/// <summary>
/// Adds the asynchronous.
/// </summary>
/// <param name="entity">The entity.</param>
/// <returns></returns>
public async Task<SaveResult> AddAsync(FARMechanismDto entity)
{
SaveResult result = SaveResult.FAILURE;
try
{
using (FailureAnalysisEntities context = new FailureAnalysisEntities())
{
FAR_Mechanism add = context.FAR_Mechanism.Create();
add.Description = entity.Description;
add.Name = entity.Name;
add.IsDeleted = false;
add.LastUpdatedBy = entity.LastUpdatedBy;
add.LastUpdate = DateTime.Now;
context.Entry<FAR_Mechanism>(add).State = System.Data.Entity.EntityState.Added;
result = await context.SaveChangesAsync() > 0 ? SaveResult.SUCCESS : SaveResult.FAILURE;
}
}
catch (Exception ex)
{
_logService.Error(ex.Message, ex);
result = SaveResult.FAILURE;
}
return result;
}
/// <summary>
/// Updates the asynchronous.
/// </summary>
/// <param name="entity">The entity.</param>
/// <returns></returns>
public async Task<SaveResult> UpdateAsync(MSTServiceDto entity)
{
SaveResult result = SaveResult.FAILURE;
try
{
using (FailureAnalysisEntities context = new FailureAnalysisEntities())
{
var service = context.MST_Services.Single(x => x.Id == entity.Id && x.IsDeleted == false);
service.Name = entity.Name;
service.IsDeleted = entity.IsDeleted;
service.Description = entity.Description;
service.LastUpdatedBy = entity.LastUpdatedBy;
service.LastUpdate = DateTime.Now;
context.Entry<MST_Services>(service).State = System.Data.Entity.EntityState.Modified;
result = await context.SaveChangesAsync() > 0 ? SaveResult.SUCCESS : SaveResult.FAILURE;
}
}
catch (Exception ex)
{
_logService.Error(ex.Message, ex);
result = SaveResult.FAILURE;
}
return result;
}
/// <summary>
/// Adds the range asynchronous.
/// </summary>
/// <param name="entities">The entities.</param>
/// <returns></returns>
public async Task<SaveResult> AddRangeAsync(IEnumerable<MSTServiceDto> entities)
{
SaveResult result = SaveResult.FAILURE;
try
{
using (FailureAnalysisEntities context = new FailureAnalysisEntities())
{
MST_Services add = null;
foreach (var entity in entities)
{
add = context.MST_Services.Create();
add.Description = entity.Description;
add.IsDeleted = false;
add.Name = entity.Name;
add.LastUpdatedBy = entity.LastUpdatedBy;
add.LastUpdate = DateTime.Now;
context.Entry<MST_Services>(add).State = System.Data.Entity.EntityState.Added;
}
result = await context.SaveChangesAsync() > 0 ? SaveResult.SUCCESS : SaveResult.FAILURE;
}
}
catch (Exception ex)
{
_logService.Error(ex.Message, ex);
result = SaveResult.FAILURE;
}
return result;
}
/// <summary>
/// Updates the asynchronous.
/// </summary>
/// <param name="entity">The entity.</param>
/// <returns></returns>
public async Task<SaveResult> UpdateAsync(FARInitialTargetLogDto entity)
{
SaveResult result = SaveResult.FAILURE;
try
{
using (FailureAnalysisEntities context = new FailureAnalysisEntities())
{
var log = context.LOG_FARInitialTarget.Single(x => x.Id == entity.Id && x.IsDeleted == false);
log.MasterId = entity.MasterId;
log.ReasonId = entity.ReasonId;
log.IsDeleted = entity.IsDeleted;
log.TargetDate = entity.TargetDate;
log.LastUpdatedBy = entity.LastUpdatedBy;
log.LastUpdate = DateTime.Now;
context.Entry<LOG_FARInitialTarget>(log).State = System.Data.Entity.EntityState.Modified;
result = await context.SaveChangesAsync() > 0 ? SaveResult.SUCCESS : SaveResult.FAILURE;
}
}
catch (Exception ex)
{
_logService.Error(ex.Message, ex);
result = SaveResult.FAILURE;
}
return result;
}
/// <summary>
/// Adds the range asynchronous.
/// </summary>
/// <param name="entities">The entities.</param>
/// <returns></returns>
public async Task<SaveResult> AddRangeAsync(IEnumerable<FARInitialTargetLogDto> entities)
{
SaveResult result = SaveResult.FAILURE;
try
{
using (FailureAnalysisEntities context = new FailureAnalysisEntities())
{
LOG_FARInitialTarget add = null;
foreach (var entity in entities)
{
add = context.LOG_FARInitialTarget.Create();
add.TargetDate = entity.TargetDate;
add.ReasonId = entity.ReasonId;
add.IsDeleted = false;
add.MasterId = entity.MasterId;
add.LastUpdatedBy = entity.LastUpdatedBy;
add.LastUpdate = DateTime.Now;
context.Entry<LOG_FARInitialTarget>(add).State = System.Data.Entity.EntityState.Added;
}
result = await context.SaveChangesAsync() > 0 ? SaveResult.SUCCESS : SaveResult.FAILURE;
}
}
catch (Exception ex)
{
_logService.Error(ex.Message, ex);
result = SaveResult.FAILURE;
}
return result;
}
/// <summary>
/// Updates the asynchronous.
/// </summary>
/// <param name="entity">The entity.</param>
/// <returns></returns>
public async Task<SaveResult> UpdateAsync(DelayReasonDto entity)
{
SaveResult result = SaveResult.FAILURE;
try
{
using (FailureAnalysisEntities context = new FailureAnalysisEntities())
{
var assembly = context.MST_ReasonINIReport.Single(x => x.Id == entity.Id && x.IsDeleted == false);
assembly.Description = entity.Description;
assembly.LastUpdatedBy = entity.LastUpdatedBy;
assembly.LastUpdate = DateTime.Now;
context.Entry<MST_ReasonINIReport>(assembly).State = System.Data.Entity.EntityState.Modified;
result = await context.SaveChangesAsync() > 0 ? SaveResult.SUCCESS : SaveResult.FAILURE;
}
}
catch (Exception ex)
{
_logService.Error(ex.Message, ex);
result = SaveResult.FAILURE;
}
return result;
}
/// <summary>
/// Adds the range.
/// </summary>
/// <param name="entities">The entities.</param>
/// <returns></returns>
public SaveResult AddRange(IEnumerable<DelayReasonDto> entities)
{
SaveResult result = SaveResult.FAILURE;
try
{
using (FailureAnalysisEntities context = new FailureAnalysisEntities())
{
foreach (var entity in entities)
{
MST_ReasonINIReport add = context.MST_ReasonINIReport.Create();
add.Description = entity.Description;
add.IsDeleted = entity.IsDeleted;
add.LastUpdatedBy = entity.LastUpdatedBy;
add.LastUpdate = DateTime.Now;
context.Entry<MST_ReasonINIReport>(add).State = System.Data.Entity.EntityState.Added;
}
result = context.SaveChanges() > 0 ? SaveResult.SUCCESS : SaveResult.FAILURE;
}
}
catch (Exception ex)
{
_logService.Error(ex.Message, ex);
result = SaveResult.FAILURE;
}
return result;
}
/// <summary>
/// Updates the asynchronous.
/// </summary>
/// <param name="entity">The entity.</param>
/// <returns></returns>
public async Task<SaveResult> UpdateAsync(FARAnalystReassignLogDto entity)
{
SaveResult result = SaveResult.FAILURE;
try
{
using (FailureAnalysisEntities context = new FailureAnalysisEntities())
{
var assembly = context.LOG_FARAnalystReassign.Single(x => x.Id == entity.Id && x.IsDeleted == false);
assembly.MasterId = entity.MasterId;
assembly.IsDeleted = entity.IsDeleted;
assembly.AnalystFrom = entity.AnalystFrom;
assembly.AnalystTo = entity.AnalystTo;
assembly.LastUpdatedBy = entity.LastUpdatedBy;
assembly.UpdatedDate = DateTime.Now;
context.Entry<LOG_FARAnalystReassign>(assembly).State = System.Data.Entity.EntityState.Modified;
result = await context.SaveChangesAsync() > 0 ? SaveResult.SUCCESS : SaveResult.FAILURE;
}
}
catch (Exception ex)
{
_logService.Error(ex.Message, ex);
result = SaveResult.FAILURE;
}
return result;
}
/// <summary>
/// Adds the asynchronous.
/// </summary>
/// <param name="entity">The entity.</param>
/// <returns></returns>
public async Task<SaveResult> AddAsync(FARAnalystReassignLogDto entity)
{
SaveResult result = SaveResult.FAILURE;
try
{
using (FailureAnalysisEntities context = new FailureAnalysisEntities())
{
LOG_FARAnalystReassign add = context.LOG_FARAnalystReassign.Create();
add.MasterId = entity.MasterId;
add.AnalystFrom = entity.AnalystFrom;
add.AnalystTo = entity.AnalystTo;
add.IsDeleted = entity.IsDeleted;
add.LastUpdatedBy = entity.LastUpdatedBy;
add.LastUpdate = DateTime.Now;
context.Entry<LOG_FARAnalystReassign>(add).State = System.Data.Entity.EntityState.Added;
result = await context.SaveChangesAsync() > 0 ? SaveResult.SUCCESS : SaveResult.FAILURE;
}
}
catch (Exception ex)
{
_logService.Error(ex.Message, ex);
result = SaveResult.FAILURE;
}
return result;
}
/// <summary>
/// Adds the asynchronous.
/// </summary>
/// <param name="entity">The entity.</param>
/// <returns></returns>
public async Task<SaveResult> AddAsync(MSTProcessProductDto entity)
{
SaveResult result = SaveResult.FAILURE;
try
{
using (FailureAnalysisEntities context = new FailureAnalysisEntities())
{
MST_ProcessProduct add = context.MST_ProcessProduct.Create();
//Check productId and ProcessTypeId exits record?
var checkExits = context.MST_ProcessProduct.Where(x => x.ProcessTypeId == entity.ProcessTypeId && x.ProductId == entity.ProductId).FirstOrDefault();
if (checkExits != null)
{
checkExits.InChargePerson = entity.InChargePerson;
checkExits.IsDeleted = false;
checkExits.LastUpdatedBy = entity.LastUpdatedBy;
checkExits.LastUpdate = DateTime.Now;
context.Entry<MST_ProcessProduct>(checkExits).State = System.Data.Entity.EntityState.Modified;
}
else
{
add.Description = entity.Description;
add.ProductId = entity.ProductId;
add.ProcessTypeId = entity.ProcessTypeId;
add.InChargePerson = entity.InChargePerson;
add.IsDeleted = false;
add.LastUpdatedBy = entity.LastUpdatedBy;
add.LastUpdate = DateTime.Now;
context.Entry<MST_ProcessProduct>(add).State = System.Data.Entity.EntityState.Added;
}
result = await context.SaveChangesAsync() > 0 ? SaveResult.SUCCESS : SaveResult.FAILURE;
}
}
catch (Exception ex)
{
_logService.Error(ex.Message, ex);
result = SaveResult.FAILURE;
}
return result;
}
/// <summary>
/// Adds the range.
/// </summary>
/// <param name="entities">The entities.</param>
/// <returns></returns>
public SaveResult AddRange(IEnumerable<MSTProcessProductDto> entities)
{
SaveResult result = SaveResult.FAILURE;
try
{
using (FailureAnalysisEntities context = new FailureAnalysisEntities())
{
MST_ProcessProduct add = null;
foreach (var entity in entities)
{
add = context.MST_ProcessProduct.Create();
add.Description = entity.Description;
add.ProductId = entity.ProductId;
add.ProcessTypeId = entity.ProcessTypeId;
add.InChargePerson = entity.InChargePerson;
add.IsDeleted = false;
add.LastUpdatedBy = entity.LastUpdatedBy;
add.LastUpdate = DateTime.Now;
context.Entry<MST_ProcessProduct>(add).State = System.Data.Entity.EntityState.Added;
}
result = context.SaveChanges() > 0 ? SaveResult.SUCCESS : SaveResult.FAILURE;
}
}
catch (Exception ex)
{
_logService.Error(ex.Message, ex);
result = SaveResult.FAILURE;
}
return result;
}
/// <summary>
/// Updates the specified entity.
/// </summary>
/// <param name="entity">The entity.</param>
/// <returns></returns>
public SaveResult Update(MSTProcessProductDto entity)
{
SaveResult result = SaveResult.FAILURE;
try
{
using (FailureAnalysisEntities context = new FailureAnalysisEntities())
{
var update = context.MST_ProcessProduct.Single(x => x.Id == entity.Id && x.IsDeleted == false);
update.InChargePerson = entity.InChargePerson;
update.IsDeleted = entity.IsDeleted;
update.Description = entity.Description;
update.LastUpdatedBy = entity.LastUpdatedBy;
update.LastUpdate = DateTime.Now;
context.Entry<MST_ProcessProduct>(update).State = System.Data.Entity.EntityState.Modified;
result = context.SaveChanges() > 0 ? SaveResult.SUCCESS : SaveResult.FAILURE;
}
}
catch (Exception ex)
{
_logService.Error(ex.Message, ex);
result = SaveResult.FAILURE;
}
return result;
}
/// <summary>
/// Deletes the asynchronous.
/// </summary>
/// <param name="entity">The entity.</param>
/// <returns></returns>
public async Task<SaveResult> DeleteAsync(FARMechanismDto entity)
{
SaveResult result = SaveResult.FAILURE;
try
{
using (FailureAnalysisEntities context = new FailureAnalysisEntities())
{
var fabSite = context.FAR_Mechanism.Single(x => x.Id == entity.Id && x.IsDeleted == false);
fabSite.IsDeleted = true;
fabSite.LastUpdate = DateTime.Now;
fabSite.LastUpdatedBy = entity.LastUpdatedBy;
context.Entry<FAR_Mechanism>(fabSite).State = System.Data.Entity.EntityState.Modified;
result = await context.SaveChangesAsync() > 0 ? SaveResult.SUCCESS : SaveResult.FAILURE;
}
}
catch (Exception ex)
{
_logService.Error(ex.Message, ex);
result = SaveResult.FAILURE;
}
return result;
}
/// <summary>
/// Adds the range.
/// </summary>
/// <param name="entities">The entities.</param>
/// <returns></returns>
public SaveResult AddRange(IEnumerable<FARMechanismDto> entities)
{
SaveResult result = SaveResult.FAILURE;
try
{
using (FailureAnalysisEntities context = new FailureAnalysisEntities())
{
FAR_Mechanism add = null;
foreach (var entity in entities)
{
add = context.FAR_Mechanism.Create();
add.Description = entity.Description;
add.IsDeleted = false;
add.Name = entity.Name;
add.LastUpdatedBy = entity.LastUpdatedBy;
add.LastUpdate = DateTime.Now;
context.Entry<FAR_Mechanism>(add).State = System.Data.Entity.EntityState.Added;
}
result = context.SaveChanges() > 0 ? SaveResult.SUCCESS : SaveResult.FAILURE;
}
}
catch (Exception ex)
{
_logService.Error(ex.Message, ex);
result = SaveResult.FAILURE;
}
return result;
}
/// <summary>
/// Adds the range asynchronous.
/// </summary>
/// <param name="entities">The entities.</param>
/// <returns></returns>
public async Task<SaveResult> AddRangeAsync(IEnumerable<FARUploadDto> entities)
{
SaveResult result = SaveResult.FAILURE;
try
{
using (FailureAnalysisEntities context = new FailureAnalysisEntities())
{
LOG_FARUpload add = null;
foreach (var entity in entities)
{
add = context.LOG_FARUpload.Create();
add.FileName = entity.FileName;
add.MasterId = entity.MasterId;
add.ReasonId = entity.ReasonId;
add.FAType = entity.FAType;
add.UploadedBy = entity.UploadedBy;
add.UploadedDate = DateTime.Now;
context.Entry<LOG_FARUpload>(add).State = System.Data.Entity.EntityState.Added;
}
result = await context.SaveChangesAsync() > 0 ? SaveResult.SUCCESS : SaveResult.FAILURE;
}
}
catch (Exception ex)
{
_logService.Error(ex.Message, ex);
result = SaveResult.FAILURE;
}
return result;
}
/// <summary>
/// Adds the range.
/// </summary>
/// <param name="entities">The entities.</param>
/// <returns></returns>
public SaveResult AddRange(IEnumerable<FARAnalystReassignLogDto> entities)
{
SaveResult result = SaveResult.FAILURE;
try
{
using (FailureAnalysisEntities context = new FailureAnalysisEntities())
{
LOG_FARAnalystReassign add = null;
foreach (var entity in entities)
{
add = context.LOG_FARAnalystReassign.Create();
add.MasterId = entity.MasterId;
add.AnalystFrom = entity.AnalystFrom;
add.AnalystTo = entity.AnalystTo;
add.IsDeleted = entity.IsDeleted;
add.LastUpdatedBy = entity.LastUpdatedBy;
add.LastUpdate = DateTime.Now;
context.Entry<LOG_FARAnalystReassign>(add).State = System.Data.Entity.EntityState.Added;
}
result = context.SaveChanges() > 0 ? SaveResult.SUCCESS : SaveResult.FAILURE;
}
}
catch (Exception ex)
{
_logService.Error(ex.Message, ex);
result = SaveResult.FAILURE;
}
return result;
}
/// <summary>
/// Deletes the asynchronous.
/// </summary>
/// <param name="entity">The entity.</param>
/// <returns></returns>
public async Task<SaveResult> DeleteAsync(FARUploadDto entity)
{
SaveResult result = SaveResult.FAILURE;
try
{
using (FailureAnalysisEntities context = new FailureAnalysisEntities())
{
var assembly = context.LOG_FARUpload.Single(x => x.Id == entity.Id);
context.Entry<LOG_FARUpload>(assembly).State = System.Data.Entity.EntityState.Deleted;
result = await context.SaveChangesAsync() > 0 ? SaveResult.SUCCESS : SaveResult.FAILURE;
}
}
catch (Exception ex)
{
_logService.Error(ex.Message, ex);
result = SaveResult.FAILURE;
}
return result;
}
/// <summary>
/// Deletes the by.
/// </summary>
/// <param name="Id">The identifier.</param>
/// <returns></returns>
public SaveResult DeleteBy(int Id)
{
SaveResult result = SaveResult.FAILURE;
try
{
using (FailureAnalysisEntities context = new FailureAnalysisEntities())
{
var reassign = context.LOG_FARAnalystReassign.Single(x => x.Id == Id && x.IsDeleted == false);
reassign.IsDeleted = true;
reassign.LastUpdate = DateTime.Now;
context.Entry<LOG_FARAnalystReassign>(reassign).State = System.Data.Entity.EntityState.Modified;
result = context.SaveChanges() > 0 ? SaveResult.SUCCESS : SaveResult.FAILURE;
}
}
catch (Exception ex)
{
_logService.Error(ex.Message, ex);
result = SaveResult.FAILURE;
}
return result;
}
/// <summary>
/// Adds the asynchronous.
/// </summary>
/// <param name="entity">The entity.</param>
/// <returns></returns>
public async Task<SaveResult> AddAsync(DelayReasonDto entity)
{
SaveResult result = SaveResult.FAILURE;
try
{
using (FailureAnalysisEntities context = new FailureAnalysisEntities())
{
MST_ReasonINIReport add = context.MST_ReasonINIReport.Create();
add.Description = entity.Description;
add.IsDeleted = entity.IsDeleted;
add.LastUpdatedBy = entity.LastUpdatedBy;
add.LastUpdate = DateTime.Now;
context.Entry<MST_ReasonINIReport>(add).State = System.Data.Entity.EntityState.Added;
result = await context.SaveChangesAsync() > 0 ? SaveResult.SUCCESS : SaveResult.FAILURE;
}
}
catch (Exception ex)
{
_logService.Error(ex.Message, ex);
result = SaveResult.FAILURE;
}
return result;
}
/// <summary>
/// Updates the asynchronous.
/// </summary>
/// <param name="entity">The entity.</param>
/// <returns></returns>
public async Task<SaveResult> UpdateAsync(RecordLockDto entity)
{
SaveResult result = SaveResult.FAILURE;
try
{
using (FailureAnalysisEntities context = new FailureAnalysisEntities())
{
var update = context.FAR_RecordLock.Single(x => x.Id == entity.Id && x.IsDeleted == false);
update.ProcessHistoryId = entity.ProcessHistoryId;
update.LockBy = entity.LockBy;
update.LockDate = entity.LockDate;
update.MasterId = entity.MasterId;
update.ReleaseDate = entity.ReleaseDate;
update.LastUpdatedBy = entity.LastUpdatedBy;
update.LastUpdate = DateTime.Now;
context.Entry<FAR_RecordLock>(update).State = System.Data.Entity.EntityState.Modified;
result = await context.SaveChangesAsync() > 0 ? SaveResult.SUCESS : SaveResult.FAILURE;
}
}
catch (Exception ex)
{
_logService.Error(ex.Message, ex);
result = SaveResult.FAILURE;
}
return result;
}
/// <summary>
/// Deletes the specified entity.
/// </summary>
/// <param name="entity">The entity.</param>
/// <returns></returns>
public SaveResult Delete(DelayReasonDto entity)
{
SaveResult result = SaveResult.FAILURE;
try
{
using (FailureAnalysisEntities context = new FailureAnalysisEntities())
{
var assembly = context.MST_ReasonINIReport.Single(x => x.Id == entity.Id && x.IsDeleted == false);
assembly.IsDeleted = true;
context.Entry<MST_ReasonINIReport>(assembly).State = System.Data.Entity.EntityState.Modified;
result = context.SaveChanges() > 0 ? SaveResult.SUCCESS : SaveResult.FAILURE;
}
}
catch (Exception ex)
{
_logService.Error(ex.Message, ex);
result = SaveResult.FAILURE;
}
return result;
}
/// <summary>
/// Adds the range asynchronous.
/// </summary>
/// <param name="entities">The entities.</param>
/// <returns></returns>
public async Task<SaveResult> AddRangeAsync(IEnumerable<RecordLockDto> entities)
{
SaveResult result = SaveResult.FAILURE;
try
{
using (FailureAnalysisEntities context = new FailureAnalysisEntities())
{
foreach (var entity in entities)
{
FAR_RecordLock add = context.FAR_RecordLock.Create();
add.ProcessHistoryId = entity.ProcessHistoryId;
add.LockBy = entity.LockBy;
add.LockDate = entity.LockDate;
add.MasterId = entity.MasterId;
add.ReleaseDate = entity.ReleaseDate;
add.LastUpdatedBy = entity.LastUpdatedBy;
add.LastUpdate = DateTime.Now;
context.Entry<FAR_RecordLock>(add).State = System.Data.Entity.EntityState.Added;
}
result = await context.SaveChangesAsync() > 0 ? SaveResult.SUCESS : SaveResult.FAILURE;
}
}
catch (Exception ex)
{
_logService.Error(ex.Message, ex);
result = SaveResult.FAILURE;
}
return result;
}
/// <summary>
/// Adds the specified entity.
/// </summary>
/// <param name="entity">The entity.</param>
/// <returns></returns>
public SaveResult Add(FARInitialTargetLogDto entity)
{
SaveResult result = SaveResult.FAILURE;
try
{
using (FailureAnalysisEntities context = new FailureAnalysisEntities())
{
LOG_FARInitialTarget add = context.LOG_FARInitialTarget.Create();
add.TargetDate = entity.TargetDate;
add.ReasonId = entity.ReasonId;
add.IsDeleted = false;
add.MasterId = entity.MasterId;
add.LastUpdatedBy = entity.LastUpdatedBy;
add.LastUpdate = DateTime.Now;
context.Entry<LOG_FARInitialTarget>(add).State = System.Data.Entity.EntityState.Added;
result = context.SaveChanges() > 0 ? SaveResult.SUCCESS : SaveResult.FAILURE;
}
}
catch (Exception ex)
{
_logService.Error(ex.Message, ex);
result = SaveResult.FAILURE;
}
return result;
}
/// <summary>
/// Deletes the by asynchronous.
/// </summary>
/// <param name="id">The identifier.</param>
/// <returns></returns>
public async Task<SaveResult> DeleteByAsync(int id)
{
SaveResult result = SaveResult.FAILURE;
try
{
using (FailureAnalysisEntities context = new FailureAnalysisEntities())
{
var record = context.FAR_RecordLock.Single(x => x.Id == id && x.IsDeleted == false);
record.IsDeleted = true;
record.LastUpdate = DateTime.Now;
context.Entry<FAR_RecordLock>(record).State = System.Data.Entity.EntityState.Modified;
result = await context.SaveChangesAsync() > 0 ? SaveResult.SUCESS : SaveResult.FAILURE;
}
}
catch (Exception ex)
{
_logService.Error(ex.Message, ex);
result = SaveResult.FAILURE;
}
return result;
}
/// <summary>
/// Deletes the by.
/// </summary>
/// <param name="Id">The identifier.</param>
/// <returns></returns>
public SaveResult DeleteBy(int Id)
{
SaveResult result = SaveResult.FAILURE;
try
{
using (FailureAnalysisEntities context = new FailureAnalysisEntities())
{
var assembly = context.LOG_FARInitialTarget.Single(x => x.Id == Id && x.IsDeleted == false);
assembly.IsDeleted = true;
context.Entry<LOG_FARInitialTarget>(assembly).State = System.Data.Entity.EntityState.Modified;
result = context.SaveChanges() > 0 ? SaveResult.SUCCESS : SaveResult.FAILURE;
}
}
catch (Exception ex)
{
_logService.Error(ex.Message, ex);
result = SaveResult.FAILURE;
}
return result;
}
/// <summary>
/// Updates the asynchronous.
/// </summary>
/// <param name="entity">The entity.</param>
/// <returns></returns>
public async Task<SaveResult> UpdateAsync(FARUploadDto entity)
{
SaveResult result = SaveResult.FAILURE;
try
{
using (FailureAnalysisEntities context = new FailureAnalysisEntities())
{
var upload = context.LOG_FARUpload.Single(x => x.Id == entity.Id);
upload.FileName = entity.FileName;
upload.MasterId = entity.MasterId;
upload.ReasonId = entity.ReasonId;
upload.FAType = entity.FAType;
upload.UploadedBy = entity.UploadedBy;
upload.UploadedDate = DateTime.Now;
context.Entry<LOG_FARUpload>(upload).State = System.Data.Entity.EntityState.Modified;
result = await context.SaveChangesAsync() > 0 ? SaveResult.SUCCESS : SaveResult.FAILURE;
}
}
catch (Exception ex)
{
_logService.Error(ex.Message, ex);
result = SaveResult.FAILURE;
}
return result;
}
/// <summary>
/// Adds the specified entity.
/// </summary>
/// <param name="entity">The entity.</param>
/// <returns></returns>
public SaveResult Add(MSTServiceDto entity)
{
SaveResult result = SaveResult.FAILURE;
try
{
using (FailureAnalysisEntities context = new FailureAnalysisEntities())
{
MST_Services add = context.MST_Services.Create();
add.Description = entity.Description;
add.IsDeleted = false;
add.Name = entity.Name;
add.LastUpdatedBy = entity.LastUpdatedBy;
add.LastUpdate = DateTime.Now;
context.Entry<MST_Services>(add).State = System.Data.Entity.EntityState.Added;
result = context.SaveChanges() > 0 ? SaveResult.SUCCESS : SaveResult.FAILURE;
}
}
catch (Exception ex)
{
_logService.Error(ex.Message, ex);
result = SaveResult.FAILURE;
}
return result;
}
/// <summary>
/// Adds the specified entity.
/// </summary>
/// <param name="entity">The entity.</param>
/// <returns></returns>
public SaveResult Add(FARUploadDto entity)
{
SaveResult result = SaveResult.FAILURE;
try
{
using (FailureAnalysisEntities context = new FailureAnalysisEntities())
{
LOG_FARUpload add = context.LOG_FARUpload.Create();
add.FileName = entity.FileName;
add.MasterId = entity.MasterId;
add.ReasonId = entity.ReasonId;
add.FAType = entity.FAType;
add.UploadedBy = entity.UploadedBy;
add.UploadedDate = DateTime.Now;
context.Entry<LOG_FARUpload>(add).State = System.Data.Entity.EntityState.Added;
result = context.SaveChanges() > 0 ? SaveResult.SUCCESS : SaveResult.FAILURE;
}
}
catch (Exception ex)
{
_logService.Error(ex.Message, ex);
result = SaveResult.FAILURE;
}
return result;
}
/// <summary>
/// Deletes the by asynchronous.
/// </summary>
/// <param name="Id">The identifier.</param>
/// <returns></returns>
public async Task<SaveResult> DeleteByAsync(int Id)
{
SaveResult result = SaveResult.FAILURE;
try
{
using (FailureAnalysisEntities context = new FailureAnalysisEntities())
{
var assembly = context.MST_Services.Single(x => x.Id == Id && x.IsDeleted == false);
assembly.IsDeleted = true;
context.Entry<MST_Services>(assembly).State = System.Data.Entity.EntityState.Modified;
result = await context.SaveChangesAsync() > 0 ? SaveResult.SUCCESS : SaveResult.FAILURE;
}
}
catch (Exception ex)
{
_logService.Error(ex.Message, ex);
result = SaveResult.FAILURE;
}
return result;
}
/// <summary>
/// Deletes the specified entity.
/// </summary>
/// <param name="entity">The entity.</param>
/// <returns></returns>
public SaveResult Delete(MSTPriorityDto entity)
{
SaveResult result = SaveResult.FAILURE;
try
{
using (FailureAnalysisEntities context = new FailureAnalysisEntities())
{
var priority = context.MST_Priority.Single(x => x.Id == entity.Id && x.IsDeleted == false);
priority.IsDeleted = true;
priority.LastUpdate = DateTime.Now;
priority.LastUpdatedBy = entity.LastUpdatedBy;
context.Entry<MST_Priority>(priority).State = System.Data.Entity.EntityState.Modified;
result = context.SaveChanges() > 0 ? SaveResult.SUCCESS : SaveResult.FAILURE;
}
}
catch (Exception ex)
{
_logService.Error(ex.Message, ex);
result = SaveResult.FAILURE;
}
return result;
}
