public async Task Update(Marital_status entity) { try { //Update Old Marital_status var lstMarital_Status = adbContext.marital_status.Where(x => x.Id == entity.Id).FirstOrDefault(); if (lstMarital_Status != null) { lstMarital_Status.Marital_Status = entity.Marital_Status; lstMarital_Status.isActive = entity.isActive; lstMarital_Status.UpdatedBy = entity.UpdatedBy; lstMarital_Status.UpdatedOn = DateTime.Now; adbContext.marital_status.Update(lstMarital_Status); await Task.FromResult(adbContext.SaveChanges()); } else { throw new Exception("Data Not Available"); } } catch (Exception ex) { throw ex; } }
public async Task <IActionResult> Edit(Marital_status marital_status) { ResponseHelper objHelper = new ResponseHelper(); if (!ModelState.IsValid) { objHelper.Status = StatusCodes.Status424FailedDependency; objHelper.Message = "Invalid Model State"; return(BadRequest(objHelper)); } try { if (marital_StatusRepository.Exists(marital_status)) { objHelper.Status = StatusCodes.Status200OK; objHelper.Message = "Data already available"; return(Ok(objHelper)); } await marital_StatusRepository.Update(marital_status); objHelper.Status = StatusCodes.Status200OK; objHelper.Message = "Saved Successfully"; return(Ok(objHelper)); } catch { objHelper.Status = StatusCodes.Status500InternalServerError; objHelper.Message = "Save Unsuccessful"; return(StatusCode(StatusCodes.Status500InternalServerError, objHelper)); } }
public async Task Insert(Marital_status entity) { try { entity.AddedOn = DateTime.Now; adbContext.marital_status.Add(entity); await Task.FromResult(adbContext.SaveChanges()); } catch (Exception ex) { throw ex; } }
public bool Exists(Marital_status entity) { try { int intCount = 0; if (entity.Id > 0) //Update Validation { intCount = adbContext.marital_status.Where(w => w.Id != entity.Id && (w.Marital_Status == entity.Marital_Status)).Count(); } else //Insert Validation { intCount = adbContext.marital_status.Where(w => w.Marital_Status == entity.Marital_Status).Count(); } return(intCount > 0 ? true : false); } catch (Exception ex) { throw ex; } }