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());
}
