public virtual ActionResult BrnIssueList(DataSourceRequest command, DqquebrnListModel model, string sort, string sortDir) { DateTime?startDateValue = (model.CreatedOnFrom == null) ? null : (DateTime?)model.CreatedOnFrom.Value; DateTime?endDateValue = (model.CreatedOnTo == null) ? null : (DateTime?)model.CreatedOnTo.Value.AddDays(1); //startDateValue, endDateValue, IssueStatus?issueStatus = model.STATUS_CODE > 0 ? (IssueStatus?)(model.STATUS_CODE) : null; var identity = ((CustomPrincipal)User).CustomIdentity; int catalogId = model.CATALOG_ID; //var routeValues = System.Web.HttpContext.Current.Request.RequestContext.RouteData.Values; ////RouteValueDictionary routeValues; //int catalogId = 1; //if (routeValues.ContainsKey("id")) // catalogId = int.Parse((string)routeValues["id"]); //if (Session["CATALOG_ID"] != null) // catalogId = Convert.ToInt32(Session["CATALOG_ID"]); //else // catalogId = model.CATALOG_ID; int[] corpCatalogs = { 61, 11, 12, 5, 21 }; if (corpCatalogs.Contains(catalogId)) { var items = _dqQueService.GetAllCorpQueIssues(model.SearchName, catalogId, model.CUST_ID, model.RULE_ID, model.BRANCH_CODE, issueStatus, model.PRIORITY_CODE, command.Page - 1, command.PageSize, string.Format("{0} {1}", sort, sortDir)); var gridModel = new DataSourceResult { Data = items.Select(x => new DqquebrnListModel { CUST_ID = x.CUST_ID, RULE_NAME = x.RULE_NAME, ISSUE_STATUS_DESC = x.MdmDQQueStatuses.STATUS_DESCRIPTION, ISSUE_PRIORITY_DESC = x.MdmDQPriorities.PRIORITY_DESCRIPTION, RUN_DATE = x.RUN_DATE, BRANCH_CODE = x.BRANCH_CODE, BRANCH_NAME = x.BRANCH_NAME, CREATED_DATE = x.CREATED_DATE, PRIORITY_CODE = x.ISSUE_PRIORITY, STATUS_CODE = x.ISSUE_STATUS, TIER = x.TIER, REASON = x.REASON, CATALOG_ID = x.CATALOG_ID, CATALOG_TABLE_NAME = x.CATALOG_TABLE_NAME, AUTH_REJECT_REASON = x.AUTH_REJECT_REASON }), Total = items.TotalCount }; return(Json(gridModel)); } else { var items = _dqQueService.GetAllBrnQueIssues(model.SearchName, catalogId, model.CUST_ID, model.RULE_ID, model.BRANCH_CODE, issueStatus, model.PRIORITY_CODE, model.TIER, command.Page - 1, command.PageSize, string.Format("{0} {1}", sort, sortDir)); var gridModel = new DataSourceResult { Data = items.Select(x => new DqquebrnListModel { CUST_ID = x.CUST_ID, RULE_NAME = x.RULE_NAME, ISSUE_STATUS_DESC = x.MdmDQQueStatuses.STATUS_DESCRIPTION, ISSUE_PRIORITY_DESC = x.MdmDQPriorities.PRIORITY_DESCRIPTION, RUN_DATE = x.RUN_DATE, BRANCH_CODE = x.BRANCH_CODE, BRANCH_NAME = x.BRANCH_NAME, CREATED_DATE = x.CREATED_DATE, PRIORITY_CODE = x.ISSUE_PRIORITY, STATUS_CODE = x.ISSUE_STATUS, TIER = x.TIER, REASON = x.REASON, CATALOG_ID = x.CATALOG_ID, CATALOG_TABLE_NAME = x.CATALOG_TABLE_NAME, AUTH_REJECT_REASON = x.AUTH_REJECT_REASON }), Total = items.TotalCount }; return(Json(gridModel)); } }
public ActionResult BrnIssueList(int?Id, int?branchid) { if (!User.Identity.IsAuthenticated) { return(AccessDeniedView()); } var identity = ((CustomPrincipal)User).CustomIdentity; _permissionservice = new PermissionsService(identity.Name, identity.UserRoleId); var model = new DqquebrnListModel(); model.CATALOG_ID = Id == null ? 0: Convert.ToInt32(Id); //foreach (var at in _dqService.GetAllActivityTypes()) //{ // model.ActivityLogType.Add(new SelectListItem // { // Value = at.Id.ToString(), // Text = at.Name // }); //} IQueryable <CM_BRANCH> curBranchList = db.CM_BRANCH.OrderBy(x => x.BRANCH_NAME); //.Where(a => a.BRANCH_ID == identity.BranchId); if (_permissionservice.IsLevel(AuthorizationLevel.Enterprise)) { } else if (_permissionservice.IsLevel(AuthorizationLevel.Regional)) { curBranchList = curBranchList.Where(a => a.REGION_ID == identity.RegionId); } else if (_permissionservice.IsLevel(AuthorizationLevel.Zonal)) { curBranchList = curBranchList.Where(a => a.ZONECODE == identity.ZoneId).OrderBy(a => a.BRANCH_NAME); } else if (_permissionservice.IsLevel(AuthorizationLevel.Branch)) { curBranchList = curBranchList.Where(a => a.BRANCH_ID == identity.BranchId).OrderBy(a => a.BRANCH_NAME); } else { curBranchList = curBranchList.Where(a => a.BRANCH_ID == "-1"); } model.Branches = new SelectList(curBranchList, "BRANCH_ID", "BRANCH_NAME").ToList(); if (_permissionservice.IsLevel(AuthorizationLevel.Enterprise)) { model.Branches.Add(new SelectListItem { Value = "0", Text = "All", Selected = true }); } int OpenIssues = (int)IssueStatus.Open; model.Statuses = new SelectList(db.MdmDQQueStatuses, "STATUS_CODE", "STATUS_DESCRIPTION", OpenIssues).ToList(); model.Priorities = new SelectList(db.MdmDQPriorities, "PRIORITY_CODE", "PRIORITY_DESCRIPTION").ToList(); model.Catalogs = new SelectList(db.MdmCatalogs.Where(q => q.ENABLED == 1), "CATALOG_ID", "CATALOG_NAME", Id).ToList(); model.Tiers.Add(new SelectListItem { Value = "1", Text = "1", }); model.Tiers.Add(new SelectListItem { Value = "2", Text = "2", }); model.Tiers.Add(new SelectListItem { Value = "3", Text = "3", }); model.Tiers.Add(new SelectListItem { Value = "0", Text = "All", Selected = true }); model.Statuses.Add(new SelectListItem { Value = "0", Text = "All" }); model.Priorities.Add(new SelectListItem { Value = "0", Text = "All" }); model.Catalogs.Add(new SelectListItem { Value = "0", Text = "All" }); //model.Branches.Add(new SelectListItem //{ // Value = "0", // Text = "All" //}); _messagingService.SaveUserActivity(identity.ProfileId, "Viewed Issue List for his / her branch", DateTime.Now); return(View(model)); }