public bool UpdateInsuranceCompany(InsuranceCompanyVM insuranceCompanyVM) { using (var dbTransaction = unitOfWork.dbContext.Database.BeginTransaction()) { try { tblInsCompany insCompany = unitOfWork.TblInsCompanyRepository.GetByID(insuranceCompanyVM.InsuranceCompanyID); insCompany.InsCompany = insuranceCompanyVM.InsuranceCompanyName; insCompany.BUID = insuranceCompanyVM.BusinessUnitID; insCompany.Address1 = insuranceCompanyVM.Address1; insCompany.Address2 = insuranceCompanyVM.Address2; insCompany.Address3 = insuranceCompanyVM.Address3; insCompany.ContactPerson = insuranceCompanyVM.ContactPerson; insCompany.ContactNo = insuranceCompanyVM.ContactNo; insCompany.Email = insuranceCompanyVM.Email; insCompany.Fax = insuranceCompanyVM.Fax; insCompany.ModifiedDate = DateTime.Now; insCompany.ModifiedBy = insuranceCompanyVM.ModifiedBy; unitOfWork.TblInsCompanyRepository.Update(insCompany); unitOfWork.Save(); //Complete the Transaction dbTransaction.Commit(); return(true); } catch (Exception ex) { //Roll back the Transaction dbTransaction.Rollback(); return(false); } } }
public IHttpActionResult UpdateInsuranceCompany([FromBody] JObject data) { try { int insCompanyID = !string.IsNullOrEmpty(data.SelectToken("insCompanyID").Value <string>()) ? Convert.ToInt32(data.SelectToken("insCompanyID").Value <string>()) : 0; int businessUnitID = !string.IsNullOrEmpty(data.SelectToken("businessUnitID").Value <string>()) ? Convert.ToInt32(data.SelectToken("businessUnitID").Value <string>()) : 0; string insCompanyName = !string.IsNullOrEmpty(data.SelectToken("insCompanyName").Value <string>()) ? data.SelectToken("insCompanyName").Value <string>() : string.Empty; string address1 = !string.IsNullOrEmpty(data.SelectToken("address1").Value <string>()) ? data.SelectToken("address1").Value <string>() : string.Empty; string address2 = !string.IsNullOrEmpty(data.SelectToken("address2").Value <string>()) ? data.SelectToken("address2").Value <string>() : string.Empty; string address3 = !string.IsNullOrEmpty(data.SelectToken("address3").Value <string>()) ? data.SelectToken("address3").Value <string>() : string.Empty; string contactPerson = !string.IsNullOrEmpty(data.SelectToken("contactPerson").Value <string>()) ? data.SelectToken("contactPerson").Value <string>() : string.Empty; string contactNo = !string.IsNullOrEmpty(data.SelectToken("contactNo").Value <string>()) ? data.SelectToken("contactNo").Value <string>() : string.Empty; string email = !string.IsNullOrEmpty(data.SelectToken("email").Value <string>()) ? data.SelectToken("email").Value <string>() : string.Empty; string fax = !string.IsNullOrEmpty(data.SelectToken("fax").Value <string>()) ? data.SelectToken("fax").Value <string>() : string.Empty; int userID = !string.IsNullOrEmpty(data.SelectToken("userID").Value <string>()) ? Convert.ToInt32(data.SelectToken("userID").Value <string>()) : 0; if (!manageInsCompany.IsInsCompanyAvailable(insCompanyID, insCompanyName)) { InsuranceCompanyVM insCompanyVM = new InsuranceCompanyVM(); insCompanyVM.InsuranceCompanyID = insCompanyID; insCompanyVM.BusinessUnitID = businessUnitID; insCompanyVM.InsuranceCompanyName = insCompanyName; insCompanyVM.Address1 = address1; insCompanyVM.Address2 = address2; insCompanyVM.Address3 = address3; insCompanyVM.ContactPerson = contactPerson; insCompanyVM.ContactNo = contactNo; insCompanyVM.Email = email; insCompanyVM.Fax = fax; insCompanyVM.ModifiedBy = userID; bool status = manageInsCompany.UpdateInsuranceCompany(insCompanyVM); if (status) { return(Json(new { status = true, message = "Successfully updated" })); } else { return(Json(new { status = false, message = "Update Failed" })); } } else { return(Json(new { status = false, message = "Insurance Company Name already exists" })); } } catch (Exception ex) { return(Json(new { status = false, message = "Unknown error occurred" })); } }
public dynamic PutInsurCompany(InsuranceCompanyVM i) { var insurcompany = db.InsuranceCompanies.Find(i.Id); insurcompany.NameA = i.NameA; insurcompany.NameE = i.NameE; var result = db.SaveChanges() > 0 ? true : false; return(new { result = result }); }
public dynamic PostInsurCompany(InsuranceCompanyVM i) { db.InsuranceCompanies.Add(new InsuranceCompany { NameA = i.NameA, NameE = i.NameE }); var result = db.SaveChanges() > 0 ? true : false; return(new { result = result }); }
public List <InsuranceCompanyVM> GetInsuranceCompaniesByBusinessUnitID(int businessUnitID) { try { var insuranceCompanyData = unitOfWork.TblInsCompanyRepository.Get(x => x.BUID == businessUnitID).ToList(); List <InsuranceCompanyVM> insuranceCompanyList = new List <InsuranceCompanyVM>(); foreach (var insuranceCompany in insuranceCompanyData) { InsuranceCompanyVM insuranceCompanyVM = new InsuranceCompanyVM(); insuranceCompanyVM.InsuranceCompanyID = insuranceCompany.InsCompanyID; insuranceCompanyVM.BusinessUnitID = insuranceCompany.BUID != null?Convert.ToInt32(insuranceCompany.BUID) : 0; if (insuranceCompanyVM.BusinessUnitID > 0) { insuranceCompanyVM.BusinessUnitName = insuranceCompany.tblBussinessUnit.BussinessUnit; } insuranceCompanyVM.InsuranceCompanyName = insuranceCompany.InsCompany; insuranceCompanyVM.Address1 = insuranceCompany.Address1; insuranceCompanyVM.Address2 = insuranceCompany.Address2; insuranceCompanyVM.Address3 = insuranceCompany.Address3; insuranceCompanyVM.ContactPerson = insuranceCompany.ContactPerson; insuranceCompanyVM.ContactNo = insuranceCompany.ContactNo; insuranceCompanyVM.Email = insuranceCompany.Email; insuranceCompanyVM.Fax = insuranceCompany.Fax; insuranceCompanyVM.CreatedDate = insuranceCompany.CreatedDate != null?insuranceCompany.CreatedDate.ToString() : string.Empty; insuranceCompanyVM.ModifiedDate = insuranceCompany.ModifiedDate != null?insuranceCompany.ModifiedDate.ToString() : string.Empty; insuranceCompanyVM.CreatedBy = insuranceCompany.CreatedBy != null?Convert.ToInt32(insuranceCompany.CreatedBy) : 0; insuranceCompanyVM.ModifiedBy = insuranceCompany.ModifiedBy != null?Convert.ToInt32(insuranceCompany.ModifiedBy) : 0; insuranceCompanyList.Add(insuranceCompanyVM); } return(insuranceCompanyList); } catch (Exception ex) { throw; } }
public InsuranceCompanyVM GetInsuranceCompanyByID(int insuranceCompanyID) { try { var insuranceCompanyData = unitOfWork.TblInsCompanyRepository.GetByID(insuranceCompanyID); InsuranceCompanyVM insuranceCompanyVM = new InsuranceCompanyVM(); insuranceCompanyVM.InsuranceCompanyID = insuranceCompanyData.InsCompanyID; insuranceCompanyVM.BusinessUnitID = insuranceCompanyData.BUID != null?Convert.ToInt32(insuranceCompanyData.BUID) : 0; if (insuranceCompanyVM.BusinessUnitID > 0) { insuranceCompanyVM.BusinessUnitName = insuranceCompanyData.tblBussinessUnit.BussinessUnit; } insuranceCompanyVM.InsuranceCompanyName = insuranceCompanyData.InsCompany; insuranceCompanyVM.Address1 = insuranceCompanyData.Address1; insuranceCompanyVM.Address2 = insuranceCompanyData.Address2; insuranceCompanyVM.Address3 = insuranceCompanyData.Address3; insuranceCompanyVM.ContactPerson = insuranceCompanyData.ContactPerson; insuranceCompanyVM.ContactNo = insuranceCompanyData.ContactNo; insuranceCompanyVM.Email = insuranceCompanyData.Email; insuranceCompanyVM.Fax = insuranceCompanyData.Fax; insuranceCompanyVM.CreatedDate = insuranceCompanyData.CreatedDate != null?insuranceCompanyData.CreatedDate.ToString() : string.Empty; insuranceCompanyVM.ModifiedDate = insuranceCompanyData.ModifiedDate != null?insuranceCompanyData.ModifiedDate.ToString() : string.Empty; insuranceCompanyVM.CreatedBy = insuranceCompanyData.CreatedBy != null?Convert.ToInt32(insuranceCompanyData.CreatedBy) : 0; insuranceCompanyVM.ModifiedBy = insuranceCompanyData.ModifiedBy != null?Convert.ToInt32(insuranceCompanyData.ModifiedBy) : 0; return(insuranceCompanyVM); } catch (Exception ex) { throw; } }