public bool XoaListTheoID(List <int> listID)
{
bool kq = true;
Entities entities = ContextFactory.GetInstance();
try
{
using (TransactionScope trans = new TransactionScope())
{
foreach (int id in listID)
{
HT_TNGUYEN obj = new HT_TNGUYEN();
obj = entities.HT_TNGUYEN.FirstOrDefault(e => e.ID == id);
entities.DeleteObject(obj);
entities.SaveChanges();
}
trans.Complete();
}
}
catch (System.Exception ex)
{
kq = false;
LLogging.WriteLog(ex.TargetSite.Name, LLogging.LogType.ERR, ex);
}
finally
{
entities = null;
}
return(kq);
}
public bool Sua(HT_TNGUYEN obj)
{
bool kq = true;
Entities entities = ContextFactory.GetInstance();
EntityKey key = null;
object original = null;
try
{
key = entities.CreateEntityKey(ENTITY_SET_NAME, obj);
if (entities.TryGetObjectByKey(key, out original))
{
entities.ApplyCurrentValues(key.EntitySetName, obj);
}
entities.SaveChanges();
kq = true;
}
catch (System.Exception ex)
{
kq = false;
LLogging.WriteLog(ex.TargetSite.Name, LLogging.LogType.ERR, ex);
}
finally
{
entities = null;
}
return(kq);
}
public bool HuyDuyetListTheoID(List <int> listID)
{
bool kq = true;
Entities entities = ContextFactory.GetInstance();
try
{
using (TransactionScope trans = new TransactionScope())
{
foreach (int id in listID)
{
HT_TNGUYEN obj = new HT_TNGUYEN();
obj = entities.HT_TNGUYEN.FirstOrDefault(e => e.ID == id);
obj.TTHAI_NVU = BusinessConstant.TrangThaiNghiepVu.THOAI_DUYET.layGiaTri();
entities.SaveChanges();
}
trans.Complete();
}
}
catch (System.Exception ex)
{
kq = false;
LLogging.WriteLog(ex.TargetSite.Name, LLogging.LogType.ERR, ex);
}
finally
{
entities = null;
}
return(kq);
}
public bool Xoa(HT_TNGUYEN obj)
{
bool kq = true;
Entities entities = ContextFactory.GetInstance();
try
{
entities.HT_TNGUYEN.DeleteObject(obj);
entities.SaveChanges();
}
catch (System.Exception ex)
{
kq = false;
LLogging.WriteLog(ex.TargetSite.Name, LLogging.LogType.ERR, ex);
}
finally
{
entities = null;
}
return(kq);
}
public HT_TNGUYEN GetByMa(string ma)
{
HT_TNGUYEN kq = null;
Entities entities = ContextFactory.GetInstance();
try
{
kq = entities.HT_TNGUYEN.FirstOrDefault(e => e.MA_TNGUYEN.Equals(ma));
return(kq);
}
catch (System.Exception ex)
{
kq = null;
LLogging.WriteLog(ex.TargetSite.Name, LLogging.LogType.ERR, ex);
}
finally
{
entities = null;
}
return(kq);
}
