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