public List <SalesVolumeDto> GetSalesVolume(SalesVolumeParamInput inputs) { var data = _SalesVolumeService.GetSalesVolume(inputs); var retData = Mapper.Map <List <SalesVolumeDto> >(data); return(retData); }
private string CreateXlsMasterSalesVolume(SalesVolumeParamInput input) { //get data List <SalesVolumeDto> SalesVolume = _SalesVolumeBLL.GetSalesVolume(input); var listData = Mapper.Map <List <SalesVolumeItem> >(SalesVolume); var slDocument = new SLDocument(); //title slDocument.SetCellValue(1, 1, "Master Sales Volume"); slDocument.MergeWorksheetCells(1, 1, 1, 10); //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 = CreateHeaderExcelMasterSalesVolume(slDocument); //create data slDocument = CreateDataExcelMasterSalesVolume(slDocument, listData); var fileName = "Master_Data_Sales_Volume" + DateTime.Now.ToString("_yyyyMMddHHmmss") + ".xlsx"; var path = Path.Combine(Server.MapPath(Constans.UploadPath), fileName); slDocument.SaveAs(path); return(path); }
public List <MST_SALES_VOLUME> GetSalesVolume(SalesVolumeParamInput filter) { Expression <Func <MST_SALES_VOLUME, bool> > queryFilter = PredicateHelper.True <MST_SALES_VOLUME>(); if (filter != null) { if (filter.MonthFrom > 0) { queryFilter = queryFilter.And(c => c.MONTH >= filter.MonthFrom); } if (filter.MonthTo > 0) { queryFilter = queryFilter.And(c => c.MONTH <= filter.MonthTo); } if (filter.YearFrom > 0) { queryFilter = queryFilter.And(c => c.YEAR >= filter.YearFrom); } if (filter.YearTo > 0) { queryFilter = queryFilter.And(c => c.YEAR <= filter.YearTo); } if (!string.IsNullOrEmpty(filter.Type)) { queryFilter = queryFilter.And(c => c.TYPE.ToUpper() == filter.Type.ToUpper()); } if (!string.IsNullOrEmpty(filter.Regional)) { queryFilter = queryFilter.And(c => c.REGION.ToUpper() == filter.Regional.ToUpper()); } } return(_SalesVolumeRepository.Get(queryFilter, null, "").ToList()); }