public int UpdateSector(TblSectors model)
{
try
{
var recordToUpdateInDb = dbContext.TblSectors.Where(x => x.Id == model.Id).FirstOrDefault();
if (recordToUpdateInDb != null)
{
var duplicateNameRecord = dbContext.TblSectors.Where(x => x.Id != model.Id && x.SectorNo == model.SectorNo).FirstOrDefault();
if (duplicateNameRecord != null)
{
return(0);
}
else
{
recordToUpdateInDb.SectorNo = model.SectorNo;
return(dbContext.SaveChanges());
}
}
else
{
return(0);
}
}
catch (Exception ex)
{
StaticHelper.LogException(path: up.GetLogFilePath(), errorMessage: ex.Message, methodName: $"Repository name: {nameof(FileRepository)} - Method name: {nameof(UpdateSector)}", stackTrace: ex.StackTrace);
return(0);
}
}
public IActionResult UpdateSector(TblSectors model)
{
try
{
return(Ok(fp.UpdateSector(model)));
}
catch (Exception ex)
{
Exceptions(ex);
return(StatusCode(500));
}
}
public int UpdateSector(TblSectors model)
{
try
{
return(file.UpdateSector(model));
}
catch (Exception ex)
{
StaticHelper.LogException(path: up.GetLogFilePath(), errorMessage: ex.Message, methodName: $"Class Name: {nameof(FilePresenter)} - Method name: {nameof(UpdateSector)}", stackTrace: ex.StackTrace);
return(0);
}
}
public int CreateNewSector(TblSectors model)
{
try
{
var count = dbContext.TblSectors.Where(x => x.SectorNo == model.SectorNo).FirstOrDefault();
if (count == null)
{
dbContext.Add(model);
return(dbContext.SaveChanges());
}
else
{
return(0);
}
}
catch (Exception ex)
{
StaticHelper.LogException(path: up.GetLogFilePath(), errorMessage: ex.Message, methodName: $"Repository name: {nameof(FileRepository)} - Method name: {nameof(CreateNewSector)}", stackTrace: ex.StackTrace);
return(0);
}
}
