public virtual ActionResult AuthList(DataSourceRequest command, DqqueAuthListModel 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;
int[] corpCatalogs = { 61, 11, 12, 5, 21 };
if (corpCatalogs.Contains(catalogId))
{
var items = _dqQueService.GetAllCorpUnAuthIssues(model.SearchName, model.CATALOG_ID, model.CUST_ID, model.RULE_ID, model.BRANCH_CODE.ToString(), issueStatus, model.PRIORITY_CODE, command.Page - 1, command.PageSize, string.Format("{0} {1}", sort, sortDir));
var gridModel = new DataSourceResult
{
Data = items.Select(x => new DqqueAuthListModel
{
EXCEPTION_ID = x.EXCEPTION_ID,
CUST_ID = x.CUST_ID,
RULE_NAME = x.RULE_NAME,
BRANCH_CODE = x.BRANCH_CODE,
ISSUE_STATUS_DESC = x.ISSUE_STATUS_DESC,
ISSUE_PRIORITY_DESC = x.ISSUE_PRIORITY_DESC,
RUN_DATE = x.RUN_DATE,
BRANCH_NAME = x.BRANCH_NAME,
CREATED_DATE = x.CREATED_DATE,
PRIORITY_CODE = x.ISSUE_PRIORITY,
STATUS_CODE = x.ISSUE_STATUS,
REASON = x.REASON,
FIRSTNAME = x.FIRST_NAME,
SURNAME = x.SURNAME,
OTHERNAME = x.OTHERNAME,
CATALOG_ID = x.CATALOG_ID,
CATALOG_TABLE_NAME = x.CATALOG_TABLE_NAME
}),
Total = items.TotalCount
};
return(Json(gridModel));
}
else
{
var items = _dqQueService.GetAllBrnUnAuthIssues(model.SearchName, model.CATALOG_ID, model.CUST_ID, model.RULE_ID, model.BRANCH_CODE.ToString(), 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 DqqueAuthListModel
{
EXCEPTION_ID = x.EXCEPTION_ID,
CUST_ID = x.CUST_ID,
RULE_NAME = x.RULE_NAME,
BRANCH_CODE = x.BRANCH_CODE,
ISSUE_STATUS_DESC = x.ISSUE_STATUS_DESC,
ISSUE_PRIORITY_DESC = x.ISSUE_PRIORITY_DESC,
RUN_DATE = x.RUN_DATE,
BRANCH_NAME = x.BRANCH_NAME,
CREATED_DATE = x.CREATED_DATE,
PRIORITY_CODE = x.ISSUE_PRIORITY,
STATUS_CODE = x.ISSUE_STATUS,
REASON = x.REASON,
FIRSTNAME = x.FIRST_NAME,
SURNAME = x.SURNAME,
OTHERNAME = x.OTHERNAME,
CATALOG_ID = x.CATALOG_ID,
CATALOG_TABLE_NAME = x.CATALOG_TABLE_NAME
}),
Total = items.TotalCount
};
return(Json(gridModel));
}
}
public ActionResult AuthList()
{
if (!User.Identity.IsAuthenticated)
{
return(AccessDeniedView());
}
var identity = ((CustomPrincipal)User).CustomIdentity;
var model = new DqqueAuthListModel();
//foreach (var at in _dqService.GetAllActivityTypes())
//{
// model.ActivityLogType.Add(new SelectListItem
// {
// Value = at.Id.ToString(),
// Text = at.Name
// });
//}
//var curBranchList = db.CM_BRANCH.Where(a => a.BRANCH_ID == identity.BranchId);
//model.Branches = new SelectList(curBranchList, "BRANCH_ID", "BRANCH_NAME").ToList();
_permissionservice = new PermissionsService(identity.Name, identity.UserRoleId);
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
});
}
model.Statuses = new SelectList(db.MdmDQQueStatuses, "STATUS_CODE", "STATUS_DESCRIPTION").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").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"
//});
return(View(model));
}
