public bool UpdateCommonInsScope(CommonInsuranceScopeVM commonInsuranceScopeVM) { using (var dbTransaction = unitOfWork.dbContext.Database.BeginTransaction()) { try { tblCommonInsScope commonInsScope = unitOfWork.TblCommonInsScopeRepository.GetByID(commonInsuranceScopeVM.CommonInsuranceScopeID); commonInsScope.Description = commonInsuranceScopeVM.Description; commonInsScope.InsClassID = commonInsuranceScopeVM.InsuranceClassID; commonInsScope.InsSubClassID = commonInsuranceScopeVM.InsuranceSubClassID; commonInsScope.ModifiedDate = DateTime.Now; commonInsScope.ModifiedBy = commonInsuranceScopeVM.ModifiedBy; unitOfWork.TblCommonInsScopeRepository.Update(commonInsScope); unitOfWork.Save(); //Complete the Transaction dbTransaction.Commit(); return(true); } catch (Exception ex) { //Roll back the Transaction dbTransaction.Rollback(); return(false); } } }
public IHttpActionResult UpdateCommonInsScope([FromBody] JObject data) { try { int commonInsScopeID = !string.IsNullOrEmpty(data.SelectToken("CommonInsScopeID").Value <string>()) ? Convert.ToInt32(data.SelectToken("CommonInsScopeID").Value <string>()) : 0; string description = !string.IsNullOrEmpty(data.SelectToken("Description").Value <string>()) ? data.SelectToken("Description").Value <string>() : string.Empty; int insClassID = !string.IsNullOrEmpty(data.SelectToken("InsClassID").Value <string>()) ? Convert.ToInt32(data.SelectToken("InsClassID").Value <string>()) : 0; int insSubClassID = !string.IsNullOrEmpty(data.SelectToken("InsSubClassID").Value <string>()) ? Convert.ToInt32(data.SelectToken("InsSubClassID").Value <string>()) : 0; int userID = !string.IsNullOrEmpty(data.SelectToken("UserID").Value <string>()) ? Convert.ToInt32(data.SelectToken("UserID").Value <string>()) : 0; CommonInsuranceScopeVM commonInsuranceScopeVM = new CommonInsuranceScopeVM(); commonInsuranceScopeVM.CommonInsuranceScopeID = commonInsScopeID; commonInsuranceScopeVM.Description = description; commonInsuranceScopeVM.InsuranceClassID = insClassID; commonInsuranceScopeVM.InsuranceSubClassID = insSubClassID; commonInsuranceScopeVM.ModifiedBy = userID; bool status = manageCommonInsScope.UpdateCommonInsScope(commonInsuranceScopeVM); if (status) { return(Json(new { status = true, message = "Successfully updated" })); } else { return(Json(new { status = false, message = "Update Failed" })); } } catch (Exception ex) { return(Json(new { status = false, message = "Unknown error occurred" })); } }
public List <CommonInsuranceScopeVM> GetAllCommonInsScopes() { try { var commonInsScopeData = unitOfWork.TblCommonInsScopeRepository.Get().ToList(); List <CommonInsuranceScopeVM> commonInsScopeList = new List <CommonInsuranceScopeVM>(); foreach (var commonInsScope in commonInsScopeData) { CommonInsuranceScopeVM commonInsuranceScopeVM = new CommonInsuranceScopeVM(); commonInsuranceScopeVM.CommonInsuranceScopeID = commonInsScope.CommonInsScopeID; commonInsuranceScopeVM.Description = commonInsScope.Description; commonInsuranceScopeVM.InsuranceClassID = commonInsScope.InsClassID != null?Convert.ToInt32(commonInsScope.InsClassID) : 0; if (commonInsuranceScopeVM.InsuranceClassID > 0) { commonInsuranceScopeVM.InsuranceClassCode = commonInsScope.tblInsClass.Code; } commonInsuranceScopeVM.InsuranceSubClassID = commonInsScope.InsSubClassID != null?Convert.ToInt32(commonInsScope.InsSubClassID) : 0; if (commonInsuranceScopeVM.InsuranceSubClassID > 0) { commonInsuranceScopeVM.InsuranceSubClassName = commonInsScope.tblInsSubClass.Description; } commonInsuranceScopeVM.CreatedDate = commonInsScope.CreatedDate != null?commonInsScope.CreatedDate.ToString() : string.Empty; commonInsuranceScopeVM.ModifiedDate = commonInsScope.ModifiedDate != null?commonInsScope.ModifiedDate.ToString() : string.Empty; commonInsuranceScopeVM.CreatedBy = commonInsScope.CreatedBy != null?Convert.ToInt32(commonInsScope.CreatedBy) : 0; commonInsuranceScopeVM.ModifiedBy = commonInsScope.ModifiedBy != null?Convert.ToInt32(commonInsScope.ModifiedBy) : 0; commonInsScopeList.Add(commonInsuranceScopeVM); } return(commonInsScopeList); } catch (Exception ex) { throw; } }
public CommonInsuranceScopeVM GetCommonInsScopeByID(int commonInsScopeID) { try { var commonInsScopeData = unitOfWork.TblCommonInsScopeRepository.GetByID(commonInsScopeID); CommonInsuranceScopeVM commonInsuranceScopeVM = new CommonInsuranceScopeVM(); commonInsuranceScopeVM.CommonInsuranceScopeID = commonInsScopeData.CommonInsScopeID; commonInsuranceScopeVM.Description = commonInsScopeData.Description; commonInsuranceScopeVM.InsuranceClassID = commonInsScopeData.InsClassID != null?Convert.ToInt32(commonInsScopeData.InsClassID) : 0; if (commonInsuranceScopeVM.InsuranceClassID > 0) { commonInsuranceScopeVM.InsuranceClassCode = commonInsScopeData.tblInsClass.Code; } commonInsuranceScopeVM.InsuranceSubClassID = commonInsScopeData.InsSubClassID != null?Convert.ToInt32(commonInsScopeData.InsSubClassID) : 0; if (commonInsuranceScopeVM.InsuranceSubClassID > 0) { commonInsuranceScopeVM.InsuranceSubClassName = commonInsScopeData.tblInsSubClass.Description; } commonInsuranceScopeVM.CreatedDate = commonInsScopeData.CreatedDate != null?commonInsScopeData.CreatedDate.ToString() : string.Empty; commonInsuranceScopeVM.ModifiedDate = commonInsScopeData.ModifiedDate != null?commonInsScopeData.ModifiedDate.ToString() : string.Empty; commonInsuranceScopeVM.CreatedBy = commonInsScopeData.CreatedBy != null?Convert.ToInt32(commonInsScopeData.CreatedBy) : 0; commonInsuranceScopeVM.ModifiedBy = commonInsScopeData.ModifiedBy != null?Convert.ToInt32(commonInsScopeData.ModifiedBy) : 0; return(commonInsuranceScopeVM); } catch (Exception ex) { throw; } }