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); } }