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 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);
}
}
}
public static List<KhuyenMaiPOS> search(KhuyenMaiPOS obj)
{
using(var model= new SGCoopSTEntities())
{
var list = from l in model.KhuyenMaiPOS select l;
if (!string.IsNullOrEmpty(obj.TenDotKhuyenMai))
list = list.Where(q => q.TenDotKhuyenMai.Contains(obj.TenDotKhuyenMai));
if (!string.IsNullOrEmpty(obj.MaNVTao))
list = list.Where(q => q.MaNVTao == obj.MaNVTao);
if (obj.TuNgay.Year != 1)
list = list.Where(q => q.TuNgay >= obj.TuNgay);
if (obj.DenNgay.Year != 1)
list = list.Where(q => q.DenNgay <= obj.DenNgay);
if (!string.IsNullOrEmpty(obj.IsCombo.ToString()))
list = list.Where(q => q.IsCombo == obj.IsCombo);
if (!string.IsNullOrEmpty(obj.IsExept.ToString()))
list = list.Where(q => q.IsExept == obj.IsExept);
return list.ToList();
}
}
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 load_data()
{
obj = new KhuyenMaiPOS();
obj.TenDotKhuyenMai = txtTenDotKhuyenMai.Text;
//obj.MaNVTao = cboNhanVienTao.SelectedValue.ToString();
if (chkTuNgay.Checked == true)
obj.TuNgay = BatDauOfTuNgay.Value;
if (chkDenNgay.Checked == true)
obj.DenNgay = BatDauOfDenNgay.Value;
obj.IsCombo = chkCombo.Checked;
obj.IsExept = chkExpect.Checked;
dgvKMPOS.AutoGenerateColumns = false;
lstKMPOS = new List<KhuyenMaiPOS>();
lstKMPOS = CTLKhuyenMaiPOS.search(obj);
dgvKMPOS.DataSource = lstKMPOS;
}
void load_KMPOS()
{
if (dgvKMPOS.RowCount == 0)
return;
obj = new KhuyenMaiPOS();
DataGridViewRow dr = dgvKMPOS.Rows[dgvKMPOS.CurrentCell.RowIndex];
FrmCauHinhKhuyenMaiDiem frm = new FrmCauHinhKhuyenMaiDiem();
frm.objKM = new KhuyenMaiPOS();
frm.objKM.MaDotKhuyenMai = dr.Cells["MaDotKhuyenMai"].Value.ToString();
frm.objKM.Load();
frm._update = true;
//frm.objKM.TenDotKhuyenMai = dr.Cells["TenDotKhuyenMai"].Value.ToString();
//frm.objKM.MaNVTao = dr.Cells["MaNVTao"].Value == null ? null : dr.Cells["MaNVTao"].Value.ToString();
//frm.objKM.TuNgay = DateTime.Parse(dr.Cells["TuNgay"].Value.ToString());
//frm.objKM.DenNgay = DateTime.Parse(dr.Cells["DenNgay"].Value.ToString());
//frm.objKM.STT = int.Parse(dr.Cells["STT"].Value.ToString());
//frm.objKM.GhiChu = dr.Cells["GhiChu"].Value.ToString();
//frm.objKM.DaApDung = bool.Parse(dr.Cells["DaApDung"].Value.ToString());
//frm.objKM.MaNVCapNhat = dr.Cells["MaNVCapNhat"].Value == null ? null : dr.Cells["MaNVCapNhat"].Value.ToString();
//frm.objKM.DaThucHien = bool.Parse(dr.Cells["DaThucHien"].Value.ToString());
//string hinhthuc = dr.Cells["HinhThucKM"].Value.ToString();
//frm.objKM.HinhThucKM = int.Parse(dr.Cells["HinhThucKM"].Value.ToString());
//frm.objKM.IsExept = bool.Parse(dr.Cells["IsExept"].Value.ToString());
//frm.objKM.IsCombo = bool.Parse(dr.Cells["IsCombo"].Value.ToString());
frm.ShowDialog();
}
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());
}
}
