public ActionResult PrintLetter(DistributorLetterSearchModel search, int page = 1, int pageSize = 10, GridSortOptions sort = null)
{
search.StartDate = (search.StartDate.Date.ToShortDateString() == "1/1/0001") ? DateTime.Now.AddDays(-7) : search.StartDate;
search.EndDate = (search.EndDate.Date.ToShortDateString() == "1/1/0001") ? DateTime.Now : search.EndDate;
Dictionary <string, string> warehouses = _warehouseService.GetAllWarehouses();
ViewBag.Warehouses = WebUtility.ConvertDictionaryToSelectList(warehouses, true);
DistributorLetterModel model = new DistributorLetterModel
{
Search = search,
NewLetter = new NewLetterModel()
};
var data = _distributorService.SearchDistributorLetter(search.DistributorNumber, search.StartDate, search.EndDate, search.WarehouseID, page, pageSize, sort.Column, "");
model.Data = data.Select(x => x.ToModel <DistributorGridModel>()).ToList();
model.Pager = data.ToMvcPaging(model.Data);
return(View(model));
}
public ActionResult ExportLetterToExcel(DistributorLetterSearchModel search)
{
try
{
var letters = _distributorService.SearchDistributorLetter(search.DistributorNumber, search.StartDate, search.EndDate, search.WarehouseID, 1, _webHelper.ExcelSheetMaxRows, null, null);
var data = letters.Select(x => x.ToModel <DistributorGridModel>()).ToList();
var table = new System.Data.DataTable();
table.Columns.Add(_resourceManager.GetString("NewLetter.Distributor"));
table.Columns.Add(_resourceManager.GetString("NewLetter.DistributorName"));
table.Columns.Add(_resourceManager.GetString("NewLetter.Address"));
table.Columns.Add(_resourceManager.GetString("NewLetter.Telephone"));
table.Columns.Add(_resourceManager.GetString("NewLetter.OldDistributor"));
table.Columns.Add(_resourceManager.GetString("NewLetter.OldDistributorName"));
table.Columns.Add(_resourceManager.GetString("NewLetter.Telephone") + " ");
table.Columns.Add(_resourceManager.GetString("NewLetter.Sponsor"));
table.Columns.Add(_resourceManager.GetString("NewLetter.SponsorName"));
table.Columns.Add(_resourceManager.GetString("NewLetter.Address") + " ");
table.Columns.Add(_resourceManager.GetString("NewLetter.Telephone") + " ");
table.Columns.Add(_resourceManager.GetString("NewLettter.Platium"));
table.Columns.Add(_resourceManager.GetString("NewLettter.PlatiumName"));
table.Columns.Add(_resourceManager.GetString("NewLetter.Address") + " ");
table.Columns.Add(_resourceManager.GetString("NewLetter.Telephone") + " ");
table.Columns.Add(_resourceManager.GetString("DistributorLetter.LetterDate"));
table.Columns.Add(_resourceManager.GetString("NewLetter.Creator"));
table.Columns.Add(_resourceManager.GetString("NewLetter.Warehouse"));
foreach (var letter in data)
{
table.Rows.Add(new object[]
{
letter.DistNumber,
letter.DistName,
letter.DistAddress,
letter.DistTelephone,
letter.OldDistNumber,
letter.OldDistName,
letter.OldDistTelephone,
letter.SponsorNum,
letter.SponsorName,
letter.SponsorAddress,
letter.SponsorTelephone,
letter.PlatiumNumber,
letter.PlatiumName,
letter.PlatiumAddress,
letter.PlatiumTelephone,
letter.LetterDate.ToString("dd/MM/yyyy"),
letter.Creator,
letter.Warehouse
});
}
var excelData = _exportManager.ExportExcelFromDataTable(table, "Letter", null);
return(File(excelData, FileContentType.EXCEL, "Letter_" + search.DistributorNumber + ".xlsx"));
}
catch (Exception ex)
{
ErrorNotification(_resourceManager.GetString("Error" + ex.Message));
return(Redirect(Request.RawUrl));
}
}
