public void InitializeWithGeneralNumber(int RefNumber)
{
SEMAPHORE = true;
aAdjustGeneralList = AdjustInventoryGeneralMgmt.SelectAllAdjustsGeneral(RefNumber, string.Empty, string.Empty);
aItemsTable = AdjustInventoryDetailedMgmt.SelectAllAdjustsDetailed(RefNumber, -1);
AllItemsTable = ItemsMgmt.SelectAllItems();
aUserRow = UsersMgmt.SelectUserInfoByID(int.Parse(aAdjustGeneralList.Rows[0]["TellerID"].ToString()));
if (aItemsTable.Rows.Count > 0)
{
aItemsTable.Columns.Add("PhysicalCountColumn", typeof(double));
aItemsTable.Columns.Add("DifferencesColumn", typeof(double));
aItemsTable.Columns.Add("DiffValueColumn", typeof(double));
page(1);
}
else
{
MatchLbl.Visible = true;
}
AdjDatePicker.Text = aAdjustGeneralList.Rows[0]["Date"].ToString();
ReferenceNumberTxtBox.Text = aAdjustGeneralList.Rows[0]["Number"].ToString();
SEMAPHORE = false;
}
private void ListItemsBtn_Click(object sender, EventArgs e)
{
if (ACTIVE_MODE == AdjustItemsFrmModes.ADDING_MODE)
{
aItemsTable = ItemsMgmt.SelectAllItems();
aItemsTable.Columns.Add("PhysicalCountColumn", typeof(double));
aItemsTable.Columns.Add("DifferencesColumn", typeof(double));
aItemsTable.Columns.Add("DiffValueColumn", typeof(double));
foreach (DataRow aRow in aItemsTable.Rows)/*validating sends error if it is not initialized*/
{
if (aRow["PhysicalCountColumn"].ToString() == string.Empty) aRow["PhysicalCountColumn"] = aRow["Qty"].ToString();
if (aRow["DifferencesColumn"].ToString() == string.Empty) aRow["DifferencesColumn"] = "0.00";
if (aRow["DiffValueColumn"].ToString() == string.Empty) aRow["DiffValueColumn"] = "0.00";
}
AddItemsToDgview();
}
else if (ACTIVE_MODE == AdjustItemsFrmModes.EDIT_MODE)
{
/* The button will be hidden in this mode*/
}
}
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);
}
}
private void ListItemsBtn_Click(object sender, EventArgs e)
{
try
{
ListItemsDgView.Rows.Clear();
if (RndrPointChkBox.Checked)
{
ItemsDatatable = ItemsMgmt.RenderPoint();
}
else
{
ItemsDatatable = ItemsMgmt.SelectAllItems();
}
if (ItemsDatatable == null)
{
MessageBox.Show(MsgTxt.UnexpectedError + "\n IN [ListItemsBtn_Click:DB-ERROR ItemsDatatable=null] \n \n", MsgTxt.ErrorCaption, MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
TotalITemsTxtBox.Text = ItemsDatatable.Rows.Count.ToString();
TaxLevelDataTable = ItemTaxLevelMgmt.SelectAll();
ItemCategoryDataTable = ItemCategoryMgmt.SelectAll();
VendorsDataTable = VendorsMgmt.SelectAllVendors();
ItemsTypeDataTalbe = ItemTypeMgmt.SelectAll();
if (TaxLevelDataTable == null || ItemCategoryDataTable == null || VendorsDataTable == null || ItemsTypeDataTalbe == null)
{
MessageBox.Show(MsgTxt.UnexpectedError + "\n IN [ListItemsBtn_Click:DB-ERROR TaxLevelDataTable=null ||ItemCategoryDataTable=null || VendorsDataTable==null || ItemsTypeDataTalbe==null] \n \n", MsgTxt.ErrorCaption, MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
taxlevelrowsnumber = TaxLevelDataTable.Rows.Count;
itemcategoryrowsnumber = ItemCategoryDataTable.Rows.Count;
vendorrowsnumber = VendorsDataTable.Rows.Count;
typerowsnumber = ItemsTypeDataTalbe.Rows.Count;
if (ItemsDatatable.Rows.Count > 0)
{
//TestingFor Paging
pagesnumber = (int)ItemsDatatable.Rows.Count / ItemsPerPage;
if ((double.Parse(ItemsDatatable.Rows.Count.ToString()) / ItemsPerPage - int.Parse(ItemsDatatable.Rows.Count.ToString()) / ItemsPerPage) > 0)
{
pagesnumber++;
}
RowNum = 0;
ListItemsDgView.Rows.Clear();
foreach (DataRow r in ItemsDatatable.Rows)
{
if (ListItemsDgView.Rows.Count < ItemsPerPage)
{
ListItemsDgView.Rows.Add();
// TRIAL 2 CODE
ListItemsDgView.Rows[RowNum].Cells["Barcode"].Value = ItemsDatatable.Rows[RowNum]["Barcode"].ToString();
for (int i = 0; i < typerowsnumber; i++)
{
if (int.Parse(ItemsTypeDataTalbe.Rows[i]["ID"].ToString()) == int.Parse(ItemsDatatable.Rows[RowNum]["Type"].ToString()))
{
ListItemsDgView.Rows[RowNum].Cells["Type"].Value = ItemsTypeDataTalbe.Rows[i]["Name"].ToString();
break;
}
}
for (int i = 0; i < itemcategoryrowsnumber; i++)
{
if (int.Parse(ItemCategoryDataTable.Rows[i]["ID"].ToString()) == int.Parse(ItemsDatatable.Rows[RowNum]["Category"].ToString()))
{
ListItemsDgView.Rows[RowNum].Cells["Category"].Value = ItemCategoryDataTable.Rows[i]["Name"].ToString();
break;
}
}
for (int i = 0; i < taxlevelrowsnumber; i++)
{
if (int.Parse(TaxLevelDataTable.Rows[i]["ID"].ToString()) == int.Parse(ItemsDatatable.Rows[RowNum]["TaxLevel"].ToString()))
{
ListItemsDgView.Rows[RowNum].Cells["TaxLevel"].Value = TaxLevelDataTable.Rows[i]["Percentage"].ToString();
break;
}
}
for (int i = 0; i < vendorrowsnumber; i++)
{
if (int.Parse(VendorsDataTable.Rows[i]["ID"].ToString()) == int.Parse(ItemsDatatable.Rows[RowNum]["Vendor"].ToString()))
{
ListItemsDgView.Rows[RowNum].Cells["Vendor"].Value = VendorsDataTable.Rows[i]["Name"].ToString();
break;
}
}
ListItemsDgView.Rows[RowNum].Cells["Description"].Value = ItemsDatatable.Rows[RowNum]["Description"].ToString();
ListItemsDgView.Rows[RowNum].Cells["Qty"].Value = ItemsDatatable.Rows[RowNum]["Qty"].ToString();
ListItemsDgView.Rows[RowNum].Cells["AvgUnitCost"].Value = Math.Round(double.Parse(ItemsDatatable.Rows[RowNum]["AvgUnitCost"].ToString()), 3);
ListItemsDgView.Rows[RowNum].Cells["SellPrice"].Value = ItemsDatatable.Rows[RowNum]["SellPrice"].ToString();
ListItemsDgView.Rows[RowNum].Cells["RenderPoint"].Value = ItemsDatatable.Rows[RowNum]["RenderPoint"].ToString();
ListItemsDgView.Rows[RowNum].Cells["Margincol"].Value = (Convert.ToDouble(ListItemsDgView.Rows[RowNum].Cells["SellPrice"].Value) - Convert.ToDouble(ListItemsDgView.Rows[RowNum].Cells["AvgUnitCost"].Value)) / Convert.ToDouble(ListItemsDgView.Rows[RowNum].Cells["AvgUnitCost"].Value) * 100;
ListItemsDgView.Rows[RowNum].Cells["DateAdded"].Value = ItemsDatatable.Rows[RowNum]["EntryDate"].ToString();
RowNum++;
}
}
}
}
catch (Exception ex)
{
MessageBox.Show(MsgTxt.UnexpectedError + "\n IN [ListCustomersBtn_Click] \n Exception: \n" + ex.ToString(), MsgTxt.ErrorCaption, MessageBoxButtons.OK, MessageBoxIcon.Error);
throw;
}
/* TimeSpan ts = DateTime.Now.Subtract(StartTime);
* string elapsedTime = String.Format("{0:00}:{1:00}:{2:00}.{3:00}",
* ts.Hours, ts.Minutes, ts.Seconds,
* ts.Milliseconds / 10);*/
PageOfTotalTxtBox.Text = "1/" + pagesnumber.ToString();
currentpage = 1;
// Console.WriteLine(elapsedTime, "RunTime");
// MessageBox.Show("Elasped Time in Seconds for [[1,300]] items [TRIAL 2 new code] is =" + elapsedTime);
}
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);
}
}