public ActionResult Index(string key, string cardgroupids, string customergroupids, string userids, string fromdate, string todate, int page = 1, string chkExport = "0")
{
var Dictionary = FunctionHelper.GetLocalizeDictionary("ActiveCardList", "Index");
if (string.IsNullOrWhiteSpace(fromdate))
{
fromdate = DateTime.Now.ToString("dd/MM/yyyy 00:00:00");
}
if (string.IsNullOrWhiteSpace(todate))
{
todate = DateTime.Now.ToString("dd/MM/yyyy 23:59:59");
}
if (chkExport == "1")
{
var listExcel = _tblActiveCardService.ReportAllByFirst(key, "", fromdate, todate, cardgroupids, customergroupids, userids);
//Xuất file theo format
PK_ActiveCardListFormatCell(listExcel, Dictionary["TitleEx"], "Sheet1", "", Dictionary["Title"], fromdate + " - " + todate);
return(RedirectToAction("Index"));
}
int pageSize = 20;
var list = _tblActiveCardService.GetAllPagingByFirst(key, "", fromdate, todate, cardgroupids, customergroupids, userids, page, pageSize);
if (list.Any())
{
var strCustomer = new List <string>();
foreach (var item in list)
{
strCustomer.Add(item.CustomerID);
}
ViewBag.CustomerList = _tblCustomerService.GetAllByListId(strCustomer).ToList();
}
var gridModel = PageModelCustom <tblActiveCardCustomViewModel> .GetPage(list, page, pageSize);
//
ViewBag.keyValue = key;
ViewBag.cardgroupidsValue = cardgroupids;
ViewBag.customergroupidsValue = customergroupids;
ViewBag.usersValue = userids;
ViewBag.fromdateValue = fromdate;
ViewBag.todateValue = todate;
//
ViewBag.cardgroups = GetListCardGroup().ToDataTableNullable();
ViewBag.users = GetListUser().ToDataTableNullable();
ViewBag.customergroups = GetMenuList();
return(View(gridModel));
}
public JsonResult GetListCardWantToUse(SelectListModelCardUpload obj)
{
var totalPage = 0;
var totalItem = 0;
var pageSize = 0;
var dtg = new List <AccessUploadMultiDevice>();
//Lấy người dùng hiện tại
var user = GetCurrentUser.GetUser();
var model = new SelectListModelCardUploadReturn();
model.ListSelfHost = GetSetFromSessionSelfHost(null);
model.ListController = GetSetFromSessionController(null);
if (obj.isall)
{
var customergroups = GetListChild("", obj.customergroupid);
var list = _tblCardService.GetAllPagingByFirstForUpload(obj.key, "", obj.cardgroupids, customergroups, "", "", obj.pageIndex, obj.pageSize, obj.accesslevelids, "", "");
var gridModel = PageModelCustom <tblCardExtend> .GetPage(list, obj.pageIndex, obj.pageSize);
totalPage = gridModel.TotalPage;
totalItem = gridModel.TotalItem;
pageSize = gridModel.PageSize;
model.ListCard = gridModel.Data.ToList();
}
else
{
model.ListCard = GetSetFromSessionCard(null);
model.ListCard = _tblCardService.GetAllByFirst_v2(model.ListCard);
}
var listCustomerId = new List <string>();
foreach (var item in model.ListCard)
{
if (!string.IsNullOrWhiteSpace(item.CustomerId))
{
listCustomerId.Add(item.CustomerId);
}
}
//Danh sách khách hàng
var ListCustomer = _tblCustomerService.GetAllByListId(listCustomerId);
if (model.ListCard.Any())
{
foreach (var item in model.ListSelfHost)
{
var ko = new AccessUploadMultiDevice()
{
Address = item.Address,
pageIndex = obj.pageIndex,
totalPage = totalPage,
totalItem = totalItem,
pageSize = pageSize
};
var lines = _tblAccessLineService.GetAllActiveByListPC(item.PCID);
var ControllerByPC = model.ListController.Where(n => lines.Any(m => m.LineID.ToString() == n.LineID)).ToList();
model.ListEmployee = new List <Employee>();
//
ko.totalItem = ko.totalItem * ControllerByPC.Count;
ko.totalController = ControllerByPC.Count;
foreach (var itemCard in model.ListCard)
{
foreach (var itemController in ControllerByPC)
{
var map = new Employee();
map.CardNumber = itemCard.CardNumber.Trim();
map.AccessLevelID = itemCard.AccessLevelID.Trim();
map.ControllerIDs = itemController.ControllerID.ToString();
map.UserID = user.Id;
//Lấy khách hàng
if (!string.IsNullOrWhiteSpace(itemCard.CustomerId))
{
var objCustomer = ListCustomer.FirstOrDefault(n => n.CustomerID.ToString() == itemCard.CustomerId);
if (objCustomer != null)
{
map.UserIDofFinger = objCustomer.UserIDofFinger;
map.Passwords = objCustomer.Password;
}
else
{
map.UserIDofFinger = 0;
map.Passwords = "";
}
}
else
{
map.UserIDofFinger = 0;
map.Passwords = "";
}
if (obj.isusenewdate)
{
map.ExpireDate = Convert.ToDateTime(obj.newdateexpire).ToString("yyyyMMdd").Trim();
}
else
{
map.ExpireDate = Convert.ToDateTime(itemCard.AccessExpireDate).ToString("yyyyMMdd").Trim();
}
model.ListEmployee.Add(map);
}
}
ko.DataSend = model.ListEmployee;
dtg.Add(ko);
}
}
//var t = new SelectListModelCardUploadReturn2()
//{
// ListEmployee = model.ListEmployee,
// ListSelfHost = model.ListSelfHost
//};
//var red = JsonConvert.SerializeObject(t);
var a = new JsonResult {
Data = dtg, MaxJsonLength = Int32.MaxValue
};
return(a);
}