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);
}
}
}
