public bool InsertProduct(ProductEntity product, List <string> dataPhoto) { string sql = "sp_product_INSERT"; //string sql_productsup = "sp_PRODUCTSUPPLIER_INSERT"; string retID = ""; int i = 1; object[] objProduct = { "@Description", product.Description, "@Waranty", product.Waranty, "@ClrID", product.ClrID, "@TypeProductID", product.TypeProductID, "@BrandID", product.BrandID, "@ReorderPoint", product.ReorderPoint, "@Price", product.Price, "@SerialStatus", product.SerialStatus }; using (TransactionScope ts = new TransactionScope()) { try { retID = Db.InsertReturnID(sql, objProduct); //object[] ojbProSup = { "@PrdID", retID, "@SupID", product.SupID }; //try { Db.Insert(sql_productsup, ojbProSup); } //catch { return false; } string sql_path = "sp_photo_INSERT"; foreach (var ls in dataPhoto) { object[] objPh = { "@PhotoID", i++, "@PrdID", retID, "@Photo", ls }; try { Db.Insert(sql_path, objPh); } catch { return(false); } } ts.Complete(); return(true); } catch { return(false); } } }
public bool InsertPROMOTION(PROMOTION PROMOTION) { string sql = @"sp_promotion_INSERT"; string sql_dta = @"sp_promotionproduct_INSERT"; object[] obj = { "@ProMStartDate", PROMOTION.ProMStartDate, "@ProMEndDate", PROMOTION.ProMEndDate, "@Discount", PROMOTION.Discount }; using (TransactionScope ts = new TransactionScope()) { string retID = Db.InsertReturnID(sql, obj); if (retID != null) { foreach (var ls in PROMOTION.PRODUCT) { object[] objs = { "@PrdID", ls.PrdID, "@ProMID", retID }; try { Db.Insert(sql_dta, objs); } catch { return(false); } } ts.Complete(); return(true); } else { return(false); } } }
public bool InsertOffer(OfferModel[] off, OfferDetailModel[] list) { string sql = @"[sp_offer_INSERT]"; string sql_Detail = @"[sp_offerDetail_INSERT]"; int i = 0; string retID = ""; using (TransactionScope ts = new TransactionScope()) { foreach (var ls in list) { if (ls.OfdNo == 1) { //สร้างหัว object[] h_obj = { "@EmpID", off[i].EmpID, "@SupID", off[i].SupID, "@OffDate", off[i].OffDate }; retID = Db.InsertReturnID(sql, h_obj); } object[] obj = { "@OffID", retID, "@OfdNo", ls.OfdNo, "@PrdID", ls.PrdID, "@AmountPost", ls.AmountPost, "@AmountApprove", ls.AmountApprove, "@Cost", ls.Cost }; try { Db.Insert(sql_Detail, obj); i++; } catch { return(false); } } ts.Complete(); return(true); } }
public bool InsertPosandRole(PositionsEntity position, PosInRoleDetailDto[] list, string UPDATEDATA) { string sql = @"sp_position_INSERT"; string sql_role = @"sp_PosAndRole_INSERT"; string retID = ""; if (UPDATEDATA.Equals("INSERT")) { using (TransactionScope ts = new TransactionScope()) { retID = Db.InsertReturnID(sql, Take(position)); if (retID != null) { foreach (var ls in list) { object[] obj = { "@RoleID", ls.RoleID, "@PosID", retID }; try { Db.Insert(sql_role, obj); } catch { return(false); } } ts.Complete(); return(true); } else { return(false); } } } else if (UPDATEDATA.Equals("UPDATE")) { string sql_upd = @"sp_PosAndRole_UPDATE"; using (TransactionScope ts = new TransactionScope()) { DeletePosition(position.PosID); { foreach (var ls in list) { object[] obj = { "@RoleID", ls.RoleID, "@PosID", position.PosID }; Db.Insert(sql_upd, obj); } ts.Complete(); return(true); } } } return(false); }
public string InsertDeliver(DELIVER data) { string sql = "[sp_deliver_INSERT]"; string retID = ""; object[] obj = { "@EmpId", data.EmpID, "@SlpID", data.SlpID, "@DlvDate", data.DlvDate, "@DlvSerial", data.DlvSerial }; using (TransactionScope ts = new TransactionScope()) { try { retID = Db.InsertReturnID(sql, obj); ts.Complete(); return(retID); } catch { return(retID = ""); } } }
public string InsertOrder(OrderEntity ord, Models.OrderDetailModel[] list) { string sql = @"[sp_order_INSERT]"; string sql_Detail = @"[sp_orderproduct_dta_INSERT]"; // update Offer status => Approve to Purchase string sql_UPDATE = @"sp_orderANDoffer_UPDATE"; var check = ""; string retID = ""; object[] objOrd = { "@SupID", ord.SupID, "@EmpID", ord.EmpID, "@OrdDate", ord.OrdDate, "@TotalCost", ord.TotalCost }; using (TransactionScope ts = new TransactionScope()) { try { retID = Db.InsertReturnID(sql, objOrd); if (retID != null) { foreach (var ls in list) { object[] obj = { "@OrdID", retID, "@OrdNo", ls.OrdNo, "@OffID", ls.OffID, "@OfdNo", ls.OfdNo, "@OrdAmount", ls.AmountApprove }; try { Db.Insert(sql_Detail, obj); if (!check.Equals(ls.OffID)) { object[] objU = { "@OffID", ls.OffID }; check = ls.OffID; Db.Update(sql_UPDATE, objU); } } catch { return(retID); } } ts.Complete(); return(retID); } else { return(retID); } } catch { return(retID); } } }
public bool InsertMember(MEMBER member) { string sql = @"sp_member_INSERT"; string sql_phone = @"sp_memAndPhone_INSERT"; string retID = ""; using (TransactionScope ts = new TransactionScope()) { object[] obj_mem = { "@MFname", member.MFname, "@MLname", member.MLname, "@MAddress", member.MAddress, "@MSex", member.MSex, "@MEmail", member.MEmail, "@MPassword", member.MPassword }; retID = Db.InsertReturnID(sql, obj_mem); if (retID != null) { if (member.MEMBER_PHONE.Count == 0) { return(false); } else { foreach (var ls in member.MEMBER_PHONE) { object[] obj = { "@MemID", retID, "@Phone", ls.Phone }; try { Db.Insert(sql_phone, obj); } catch { return(false); } } } ts.Complete(); return(true); } else { return(false); } } }
public bool InsertSellProduct(SELLPRODUCT sellpd) { string sql = @"sp_sellproduct_INSERT"; string sql_dta = @"sp_sellproductDTA_INSERT"; string sql_reserve = @"sp_checkout_reserve"; string retID = ""; using (TransactionScope ts = new TransactionScope()) { object[] obj = { "@MemID", sellpd.MemID, "@SlpDate", sellpd.SlpDate, "@FnameRec", sellpd.FnameRec, "@LnameRec", sellpd.LnameRec, "@AdressRec", sellpd.AdressRec, "@SlpStatus", "ยังไม่ได้ชำระเงิน", "@SlpSum", sellpd.SlpSum }; retID = Db.InsertReturnID(sql, obj); if (retID != null) { int Num = 0; foreach (var ls in sellpd.SELLPRODUCT_DTA) { object[] obj_dta = { "@SlpID", retID, "@SlpNo", Num++, "@PrdID", ls.PrdID, "@SpdAmount", ls.SpdAmount, "@SpdPrice", ls.SpdPrice, "@Discount", ls.Discount }; object[] obj_reserve = { "@PrdID", ls.PrdID, "@Amount", ls.SpdAmount }; try { Db.Insert(sql_dta, obj_dta); Db.Update(sql_reserve, obj_reserve); } catch { return(false); } } ts.Complete(); return(true); } else { return(false); } } }
public bool InsertSupAndPhone(SupplierEntity Supplier, ICollection <Models.SUPPLIER_PHONE> list) { string sql = @"sp_supplier_INSERT"; string sql_phone = @"sp_supAndPhone_INSERT"; using (TransactionScope ts = new TransactionScope()) { string retID = Db.InsertReturnID(sql, Take(Supplier)); if (retID != null) { if (list.Count() == 0) { object[] obj = { "@PhoneNumber", "XXXXXXXXXX" }; Db.Insert(sql_phone, obj); } else { foreach (var ls in list) { object[] obj = { "@SupID", retID, "@PhoneNumber", ls.Phone }; try { Db.Insert(sql_phone, obj); } catch { return(false); } } } ts.Complete(); return(true); } else { return(false); } } }
public bool InsertReceive(ReceiveModel rec, List <ReceiveDetailModel> list, List <SERIAL> serial) { string sql = @"[sp_receiveorder_INSERT]"; string sql_Detail = @"[sp_receiveorder_dta_INSERT]"; string sql_Lot = @"[sp_productlot_INSERT]"; string sql_serial = @"[sp_serial_INSERT]"; // update Offer status => Approve to Purchase // string sql_UPDATE = @"sp_orderANDoffer_UPDATE"; string retID = ""; string tempID = ""; object[] objRec = { "@EmpID", rec.EmpID, "@RecODate", rec.RecODate }; using (TransactionScope ts = new TransactionScope()) { try { retID = Db.InsertReturnID(sql, objRec); if (retID != null) { foreach (var ls in list) { object[] obj = { "@RecOID", retID, "@RecONo", ls.RecONo, "@OrdID", ls.OrdID, "@OrdNo", ls.OrdNo, "@AmountRec", ls.AmountRec }; object[] obj_lot = { "@LotNo", tempID, "@PrdID", ls.PrdID, "@RecOID", retID, "@RecONo", ls.RecONo, "@AmountRec", ls.AmountRec, "@Amount", ls.AmountRec, "@Price", ls.Cost, "@LotDate", System.DateTime.Now.ToString("yyyy-MM-dd", System.Globalization.CultureInfo.InvariantCulture) }; //object[] obj_stock = try { Db.Insert(sql_Detail, obj); tempID = Db.InsertReturnID(sql_Lot, obj_lot); } catch { return(false); } } foreach (var ls in serial) { object[] obj_serial = { "@LotNo", tempID, "@PrdID", ls.PrdID, "@SrlID", ls.SrlID }; try { Db.Insert(sql_serial, obj_serial); } catch { return(false); } } ts.Complete(); return(true); } else { return(false); } } catch { return(false); } } }
public bool InsertEmpAndPhone(EmployeeEntity employee, ICollection <EMPLOYEE_PHONE> list, string UPDATEDATA) { string sql = @"sp_employee_INSERT"; string sql_phone = @"sp_empAndPhone_INSERT"; string retID = ""; if (UPDATEDATA.Equals("INSERT")) { using (TransactionScope ts = new TransactionScope()) { retID = Db.InsertReturnID(sql, Take(employee)); if (retID != null) { if (list.Count() == 0) { object[] obj = { "@PhoneNumber", "XXXXXXXXXX" }; Db.Insert(sql_phone, obj); } else { foreach (var ls in list) { object[] obj = { "@EmpID", retID, "@PhoneNumber", ls.Phone }; try { Db.Insert(sql_phone, obj); } catch { return(false); } } } ts.Complete(); return(true); } else { return(false); } } } else if (UPDATEDATA.Equals("UPDATE")) { string sql_emp = @"sp_employee_UPDATE"; string sql_upd = @"sp_empAndPhone_UPDATE"; string sql_del = @"sp_empAndPhone_DELETE"; using (TransactionScope ts = new TransactionScope()) {// UPDATE พนักงาน Db.Update(sql_emp, Take2(employee)); // ลบ และ สร้าง เบอร์ใหม่ เพื่อ อัพเดท object[] del = { "@EmpID", employee.EmpID }; Db.Delete(sql_del, del); { foreach (var ls in list) { object[] obj = { "@EmpID", employee.EmpID, "@Phone", ls.Phone }; try { Db.Insert(sql_upd, obj); } catch { return(false); } } ts.Complete(); return(true); } } } return(false); }