public static string Update(tbl_DiscountGroup data)
{
using (var con = new inventorymanagementEntities())
{
var discount = con.tbl_DiscountGroup
.Where(a => a.ID == data.ID)
.FirstOrDefault();
if (discount != null)
{
discount.DiscountName = data.DiscountName;
discount.DiscountAmount = data.DiscountAmount;
discount.QuantityProduct = data.QuantityProduct;
discount.DiscountAmountPercent = data.DiscountAmountPercent;
discount.FeeRefund = data.FeeRefund;
discount.NumOfDateToChangeProduct = data.NumOfDateToChangeProduct;
discount.NumOfProductCanChange = data.NumOfProductCanChange;
discount.RefundQuantityNoFee = data.RefundQuantityNoFee;
discount.DiscountNote = data.DiscountNote;
discount.IsHidden = data.IsHidden;
discount.ModifiedBy = data.ModifiedBy;
discount.ModifiedDate = data.ModifiedDate;
discount.PermittedRead = data.PermittedRead;
discount.QuantityRequired = data.QuantityRequired;
int kq = con.SaveChanges();
return(kq.ToString());
}
else
{
return(null);
}
}
}
public static string Update(int ID, string DiscountName, double DiscountAmount, double DiscountAmountPercent, string DiscountNote, bool IsHidden,
DateTime ModifiedDate, string ModifiedBy, double FeeRefund, double NumOfDateToChangeProduct, double NumOfProductCanChange)
{
using (var dbe = new inventorymanagementEntities())
{
tbl_DiscountGroup ui = dbe.tbl_DiscountGroup.Where(a => a.ID == ID).SingleOrDefault();
if (ui != null)
{
ui.DiscountName = DiscountName;
ui.DiscountAmount = DiscountAmount;
ui.DiscountAmountPercent = DiscountAmountPercent;
ui.DiscountNote = DiscountNote;
ui.IsHidden = IsHidden;
ui.FeeRefund = FeeRefund;
ui.NumOfDateToChangeProduct = NumOfDateToChangeProduct;
ui.NumOfProductCanChange = NumOfProductCanChange;
ui.ModifiedBy = ModifiedBy;
ui.ModifiedDate = ModifiedDate;
int kq = dbe.SaveChanges();
return(kq.ToString());
}
else
{
return(null);
}
}
}
public static string Insert(tbl_DiscountGroup data)
{
using (var con = new inventorymanagementEntities())
{
con.tbl_DiscountGroup.Add(data);
con.SaveChanges();
return(data.ID.ToString());
}
}
public static tbl_DiscountGroup GetByID(int ID)
{
using (var dbe = new inventorymanagementEntities())
{
tbl_DiscountGroup ai = dbe.tbl_DiscountGroup.Where(a => a.ID == ID).FirstOrDefault();
if (ai != null)
{
return(ai);
}
else
{
return(null);
}
}
}
protected void btnUpdateDiscountGroup_Click(object sender, EventArgs e)
{
string username = Request.Cookies["usernameLoginSystem"].Value;
var acc = AccountController.GetByUsername(username);
if (acc != null)
{
if (acc.RoleID == 0)
{
int id = ViewState["ID"].ToString().ToInt(0);
if (id > 0)
{
var now = DateTime.Now;
var data = new tbl_DiscountGroup()
{
ID = id,
DiscountName = txtDiscountName.Text,
DiscountAmount = pDiscountAmount.Value.HasValue ? pDiscountAmount.Value.Value : 0,
DiscountAmountPercent = 0,
QuantityProduct = pQuantityProduct.Value.HasValue ? Convert.ToInt32(pQuantityProduct.Value.Value) : 0,
FeeRefund = rRefundGoods.Value.HasValue ? rRefundGoods.Value.Value : 0,
NumOfDateToChangeProduct = pNumOfDateToChangeProduct.Value.HasValue ? pNumOfDateToChangeProduct.Value.Value : 0,
NumOfProductCanChange = pNumOfProductCanChange.Value.HasValue ? pNumOfProductCanChange.Value.Value : 0,
RefundQuantityNoFee = pRefundQuantityNoFee.Value.HasValue ? Convert.ToInt32(pRefundQuantityNoFee.Value.Value) : 0,
DiscountNote = pDiscountNote.Content,
IsHidden = chkIsHidden.Checked,
ModifiedBy = username,
ModifiedDate = now,
PermittedRead = hdfPermittedRead.Value,
QuantityRequired = pQuantityRequired.Value.HasValue ? Convert.ToInt32(pQuantityRequired.Value.Value) : 0,
};
var result = DiscountGroupController.Update(data);
if (!String.IsNullOrEmpty(result))
{
PJUtils.ShowMessageBoxSwAlert("Cập nhật nhóm khách hàng thành công", "s", true, Page);
}
}
}
}
}
public static string Insert(string DiscountName, double DiscountAmount, double DiscountAmountPercent, string DiscountNote, bool IsHidden,
DateTime CreatedDate, string CreatedBy, double FeeRefund, double NumOfDateToChangeProduct, double NumOfProductCanChange)
{
using (var dbe = new inventorymanagementEntities())
{
tbl_DiscountGroup ui = new tbl_DiscountGroup();
ui.DiscountName = DiscountName;
ui.DiscountAmount = DiscountAmount;
ui.DiscountAmountPercent = DiscountAmountPercent;
ui.DiscountNote = DiscountNote;
ui.IsHidden = IsHidden;
ui.CreatedDate = CreatedDate;
ui.CreatedBy = CreatedBy;
ui.FeeRefund = FeeRefund;
ui.NumOfDateToChangeProduct = NumOfDateToChangeProduct;
ui.NumOfProductCanChange = NumOfProductCanChange;
dbe.tbl_DiscountGroup.Add(ui);
dbe.SaveChanges();
int kq = ui.ID;
return(kq.ToString());
}
}
protected void btnCreateDiscountGroup_Click(object sender, EventArgs e)
{
string username = Request.Cookies["usernameLoginSystem"].Value;
var acc = AccountController.GetByUsername(username);
if (acc != null)
{
if (acc.RoleID == 0)
{
var now = DateTime.Now;
var data = new tbl_DiscountGroup()
{
DiscountName = txtDiscountName.Text,
DiscountAmount = pDiscountAmount.Value.HasValue ? pDiscountAmount.Value.Value : 0,
DiscountAmountPercent = 0,
QuantityProduct = pQuantityProduct.Value.HasValue ? Convert.ToInt32(pQuantityProduct.Value.Value) : 0,
FeeRefund = rRefundGoods.Value.HasValue ? rRefundGoods.Value.Value : 0,
NumOfDateToChangeProduct = pNumOfDateToChangeProduct.Value.HasValue ? pNumOfDateToChangeProduct.Value.Value : 0,
NumOfProductCanChange = pNumOfProductCanChange.Value.HasValue ? pNumOfProductCanChange.Value.Value : 0,
RefundQuantityNoFee = pRefundQuantityNoFee.Value.HasValue ? Convert.ToInt32(pRefundQuantityNoFee.Value.Value) : 0,
DiscountNote = pDiscountNote.Content,
IsHidden = chkIsHidden.Checked,
CreatedBy = username,
CreatedDate = now,
ModifiedBy = username,
ModifiedDate = now,
PermittedRead = hdfPermittedRead.Value,
QuantityRequired = pQuantityRequired.Value.HasValue ? Convert.ToInt32(pQuantityRequired.Value.Value) : 0
};
DiscountGroupController.Insert(data);
Response.Redirect("/danh-sach-nhom-khach-hang.aspx");
PJUtils.ShowMessageBoxSwAlert("Tạo mới thành công", "s", true, Page);
}
}
}
