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