public VehicleOverallReportModel Initial(VehicleOverallReportModel model)
{
var settingData = _settingBLL.GetSetting();
var listStatus = new Dictionary <bool, string> {
{ true, "Active" }, { false, "InActive" }
};
var listVehType = settingData.Where(x => x.SettingGroup == EnumHelper.GetDescription(Enums.SettingGroup.VehicleType) && x.IsActive).Select(x => new { x.SettingValue }).ToList();
var listSupMethod = settingData.Where(x => x.SettingGroup == EnumHelper.GetDescription(Enums.SettingGroup.SupplyMethod) && x.IsActive).Select(x => new { x.SettingValue }).ToList();
var listRegional = _locationMappingBLL.GetLocationMapping().Where(x => x.IsActive).Select(x => new { x.Region }).Distinct().ToList();
var listBodyType = settingData.Where(x => x.SettingGroup == EnumHelper.GetDescription(Enums.SettingGroup.BodyType) && x.IsActive).Select(x => new { x.SettingValue }).ToList();
var listVendor = _vendorBLL.GetVendor().Where(x => x.IsActive).Select(x => new { x.VendorName }).Distinct().ToList();
var listCity = _locationMappingBLL.GetLocationMapping().Where(x => x.IsActive).Select(x => new { x.Location }).Distinct().ToList();
model.SearchView.StatusList = new SelectList(listStatus, "Key", "Value");
model.SearchView.VehicleTypeList = new SelectList(listVehType, "SettingValue", "SettingValue");
model.SearchView.SupplyMethodList = new SelectList(listSupMethod, "SettingValue", "SettingValue");
model.SearchView.RegionalList = new SelectList(listRegional, "Region", "Region");
model.SearchView.BodyTypeList = new SelectList(listBodyType, "SettingValue", "SettingValue");;
model.SearchView.VendorList = new SelectList(listVendor, "VendorName", "VendorName");
model.SearchView.CityList = new SelectList(listCity, "Location", "Location");
model.SearchView.FromDate = new DateTime(DateTime.Today.Year, DateTime.Today.Month, 1);
model.SearchView.ToDate = DateTime.Today;
model.MainMenu = _mainMenu;
model.CurrentLogin = CurrentUser;
return(model);
}
private string CreateXlsVehicleReport(VehicleOverallReportModel model)
{
//get data
var data = GetVehicleData(model.SearchView);
var slDocument = new SLDocument();
//title
slDocument.SetCellValue(1, 1, "VEHICLE REPORT");
slDocument.MergeWorksheetCells(1, 1, 1, 32);
//create style
SLStyle valueStyle = slDocument.CreateStyle();
valueStyle.SetHorizontalAlignment(HorizontalAlignmentValues.Center);
valueStyle.Font.Bold = true;
valueStyle.Font.FontSize = 18;
slDocument.SetCellStyle(1, 1, valueStyle);
//create header
slDocument = CreateHeaderVehicleReport(slDocument);
//create data
slDocument = CreateDataExcelVehicleReport(slDocument, data);
var fileName = "Vehicle_report" + DateTime.Now.ToString("_yyyyMMddHHmmss") + ".xlsx";
var path = Path.Combine(Server.MapPath(Constans.UploadPath), fileName);
slDocument.SaveAs(path);
return(path);
}
public ActionResult Index()
{
var model = new VehicleOverallReportModel();
model = Initial(model);
var filter = new VehicleOverallReportGetByParamInput();
filter.FromDate = new DateTime(DateTime.Today.Year, DateTime.Today.Month, 1);
filter.ToDate = DateTime.Today;
var data = _vehicleOverallReportBLL.GetVehicle(filter);
var ListData = Mapper.Map <List <VehicleOverallItem> >(data);
model.ListVehicle = ListData;
return(View(model));
}
public void ExportVehicleReport(VehicleOverallReportModel model)
{
string pathFile = "";
pathFile = CreateXlsVehicleReport(model);
var newFile = new FileInfo(pathFile);
var fileName = Path.GetFileName(pathFile);
string attachment = string.Format("attachment; filename={0}", fileName);
Response.Clear();
Response.AddHeader("content-disposition", attachment);
Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
Response.WriteFile(newFile.FullName);
Response.Flush();
newFile.Delete();
Response.End();
}
public PartialViewResult ListVehicle(VehicleOverallReportModel model)
{
model.ListVehicle = GetVehicleData(model.SearchView);
return(PartialView("_ListVehicleOverall", model));
}
