public string GetExcelReportData(int id, out Library.DTO.Notification notification)
{
notification = new Library.DTO.Notification()
{
Type = Library.DTO.NotificationType.Success
};
PurchaseOrderDataObject ds = new PurchaseOrderDataObject();
try
{
SqlDataAdapter adap = new SqlDataAdapter();
adap.SelectCommand = new SqlCommand("PurchaseOrderMng_function_GetReportData", new SqlConnection(Library.Helper.GetSQLConnectionString()));
adap.SelectCommand.CommandType = System.Data.CommandType.StoredProcedure;
adap.SelectCommand.Parameters.AddWithValue("@PurchaseOrderID", id);
adap.TableMappings.Add("Table", "PurchaseOrderReportData");
adap.TableMappings.Add("Table1", "PurchaseOrderDetailReportData");
adap.Fill(ds);
return(Library.Helper.CreateReportFileWithEPPlus2(ds, "PurchaseOrder"));
}
catch (Exception ex)
{
notification.Type = Library.DTO.NotificationType.Error;
notification.Message = ex.Message;
if (ex.InnerException != null && !string.IsNullOrEmpty(ex.InnerException.Message))
{
notification.DetailMessage.Add(ex.InnerException.Message);
}
return(string.Empty);
}
}
public DTO.PurchaseOrderPrintOutDto GetHTMLReportData(int PurchaseOrderID, out Library.DTO.Notification notification)
{
notification = new Library.DTO.Notification()
{
Type = Library.DTO.NotificationType.Success
};
DTO.PurchaseOrderPrintOutDto PurchaseOrderPrintOut = new DTO.PurchaseOrderPrintOutDto();
PurchaseOrderPrintOut.PurchaseOrderDetailPrintOutDtos = new List <DTO.PurchaseOrderDetailPrintOutDto>();
PurchaseOrderDataObject ds = new PurchaseOrderDataObject();
try
{
SqlDataAdapter adap = new SqlDataAdapter();
adap.SelectCommand = new SqlCommand("PurchaseOrderMng_function_GetReportData", new SqlConnection(Library.Helper.GetSQLConnectionString()));
adap.SelectCommand.CommandType = System.Data.CommandType.StoredProcedure;
adap.SelectCommand.Parameters.AddWithValue("@PurchaseOrderID", PurchaseOrderID);
adap.TableMappings.Add("Table", "PurchaseOrderReportData");
adap.TableMappings.Add("Table1", "PurchaseOrderDetailReportData");
adap.Fill(ds);
//read to delivery note
var purchaseOrder = ds.PurchaseOrderReportData.FirstOrDefault();
PurchaseOrderPrintOut.PurchaseOrderID = purchaseOrder.PurchaseOrderID;
PurchaseOrderPrintOut.PurchaseOrderUD = purchaseOrder.PurchaseOrderUD;
PurchaseOrderPrintOut.PurchaseOrderDate = purchaseOrder.PurchaseOrderDate;
PurchaseOrderPrintOut.FactoryRawMaterialOfficialNM = purchaseOrder.FactoryRawMaterialOfficialNM;
PurchaseOrderPrintOut.FactoryRawMaterialShortNM = purchaseOrder.FactoryRawMaterialShortNM;
PurchaseOrderPrintOut.Address = purchaseOrder.Address;
PurchaseOrderPrintOut.Fax = purchaseOrder.Fax;
PurchaseOrderPrintOut.Phone = purchaseOrder.Phone;
PurchaseOrderPrintOut.ContactPerson = purchaseOrder.ContactPerson;
PurchaseOrderPrintOut.RequiredDocuments = purchaseOrder.RequiredDocuments;
PurchaseOrderPrintOut.PaymentDocuments = purchaseOrder.PaymentDocuments;
PurchaseOrderPrintOut.SupplierPaymentTermID = purchaseOrder.SupplierPaymentTermID;
PurchaseOrderPrintOut.SupplierPaymentTermNM = purchaseOrder.SupplierPaymentTermNM;
PurchaseOrderPrintOut.Currency = purchaseOrder.Currency;
PurchaseOrderPrintOut.VAT = purchaseOrder.VAT;
//read delivery note detail
DTO.PurchaseOrderDetailPrintOutDto purchaseOrderDetail;
foreach (var item in ds.PurchaseOrderDetailReportData)
{
purchaseOrderDetail = new DTO.PurchaseOrderDetailPrintOutDto();
PurchaseOrderPrintOut.PurchaseOrderDetailPrintOutDtos.Add(purchaseOrderDetail);
purchaseOrderDetail.ProductionItemNM = item.ProductionItemNM;
purchaseOrderDetail.ProductionItemUD = item.ProductionItemUD;
purchaseOrderDetail.ClientUD = item.ClientUD;
purchaseOrderDetail.UnitNM = item.UnitNM;
purchaseOrderDetail.OrderQnt = item.OrderQnt;
purchaseOrderDetail.Amount = item.Amount;
purchaseOrderDetail.Remark = item.Remark;
purchaseOrderDetail.UnitPrice = item.UnitPrice;
purchaseOrderDetail.ThumbnailLocation = FrameworkSetting.Setting.MediaFullSizeUrl + item.ThumbnailLocation;
purchaseOrderDetail.FileLocation = FrameworkSetting.Setting.MediaFullSizeUrl + item.FileLocation;
purchaseOrderDetail.ProductImage = item.ProductImage;
purchaseOrderDetail.ETA = item.ETA;
//purchaseOrderDetail.WorkOrderUD = item.WorkOrderUD;
purchaseOrderDetail.ID = item.ID;
}
return(PurchaseOrderPrintOut);
}
catch (Exception ex)
{
notification.Type = Library.DTO.NotificationType.Error;
notification.Message = ex.Message;
notification.DetailMessage.Add(ex.Message);
if (ex.GetBaseException() != null)
{
notification.DetailMessage.Add(ex.GetBaseException().Message);
}
return(PurchaseOrderPrintOut);
}
}
