JohnKenedy Data Access Layer Library

using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;

namespace JohnKenedy.DataAccessModule
{
    [Serializable]
    public class ModuleExtendDefinition
    {
        #region Properties
        protected int _Index;
        public int Index
        {
            get
            {
                return _Index;
            }
            set
            {
                _Index = value;
            }
        }

        protected string _ModuleName;
        public virtual string ModuleName
        {
            get
            {
                return _ModuleName;
            }
            set
            {
                _ModuleName = value;
            }
        }

        protected IDictionary<string, string> _RolenameAndTable = new Dictionary<string, string>();
        public virtual IDictionary<string, string> RolenameAndTable
        {
            get
            {
                return _RolenameAndTable;
            }
        }
        #endregion

        public ModuleExtendDefinition()
        {
        }

        public string GetTableRole(string _tableName)
        {
            if (_RolenameAndTable == null || _RolenameAndTable.Count <= 0) return "";
            if (_RolenameAndTable.ContainsKey(_tableName)) return "";
            return _RolenameAndTable[_tableName];
        }

        public virtual string GetModuleExtension(string _tableName)
        {
            return "";
        }

        public virtual string GetModuleCollectionExtension(string _tableName)
        {
            return "";
        }

        public DataTable GetRoleTable()
        {
            DataTable _data = new DataTable();
            _data.Columns.Add("Rolename", typeof(string));
            _data.Columns.Add("Tablename", typeof(string));
            
            foreach (KeyValuePair<string, string> _pair in _RolenameAndTable)
            {
                DataRow _row = _data.NewRow();
                _row["Rolename"] = _pair.Key;
                _row["Tablename"] = _pair.Value;
                _data.Rows.Add(_row);
            }
            _data.AcceptChanges();
            return _data;
        }

        public void SetRoleTable(DataTable _datatable)
        {
            _RolenameAndTable.Clear();
            foreach (DataRow _row in _datatable.Rows)
            {
                string _key = _row["Rolename"].ToString();
                string _value = _row["Tablename"].ToString();
                _RolenameAndTable.Add(_key, _value);
            }
        }
    }
}