public void GeneratePLUReport(Int32 BranchID, string TerminalNo, bool isPerGroup, string CashierName)
{
try
{
System.Data.DataTable dtPLUReport = this.PLUReport(BranchID, TerminalNo, CashierName, isPerGroup);
Data.PLUReport clsPLUReport = new Data.PLUReport(base.Connection, base.Transaction);
clsPLUReport.Delete(BranchID, TerminalNo);
PLUReportDetails clsPLUReportDetails;
ProductComposition clsProductComposition = new ProductComposition(base.Connection, base.Transaction);
foreach(System.Data.DataRow dr in dtPLUReport.Rows)
{
long lProductID = Convert.ToInt64(dr["ProductID"]);
string stProductCode = dr["ProductCode"].ToString();
string stProductGroup = dr["ProductGroup"].ToString();
decimal decQuantity = Convert.ToDecimal(dr["Quantity"]);
decimal decAmount = Convert.ToDecimal(dr["Amount"]);
bool boOrderSlipPrinter1 = bool.Parse(dr["OrderSlipPrinter1"].ToString());
bool boOrderSlipPrinter2 = bool.Parse(dr["OrderSlipPrinter2"].ToString());
bool boOrderSlipPrinter3 = bool.Parse(dr["OrderSlipPrinter3"].ToString());
bool boOrderSlipPrinter4 = bool.Parse(dr["OrderSlipPrinter4"].ToString());
bool boOrderSlipPrinter5 = bool.Parse(dr["OrderSlipPrinter5"].ToString());
// 07Apr2015 : Add this so that those products without OrderSlipPrinter will be defaulted to OrderSlipPrinter1
if (!boOrderSlipPrinter1 && !boOrderSlipPrinter2 && !boOrderSlipPrinter3 && !boOrderSlipPrinter4 && !boOrderSlipPrinter5) boOrderSlipPrinter1 = true;
clsPLUReportDetails = new PLUReportDetails();
clsPLUReportDetails.BranchDetails = new BranchDetails {
BranchID = BranchID
};
clsPLUReportDetails.TerminalNo = TerminalNo;
clsPLUReportDetails.ProductID = lProductID;
clsPLUReportDetails.ProductCode = stProductCode;
clsPLUReportDetails.ProductGroup = stProductGroup;
clsPLUReportDetails.Quantity = decQuantity;
clsPLUReportDetails.Amount = decAmount;
if (boOrderSlipPrinter1) { clsPLUReportDetails.OrderSlipPrinter = OrderSlipPrinter.RetailPlusOSPrinter1; clsPLUReport.Insert(clsPLUReportDetails); }
if (boOrderSlipPrinter2) { clsPLUReportDetails.OrderSlipPrinter = OrderSlipPrinter.RetailPlusOSPrinter2; clsPLUReport.Insert(clsPLUReportDetails); }
if (boOrderSlipPrinter3) { clsPLUReportDetails.OrderSlipPrinter = OrderSlipPrinter.RetailPlusOSPrinter3; clsPLUReport.Insert(clsPLUReportDetails); }
if (boOrderSlipPrinter4) { clsPLUReportDetails.OrderSlipPrinter = OrderSlipPrinter.RetailPlusOSPrinter4; clsPLUReport.Insert(clsPLUReportDetails); }
if (boOrderSlipPrinter5) { clsPLUReportDetails.OrderSlipPrinter = OrderSlipPrinter.RetailPlusOSPrinter5; clsPLUReport.Insert(clsPLUReportDetails); }
// generate if per item
if (!isPerGroup) clsProductComposition.GeneratePLUReport(BranchID, TerminalNo, lProductID, stProductCode, decQuantity);
}
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public void PrintPLUReportPerOrderSlipPrinter()
{
Data.CashierReports clsCashierReport = new Data.CashierReports(mConnection, mTransaction);
mConnection = clsCashierReport.Connection; mTransaction = clsCashierReport.Transaction;
Data.CashierReportDetails clsCashierReportDetails = clsCashierReport.Details(mclsSalesTransactionDetails.CashierID, Constants.TerminalBranchID, mclsTerminalDetails.TerminalNo);
clsCashierReport.GeneratePLUReport(mclsTerminalDetails.BranchDetails.BranchID, mclsTerminalDetails.TerminalNo, false, mCashierName);
Data.PLUReport clsPLUReport = new Data.PLUReport(mConnection, mTransaction);
System.Data.DataTable dtpluReport = clsPLUReport.ListAsDataTable(mclsTerminalDetails.BranchDetails.BranchID, mclsTerminalDetails.TerminalNo);
clsCashierReport.CommitAndDispose();
DateTime StartDate = clsCashierReportDetails.LastLoginDate;
DateTime EndDate = DateTime.Now;
DialogResult result = DialogResult.OK;
if (mclsTerminalDetails.PreviewTerminalReport)
{
PLUReportWnd clsPLUReportWnd = new PLUReportWnd();
clsPLUReportWnd.TerminalDetails = mclsTerminalDetails;
clsPLUReportWnd.CashierName = mCashierName;
clsPLUReportWnd.dtPLUReport = dtpluReport;
clsPLUReportWnd.CashierReportDetail = clsCashierReportDetails;
clsPLUReportWnd.StartDate = StartDate;
clsPLUReportWnd.EndDate = EndDate;
clsPLUReportWnd.ShowDialog(this);
result = clsPLUReportWnd.Result;
clsPLUReportWnd.Close();
clsPLUReportWnd.Dispose();
}
if (result == DialogResult.OK)
{
// put variables in which printer to print
int iRetailPlusOSPrinter1Ctr = 0; int iRetailPlusOSPrinter2Ctr = 0; int iRetailPlusOSPrinter3Ctr = 0; int iRetailPlusOSPrinter4Ctr = 0; int iRetailPlusOSPrinter5Ctr = 0;
foreach (System.Data.DataRow dr in dtpluReport.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) { iRetailPlusOSPrinter1Ctr++; }
if (orderSlipPrinter2) { iRetailPlusOSPrinter2Ctr++; }
if (orderSlipPrinter3) { iRetailPlusOSPrinter3Ctr++; }
if (orderSlipPrinter4) { iRetailPlusOSPrinter4Ctr++; }
if (orderSlipPrinter5) { iRetailPlusOSPrinter5Ctr++; }
}
if (iRetailPlusOSPrinter1Ctr > 0) PrintPLUReportPerOrderSlipPrinter(dtpluReport, clsCashierReportDetails, StartDate, EndDate, AceSoft.RetailPlus.OrderSlipPrinter.RetailPlusOSPrinter1);
if (iRetailPlusOSPrinter2Ctr > 0) PrintPLUReportPerOrderSlipPrinter(dtpluReport, clsCashierReportDetails, StartDate, EndDate, AceSoft.RetailPlus.OrderSlipPrinter.RetailPlusOSPrinter2);
if (iRetailPlusOSPrinter3Ctr > 0) PrintPLUReportPerOrderSlipPrinter(dtpluReport, clsCashierReportDetails, StartDate, EndDate, AceSoft.RetailPlus.OrderSlipPrinter.RetailPlusOSPrinter3);
if (iRetailPlusOSPrinter4Ctr > 0) PrintPLUReportPerOrderSlipPrinter(dtpluReport, clsCashierReportDetails, StartDate, EndDate, AceSoft.RetailPlus.OrderSlipPrinter.RetailPlusOSPrinter4);
if (iRetailPlusOSPrinter5Ctr > 0) PrintPLUReportPerOrderSlipPrinter(dtpluReport, clsCashierReportDetails, StartDate, EndDate, AceSoft.RetailPlus.OrderSlipPrinter.RetailPlusOSPrinter5);
}
}
public void PrintPLUReportPerGroup()
{
Data.CashierReports clsCashierReport = new Data.CashierReports(mConnection, mTransaction);
mConnection = clsCashierReport.Connection; mTransaction = clsCashierReport.Transaction;
Data.CashierReportDetails clsCashierReportDetails = clsCashierReport.Details(mclsSalesTransactionDetails.CashierID, Constants.TerminalBranchID, mclsTerminalDetails.TerminalNo);
clsCashierReport.GeneratePLUReport(mclsTerminalDetails.BranchDetails.BranchID, mclsTerminalDetails.TerminalNo, false, mCashierName);
Data.PLUReport clsPLUReport = new Data.PLUReport(mConnection, mTransaction);
mConnection = clsPLUReport.Connection; mTransaction = clsPLUReport.Transaction;
System.Data.DataTable dtpluReport = clsPLUReport.ListAsDataTable(mclsTerminalDetails.BranchDetails.BranchID, mclsTerminalDetails.TerminalNo, true, "ProductGroup");
clsCashierReport.CommitAndDispose();
DateTime StartDate = clsCashierReportDetails.LastLoginDate;
DateTime EndDate = DateTime.Now;
DialogResult result = DialogResult.OK;
if (result == DialogResult.OK)
{
//PrintPLUReportPerGroupDelegate plureportDel = new PrintPLUReportPerGroupDelegate(PrintPLUReportPerGroup);
PrintPLUReportPerGroup(dtpluReport, clsCashierReportDetails, StartDate, EndDate);
}
}
public void PrintPLUReport()
{
Data.CashierReports clsCashierReport = new Data.CashierReports(mConnection, mTransaction);
mConnection = clsCashierReport.Connection; mTransaction = clsCashierReport.Transaction;
Data.CashierReportDetails clsCashierReportDetails = clsCashierReport.Details(mclsSalesTransactionDetails.CashierID, Constants.TerminalBranchID, mclsTerminalDetails.TerminalNo);
clsCashierReport.GeneratePLUReport(mclsTerminalDetails.BranchDetails.BranchID, mclsTerminalDetails.TerminalNo, false, mCashierName);
Data.PLUReport clsPLUReport = new Data.PLUReport(mConnection, mTransaction);
mConnection = clsPLUReport.Connection; mTransaction = clsPLUReport.Transaction;
System.Data.DataTable dtpluReport = clsPLUReport.ListAsDataTable(mclsTerminalDetails.BranchDetails.BranchID, mclsTerminalDetails.TerminalNo);
clsCashierReport.CommitAndDispose();
DateTime StartDate = clsCashierReportDetails.LastLoginDate;
DateTime EndDate = DateTime.Now;
DialogResult result = DialogResult.OK;
if (mclsTerminalDetails.PreviewTerminalReport)
{
PLUReportWnd clsPLUReportWnd = new PLUReportWnd();
clsPLUReportWnd.TerminalDetails = mclsTerminalDetails;
clsPLUReportWnd.CashierName = mCashierName;
clsPLUReportWnd.dtPLUReport = dtpluReport;
clsPLUReportWnd.CashierReportDetail = clsCashierReportDetails;
clsPLUReportWnd.StartDate = StartDate;
clsPLUReportWnd.EndDate = EndDate;
clsPLUReportWnd.ShowDialog(this);
result = clsPLUReportWnd.Result;
clsPLUReportWnd.Close();
clsPLUReportWnd.Dispose();
}
if (result == DialogResult.OK)
{
//PrintPLUReportDelegate plureportDel = new PrintPLUReportDelegate(PrintPLUReport);
PrintPLUReport(dtpluReport, clsCashierReportDetails, StartDate, EndDate);
}
}
// returns True if a composition exist
// returns False if a composition does not exist
public bool GeneratePLUReport(Int32 BranchID, string TerminalNo, long MainProductID, string MainProductCode, decimal Quantity)
{
try
{
bool boRetValue = false;
System.Data.DataTable dtCompositionList = ListAsDataTable(MainProductID, "CompositionID", SortOption.Ascending);
Data.PLUReport clsPLUReport = new Data.PLUReport(base.Connection, base.Transaction);
PLUReportDetails clsPLUReportDetails;
foreach (System.Data.DataRow dr in dtCompositionList.Rows)
{
long lProductID = Convert.ToInt64(dr["ProductID"]);
string stProductCode = dr["ProductCode"].ToString();
decimal decQuantity = Convert.ToDecimal(Convert.ToDecimal(dr["Quantity"]) * Quantity);
bool boOrderSlipPrinter1 = bool.Parse(dr["OrderSlipPrinter1"].ToString());
bool boOrderSlipPrinter2 = bool.Parse(dr["OrderSlipPrinter2"].ToString());
bool boOrderSlipPrinter3 = bool.Parse(dr["OrderSlipPrinter3"].ToString());
bool boOrderSlipPrinter4 = bool.Parse(dr["OrderSlipPrinter4"].ToString());
bool boOrderSlipPrinter5 = bool.Parse(dr["OrderSlipPrinter5"].ToString());
clsPLUReportDetails = new PLUReportDetails();
clsPLUReportDetails.BranchDetails = new BranchDetails
{
BranchID = BranchID
};
clsPLUReportDetails.TerminalNo = TerminalNo;
clsPLUReportDetails.ProductID = lProductID;
clsPLUReportDetails.ProductCode = MainProductCode + "-" + stProductCode;
clsPLUReportDetails.Quantity = decQuantity;
clsPLUReportDetails.Amount = 0;
if (boOrderSlipPrinter1)
{
clsPLUReportDetails.OrderSlipPrinter = OrderSlipPrinter.RetailPlusOSPrinter1; clsPLUReport.Insert(clsPLUReportDetails);
}
if (boOrderSlipPrinter2)
{
clsPLUReportDetails.OrderSlipPrinter = OrderSlipPrinter.RetailPlusOSPrinter2; clsPLUReport.Insert(clsPLUReportDetails);
}
if (boOrderSlipPrinter3)
{
clsPLUReportDetails.OrderSlipPrinter = OrderSlipPrinter.RetailPlusOSPrinter3; clsPLUReport.Insert(clsPLUReportDetails);
}
if (boOrderSlipPrinter4)
{
clsPLUReportDetails.OrderSlipPrinter = OrderSlipPrinter.RetailPlusOSPrinter4; clsPLUReport.Insert(clsPLUReportDetails);
}
if (boOrderSlipPrinter5)
{
clsPLUReportDetails.OrderSlipPrinter = OrderSlipPrinter.RetailPlusOSPrinter5; clsPLUReport.Insert(clsPLUReportDetails);
}
GeneratePLUReport(BranchID, TerminalNo, lProductID, stProductCode, decQuantity);
boRetValue = true;
}
return(boRetValue);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
// returns True if a composition exist
// returns False if a composition does not exist
public bool GeneratePLUReport(Int32 BranchID, string TerminalNo, long MainProductID, string MainProductCode, decimal Quantity)
{
try
{
bool boRetValue = false;
System.Data.DataTable dtCompositionList = ListAsDataTable(MainProductID, "CompositionID", SortOption.Ascending);
Data.PLUReport clsPLUReport = new Data.PLUReport(base.Connection, base.Transaction);
PLUReportDetails clsPLUReportDetails;
foreach(System.Data.DataRow dr in dtCompositionList.Rows)
{
long lProductID = Convert.ToInt64(dr["ProductID"]);
string stProductCode = dr["ProductCode"].ToString();
decimal decQuantity = Convert.ToDecimal(Convert.ToDecimal(dr["Quantity"]) * Quantity);
bool boOrderSlipPrinter1 = bool.Parse(dr["OrderSlipPrinter1"].ToString());
bool boOrderSlipPrinter2 = bool.Parse(dr["OrderSlipPrinter2"].ToString());
bool boOrderSlipPrinter3 = bool.Parse(dr["OrderSlipPrinter3"].ToString());
bool boOrderSlipPrinter4 = bool.Parse(dr["OrderSlipPrinter4"].ToString());
bool boOrderSlipPrinter5 = bool.Parse(dr["OrderSlipPrinter5"].ToString());
clsPLUReportDetails = new PLUReportDetails();
clsPLUReportDetails.BranchDetails = new BranchDetails
{
BranchID = BranchID
};
clsPLUReportDetails.TerminalNo = TerminalNo;
clsPLUReportDetails.ProductID = lProductID;
clsPLUReportDetails.ProductCode = MainProductCode + "-" + stProductCode;
clsPLUReportDetails.Quantity = decQuantity;
clsPLUReportDetails.Amount = 0;
if (boOrderSlipPrinter1) { clsPLUReportDetails.OrderSlipPrinter = OrderSlipPrinter.RetailPlusOSPrinter1; clsPLUReport.Insert(clsPLUReportDetails); }
if (boOrderSlipPrinter2) { clsPLUReportDetails.OrderSlipPrinter = OrderSlipPrinter.RetailPlusOSPrinter2; clsPLUReport.Insert(clsPLUReportDetails); }
if (boOrderSlipPrinter3) { clsPLUReportDetails.OrderSlipPrinter = OrderSlipPrinter.RetailPlusOSPrinter3; clsPLUReport.Insert(clsPLUReportDetails); }
if (boOrderSlipPrinter4) { clsPLUReportDetails.OrderSlipPrinter = OrderSlipPrinter.RetailPlusOSPrinter4; clsPLUReport.Insert(clsPLUReportDetails); }
if (boOrderSlipPrinter5) { clsPLUReportDetails.OrderSlipPrinter = OrderSlipPrinter.RetailPlusOSPrinter5; clsPLUReport.Insert(clsPLUReportDetails); }
GeneratePLUReport(BranchID, TerminalNo, lProductID, stProductCode, decQuantity);
boRetValue = true;
}
return boRetValue;
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
