public string ExportFSCReport(string startDate, string endDate, out Library.DTO.Notification notification) { notification = new Library.DTO.Notification(); notification.Type = Library.DTO.NotificationType.Success; ReportObjectData ds = new ReportObjectData(); string fileName = string.Empty; DateTime?valStartDate = startDate.ConvertStringToDateTime(); DateTime?valEndDate = endDate.ConvertStringToDateTime(); try { System.Data.SqlClient.SqlDataAdapter adap = new System.Data.SqlClient.SqlDataAdapter(); adap.SelectCommand = new System.Data.SqlClient.SqlCommand("FSCRpt_function_FSCOverviewExcel", new System.Data.SqlClient.SqlConnection(Library.Helper.GetSQLConnectionString())); adap.SelectCommand.CommandType = System.Data.CommandType.StoredProcedure; adap.SelectCommand.Parameters.AddWithValue("@StartDate", valStartDate.Value.Date); adap.SelectCommand.Parameters.AddWithValue("@EndDate", valEndDate.Value.Date); adap.TableMappings.Add("Table", "FSCRpt_FSCOverview_View FSCOverview"); adap.Fill(ds); ReportObjectData.ReportHeaderRow hRow = ds.ReportHeader.NewReportHeaderRow(); hRow.StartDate = startDate; hRow.EndDate = endDate; ds.ReportHeader.AddReportHeaderRow(hRow); ds.AcceptChanges(); fileName = Library.Helper.CreateReportFileWithEPPlus(ds, "FSCReport"); } 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(fileName); }
public string ExportExcel(string season, out Library.DTO.Notification notification) { string fileName = ""; notification = new Library.DTO.Notification(); notification.Type = Library.DTO.NotificationType.Success; ReportObjectData ds = new ReportObjectData(); try { System.Data.SqlClient.SqlDataAdapter adap = new System.Data.SqlClient.SqlDataAdapter(); adap.SelectCommand = new System.Data.SqlClient.SqlCommand("ShipmentToBeInvoiceRpt_function_ExportExcel", new System.Data.SqlClient.SqlConnection(Library.Helper.GetSQLConnectionString())); adap.SelectCommand.CommandType = System.Data.CommandType.StoredProcedure; adap.SelectCommand.Parameters.AddWithValue("@Season", season); adap.TableMappings.Add("Table", "ShipmentToBeInvoice_Common"); adap.TableMappings.Add("Table1", "ShipmentToBeInvoice_Detail"); adap.Fill(ds); ds.AcceptChanges(); fileName = Library.Helper.CreateReportFileWithEPPlus2(ds, "ShipmentToBeInvoice"); } 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(fileName); }
public object ExportExcel(int userID, System.Collections.Hashtable filters, out Library.DTO.Notification notification) { notification = new Library.DTO.Notification(); notification.Type = Library.DTO.NotificationType.Success; try { string client = (filters.ContainsKey("clientSearch") && filters["clientSearch"] != null && !string.IsNullOrEmpty(filters["clientSearch"].ToString().Trim())) ? filters["clientSearch"].ToString().Trim() : null; string model = (filters.ContainsKey("modelSearch") && filters["modelSearch"] != null && !string.IsNullOrEmpty(filters["modelSearch"].ToString().Trim())) ? filters["modelSearch"].ToString().Trim() : null; string product = (filters.ContainsKey("productSearch") && filters["productSearch"] != null && !string.IsNullOrEmpty(filters["productSearch"].ToString().Trim())) ? filters["productSearch"].ToString().Trim() : null; string sampleProduct = (filters.ContainsKey("sampleSearch") && filters["sampleSearch"] != null && !string.IsNullOrEmpty(filters["sampleSearch"].ToString().Trim())) ? filters["sampleSearch"].ToString().Trim() : null; ReportObjectData ds = new ReportObjectData(); System.Data.SqlClient.SqlDataAdapter adap = new System.Data.SqlClient.SqlDataAdapter(); adap.SelectCommand = new System.Data.SqlClient.SqlCommand("ProductBreakDownPAL_function_ProductBreakDownPALSearchResult", new System.Data.SqlClient.SqlConnection(Library.Helper.GetSQLConnectionString())); adap.SelectCommand.CommandType = System.Data.CommandType.StoredProcedure; adap.SelectCommand.Parameters.AddWithValue("@clientSearch", client); adap.SelectCommand.Parameters.AddWithValue("@modelSearch", model); adap.SelectCommand.Parameters.AddWithValue("@productSearch", product); adap.SelectCommand.Parameters.AddWithValue("@sampleSearch", sampleProduct); adap.TableMappings.Add("Table", "ProductBreakDownView"); adap.Fill(ds); ds.AcceptChanges(); return(Library.Helper.CreateReportFileWithEPPlus2(ds, "Product_BreakDown_PAL")); } catch (Exception ex) { notification.Type = Library.DTO.NotificationType.Error; notification.Message = Library.Helper.GetInnerException(ex).Message; return(string.Empty); } }