public bool UpdateWithDetail(AdministrasiRole header, List <AdministrasiRoleDtl> detail)
{
using (var trans = ctx.Database.BeginTransaction(IsolationLevel.ReadCommitted))
{
try
{
base.Update(header);
using (var repoDtl = new AdministrasiRoleDtlRepository(ctx))
{
var redcDetail = repoDtl.GetAll().Where(x => x.KodeRole == header.Kode).ToList();
repoDtl.Deletes(redcDetail);
//repoDtl.User = this.User;
foreach (var dtl in detail)
{
repoDtl.Create(dtl);
}
}
trans.Commit();
return(true);
}
catch (Exception ex)
{
trans.Rollback();
throw new Exception(ex.Message, ex.InnerException);
}
}
}
public bool DeleteWithDetail(string kode)
{
using (var trans = ctx.Database.BeginTransaction(IsolationLevel.ReadCommitted))
{
try
{
var model = base.GetSingle(kode);
base.Delete(model);
using (var repoDtl = new AdministrasiRoleDtlRepository(ctx))
{
repoDtl.UserProfile = this.UserProfile;
var detail = repoDtl.GetAll().Where(x => x.KodeRole == kode).ToList();
repoDtl.Deletes(detail);
}
trans.Commit();
return(true);
}
catch (Exception ex)
{
trans.Rollback();
throw new Exception(ex.Message, ex.InnerException);
}
}
}
public bool CreateWithDetail(AdministrasiRole header, List <AdministrasiRoleDtl> detail)
{
using (var trans = ctx.Database.BeginTransaction(IsolationLevel.ReadCommitted))
{
try
{
base.Create(header);
using (var repoDtl = new AdministrasiRoleDtlRepository(ctx))
{
foreach (var dtl in detail)
{
dtl.KodeWilayahKerja = "CE01";
repoDtl.Create(dtl);
}
}
trans.Commit();
return(true);
}
catch (Exception ex)
{
trans.Rollback();
throw new Exception(ex.Message, ex.InnerException);
}
}
}
