public ActionResult Index(string key = "", string customergroup = "", int page = 1, string chkExport = "0", string customerstatus = "", string selectedId = "") { var str = GetListChild("", customergroup); if (chkExport.Equals("1")) { var listExcel = _tblCustomerService.ExcelAllByFirst(key, str, customerstatus); //Xuất file theo format PK_CustomerMapFormatCell(listExcel, "Danh_sách_khách_hàng", "Sheet1", "", "Danh sách khách hàng", ""); return(RedirectToAction("Index", new { key = key, customergroup = customergroup, customerstatus = customerstatus, page = page })); } var pageSize = 20; var list = _tblCustomerService.GetAllPagingByFirst(key, str, page, pageSize, customerstatus); if (list.Any()) { var lstId = ""; var lstCustomerId = ""; foreach (var item in list) { lstId += item.CustomerGroupID + ";"; lstCustomerId += item.CustomerID.ToString() + ","; } ViewBag.listCustomerGroup = _tblCustomerGroupService.GetAllActiveByListId(lstId).ToList(); //ViewBag.listCardCustomer = _PK_CardCustomerService.GetAllCardByListCustomerId(lstCustomerId).ToList(); } var gridModel = PageModelCustom <tblCustomer> .GetPage(list, page, pageSize); ViewBag.keyValue = key; ViewBag.customergroupValue = customergroup; ViewBag.customerstatusValue = customerstatus; ViewBag.selectedIdValue = selectedId; ViewBag.CustomerGroups = GetMenuList(); ViewBag.CustomerStatusList = GetCustomerStatusList(); ViewBag.llevels = GetListAccessLevel(); return(View(gridModel)); }
// GET: Parking/tblCustomers public ActionResult Index(string key = "", string customerGr = "", string selectedId = "", int page = 1, string chkExport = "0") { int totalItem = 0; int pageSize = 20; var str = new List <string>(); //GetCustomerGr(str, customerGr); var listCustomer = itblCustomerService.GetListCustmer(key, customerGr, selectedId, page, pageSize, ref totalItem); var girdModel = PageModelCustom <tblCustomer> .GetPage(listCustomer, page, pageSize, totalItem); if (listCustomer.Any()) { var lstId = ""; foreach (var item in listCustomer) { lstId += item.CustomerGroupID + ","; } ViewBag.lstCustomerGr = itblCustomerGrService.GetAllActiveByListId(lstId).ToList(); } return(View(girdModel)); }
public List <tblCustomer_Excel> ExcelAllByFirst(string key, string customergroup, string customerstatus = "") { var query = from n in _tblCustomerRepository.Table select n; if (!string.IsNullOrWhiteSpace(key)) { query = query.Where(n => n.CustomerName.Contains(key) || n.CustomerCode.Contains(key) || n.Description.Contains(key) || n.CompartmentId.Contains(key)); } if (!string.IsNullOrWhiteSpace(customergroup)) { query = query.Where(n => customergroup.Contains(n.CustomerGroupID)); } if (!string.IsNullOrWhiteSpace(customerstatus)) { if (customerstatus.Equals("0")) { query = query.Where(n => n.Inactive == false); } else { query = query.Where(n => n.Inactive == true); } } // var idCustomerGroups = ""; var listCus = new List <tblCustomer_Excel>(); if (query.Any()) { // foreach (var item in query) { idCustomerGroups += item.CustomerGroupID + ";"; //idCustomers += item._id.ToString() + ","; } // var listCustomerGroup = _tblCustomerGroupService.GetAllActiveByListId(idCustomerGroups).ToList(); //var listCard = _PK_CardCustomerService.GetAllCardByListCustomerId(idCustomers).ToList(); // var count = 0; foreach (var item in query) { count++; var cusgroupid = !string.IsNullOrEmpty(item.CustomerGroupID) ? item.CustomerGroupID.ToLower() : ""; var objCustomerGroup = listCustomerGroup.FirstOrDefault(n => n.CustomerGroupID.ToString().Equals(cusgroupid)); var obj = new tblCustomer_Excel() { NumberRow = count, Active = item.Inactive == false ? "Hoạt động" : "Ngừng hoạt động", Cards = "", CustomerAddress = item.Address, CustomerCode = item.CustomerCode, CustomerGroupName = objCustomerGroup != null ? objCustomerGroup.CustomerGroupName : "", CustomerIdentify = item.IDNumber, CustomerMobile = item.Mobile, CustomerName = item.CustomerName, Plates = "" }; listCus.Add(obj); } } return(listCus); }