public virtual ActionResult GetAll([DataSourceRequest] DataSourceRequest request,
DateTime?dateFrom,
DateTime?dateTo,
string buyerName,
string orderNumber)
{
LogI("GetAll");
var filter = new CustomerFilterViewModel()
{
DateFrom = dateFrom,
DateTo = dateTo,
BuyerName = buyerName,
OrderNumber = orderNumber
};
request.Sorts = new List <SortDescriptor>()
{
new SortDescriptor("CreateDate", ListSortDirection.Descending)
};
var items = CustomerViewModel.GetAll(Db, filter);
var dataSource = items.ToDataSourceResult(request);
return(new JsonResult {
Data = dataSource, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public ActionResult Index(string firstName, string lastName, string city, string street, GridSortOptions gridSortOptions, [DefaultValue(1)] int page)
{
// Pobranie listy użytkowników
var customersList = _customerRepo.GetAllCustomers();
// Ustawienie domyślnej kolumny sortowania
if (string.IsNullOrWhiteSpace(gridSortOptions.Column))
{
gridSortOptions.Column = "Id";
}
// Filtrowanie po imieniu
if (!string.IsNullOrWhiteSpace(firstName))
{
customersList = customersList.Where(a => a.FirstName.Contains(firstName));
}
// Filtrowanie po nazwisku
if (!string.IsNullOrWhiteSpace(lastName))
{
customersList = customersList.Where(a => a.LastName.Contains(lastName));
}
// Filtrowanie po mieście
if (!string.IsNullOrWhiteSpace(city))
{
customersList = customersList.Where(a => a.City.Contains(city));
}
// Filtrowanie po ulicy
if (!string.IsNullOrWhiteSpace(street))
{
customersList = customersList.Where(a => a.Street.Contains(street));
}
var customerFilterViewModel = new CustomerFilterViewModel();
// Sortowanie listy użytkowników oraz stronicowanie
var customerPagedList = customersList.OrderBy(gridSortOptions.Column, gridSortOptions.Direction)
.AsPagination(page, 5);
CustomerListContainerViewModel customerListContainer = new CustomerListContainerViewModel
{
CustomerPagedList = customerPagedList,
CustomerFilterViewModel = customerFilterViewModel,
GridSortOptions = gridSortOptions
};
return(View(customerListContainer));
}
public virtual ActionResult ExportToExcel()
{
LogI("ExportToExcel");
var filters = new CustomerFilterViewModel();
string filename = "CustomerReport_" + Time.GetAppNowTime().ToString("ddMMyyyyHHmmss") + ".xls";
var output = CustomerViewModel.ExportToExcel(LogService,
Time,
Db,
filters);
return(File(output.ToArray(), //The binary data of the XLS file
"application/vnd.ms-excel", //MIME type of Excel files
filename)); //Suggested file name in the "Save as" dialog which will be displayed to the end user
}
// GET: Invoice/Bulk
public async Task <ActionResult> Bulk()
{
var companies = await _companyBusinessManager.GetCompanies();
ViewBag.Companies = companies.Select(x => new SelectListItem()
{
Text = x.Name, Value = x.Id.ToString()
}).ToList();
var selectedCompany = companies.FirstOrDefault();
var model = new CustomerFilterViewModel()
{
CompanyId = selectedCompany?.Id ?? 0,
DateFrom = DateTime.Now.FirstDayOfMonth(),
DateTo = DateTime.Now.LastDayOfMonth()
};
var summary = await _companyBusinessManager.GetSummaryRanges(selectedCompany?.Id ?? 0);
ViewBag.SummaryRange = summary.Select(x => new SelectListItem()
{
Text = $"{x.From} - {x.To}", Value = x.Id.ToString()
});
var customerTags = await _businessManager.GetCustomerTags();
ViewBag.Tags = customerTags.Select(x => new SelectListItem()
{
Text = x.Name, Value = x.Id.ToString()
});
var customerTypes = await _businessManager.GetCustomerTypes();
ViewBag.CustomerTypes = customerTypes.Select(x => new SelectListItem()
{
Text = x.Name, Value = x.Id.ToString()
});
//var customers = await _businessManager.GetBulkCustomers(selectedCompany?.Id ?? 0, model.DateFrom, model.DateTo);
//ViewBag.Customers = _mapper.Map<List<CustomerListViewModel>>(customers);
return(View(model));
}
public ActionResult Index(string FirstName, string LastName, string City, string Street, GridSortOptions sort, [DefaultValue(1)] int page)
{
IQueryable <CustomerViewModel> customerList = _customerRepo.GetAllCustomer();
if (string.IsNullOrWhiteSpace(sort.Column))
{
sort.Column = "CustomerId";
}
if (!string.IsNullOrWhiteSpace(FirstName))
{
customerList = customerList.Where(c => c.FirstName.Contains(FirstName));
}
if (!string.IsNullOrWhiteSpace(LastName))
{
customerList = customerList.Where(c => c.LastName.Contains(LastName));
}
if (!string.IsNullOrWhiteSpace(City))
{
customerList = customerList.Where(c => c.City.Contains(City));
}
if (!string.IsNullOrWhiteSpace(Street))
{
customerList = customerList.Where(c => c.Street.Contains(Street));
}
//potrzebna przestrzen nazw using MvcContrib.Sorting;
var customerPagedList = customerList.OrderBy(sort.Column, sort.Direction).AsPagination(page, 5);
CustomerFilterViewModel customerFilterViewModel = new CustomerFilterViewModel();
CustomerListContainerViewModel customerListContainerViewModel = new CustomerListContainerViewModel
{
CustomerPageList = customerPagedList,
CustomerFilterViewModel = customerFilterViewModel,
GridSortOptions = sort
};
return(View(customerListContainerViewModel));
}
public async Task <ActionResult> Find(CustomerFilterViewModel customerFilterViewModel)
{
try
{
#region Validation
if (!ModelState.IsValid)
{
var coreModels = await _customerService
.GetUsingPagedListAsync(customerFilterViewModel.Page ?? 1, _pageSize)
.ConfigureAwait(false);
var viewModels = _mapper.Map <IPagedList <CustomerViewModel> >(coreModels);
return(PartialView("Partial/_CustomerTable", viewModels));
}
#endregion
#region Filter
var customersCoreModels = _customerService.Filter(
_mapper.Map <CustomerFilterCoreModel>(customerFilterViewModel), _pageSize);
var customersViewModels = _mapper.Map <IPagedList <CustomerViewModel> >(customersCoreModels);
#endregion
#region Filling ViewBag
ViewBag.CustomerFilterFirstNameValue = customerFilterViewModel.FirstName;
ViewBag.CustomerFilterLastNameValue = customerFilterViewModel.LastName;
#endregion
return(PartialView("Partial/_CustomerTable", customersViewModels));
}
catch (Exception exception)
{
ViewBag.Error = exception.Message;
return(PartialView("Partial/_CustomerTable"));
}
}
