public static bool InventoryAdjustReport(int ReferenceNumber, bool TableBorder = false, bool Preview = true, bool PrintToThermal = false, bool ExportToPdf = false, bool ExportToExcel = false, string ExportPath = "", bool colored = false) { bool GenerateReportIs100Matched = false; DataTable InventoryGeneral = AdjustInventoryGeneralMgmt.SelectAllAdjustsGeneral(ReferenceNumber, string.Empty, string.Empty); if (InventoryGeneral == null) { return(false); } if (InventoryGeneral.Rows.Count == 0) { return(false); } DataTable InventoryDetailedTable = AdjustInventoryDetailedMgmt.SelectAllAdjustsDetailed(ReferenceNumber, -1); if (InventoryDetailedTable == null) { GenerateReportIs100Matched = true; } if (InventoryDetailedTable.Rows.Count == 0) { GenerateReportIs100Matched = true; } List <DataTable> aDataTableList = new List <DataTable>(); DataTable aDataTable1 = new DataTable(); aDataTable1.Columns.Add("[border=true1]" + "<th width=15%>" + ReportsText.BarcodeRepTxt); aDataTable1.Columns.Add("<th width=20%>" + ReportsText.DescriptionRepTxt); aDataTable1.Columns.Add("<th width=9%>" + ReportsText.AvgCostRepTxt); aDataTable1.Columns.Add("<th width=9%>" + ReportsText.AvaQtyRepTxt); aDataTable1.Columns.Add(ReportsText.PhysicalCountRepTxt); aDataTable1.Columns.Add(ReportsText.DifferencesRepTxt); aDataTable1.Columns.Add(ReportsText.DifferenceValueRepTxt); double TotalPositive = 0.00, TotalNegative = 0.00, ParsingTester = 0.00;; DataTable ItemsTable = ItemsMgmt.SelectAllItems(); foreach (DataRow aRow in InventoryDetailedTable.Rows) { if (double.Parse(aRow["DifferenceQty"].ToString()) == 0) { continue; } DataRow aToAddRow = aDataTable1.Rows.Add(); aToAddRow[0] = ReportsHelper.FindData(ItemsTable, "ID", "Barcode", aRow["ItemID"].ToString()); aToAddRow[1] = ReportsHelper.FindData(ItemsTable, "ID", "Description", aRow["ItemID"].ToString()); aToAddRow[2] = Math.Round(double.Parse(ReportsHelper.FindData(ItemsTable, "ID", "AvgUnitCost", aRow["ItemID"].ToString())), 3); aToAddRow[3] = Math.Round(double.Parse(aRow["OldQty"].ToString()), 3); aToAddRow[4] = aRow["NewQty"]; aToAddRow[5] = aRow["DifferenceQty"]; ParsingTester = double.Parse(aRow["DifferenceValue"].ToString()); aToAddRow[6] = ParsingTester; if (ParsingTester > 0) { TotalPositive += ParsingTester; } else { TotalNegative += ParsingTester; } } if (aDataTable1.Rows.Count == 0 || GenerateReportIs100Matched) { DataTable aEmptyTable = new DataTable(); aEmptyTable.Columns.Add("INVENTORY STOCK AVAILABLE QTY MATCHES 100% THE PHYSICAL COUNT"); aDataTableList.Add(aEmptyTable); } else { aDataTableList.Add(aDataTable1); DataRow NetRow = aDataTable1.Rows.Add(); string EmptyNoborderRow = ReportsHelper.MANUAL_TD_OPTION_START + ReportsHelper.NOBORDER + ReportsHelper.MANUAL_TD_OPTION_END + ReportsHelper.MANUAL_TD_END; NetRow[0] = EmptyNoborderRow; NetRow[1] = EmptyNoborderRow; NetRow[2] = EmptyNoborderRow; NetRow[3] = EmptyNoborderRow; NetRow[4] = ReportsHelper.MANUAL_TD_OPTION_START + ReportsHelper.UNDERLINE + ReportsHelper.NOBORDER + ReportsHelper.MANUAL_TD_OPTION_END + ReportsText.TotalRepTxt + ReportsHelper.MANUAL_TD_END; NetRow[5] = ReportsHelper.MANUAL_TD_OPTION_START + ReportsHelper.UNDERLINE + ReportsHelper.NOBORDER + ReportsHelper.MANUAL_TD_OPTION_END + ReportsText.PosAdjValueRepTxt + ReportsHelper.MANUAL_TD_END; NetRow[6] = ReportsHelper.MANUAL_TD_OPTION_START + ReportsHelper.UNDERLINE + ReportsHelper.NOBORDER + ReportsHelper.MANUAL_TD_OPTION_END + TotalPositive + ReportsHelper.MANUAL_TD_END; NetRow = aDataTable1.Rows.Add(); NetRow[0] = EmptyNoborderRow; NetRow[1] = EmptyNoborderRow; NetRow[2] = EmptyNoborderRow; NetRow[3] = EmptyNoborderRow; NetRow[4] = EmptyNoborderRow; NetRow[5] = ReportsHelper.MANUAL_TD_OPTION_START + ReportsHelper.UNDERLINE + ReportsHelper.NOBORDER + ReportsHelper.MANUAL_TD_OPTION_END + ReportsText.NegAdjValueRepTxt + ReportsHelper.MANUAL_TD_END; NetRow[6] = ReportsHelper.MANUAL_TD_OPTION_START + ReportsHelper.UNDERLINE + ReportsHelper.NOBORDER + ReportsHelper.MANUAL_TD_OPTION_END + TotalNegative + ReportsHelper.MANUAL_TD_END; NetRow = aDataTable1.Rows.Add(); NetRow[0] = EmptyNoborderRow; NetRow[1] = EmptyNoborderRow; NetRow[2] = EmptyNoborderRow; NetRow[3] = EmptyNoborderRow; NetRow[4] = EmptyNoborderRow; NetRow[5] = ReportsHelper.MANUAL_TD_OPTION_START + ReportsHelper.UNDERLINE + ReportsHelper.NOBORDER + ReportsHelper.MANUAL_TD_OPTION_END + "<b>" + ReportsText.NetValueRepTxt + "<b>" + ReportsHelper.MANUAL_TD_END; NetRow[6] = ReportsHelper.MANUAL_TD_OPTION_START + ReportsHelper.UNDERLINE + ReportsHelper.NOBORDER + ReportsHelper.MANUAL_TD_OPTION_END + (TotalNegative + TotalPositive) + ReportsHelper.MANUAL_TD_END; } List <string> aStringList = ReportsHelper.ImportReportHeader(0, 1); List <string> aFooterList = ReportsHelper.ImportReportHeader(1, 1); aStringList.Add(SharedVariables.Line_Solid_10px_Black); aStringList.Add(ReportsNames.InventoryStockAdjustRepName); aStringList.Add("<h2>" + "Added On" + " " + InventoryGeneral.Rows[0]["Date"].ToString() + "</h2>"); aStringList.Add("<h2> " + "Added By" + ": " + UsersMgmt.SelectUserNameByID(int.Parse(InventoryGeneral.Rows[0]["TellerID"].ToString())) + "</h2>"); aStringList.Add("<h2>" + ReceiptText.RctTxtReprintedOn + " " + DateTime.Now.ToShortDateString() + " " + DateTime.Now.ToShortTimeString() + "</h2>"); aStringList.Add("<h2> " + ReceiptText.RctTxtReprintedBy + ": " + SharedFunctions.ReturnLoggedUserName() + "</h2>"); aStringList.Add(ReceiptText.RctTxtInvoiceNum + ": " + ReferenceNumber); aStringList.Add(SharedVariables.Line_Solid_10px_Black); if (Preview) { PrintingManager.Instance.PrintTables(aDataTableList, aStringList, aFooterList, ReportsHelper.TempOutputPath, ReportsHelper.TempOutputPath, PrintToThermal, false, false, "", false, "", colored); return(true); } else if (ExportToPdf) { PrintingManager.Instance.PrintTables(aDataTableList, aStringList, aFooterList, ReportsHelper.TempOutputPath, ReportsHelper.TempOutputPath, PrintToThermal, false, true, ExportPath, false, "", colored); return(true); } else if (ExportToExcel) { PrintingManager.Instance.PrintTables(aDataTableList, aStringList, aFooterList, ReportsHelper.TempOutputPath, ReportsHelper.TempOutputPath, PrintToThermal, false, false, "", true, ExportPath, colored); return(true); } else if (PrintToThermal) { PrintingManager.Instance.PrintTables(aDataTableList, aStringList, aFooterList, ReportsHelper.TempOutputPath, ReportsHelper.TempOutputPath, true, true, false, "", false, "", colored); return(true); } else { return(false); } }
public string FastMoveItems(bool FastOrSlowReport, int NumberOfItems, string DateFrom, string DateTo, bool ExportToExcel = false, string ExportPath = "") { try { Excel.Range chartRange; xlApp = new Excel.Application(); xlApp.DisplayAlerts = false; xlApp.Visible = false; xlApp.SheetsInNewWorkbook = 1; xlWorkBook = xlApp.Workbooks.Add(misValue);//misValue string ReportName = (FastOrSlowReport ? "Fast Move Items Report" : "Slow Move Items Report"); DataTable aTable = ReportsMgmt.FastMovItemBasedOnQty(NumberOfItems, DateFrom, DateTo, FastOrSlowReport); if (aTable.Rows.Count > 0) { int RowCnt = 1; xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1); xlWorkSheet.Name = ReportName; List <string> aHeader = ReportsHelper.ImportReportHeader(0, 1); List <string> aFooter = ReportsHelper.ImportReportHeader(1, 1); for (int i = 0; i < aHeader.Count; i++) { string astringss = aHeader[i]; xlWorkSheet.Cells[RowCnt, 2] = aHeader[i]; RowCnt++; } xlWorkSheet.Cells[RowCnt++, 1] = ReportName; xlWorkSheet.Cells[RowCnt, 2] = "Date From:\t" + DateFrom; xlWorkSheet.Cells[RowCnt, 3] = "Date To:\t" + DateTo; RowCnt++; xlWorkSheet.Cells[RowCnt, 1] = "Item Description"; xlWorkSheet.Cells[RowCnt, 2] = "Qty Sold"; xlWorkSheet.get_Range("A1", "K" + RowCnt.ToString()).Font.Bold = true; //xlWorkSheet.get_Range("A1", "K" + RowCnt.ToString()).WrapText = true; xlWorkSheet.get_Range("A1", "K" + RowCnt.ToString()).HorizontalAlignment = Excel.XlVAlign.xlVAlignCenter; xlWorkSheet.get_Range("A1", "K" + RowCnt.ToString()).VerticalAlignment = Excel.XlVAlign.xlVAlignCenter; RowCnt++; int DataStart = RowCnt; foreach (DataRow aRow in aTable.Rows) { xlWorkSheet.Cells[RowCnt, 1] = aRow["ItemDescription"].ToString(); xlWorkSheet.Cells[RowCnt, 2] = aRow["Summation"].ToString(); RowCnt++; } xlWorkSheet.get_Range("A" + DataStart.ToString(), "K" + RowCnt.ToString()).HorizontalAlignment = Excel.XlVAlign.xlVAlignCenter; xlWorkSheet.get_Range("A" + DataStart.ToString(), "K" + RowCnt.ToString()).VerticalAlignment = Excel.XlVAlign.xlVAlignCenter; oRng = xlWorkSheet.get_Range("A1", "K" + RowCnt.ToString()); oRng.EntireColumn.AutoFit(); Excel.ChartObjects myCharts = (Excel.ChartObjects)xlWorkSheet.ChartObjects(Type.Missing); xlWorkSheet.DisplayRightToLeft = false; int size = aTable.Rows.Count * 100; if (size >= 600) { size = 600; } if (size < 300) { size = 300; } Excel.ChartObject myChart = (Excel.ChartObject)myCharts.Add(0, RowCnt * 15, size, 300); Excel.Chart chartPage = myChart.Chart; Excel.SeriesCollection seriesCollection = chartPage.SeriesCollection(); Excel.Series series1 = seriesCollection.NewSeries(); RowCnt--; //because we started from 1 suppose to be 0 series1.Name = ReportName; series1.XValues = xlWorkSheet.Range["A" + DataStart.ToString(), "A" + RowCnt.ToString()]; series1.Values = xlWorkSheet.Range["B" + DataStart.ToString(), "B" + RowCnt.ToString()]; chartPage.ChartType = Excel.XlChartType.xlColumnClustered; Excel.Axis axis = chartPage.Axes(Excel.XlAxisType.xlValue, Microsoft.Office.Interop.Excel.XlAxisGroup.xlPrimary) as Excel.Axis; series1.ApplyDataLabels(Excel.XlDataLabelsType.xlDataLabelsShowBubbleSizes); object format = Microsoft.Office.Interop.Excel.XlFileFormat.xlHtml; xlWorkSheet.SaveAs(ReportsHelper.TempOutputPath, format); if (ExportToExcel) { format = Microsoft.Office.Interop.Excel.XlFileFormat.xlExcel7; xlWorkSheet.SaveAs(ExportPath, format); } xlApp.UserControl = false; return("TRUE"); } else { return("EMPTY"); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); return("ERROR"); } finally { //Once done close and quit Excel xlWorkBook.Close(true, misValue, misValue); xlApp.Quit(); releaseObject(xlWorkSheet); releaseObject(xlWorkBook); releaseObject(xlApp); } }
public static bool ItemStatusReport(int ItemID, string DateFrom, string DateTo, bool TableBorder = false, bool Preview = true, bool PrintToThermal = false, bool ExportToPdf = false, bool ExportToExcel = false, string ExportPath = "", bool colored = false) { if (!ItemsMgmt.IsItemExistByID(ItemID)) { return(false); } string EmptyNoborderRow = ReportsHelper.MANUAL_TD_OPTION_START + ReportsHelper.NOBORDER + ReportsHelper.MANUAL_TD_OPTION_END + ReportsHelper.MANUAL_TD_END; List <DataTable> aDTlist = new List <DataTable>(); DataTable aTable1 = new DataTable(); if (TableBorder) { aTable1.Columns.Add("[Border=true1]" + "Barcode"); } else { aTable1.Columns.Add("Barcode"); } aTable1.Columns.Add("Description"); aTable1.Columns.Add("Type"); aTable1.Columns.Add("Qty"); DataRow aItemRow = ItemsMgmt.SelectItemRowByID(ItemID); bool AddEmpty = false; double NetTotal = 0.00; DataRow __PoorRow; double OnHandQty = double.Parse(aItemRow["OnHandQty"].ToString()); double TotalBeforeBills = BillDetailedMgmt.SelectAllSoldQty(ItemID, DateFrom, DateTo, 0, true); double TotalBeforeAdjust = AdjustInventoryDetailedMgmt.SelectAllAdjustQty(ItemID, DateFrom, DateTo, -1, true); double TotalBeforeDispose = DisposalDetailedMgmt.SelectAllDisposedQty(ItemID, DateFrom, DateTo, 0, true); double TotalBeforePurchase = PurchaseVoucherDetailedMgmt.SelectAllPurchaseQty(ItemID, DateFrom, DateTo, 0, true); double TotalBeforeCusRet = ReturnItemsCustDetailedMGMT.SelectAllReturnedQty(ItemID, DateFrom, DateTo, 0, true); double TotalBeforeVenReturns = ReturnItemsVendorDetailedMgmt.SelectAllReturnedQty(ItemID, DateFrom, DateTo, 0, true); double BegginingQty = OnHandQty - TotalBeforeBills + TotalBeforeAdjust - TotalBeforeDispose + TotalBeforePurchase + TotalBeforeCusRet - TotalBeforeVenReturns; if (BegginingQty != 0) { NetTotal += BegginingQty; __PoorRow = aTable1.Rows.Add(); __PoorRow[0] = (AddEmpty) ? EmptyNoborderRow : aItemRow["Barcode"].ToString(); __PoorRow[1] = (AddEmpty) ? EmptyNoborderRow : aItemRow["Description"].ToString(); __PoorRow[2] = "Beginning Qty"; __PoorRow[3] = Math.Round(BegginingQty, 3); AddEmpty = true; } double TotalBills = BillDetailedMgmt.SelectAllSoldQty(ItemID, DateFrom, DateTo, -1); double TotalReversedBills = BillDetailedMgmt.SelectAllSoldQty(ItemID, DateFrom, DateTo, 1); if (TotalBills != 0) { NetTotal -= TotalBills; __PoorRow = aTable1.Rows.Add(); __PoorRow[0] = (AddEmpty) ? EmptyNoborderRow : aItemRow["Barcode"].ToString(); __PoorRow[1] = (AddEmpty) ? EmptyNoborderRow : aItemRow["Description"].ToString(); __PoorRow[2] = "Total Sales"; __PoorRow[3] = Math.Round(0.00 - TotalBills, 3); AddEmpty = true; } if (TotalReversedBills != 0) { NetTotal += TotalReversedBills; __PoorRow = aTable1.Rows.Add(); __PoorRow[0] = (AddEmpty) ? EmptyNoborderRow : aItemRow["Barcode"].ToString(); __PoorRow[1] = (AddEmpty) ? EmptyNoborderRow : aItemRow["Description"].ToString(); __PoorRow[2] = "Reversed Sales"; __PoorRow[3] = Math.Round((TotalReversedBills), 3); AddEmpty = true; } double TotalAdjust = AdjustInventoryDetailedMgmt.SelectAllAdjustQty(ItemID, DateFrom, DateTo, -1); if (TotalAdjust != 0) { NetTotal += TotalAdjust; __PoorRow = aTable1.Rows.Add(); __PoorRow[0] = (AddEmpty) ? EmptyNoborderRow : aItemRow["Barcode"].ToString(); __PoorRow[1] = (AddEmpty) ? EmptyNoborderRow : aItemRow["Description"].ToString(); __PoorRow[2] = "Total Inventory Adjust"; __PoorRow[3] = Math.Round(TotalAdjust, 3); AddEmpty = true; } double TotalDisposed = DisposalDetailedMgmt.SelectAllDisposedQty(ItemID, DateFrom, DateTo, -1); double TotalReversedDisposed = DisposalDetailedMgmt.SelectAllDisposedQty(ItemID, DateFrom, DateTo, 1); if (TotalDisposed != 0) { NetTotal -= TotalDisposed; __PoorRow = aTable1.Rows.Add(); __PoorRow[0] = (AddEmpty) ? EmptyNoborderRow : aItemRow["Barcode"].ToString(); __PoorRow[1] = (AddEmpty) ? EmptyNoborderRow : aItemRow["Description"].ToString(); __PoorRow[2] = "Total Disposed"; __PoorRow[3] = Math.Round(0.00 - TotalDisposed, 3); AddEmpty = true; } if (TotalReversedDisposed != 0) { NetTotal += TotalReversedDisposed; __PoorRow = aTable1.Rows.Add(); __PoorRow[0] = (AddEmpty) ? EmptyNoborderRow : aItemRow["Barcode"].ToString(); __PoorRow[1] = (AddEmpty) ? EmptyNoborderRow : aItemRow["Description"].ToString(); __PoorRow[2] = "Total Reversed Disposals"; __PoorRow[3] = Math.Round((0.00 - TotalReversedDisposed), 3); AddEmpty = true; } double TotalPurchase = PurchaseVoucherDetailedMgmt.SelectAllPurchaseQty(ItemID, DateFrom, DateTo, -1); double TotalReversedPurchase = PurchaseVoucherDetailedMgmt.SelectAllPurchaseQty(ItemID, DateFrom, DateTo, 1); if (TotalPurchase != 0) { NetTotal += TotalPurchase; __PoorRow = aTable1.Rows.Add(); __PoorRow[0] = (AddEmpty) ? EmptyNoborderRow : aItemRow["Barcode"].ToString(); __PoorRow[1] = (AddEmpty) ? EmptyNoborderRow : aItemRow["Description"].ToString(); __PoorRow[2] = "Total Purchase"; __PoorRow[3] = Math.Round((TotalPurchase), 3); AddEmpty = true; } if (TotalReversedPurchase != 0) { NetTotal -= TotalReversedPurchase; __PoorRow = aTable1.Rows.Add(); __PoorRow[0] = (AddEmpty) ? EmptyNoborderRow : aItemRow["Barcode"].ToString(); __PoorRow[1] = (AddEmpty) ? EmptyNoborderRow : aItemRow["Description"].ToString(); __PoorRow[2] = "Total Reversed Purchase"; __PoorRow[3] = Math.Round((0.00 - TotalReversedPurchase), 3); AddEmpty = true; } double TotalCustomerReturns = ReturnItemsCustDetailedMGMT.SelectAllReturnedQty(ItemID, DateFrom, DateTo, -1); double TotalReversedCustomerReturns = ReturnItemsCustDetailedMGMT.SelectAllReturnedQty(ItemID, DateFrom, DateTo, 1); if (TotalCustomerReturns != 0) { NetTotal += TotalCustomerReturns; __PoorRow = aTable1.Rows.Add(); __PoorRow[0] = (AddEmpty) ? EmptyNoborderRow : aItemRow["Barcode"].ToString(); __PoorRow[1] = (AddEmpty) ? EmptyNoborderRow : aItemRow["Description"].ToString(); __PoorRow[2] = "Total Customer Returns"; __PoorRow[3] = Math.Round((TotalCustomerReturns), 3); AddEmpty = true; } if (TotalReversedCustomerReturns != 0) { NetTotal -= TotalReversedCustomerReturns; __PoorRow = aTable1.Rows.Add(); __PoorRow[0] = (AddEmpty) ? EmptyNoborderRow : aItemRow["Barcode"].ToString(); __PoorRow[1] = (AddEmpty) ? EmptyNoborderRow : aItemRow["Description"].ToString(); __PoorRow[2] = "Total Reversed Customer Returns"; __PoorRow[3] = Math.Round((0.00 - TotalReversedCustomerReturns), 3); AddEmpty = true; } double TotalVendorReturns = ReturnItemsVendorDetailedMgmt.SelectAllReturnedQty(ItemID, DateFrom, DateTo, -1); double TotalReversedVendorReturns = ReturnItemsVendorDetailedMgmt.SelectAllReturnedQty(ItemID, DateFrom, DateTo, 1); if (TotalVendorReturns != 0) { NetTotal -= TotalVendorReturns; __PoorRow = aTable1.Rows.Add(); __PoorRow[0] = (AddEmpty) ? EmptyNoborderRow : aItemRow["Barcode"].ToString(); __PoorRow[1] = (AddEmpty) ? EmptyNoborderRow : aItemRow["Description"].ToString(); __PoorRow[2] = "Total Vendors Returns"; __PoorRow[3] = Math.Round((0.00 - TotalVendorReturns), 3); AddEmpty = true; } if (TotalReversedVendorReturns != 0) { NetTotal += TotalReversedVendorReturns; __PoorRow = aTable1.Rows.Add(); __PoorRow[0] = (AddEmpty) ? EmptyNoborderRow : aItemRow["Barcode"].ToString(); __PoorRow[1] = (AddEmpty) ? EmptyNoborderRow : aItemRow["Description"].ToString(); __PoorRow[2] = "Total Reversed Vendors Returns"; __PoorRow[3] = Math.Round((TotalReversedVendorReturns), 3); AddEmpty = true; } if (NetTotal != 0) { __PoorRow = aTable1.Rows.Add(); __PoorRow[0] = (AddEmpty) ? EmptyNoborderRow : aItemRow["Barcode"].ToString(); __PoorRow[1] = (AddEmpty) ? EmptyNoborderRow : aItemRow["Description"].ToString(); __PoorRow[2] = ReportsHelper.MANUAL_TD_OPTION_START + ReportsHelper.UNDERLINE + ReportsHelper.MANUAL_TD_OPTION_END + "TOTAL" + ReportsHelper.MANUAL_TD_END; __PoorRow[3] = ReportsHelper.MANUAL_TD_OPTION_START + ReportsHelper.UNDERLINE + ReportsHelper.MANUAL_TD_OPTION_END + Math.Round((NetTotal), 3) + ReportsHelper.MANUAL_TD_END; AddEmpty = true; } aDTlist.Add(aTable1); List <string> aHeaderList = ReportsHelper.ImportReportHeader(0, 1); List <string> aFooterList = ReportsHelper.ImportReportHeader(1, 1); aHeaderList.Add("<td>" + SharedVariables.Line_Solid_10px_Black); aHeaderList.Add("<b><font size=4>" + Text.ReportsNames.ItemSymmaryStatusRepName + " </font>"); aHeaderList.Add("<b><font size=4>" + Text.ReportsText.DateRepTxt + ": " + DateTime.Now.ToShortDateString() + " </font>"); aHeaderList.Add("<b><font size=4>" + Text.ReportsText.FromRepTxt + ": " + DateFrom + " " + Text.ReportsText.ToRepTxt + ": " + DateTo + " </font>"); aHeaderList.Add("<td>" + SharedVariables.Line_Solid_10px_Black); if (Preview) { PrintingManager.Instance.PrintTables(aDTlist, aHeaderList, aFooterList, ReportsHelper.TempOutputPath, ReportsHelper.TempOutputPath, PrintToThermal, false, false, "", false, "", colored); return(true); } else if (ExportToPdf) { PrintingManager.Instance.PrintTables(aDTlist, aHeaderList, aFooterList, ReportsHelper.TempOutputPath, ReportsHelper.TempOutputPath, PrintToThermal, false, true, ExportPath, false, "", colored); return(true); } else if (ExportToExcel) { PrintingManager.Instance.PrintTables(aDTlist, aHeaderList, aFooterList, ReportsHelper.TempOutputPath, ReportsHelper.TempOutputPath, PrintToThermal, false, false, "", true, ExportPath, colored); return(true); } else if (PrintToThermal) { PrintingManager.Instance.PrintTables(aDTlist, aHeaderList, aFooterList, ReportsHelper.TempOutputPath, ReportsHelper.TempOutputPath, true, true, false, "", false, "", colored); return(true); } else { return(false); } }
public bool VendorsListReport(bool PrintToThermal, bool ExportToPdf = false, bool ExportToExcel = false, string ExportPath = "", bool TableBorder = false, bool Preview = false, bool colored = false) { List <DataTable> aDTlist = new List <DataTable>(); DataTable allVendorsTable = VendorsMgmt.SelectAllVendors(); allVendorsTable.Columns.Remove("ID"); if (TableBorder) { allVendorsTable.Columns[0].ColumnName = "[Border=true1]" + allVendorsTable.Columns[0].ColumnName; } //REMOVING EMPTY COLUMNS List <string> aColumnsToRemove = new List <string>(); foreach (DataColumn aColumn in allVendorsTable.Columns) { bool ColumnEmpty = false; for (int i = 0; i < allVendorsTable.Rows.Count - 1; i++) { if (allVendorsTable.Rows[i][aColumn].ToString().Trim() == "") { ColumnEmpty = true; } else { ColumnEmpty = false; break; } } if (ColumnEmpty) { aColumnsToRemove.Add(aColumn.ColumnName); } } for (int i = 0; i < aColumnsToRemove.Count; i++) { allVendorsTable.Columns.Remove(aColumnsToRemove[i]); } //END REMOVING EMPTY COLUMNS aDTlist.Add(allVendorsTable); List <string> aHeaderList = ReportsHelper.ImportReportHeader(0, 1); List <string> aFooterList = ReportsHelper.ImportReportHeader(1, 1); aHeaderList.Add("<td>" + SharedVariables.Line_Solid_10px_Black); aHeaderList.Add("<b><font size=4>" + "Vendors List Contact" + " </font>"); aHeaderList.Add("<td>" + SharedVariables.Line_Solid_10px_Black); if (Preview) { PrintingManager.Instance.PrintTables(aDTlist, aHeaderList, aFooterList, ReportsHelper.TempOutputPath, ReportsHelper.TempOutputPath, PrintToThermal, false, false, "", false, "", colored); return(true); } else if (ExportToPdf) { PrintingManager.Instance.PrintTables(aDTlist, aHeaderList, aFooterList, ReportsHelper.TempOutputPath, ReportsHelper.TempOutputPath, PrintToThermal, false, true, ExportPath, false, "", colored); return(true); } else if (ExportToExcel) { PrintingManager.Instance.PrintTables(aDTlist, aHeaderList, aFooterList, ReportsHelper.TempOutputPath, ReportsHelper.TempOutputPath, PrintToThermal, false, false, "", true, ExportPath, colored); return(true); } else if (PrintToThermal) { PrintingManager.Instance.PrintTables(aDTlist, aHeaderList, aFooterList, ReportsHelper.TempOutputPath, ReportsHelper.TempOutputPath, true, true); return(true); } else { return(false); } }
//Revenues Comparison public string RevenuesComparison(int ByDDMMYYYY, string DateFrom, string DateTo, bool ExportToExcel = false, string ExportPath = "") { try { string ReportName = "Revenues Comparison Report"; DataTable aTable = ReportsMgmt.RevenuesComparions(ByDDMMYYYY, DateFrom, DateTo); if (aTable.Rows.Count > 0) { xlApp = new Excel.Application(); xlApp.DisplayAlerts = false; xlApp.Visible = false; xlApp.SheetsInNewWorkbook = 1; xlWorkBook = xlApp.Workbooks.Add(misValue);//misValue int RowCnt = 1; xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1); xlWorkSheet.Name = ReportName; List <string> aHeader = ReportsHelper.ImportReportHeader(0, 1); List <string> aFooter = ReportsHelper.ImportReportHeader(1, 1); for (int i = 0; i < aHeader.Count; i++) { xlWorkSheet.Cells[RowCnt, 2] = aHeader[i]; RowCnt++; } xlWorkSheet.Cells[RowCnt++, 1] = ReportName; xlWorkSheet.Cells[RowCnt, 2] = "Date From:\t" + DateFrom; xlWorkSheet.Cells[RowCnt, 3] = "Date To:\t" + DateTo; RowCnt++; xlWorkSheet.Cells[RowCnt, 1] = "Date"; xlWorkSheet.Cells[RowCnt, 2] = "Total Cost JOD"; xlWorkSheet.Cells[RowCnt, 3] = "Total Sales JOD"; xlWorkSheet.Cells[RowCnt, 4] = "Gross Profit JOD"; xlWorkSheet.get_Range("A1", "K" + RowCnt.ToString()).Font.Bold = true; //xlWorkSheet.get_Range("A1", "K" + RowCnt.ToString()).WrapText = true; xlWorkSheet.get_Range("A1", "K" + RowCnt.ToString()).HorizontalAlignment = Excel.XlVAlign.xlVAlignCenter; xlWorkSheet.get_Range("A1", "K" + RowCnt.ToString()).VerticalAlignment = Excel.XlVAlign.xlVAlignCenter; RowCnt++; int DataStart = RowCnt; foreach (DataRow aRow in aTable.Rows) { if (ByDDMMYYYY == 0) //BY DAY { xlWorkSheet.Cells[RowCnt, 1] = aRow["Day"].ToString() + '\\' + aRow["Month"].ToString() + "\\" + aRow["Year"].ToString(); } else if (ByDDMMYYYY == 1)//BY MONTH { xlWorkSheet.Cells[RowCnt, 1] = aRow["Month"].ToString() + '\\' + aRow["Year"].ToString(); } else //BY YEAR { xlWorkSheet.Cells[RowCnt, 1] = aRow["Year"].ToString(); } xlWorkSheet.Cells[RowCnt, 2] = Math.Round(double.Parse(aRow["TotalCost"].ToString()), 2); xlWorkSheet.Cells[RowCnt, 3] = Math.Round(double.Parse(aRow["TotalPrice"].ToString()), 2); xlWorkSheet.Cells[RowCnt, 4] = Math.Round(double.Parse(aRow["TotalProfit"].ToString()), 2); RowCnt++; } xlWorkSheet.get_Range("A" + DataStart.ToString(), "K" + RowCnt.ToString()).HorizontalAlignment = Excel.XlVAlign.xlVAlignCenter; xlWorkSheet.get_Range("A" + DataStart.ToString(), "K" + RowCnt.ToString()).VerticalAlignment = Excel.XlVAlign.xlVAlignCenter; oRng = xlWorkSheet.get_Range("A1", "K" + RowCnt.ToString()); oRng.EntireColumn.AutoFit(); Excel.ChartObjects myCharts = (Excel.ChartObjects)xlWorkSheet.ChartObjects(Type.Missing); xlWorkSheet.DisplayRightToLeft = false; int size = aTable.Rows.Count * 100; if (size > 600) { size = 600; } if (size < 300) { size = 300; } Excel.ChartObject myChart = (Excel.ChartObject)myCharts.Add(0, RowCnt * 15, size, 300); Excel.Chart chartPage = myChart.Chart; Excel.SeriesCollection seriesCollection = chartPage.SeriesCollection(); Excel.Series series1 = seriesCollection.NewSeries(); Excel.Series series2 = seriesCollection.NewSeries(); Excel.Series series3 = seriesCollection.NewSeries(); RowCnt--; //because we started from 1 suppose to be 0 series1.Name = "Total Cost"; series1.XValues = xlWorkSheet.Range["A" + DataStart.ToString(), "A" + RowCnt.ToString()]; series1.Values = xlWorkSheet.Range["B" + DataStart.ToString(), "B" + RowCnt.ToString()]; series2.Name = "Total Sales"; series2.XValues = xlWorkSheet.Range["A" + DataStart.ToString(), "A" + RowCnt.ToString()]; series2.Values = xlWorkSheet.Range["C" + DataStart.ToString(), "C" + RowCnt.ToString()]; series3.Name = "Gross Profit"; series3.XValues = xlWorkSheet.Range["A" + DataStart.ToString(), "A" + RowCnt.ToString()]; series3.Values = xlWorkSheet.Range["D" + DataStart.ToString(), "D" + RowCnt.ToString()]; chartPage.ChartType = Excel.XlChartType.xlLineMarkers; Excel.Axis axis = chartPage.Axes(Excel.XlAxisType.xlValue, Microsoft.Office.Interop.Excel.XlAxisGroup.xlPrimary) as Excel.Axis; series1.ApplyDataLabels(Excel.XlDataLabelsType.xlDataLabelsShowBubbleSizes); series2.ApplyDataLabels(Excel.XlDataLabelsType.xlDataLabelsShowBubbleSizes); series3.ApplyDataLabels(Excel.XlDataLabelsType.xlDataLabelsShowBubbleSizes); object format = Microsoft.Office.Interop.Excel.XlFileFormat.xlHtml; xlWorkSheet.SaveAs(ReportsHelper.TempOutputPath, format); if (ExportToExcel) { format = Microsoft.Office.Interop.Excel.XlFileFormat.xlExcel7; xlWorkSheet.SaveAs(ExportPath, format); } xlApp.UserControl = false; //Once done close and quit Excel return("TRUE"); } else { return("EMPTY"); } } catch (Exception ex) { MessageBox.Show("{EXCEPTION in Revenues Comparison}" + ex.Message + ex.ToString()); return("ERROR " + ex.Message); } finally { //Once done close and quit Excel xlWorkBook.Close(true, misValue, misValue); xlApp.Quit(); releaseObject(xlWorkSheet); releaseObject(xlWorkBook); releaseObject(xlApp); } }
public bool VendorsBalanceListReport(bool PrintToThermal, bool ExportToPdf = false, bool ExportToExcel = false, string ExportPath = "", bool TableBorder = false, bool Preview = false, bool colored = false) { List <DataTable> aDTlist = new List <DataTable>(); DataTable aVendorsTable = VendorsMgmt.SelectAllVendors(); aVendorsTable.Columns.Add("Balance"); DataTable aVendorAccountTable = VendorsAccountsMgmt.SelectAll(); if (aVendorsTable.Rows.Count > 0) { int RowNum = 0; foreach (DataRow r in aVendorsTable.Rows) { if (aVendorAccountTable != null) { for (int i = 0; i < aVendorAccountTable.Rows.Count; i++) { if (int.Parse(aVendorsTable.Rows[RowNum]["ID"].ToString()) == int.Parse(aVendorAccountTable.Rows[i]["VendorID"].ToString())) { aVendorsTable.Rows[RowNum]["Balance"] = aVendorAccountTable.Rows[i]["Amount"].ToString(); } } } RowNum++; } aVendorsTable.Columns.Remove("ID"); if (TableBorder) { aVendorsTable.Columns[0].ColumnName = "[Border=true1]" + aVendorsTable.Columns[0].ColumnName; } //REMOVING EMPTY COLUMNS List <string> aColumnsToRemove = new List <string>(); foreach (DataColumn aColumn in aVendorsTable.Columns) { bool ColumnEmpty = false; for (int i = 0; i < aVendorsTable.Rows.Count - 1; i++) { if (aVendorsTable.Rows[i][aColumn].ToString().Trim() == "") { ColumnEmpty = true; } else { ColumnEmpty = false; break; } } if (ColumnEmpty) { aColumnsToRemove.Add(aColumn.ColumnName); } } for (int i = 0; i < aColumnsToRemove.Count; i++) { aVendorsTable.Columns.Remove(aColumnsToRemove[i]); } //END REMOVING EMPTY COLUMNS aDTlist.Add(aVendorsTable); List <string> aHeaderList = ReportsHelper.ImportReportHeader(0, 1); List <string> aFooterList = ReportsHelper.ImportReportHeader(1, 1); aHeaderList.Add("<td>" + SharedVariables.Line_Solid_10px_Black); aHeaderList.Add("<b><font size=4>" + "Vendors Balances List" + " </font>"); aHeaderList.Add("<td>" + SharedVariables.Line_Solid_10px_Black); if (Preview) { PrintingManager.Instance.PrintTables(aDTlist, aHeaderList, aFooterList, ReportsHelper.TempOutputPath, ReportsHelper.TempOutputPath, PrintToThermal, false, false, "", false, "", colored); return(true); } else if (ExportToPdf) { PrintingManager.Instance.PrintTables(aDTlist, aHeaderList, aFooterList, ReportsHelper.TempOutputPath, ReportsHelper.TempOutputPath, PrintToThermal, false, true, ExportPath, false, "", colored); return(true); } else if (ExportToExcel) { PrintingManager.Instance.PrintTables(aDTlist, aHeaderList, aFooterList, ReportsHelper.TempOutputPath, ReportsHelper.TempOutputPath, PrintToThermal, false, false, "", true, ExportPath, colored); return(true); } else if (PrintToThermal) { PrintingManager.Instance.PrintTables(aDTlist, aHeaderList, aFooterList, ReportsHelper.TempOutputPath, ReportsHelper.TempOutputPath, true, true); return(true); } else { return(false); } } else { return(false); //there is no items in the customer table } }
public string VendorBalanceStatement(int VendorID, string DateFrom, string DateTo, bool TableBorder = false, bool Preview = true, bool PrintToThermal = false, bool ExportToPdf = false, bool ExportToExcel = false, string ExportPath = "", bool colored = false) { List <DataTable> aDTlist = new List <DataTable>(); bool aRevisedExist = false; DataTable aBillDataTable = ReportsMgmt.SelectVendorPurchaseINVOICEsByIDandDate(VendorID, DateFrom, DateTo); DataTable aPaymentDataTable = ReportsMgmt.SelectVendorPaymentsByIDandDate(VendorID, DateFrom, DateTo); #region ConcatTables DataTable ConcatTable = new DataTable(); ConcatTable.Columns.Add("Description"); ConcatTable.Columns.Add("Date", typeof(DateTime)); ConcatTable.Columns.Add("#"); ConcatTable.Columns.Add("Debit"); ConcatTable.Columns.Add("Credit"); int Cnt = 0; char AM = (char)1589; char PM = (char)1605; foreach (DataRow aRow in aPaymentDataTable.Rows) { ConcatTable.Rows.Add(); ConcatTable.Rows[Cnt]["Description"] = "Payment"; ConcatTable.Rows[Cnt]["Date"] = Convert.ToDateTime((Convert.ToDateTime(aRow["Date"]).ToShortDateString() + " " + aRow["Time"].ToString().ToString().Replace((string)(AM + ""), "AM").Replace((string)(PM + ""), "PM"))); ConcatTable.Rows[Cnt]["#"] = aRow["PaymentNumber"]; ConcatTable.Rows[Cnt]["Credit"] = "-"; ConcatTable.Rows[Cnt]["Debit"] = aRow["Amount"]; Cnt++; if (int.Parse(aRow["IsRevised"].ToString()) == 1) { ConcatTable.Rows.Add(); ConcatTable.Rows[Cnt]["Description"] = "Reversed Payment"; ConcatTable.Rows[Cnt]["Date"] = Convert.ToDateTime((Convert.ToDateTime(aRow["ReviseDate"]).ToShortDateString() + " " + aRow["ReviseTime"].ToString().ToString().Replace((string)(AM + ""), "AM").Replace((string)(PM + ""), "PM"))); ConcatTable.Rows[Cnt]["#"] = aRow["PaymentNumber"]; ConcatTable.Rows[Cnt]["Credit"] = double.Parse(aRow["Amount"].ToString()); ConcatTable.Rows[Cnt]["Debit"] = "-"; Cnt++; } } foreach (DataRow aRow in aBillDataTable.Rows) { ConcatTable.Rows.Add(); ConcatTable.Rows[Cnt]["Description"] = "Bill"; ConcatTable.Rows[Cnt]["Date"] = Convert.ToDateTime((Convert.ToDateTime(aRow["Date"]).ToShortDateString() + " " + aRow["Time"].ToString().ToString().Replace((string)(AM + ""), "AM").Replace((string)(PM + ""), "PM"))); ConcatTable.Rows[Cnt]["#"] = aRow["VoucherNumber"]; ConcatTable.Rows[Cnt]["Credit"] = aRow["TotalCost"]; ConcatTable.Rows[Cnt]["Debit"] = "-"; Cnt++; if (int.Parse(aRow["IsRevised"].ToString()) == 1) { ConcatTable.Rows.Add(); ConcatTable.Rows[Cnt]["Description"] = "Reversed Bill"; ConcatTable.Rows[Cnt]["Date"] = Convert.ToDateTime((Convert.ToDateTime(aRow["ReviseDate"]).ToShortDateString() + " " + aRow["ReviseTime"].ToString().ToString().Replace((string)(AM + ""), "AM").Replace((string)(PM + ""), "PM"))); ConcatTable.Rows[Cnt]["#"] = aRow["VoucherNumber"]; ConcatTable.Rows[Cnt]["Credit"] = "-"; ConcatTable.Rows[Cnt]["Debit"] = double.Parse(aRow["TotalCost"].ToString()); Cnt++; } } ConcatTable.DefaultView.Sort = "Date ASC"; ConcatTable = ConcatTable.DefaultView.ToTable(); #endregion ConcatTables DataTable aMergedTable = new DataTable(); aMergedTable.Columns.Add("Description"); aMergedTable.Columns.Add("Date", typeof(DateTime)); aMergedTable.Columns.Add("#"); aMergedTable.Columns.Add("Debit"); aMergedTable.Columns.Add("Credit"); aMergedTable.Columns.Add("Balance"); aMergedTable.Rows.Add(); //for startign balance aMergedTable.Rows[0]["Description"] = "Opening Balance"; aMergedTable.Rows[0]["#"] = "-"; aMergedTable.Rows[0]["Debit"] = "-"; aMergedTable.Rows[0]["Credit"] = "-"; if (aBillDataTable.Rows.Count > 0) { aMergedTable.Rows[0]["Date"] = Convert.ToDateTime(Convert.ToDateTime(aBillDataTable.Rows[0]["Date"]).ToShortDateString() + " " + Convert.ToDateTime(aBillDataTable.Rows[0]["Time"].ToString()).ToShortTimeString()); aMergedTable.Rows[0]["Balance"] = Math.Round(double.Parse(aBillDataTable.Rows[0]["VendorAccountAmountOld"].ToString()), 2); } if (aPaymentDataTable.Rows.Count > 0) { DateTime tempdt = Convert.ToDateTime(Convert.ToDateTime(aPaymentDataTable.Rows[0]["Date"]).ToShortDateString() + " " + Convert.ToDateTime(aPaymentDataTable.Rows[0]["Time"].ToString()).ToShortTimeString()); if (aBillDataTable.Rows.Count > 0) { if (tempdt < Convert.ToDateTime(aMergedTable.Rows[0]["Date"])) { aMergedTable.Rows[0]["Date"] = tempdt; aMergedTable.Rows[0]["Balance"] = Math.Round(double.Parse(aPaymentDataTable.Rows[0]["OldVendorAccountAmount"].ToString()), 2); } } else { aMergedTable.Rows[0]["Date"] = tempdt; aMergedTable.Rows[0]["Balance"] = Math.Round(double.Parse(aPaymentDataTable.Rows[0]["OldVendorAccountAmount"].ToString()), 2); } } double FinalAmount = 0.00; double.TryParse(aMergedTable.Rows[0]["Balance"].ToString(), out FinalAmount); int aCounter = 1; #region OLDCODE //foreach (DataRow aRow in aPaymentDataTable.Rows) //{ // aMergedTable.Rows.Add(); // aMergedTable.Rows[aCounter]["Description"] = "Payment"; // aMergedTable.Rows[aCounter]["Date"] = Convert.ToDateTime(Convert.ToDateTime(aRow["Date"]).ToShortDateString() + " " + Convert.ToDateTime(aRow["Time"].ToString()).ToShortTimeString()); // aMergedTable.Rows[aCounter]["#"] = aRow["PaymentNumber"]; // aMergedTable.Rows[aCounter]["Debit"] = aRow["Amount"]; // aMergedTable.Rows[aCounter]["Credit"] = "-"; // aMergedTable.Rows[aCounter]["Balance"] = Math.Round((double.Parse(aRow["OldVendorAccountAmount"].ToString()) - double.Parse(aMergedTable.Rows[aCounter]["Debit"].ToString())), 2); // aCounter++; // if (int.Parse(aRow["IsRevised"].ToString()) == 1) // { // aRevisedExist = true; // aMergedTable.Rows.Add(); // aMergedTable.Rows[aCounter]["Description"] = "Reversed Invoice"; // aMergedTable.Rows[aCounter]["Date"] = Convert.ToDateTime(Convert.ToDateTime(aRow["ReviseDate"]).ToShortDateString() + " " + Convert.ToDateTime(aRow["ReviseTime"].ToString()).ToShortTimeString()); // aMergedTable.Rows[aCounter]["#"] = aRow["PaymentNumber"]; // aMergedTable.Rows[aCounter]["Credit"] = double.Parse(aRow["Amount"].ToString()); // aMergedTable.Rows[aCounter]["Debit"] = "-"; // aMergedTable.Rows[aCounter]["Balance"] = Math.Round((double.Parse(aMergedTable.Rows[aCounter - 1]["Balance"].ToString()) + double.Parse(aMergedTable.Rows[aCounter]["Credit"].ToString())), 2); // aCounter++; // } //} //foreach (DataRow aRow in aBillDataTable.Rows) //{ // aMergedTable.Rows.Add(); // aMergedTable.Rows[aCounter]["Description"] = "Bill"; // aMergedTable.Rows[aCounter]["Date"] = Convert.ToDateTime(Convert.ToDateTime(aRow["Date"]).ToShortDateString() + " " + Convert.ToDateTime(aRow["Time"].ToString()).ToShortTimeString()); // aMergedTable.Rows[aCounter]["#"] = aRow["VoucherNumber"]; // aMergedTable.Rows[aCounter]["Debit"] = "-"; // aMergedTable.Rows[aCounter]["Credit"] = aRow["TotalCost"]; // aMergedTable.Rows[aCounter]["Balance"] = Math.Round((double.Parse(aRow["VendorAccountAmountOld"].ToString()) + double.Parse(aMergedTable.Rows[aCounter]["Credit"].ToString())), 2); // aCounter++; // if (int.Parse(aRow["IsRevised"].ToString()) == 1) // { // aRevisedExist = true; // aMergedTable.Rows.Add(); // aMergedTable.Rows[aCounter]["Description"] = "Reversed Bill"; // aMergedTable.Rows[aCounter]["Date"] = Convert.ToDateTime(Convert.ToDateTime(aRow["ReviseDate"]).ToShortDateString() + " " + Convert.ToDateTime(aRow["ReviseTime"].ToString()).ToShortTimeString()); // aMergedTable.Rows[aCounter]["#"] = aRow["VoucherNumber"]; // aMergedTable.Rows[aCounter]["Credit"] = "-"; // aMergedTable.Rows[aCounter]["Debit"] = double.Parse(aRow["TotalCost"].ToString()); // aMergedTable.Rows[aCounter]["Balance"] = Math.Round((double.Parse(aMergedTable.Rows[aCounter - 1]["Balance"].ToString()) - double.Parse(aMergedTable.Rows[aCounter]["Debit"].ToString())), 2); // aCounter++; // } //} //aMergedTable.DefaultView.Sort = "Date ASC"; //aMergedTable = aMergedTable.DefaultView.ToTable(); #endregion OLDCODE foreach (DataRow aRow in ConcatTable.Rows) { aMergedTable.Rows.Add(); aMergedTable.Rows[aCounter]["Description"] = aRow["Description"]; aMergedTable.Rows[aCounter]["Date"] = aRow["Date"]; aMergedTable.Rows[aCounter]["#"] = aRow["#"]; if (aRow["Debit"].ToString() != "-") { aMergedTable.Rows[aCounter]["Credit"] = "-"; aMergedTable.Rows[aCounter]["Debit"] = aRow["Debit"]; FinalAmount -= double.Parse(aRow["Debit"].ToString()); } else { aMergedTable.Rows[aCounter]["Credit"] = aRow["Credit"]; aMergedTable.Rows[aCounter]["Debit"] = "-"; FinalAmount += double.Parse(aRow["Credit"].ToString()); } aMergedTable.Rows[aCounter]["Balance"] = Math.Round(FinalAmount, 3); aCounter++; } aMergedTable.Rows.Add(); aMergedTable.Rows[aCounter]["Description"] = "Total"; aMergedTable.Rows[aCounter]["Balance"] = FinalAmount; if (aMergedTable.Rows.Count > 1) { aDTlist.Add(aMergedTable); if (TableBorder) { aMergedTable.Columns[0].ColumnName = "[Border=true1]<th style=\"width:18%\";>" + aMergedTable.Columns[0].ColumnName; } else { aMergedTable.Columns[0].ColumnName = "<th style=\"width:18%\";>" + aMergedTable.Columns[0].ColumnName; } aMergedTable.Columns[1].ColumnName = "<th style=\"width:27%\";>" + aMergedTable.Columns[1].ColumnName; aMergedTable.Columns[2].ColumnName = "<th style=\"width:15%\";>" + aMergedTable.Columns[2].ColumnName; List <string> aHeaderList = ReportsHelper.ImportReportHeader(0, 1); List <string> aFooterList = ReportsHelper.ImportReportHeader(1, 1); double prevrow; double row; double data; if (aRevisedExist) { for (int i = 1; i < aMergedTable.Rows.Count; i++) { if (double.TryParse(aMergedTable.Rows[i - 1]["Balance"].ToString(), out prevrow)) { if (double.TryParse(aMergedTable.Rows[i]["Balance"].ToString(), out row)) { //debit if (double.TryParse(aMergedTable.Rows[i]["Debit"].ToString(), out data)) { aMergedTable.Rows[i]["Balance"] = prevrow - data; } //credit else if (double.TryParse(aMergedTable.Rows[i]["Credit"].ToString(), out data)) { aMergedTable.Rows[i]["Balance"] = prevrow + data; } else { //TOTAL FINALLY aMergedTable.Rows[i]["Balance"] = prevrow; } } } } } aHeaderList.Add(SharedVariables.Line_Solid_10px_Black); aHeaderList.Add(Text.ReportsNames.VenStatementOfAcctRepNm); DataRow vendorName = VendorsMgmt.SelectVendorRowByID(VendorID); //DataRow aCustomerRow = CustomerMgmt.SelectCustomerRowByID(VendorID); aHeaderList.Add(" <h2>Phone:<b>" + vendorName["Phone1"].ToString() + "</b> Name: <b>" + vendorName["Name"].ToString() + "</b></h2>"); aHeaderList.Add("<h2> From: " + DateFrom + " To:" + DateTo + "</h2>"); aHeaderList.Add("<h3>Print By: <b>" + SharedFunctions.ReturnLoggedUserName() + "</b> On <b>" + DateTime.Now + "</b></h3>"); aHeaderList.Add(SharedVariables.Line_Solid_10px_Black); if (Preview) { PrintingManager.Instance.PrintTables(aDTlist, aHeaderList, aFooterList, ReportsHelper.TempOutputPath, ReportsHelper.TempOutputPath, PrintToThermal, false, false, "", false, "", colored); return("True"); } else if (ExportToPdf) { PrintingManager.Instance.PrintTables(aDTlist, aHeaderList, aFooterList, ReportsHelper.TempOutputPath, ReportsHelper.TempOutputPath, PrintToThermal, false, true, ExportPath, false, "", colored); return("True"); } else if (ExportToExcel) { PrintingManager.Instance.PrintTables(aDTlist, aHeaderList, aFooterList, ReportsHelper.TempOutputPath, ReportsHelper.TempOutputPath, PrintToThermal, false, false, "", true, ExportPath, colored); return("True"); } else if (PrintToThermal) { PrintingManager.Instance.PrintTables(aDTlist, aHeaderList, aFooterList, ReportsHelper.TempOutputPath, ReportsHelper.TempOutputPath, true, true); return("True"); } else { return("True"); } } else { return("No-Data"); } }
public static string TaxReport(string FilterDateFrom, string FilterDateTo, bool TableBorder = false, bool Preview = true, bool PrintToThermal = false, bool ExportToPdf = false, bool ExportToExcel = false, string ExportPath = "", bool colored = false) { // string RCV = "<b>recieved</b>"; // string REV = "<b>reversed</b>"; List <string> aStringList = ReportsHelper.ImportReportHeader(0, 1); List <string> aFooterList = ReportsHelper.ImportReportHeader(1, 1); aStringList.Add(SharedVariables.Line_Solid_10px_Black); aStringList.Add("تقرير الضريبة "); aStringList.Add("<h2> Date From: " + FilterDateFrom + "</h2>"); aStringList.Add("<h2> Date To : " + FilterDateTo + "</h2>"); aStringList.Add("<h2>Printed on:" + DateTime.Now.ToShortDateString() + " " + DateTime.Now.ToShortTimeString() + "</h2>"); aStringList.Add("<h2>Printed By: <b>" + SharedFunctions.ReturnLoggedUserName() + "</b></h2>"); aStringList.Add(SharedVariables.Line_Solid_10px_Black); //end headers and foters List <DataTable> aDTList = new List <DataTable>(); DataTable TaxLevelsDT = ItemTaxLevelMgmt.SelectAll(); if (TaxLevelsDT == null) { return("ERROR"); } foreach (DataRow aRow in TaxLevelsDT.Rows) { DataTable TitleTable = new DataTable(); TitleTable.Columns.Add("TaxLevel [ " + aRow["Percentage"].ToString() + "](" + aRow["Description"].ToString() + " )"); aDTList.Add(TitleTable); DataTable aTaxTable = new DataTable(); if (TableBorder) { aTaxTable.Columns.Add("[border=true1]Description"); } else { aTaxTable.Columns.Add("[border=false]Description"); } aTaxTable.Columns.Add("Total JOD"); aTaxTable.Columns.Add("Tax JOD"); double TotalSold = 0; double TotalCost = 0; double TotalCustReturnsSold = 0; double TotalCustReturnsCost = 0; double TotalPurchase = 0; double TotalVendorReturnCost = 0; #region Sales DataRow aSaleRow = ReportsMgmt.SelectSalesTax(int.Parse(aRow["ID"].ToString()), FilterDateFrom, FilterDateTo); if (aSaleRow != null) { if (double.TryParse(aSaleRow["TotalSold"].ToString(), out TotalSold)) { TotalSold = Math.Round(TotalSold, 3); } if (double.TryParse(aSaleRow["TotalCost"].ToString(), out TotalCost)) { TotalCost = Math.Round(TotalCost, 3); } } int RowCnt = 0; aTaxTable.Rows.Add(); aTaxTable.Rows[RowCnt][0] = "Total Sales"; aTaxTable.Rows[RowCnt][1] = TotalSold.ToString(); double TestParser = 0; if (double.TryParse(aRow["Percentage"].ToString(), out TestParser)) { aTaxTable.Rows[RowCnt][2] = Math.Round(TotalSold * TestParser / 100, 3); } else { aTaxTable.Rows[RowCnt][2] = 0; } RowCnt++; aTaxTable.Rows.Add(); aTaxTable.Rows[RowCnt][0] = "Total Sales COST"; aTaxTable.Rows[RowCnt][1] = TotalCost.ToString(); if (double.TryParse(aRow["Percentage"].ToString(), out TestParser)) { aTaxTable.Rows[RowCnt][2] = Math.Round(TotalCost * TestParser / 100, 3); } else { aTaxTable.Rows[RowCnt][2] = 0; } RowCnt++; #endregion Sales #region CustomersReturns DataRow aCustReturnsRow = ReportsMgmt.SelectCustomersReturnsTax(int.Parse(aRow["ID"].ToString()), FilterDateFrom, FilterDateTo); if (aCustReturnsRow != null) { if (double.TryParse(aCustReturnsRow["TotalSold"].ToString(), out TotalCustReturnsSold)) { TotalCustReturnsSold = Math.Round(TotalCustReturnsSold, 3); } if (double.TryParse(aCustReturnsRow["TotalCost"].ToString(), out TotalCustReturnsCost)) { TotalCustReturnsCost = Math.Round(TotalCustReturnsCost, 3); } } aTaxTable.Rows.Add(); aTaxTable.Rows[RowCnt][0] = "Customers Returns"; aTaxTable.Rows[RowCnt][1] = TotalCustReturnsSold.ToString(); TestParser = 0; if (double.TryParse(aRow["Percentage"].ToString(), out TestParser)) { aTaxTable.Rows[RowCnt][2] = Math.Round(TotalCustReturnsSold * TestParser / 100, 3); } else { aTaxTable.Rows[RowCnt][2] = 0; } RowCnt++; aTaxTable.Rows.Add(); aTaxTable.Rows[RowCnt][0] = "Customers Returns COST"; aTaxTable.Rows[RowCnt][1] = TotalCustReturnsCost.ToString(); if (double.TryParse(aRow["Percentage"].ToString(), out TestParser)) { aTaxTable.Rows[RowCnt][2] = Math.Round(TotalCustReturnsCost * TestParser / 100, 3); } else { aTaxTable.Rows[RowCnt][2] = 0; } RowCnt++; #endregion CustomersReturns #region Purchase DataRow aPurchaseRow = ReportsMgmt.SelectPurchaseTax(int.Parse(aRow["ID"].ToString()), FilterDateFrom, FilterDateTo); if (aPurchaseRow != null) { if (double.TryParse(aPurchaseRow["TotalCost"].ToString(), out TotalPurchase)) { TotalPurchase = Math.Round(TotalPurchase, 3); } } aTaxTable.Rows.Add(); aTaxTable.Rows[RowCnt][0] = "Total Purchase COST"; aTaxTable.Rows[RowCnt][1] = TotalPurchase.ToString(); if (double.TryParse(aRow["Percentage"].ToString(), out TestParser)) { aTaxTable.Rows[RowCnt][2] = Math.Round(TotalPurchase * TestParser / 100, 3); } else { aTaxTable.Rows[RowCnt][2] = 0; } RowCnt++; #endregion Purchase #region VendorReturns DataRow aVendorReturnsRow = ReportsMgmt.SelectVendorsReturnsTax(int.Parse(aRow["ID"].ToString()), FilterDateFrom, FilterDateTo); if (aVendorReturnsRow != null) { if (double.TryParse(aVendorReturnsRow["TotalCost"].ToString(), out TotalVendorReturnCost)) { TotalVendorReturnCost = Math.Round(TotalVendorReturnCost, 3); } } aTaxTable.Rows.Add(); aTaxTable.Rows[RowCnt][0] = "Vendors Returns COST"; aTaxTable.Rows[RowCnt][1] = TotalVendorReturnCost.ToString(); TestParser = 0; if (double.TryParse(aRow["Percentage"].ToString(), out TestParser)) { aTaxTable.Rows[RowCnt][2] = Math.Round(TotalVendorReturnCost * TestParser / 100, 3); } else { aTaxTable.Rows[RowCnt][2] = 0; } RowCnt++; #endregion VendorReturns #region Disposal DataRow aDisposalRow = ReportsMgmt.SelectDisposalTax(int.Parse(aRow["ID"].ToString()), FilterDateFrom, FilterDateTo); if (aDisposalRow != null) { if (double.TryParse(aDisposalRow["TotalCost"].ToString(), out TotalCost)) { TotalCost = Math.Round(TotalCost, 3); } } aTaxTable.Rows.Add(); aTaxTable.Rows[RowCnt][0] = "Total Disposals"; aTaxTable.Rows[RowCnt][1] = TotalCost.ToString(); if (double.TryParse(aRow["Percentage"].ToString(), out TestParser)) { aTaxTable.Rows[RowCnt][2] = Math.Round(TotalCost * TestParser / 100, 3); } else { aTaxTable.Rows[RowCnt][2] = 0; } RowCnt++; #endregion Disposal aDTList.Add(aTaxTable); } if (Preview) { PrintingManager.Instance.PrintTables(aDTList, aStringList, aFooterList, ReportsHelper.TempOutputPath, ReportsHelper.TempOutputPath, PrintToThermal, false, false, "", false, "", colored); return("True"); } else if (ExportToPdf) { PrintingManager.Instance.PrintTables(aDTList, aStringList, aFooterList, ReportsHelper.TempOutputPath, ReportsHelper.TempOutputPath, false, false, true, ExportPath, false, "", colored); return("True"); } else if (ExportToExcel) { PrintingManager.Instance.PrintTables(aDTList, aStringList, aFooterList, ReportsHelper.TempOutputPath, ReportsHelper.TempOutputPath, false, false, false, "", ExportToExcel, ExportPath, colored); return("True"); } else if (PrintToThermal) { PrintingManager.Instance.PrintTables(aDTList, aStringList, aFooterList, ReportsHelper.TempOutputPath, ReportsHelper.TempOutputPath, PrintToThermal, true); return("True"); } else { return("ERROR"); } }
public string EndOfPeriodReport(string TellerName, int FilterTellerNameID, string FilterDateFrom, string FilterDateTo, bool TableBorder = false, bool Preview = true, bool PrintToThermal = false, bool ExportToPdf = false, bool ExportToExcel = false, string ExportPath = "", bool colored = false) { /**************************************** END OF PERIOD *********************************/ /* For Teller : Teller Name (s) Date From ----------> To * Printed On : Date::Time * Printed By : Current User Name * ************************************************************************************* * [CASH] * ---------------------------------------- |-------------------------------------------- * | TYPE | AMOUNT (JOD) | * -------------------------------------------------------------------------------------- * | CASH SALES | XXXXXX.XXX | * -------------------------------------------------------------------------------------- * |_______________TOTAL____________________|_______________XXXXXX.XXX__________________| * */ List <DataTable> aDTList = new List <DataTable>(); DataTable aTempTable = null; DataRow aTempRow = null; /*Row Used For filling the datatables*/ #region REPORT HEADER string RCV = "<b>" + Text.ReportsText.ReceivedRepTxt + "</b>"; string REV = "<b>" + Text.ReportsText.ReversedRepTxt + "</b>"; List <string> aStringList = ReportsHelper.ImportReportHeader(0, 1); List <string> aFooterList = ReportsHelper.ImportReportHeader(1, 1); aStringList.Add(SharedVariables.Line_Solid_10px_Black); aStringList.Add(Text.ReportsNames.EndOfPeriodRepNm); aStringList.Add("<h2>" + Text.ReportsText.TellerRepTxt + ": <b>" + TellerName + "</b></h2>"); aStringList.Add("<h2>" + Text.ReportsText.DateRepTxt + " " + Text.ReportsText.FromRepTxt + " : " + FilterDateFrom + " " + Text.ReportsText.ToRepTxt + " :" + FilterDateTo + "</h2>"); aStringList.Add("<h2>" + Text.ReportsText.PrintedOnrepTxt + " : " + DateTime.Now.ToShortDateString() + " " + DateTime.Now.ToShortTimeString() + "</h2>"); aStringList.Add("<h2>" + Text.ReportsText.PrintedByrepTxt + ": <b>" + SharedFunctions.ReturnLoggedUserName() + "</b></h2>"); aStringList.Add(SharedVariables.Line_Solid_10px_Black); #endregion REPORT HEADER #region CASH_HANDLING { /*cash scope*/ double CashSalesDiscount = BillGeneralMgmt.SelectTotalDiscount(FilterDateFrom, FilterDateTo, FilterTellerNameID, -1, PaymentMethodMgmt.CASH_PAYMENT_METHOD, 0); double CashSales = BillGeneralMgmt.SelectSalesAmount(FilterDateFrom, FilterDateTo, FilterTellerNameID, -1, PaymentMethodMgmt.CASH_PAYMENT_METHOD, 0); /*Cash Sales Amount*/ double ReversedCashSales = BillGeneralMgmt.SelectSalesAmount(FilterDateFrom, FilterDateTo, FilterTellerNameID, 1, PaymentMethodMgmt.CASH_PAYMENT_METHOD, 0); double CashSalesReturns = ReturnItemsCustGeneralMGMT.SelectCustomersReturns(FilterDateFrom, FilterDateTo, FilterTellerNameID, 0, -1); double NetTotalCashSales = CashSales - ReversedCashSales - CashSalesReturns; /*discount removed since it is in the added to the sales*/ #region CASH_HANDLING_SALES DataTable aCashTableHeader = new DataTable(); /*Only Header For Cash section*/ aCashTableHeader.Columns.Add(Text.ReportsText.CashSalesRepTxt); /*Title Only row, this is empty datatable*/ aDTList.Add(aCashTableHeader); /*Receieved Cash Sales Handling*/ aTempTable = GetEndOfPeriodInnerTable(TableBorder); aTempRow = aTempTable.Rows.Add(); aTempRow[0] = Text.ReportsText.CshSalesRepTxt;/*Cash Sales*/ aTempRow[1] = CashSales + CashSalesDiscount; /*Reversed Cash Sales Handling*/ aTempRow = aTempTable.Rows.Add(); aTempRow[0] = Text.ReportsText.RevCashSalesRepTxt;/*ReversedCash Sales*/ aTempRow[1] = ReversedCashSales; /*Cash Sales Discounts*/ aTempRow = aTempTable.Rows.Add(); aTempRow[0] = Text.ReportsText.CashSalesDiscountRepTxt;/*ReversedCash Sales*/ aTempRow[1] = CashSalesDiscount; /*Cash Sales Returns*/ aTempRow = aTempTable.Rows.Add(); aTempRow[0] = Text.ReportsText.CashSalesReturnsRepTxt; /*Cash Sales Returns;*/ aTempRow[1] = CashSalesReturns; /*NET Cash Sales*/ aTempRow = aTempTable.Rows.Add(); aTempRow[0] = ReportsHelper.MANUAL_TD_OPTION_START + ReportsHelper.NOBORDER + ReportsHelper.UNDERLINE + ReportsHelper.MANUAL_TD_OPTION_END + ReportsHelper.MANUAL_TD_END; aTempRow[1] = ReportsHelper.MANUAL_TD_OPTION_START + ReportsHelper.NOBORDER + ReportsHelper.UNDERLINE + ReportsHelper.BOLD + ReportsHelper.MANUAL_TD_OPTION_END + Text.ReportsText.TotalTxt + " " + NetTotalCashSales + ReportsHelper.MANUAL_TD_END; aDTList.Add(aTempTable); #endregion CASH_HANDLING_SALES double CashCustPayment = CustomersPaymentsMgmt.SelectCustomerPayments(FilterDateFrom, FilterDateTo, FilterTellerNameID, 0, PaymentMethodMgmt.CASH_PAYMENT_METHOD); double CashVendorPayment = VendorsPaymentsMgmt.SelectCustomerPayments(FilterDateFrom, FilterDateTo, FilterTellerNameID, 0, PaymentMethodMgmt.CASH_PAYMENT_METHOD); double NetCashPayments = CashCustPayment - CashVendorPayment; #region CASH_HANDLING_PAYMENTS DataTable aPaymentsTableHeader = new DataTable(); /*Only Header For Cash section*/ aPaymentsTableHeader.Columns.Add(Text.ReportsText.CashPaymentsRepTxt); /*Title Only row, this is empty datatable*/ aDTList.Add(aPaymentsTableHeader); /*Cash Customer Payments*/ aTempTable = GetEndOfPeriodInnerTable(TableBorder); aTempRow = aTempTable.Rows.Add(); aTempRow[0] = Text.ReportsText.CashCustPaymentsRepTxt;/*Cash Sales*/ aTempRow[1] = CashCustPayment; /*Cash Vendors Payments*/ aTempRow = aTempTable.Rows.Add(); aTempRow[0] = Text.ReportsText.CashVendPaymentsRepTxt;/*Cash Sales*/ aTempRow[1] = CashVendorPayment; /*Net Cash Payments*/ aTempRow = aTempTable.Rows.Add(); aTempRow[0] = ReportsHelper.MANUAL_TD_OPTION_START + ReportsHelper.NOBORDER + ReportsHelper.UNDERLINE + ReportsHelper.MANUAL_TD_OPTION_END + ReportsHelper.MANUAL_TD_END; aTempRow[1] = ReportsHelper.MANUAL_TD_OPTION_START + ReportsHelper.NOBORDER + ReportsHelper.UNDERLINE + ReportsHelper.BOLD + ReportsHelper.MANUAL_TD_OPTION_END + Text.ReportsText.TotalTxt + " " + NetCashPayments + ReportsHelper.MANUAL_TD_END; aDTList.Add(aTempTable); #endregion CASH_HANDLING_PAYMENTS double CashPurchaseDiscount = PurchaseVoucherGeneralMgmt.SelectTotalDiscount(FilterDateFrom, FilterDateTo, FilterTellerNameID, -1, PaymentMethodMgmt.CASH_PAYMENT_METHOD, -1); double CashPurchase = PurchaseVoucherGeneralMgmt.SelectPurchaseAmount(FilterDateFrom, FilterDateTo, FilterTellerNameID, -1, PaymentMethodMgmt.CASH_PAYMENT_METHOD, 0);/*Cash Sales Amount*/ double ReversedCashPurchase = PurchaseVoucherGeneralMgmt.SelectPurchaseAmount(FilterDateFrom, FilterDateTo, FilterTellerNameID, 1, PaymentMethodMgmt.CASH_PAYMENT_METHOD, -1); double CashPurchaseReturns = ReturnItemsVendorGeneralMgmt.SelectVendorReturns(FilterDateFrom, FilterDateTo, FilterTellerNameID, 0, -1); double NetTotalCashPurchase = -CashPurchase + ReversedCashPurchase + CashPurchaseReturns; /*discount removed since it is in the added to the sales*/ #region CASH_HANDLING_PURCHASE DataTable aCashPurchaseTableHeader = new DataTable(); /*Only Header For Cash section*/ aCashPurchaseTableHeader.Columns.Add(Text.ReportsText.CashPurchaseRepTxt); /*Title Only row, this is empty datatable*/ aDTList.Add(aCashPurchaseTableHeader); /*CASH PURCHASES*/ aTempTable = GetEndOfPeriodInnerTable(TableBorder); aTempRow = aTempTable.Rows.Add(); aTempRow[0] = Text.ReportsText.CashPurchaseRepTxt; aTempRow[1] = CashPurchase + CashPurchaseDiscount; /*REVERSED CASH PURCHASES*/ aTempRow = aTempTable.Rows.Add(); aTempRow[0] = Text.ReportsText.RevCashPurchaseRepTxt;/*ReversedCash Sales*/ aTempRow[1] = ReversedCashPurchase; /*Cash Purchase Discounts*/ aTempRow = aTempTable.Rows.Add(); aTempRow[0] = Text.ReportsText.CashPurchaseDiscountRepTxt;/*ReversedCash Sales*/ aTempRow[1] = CashPurchaseDiscount; /*Cash Purchase Returns*/ aTempRow = aTempTable.Rows.Add(); aTempRow[0] = Text.ReportsText.CashPurchaseReturnRepTxt; /*Cash Sales Returns;*/ aTempRow[1] = CashPurchaseReturns; /*NET Cash Purchase*/ aTempRow = aTempTable.Rows.Add(); aTempRow[0] = ReportsHelper.MANUAL_TD_OPTION_START + ReportsHelper.NOBORDER + ReportsHelper.UNDERLINE + ReportsHelper.MANUAL_TD_OPTION_END + ReportsHelper.MANUAL_TD_END; aTempRow[1] = ReportsHelper.MANUAL_TD_OPTION_START + ReportsHelper.NOBORDER + ReportsHelper.UNDERLINE + ReportsHelper.BOLD + ReportsHelper.MANUAL_TD_OPTION_END + Text.ReportsText.TotalTxt + " " + NetTotalCashPurchase + ReportsHelper.MANUAL_TD_END; aDTList.Add(aTempTable); #endregion CASH_HANDLING_PURCHASE double TotalCash = NetTotalCashSales + NetCashPayments - NetTotalCashPurchase; DataTable aFinalCashTable = new DataTable(); aFinalCashTable.Columns.Add(Text.ReportsText.TotalCashAmountTxt + " " + TotalCash.ToString() + " JOD <hr/>"); aDTList.Add(aFinalCashTable); }/*end cash scope*/ #endregion CASH_HANDLING #region INVOICE_CARD_HANDLING { /*Invoice Scope*/ double InvoiceSalesDiscount = BillGeneralMgmt.SelectTotalDiscount(FilterDateFrom, FilterDateTo, FilterTellerNameID, -1, PaymentMethodMgmt.CASH_PAYMENT_METHOD, 1); double InvoiceSales = BillGeneralMgmt.SelectSalesAmount(FilterDateFrom, FilterDateTo, FilterTellerNameID, -1, PaymentMethodMgmt.CASH_PAYMENT_METHOD, 1); /*Cash Sales Amount*/ double ReversedInvoiceSales = BillGeneralMgmt.SelectSalesAmount(FilterDateFrom, FilterDateTo, FilterTellerNameID, 1, PaymentMethodMgmt.CASH_PAYMENT_METHOD, 1); double NetTotalInvoiceSales = InvoiceSales - ReversedInvoiceSales; /*discount removed since it is in the added to the sales*/ #region INVOICE_HANDLING_SALES DataTable aCashTableHeader = new DataTable(); /*Only Header For Cash section*/ aCashTableHeader.Columns.Add(Text.ReportsText.InvoiceSalesRepTxt); /*Title Only row, this is empty datatable*/ aDTList.Add(aCashTableHeader); /*Receieved Cash Sales Handling*/ aTempTable = GetEndOfPeriodInnerTable(TableBorder); aTempRow = aTempTable.Rows.Add(); aTempRow[0] = Text.ReportsText.InvoiceSalesRepTxt;/*Cash Sales*/ aTempRow[1] = InvoiceSalesDiscount + InvoiceSales; /*Reversed Cash Sales Handling*/ aTempRow = aTempTable.Rows.Add(); aTempRow[0] = Text.ReportsText.RevInvoiceSalesRepTxt;/*ReversedCash Sales*/ aTempRow[1] = ReversedInvoiceSales; /*Cash Sales Discounts*/ aTempRow = aTempTable.Rows.Add(); aTempRow[0] = Text.ReportsText.InvoiceDiscountRepTxt;/*ReversedCash Sales*/ aTempRow[1] = InvoiceSalesDiscount; /*NET Cash Sales*/ aTempRow = aTempTable.Rows.Add(); aTempRow[0] = ReportsHelper.MANUAL_TD_OPTION_START + ReportsHelper.NOBORDER + ReportsHelper.UNDERLINE + ReportsHelper.MANUAL_TD_OPTION_END + ReportsHelper.MANUAL_TD_END; aTempRow[1] = ReportsHelper.MANUAL_TD_OPTION_START + ReportsHelper.NOBORDER + ReportsHelper.UNDERLINE + ReportsHelper.BOLD + ReportsHelper.MANUAL_TD_OPTION_END + Text.ReportsText.TotalTxt + " " + NetTotalInvoiceSales + ReportsHelper.MANUAL_TD_END; aDTList.Add(aTempTable); #endregion INVOICE_HANDLING_SALES double InvoicePurchaseDiscount = PurchaseVoucherGeneralMgmt.SelectTotalDiscount(FilterDateFrom, FilterDateTo, FilterTellerNameID, -1, PaymentMethodMgmt.CASH_PAYMENT_METHOD, 1); double InvoicePurchase = PurchaseVoucherGeneralMgmt.SelectPurchaseAmount(FilterDateFrom, FilterDateTo, FilterTellerNameID, -1, PaymentMethodMgmt.CASH_PAYMENT_METHOD, 1); /*Cash Sales Amount*/ double ReversedInvoicePurchase = PurchaseVoucherGeneralMgmt.SelectPurchaseAmount(FilterDateFrom, FilterDateTo, FilterTellerNameID, 1, PaymentMethodMgmt.CASH_PAYMENT_METHOD, 1); double NetTotalInvoicePurchase = -InvoicePurchase + ReversedInvoicePurchase; /*discount removed since it is in the added to the sales*/ #region Invoice_HANDLING_PURCHASE DataTable aCashPurchaseTableHeader = new DataTable(); /*Only Header For Cash section*/ aCashPurchaseTableHeader.Columns.Add(Text.ReportsText.InvoicePurchaseRepTxt); /*Title Only row, this is empty datatable*/ aDTList.Add(aCashPurchaseTableHeader); /*CASH PURCHASES*/ aTempTable = GetEndOfPeriodInnerTable(TableBorder); aTempRow = aTempTable.Rows.Add(); aTempRow[0] = Text.ReportsText.InvoicePurchaseRepTxt; aTempRow[1] = InvoicePurchase + InvoicePurchaseDiscount; /*REVERSED CASH PURCHASES*/ aTempRow = aTempTable.Rows.Add(); aTempRow[0] = Text.ReportsText.RevInvoicePurchaseRepTxt;/*ReversedCash Sales*/ aTempRow[1] = ReversedInvoicePurchase; /*Cash Purchase Discounts*/ aTempRow = aTempTable.Rows.Add(); aTempRow[0] = Text.ReportsText.InvoicePurchaseDiscountRepTxt;/*ReversedCash Sales*/ aTempRow[1] = InvoicePurchaseDiscount; /*NET Cash Purchase*/ aTempRow = aTempTable.Rows.Add(); aTempRow[0] = ReportsHelper.MANUAL_TD_OPTION_START + ReportsHelper.NOBORDER + ReportsHelper.UNDERLINE + ReportsHelper.MANUAL_TD_OPTION_END + ReportsHelper.MANUAL_TD_END; aTempRow[1] = ReportsHelper.MANUAL_TD_OPTION_START + ReportsHelper.NOBORDER + ReportsHelper.UNDERLINE + ReportsHelper.BOLD + ReportsHelper.MANUAL_TD_OPTION_END + Text.ReportsText.TotalTxt + " " + NetTotalInvoicePurchase + ReportsHelper.MANUAL_TD_END; aDTList.Add(aTempTable); #endregion Invoice_HANDLING_PURCHASE double TotalInvoice = NetTotalInvoiceSales - NetTotalInvoicePurchase; DataTable aFinalInvoiceTable = new DataTable(); aFinalInvoiceTable.Columns.Add(Text.ReportsText.TotalInvoiceAmountTxt + " " + TotalInvoice.ToString() + " JOD <hr/>"); aDTList.Add(aFinalInvoiceTable); }/*End Invoice Scope*/ #endregion INVOICE_CARD_HANDLING #region CREDIT_CARD_HANDLING { /*Credit Scope*/ double CreditSalesDiscount = BillGeneralMgmt.SelectTotalDiscount(FilterDateFrom, FilterDateTo, FilterTellerNameID, -1, PaymentMethodMgmt.CREDITCARD_PAYMENT_METHOD, -1); double CreditSales = BillGeneralMgmt.SelectSalesAmount(FilterDateFrom, FilterDateTo, FilterTellerNameID, -1, PaymentMethodMgmt.CREDITCARD_PAYMENT_METHOD, -1); /*Cash Sales Amount*/ double ReversedCreditSales = BillGeneralMgmt.SelectSalesAmount(FilterDateFrom, FilterDateTo, FilterTellerNameID, 1, PaymentMethodMgmt.CREDITCARD_PAYMENT_METHOD, -1); double NetTotalCreditSales = CreditSales - ReversedCreditSales; /*discount removed since it is in the added to the sales*/ #region CREDIT_HANDLING_SALES DataTable aCashTableHeader = new DataTable(); /*Only Header For Cash section*/ aCashTableHeader.Columns.Add(Text.ReportsText.CreditSalesRepTxt); /*Title Only row, this is empty datatable*/ aDTList.Add(aCashTableHeader); /*Receieved Cash Sales Handling*/ aTempTable = GetEndOfPeriodInnerTable(TableBorder); aTempRow = aTempTable.Rows.Add(); aTempRow[0] = Text.ReportsText.CreditSalesRepTxt;/*Cash Sales*/ aTempRow[1] = CreditSales + CreditSalesDiscount; /*Reversed Cash Sales Handling*/ aTempRow = aTempTable.Rows.Add(); aTempRow[0] = Text.ReportsText.RevCreditSalesRepTxt;/*ReversedCash Sales*/ aTempRow[1] = ReversedCreditSales; /*Cash Sales Discounts*/ aTempRow = aTempTable.Rows.Add(); aTempRow[0] = Text.ReportsText.CreditSalesDiscountRepTxt;/*ReversedCash Sales*/ aTempRow[1] = CreditSalesDiscount; /*NET Cash Sales*/ aTempRow = aTempTable.Rows.Add(); aTempRow[0] = ReportsHelper.MANUAL_TD_OPTION_START + ReportsHelper.NOBORDER + ReportsHelper.UNDERLINE + ReportsHelper.MANUAL_TD_OPTION_END + ReportsHelper.MANUAL_TD_END; aTempRow[1] = ReportsHelper.MANUAL_TD_OPTION_START + ReportsHelper.NOBORDER + ReportsHelper.UNDERLINE + ReportsHelper.BOLD + ReportsHelper.MANUAL_TD_OPTION_END + Text.ReportsText.TotalTxt + " " + NetTotalCreditSales + ReportsHelper.MANUAL_TD_END; aDTList.Add(aTempTable); #endregion CREDIT_HANDLING_SALES double CreditCustPayment = CustomersPaymentsMgmt.SelectCustomerPayments(FilterDateFrom, FilterDateTo, FilterTellerNameID, 0, PaymentMethodMgmt.CREDITCARD_PAYMENT_METHOD); double CreditVendorPayment = VendorsPaymentsMgmt.SelectCustomerPayments(FilterDateFrom, FilterDateTo, FilterTellerNameID, 0, PaymentMethodMgmt.CREDITCARD_PAYMENT_METHOD); double NetCreditPayments = CreditCustPayment - CreditVendorPayment; #region CREDIT_HANDLING_PAYMENTS DataTable aPaymentsTableHeader = new DataTable(); /*Only Header For Cash section*/ aPaymentsTableHeader.Columns.Add(Text.ReportsText.CreditPaymentsRepTxt); /*Title Only row, this is empty datatable*/ aDTList.Add(aPaymentsTableHeader); /*Cash Customer Payments*/ aTempTable = GetEndOfPeriodInnerTable(TableBorder); aTempRow = aTempTable.Rows.Add(); aTempRow[0] = Text.ReportsText.CreditCustPaymentsRepTxt;/*Cash Sales*/ aTempRow[1] = CreditCustPayment; /*Cash Vendors Payments*/ aTempRow = aTempTable.Rows.Add(); aTempRow[0] = Text.ReportsText.CreditVendPaymentsRepTxt;/*Cash Sales*/ aTempRow[1] = CreditVendorPayment; /*Net Cash Payments*/ aTempRow = aTempTable.Rows.Add(); aTempRow[0] = ReportsHelper.MANUAL_TD_OPTION_START + ReportsHelper.NOBORDER + ReportsHelper.UNDERLINE + ReportsHelper.MANUAL_TD_OPTION_END + ReportsHelper.MANUAL_TD_END; aTempRow[1] = ReportsHelper.MANUAL_TD_OPTION_START + ReportsHelper.NOBORDER + ReportsHelper.UNDERLINE + ReportsHelper.BOLD + ReportsHelper.MANUAL_TD_OPTION_END + Text.ReportsText.TotalTxt + " " + NetCreditPayments + ReportsHelper.MANUAL_TD_END; aDTList.Add(aTempTable); #endregion CREDIT_HANDLING_PAYMENTS double CreditPurchaseDiscount = PurchaseVoucherGeneralMgmt.SelectTotalDiscount(FilterDateFrom, FilterDateTo, FilterTellerNameID, -1, PaymentMethodMgmt.CREDITCARD_PAYMENT_METHOD, -1); double CreditPurchase = PurchaseVoucherGeneralMgmt.SelectPurchaseAmount(FilterDateFrom, FilterDateTo, FilterTellerNameID, -1, PaymentMethodMgmt.CREDITCARD_PAYMENT_METHOD, -1); /*Cash Sales Amount*/ double ReversedCreditPurchase = PurchaseVoucherGeneralMgmt.SelectPurchaseAmount(FilterDateFrom, FilterDateTo, FilterTellerNameID, 1, PaymentMethodMgmt.CREDITCARD_PAYMENT_METHOD, -1); double NetTotalCreditPurchase = -CreditPurchase + ReversedCreditPurchase; /*discount removed since it is in the added to the sales*/ #region CREDIT_HANDLING_PURCHASE DataTable aCashPurchaseTableHeader = new DataTable(); /*Only Header For Cash section*/ aCashPurchaseTableHeader.Columns.Add(Text.ReportsText.CreditPurchaseRepTxt); /*Title Only row, this is empty datatable*/ aDTList.Add(aCashPurchaseTableHeader); /*CASH PURCHASES*/ aTempTable = GetEndOfPeriodInnerTable(TableBorder); aTempRow = aTempTable.Rows.Add(); aTempRow[0] = Text.ReportsText.CreditPurchaseRepTxt; aTempRow[1] = CreditPurchase + CreditPurchaseDiscount; /*REVERSED CASH PURCHASES*/ aTempRow = aTempTable.Rows.Add(); aTempRow[0] = Text.ReportsText.RevCreditPurchaseRepTxt;/*ReversedCash Sales*/ aTempRow[1] = ReversedCreditPurchase; /*Cash Purchase Discounts*/ aTempRow = aTempTable.Rows.Add(); aTempRow[0] = Text.ReportsText.CreditPurchaseDiscountRepTxt;/*ReversedCash Sales*/ aTempRow[1] = CreditPurchaseDiscount; /*NET Cash Purchase*/ aTempRow = aTempTable.Rows.Add(); aTempRow[0] = ReportsHelper.MANUAL_TD_OPTION_START + ReportsHelper.NOBORDER + ReportsHelper.UNDERLINE + ReportsHelper.MANUAL_TD_OPTION_END + ReportsHelper.MANUAL_TD_END; aTempRow[1] = ReportsHelper.MANUAL_TD_OPTION_START + ReportsHelper.NOBORDER + ReportsHelper.UNDERLINE + ReportsHelper.BOLD + ReportsHelper.MANUAL_TD_OPTION_END + Text.ReportsText.TotalTxt + " " + NetTotalCreditPurchase + ReportsHelper.MANUAL_TD_END; aDTList.Add(aTempTable); #endregion CREDIT_HANDLING_PURCHASE double TotalCredit = NetTotalCreditSales + NetCreditPayments - NetTotalCreditPurchase; DataTable aFinalCreditTable = new DataTable(); aFinalCreditTable.Columns.Add(Text.ReportsText.TotalCreditAmountTxt + " " + TotalCredit.ToString() + " JOD <hr/>"); aDTList.Add(aFinalCreditTable); }/*End Credit Scope*/ #endregion CREDIT_HANDLING_PURCHASE #region SENDING_FOR_PRINTING_MANAGER if (Preview) { PrintingManager.Instance.PrintTables(aDTList, aStringList, aFooterList, ReportsHelper.TempOutputPath, ReportsHelper.TempOutputPath, PrintToThermal, false, false, "", false, "", colored); return("True"); } else if (ExportToPdf) { PrintingManager.Instance.PrintTables(aDTList, aStringList, aFooterList, ReportsHelper.TempOutputPath, ReportsHelper.TempOutputPath, false, false, true, ExportPath, false, "", colored); return("True"); } else if (ExportToExcel) { PrintingManager.Instance.PrintTables(aDTList, aStringList, aFooterList, ReportsHelper.TempOutputPath, ReportsHelper.TempOutputPath, false, false, false, "", ExportToExcel, ExportPath, colored); return("True"); } else if (PrintToThermal) { PrintingManager.Instance.PrintTables(aDTList, aStringList, aFooterList, ReportsHelper.TempOutputPath, ReportsHelper.TempOutputPath, PrintToThermal, true); return("True"); } else { return("ERROR"); } #endregion SENDING_FOR_PRINTING_MANAGER }
public bool InvValuationSummaryStatus(bool PrintToThermal, bool ExportToPdf = false, bool ExportToExcel = false, string ExportPath = "", bool TableBorder = false, bool Preview = false, bool colored = false) { try { List <DataTable> aDTlist = new List <DataTable>(); DataTable ItemsDatatable = ItemsMgmt.SelectAllItems(); if (ItemsDatatable == null) { return(false); } else { if (ItemsDatatable.Rows.Count == 0) { return(false); } } DataTable ToPrintTable = new DataTable(); ToPrintTable.Columns.Add("Name"); ToPrintTable.Columns.Add("Ava Qty"); ToPrintTable.Columns.Add("Avg Cost"); ToPrintTable.Columns.Add("Inventory Value"); ToPrintTable.Columns.Add("% of Tot Inventory"); ToPrintTable.Columns.Add("Selling Price"); ToPrintTable.Columns.Add("Retail Value"); ToPrintTable.Columns.Add("% of Tot Retail"); double AvgCost = 0.00, AvaQty = 0.00, SellingPrice = 0.00; double TotalInvValue = 0.00; /*this to be used in the second loop*/ double TotalRetailValue = 0.00; /*this to be used in the second loop*/ double TotalQty = 0.00; foreach (DataRow r in ItemsDatatable.Rows) { AvgCost = double.Parse(r["AvgUnitCost"].ToString()); AvaQty = double.Parse(r["Qty"].ToString()); SellingPrice = double.Parse(r["SellPrice"].ToString()); if (AvaQty <= 0) { continue; } TotalRetailValue += (SellingPrice * AvaQty); TotalInvValue += (AvgCost * AvaQty); } foreach (DataRow r in ItemsDatatable.Rows) { AvgCost = double.Parse(r["AvgUnitCost"].ToString()); AvaQty = double.Parse(r["Qty"].ToString()); TotalQty += AvaQty; if (AvaQty <= 0) { continue; } DataRow aRow = ToPrintTable.Rows.Add(); aRow["Name"] = r["Description"]; aRow["Ava Qty"] = Math.Round(AvaQty, 3); aRow["Avg Cost"] = Math.Round(AvgCost, 3); aRow["Inventory Value"] = Math.Round(AvgCost * AvaQty, 3); SellingPrice = double.Parse(r["SellPrice"].ToString()); aRow["Selling Price"] = Math.Round(SellingPrice, 3); aRow["Retail Value"] = Math.Round(SellingPrice * AvaQty, 3); aRow["% of Tot Inventory"] = Math.Round(((AvgCost * AvaQty) / TotalInvValue) * 100, 3).ToString() + " %"; aRow["% of Tot Retail"] = Math.Round(((SellingPrice * AvaQty) / TotalRetailValue) * 100, 3).ToString() + " %"; } DataRow FinalRow = ToPrintTable.Rows.Add(); FinalRow["Name"] = "<td style=\"text-decoration:underline;\">" + "T O T A L"; FinalRow["Ava Qty"] = "<td style=\"text-decoration:underline;\">" + Math.Round(TotalQty, 3); FinalRow["Avg Cost"] = "<td style=\"text-decoration:underline;\">" + " "; FinalRow["Selling Price"] = "<td style=\"text-decoration:underline;\">" + " "; FinalRow["Inventory Value"] = "<td style=\"text-decoration:underline;\">" + Math.Round(TotalInvValue, 3); FinalRow["Retail Value"] = "<td style=\"text-decoration:underline;\">" + Math.Round(TotalRetailValue, 3); FinalRow["% of Tot Inventory"] = "<td style=\"text-decoration:underline;\">" + "100%"; FinalRow["% of Tot Retail"] = "<td style=\"text-decoration:underline;\">" + "100%"; if (TableBorder) { ToPrintTable.Columns[0].ColumnName = "[Border=true1]" + ToPrintTable.Columns[0].ColumnName; } aDTlist.Add(ToPrintTable); List <string> aHeaderList = ReportsHelper.ImportReportHeader(0, 1); List <string> aFooterList = ReportsHelper.ImportReportHeader(1, 1); aHeaderList.Add("<td>" + SharedVariables.Line_Solid_10px_Black); aHeaderList.Add("<b><font size=4>" + Text.ReportsNames.InvvaluationSummaryRepNm + " </font>"); aHeaderList.Add("<b><font size=2>" + Text.ReportsText.DateRepTxt + ": " + DateTime.Now.ToShortDateString() + " </font>"); aHeaderList.Add("<td>" + SharedVariables.Line_Solid_10px_Black); if (Preview) { PrintingManager.Instance.PrintTables(aDTlist, aHeaderList, aFooterList, ReportsHelper.TempOutputPath, ReportsHelper.TempOutputPath, PrintToThermal, false, false, "", false, "", colored); return(true); } else if (ExportToPdf) { PrintingManager.Instance.PrintTables(aDTlist, aHeaderList, aFooterList, ReportsHelper.TempOutputPath, ReportsHelper.TempOutputPath, PrintToThermal, false, true, ExportPath, false, "", colored); return(true); } else if (ExportToExcel) { PrintingManager.Instance.PrintTables(aDTlist, aHeaderList, aFooterList, ReportsHelper.TempOutputPath, ReportsHelper.TempOutputPath, PrintToThermal, false, false, "", true, ExportPath, colored); return(true); } else if (PrintToThermal) { PrintingManager.Instance.PrintTables(aDTlist, aHeaderList, aFooterList, ReportsHelper.TempOutputPath, ReportsHelper.TempOutputPath, true, true, false, "", false, "", colored); return(true); } else { return(false); } } catch (Exception ex) { throw new Exception(ex.Message); } }
public bool PrintItemsList(bool RenderPoint, bool PrintToThermal, bool ExportToPdf = false, bool ExportToExcel = false, string ExportPath = "", bool TableBorder = false, bool Preview = false, bool colored = false) { try { List <DataTable> aDTlist = new List <DataTable>(); DataTable ItemsDatatable = null; if (RenderPoint) { ItemsDatatable = ItemsMgmt.RenderPoint(); } else { ItemsDatatable = ItemsMgmt.SelectAllItems(); } if (ItemsDatatable == null) { return(false); } else { if (ItemsDatatable.Rows.Count == 0) { return(false); } } DataTable ItemCategoryDataTable = ItemCategoryMgmt.SelectAll(); DataTable VendorsDataTable = VendorsMgmt.SelectAllVendors(); DataTable ItemsTypeDataTalbe = ItemTypeMgmt.SelectAll(); int itemcategoryrowsnumber = ItemCategoryDataTable.Rows.Count; int vendorrowsnumber = VendorsDataTable.Rows.Count; int typerowsnumber = ItemsTypeDataTalbe.Rows.Count; DataTable ToPrintTable = new DataTable(); ToPrintTable.Columns.Add("Barcode"); ToPrintTable.Columns.Add("Description"); ToPrintTable.Columns.Add("Ava.Qty"); ToPrintTable.Columns.Add("Avg Cost"); ToPrintTable.Columns.Add("Type"); ToPrintTable.Columns.Add("Category"); ToPrintTable.Columns.Add("Pref.Vendor"); if (RenderPoint) { ToPrintTable.Columns.Add("Phone"); } foreach (DataRow r in ItemsDatatable.Rows) { DataRow aRow = ToPrintTable.Rows.Add(); aRow["Barcode"] = r["Barcode"]; aRow["Description"] = r["Description"]; aRow["Ava.Qty"] = Math.Round(double.Parse(r["Qty"].ToString()), 3); aRow["Avg Cost"] = Math.Round(double.Parse(r["AvgUnitCost"].ToString()), 3); for (int i = 0; i < typerowsnumber; i++) { if (int.Parse(ItemsTypeDataTalbe.Rows[i]["ID"].ToString()) == int.Parse(r["Type"].ToString())) { aRow["Type"] = ItemsTypeDataTalbe.Rows[i]["Name"].ToString(); break; } } for (int i = 0; i < itemcategoryrowsnumber; i++) { if (int.Parse(ItemCategoryDataTable.Rows[i]["ID"].ToString()) == int.Parse(r["Category"].ToString())) { aRow["Category"] = ItemCategoryDataTable.Rows[i]["Name"].ToString(); break; } } for (int i = 0; i < vendorrowsnumber; i++) { if (int.Parse(VendorsDataTable.Rows[i]["ID"].ToString()) == int.Parse(r["Vendor"].ToString())) { aRow["Pref.Vendor"] = VendorsDataTable.Rows[i]["Name"].ToString(); if (RenderPoint) { aRow["Phone"] = VendorsDataTable.Rows[i]["Phone1"].ToString(); } break; } } } if (TableBorder) { ToPrintTable.Columns[0].ColumnName = "[Border=true1]" + ToPrintTable.Columns[0].ColumnName; } if (RenderPoint) { ToPrintTable.Columns.Remove("Category"); } ToPrintTable.Columns["Description"].ColumnName = ("<th width=30%> Description"); ToPrintTable.Columns.Remove("Type"); aDTlist.Add(ToPrintTable); List <string> aHeaderList = ReportsHelper.ImportReportHeader(0, 1); List <string> aFooterList = ReportsHelper.ImportReportHeader(1, 1); aHeaderList.Add("<td>" + SharedVariables.Line_Solid_10px_Black); if (RenderPoint) { aHeaderList.Add("<b><font size=4>" + Text.ReportsNames.RenPointListRepNm + " </font>"); } else { aHeaderList.Add("<b><font size=4>" + Text.ReportsNames.ItemsListRepNm + " </font>"); } aHeaderList.Add("<b><font size=2>" + Text.ReportsText.DateRepTxt + ": " + DateTime.Now.ToShortDateString() + " </font>"); aHeaderList.Add("<td>" + SharedVariables.Line_Solid_10px_Black); if (Preview) { PrintingManager.Instance.PrintTables(aDTlist, aHeaderList, aFooterList, ReportsHelper.TempOutputPath, ReportsHelper.TempOutputPath, PrintToThermal, false, false, "", false, "", colored); return(true); } else if (ExportToPdf) { PrintingManager.Instance.PrintTables(aDTlist, aHeaderList, aFooterList, ReportsHelper.TempOutputPath, ReportsHelper.TempOutputPath, PrintToThermal, false, true, ExportPath, false, "", colored); return(true); } else if (ExportToExcel) { PrintingManager.Instance.PrintTables(aDTlist, aHeaderList, aFooterList, ReportsHelper.TempOutputPath, ReportsHelper.TempOutputPath, PrintToThermal, false, false, "", true, ExportPath, colored); return(true); } else if (PrintToThermal) { PrintingManager.Instance.PrintTables(aDTlist, aHeaderList, aFooterList, ReportsHelper.TempOutputPath, ReportsHelper.TempOutputPath, true, true, false, "", false, "", colored); return(true); } else { return(false); } } catch (Exception ex) { throw new Exception(ex.Message); } }
public bool PrintPhysicalItemsStatus(bool PrintToThermal, bool ExportToPdf = false, bool ExportToExcel = false, string ExportPath = "", bool TableBorder = false, bool Preview = false, bool colored = false) { try { List <DataTable> aDTlist = new List <DataTable>(); DataTable ItemsDatatable = ItemsMgmt.SelectAllItems(); if (ItemsDatatable == null) { return(false); } else { if (ItemsDatatable.Rows.Count == 0) { return(false); } } DataTable ToPrintTable = new DataTable(); ToPrintTable.Columns.Add("Barcode"); ToPrintTable.Columns.Add("Description"); ToPrintTable.Columns.Add("Ava.Qty"); ToPrintTable.Columns.Add("Physical Count"); foreach (DataRow r in ItemsDatatable.Rows) { DataRow aRow = ToPrintTable.Rows.Add(); aRow["Barcode"] = r["Barcode"]; aRow["Description"] = r["Description"]; aRow["Ava.Qty"] = Math.Round(double.Parse(r["Qty"].ToString()), 3); aRow["Physical Count"] = "________"; } if (TableBorder) { ToPrintTable.Columns[0].ColumnName = "[Border=true1]" + ToPrintTable.Columns[0].ColumnName; } aDTlist.Add(ToPrintTable); List <string> aHeaderList = ReportsHelper.ImportReportHeader(0, 1); List <string> aFooterList = ReportsHelper.ImportReportHeader(1, 1); aHeaderList.Add("<td>" + SharedVariables.Line_Solid_10px_Black); aHeaderList.Add("<b><font size=4>" + Text.ReportsNames.PhysicalInvWorksheetRepNm + " </font>"); aHeaderList.Add("<b><font size=2>" + Text.ReportsText.DateRepTxt + ": " + DateTime.Now.ToShortDateString() + " </font>"); aHeaderList.Add("<td>" + SharedVariables.Line_Solid_10px_Black); if (Preview) { PrintingManager.Instance.PrintTables(aDTlist, aHeaderList, aFooterList, ReportsHelper.TempOutputPath, ReportsHelper.TempOutputPath, PrintToThermal, false, false, "", false, "", colored); return(true); } else if (ExportToPdf) { PrintingManager.Instance.PrintTables(aDTlist, aHeaderList, aFooterList, ReportsHelper.TempOutputPath, ReportsHelper.TempOutputPath, PrintToThermal, false, true, ExportPath, false, "", colored); return(true); } else if (ExportToExcel) { PrintingManager.Instance.PrintTables(aDTlist, aHeaderList, aFooterList, ReportsHelper.TempOutputPath, ReportsHelper.TempOutputPath, PrintToThermal, false, false, "", true, ExportPath, colored); return(true); } else if (PrintToThermal) { PrintingManager.Instance.PrintTables(aDTlist, aHeaderList, aFooterList, ReportsHelper.TempOutputPath, ReportsHelper.TempOutputPath, true, true, false, "", false, "", colored); return(true); } else { return(false); } } catch (Exception ex) { throw new Exception(ex.Message); } }