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;
}
}
