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 DieuKienKhuyenMaiPOS Load(string CTKhuyenMaiID) { using(var model= new SGCoopSTEntities()) { var obj = from l in model.DieuKienKhuyenMaiPOS where l.CTKhuyenMaiID == CTKhuyenMaiID select l; return obj.FirstOrDefault(); } }
public static List<DieuKienKhuyenMaiPOS> Load(DieuKienKhuyenMaiPOS obj) { using(var model= new SGCoopSTEntities()) { var list = from l in model.DieuKienKhuyenMaiPOS where l.CTKhuyenMaiID == obj.CTKhuyenMaiID select l; return list.ToList(); } }
public static int count() { using (var model= new SGCoopSTEntities()) { int count = model.KhuyenMaiPOS.Count(); return count; } }
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 List<ExceptionPOS> Load(ExceptionPOS obj) { using(var model= new SGCoopSTEntities()) { var list = from l in model.ExceptionPOS where l.MaDotKhuyenMai == obj.MaDotKhuyenMai select l; return list.ToList(); } }
public static int delete(List<DieuKienKhuyenMaiPOS> lst) { using(var model= new SGCoopSTEntities()) { foreach (var item in lst) { model.Entry(item).State = System.Data.Entity.EntityState.Deleted; } return model.SaveChanges(); } }
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(); } }