public List <PolicyCategoryVM> GetAllPolicyCategories()
{
try
{
var policyCategoryData = unitOfWork.TblPolicyCategoryRepository.Get().ToList();
List <PolicyCategoryVM> policyCategoryList = new List <PolicyCategoryVM>();
foreach (var policyCategory in policyCategoryData)
{
PolicyCategoryVM policyCategoryVM = new PolicyCategoryVM();
policyCategoryVM.PolicyCategoryID = policyCategory.PolicyCategoryID;
policyCategoryVM.PolicyCategoryName = policyCategory.CategoryName;
policyCategoryVM.CreatedDate = policyCategory.CreatedDate != null?policyCategory.CreatedDate.ToString() : string.Empty;
policyCategoryVM.ModifiedDate = policyCategory.ModifiedDate != null?policyCategory.ModifiedDate.ToString() : string.Empty;
policyCategoryVM.CreatedBy = policyCategory.CreatedBy != null?Convert.ToInt32(policyCategory.CreatedBy) : 0;
policyCategoryVM.ModifiedBy = policyCategory.ModifiedBy != null?Convert.ToInt32(policyCategory.ModifiedBy) : 0;
policyCategoryList.Add(policyCategoryVM);
}
return(policyCategoryList);
}
catch (Exception ex)
{
throw;
}
}
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 IHttpActionResult SavePolicyCategrory([FromBody] JObject data)
{
try
{
string categoryName = !string.IsNullOrEmpty(data.SelectToken("CategoryName").Value <string>()) ? data.SelectToken("CategoryName").Value <string>() : string.Empty;
int userID = !string.IsNullOrEmpty(data.SelectToken("UserID").Value <string>()) ? Convert.ToInt32(data.SelectToken("UserID").Value <string>()) : 0;
if (!managePolicy.IsPolicyCategoryAvailable(null, categoryName))
{
PolicyCategoryVM policyCategoryVM = new PolicyCategoryVM();
policyCategoryVM.PolicyCategoryName = categoryName;
policyCategoryVM.CreatedBy = userID;
bool status = managePolicy.SavePolicyCategory(policyCategoryVM);
if (status)
{
return(Json(new { status = true, message = "Successfully Saved" }));
}
else
{
return(Json(new { status = false, message = "Save Failed" }));
}
}
else
{
return(Json(new { status = false, message = "Policy Category Name already exists" }));
}
}
catch (Exception ex)
{
return(Json(new { status = false, message = "Unknown error occurred" }));
}
}
public PolicyCategoryVM GetPolicyCategoryByID(int policyCategoryID)
{
try
{
var policyCategoryData = unitOfWork.TblPolicyCategoryRepository.GetByID(policyCategoryID);
PolicyCategoryVM policyCategoryVM = new PolicyCategoryVM();
policyCategoryVM.PolicyCategoryID = policyCategoryData.PolicyCategoryID;
policyCategoryVM.PolicyCategoryName = policyCategoryData.CategoryName;
policyCategoryVM.CreatedDate = policyCategoryData.CreatedDate != null?policyCategoryData.CreatedDate.ToString() : string.Empty;
policyCategoryVM.ModifiedDate = policyCategoryData.ModifiedDate != null?policyCategoryData.ModifiedDate.ToString() : string.Empty;
policyCategoryVM.CreatedBy = policyCategoryData.CreatedBy != null?Convert.ToInt32(policyCategoryData.CreatedBy) : 0;
policyCategoryVM.ModifiedBy = policyCategoryData.ModifiedBy != null?Convert.ToInt32(policyCategoryData.ModifiedBy) : 0;
return(policyCategoryVM);
}
catch (Exception ex)
{
throw;
}
}
