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);
}