public bool addInvoice(INVOICE invoice, List <INVOICE_ITEM> itemList) { try { UShopDB.INVOICEs.InsertOnSubmit(invoice); UShopDB.SubmitChanges(); invoice.INVOICE_CODE = getCODE("INV", invoice.INVOICE_ID); if (itemList != null && itemList.Count > 0) { UShopDB.INVOICE_ITEMs.InsertAllOnSubmit(itemList); UShopDB.SubmitChanges(); double totalDiscount = 0; foreach (var item in itemList) { item.INVOICE_ITEM_CODE = getCODE("INVI", item.INVOICE_ITEM_ID); item.INVOICE_ID = invoice.INVOICE_ID; totalDiscount += (double)item.DISCOUNT; //updateProductSize((int)item.PRODUCT_ID, item.SIZE,0 -(int)item.QUANTITY); } invoice.TOTAL_SALE = totalDiscount; } UShopDB.SubmitChanges(); return(true); } catch (Exception e) { Console.WriteLine(e.Message); return(false); } }
public void deleteProductSize(string id, string size) { PRODUCT_SIZE obj = UShopDB.PRODUCT_SIZEs.Where(o => o.PRODUCT_ID == Convert.ToInt32(id) && o.SIZE.Equals(size)).SingleOrDefault(); UShopDB.PRODUCT_SIZEs.DeleteOnSubmit(obj); UShopDB.SubmitChanges(); }
public void deleteSupplier(string id) { SUPPLIER obj = UShopDB.SUPPLIERs.Where(o => o.SUPPLIER_ID == Convert.ToInt32(id)).SingleOrDefault(); obj.RECORD_STATUS = "D"; UShopDB.SubmitChanges(); }
public bool updateAppointment(APPOINTMENT updateApp) { bool ret = false; try { var result = UShopDB.APPOINTMENTs.Where(o => o.APP_ID == updateApp.APP_ID); APPOINTMENT app = result.SingleOrDefault(); app.APP_DATE = updateApp.APP_DATE; app.CREATED_DATE = updateApp.CREATED_DATE; app.CUS_ID = updateApp.CUS_ID; app.DESCRIPTION = updateApp.DESCRIPTION; app.NOTE = updateApp.NOTE; app.PREPARER_ID = updateApp.PREPARER_ID; app.RECORD_STATUS = updateApp.RECORD_STATUS; UShopDB.SubmitChanges(); ret = true; } catch (Exception e) { Console.WriteLine(e.Message); } return(ret); }
public void updateProductSize(PRODUCT_SIZE product) { PRODUCT_SIZE obj = UShopDB.PRODUCT_SIZEs.Where(o => o.PRODUCT_ID == product.PRODUCT_ID && o.SIZE.Equals(product.SIZE)).SingleOrDefault(); obj.IN_STOCK_QUANTITY = product.IN_STOCK_QUANTITY; obj.PRODUCT_ID = product.PRODUCT_ID; obj.SIZE = product.SIZE; UShopDB.SubmitChanges(); }
public void add(RECEIPT_NOTE obj, DataTable dtItems) { UShopDB.RECEIPT_NOTEs.InsertOnSubmit(obj); UShopDB.SubmitChanges(); obj.RN_CODE = getCODE("RCN", obj.RN_ID); List <RECEIPT_NOTE_ITEM> lst = new List <RECEIPT_NOTE_ITEM>(); foreach (DataRow r in dtItems.Rows) { RECEIPT_NOTE_ITEM item = new RECEIPT_NOTE_ITEM(); item.RN_ID = obj.RN_ID; item.PRODUCT_ID = Int32.Parse(r[0].ToString().Substring(r[0].ToString().IndexOf('0'), r[0].ToString().Length - r[0].ToString().IndexOf('0'))); item.QUANTITY_STOCK_S = Int32.Parse(r[2].ToString()); item.QUANTITY_VOUCHER_S = Int32.Parse(r[3].ToString()); item.SIZE = r[4].ToString(); item.PRICE = Int32.Parse(r[5].ToString()); item.AMOUNT = Int32.Parse(r[6].ToString()); item.RECORD_STATUS = "A"; lst.Add(item); // foreach (RECEIPT_NOTE_ITEM i in lst) { if (UShopDB.PRODUCT_SIZEs.Where(o => o.PRODUCT_ID.Equals(i.PRODUCT_ID) && o.SIZE.Equals(i.SIZE)).Count() > 0) { PRODUCT_SIZE p = UShopDB.PRODUCT_SIZEs.Where(o => o.PRODUCT_ID.Equals(i.PRODUCT_ID) && o.SIZE.Equals(i.SIZE)).First(); p.IN_STOCK_QUANTITY += item.QUANTITY_STOCK_S; } else { PRODUCT_SIZE p = new PRODUCT_SIZE(); p.PRODUCT_ID = i.PRODUCT_ID ?? 1; p.SIZE = i.SIZE; p.IN_STOCK_QUANTITY = item.QUANTITY_STOCK_S; UShopDB.PRODUCT_SIZEs.InsertOnSubmit(p); } } } UShopDB.RECEIPT_NOTE_ITEMs.InsertAllOnSubmit(lst); UShopDB.SubmitChanges(); foreach (RECEIPT_NOTE_ITEM i in UShopDB.RECEIPT_NOTE_ITEMs.Where(o => o.RN_ID == obj.RN_ID)) { i.RN_ITEM_CODE = getCODE("RIT", i.RN_ITEM_ID); } UShopDB.SubmitChanges(); }
public void add(RECEIPT_NOTE obj, DataTable dtItems) { UShopDB.RECEIPT_NOTEs.InsertOnSubmit(obj); UShopDB.SubmitChanges(); obj.RN_CODE = getCODE("RCN", obj.RN_ID); List <RECEIPT_NOTE_ITEM> lst = new List <RECEIPT_NOTE_ITEM>(); foreach (DataRow r in dtItems.Rows) { RECEIPT_NOTE_ITEM item = new RECEIPT_NOTE_ITEM(); item.RN_ID = obj.RN_ID; item.PRODUCT_ID = Int32.Parse(r[0].ToString().Substring(r[0].ToString().IndexOf('0'), 5)); item.QUANTITY_STOCK_S = Int32.Parse(r[2].ToString()); item.QUANTITY_VOUCHER_S = Int32.Parse(r[3].ToString()); item.QUANTITY_STOCK_M = Int32.Parse(r[4].ToString()); item.QUANTITY_VOUCHER_M = Int32.Parse(r[5].ToString()); item.QUANTITY_STOCK_L = Int32.Parse(r[6].ToString()); item.QUANTITY_VOUCHER_L = Int32.Parse(r[7].ToString()); item.QUANTITY_STOCK_XL = Int32.Parse(r[8].ToString()); item.QUANTITY_VOUCHER_XL = Int32.Parse(r[9].ToString()); item.QUANTITY_STOCK_XXL = Int32.Parse(r[10].ToString()); item.QUANTITY_VOUCHER_XXL = Int32.Parse(r[11].ToString()); item.TOTAL_STOCK = Int32.Parse(r[12].ToString()); item.TOTAL_VOUCHER = Int32.Parse(r[13].ToString()); item.PRICE = Int32.Parse(r[14].ToString()); item.AMOUNT = Int32.Parse(r[15].ToString()); item.RECORD_STATUS = "A"; lst.Add(item); foreach (PRODUCT p in UShopDB.PRODUCTs.Where(o => o.PRODUCT_ID == item.PRODUCT_ID)) { p.SIZE_S += item.QUANTITY_STOCK_S; p.SIZE_M += item.QUANTITY_STOCK_M; p.SIZE_L += item.QUANTITY_STOCK_L; p.SIZE_XL += item.QUANTITY_STOCK_XL; p.SIZE_XXL += item.QUANTITY_STOCK_XXL; } } UShopDB.RECEIPT_NOTE_ITEMs.InsertAllOnSubmit(lst); UShopDB.SubmitChanges(); foreach (RECEIPT_NOTE_ITEM i in UShopDB.RECEIPT_NOTE_ITEMs.Where(o => o.RN_ID == obj.RN_ID)) { i.RN_ITEM_CODE = getCODE("RIT", i.RN_ITEM_ID); } UShopDB.SubmitChanges(); }
public void updateSupplier(SUPPLIER supplier) { SUPPLIER obj = UShopDB.SUPPLIERs.Where(o => o.SUPPLIER_ID == Convert.ToInt32(supplier.SUPPLIER_ID)).SingleOrDefault(); obj.SUPPLIER_NAME = supplier.SUPPLIER_NAME; obj.TAX_CODE = supplier.TAX_CODE; obj.PHONE = supplier.PHONE; obj.ADDRESS = supplier.ADDRESS; UShopDB.SubmitChanges(); }
public void updateUShop(SUPPLIER obj) { getUShop(); SUPPLIER ushop = UShopDB.SUPPLIERs.Where(o => o.RECORD_STATUS.Equals("U")).First(); ushop.TAX_CODE = obj.TAX_CODE; ushop.ADDRESS = obj.ADDRESS; ushop.SUPPLIER_NAME = obj.SUPPLIER_NAME; ushop.PHONE = obj.PHONE; UShopDB.SubmitChanges(); }
public void addAccount(ACCOUNT obj) { try { UShopDB.ACCOUNTs.InsertOnSubmit(obj); UShopDB.SubmitChanges(); } catch (Exception ex) { throw new Exception(); } }
public void addReceiptNote(RECEIPT_NOTE obj) { try { UShopDB.RECEIPT_NOTEs.InsertOnSubmit(obj); UShopDB.SubmitChanges(); } catch (Exception ex) { throw new Exception(); } }
public void deleteProduct(string id) { PRODUCT obj = UShopDB.PRODUCTs.Where(o => o.PRODUCT_ID == Convert.ToInt32(id)).SingleOrDefault(); obj.RECORD_STATUS = "D"; foreach (PRODUCT_SIZE z in UShopDB.PRODUCT_SIZEs.Where(o => o.PRODUCT_ID == Convert.ToInt32(id))) { UShopDB.PRODUCT_SIZEs.DeleteOnSubmit(z); } UShopDB.SubmitChanges(); }
public void addSupplier(SUPPLIER obj) { try { UShopDB.SUPPLIERs.InsertOnSubmit(obj); UShopDB.SubmitChanges(); obj.SUPPLIER_CODE = getCODE("SUP", obj.SUPPLIER_ID); UShopDB.SubmitChanges(); } catch (Exception ex) { throw new Exception(); } }
public void addProduct(PRODUCT obj) { try { UShopDB.PRODUCTs.InsertOnSubmit(obj); UShopDB.SubmitChanges(); obj.PRODUCT_CODE = getCODE("PRO", obj.PRODUCT_ID); UShopDB.SubmitChanges(); } catch (Exception ex) { throw new Exception(); } }
bool IAccount.deleteAccount(string code) { bool ret = false; try { var result = UShopDB.ACCOUNTs.Where(o => o.ACC_CODE.Equals(code)); ACCOUNT acc = result.SingleOrDefault(); acc.RECORD_STATUS = ((char)RECORD_STATUS.INACTIVE) + ""; UShopDB.SubmitChanges(); ret = true; } catch (Exception e) { Console.WriteLine(e.Message); } return(ret); }
public bool deleteAppointment(string code) { bool ret = false; try { var result = UShopDB.APPOINTMENTs.Where(o => o.APP_CODE.Equals(code)); APPOINTMENT app = result.SingleOrDefault(); app.RECORD_STATUS = ((char)RECORD_STATUS.INACTIVE) + ""; UShopDB.SubmitChanges(); ret = true; } catch (Exception e) { Console.WriteLine(e.Message); } return(ret); }
public bool addAppointment(APPOINTMENT app) { try { UShopDB.APPOINTMENTs.InsertOnSubmit(app); UShopDB.SubmitChanges(); app.APP_CODE = getCODE("APP", app.APP_ID); UShopDB.SubmitChanges(); return(true); } catch (Exception e) { Console.WriteLine(e.Message); return(false); } }
private bool updateProductSize(int productId, string size, int deltaQuantity) { PRODUCT_SIZE prosize = UShopDB.PRODUCT_SIZEs.Where(o => o.PRODUCT_ID == productId && o.SIZE.Equals(size)).SingleOrDefault(); if (prosize != null) { if (prosize.IN_STOCK_QUANTITY == 0) { throw new Exception("instock quantity is zero but still has an invoice item "); } prosize.IN_STOCK_QUANTITY = prosize.IN_STOCK_QUANTITY + deltaQuantity; UShopDB.SubmitChanges(); return(true); } return(false); }
public bool addAccount(ACCOUNT obj) { try { UShopDB.ACCOUNTs.InsertOnSubmit(obj); UShopDB.SubmitChanges(); return(true); } catch (Exception ex) { //wtf ??? //throw new Exception(); Console.WriteLine(ex.Message); } return(false); }
public SUPPLIER getUShop() { int count = UShopDB.SUPPLIERs.Where(o => o.RECORD_STATUS.Equals("U")).Count(); if (count == 0) { SUPPLIER ushop = new SUPPLIER(); ushop.TAX_CODE = "0000"; ushop.ADDRESS = "Quận 3, TP HCM"; ushop.SUPPLIER_NAME = "UShop"; ushop.RECORD_STATUS = "U"; ushop.PHONE = "0975862516"; UShopDB.SUPPLIERs.InsertOnSubmit(ushop); UShopDB.SubmitChanges(); ushop.SUPPLIER_CODE = getCODE("SUP", ushop.SUPPLIER_ID); UShopDB.SubmitChanges(); } return(UShopDB.SUPPLIERs.Where(o => o.RECORD_STATUS.Equals("U")).First()); }