private string CreateXlsRptCCF(RptCCFInput input)
{
//get data
List <RptCCFDto> data = _rptCcfBLL.GetRptCcf(input);
var listData = Mapper.Map <List <RptCCFItem> >(data);
var slDocument = new SLDocument();
//title
slDocument.SetCellValue(1, 1, "CCF Report Data");
slDocument.MergeWorksheetCells(1, 1, 1, 14);
//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 = CreateHeaderExcelDashboard(slDocument);
//create data
slDocument = CreateDataExcelDashboard(slDocument, listData);
var fileName = "RptCCF" + DateTime.Now.ToString("_yyyyMMddHHmmss") + ".xlsx";
var path = Path.Combine(Server.MapPath(Constans.UploadPath), fileName);
slDocument.SaveAs(path);
return(path);
}
public List <TRA_CCF> GetRptCcf(RptCCFInput filter)
{
Expression <Func <TRA_CCF, bool> > queryFilter = PredicateHelper.True <TRA_CCF>();
if (filter != null)
{
if (filter.PeriodFrom != null)
{
queryFilter = queryFilter.And(c => (c.CREATED_DATE.Day >= filter.PeriodFrom.Day) &&
(c.CREATED_DATE.Month >= filter.PeriodFrom.Month) &&
(c.CREATED_DATE.Year >= filter.PeriodFrom.Year));
}
if (filter.PeriodTo != null)
{
queryFilter = queryFilter.And(c => (c.CREATED_DATE.Day <= filter.PeriodTo.Day) &&
(c.CREATED_DATE.Month <= filter.PeriodTo.Month) &&
(c.CREATED_DATE.Year <= filter.PeriodTo.Year));
}
if (filter.Category > 0)
{
queryFilter = queryFilter.And(c => c.COMPLAINT_CATEGORY == filter.Category);
}
if (!string.IsNullOrEmpty(filter.Coordinator))
{
queryFilter = queryFilter.And(c => c.COORDINATOR_NAME.ToUpper() == filter.Coordinator.ToUpper());
}
if (!string.IsNullOrEmpty(filter.Location))
{
queryFilter = queryFilter.And(c => c.LOCATION_CITY.ToUpper() == filter.Location.ToUpper());
}
if (filter.CoorKPI > 0)
{
queryFilter = queryFilter.And(c => c.COORDINATOR_KPI == filter.CoorKPI);
}
if (filter.VendorKPI > 0)
{
queryFilter = queryFilter.And(c => c.VENDOR_KPI == filter.VendorKPI);
}
}
return(_rptCcfRepository.Get(queryFilter, null, "").ToList());
}
public List <RptCCFDto> GetRptCcf(RptCCFInput filter)
{
var data = _RptCcfService.GetRptCcf(filter);
return(Mapper.Map <List <RptCCFDto> >(data));
}
