public IHttpActionResult PrintPickingList(int id)
{
Library.DTO.Notification notification;
// authentication
Module.Framework.BLL fwBll = new Module.Framework.BLL();
if (!fwBll.CanPerformAction(ControllerContext.GetAuthUserId(), getModuleCode(), Library.DTO.ModuleAction.CanPrint))
{
return(InternalServerError(new Exception(Properties.Resources.NOT_AUTHORIZED)));
}
//GET DATA
BLL.WarehousePickingListMng bll = new BLL.WarehousePickingListMng();
DTO.WarehousePickingListMng.CMRContainer dtoPrintout = bll.GetCMRPrintout(id, ControllerContext.GetAuthUserId(), out notification);
//CREATE PRINTOUT
Microsoft.Reporting.WebForms.LocalReport lr = new Microsoft.Reporting.WebForms.LocalReport();
lr.ReportPath = FrameworkSetting.Setting.AbsoluteReportFolder + "CMR.rdlc";
Microsoft.Reporting.WebForms.ReportDataSource rsInvoice = new Microsoft.Reporting.WebForms.ReportDataSource();
rsInvoice.Name = "CMR";
rsInvoice.Value = dtoPrintout.CMRs;
lr.DataSources.Add(rsInvoice);
Microsoft.Reporting.WebForms.ReportDataSource rsInvoiceDetail = new Microsoft.Reporting.WebForms.ReportDataSource();
rsInvoiceDetail.Name = "CMRDetail";
rsInvoiceDetail.Value = dtoPrintout.CMRDetails;
lr.DataSources.Add(rsInvoiceDetail);
string printoutFileName = PrintoutHelper.BuildPrintoutFileCMR(lr, "PDF");
return(Ok(new Library.DTO.ReturnData <string>()
{
Data = printoutFileName, Message = notification
}));
}
public DTO.WarehousePickingListMng.CMRContainer DB2DTO_CMR(WarehousePickingListMng_PickingList_ReportView dbItem)
{
DTO.WarehousePickingListMng.CMRContainer dtoItem = new DTO.WarehousePickingListMng.CMRContainer();
dtoItem.CMRs = new List <DTO.WarehousePickingListMng.CMR>();
dtoItem.CMRDetails = new List <DTO.WarehousePickingListMng.CMRDetail>();
//READ PICKING LIST DETAIL
DTO.WarehousePickingListMng.CMRDetail dtoCMRDetail;
int i = 1;
int?TotalQnt = 0;
foreach (var item in dbItem.WarehousePickingListMng_PickingListProductDetail_ReportView)
{
dtoCMRDetail = new DTO.WarehousePickingListMng.CMRDetail();
dtoCMRDetail.RowIndex = i;
if (item.Description.Length > 90)
{
dtoCMRDetail.Description = item.Description.Substring(0, 85) + "..........";
}
else
{
dtoCMRDetail.Description = item.Description;
}
dtoCMRDetail.Quantity = item.Quantity;
dtoItem.CMRDetails.Add(dtoCMRDetail);
i++;
TotalQnt += item.Quantity;
}
int maxRow = 17; //(that mean 16 product)
if (i < maxRow)
{
for (int j = 1; j <= maxRow - i; j++)
{
dtoCMRDetail = new DTO.WarehousePickingListMng.CMRDetail();
dtoCMRDetail.Description = "";
//dtoCMRDetail.RowIndex = j;
dtoItem.CMRDetails.Add(dtoCMRDetail);
}
}
//READ PICKIGLIST
DTO.WarehousePickingListMng.CMR dtoCMR = new DTO.WarehousePickingListMng.CMR();
dtoCMR.CMR1 = dbItem.CMR1;
dtoCMR.CMR2 = dbItem.CMR2;
dtoCMR.CMR3 = dbItem.CMR3;
dtoCMR.CMR4 = dbItem.CMR4;
dtoCMR.CMR5 = dbItem.CMR5;
dtoCMR.CMR13 = dbItem.CMR13;
dtoCMR.CMR14 = dbItem.CMR14;
dtoCMR.CMR15 = dbItem.CMR15;
dtoCMR.CMR16 = dbItem.CMR16;
dtoCMR.CMR17 = dbItem.CMR17;
dtoCMR.CMR18 = dbItem.CMR18;
dtoCMR.CMR19 = dbItem.CMR19;
dtoCMR.CMR20 = dbItem.CMR20;
dtoCMR.CMR21 = dbItem.CMR21;
dtoCMR.CMR22 = dbItem.CMR22;
dtoCMR.CMR23 = dbItem.CMR23;
dtoCMR.CMR24 = dbItem.CMR24;
dtoCMR.TotalQnt = TotalQnt;
dtoCMR.CMRDate = dbItem.CMRDate;
dtoItem.CMRs.Add(dtoCMR);
//RETURN DATA
return(dtoItem);
}