public IEnumerable <RulesIndex> GetRulesIndex(RulesIndex rulesIndex)
{
using (DemsifyEntities dataContext = new DemsifyEntities())
{
ObjectParameter totalPageCount = new ObjectParameter("TotalPageCount", typeof(int));
ObjectParameter totalRecord = new ObjectParameter("TotalRecord", typeof(int));
var rulesIndexes = dataContext.RulesIndexGet(rulesIndex.IndexId, rulesIndex.RulesId, Utility.TrimString(rulesIndex.SearchText), rulesIndex.IsActive, rulesIndex.PageNumber, rulesIndex.PageSize, rulesIndex.IsPagingRequired, Utility.TrimString(rulesIndex.OrderBy), Utility.TrimString(rulesIndex.OrderByDirection), totalPageCount, totalRecord).ToList();
var rulesIndexList = new List <RulesIndex>();
foreach (var rulesIndexDetail in rulesIndexes)
{
rulesIndexList.Add(new RulesIndex()
{
IndexId = rulesIndexDetail.Indexid,
RulesId = rulesIndexDetail.RuleID,
IndexNo = rulesIndexDetail.IndexNo,
IndexName = rulesIndexDetail.Indexname,
IndexContent = rulesIndexDetail.IndexContent,
SortId = rulesIndexDetail.SortId,
IsActive = rulesIndexDetail.Isactive,
TotalPageCount = Convert.ToInt32(totalPageCount.Value),
TotalRecord = Convert.ToInt32(totalRecord.Value)
});
}
return(rulesIndexList);
}
}
public IHttpActionResult UpdateRulesIndex(UpdateRulesIndexRequest updateRulesIndexRequest)
{
var responses = new Responses();
try
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (Utility.UserId < 0)
{
return(BadRequest(Utility.INVALID_USER));
}
var rulesIndex = new RulesIndex()
{
IndexId = updateRulesIndexRequest.IndexId,
RulesId = updateRulesIndexRequest.RulesId,
IndexNo = updateRulesIndexRequest.IndexNo,
IndexName = updateRulesIndexRequest.IndexName,
IndexContent = updateRulesIndexRequest.IndexContent,
SaveAfterIndexId = updateRulesIndexRequest.SaveAfterIndexId,
ModifiedBy = Utility.UserId
};
int result = iRulesIndex.UpdateRulesIndex(rulesIndex);
switch (result)
{
case 1:
responses.Status = Utility.SUCCESS_STATUS_RESPONSE;
responses.Description = "RulesIndex updated successfully.";
break;
case -2:
responses.Status = Utility.ERROR_STATUS_RESPONSE;
responses.Description = "RulesIndex already exists.";
break;
case -3:
responses.Status = Utility.ERROR_STATUS_RESPONSE;
responses.Description = "RulesIndex doesn't exist.";
break;
default:
responses.Status = Utility.ERROR_STATUS_RESPONSE;
responses.Description = "Error while updating RulesIndex.";
break;
}
}
catch (Exception ex)
{
responses.Status = Utility.ERROR_STATUS_RESPONSE;
responses.Description = "Error while updating RulesIndex.";
Utility.WriteLog("UpdateRulesIndex", updateRulesIndexRequest, "Error while updating RulesIndex. (RulesIndexAdminController)", ex.ToString());
}
return(Ok(responses));
}
public int DeleteRulesIndex(RulesIndex rulesIndex)
{
using (DemsifyEntities dataContext = new DemsifyEntities())
{
ObjectParameter result = new ObjectParameter("Result", typeof(int));
dataContext.RulesIndexDelete(rulesIndex.IndexId, rulesIndex.RulesId, rulesIndex.ModifiedBy, result);
return(Convert.ToInt32(result.Value));
}
}
public int UpdateRulesIndex(RulesIndex rulesIndex)
{
using (DemsifyEntities dataContext = new DemsifyEntities())
{
ObjectParameter result = new ObjectParameter("Result", typeof(int));
dataContext.RulesIndexUpdate(rulesIndex.IndexId, rulesIndex.RulesId, Utility.TrimString(rulesIndex.IndexNo), Utility.TrimString(rulesIndex.IndexName), Utility.TrimString(rulesIndex.IndexContent), rulesIndex.SaveAfterIndexId, rulesIndex.ModifiedBy, result);
return(Convert.ToInt32(result.Value));
}
}
public IHttpActionResult AddRulesIndex(AddRulesIndexRequest addRulesIndexRequest)
{
var responses = new Responses();
try
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
var rulesIndex = new RulesIndex()
{
RulesId = addRulesIndexRequest.RulesId,
IndexNo = addRulesIndexRequest.IndexNo,
IndexName = addRulesIndexRequest.IndexName,
IndexContent = addRulesIndexRequest.IndexContent,
SaveAfterIndexId = addRulesIndexRequest.SaveAfterIndexId,
CreatedBy = Utility.UserId
};
int result = iRulesIndex.AddRulesIndex(rulesIndex);
if (result > 0)
{
responses.Status = Utility.SUCCESS_STATUS_RESPONSE;
responses.Description = "RulesIndex added successfully.";
}
else if (result == -2)
{
responses.Status = Utility.ERROR_STATUS_RESPONSE;
responses.Description = "RulesIndex alread exists.";
}
else
{
responses.Status = Utility.ERROR_STATUS_RESPONSE;
responses.Description = "Error while adding RulesIndex.";
}
}
catch (Exception ex)
{
responses.Status = Utility.ERROR_STATUS_RESPONSE;
responses.Description = "Error while adding RulesIndex.";
Utility.WriteLog("AddRulesIndex", addRulesIndexRequest, "Error while adding RulesIndex. (RulesIndexAdminController)", ex.ToString());
}
return(Ok(responses));
}
public async Task <bool> Save()
{
//if GroupID found - update it
var Group = ctx.BillingRulesGroup.Where(w => w.GroupID == GroupID).FirstOrDefault();
if (Group == null)
{
Group = new Models.BillingRulesGroup {
GroupName = GroupName
};
ctx.BillingRulesGroup.Add(Group);
}
else
{
Group.GroupName = GroupName;
ctx.Entry(Group).State = EntityState.Modified;
}
await ctx.SaveChangesAsync();
//Delete the rules specified in Database first
await ctx.Database.ExecuteSqlCommandAsync("DELETE FROM BillingRulesCost WHERE GroupID = {0}", GroupID);
//Save Billing Rules
var RuleIDs = RulesIndex.Split(',').Select(s => int.Parse(s)).ToList();
foreach (var rule in Rule)
{
var Seq = RuleIDs.IndexOf(rule.RuleID) * 10;
var dbRule = new Models.BillingRulesCost {
RuleID = rule.RuleID,
Seq = Seq,
GroupID = Group.GroupID,
CostDividedBy = rule.CostDividedBy,
CostMultipliedBy = rule.CostMultipliedBy,
IsSkipRest = (rule.IsActive ? (byte)0 : (byte)1)
};
ctx.BillingRulesCost.Add(dbRule);
}
await ctx.SaveChangesAsync();
return(true);
}
public IHttpActionResult GetRulesIndex([FromUri] GetRulesIndexRequest getRulesIndexRequest)
{
var responses = new Responses();
try
{
if (Utility.UserId < 0)
{
return(BadRequest(Utility.INVALID_USER));
}
if (getRulesIndexRequest == null)
{
getRulesIndexRequest = new GetRulesIndexRequest();
}
if (getRulesIndexRequest.PageSize == null)
{
getRulesIndexRequest.PageSize = Convert.ToInt32(ConfigurationManager.AppSettings["PageSize"]);
}
var rulesIndex = new RulesIndex()
{
IndexId = getRulesIndexRequest.IndexId,
RulesId = getRulesIndexRequest.RulesId,
SearchText = getRulesIndexRequest.SearchText,
IsActive = getRulesIndexRequest.IsActive,
PageNumber = getRulesIndexRequest.PageNumber,
PageSize = Convert.ToInt32(getRulesIndexRequest.PageSize),
IsPagingRequired = (getRulesIndexRequest.PageNumber != null) ? true : false,
OrderBy = getRulesIndexRequest.OrderBy,
OrderByDirection = getRulesIndexRequest.OrderByDirection
};
var rulesIndexes = iRulesIndex.GetRulesIndex(rulesIndex).OrderBy(x => x.SortId).ToList();
var rulesIndexList = new List <GetRulesIndexResponse>();
foreach (var rulesIndexDetail in rulesIndexes)
{
rulesIndexList.Add(new GetRulesIndexResponse()
{
IndexId = Convert.ToInt32(rulesIndexDetail.IndexId),
RulesId = Convert.ToInt32(rulesIndexDetail.RulesId),
IndexNo = rulesIndexDetail.IndexNo,
IndexName = rulesIndexDetail.IndexName,
IndexContent = rulesIndexDetail.IndexContent,
SortId = rulesIndexDetail.SortId,
IsActive = Convert.ToBoolean(rulesIndexDetail.IsActive),
CreatedBy = rulesIndexDetail.CreatedBy,
TotalPageCount = rulesIndexDetail.TotalPageCount,
TotalRecord = rulesIndexDetail.TotalRecord
});
}
responses.Status = Utility.SUCCESS_STATUS_RESPONSE;
responses.Description = "RulesIndex retrieved successfully";
responses.Response = rulesIndexList;
}
catch (Exception ex)
{
responses.Status = Utility.ERROR_STATUS_RESPONSE;
responses.Description = "Error while retrieving RulesIndex.";
Utility.WriteLog("GetRulesIndex", getRulesIndexRequest, "Error while retrieving RulesIndex. (RulesOfFEMASubModuleDetailUserController)", ex.ToString());
}
return(Ok(responses));
}
