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