protected void chkOrderSlipPrinter_CheckedChanged(Object sender, EventArgs e)
{
CheckBox chkOrderSlipPrinter = (CheckBox)sender;
DataListItem item = (DataListItem)chkOrderSlipPrinter.NamingContainer;
HtmlInputCheckBox chkList = (HtmlInputCheckBox)item.FindControl("chkList");
Int64 iProductID = Int64.Parse(chkList.Value);
OrderSlipPrinter orderSlipPrinter = OrderSlipPrinter.NotApplicable;
switch (chkOrderSlipPrinter.ID)
{
case "chkOrderSlipPrinter1": orderSlipPrinter = OrderSlipPrinter.RetailPlusOSPrinter1; break;
case "chkOrderSlipPrinter2": orderSlipPrinter = OrderSlipPrinter.RetailPlusOSPrinter2; break;
case "chkOrderSlipPrinter3": orderSlipPrinter = OrderSlipPrinter.RetailPlusOSPrinter3; break;
case "chkOrderSlipPrinter4": orderSlipPrinter = OrderSlipPrinter.RetailPlusOSPrinter4; break;
case "chkOrderSlipPrinter5": orderSlipPrinter = OrderSlipPrinter.RetailPlusOSPrinter5; break;
}
Products clsProducts = new Products();
clsProducts.UpdateOrderSlipPrinter(iProductID, orderSlipPrinter, chkOrderSlipPrinter.Checked);
clsProducts.CommitAndDispose();
}
protected void chkOrderSlipPrinterAll_CheckedChanged(Object sender, EventArgs e)
{
HtmlInputCheckBox chkList = null;
CheckBox chkOrderSlipPrinterAll = (CheckBox)sender;
CheckBox chkOrderSlipPrinter = null;
Int64 iProductID = 0;
Products clsProducts = new Products();
OrderSlipPrinter orderSlipPrinter = OrderSlipPrinter.NotApplicable;
foreach (DataListItem item in lstItem.Items)
{
chkList = (HtmlInputCheckBox)item.FindControl("chkList");
iProductID = Int64.Parse(chkList.Value);
switch (chkOrderSlipPrinterAll.ID)
{
case "chkOrderSlipPrinter1All": orderSlipPrinter = OrderSlipPrinter.RetailPlusOSPrinter1; chkOrderSlipPrinter = (CheckBox)item.FindControl("chkOrderSlipPrinter1"); break;
case "chkOrderSlipPrinter2All": orderSlipPrinter = OrderSlipPrinter.RetailPlusOSPrinter2; chkOrderSlipPrinter = (CheckBox)item.FindControl("chkOrderSlipPrinter2"); break;
case "chkOrderSlipPrinter3All": orderSlipPrinter = OrderSlipPrinter.RetailPlusOSPrinter3; chkOrderSlipPrinter = (CheckBox)item.FindControl("chkOrderSlipPrinter3"); break;
case "chkOrderSlipPrinter4All": orderSlipPrinter = OrderSlipPrinter.RetailPlusOSPrinter4; chkOrderSlipPrinter = (CheckBox)item.FindControl("chkOrderSlipPrinter4"); break;
case "chkOrderSlipPrinter5All": orderSlipPrinter = OrderSlipPrinter.RetailPlusOSPrinter5; chkOrderSlipPrinter = (CheckBox)item.FindControl("chkOrderSlipPrinter5"); break;
}
clsProducts.UpdateOrderSlipPrinter(iProductID, orderSlipPrinter, chkOrderSlipPrinterAll.Checked);
chkOrderSlipPrinter.Checked = chkOrderSlipPrinterAll.Checked;
}
clsProducts.CommitAndDispose();
}
public void PrintPLUReportPerOrderSlipPrinter(System.Data.DataTable dtPLUReport, Data.CashierReportDetails clsCashierReportDetails, DateTime StartDate, DateTime EndDate, OrderSlipPrinter blockOrderSlipPrinter)
{
Cursor.Current = Cursors.WaitCursor;
try
{
PrintingPreference oldCONFIG_AutoPrint = mclsTerminalDetails.AutoPrint;
mclsTerminalDetails.AutoPrint = PrintingPreference.Normal;
PrintReportHeadersSection(false);
decimal TotalQuantity = 0;
decimal TotalAmount = 0;
msbToPrint.Append("-".PadRight(mclsTerminalDetails.MaxReceiptWidth, '-') + Environment.NewLine);
msbToPrint.Append(CenterString("PLU REPORT", mclsTerminalDetails.MaxReceiptWidth) + Environment.NewLine);
msbToPrint.Append(CenterString(blockOrderSlipPrinter.ToString("G"), mclsTerminalDetails.MaxReceiptWidth) + Environment.NewLine);
msbToPrint.Append("-".PadRight(mclsTerminalDetails.MaxReceiptWidth, '-') + Environment.NewLine);
msbToPrint.Append(CenterString("Start Date: " + StartDate.ToString("MM/dd/yyyy hh:mm:ss tt"), mclsTerminalDetails.MaxReceiptWidth) + Environment.NewLine);
msbToPrint.Append(CenterString("End Date : " + EndDate.ToString("MM/dd/yyyy hh:mm:ss tt"), mclsTerminalDetails.MaxReceiptWidth) + Environment.NewLine + Environment.NewLine);
msbToPrint.Append("Item Quantity Amount" + Environment.NewLine);
msbToPrint.Append("-".PadRight(mclsTerminalDetails.MaxReceiptWidth, '-') + Environment.NewLine);
foreach (System.Data.DataRow dr in dtPLUReport.Rows)
{
OrderSlipPrinter enumOrderSlipPrinter = (OrderSlipPrinter)Enum.Parse(typeof(OrderSlipPrinter), dr["OrderSlipPrinter"].ToString());
if (blockOrderSlipPrinter == enumOrderSlipPrinter)
{
string stProductCode = dr["ProductCode"].ToString();
string stQuantity = Convert.ToDecimal(dr["Quantity"].ToString()).ToString("#,##0.#0");
string stAmount = Convert.ToDecimal(dr["Amount"].ToString()).ToString("#,##0.#0");
if (stProductCode.Length <= 11)
{
msbToPrint.Append(stProductCode.PadRight(11));
msbToPrint.Append(stQuantity.PadLeft(12));
msbToPrint.Append(stAmount.PadLeft(17));
msbToPrint.Append(Environment.NewLine);
}
else
{
msbToPrint.Append(stProductCode + Environment.NewLine);
msbToPrint.Append(stQuantity.PadLeft(23));
msbToPrint.Append(stAmount.PadLeft(17));
msbToPrint.Append(Environment.NewLine);
}
TotalQuantity += Convert.ToDecimal(dr["Quantity"]);
TotalAmount += Convert.ToDecimal(dr["Amount"]);
}
}
msbToPrint.Append("-".PadRight(mclsTerminalDetails.MaxReceiptWidth, '-') + Environment.NewLine);
msbToPrint.Append("Total:".PadRight(6));
msbToPrint.Append(TotalQuantity.ToString("#,##0.#0").PadLeft(17));
msbToPrint.Append(TotalAmount.ToString("#,##0.#0").PadLeft(17));
msbToPrint.Append(Environment.NewLine);
msbToPrint.Append("Grand Total :".PadRight(16));
msbToPrint.Append(TotalAmount.ToString("#,##0.#0").PadLeft(24));
msbToPrint.Append(Environment.NewLine);
msbToPrint.Append("-".PadRight(mclsTerminalDetails.MaxReceiptWidth, '-') + Environment.NewLine);
PrintPageAndReportFooterSection(false, DateTime.MinValue);
mclsTerminalDetails.AutoPrint = oldCONFIG_AutoPrint;
InsertAuditLog(AccessTypes.PrintPLUReport, "Print PLU report per OrderSlipprinter: " + blockOrderSlipPrinter.ToString("G") + " TerminalNo=" + mclsTerminalDetails.TerminalNo + " @ Branch: " + mclsTerminalDetails.BranchDetails.BranchCode);
}
catch (Exception ex)
{
InsertErrorLogToFile(ex, "ERROR!!! Printing PLU report. Err Description: ");
}
Cursor.Current = Cursors.Default;
}
public void PrintItemToOSPrinter(string Description, string stProductUnitCode, decimal Quantity, OrderSlipPrinter OrderSlipPrinter, bool bolBIG, string Remarks)
{
// return if no OrderSlipPrinter
if (OrderSlipPrinter == RetailPlus.OrderSlipPrinter.NotApplicable) return;
// description
string stDescription = Description;
if (stDescription.IndexOf(Environment.NewLine) > -1)
{
try
{ stDescription = Description.Split(Convert.ToChar(Environment.NewLine)).GetValue(0).ToString(); }
catch { }
}
if (stDescription.Length > mclsTerminalDetails.MaxReceiptWidth)
{
try
{ stDescription = stDescription.Substring(0, mclsTerminalDetails.MaxReceiptWidth); }
catch { }
}
string stQuantity = Quantity.ToString("#,##0.#0");
if (Quantity == 1 || Quantity == -1)
stQuantity = "1";
else if (Decimal.Compare(Quantity, Decimal.Floor(Quantity)) == 0)
{ stQuantity = Quantity.ToString("#,##0"); }
if (bolBIG)
{
if (mclsTerminalDetails.IsPrinterDotMatrix) SendOrderSlipToPrinter(stQuantity + "x" + stProductUnitCode + " " + stDescription.PadRight(mclsTerminalDetails.MaxReceiptWidth - 12), OrderSlipPrinter);
else SendOrderSlipToPrinter(RawPrinterHelper.escFontHeightX2On + stQuantity + "x" + stProductUnitCode + " " + stDescription.PadRight(mclsTerminalDetails.MaxReceiptWidth - 12) + RawPrinterHelper.escFontHeightX2Off, OrderSlipPrinter);
}
else
{
SendOrderSlipToPrinter(stDescription.PadRight(mclsTerminalDetails.MaxReceiptWidth - 12), OrderSlipPrinter);
SendOrderSlipToPrinter(stProductUnitCode.PadRight(6), OrderSlipPrinter);
SendOrderSlipToPrinter(stQuantity.PadLeft(6), OrderSlipPrinter);
}
SendOrderSlipToPrinter(Environment.NewLine, OrderSlipPrinter);
if (!string.IsNullOrEmpty(Remarks))
SendOrderSlipToPrinter(" * " + Remarks + Environment.NewLine, OrderSlipPrinter);
}
public void PrintItemCompositionToOSPrinter(string Description, string stProductUnitCode, decimal Quantity, OrderSlipPrinter OrderSlipPrinter)
{
// return if no OrderSlipPrinter
if (OrderSlipPrinter == RetailPlus.OrderSlipPrinter.NotApplicable) return;
// description
string stDescription = Description;
try
{ stDescription = Description.Split(Convert.ToChar(Environment.NewLine)).GetValue(0).ToString(); }
catch { }
try
{ stDescription = stDescription.Substring(0, mclsTerminalDetails.MaxReceiptWidth); }
catch { }
SendOrderSlipToPrinter(stDescription.PadRight(mclsTerminalDetails.MaxReceiptWidth - 12), OrderSlipPrinter);
SendOrderSlipToPrinter(stProductUnitCode.PadRight(6), OrderSlipPrinter);
string stQuantity = Quantity.ToString("#,##0.#0");
if (Quantity == 1 || Quantity == -1)
stQuantity = "1";
else if (Decimal.Compare(Quantity, Decimal.Floor(Quantity)) == 0)
{ stQuantity = Quantity.ToString("#,##0"); }
SendOrderSlipToPrinter(stQuantity.PadLeft(6), OrderSlipPrinter);
SendOrderSlipToPrinter(Environment.NewLine, OrderSlipPrinter);
}
public bool PrintOrderSlipFooter(OrderSlipPrinter orderSlipPrinter)
{
// no need if it's a non-applicable
if (orderSlipPrinter == RetailPlus.OrderSlipPrinter.NotApplicable) return false;
bool boSuccess = false;
SendOrderSlipToPrinter("-".PadRight(mclsTerminalDetails.MaxReceiptWidth, '-') + Environment.NewLine, orderSlipPrinter);
SendOrderSlipToPrinter("Served by: " + mclsSalesTransactionDetails.WaiterName + Environment.NewLine, orderSlipPrinter);
SendOrderSlipToPrinter("-".PadRight(mclsTerminalDetails.MaxReceiptWidth, '-') + Environment.NewLine, orderSlipPrinter);
// print page footer spacer
for (int i = 0; i < 6; i++)
{ SendOrderSlipToPrinter(Environment.NewLine, orderSlipPrinter); }
switch (orderSlipPrinter)
{
case RetailPlus.OrderSlipPrinter.RetailPlusOSPrinter1:
mclsFPRetailPlusOSPrinter1.Write(msbToPrintFP1);
boSuccess = RawPrinterHelper.SendFileToPrinter(orderSlipPrinter.ToString("G"), mclsFPRetailPlusOSPrinter1.FileName, "RetailPlus " + mclsFPRetailPlusOSPrinter1.FileName);
//mclsFPRetailPlusOSPrinter1.DeleteFile();
break;
case RetailPlus.OrderSlipPrinter.RetailPlusOSPrinter2:
mclsFPRetailPlusOSPrinter2.Write(msbToPrintFP2);
boSuccess = RawPrinterHelper.SendFileToPrinter(orderSlipPrinter.ToString("G"), mclsFPRetailPlusOSPrinter2.FileName, "RetailPlus " + mclsFPRetailPlusOSPrinter2.FileName);
//mclsFPRetailPlusOSPrinter2.DeleteFile();
break;
case RetailPlus.OrderSlipPrinter.RetailPlusOSPrinter3:
mclsFPRetailPlusOSPrinter3.Write(msbToPrintFP3);
boSuccess = RawPrinterHelper.SendFileToPrinter(orderSlipPrinter.ToString("G"), mclsFPRetailPlusOSPrinter3.FileName, "RetailPlus " + mclsFPRetailPlusOSPrinter3.FileName);
//mclsFPRetailPlusOSPrinter3.DeleteFile();
break;
case RetailPlus.OrderSlipPrinter.RetailPlusOSPrinter4:
mclsFPRetailPlusOSPrinter4.Write(msbToPrintFP4);
boSuccess = RawPrinterHelper.SendFileToPrinter(orderSlipPrinter.ToString("G"), mclsFPRetailPlusOSPrinter4.FileName, "RetailPlus " + mclsFPRetailPlusOSPrinter4.FileName);
//mclsFPRetailPlusOSPrinter4.DeleteFile();
break;
case RetailPlus.OrderSlipPrinter.RetailPlusOSPrinter5:
mclsFPRetailPlusOSPrinter5.Write(msbToPrintFP5);
boSuccess = RawPrinterHelper.SendFileToPrinter(orderSlipPrinter.ToString("G"), mclsFPRetailPlusOSPrinter2.FileName, "RetailPlus " + mclsFPRetailPlusOSPrinter5.FileName);
//mclsFPRetailPlusOSPrinter5.DeleteFile();
break;
}
if (mclsTerminalDetails.IsPrinterAutoCutter) CutPrinterPaper(orderSlipPrinter.ToString("G"));
return boSuccess;
}
public void PrintOrderSlipHeader(OrderSlipPrinter OrderSlipPrinter, bool WillReprintAll)
{
// no need if it's a non-applicable
if (OrderSlipPrinter == RetailPlus.OrderSlipPrinter.NotApplicable) return;
switch (OrderSlipPrinter)
{
case RetailPlus.OrderSlipPrinter.RetailPlusOSPrinter1:
mclsFPRetailPlusOSPrinter1 = new FilePrinter();
msbToPrintFP1.Clear();
msbToPrintFP1 = new StringBuilder();
if (string.IsNullOrEmpty(mclsSalesTransactionDetails.TransactionNo) || mclsSalesTransactionDetails.TransactionNo == "READY..." || mclsSalesTransactionDetails.TransactionNo == mclsFPRetailPlusOSPrinter1.FileName)
mclsFPRetailPlusOSPrinter1.FileName = DateTime.Now.ToString("yyyyMMddhhmmss");
else
mclsFPRetailPlusOSPrinter1.FileName = mclsSalesTransactionDetails.TransactionNo + "OS1";
break;
case RetailPlus.OrderSlipPrinter.RetailPlusOSPrinter2:
mclsFPRetailPlusOSPrinter2 = new FilePrinter();
msbToPrintFP2.Clear();
msbToPrintFP2 = new StringBuilder();
if (string.IsNullOrEmpty(mclsSalesTransactionDetails.TransactionNo) || mclsSalesTransactionDetails.TransactionNo == "READY..." || mclsSalesTransactionDetails.TransactionNo == mclsFPRetailPlusOSPrinter2.FileName)
mclsFPRetailPlusOSPrinter2.FileName = DateTime.Now.ToString("yyyyMMddhhmmss");
else
mclsFPRetailPlusOSPrinter2.FileName = mclsSalesTransactionDetails.TransactionNo + "OS2";
break;
case RetailPlus.OrderSlipPrinter.RetailPlusOSPrinter3:
mclsFPRetailPlusOSPrinter3 = new FilePrinter();
msbToPrintFP3.Clear();
msbToPrintFP3 = new StringBuilder();
if (string.IsNullOrEmpty(mclsSalesTransactionDetails.TransactionNo) || mclsSalesTransactionDetails.TransactionNo == "READY..." || mclsSalesTransactionDetails.TransactionNo == mclsFPRetailPlusOSPrinter3.FileName)
mclsFPRetailPlusOSPrinter3.FileName = DateTime.Now.ToString("yyyyMMddhhmmss");
else
mclsFPRetailPlusOSPrinter3.FileName = mclsSalesTransactionDetails.TransactionNo + "OS3";
break;
case RetailPlus.OrderSlipPrinter.RetailPlusOSPrinter4:
mclsFPRetailPlusOSPrinter4 = new FilePrinter();
msbToPrintFP4.Clear();
msbToPrintFP4 = new StringBuilder();
if (string.IsNullOrEmpty(mclsSalesTransactionDetails.TransactionNo) || mclsSalesTransactionDetails.TransactionNo == "READY..." || mclsSalesTransactionDetails.TransactionNo == mclsFPRetailPlusOSPrinter4.FileName)
mclsFPRetailPlusOSPrinter4.FileName = DateTime.Now.ToString("yyyyMMddhhmmss");
else
mclsFPRetailPlusOSPrinter4.FileName = mclsSalesTransactionDetails.TransactionNo + "OS4";
break;
case RetailPlus.OrderSlipPrinter.RetailPlusOSPrinter5:
mclsFPRetailPlusOSPrinter5 = new FilePrinter();
msbToPrintFP5.Clear();
msbToPrintFP5 = new StringBuilder();
if (string.IsNullOrEmpty(mclsSalesTransactionDetails.TransactionNo) || mclsSalesTransactionDetails.TransactionNo == "READY..." || mclsSalesTransactionDetails.TransactionNo == mclsFPRetailPlusOSPrinter5.FileName)
mclsFPRetailPlusOSPrinter5.FileName = DateTime.Now.ToString("yyyyMMddhhmmss");
else
mclsFPRetailPlusOSPrinter5.FileName = mclsSalesTransactionDetails.TransactionNo + "OS5";
break;
}
// print page header spacer
for (int i = 0; i < 3; i++)
{
SendOrderSlipToPrinter(Environment.NewLine, OrderSlipPrinter);
}
SendOrderSlipToPrinter(CenterString("Trx #: " + mclsSalesTransactionDetails.TransactionNo, mclsTerminalDetails.MaxReceiptWidth) + Environment.NewLine, OrderSlipPrinter);
SendOrderSlipToPrinter(CenterString(DateTime.Now.ToString("MM/dd/yyyy hh:mm tt"), mclsTerminalDetails.MaxReceiptWidth) + Environment.NewLine, OrderSlipPrinter);
if (mclsTerminalDetails.IsPrinterDotMatrix)
{ SendOrderSlipToPrinter(CenterString("ORDER SLIP", mclsTerminalDetails.MaxReceiptWidth) + Environment.NewLine, OrderSlipPrinter); }
else { SendOrderSlipToPrinter(RawPrinterHelper.escFontHeightX2On + CenterString("ORDER SLIP", mclsTerminalDetails.MaxReceiptWidth) + RawPrinterHelper.escFontHeightX2Off + Environment.NewLine, OrderSlipPrinter); }
//
if (WillReprintAll)
{ SendOrderSlipToPrinter(CenterString("-reprinted: check if already prepared-", mclsTerminalDetails.MaxReceiptWidth) + Environment.NewLine, OrderSlipPrinter); }
SendOrderSlipToPrinter(Environment.NewLine, OrderSlipPrinter);
SendOrderSlipToPrinter("-".PadRight(mclsTerminalDetails.MaxReceiptWidth, '-') + Environment.NewLine, OrderSlipPrinter);
SendOrderSlipToPrinter("Customer : " + mclsSalesTransactionDetails.CustomerName + Environment.NewLine, OrderSlipPrinter);
SendOrderSlipToPrinter("-".PadRight(mclsTerminalDetails.MaxReceiptWidth, '-') + Environment.NewLine, OrderSlipPrinter);
SendOrderSlipToPrinter("DESC".PadRight(mclsTerminalDetails.MaxReceiptWidth - 12), OrderSlipPrinter);
SendOrderSlipToPrinter("UNIT".PadRight(6), OrderSlipPrinter);
SendOrderSlipToPrinter("QTY".PadLeft(6), OrderSlipPrinter);
SendOrderSlipToPrinter(Environment.NewLine, OrderSlipPrinter);
SendOrderSlipToPrinter("-".PadRight(mclsTerminalDetails.MaxReceiptWidth, '-') + Environment.NewLine, OrderSlipPrinter);
}
public void UpdateOrderSlipAsPrinted(OrderSlipPrinter OrderSlipPrinter)
{
Data.SalesTransactionItems clsSalesTransactionItems = new Data.SalesTransactionItems(mConnection, mTransaction);
mConnection = clsSalesTransactionItems.Connection; mTransaction = clsSalesTransactionItems.Transaction;
foreach (System.Data.DataRow dr in ItemDataTable.Rows)
{
bool orderSlipPrinter1 = bool.Parse(dr["OrderSlipPrinter1"].ToString());
bool orderSlipPrinter2 = bool.Parse(dr["OrderSlipPrinter2"].ToString());
bool orderSlipPrinter3 = bool.Parse(dr["OrderSlipPrinter3"].ToString());
bool orderSlipPrinter4 = bool.Parse(dr["OrderSlipPrinter4"].ToString());
bool orderSlipPrinter5 = bool.Parse(dr["OrderSlipPrinter5"].ToString());
if (orderSlipPrinter1 || orderSlipPrinter2 || orderSlipPrinter3 || orderSlipPrinter4 || orderSlipPrinter5)
{
/****************************************
* 05Dec2014 put this here, should only set to true if success printing
****************************************/
Int64 iTransactionItemsID = Convert.ToInt64(dr["TransactionItemsID"]);
clsSalesTransactionItems.UpdateOrderSlipPrinted(true, iTransactionItemsID);
}
}
clsSalesTransactionItems.CommitAndDispose();
}
public void ShowOrderSlipPrinterError(OrderSlipPrinter OrderSlipPrinter, bool isFromSuspendTransaction, bool PrinterOffline = false)
{
if (PrinterOffline)
{
if (isFromSuspendTransaction)
MessageBox.Show("Printer is Offline: Error sending items to kitchen while suspending the transaction!!! Please double check the OrderSlipPrinter #" + (Int32.Parse(OrderSlipPrinter.ToString("d")) + 1).ToString() + " then RESEND this order for printing.", "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1);
else
MessageBox.Show("Printer is Offline: Error sending items to kitchen!!! Please double check the OrderSlipPrinter #" + (Int32.Parse(OrderSlipPrinter.ToString("d")) + 1).ToString() + " then RESEND this order for printing.", "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1);
}
else
{
if (isFromSuspendTransaction)
MessageBox.Show("Error sending items to kitchen while suspending the transaction!!! Please double check the OrderSlipPrinter #" + (Int32.Parse(OrderSlipPrinter.ToString("d")) + 1).ToString() + " then RESEND this order for printing.", "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1);
else
MessageBox.Show("Error sending items to kitchen!!! Please double check the OrderSlipPrinter #" + (Int32.Parse(OrderSlipPrinter.ToString("d")) + 1).ToString() + " then RESEND this order for printing.", "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1);
}
}
public bool SendOrderSlipToPrinter(string szString, OrderSlipPrinter orderSlipPrinter)
{
try
{
clsEvent.AddEventReceipt(szString);
switch (orderSlipPrinter)
{
case RetailPlus.OrderSlipPrinter.RetailPlusOSPrinter1:
msbToPrintFP1.Append(szString);
break;
case RetailPlus.OrderSlipPrinter.RetailPlusOSPrinter2:
msbToPrintFP2.Append(szString);
break;
case RetailPlus.OrderSlipPrinter.RetailPlusOSPrinter3:
msbToPrintFP3.Append(szString);
break;
case RetailPlus.OrderSlipPrinter.RetailPlusOSPrinter4:
msbToPrintFP4.Append(szString);
break;
case RetailPlus.OrderSlipPrinter.RetailPlusOSPrinter5:
msbToPrintFP5.Append(szString);
break;
}
return true;
}
catch
{
return false;
}
}
public void UpdateOrderSlipPrinter(Int64 ProductID, OrderSlipPrinter OrderSlipPrinter, bool isChecked)
{
// Added August 2, 2009 to monitor if product still has/have variations
try
{
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
string SQL = "";
switch (OrderSlipPrinter)
{
case OrderSlipPrinter.RetailPlusOSPrinter1: SQL = "UPDATE tblProducts SET OrderSlipPrinter1 = @isChecked WHERE ProductID=@ProductID;";
break;
case OrderSlipPrinter.RetailPlusOSPrinter2: SQL = "UPDATE tblProducts SET OrderSlipPrinter2 = @isChecked WHERE ProductID=@ProductID;";
break;
case OrderSlipPrinter.RetailPlusOSPrinter3: SQL = "UPDATE tblProducts SET OrderSlipPrinter3 = @isChecked WHERE ProductID=@ProductID;";
break;
case OrderSlipPrinter.RetailPlusOSPrinter4: SQL = "UPDATE tblProducts SET OrderSlipPrinter4 = @isChecked WHERE ProductID=@ProductID;";
break;
case OrderSlipPrinter.RetailPlusOSPrinter5: SQL = "UPDATE tblProducts SET OrderSlipPrinter5 = @isChecked WHERE ProductID=@ProductID;";
break;
}
cmd.Parameters.AddWithValue("@isChecked", isChecked);
cmd.Parameters.AddWithValue("@ProductID", ProductID);
cmd.CommandText = SQL;
base.ExecuteNonQuery(cmd);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
