public ActionResult Index(ProfileBoxSearchModel search, int page = 1, int pageSize = 5, GridSortOptions sort = null)
{
var model = new ProfileBoxsModel();
//model.ProfileBox = new ProfileBoxInfomationModel
//{
// Name = DateTime.Now.ToString("ddMMyyyy_HH") + "_" + _workContext.User.UserName,
// UserName = _workContext.User.UserName
//};
Dictionary <string, string> profileTypes = _profileTypeService.GetAllTypes();
ViewBag.ProfileType = WebUtility.ConvertDictionaryToSelectList(profileTypes, true);
Dictionary <string, string> warehouses = _warehouseService.GetAllWarehouses();
ViewBag.Warehouses = WebUtility.ConvertDictionaryToSelectList(warehouses, true);
Dictionary <string, string> users = _userService.GetAllUsers();
ViewBag.Users = WebUtility.ConvertDictionaryToSelectList(users, true);
ViewBag.StatusList = WebUtility.ConvertEnumToSelectList <ABO.Core.ProfileBoxStatus>(true);
model.SearchModel = search;
var data = _profileBoxService.Search(page, pageSize, search.ToCriteria <ProfileBoxSearchModel, ProfileBoxSearchCriteria>());
model.Data = data.Select(x => x.ToModel <ProfileBoxGridModel>()).ToList();
ViewBag.ShowAddButton = _workContext.User.WarehouseId;
model.Pager = data.ToMvcPaging(model.Data);
return(View(model));
}
public ActionResult Index(ProfileBoxSearchModel search)
{
try
{
var profileBoxes = _profileBoxService.Search(1, _webHelper.ExcelSheetMaxRows, search.ToCriteria <ProfileBoxSearchModel, ProfileBoxSearchCriteria>());
var table = new DataTable();
table.Columns.Add(_resourceManager.GetString("ProfileBox.Name"));
table.Columns.Add(_resourceManager.GetString("ProfileBox.CreatedDate"));
table.Columns.Add(_resourceManager.GetString("ProfileBox.UserID"));
table.Columns.Add(_resourceManager.GetString("ProfileBox.WareHouse"));
table.Columns.Add(_resourceManager.GetString("ProfileBox.BoxStatus2"));
table.Columns.Add(_resourceManager.GetString("ProfileBox.AdaCount"));
foreach (var box in profileBoxes)
{
table.Rows.Add(new object[]
{
box.Name,
box.CreatedDate.ToString("dd/MM/yyyy"),
box.User.UserName,
box.Warehouse.WarehouseName,
box.Status.Name,
box.ADACount,
});
}
var excelData = _exportManager.ExportExcelFromDataTable(table, "ProfileBoxes", null);
return(File(excelData, FileContentType.EXCEL, "ProfileBoxes.xlsx"));
}
catch (Exception ex)
{
ErrorNotification(_resourceManager.GetString("Error" + ex.Message));
return(Redirect(Request.RawUrl));
}
}
