public async Task <IActionResult> Edit(Employee_Address employee_Address) { ResponseHelper objHelper = new ResponseHelper(); if (!ModelState.IsValid) { objHelper.Status = StatusCodes.Status424FailedDependency; objHelper.Message = "Invalid Model State"; return(BadRequest(objHelper)); } try { if (employee_AddressRepository.Exists(employee_Address)) { objHelper.Status = StatusCodes.Status200OK; objHelper.Message = "Data already available"; return(Ok(objHelper)); } await employee_AddressRepository.Update(employee_Address); objHelper.Status = StatusCodes.Status200OK; objHelper.Message = "Saved Successfully"; return(Ok(objHelper)); } catch { objHelper.Status = StatusCodes.Status500InternalServerError; objHelper.Message = "Get Unsuccessful"; return(StatusCode(StatusCodes.Status500InternalServerError, objHelper)); } }
public async Task Insert(Employee_Address entity) { try { entity.AddedOn = DateTime.Now; adbContext.employee_address.Add(entity); await Task.FromResult(adbContext.SaveChanges()); } catch (Exception ex) { throw ex; } }
public bool Exists(Employee_Address entity) { try { int intCount = 0; if (entity.Emp_Address_Id > 0) //Update Validation { intCount = adbContext.employee_address.Where(w => w.Emp_Address_Id != entity.Emp_Address_Id && w.Emp_Id == entity.Emp_Id && w.Address1 == entity.Address1 && w.Address2 == entity.Address2 && w.Address3 == entity.Address3 && w.Address4 == entity.Address4).Count(); } else //Insert Validation { intCount = adbContext.employee_address.Where(w => w.Address1 == entity.Address1 && w.Address2 == entity.Address2 && w.Address3 == entity.Address3 && w.Address4 == entity.Address4).Count(); } return(intCount > 0 ? true : false); } catch (Exception ex) { throw ex; } }
public async Task Update(Employee_Address entity) { try { //Update Old Department var vList = adbContext.employee_address.Where(w => w.Emp_Id == entity.Emp_Id).FirstOrDefault(); if (vList != null) { vList.Emp_Id = entity.Emp_Id; vList.Address_Type = entity.Address_Type; vList.Address1 = entity.Address1; vList.Address2 = entity.Address2; vList.Address3 = entity.Address3; vList.Address4 = entity.Address4; vList.PostCode = entity.PostCode; vList.City = entity.City; vList.State = entity.State; vList.Country = entity.Country; vList.LandlineNo = entity.LandlineNo; vList.isDefault = entity.isDefault; vList.Emp_Doc_Id = entity.Emp_Doc_Id; vList.isActive = entity.isActive; vList.UpdatedBy = entity.UpdatedBy; vList.UpdatedOn = DateTime.Now; adbContext.employee_address.Update(vList); await Task.FromResult(adbContext.SaveChanges()); } else { throw new Exception("Data Not Available"); } } catch (Exception ex) { throw ex; } }