public List <WindowsFormData> GetAll()
        {
            List <WindowsFormData> lvar   = new List <WindowsFormData>();
            WindowsFormData        data   = null;
            DbDataReader           reader = null;

            try
            {
                reader = ExecuteReader(CommandType.StoredProcedure, "WindowsFormGetAll");
                while (reader.Read())
                {
                    data = (WindowsFormData)GetFromReader(reader);
                    lvar.Add(data);
                }
                return(lvar);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                CloseReader(reader);
            }
        }
        //public int Add(WindowsFormData WindowsFormDataData)
        //{
        //    try
        //    {
        //        DbParameter[] Parameters = CreateAddParameters(WindowsFormDataData);
        //        ExecuteNonQuery(CommandType.StoredProcedure, "CityAdd", Parameters);
        //        WindowsFormDataData.ID = (int)Parameters[0].Value;
        //        return WindowsFormDataData.ID;
        //    }
        //    catch (DbException ex)
        //    {
        //        throw ex;

        //    }
        //}

        //public void update(WindowsFormData WindowsFormDataData)
        //{
        //    try
        //    {
        //        this.ExecuteNonQuery(CommandType.StoredProcedure, "CityUpdate", CreateUpdateParameters(WindowsFormDataData));
        //    }
        //    catch (DbException ex)
        //    {
        //        throw ex;
        //    }
        //}

        //public void Delete(WindowsFormData WindowsFormDataData)
        //{
        //    List<DbParameter> Parameters = new List<DbParameter>();
        //    Parameters.Add(CreateParameter("@ID", WindowsFormDataData.ID));
        //    this.ExecuteNonQuery(CommandType.StoredProcedure, "CityDELETE", Parameters.ToArray());

        //}

        protected override void CreateParameters(BasicData data, List <DbParameter> parameters)
        {
            WindowsFormData WindowsFormData = (WindowsFormData)data;

            parameters.Add(CreateParameter("@ID", WindowsFormData.ID));
            parameters.Add(CreateParameter("@TableName", WindowsFormData.TableName));
            parameters.Add(CreateParameter("@DalClass", WindowsFormData.DalClass));
            parameters.Add(CreateParameter("@DataClass", WindowsFormData.DataClass));
            parameters.Add(CreateParameter("@LogicClass", WindowsFormData.LogicClass));
            parameters.Add(CreateParameter("@IDField", WindowsFormData.IDField));
            parameters.Add(CreateParameter("@CodeField", WindowsFormData.CodeField));
            parameters.Add(CreateParameter("@ArabicField", WindowsFormData.ArabicField));
            parameters.Add(CreateParameter("@EnglishField", WindowsFormData.EnglishField));
        }
        public override BasicData GetFromReader(DbDataReader reader)
        {
            WindowsFormData WindowsFormData = new WindowsFormData();

            WindowsFormData.ID           = this.ReadInt32(reader, "ID");
            WindowsFormData.TableName    = this.ReadString(reader, "TableName");
            WindowsFormData.DalClass     = this.ReadString(reader, "DalClass");
            WindowsFormData.DataClass    = this.ReadString(reader, "DataClass");
            WindowsFormData.LogicClass   = this.ReadString(reader, "LogicClass");
            WindowsFormData.IDField      = this.ReadString(reader, "IDField");
            WindowsFormData.CodeField    = this.ReadString(reader, "CodeField");
            WindowsFormData.ArabicField  = this.ReadString(reader, "ArabicField");
            WindowsFormData.EnglishField = this.ReadString(reader, "EnglishField");
            return(WindowsFormData);
        }
        public WindowsFormData GetByID(string TableName)
        {
            WindowsFormData data    = null;
            SqlConnection   sqlconn = new SqlConnection(ConfigurationManager.ConnectionStrings["MyCon"].ConnectionString);
            string          qury    = string.Format("SELECT * FROM WindowsForm WHERE TableName = '{0}'", TableName);
            SqlCommand      command = new SqlCommand(qury, sqlconn);

            sqlconn.Open();

            SqlDataReader reader = command.ExecuteReader();

            //DataTable dt = reader.GetSchemaTable();

            //DbDataReader reader = ExecuteReader(CommandType.Text, string.Format("SELECT * FROM WindowsForm WHERE ID = {0}", id.ToString()));

            if (reader.Read())
            {
                data = (WindowsFormData)GetFromReader(reader);
            }

            return(data);
        }