public static void save_KMPOS(KhuyenMaiPOS obj,CTKhuyenMaiPOS objCT,List<DieuKienKhuyenMaiPOS> objDK,List<ExceptionPOS> objEX=null)
{
using (var model= new SGCoopSTEntities())
{
using(var trans= model.Database.BeginTransaction())
{
try
{
model.KhuyenMaiPOS.Add(obj);
model.CTKhuyenMaiPOS.Add(objCT);
model.DieuKienKhuyenMaiPOS.AddRange(objDK);
if (objEX.Count!=0)
{
model.ExceptionPOS.AddRange(objEX);
}
model.SaveChanges();
trans.Commit();
}
catch (DbEntityValidationException ex)
{
trans.Rollback();
List<string> errorMessages = new List<string>();
foreach (DbEntityValidationResult validationResult in ex.EntityValidationErrors)
{
string entityName = validationResult.Entry.Entity.GetType().Name;
foreach (DbValidationError error in validationResult.ValidationErrors)
{
errorMessages.Add(entityName + "." + error.PropertyName + ": " + error.ErrorMessage);
}
}
throw new Exception(errorMessages.ToString());
}
}
}
}
public static CTKhuyenMaiPOS load(CTKhuyenMaiPOS obj)
{
using (var model = new SGCoopSTEntities())
{
var objct = from l in model.CTKhuyenMaiPOS where l.MaDotKhuyenMai == obj.MaDotKhuyenMai select l;
return objct.FirstOrDefault();
}
}
public static void del_KMPOS(KhuyenMaiPOS obj, CTKhuyenMaiPOS objCT, List<DieuKienKhuyenMaiPOS> objDK, List<ExceptionPOS> objEX)
{
using(var model= new SGCoopSTEntities())
{
using(var trans= model.Database.BeginTransaction())
try
{
model.Entry(obj).State = System.Data.Entity.EntityState.Deleted;
model.Entry(objCT).State = System.Data.Entity.EntityState.Deleted;
model.Entry(objEX).State = System.Data.Entity.EntityState.Deleted;
model.Entry(objDK).State = System.Data.Entity.EntityState.Deleted;
model.SaveChanges();
trans.Commit();
}
catch (Exception ex)
{
trans.Rollback();
throw new Exception(ex.Message);
}
}
}
void add()
{
objCT = new CTKhuyenMaiPOS(); lstDK = new List<DieuKienKhuyenMaiPOS>(); lstEX = new List<ExceptionPOS>(); objKM = new KhuyenMaiPOS(); lst_KM_ST = new List<KhuyenMai_SieuThi>();
try
{
if (check_detail()==true)
{
string _GuidCT = Guid.NewGuid().ToString();
int _STT = Create_Number();
set_object(_GuidCT, _STT);
CTLKhuyenMaiPOS.save_KMPOS(objKM, objCT, lstDK, lstEX);
MessageBox.Show("Đã lưu","Thông báo", MessageBoxButtons.OK,MessageBoxIcon.Information);
clear_form();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToArray().ToString());
}
}
void update()
{
try
{
if (check_detail() == true)
{
string _GuidCT = objCT.CTKhuyenMaiID;
int _STT = objCT.STT;
if (lstDK != null)
CTLDieuKienKhuyenMaiPOS.delete(lstDK);
if (lstEX!= null)
CTLExceptionPOS.delete(lstEX);
objCT = new CTKhuyenMaiPOS(); lstDK = new List<DieuKienKhuyenMaiPOS>(); lstEX = new List<ExceptionPOS>(); objKM = new KhuyenMaiPOS();
objKM.MaNVCapNhat = CurrentUser.MaNV;
set_object(_GuidCT, _STT);
CTLKhuyenMaiPOS.update_KMPOS(objKM, objCT, lstDK, lstEX);
MessageBox.Show("Đã lưu", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Close();
//clear_form();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}
}
void load_data_update()
{
txtTenDotKhuyenMai.Text = objKM.TenDotKhuyenMai;
cboKhuyenMai.SelectedItem = objKM.HinhThucKM.ToString().Trim();
chkCombo.Checked = bool.Parse(objKM.IsCombo.ToString());
chkLoaiTruSKU.Checked = bool.Parse(objKM.IsExept.ToString());
dateTuNgay.Value = objKM.TuNgay;
dateDenNgay.Value = objKM.DenNgay;
chkDaApDung.Checked = objKM.DaApDung;
chkDaThucHien.Checked = bool.Parse(objKM.DaThucHien.ToString());
//*******load CTKhuyenMaiPOS************************************//
objCT = new CTKhuyenMaiPOS();
objCT.MaDotKhuyenMai = objKM.MaDotKhuyenMai;
objCT = CTLCTKhuyenMaiPOS.load(objCT);
txtDKCongDiem.Text = objCT.DieuKien;
txtDiemThuongGioiHan.Text = objCT.DiemThuongGioiHan.ToString();
txtGiaTriHoaDon.Text = format_value(objCT.GiaTriTongHoaDon.ToString().Replace(".00", ""));
txtGhiChu.Text = objCT.GhiChu;
//******load DieuKienKhuyenMai POS*****************************//
objDK = new DieuKienKhuyenMaiPOS();
objDK.CTKhuyenMaiID = objCT.CTKhuyenMaiID;
lstDK = new List<DieuKienKhuyenMaiPOS>();
lstDK = CTLDieuKienKhuyenMaiPOS.Load(objDK);
if(lstDK.Count>0)
{
dgvDieuKienKM.AutoGenerateColumns = false;
dgvDieuKienKM.DataSource = lstDK;
}
//*****load ExceptionPOS**************************************//
if(objKM.IsExept==true)
{
objEX = new ExceptionPOS();
objEX.MaDotKhuyenMai = objKM.MaDotKhuyenMai;
lstEX = new List<ExceptionPOS>();
lstEX = CTLExceptionPOS.Load(objEX);
if(lstEX.Count>0)
{
dgvExPOS.AutoGenerateColumns = false;
dgvExPOS.DataSource = lstEX;
}
}
}