public List<Supplier> GetBookSupplierList() { List<Supplier> SupplierList = null; using (DataTable table = DataProvider.ExecuteSelectCommand("sp_ViewAllBookSuppliers", CommandType.StoredProcedure)) { if (table.Rows.Count > 0) { SupplierList = new List<Supplier>(); foreach (DataRow row in table.Rows) { Supplier supplier = new Supplier(); supplier.SupplierID = Convert.ToInt32(row["SupplierID"]); supplier.Name = row["Name"].ToString(); supplier.LastName = row["LastName"].ToString(); supplier.Fax = row["Fax"].ToString(); supplier.ContactPerson = row["ContactPerson"].ToString(); supplier.ContactPersonNumber = row["ContactPersonNumber"].ToString(); SupplierList.Add(supplier); } } } return SupplierList; }
public Supplier GetSupplier(string User_Id) { Supplier supplier = null; SqlParameter[] Params = { new SqlParameter("@User_Id", User_Id) }; using (DataTable table = DataProvider.ExecuteParamatizedSelectCommand("sp_ViewSpecificUserSupplier", CommandType.StoredProcedure, Params)) { if (table.Rows.Count == 1) { DataRow row = table.Rows[0]; supplier = new Supplier(); supplier.SupplierID = Convert.ToInt32(row["SupplierID"]); supplier.Name = row["Name"].ToString(); supplier.LastName = row["LastName"].ToString(); supplier.Fax = row["Fax"].ToString(); supplier.ContactPerson = row["ContactPerson"].ToString(); supplier.ContactPersonNumber = row["ContactPersonNumber"].ToString(); } } return supplier; }
public bool UpdateSupplier(Supplier supplier) { SupplierHandler myHandler = new SupplierHandler(); return myHandler.UpdateSupplier(supplier); }
public bool AddSupplier(Supplier supplier) { SupplierHandler myHandler = new SupplierHandler(); return myHandler.InsertSupplier(supplier); }
public bool UpdateSupplier(Supplier supplier) { SqlParameter[] Params = new SqlParameter[] { new SqlParameter ("@SupplierID", supplier.SupplierID), new SqlParameter("@Name", supplier.Name ), new SqlParameter("@Telephone", supplier.LastName), new SqlParameter("@Fax", supplier.Fax), new SqlParameter("@ContactPerson", supplier.ContactPerson), new SqlParameter("@ContactPersonTel", supplier.ContactPersonNumber), }; return DataProvider.ExecuteNonQuery("sp_UpdateSupplier", CommandType.StoredProcedure, Params); }
public Supplier SearchSupplier(string Query) { Supplier supplier = null; SqlParameter[] Params = new SqlParameter[] { new SqlParameter("@Name", Query) ///SEARCH }; using (DataTable table = DataProvider.ExecuteParamatizedSelectCommand("sp_SearchProduct", CommandType.StoredProcedure, Params)) { if (table.Rows.Count == 1) { DataRow row = table.Rows[0]; supplier = new Supplier(); supplier.SupplierID = Convert.ToInt32(row["SupplierID"]); supplier.Name = row["Name"].ToString(); supplier.LastName = row["LastName"].ToString(); supplier.Fax = row["Fax"].ToString(); supplier.ContactPerson = row["ContactPerson"].ToString(); supplier.ContactPersonNumber = row["ContactPersonNumber"].ToString(); } } return supplier; }
public bool IsBookSupplier(int SupplierID) { Supplier supplier = null; SqlParameter[] Params = new SqlParameter[] { new SqlParameter("@SupplierID", SupplierID) ///SEARCH }; using (DataTable table = DataProvider.ExecuteParamatizedSelectCommand("sp_CheckSupplierType", CommandType.StoredProcedure, Params)) { if (table.Rows.Count == 1) { DataRow row = table.Rows[0]; supplier = new Supplier(); supplier.SupplierID = Convert.ToInt32(row["SupplierID"]); } } return supplier.IsBookSupplier; }