protected void btnAddCustomer_Click(object sender, EventArgs e) { if (discountGroupID != 0 && acc != null) { var customer = JsonConvert.DeserializeObject <CustomerModel>(hdfCustomer.Value); var order = JsonConvert.DeserializeObject <OrderModel>(hdfOrder.Value); if (customer != null) { var now = DateTime.Now; var data = new tbl_DiscountCustomer() { DiscountGroupID = discountGroupID, UID = customer.ID, CustomerName = customer.FullName, CustomerPhone = customer.Phone, IsHidden = false, CreatedDate = now, CreatedBy = acc.Username, ModifiedDate = now, ModifiedBy = acc.Username, VerifyOrder = order != null ? order.ID : 0 }; DiscountCustomerController.Insert(data); PJUtils.ShowMessageBoxSwAlert("Thêm khách hàng vào nhóm thành công", "s", true, Page); } else { PJUtils.ShowMessageBoxSwAlert("Vui lòng chọn khách hàng cần thêm", "e", true, Page); } } }
public static tbl_DiscountCustomer GetByID(int ID) { using (var dbe = new inventorymanagementEntities()) { tbl_DiscountCustomer ai = dbe.tbl_DiscountCustomer.Where(a => a.UID == ID).FirstOrDefault(); if (ai != null) { return(ai); } else { return(null); } } }
public static string Delete(int customerID) { using (var dbe = new inventorymanagementEntities()) { tbl_DiscountCustomer ui = dbe.tbl_DiscountCustomer.Where(a => a.UID == customerID).SingleOrDefault(); if (ui != null) { dbe.tbl_DiscountCustomer.Remove(ui); int kq = dbe.SaveChanges(); return(kq.ToString()); } else { return(null); } } }
public static void Insert(tbl_DiscountCustomer data) { using (var con = new inventorymanagementEntities()) { var dataOld = con.tbl_DiscountCustomer .Where(x => x.UID == data.UID) .FirstOrDefault(); // Kiểm tra nếu khách hàng ở nhóm khác thì xóa khách ở nhóm đó đi để chuyển qua nhóm mới if (dataOld != null) { con.tbl_DiscountCustomer.Remove(dataOld); } con.tbl_DiscountCustomer.Add(data); con.SaveChanges(); } }
public static string Insert(int DiscountGroupID, int UID, string CustomerName, string customerPhone, bool IsHidden, DateTime CreatedDate, string CreatedBy) { using (var dbe = new inventorymanagementEntities()) { tbl_DiscountCustomer ui = new tbl_DiscountCustomer(); ui.DiscountGroupID = DiscountGroupID; ui.UID = UID; ui.CustomerName = CustomerName; ui.CustomerPhone = customerPhone; ui.IsHidden = IsHidden; ui.CreatedDate = CreatedDate; ui.CreatedBy = CreatedBy; dbe.tbl_DiscountCustomer.Add(ui); dbe.SaveChanges(); int kq = ui.ID; return(kq.ToString()); } }
public static string UpdateIsHidden(int ID, bool IsHidden, DateTime ModifiedDate, string ModifiedBy) { using (var dbe = new inventorymanagementEntities()) { tbl_DiscountCustomer ui = dbe.tbl_DiscountCustomer.Where(a => a.ID == ID).SingleOrDefault(); if (ui != null) { ui.IsHidden = IsHidden; ui.ModifiedBy = ModifiedBy; ui.ModifiedDate = ModifiedDate; int kq = dbe.SaveChanges(); return(kq.ToString()); } else { return(null); } } }