//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)); }
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); } }
public bool Update() { objCompanyDAL = new Company_DAL(objCompanyProperty); return(objCompanyDAL.Update()); }
public bool Insert() { objCompanyDAL = new Company_DAL(objCompanyProperty); return(objCompanyDAL.Insert()); }
public DataTable GetCompanyById() { objCompanyDAL = new Company_DAL(objCompanyProperty); return(objCompanyDAL.SelectById()); }
public DataTable ViewAll() { objCompanyDAL = new Company_DAL(objCompanyProperty); return(objCompanyDAL.SelectAll()); }