public int UpdateHouseAddress(HouseAddressViewModel model)
        {
            try
            {
                var recordToUpdateInDb = dbContext.TblHouseAddress.Where(x => x.Id == model.HouseId).FirstOrDefault();
                if (recordToUpdateInDb != null)
                {
                    var duplicateNameRecord = dbContext.TblHouseAddress.Where(x => x.Id != model.HouseId &&
                                                                              x.HouseNo == model.HouseNo &&
                                                                              x.SectorId == model.SectorID).FirstOrDefault();

                    if (duplicateNameRecord != null)
                    {
                        return(0);
                    }
                    else
                    {
                        recordToUpdateInDb.HouseNo  = model.HouseNo;
                        recordToUpdateInDb.SectorId = model.SectorID;
                        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(UpdateHouseAddress)}", stackTrace: ex.StackTrace);
                return(0);
            }
        }
예제 #2
0
 public IActionResult UpdateHouseAddress(HouseAddressViewModel model)
 {
     try
     {
         return(Ok(fp.UpdateHouseAddress(model)));
     }
     catch (Exception ex)
     {
         Exceptions(ex);
         return(StatusCode(500));
     }
 }
 public int UpdateHouseAddress(HouseAddressViewModel model)
 {
     try
     {
         return(file.UpdateHouseAddress(model));
     }
     catch (Exception ex)
     {
         StaticHelper.LogException(path: up.GetLogFilePath(), errorMessage: ex.Message, methodName: $"Class Name: {nameof(FilePresenter)} - Method name:  {nameof(UpdateHouseAddress)}", stackTrace: ex.StackTrace);
         return(0);
     }
 }