public async Task <List <DocumentationBusinessType> > FindDocumentationBusinessTypesByBTAsync(int businessTypeID)
{
Stopwatch timespan = Stopwatch.StartNew();
try
{
var result = await db.DocumentationBusinessTypes
.Where(t => t.BusinessTypeID == businessTypeID)
.OrderByDescending(t => t.BusinessTypeID).ToListAsync();
if (result != null)
{
foreach (DocumentationBusinessType item in result)
{
db.Entry(item).Reference(x => x.Documentation).Load();
}
}
timespan.Stop();
log.TraceApi("SQL Database", "DocumentationBusinessTypeRepository.FindDocumentationBusinessTypesByBTAsync", timespan.Elapsed, "businessTypeID={0}", businessTypeID);
return(result);
}
catch (Exception e)
{
log.Error(e, "Error in DocumentationBusinessTypeRepository.FindDocumentationBusinessTypesByBTAsync(businessTypeID={0})", businessTypeID);
throw;
}
}
/// <summary>
/// Cuando una Presetacion la toma un Auditor para su revision
/// </summary>
/// <param name="presentation"></param>
/// <returns></returns>
#warning "Falta tomar el Id del Usuario logueado"
public async Task TakeToAudit(Presentation presentation)
{
Stopwatch timespan = Stopwatch.StartNew();
SiccoAppConfiguration.SuspendExecutionStrategy = true;
DbContextTransaction tran = db.Database.BeginTransaction();
try
{
if (presentation.PresentationStatus != PresentationStatus.Pending)
{
throw new Exception("No se puede tomar Presentaciones que no estan PENDIENTES");
}
//actualizacion de Presentation
presentation.TakenDate = DateTime.UtcNow;
//presentation.TakenFor = 999;
presentation.PresentationStatus = PresentationStatus.Processing;
//actualizacion de Requerimientos
var requirement = await db.Requirements.FindAsync(presentation.RequirementID);
requirement.RequirementStatus = RequirementStatus.Processing;
//creacion de el historico de accionesde Presentation
PresentationAction presentationAction = new PresentationAction
{
PresentationID = presentation.PresentationID,
PresentationDate = DateTime.UtcNow,
ActionForID = presentation.TakenForID,
PresentationActionType = PresentationActionType.Taken
};
db.PresentationActions.Add(presentationAction);
db.Entry(presentation).State = EntityState.Modified;
await db.SaveChangesAsync();
tran.Commit();
timespan.Stop();
log.TraceApi("SQL Database", "PresentationRepository.TakeToAudit", timespan.Elapsed, "presentation={0}", presentation);
}
catch (Exception e)
{
tran.Rollback();
log.Error(e, "Error in PresentationRepository.TakeToAudit(presentation={0})", presentation);
throw;
}
SiccoAppConfiguration.SuspendExecutionStrategy = false;
}
public async Task UpdateAsync(Contractor contractorToSave)
{
Stopwatch timespan = Stopwatch.StartNew();
try
{
db.Entry(contractorToSave).State = EntityState.Modified;
await db.SaveChangesAsync();
timespan.Stop();
log.TraceApi("SQL Database", "ContractorRepository.UpdateAsync", timespan.Elapsed, "contractorToSave={0}", contractorToSave);
}
catch (Exception e)
{
log.Error(e, "Error in ContractorRepository.UpdateAsync(contractorToSave={0})", contractorToSave);
throw;
}
}
public async Task UpdateAsync(BusinessTypeTemplate businessTypeTemplateToSave)
{
Stopwatch timespan = Stopwatch.StartNew();
try
{
db.Entry(businessTypeTemplateToSave).State = EntityState.Modified;
await db.SaveChangesAsync();
timespan.Stop();
log.TraceApi("SQL Database", "BusinessTypeTemplateRepository.UpdateAsync", timespan.Elapsed, "businessTypeTemplateToSave={0}", businessTypeTemplateToSave);
}
catch (Exception e)
{
log.Error(e, "Error in BusinessTypeTemplateRepository.UpdateAsync(businessTypeTemplateToSave={0})", businessTypeTemplateToSave);
throw;
}
}
public void Update(T entity)
{
_dbContext.Entry(entity).State = EntityState.Modified;
_dbContext.SaveChanges();
}
