public void FillRentAvailable(DateTime From, DateTime To) { DataTable dataTable = Product_DAL.GetDataTable(); DataRow dataRow; Product product; OrderRentArr orderRentArr = new OrderRentArr(); orderRentArr.Fill(); // orderRentArr = orderRentArr.FilterNoReturned(); orderRentArr = orderRentArr.Filter(From, To); for (int i = 0; i < dataTable.Rows.Count; i++) { dataRow = dataTable.Rows[i]; product = new Product(dataRow); if ( (product.Status == "Rent") && (!orderRentArr.DoesExist(product)) ) { this.Add(product); } } }
public void FillBuyAvailable() { DataTable dataTable = Product_DAL.GetDataTable(); //להעביר את הערכים מהטבלה לתוך אוסף הלקוחות //להעביר כל שורה בטבלה ללקוח DataRow dataRow; Product product; for (int i = 0; i < dataTable.Rows.Count; i++) { dataRow = dataTable.Rows[i]; product = new Product(dataRow); if ( (product.Status == "Buy") && (product.Doesavailable == "") ) { this.Add(product); } } }
public Product_BAL() { Product = new Product_DAL(); product_Image_Bal = new ProductImage_BAL(); ProductImage = new ProductImage_DAL(); }
public int?GetId(Product_DAL product) { var temp = context.Products.FirstOrDefault(p => (p.Name == product.Name)); if (temp == null) { return(null); } else { return(temp.Id); } }
public bool DeleteRecord(int iId) { bool objReturn = false; try { using (Product_DAL objDAL = new Product_DAL()) { objReturn = objDAL.DeleteRecord(iId); } } catch (Exception ex) { log.Error("DeleteRecord Error: ", ex); } return(objReturn); }
public ProductPage GetRecordPage(int iPageNo, int iPageSize) { ProductPage objReturn = new ProductPage(); try { using (Product_DAL objDAL = new Product_DAL()) { objReturn = objDAL.GetRecordPage(iPageNo, iPageSize); } } catch (Exception ex) { log.Error("GetRecordPage Error: ", ex); } return(objReturn); }
public Product GetRecordById(Guid iId) { Product objReturn = null; try { using (Product_DAL objDAL = new Product_DAL()) { objReturn = objDAL.GetRecordById(iId); } } catch (Exception ex) { log.Error("GetRecordById Error: ", ex); } return(objReturn); }
public Guid InsertUpdateRecord(Product objProduct) { Guid objReturn = new Guid(); try { using (Product_DAL objDAL = new Product_DAL()) { objReturn = objDAL.InsertUpdateRecord(objProduct); } } catch (Exception ex) { log.Error("InsertUpdateRecord Error: ", ex); } return(objReturn); }
public List <Product> GetAllRecord() { List <Product> objReturn = null; try { using (Product_DAL objDAL = new Product_DAL()) { objReturn = objDAL.GetAllRecord(); } } catch (Exception ex) { log.Error("GetAllRecord Error: ", ex); } return(objReturn); }
public Product Validate(string email, string password) { Product objReturn = null; try { using (Product_DAL objDAL = new Product_DAL()) { objReturn = objDAL.Validate(email, password); } } catch (Exception ex) { log.Error("Validate Error: ", ex); } return(objReturn); }
public void Fill() { //להביא מה-DAL טבלה מלאה בכל הלקוחות DataTable dataTable = Product_DAL.GetDataTable(); //להעביר את הערכים מהטבלה לתוך אוסף הלקוחות //להעביר כל שורה בטבלה ללקוח DataRow dataRow; Product product; for (int i = 0; i < dataTable.Rows.Count; i++) { dataRow = dataTable.Rows[i]; product = new Product(dataRow); this.Add(product); } }
public void FillRentAvailable() { DataTable dataTable = Product_DAL.GetDataTable(); //להעביר את הערכים מהטבלה לתוך אוסף הלקוחות //להעביר כל שורה בטבלה ללקוח DataRow dataRow; Product product; OrderRent orderRent; OrderRentArr orderRentArr = new OrderRentArr(); orderRentArr.Fill(); // orderRentArr = orderRentArr.FilterNoReturned(); for (int i = 0; i < dataTable.Rows.Count; i++) { dataRow = dataTable.Rows[i]; product = new Product(dataRow); for (int j = 0; j < orderRentArr.Count; j++) { orderRent = orderRentArr[j] as OrderRent; if ( (product.Status == "Rent") && (orderRent.Product.Id != product.Id) && (orderRent.Product.Doesavailable == "InRent") ) { this.Add(product); } } } }
public string GenerateProductCode(LP_GenerateTransNumber_Property objtransno) { string TransactionNumber = ""; objProduct_DAL = new Product_DAL(); DataTable dt = objProduct_DAL.GenerateProductCode(objtransno); if (dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { TransactionNumber = dr["TransNumber"].ToString(); TransactionNumber = "P-00" + TransactionNumber + "-" + objtransno.userid; } return(TransactionNumber); } else { TransactionNumber = "P-001-" + objtransno.userid; return(TransactionNumber); } //return _objMRNDAL.GenerateMRNNo(objtransno); }
public static bool SuaSPCH(Product_DTO sanpham) { return(Product_DAL.SuaSanPhamCH(sanpham)); }
public static List <Product_DTO> LoadProduct() { return(Product_DAL.LoadProduct()); }
public Product_BUS() { temp = new Product_DAL(); }
public FrontEndBAL() { Product_DAL = new Product_DAL(); frontEnd_DAL = new FrontEnd_DAL(); }
public DataTable ddlSubCategory() { objProduct_DAL = new Product_DAL(objProductProperty); return(objProduct_DAL.ddlSubCategory()); }
public DataTable GetById(int?id) { objProduct_DAL = new Product_DAL(objProductProperty); return(objProduct_DAL.SelectById(id)); }
public void Update(Product_DAL item) { var product = context.Products.FirstOrDefault(p => (p.Id == item.Id)); product.Name = item.Name; }
public bool Insert() { objProduct_DAL = new Product_DAL(objProductProperty); return(objProduct_DAL.Insert()); }
public void Add(Product_DAL product) { context.Products.Add(ToEntity(product)); }
public static bool XoaSPCH(Product_DTO sanpham) { return(Product_DAL.XoaSPCH(sanpham)); }
public DataTable ddlUnit() { objProduct_DAL = new Product_DAL(objProductProperty); return(objProduct_DAL.ddlUnit()); }
public bool Delete(int?id) { objProduct_DAL = new Product_DAL(objProductProperty); return(objProduct_DAL.Delete(id)); }
public DataTable ViewAll() { objProduct_DAL = new Product_DAL(objProductProperty); return(objProduct_DAL.SelectAll()); }
public bool Update() { objProduct_DAL = new Product_DAL(objProductProperty); return(objProduct_DAL.Update()); }