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