public Stream GetReportContainerSizeList(string strTypeLanguage)
{
Stream stream;
DataRow row;
_DataSet_ContainerSizeList.DataTable1DataTable dt;
List <ContainerSize_M> containerSizeList;
int intLanguage = 1;
var containersizes = _containerSizeRepository.GetAllQueryable();
containersizes = containersizes.OrderBy("ContainerSizeC descending");
containerSizeList = containersizes.ToList();
dt = new _DataSet_ContainerSizeList.DataTable1DataTable();
foreach (ContainerSize_M item in containerSizeList)
{
row = dt.NewRow();
row["ContainerSizeC"] = item.ContainerSizeC;
row["ContainerSizeN"] = item.ContainerSizeN;
row["Description"] = item.Description;
row["Status"] = item.IsActive;
//row["Status"] = "Không khả dụng";
//if (item.IsActive)
//{
// row["Status"] = "Khả dụng";
//}
dt.Rows.Add(row);
}
if (strTypeLanguage == "en")
{
intLanguage = 2;
}
else if (strTypeLanguage == "jp")
{
intLanguage = 3;
}
stream = ExportPDF.GetContainerSizeList(dt, intLanguage);
return(stream);
}
public static Stream GetContainerSizeList(_DataSet_ContainerSizeList.DataTable1DataTable datatable, int intLanguage = 1)
{
try
{
ReportDocument report;
string strPath;
//strPath = HttpContext.Current.Request.MapPath("~/FileRpt/ContainerSize/ContainnerSizeList.rpt");
//deploy
strPath = HttpContext.Current.Request.MapPath("~/FileRpt/ContainerSize/ContainnerSizeList.rpt");
if (intLanguage == 3)
{
strPath = HttpContext.Current.Request.MapPath("~/FileRpt/ContainerSize/ContainnerSizeListJP.rpt");
}
else if (intLanguage == 2)
{
strPath = HttpContext.Current.Request.MapPath("~/FileRpt/ContainerSize/ContainnerSizeListEN.rpt");
}
report = new ReportDocument();
report.Load(strPath);
report.Database.Tables[0].SetDataSource((DataTable)datatable);
//if (type == 1)
//{
// return report.ExportToStream(ExportFormatType.Excel);
//}
Stream stream = report.ExportToStream(ExportFormatType.PortableDocFormat);
report.Close();
report.Dispose();
GC.Collect();
return(stream);
}
catch (NullReferenceException)
{
throw new NullReferenceException();
}
}
