public bool deleteBranchImport(string id) { db = new CMART1Entities1(); try { BranchImport branchImport = db.BranchImports.Single(st => st.IDBranchImport.Equals(id)); List <BranchImport_List> branchlist = branchImport.BranchImport_List.ToList(); foreach (BranchImport_List a in branchlist) { db.BranchImport_List.Remove(a); } db.BranchImports.Remove(branchImport); db.SaveChanges(); return(true); } catch (Exception) { return(false); } }
public bool deleteHeadImport(string id) { db = new CMART1Entities1(); try { HeadImport headimport = db.HeadImports.Single(st => st.IDHeadImport.Equals(id)); List <HeadImport_List> headlist = headimport.HeadImport_List.ToList(); foreach (HeadImport_List a in headlist) { db.HeadImport_List.Remove(a); } db.HeadImports.Remove(headimport); db.SaveChanges(); return(true); } catch (Exception) { return(false); } }
public bool editPriceHT(int id, DateTime date, string price1, DateTime date1) { db = new CMART1Entities1(); try { PriceHistory pricer = db.PriceHistories.Single(st => st.IDProduct.Equals(id) && st.Date.Equals(date)); db.PriceHistories.Remove(pricer); PriceHistory priceht = new PriceHistory(); float b = float.Parse(price1); priceht.IDProduct = id; priceht.Price = b; priceht.Date = date1; db.PriceHistories.Add(priceht); db.SaveChanges(); return(true); } catch (Exception) { return(false); } }
public bool editPromotion(string idPromotion, int idProduct, string price, string image, DateTime start, DateTime end, string content) { db = new CMART1Entities1(); try { Promotion promotion = db.Promotions.Single(st => st.IDPromotion.Equals(idPromotion)); promotion.IDProduct = idProduct; promotion.Price = float.Parse(price); promotion.Image = image; promotion.Contents = content; promotion.StartDate = start; promotion.EndDate = end; db.SaveChanges(); return(true); } catch (Exception) { return(false); } }
public bool addBranchList(string idBI, int[] idpro, int[] quantity, string[] status) { db = new CMART1Entities1(); try { for (int i = 0; i < quantity.Length; i++) { BranchImport_List branchList = new BranchImport_List(); branchList.IDBranchImport = idBI; branchList.IDProduct = idpro[i]; branchList.Quantity = quantity[i]; branchList.Status = status[i]; db.BranchImport_List.Add(branchList); db.SaveChanges(); } return(true); } catch (Exception) { return(false); } }
public bool deletePromotion(string id, DataGridView list) { db = new CMART1Entities1(); Promotion promotion; try { if (list.SelectedRows.Count == 1) { var row = list.SelectedRows[0]; var cell = row.Cells["IDPromotion"]; string idd = (string)cell.Value; promotion = db.Promotions.Single(st => st.IDPromotion == idd); db.Promotions.Remove(promotion); db.SaveChanges(); } return(true); } catch (Exception) { return(false); } }
public bool addHeadList(string idHI, int[] idpro, int[] quantity, double[] price, DateTime[] date, string[] status) { db = new CMART1Entities1(); try { for (int i = 0; i < idpro.Length; i++) { HeadImport_List head = new HeadImport_List(); head.IDHeadImport = idHI; head.IDProduct = idpro[i]; head.Quantity = quantity[i]; head.Status = status[i]; head.Price = price[i]; head.Expiration = date[i]; db.HeadImport_List.Add(head); db.SaveChanges(); } return(true); } catch (Exception) { return(false); } }
public bool addHeadImport(string idRe, DateTime date, float Total, string IDAcc, int[] idpro, int[] quantity, double[] price, DateTime[] dateti, string[] status) { db = new CMART1Entities1(); HeadImport Head = null; List <HeadImport> lst = db.HeadImports.ToList(); foreach (HeadImport he in lst) { Head = he; } if (Head != null) { int t = int.Parse(Head.IDHeadImport.Substring(8, 3)) + 1; string Month = date.Month.ToString(); string Date = date.Day.ToString(); if (Month.Length < 2) { Month = "0" + Month; } if (Date.Length < 2) { Date = "0" + Date; } string idnew = date.Year.ToString() + Month + Date; idnew = "HI" + idnew.Substring(2, 6); if (idnew == Head.IDHeadImport.Substring(0, 8)) { for (int i = t.ToString().Length; i < 3; i++) { idnew = idnew + "0"; } idnew = idnew + t; } else { idnew = idnew + "001"; } HeadImport head = new HeadImport(); try { head.IDrequestImport = idRe; head.IDHeadImport = idnew; head.IDAcc = IDAcc; head.HeadDate = date; head.TotalAmount = Total; db.HeadImports.Add(head); db.SaveChanges(); addHeadList(idnew, idpro, quantity, price, dateti, status); return(true); } catch (Exception) { return(false); } } else { HeadImport head = new HeadImport(); string Month = date.Month.ToString(); string Date = date.Day.ToString(); if (Month.Length < 2) { Month = "0" + Month; } if (Date.Length < 2) { Date = "0" + Date; } string idnew = date.Year.ToString() + Month + Date; idnew = "HI" + idnew.Substring(2, 6) + "001"; try { head.IDrequestImport = idRe; head.IDHeadImport = idnew; head.IDAcc = IDAcc; head.HeadDate = date; head.TotalAmount = Total; db.HeadImports.Add(head); db.SaveChanges(); addHeadList(idnew, idpro, quantity, price, dateti, status); return(true); } catch (Exception) { return(false); } } }
public bool addBill(string id, DateTime date, string totalAmount, string Recieved, string returned, int totalQuantity, string POS, string IDAcc, int[] idpro, string[] quantity, string[] unitprice) { db = new CMART1Entities1(); Bill billl = null; List <Bill> lst = db.Bills.ToList(); foreach (Bill bi in lst) { billl = bi; } if (billl != null) { int t = int.Parse(id.Substring(6, 6)) + 1; string Month = date.Month.ToString(); string Date = date.Day.ToString(); if (Month.Length < 2) { Month = "0" + Month; } if (Date.Length < 2) { Date = "0" + Date; } string idnew = date.Year.ToString() + Month + Date; idnew = idnew.Substring(2, 6); if (idnew == id.Substring(0, 6)) { for (int i = t.ToString().Length; i < 6; i++) { idnew = idnew + "0"; } idnew = idnew + t; } else { idnew = idnew + "000001"; } Bill bill = new Bill(); try { bill.IDBill = idnew; bill.BillDate = date; bill.TotalAmount = totalAmount; bill.TotalQuantity = totalQuantity; bill.Recieved = Recieved; bill.Returned = returned; bill.POS = POS; bill.IDAcc = IDAcc; db.Bills.Add(bill); db.SaveChanges(); addBillList(idnew, idpro, quantity, unitprice); return(true); } catch (Exception) { return(false); } } else { Bill bill = new Bill(); string Month = date.Month.ToString(); string Date = date.Day.ToString(); if (Month.Length < 2) { Month = "0" + Month; } if (Date.Length < 2) { Date = "0" + Date; } string idnew = date.Year.ToString() + Month + Date; idnew = idnew.Substring(2, 6); idnew = idnew + "000001"; try { bill.IDBill = idnew; bill.BillDate = date; bill.TotalAmount = totalAmount; bill.TotalQuantity = totalQuantity; bill.Recieved = Recieved; bill.Returned = returned; bill.POS = POS; bill.IDAcc = IDAcc; db.Bills.Add(bill); db.SaveChanges(); addBillList(idnew, idpro, quantity, unitprice); return(true); } catch (Exception) { return(false); } } }
public bool addPromotion(int idProduct, float price, string image, DateTime start, DateTime end, string content) { db = new CMART1Entities1(); Promotion promotion = new Promotion(); List <Promotion> lst = db.Promotions.ToList(); Promotion promotion1 = null; foreach (Promotion a in lst) { promotion1 = a; } if (promotion1 != null) { string idold = promotion1.IDPromotion; int changeID = int.Parse(idold.Substring(1, 6)) + 1; string idnew = "P"; for (int i = changeID.ToString().Length; i < 6; i++) { idnew = idnew + "0"; } idnew = idnew + changeID.ToString(); try { promotion.IDPromotion = idnew; promotion.IDProduct = idProduct; promotion.Price = price; promotion.Image = image; promotion.Contents = content; promotion.StartDate = start; promotion.EndDate = end; db.Promotions.Add(promotion); db.SaveChanges(); return(true); } catch (Exception) { return(false); } } else { try { promotion.IDPromotion = "P000001"; promotion.IDProduct = idProduct; promotion.Price = price; promotion.Image = image; promotion.Contents = content; promotion.StartDate = start; promotion.EndDate = end; db.Promotions.Add(promotion); db.SaveChanges(); return(true); } catch (Exception) { return(false); } } }
public bool addBranchImport(string idHI, DateTime date, int branch, string IDAcc, int[] idpro, int[] quantity, string[] status) { db = new CMART1Entities1(); BranchImport bran = null; List <BranchImport> lst = db.BranchImports.ToList(); foreach (BranchImport b in lst) { bran = b; } if (bran != null) { int t = int.Parse(bran.IDBranchImport.Substring(8, 3)) + 1; string Month = date.Month.ToString(); string Date = date.Day.ToString(); if (Month.Length < 2) { Month = "0" + Month; } if (Date.Length < 2) { Date = "0" + Date; } string idnew = date.Year.ToString() + Month + Date; idnew = "BI" + idnew.Substring(2, 6); if (idnew == bran.IDBranchImport.Substring(0, 8)) { for (int i = t.ToString().Length; i < 3; i++) { idnew = idnew + "0"; } idnew = idnew + t; } else { idnew = idnew + "001"; } BranchImport branchImport = new BranchImport(); try { branchImport.IDBranchImport = idnew; branchImport.IDHeadImport = idHI; branchImport.BranchDate = date; branchImport.Branch = branch; branchImport.IDAcc = IDAcc; db.BranchImports.Add(branchImport); db.SaveChanges(); addBranchList(idnew, idpro, quantity, status); return(true); } catch (Exception) { return(false); } } else { BranchImport branchImport = new BranchImport(); string Month = date.Month.ToString(); string Date = date.Day.ToString(); if (Month.Length < 2) { Month = "0" + Month; } if (Date.Length < 2) { Date = "0" + Date; } string idnew = date.Year.ToString() + Month + Date; idnew = "BI" + idnew.Substring(2, 6) + "001"; try { branchImport.IDBranchImport = idnew; branchImport.IDHeadImport = idHI; branchImport.BranchDate = date; branchImport.Branch = branch; branchImport.IDAcc = IDAcc; db.BranchImports.Add(branchImport); db.SaveChanges(); addBranchList(idnew, idpro, quantity, status); return(true); } catch (Exception) { return(false); } } }