public virtual ActionResult GoldenRecordsList(DataSourceRequest command, GoldenRecordModel model, string sort, string sortDir)
{
var items = _dqQueService.GetAllQueItems(model.FULL_NAME, model.CUSTOMER_NO, model.EMAIL, model.ACCOUNT_NO, model.BVN, model.GOLDEN_RECORD, model.BRANCH_CODE, command.Page - 1, command.PageSize, string.Format("{0} {1}", sort, sortDir));
//var logItems = _logger.GetAllLogs(createdOnFromValue, createdToFromValue, model.Message,
// logLevel, command.Page - 1, command.PageSize);
DateTime _today = DateTime.Now.Date;
var gridModel = new DataSourceResult
{
Data = items.Select(x => new GoldenRecordModel
{
Id = x.RECORD_ID,
GOLDEN_RECORD = x.GOLDEN_RECORD,
CUSTOMER_NO = x.CUSTOMER_NO,
BVN = x.BVN,
FULL_NAME = x.FULL_NAME,
DATE_OF_BIRTH = x.DATE_OF_BIRTH,
RESIDENTIAL_ADDRESS = x.RESIDENTIAL_ADDRESS,
CUSTOMER_TYPE = x.CUSTOMER_TYPE,
SEX = x.SEX,
BRANCH_CODE = x.BRANCH_CODE,
PHONE_NUMBER = x.PHONE_NUMBER,
SCHEME_CODE = x.SCHEME_CODE,
ACCOUNT_NO = x.ACCOUNT_NO,
EMAIL = x.EMAIL,
}),
Total = items.TotalCount
};
return(Json(gridModel));
}
public ActionResult List()
{
var model = new GoldenRecordModel();
if (!User.Identity.IsAuthenticated)
{
return(AccessDeniedView());
}
var identity = ((CustomPrincipal)User).CustomIdentity;
_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
});
}
_messagingService.SaveUserActivity(identity.ProfileId, "Viewed Golden Records Manual Merge Report", DateTime.Now);
return(View(model));
}
public virtual ActionResult AuthList(DataSourceRequest command, GoldenRecordModel 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);
var identity = ((CustomPrincipal)User).CustomIdentity;
var routeValues = System.Web.HttpContext.Current.Request.RequestContext.RouteData.Values;
//RouteValueDictionary routeValues;
int goldenRecord = 0;
if (routeValues.ContainsKey("id"))
{
goldenRecord = int.Parse((string)routeValues["id"]);
}
var items = _dqQueService.GetAllQueItems(model.SearchName, model.CUSTOMER_NO, model.EMAIL, model.ACCOUNT_NO, model.BVN, goldenRecord, model.BRANCH_CODE, command.Page - 1, command.PageSize, string.Format("{0} {1}", sort, sortDir));
var gridModel = new DataSourceResult
{
Data = items.Select(x => new GoldenRecordModel
{
GOLDEN_RECORD = x.GOLDEN_RECORD,
FULL_NAME = x.FULL_NAME,
DATE_OF_BIRTH = x.DATE_OF_BIRTH,
SEX = x.SEX,
RESIDENTIAL_ADDRESS = x.RESIDENTIAL_ADDRESS,
BRANCH_CODE = x.BRANCH_CODE,
BVN = x.BVN,
CUSTOMER_NO = x.CUSTOMER_NO,
CUSTOMER_TYPE = x.CUSTOMER_TYPE,
Id = x.RECORD_ID
}),
Total = items.TotalCount
};
return(Json(gridModel));
}
public ActionResult List()
{
var model = new GoldenRecordModel();
if (!User.Identity.IsAuthenticated)
{
return(AccessDeniedView());
}
var identity = ((CustomPrincipal)User).CustomIdentity;
var curBranchList = db.CM_BRANCH.Where(a => a.BRANCH_ID == identity.BranchId);
model.Branches = new SelectList(curBranchList, "BRANCH_ID", "BRANCH_NAME").ToList();
model.Branches.Add(new SelectListItem
{
Value = "0",
Text = "All"
});
return(View(model));
}
public virtual ActionResult ExportExcelAll(GoldenRecordModel model)
{
if (!User.Identity.IsAuthenticated)
{
return(AccessDeniedView());
}
var items = _dqQueService.GetAllQueItems(model.FULL_NAME, model.CUSTOMER_NO, model.EMAIL, model.ACCOUNT_NO, model.BVN, model.GOLDEN_RECORD, model.BRANCH_CODE);
try
{
byte[] bytes = _exportManager.ExportDocumentsToXlsx(items);
identity = ((CustomPrincipal)User).CustomIdentity;
_messagingService.SaveUserActivity(identity.ProfileId, "Downloaded Customers with Multiple Ids Report", DateTime.Now);
return(File(bytes, MimeTypes.TextXlsx, "multipleIDs.xlsx"));
}
catch (Exception exc)
{
ErrorNotification(exc);
return(RedirectToAction("List"));
}
}
public ActionResult AuthList(int id)
{
if (!User.Identity.IsAuthenticated)
{
return(AccessDeniedView());
}
var identity = ((CustomPrincipal)User).CustomIdentity;
var model = new GoldenRecordModel();
model.GOLDEN_RECORD = id;
//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();
model.Branches.Add(new SelectListItem
{
Value = "0",
Text = "All"
});
//model.Branches.Add(new SelectListItem
//{
// Value = "0",
// Text = "All"
//});
_messagingService.SaveUserActivity(identity.ProfileId, "Viewed Golden Records Authorization Report", DateTime.Now);
return(View(model));
}
public virtual ActionResult List(DataSourceRequest command, GoldenRecordModel model, string sort, string sortDir)
{
var items = _dqQueService.GetAllQueItems(model.SearchName, model.CUSTOMER_NO, model.EMAIL, model.ACCOUNT_NO, model.BVN, model.GOLDEN_RECORD, model.BRANCH_CODE, command.Page - 1, command.PageSize, string.Format("{0} {1}", sort, sortDir));
//var logItems = _logger.GetAllLogs(createdOnFromValue, createdToFromValue, model.Message,
// logLevel, command.Page - 1, command.PageSize);
DateTime _today = DateTime.Now.Date;
var gridModel = new DataSourceResult
{
Data = items.Select(x => new GoldenRecordModel
{
GOLDEN_RECORD = x.GOLDEN_RECORD,
FULL_NAME = x.FULL_NAME,
DATE_OF_BIRTH = x.DATE_OF_BIRTH,
SEX = x.SEX,
RESIDENTIAL_ADDRESS = x.RESIDENTIAL_ADDRESS,
BVN = x.BVN,
BRANCH_CODE = x.BRANCH_CODE,
CUSTOMER_NO = x.CUSTOMER_NO,
CUSTOMER_TYPE = x.CUSTOMER_TYPE,
Id = x.RECORD_ID
}),
Total = items.TotalCount
};
//var gridModel = new DataSourceResult
//{
// Data = items.Select(x =>
// {
// var itemsModel = x.ToModel();
// PrepareSomethingModel(itemsModel, x, false, false);
// return itemsModel;
// }),
// Total = items.TotalCount,
//};
return(Json(gridModel));
}
