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