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