public List <RateCategoryVM> GetAllRateCategories()
{
try
{
var rateCategoryData = unitOfWork.TblRateCategoryRepository.Get().ToList();
List <RateCategoryVM> rateCategoryList = new List <RateCategoryVM>();
foreach (var rateCategory in rateCategoryData)
{
RateCategoryVM rateCategoryVM = new RateCategoryVM();
rateCategoryVM.RateCategoryID = rateCategory.RateCategoryID;
rateCategoryVM.RateCategoryName = rateCategory.RateCategory;
rateCategoryVM.CreatedDate = rateCategory.CreatedDate != null?rateCategory.CreatedDate.ToString() : string.Empty;
rateCategoryVM.ModifiedDate = rateCategory.ModifiedDate != null?rateCategory.ModifiedDate.ToString() : string.Empty;
rateCategoryVM.CreatedBy = rateCategory.CreatedBy != null?Convert.ToInt32(rateCategory.CreatedBy) : 0;
rateCategoryVM.ModifiedBy = rateCategory.ModifiedBy != null?Convert.ToInt32(rateCategory.ModifiedBy) : 0;
rateCategoryList.Add(rateCategoryVM);
}
return(rateCategoryList);
}
catch (Exception ex)
{
throw;
}
}
public bool UpdateRateCategory(RateCategoryVM rateCategoryVM)
{
using (var dbTransaction = unitOfWork.dbContext.Database.BeginTransaction())
{
try
{
tblRateCategory rateCategory = unitOfWork.TblRateCategoryRepository.GetByID(rateCategoryVM.RateCategoryID);
rateCategory.RateCategory = rateCategoryVM.RateCategoryName;
rateCategory.ModifiedDate = DateTime.Now;
rateCategory.ModifiedBy = rateCategoryVM.ModifiedBy;
unitOfWork.TblRateCategoryRepository.Update(rateCategory);
unitOfWork.Save();
//Complete the Transaction
dbTransaction.Commit();
return(true);
}
catch (Exception ex)
{
//Roll back the Transaction
dbTransaction.Rollback();
return(false);
}
}
}
public IHttpActionResult SaveRateCategory([FromBody] JObject data)
{
try
{
string rateCategory = !string.IsNullOrEmpty(data.SelectToken("RateCategory").Value <string>()) ? data.SelectToken("RateCategory").Value <string>() : string.Empty;
int userID = !string.IsNullOrEmpty(data.SelectToken("UserID").Value <string>()) ? Convert.ToInt32(data.SelectToken("UserID").Value <string>()) : 0;
if (!manageRateCategory.IsRateCategoryAvailable(null, rateCategory))
{
RateCategoryVM rateCategoryVM = new RateCategoryVM();
rateCategoryVM.RateCategoryName = rateCategory;
rateCategoryVM.CreatedBy = userID;
bool status = manageRateCategory.SaveRateCategory(rateCategoryVM);
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 = "Rate Category Name already exists" }));
}
}
catch (Exception ex)
{
return(Json(new { status = false, message = "Unknown error occurred" }));
}
}
public RateCategoryVM GetRateCategoryByID(int rateCategoryID)
{
try
{
var rateCategoryData = unitOfWork.TblRateCategoryRepository.GetByID(rateCategoryID);
RateCategoryVM rateCategoryVM = new RateCategoryVM();
rateCategoryVM.RateCategoryID = rateCategoryData.RateCategoryID;
rateCategoryVM.RateCategoryName = rateCategoryData.RateCategory;
rateCategoryVM.CreatedDate = rateCategoryData.CreatedDate != null?rateCategoryData.CreatedDate.ToString() : string.Empty;
rateCategoryVM.ModifiedDate = rateCategoryData.ModifiedDate != null?rateCategoryData.ModifiedDate.ToString() : string.Empty;
rateCategoryVM.CreatedBy = rateCategoryData.CreatedBy != null?Convert.ToInt32(rateCategoryData.CreatedBy) : 0;
rateCategoryVM.ModifiedBy = rateCategoryData.ModifiedBy != null?Convert.ToInt32(rateCategoryData.ModifiedBy) : 0;
return(rateCategoryVM);
}
catch (Exception ex)
{
throw;
}
}
