public ActionResult IndexCustomer(CustomerCriteria criteria, string currentFilter, int?page = 1)
{
int pageNumber = (page ?? 1);
this.ViewBag.CurrentFilter = criteria;
if (!string.IsNullOrEmpty(currentFilter))
{
return(this.IndexCustomer(criteria, page));
}
var obj = CustomerList.GetCustomerList().OrderByDescending(x => x.CreatedDate).ToPagedList(pageNumber, this.pageSize);
var list = new ISAT.Web.ViewModel.CustomerViewModel();
foreach (var item in obj)
{
var cust = Business.Customer.NewCustomer();
cust.FirstName = item.FirstName;
cust.LastName = item.LastName;
cust.Email = item.Email;
cust.CustNo = item.CustNo;
cust.CompanyName = item.CompanyName;
cust.CreatedDate = item.CreatedDate;
cust.CreatedBy = item.CreatedBy;
list.ListCustomer.Add(cust);
}
var viewModel = new CustomerViewModel()
{
ListCustomer = list.ListCustomer.ToList(),
Criteria = new CustomerCriteria()
};
var onePageOfProducts = list;
ViewBag.OnePageOfProducts = obj;
return(View(viewModel));
}
public ActionResult ExportExcelCustomerData(CustomerCriteria criteria)
{
var headerDictionary = new Dictionary <string, string>();
this.ViewBag.CurrentFilter = criteria;
var obj = CustomerList.GetCustomerList();
var list = new ISAT.Web.ViewModel.CustomerViewModel();
foreach (var item in obj)
{
var cust = Business.Customer.NewCustomer();
cust.FirstName = item.FirstName;
cust.LastName = item.LastName;
cust.Email = item.Email;
cust.CustNo = item.CustNo;
cust.CompanyName = item.CompanyName;
cust.CreatedDate = item.CreatedDate;
cust.CreatedBy = item.CreatedBy;
list.ListCustomer.Add(cust);
}
var viewModel = new CustomerViewModel()
{
ListCustomer = list.ListCustomer.OrderByDescending(x => x.CreatedDate).ToList(),
Criteria = new CustomerCriteria()
};
try
{
IExporter exporter = new CustomerDataExcelExporter(this.Response, viewModel.ListCustomer);
exporter.Export();
}
catch
{
throw;
}
return(this.View("IndexCustomer", viewModel));
}
public ActionResult IndexCustomer(CustomerCriteria criteria, int?page = 1)
{
int pageNumber = (page ?? 1);
this.ViewBag.CurrentFilter = criteria;
var obj = CustomerList.GetCustomerList().Where(o => (criteria.FirstName == null || o.FirstName.ToLower().Contains(criteria.FirstName.ToLower())) &&
(criteria.LastName == null || o.LastName.ToLower().Contains(criteria.LastName.ToLower())) &&
(criteria.Email == null || o.Email.ToLower().Contains(criteria.Email.ToLower())) &&
(criteria.CompanyName == null || o.CompanyName.ToLower().Contains(criteria.CompanyName.ToLower()) &&
(criteria.CustNo == null || o.CustNo.ToLower().Contains(criteria.CustNo.ToLower()))))
.Select(o => o).ToPagedList(pageNumber, this.pageSize);
var list = new ISAT.Web.ViewModel.CustomerViewModel();
foreach (var item in obj)
{
var cust = Business.Customer.NewCustomer();
cust.FirstName = item.FirstName;
cust.LastName = item.LastName;
cust.Email = item.Email;
cust.CustNo = item.CustNo;
cust.CompanyName = item.CompanyName;
cust.CreatedDate = item.CreatedDate;
cust.CreatedBy = item.CreatedBy;
list.ListCustomer.Add(cust);
}
var viewModel = new CustomerViewModel()
{
ListCustomer = list.ListCustomer.OrderByDescending(x => x.CreatedDate).ToList(),
Criteria = new CustomerCriteria()
};
var onePageOfProducts = list;
ViewBag.OnePageOfProducts = obj;
return(View(viewModel));
}