public bool UpdatePolicyCategory(PolicyCategoryVM policyCategoryVM)
{
using (var dbTransaction = unitOfWork.dbContext.Database.BeginTransaction())
{
try
{
tblPolicyCategory policyCategory = unitOfWork.TblPolicyCategoryRepository.GetByID(policyCategoryVM.PolicyCategoryID);
policyCategory.CategoryName = policyCategoryVM.PolicyCategoryName;
policyCategory.ModifiedDate = DateTime.Now;
policyCategory.ModifiedBy = policyCategoryVM.ModifiedBy;
unitOfWork.TblPolicyCategoryRepository.Update(policyCategory);
unitOfWork.Save();
//Complete the Transaction
dbTransaction.Commit();
return(true);
}
catch (Exception ex)
{
//Roll back the Transaction
dbTransaction.Rollback();
return(false);
}
}
}
public bool DeletePolicyCategory(int policyCategoryID)
{
using (var dbTransaction = unitOfWork.dbContext.Database.BeginTransaction())
{
try
{
tblPolicyCategory policyCategory = unitOfWork.TblPolicyCategoryRepository.GetByID(policyCategoryID);
unitOfWork.TblPolicyCategoryRepository.Delete(policyCategory);
unitOfWork.Save();
//Complete the Transaction
dbTransaction.Commit();
return(true);
}
catch (Exception ex)
{
//Roll back the Transaction
dbTransaction.Rollback();
return(false);
}
}
}
