Exemple #1
0
        //public DataTable ViewByDistributer_ID(int DistributerID)
        //{
        //    objCompanyDAL = new Company_DAL(objCompanyProperty);
        //    return objCompanyDAL.SelectByDistributerID(DistributerID);
        //}

        public DataTable ViewAll(string xmlpath)
        {
            // load your xml file (this one is named people and it is in my App_Data folder)
            XElement x = XElement.Load(xmlpath);//get your file

            // declare a new DataTable and pass your XElement to it


            objCompanyDAL = new Company_DAL(objCompanyProperty);
            return(objCompanyDAL.XElementToDataTable(x));
        }
Exemple #2
0
        public void Fill()
        {
            DataTable dataTable = Company_DAL.GetDataTable();
            Company   company   = new Company();
            DataRow   dataRow;

            for (int i = 0; i < dataTable.Rows.Count; i++)
            {
                dataRow = dataTable.Rows[i];

                company = new Company(dataRow);

                this.Add(company);
            }
        }
Exemple #3
0
 public bool Update()
 {
     objCompanyDAL = new Company_DAL(objCompanyProperty);
     return(objCompanyDAL.Update());
 }
Exemple #4
0
 public bool Insert()
 {
     objCompanyDAL = new Company_DAL(objCompanyProperty);
     return(objCompanyDAL.Insert());
 }
Exemple #5
0
 public DataTable GetCompanyById()
 {
     objCompanyDAL = new Company_DAL(objCompanyProperty);
     return(objCompanyDAL.SelectById());
 }
Exemple #6
0
 public DataTable ViewAll()
 {
     objCompanyDAL = new Company_DAL(objCompanyProperty);
     return(objCompanyDAL.SelectAll());
 }