private void SaveRecord()
{
TerminalDetails clsDetails = new TerminalDetails();
clsDetails.BranchID = Convert.ToInt32(lblBranchID.Text);
clsDetails.TerminalID = Convert.ToInt32(lblTerminalID.Text);
clsDetails.TerminalNo = txtTerminalNo.Text;
clsDetails.TerminalCode = txtTerminalCode.Text;
clsDetails.TerminalName = txtTerminalName.Text;
clsDetails.Status = 0;
clsDetails.DateCreated = Convert.ToDateTime(txtDateCreated.Text);
clsDetails.MachineSerialNo = txtMachineSerialNo.Text;
clsDetails.AccreditationNo = txtAccreditationNo.Text;
clsDetails.IsPrinterAutoCutter = Convert.ToBoolean(chkIsPrinterAutoCutter.Checked);
clsDetails.AutoPrint = (PrintingPreference) Enum.Parse(typeof(PrintingPreference), cboAutoPrint.SelectedItem.Value);
clsDetails.IsVATInclusive = Convert.ToBoolean(chkIsVATInclusive.Checked);
clsDetails.PrinterName = txtPrinterName.Text;
clsDetails.TurretName = txtTurretName.Text;
clsDetails.CashDrawerName = txtCashDrawerName.Text;
clsDetails.ItemVoidConfirmation = Convert.ToBoolean(chkItemVoidConfirmation.Checked);
clsDetails.EnableEVAT = Convert.ToBoolean(chkEnableEVAT.Checked);
clsDetails.MaxReceiptWidth = Convert.ToInt16(txtMaxReceiptWidth.Text);
clsDetails.FORM_Behavior = cboFormBehaviour.SelectedItem.Value;
clsDetails.MarqueeMessage = txtMarqueeMessage.Text;
// Added May 6, 2009.
clsDetails.VAT = Convert.ToDecimal(txtVAT.Text);
clsDetails.EVAT = Convert.ToDecimal(txtEVAT.Text);
clsDetails.LocalTax = Convert.ToDecimal(txtLocalTax.Text);
clsDetails.ShowItemMoreThanZeroQty = chkShowItemMoreThanZeroQty.Checked;
clsDetails.ShowOnlyPackedTransactions = chkShowOnlyPackedTransactions.Checked;
clsDetails.ShowOneTerminalSuspendedTransactions = chkShowOneTerminalSuspendedTransactions.Checked;
clsDetails.ReceiptType = (TerminalReceiptType)Enum.Parse(typeof(TerminalReceiptType), cboReceiptType.SelectedItem.Value);
clsDetails.SalesInvoicePrinterName = txtSalesInvoicePrinterName.Text;
clsDetails.CashCountBeforeReport = chkCashCountBeforeReport.Checked;
clsDetails.PreviewTerminalReport = chkPreviewTerminalReport.Checked;
// Added May 6, 2009.
clsDetails.IsPrinterDotMatrix = chkIsPrinterDotmatrix.Checked;
clsDetails.IsChargeEditable = chkIsChargeEditable.Checked;
clsDetails.IsDiscountEditable = chkIsDiscountEditable.Checked;
clsDetails.CheckCutOffTime = chkCheckCutOffTime.Checked;
clsDetails.StartCutOffTime = txtStartCutOffTime.Text;
clsDetails.EndCutOffTime = txtEndCutOffTime.Text;
clsDetails.WithRestaurantFeatures = chkWithRestaurantFeatures.Checked;
clsDetails.SeniorCitizenDiscountCode = cboDiscountCode.SelectedItem.Value;
clsDetails.PWDDiscountCode = cboPWDDiscountCode.SelectedItem.Value;
// Added May 21, 2009
clsDetails.IsTouchScreen = chkIsTouchScreen.Checked;
// Added June 1, 2010
clsDetails.WillContinueSelectionVariation = chkWillContinueSelectionVariation.Checked;
// Added June 15, 2010
clsDetails.WillContinueSelectionProduct = chkWillContinueSelectionProduct.Checked;
// Added Sep 21, 2010
clsDetails.WillPrintGrandTotal = chkWillPrintGrandTotal.Checked;
// Added Apr 12, 2011
clsDetails.ReservedAndCommit = chkReservedAndCommit.Checked;
// Added Oct 17, 2011
clsDetails.ShowCustomerSelection = chkShowCustomerSelection.Checked;
clsDetails.GroupChargeType = new ChargeTypeDetails()
{
ChargeTypeID = int.Parse(cboGroupChargeType.SelectedItem.Value),
ChargeTypeCode = cboGroupChargeType.SelectedItem.Text
};
clsDetails.PersonalChargeType = new ChargeTypeDetails()
{
ChargeTypeID = int.Parse(cboPersonalChargeType.SelectedItem.Value),
ChargeTypeCode = cboPersonalChargeType.SelectedItem.Text
};
// Added Sep 24, 2014
clsDetails.DefaultTransactionChargeCode = cboDefaultTransactionChargeCode.SelectedItem.Value;
clsDetails.DineInChargeCode = cboDineInChargeCode.SelectedItem.Value;
clsDetails.TakeOutChargeCode = cboTakeOutChargeCode.SelectedItem.Value;
clsDetails.DeliveryChargeCode = cboDeliveryChargeCode.SelectedItem.Value;
Terminal clsTerminal = new Terminal();
clsTerminal.Update(clsDetails);
clsTerminal.CommitAndDispose();
}
private TerminalDetails SetDetails(System.Data.DataTable dt)
{
int iPersonalChargeTypeID = 0;
int iGroupChargeTypeID = 0;
TerminalDetails Details = new TerminalDetails();
foreach(System.Data.DataRow dr in dt.Rows)
{
Details.BranchID = Int32.Parse(dr["BranchID"].ToString());
Details.TerminalID = Int32.Parse(dr["TerminalID"].ToString());
Details.TerminalNo = dr["TerminalNo"].ToString();
Details.TerminalCode = dr["TerminalCode"].ToString();
Details.TerminalName = dr["TerminalName"].ToString();
Details.Status = (TerminalStatus)Enum.Parse(typeof(TerminalStatus), dr["Status"].ToString());
Details.DateCreated = DateTime.Parse(dr["DateCreated"].ToString());
Details.IsPrinterAutoCutter = bool.Parse(dr["IsPrinterAutoCutter"].ToString());
Details.MaxReceiptWidth = Int16.Parse(dr["MaxReceiptWidth"].ToString());
Details.TransactionNoLength = Int16.Parse(dr["TransactionNoLength"].ToString());
Details.AutoPrint = (PrintingPreference)Enum.Parse(typeof(PrintingPreference), dr["AutoPrint"].ToString());
Details.IsVATInclusive = bool.Parse(dr["IsVATInclusive"].ToString());
Details.PrinterName = dr["PrinterName"].ToString();
Details.TurretName = dr["TurretName"].ToString();
Details.CashDrawerName = dr["CashDrawerName"].ToString();
Details.MachineSerialNo = dr["MachineSerialNo"].ToString();
Details.AccreditationNo = dr["AccreditationNo"].ToString();
Details.ItemVoidConfirmation = bool.Parse(dr["ItemVoidConfirmation"].ToString());
Details.EnableEVAT = bool.Parse(dr["EnableEVAT"].ToString());
Details.FORM_Behavior = dr["FORM_Behavior"].ToString();
Details.MarqueeMessage = dr["MarqueeMessage"].ToString();
Details.TrustFund = decimal.Parse(dr["TrustFund"].ToString());
Details.VAT = decimal.Parse(dr["VAT"].ToString());
Details.EVAT = decimal.Parse(dr["EVAT"].ToString());
Details.LocalTax = decimal.Parse(dr["LocalTax"].ToString());
Details.ShowItemMoreThanZeroQty = bool.Parse(dr["ShowItemMoreThanZeroQty"].ToString());
Details.ShowOnlyPackedTransactions = bool.Parse(dr["ShowOnlyPackedTransactions"].ToString());
Details.ShowOneTerminalSuspendedTransactions = bool.Parse(dr["ShowOneTerminalSuspendedTransactions"].ToString());
Details.ReceiptType = (TerminalReceiptType)Enum.Parse(typeof(TerminalReceiptType), dr["TerminalReceiptType"].ToString());
Details.SalesInvoicePrinterName = dr["SalesInvoicePrinterName"].ToString();
Details.CashCountBeforeReport = bool.Parse(dr["CashCountBeforeReport"].ToString());
Details.PreviewTerminalReport = bool.Parse(dr["PreviewTerminalReport"].ToString());
// Added May 5, 2009
Details.IsPrinterDotMatrix = bool.Parse(dr["IsPrinterDotMatrix"].ToString());
Details.IsChargeEditable = bool.Parse(dr["IsChargeEditable"].ToString());
Details.IsDiscountEditable = bool.Parse(dr["IsDiscountEditable"].ToString());
Details.CheckCutOffTime = bool.Parse(dr["CheckCutOffTime"].ToString());
Details.StartCutOffTime = dr["StartCutOffTime"].ToString();
Details.EndCutOffTime = dr["EndCutOffTime"].ToString();
Details.WithRestaurantFeatures = bool.Parse(dr["WithRestaurantFeatures"].ToString());
// Added Nov 8, 2011
Details.IsFineDining = bool.Parse(dr["IsFineDIning"].ToString());
// -- end
Details.SeniorCitizenDiscountCode = dr["SeniorCitizenDiscountCode"].ToString();
Details.PWDDiscountCode = dr["PWDDiscountCode"].ToString();
// Added May 21, 2009
Details.IsTouchScreen = bool.Parse(dr["IsTouchScreen"].ToString());
// Added June 1, 2010
Details.WillContinueSelectionVariation = bool.Parse(dr["WillContinueSelectionVariation"].ToString());
Details.WillContinueSelectionProduct = bool.Parse(dr["WillContinueSelectionProduct"].ToString());
// Added July 9, 2010
Details.WSPriceMarkUp = decimal.Parse(dr["WSPriceMarkUp"].ToString());
Details.RETPriceMarkUp = decimal.Parse(dr["RETPriceMarkUp"].ToString());
// Added Sep 21, 2010
Details.WillPrintGrandTotal = bool.Parse(dr["WillPrintGrandTotal"].ToString());
// Added Apr 12, 2011
Details.ReservedAndCommit = bool.Parse(dr["ReservedAndCommit"].ToString());
// Added Sep 10, 2011
Details.DBVersion = dr["DBVersion"].ToString();
// Added Oct 17, 2011
Details.ShowCustomerSelection = bool.Parse(dr["ShowCustomerSelection"].ToString());
Details.AutoGenerateRewardCardNo = bool.Parse(dr["AutoGenerateRewardCardNo"].ToString());
// Added Oct 17, 2011
RewardPointsDetails clsRewardPointsDetails = new RewardPointsDetails();
clsRewardPointsDetails.EnableRewardPoints = bool.Parse(dr["EnableRewardPoints"].ToString());
clsRewardPointsDetails.RoundDownRewardPoints = bool.Parse(dr["RoundDownRewardPoints"].ToString());
clsRewardPointsDetails.RewardPointsMinimum = decimal.Parse(dr["RewardPointsMinimum"].ToString());
clsRewardPointsDetails.RewardPointsEvery = decimal.Parse(dr["RewardPointsEvery"].ToString());
clsRewardPointsDetails.RewardPoints = decimal.Parse(dr["RewardPoints"].ToString());
// Added Nov 4, 2011 : For use as payment
clsRewardPointsDetails.EnableRewardPointsAsPayment = bool.Parse(dr["EnableRewardPointsAsPayment"].ToString());
clsRewardPointsDetails.RewardPointsMaxPercentageForPayment = decimal.Parse(dr["RewardPointsMaxPercentageForPayment"].ToString());
clsRewardPointsDetails.RewardPointsPaymentValue = decimal.Parse(dr["RewardPointsPaymentValue"].ToString());
clsRewardPointsDetails.RewardPointsPaymentCashEquivalent = decimal.Parse(dr["RewardPointsPaymentCashEquivalent"].ToString());
clsRewardPointsDetails.RewardsPermitNo = dr["RewardsPermitNo"].ToString();
Details.RewardPointsDetails = clsRewardPointsDetails;
//Details.InHouseIndividualCreditPermitNo = dr["InHouseIndividualCreditPermitNo"].ToString();
//Details.InHouseGroupCreditPermitNo = dr["InHouseGroupCreditPermitNo"].ToString();
iPersonalChargeTypeID = Int32.Parse(dr["PersonalChargeTypeID"].ToString());
iGroupChargeTypeID = Int32.Parse(dr["GroupChargeTypeID"].ToString());
// Added Mar 18, 2012
Details.ProductSearchType = (ProductSearchType)Enum.Parse(typeof(ProductSearchType), dr["ProductSearchType"].ToString());
// Added Apr 29, 2013
Details.IncludeCreditChargeAgreement = bool.Parse(dr["IncludeCreditChargeAgreement"].ToString());
// Added Jun 30, 2013
Details.IsParkingTerminal = bool.Parse(dr["IsParkingTerminal"].ToString());
Details.WillPrintChargeSlip = bool.Parse(dr["WillPrintChargeSlip"].ToString());
Details.WillPrintVoidItem = bool.Parse(dr["WillPrintVoidItem"].ToString());
// Added Oct 20, 2013
Details.IncludeTermsAndConditions = bool.Parse(dr["IncludeTermsAndConditions"].ToString());
Details.DefaultTransactionChargeCode = dr["DefaultTransactionChargeCode"].ToString();
Details.DineInChargeCode = dr["DineInChargeCode"].ToString();
Details.TakeOutChargeCode = dr["TakeOutChargeCode"].ToString();
Details.DeliveryChargeCode = dr["DeliveryChargeCode"].ToString();
Details.ORSeriesBranchID = Int32.Parse(dr["ORSeriesBranchID"].ToString());
Details.ORSeriesTerminalNo = dr["ORSeriesTerminalNo"].ToString();
// Added Jul 4, 2015
Details.MultiInstanceEnabled = bool.Parse(dr["MultiInstanceEnabled"].ToString());
Details.MaskProductSearch = dr["MaskProductSearch"].ToString().Replace('*', '%');
}
Branch clsBranch = new Branch(base.Connection, base.Transaction);
Details.BranchDetails = clsBranch.Details(Convert.ToInt16(Details.BranchID));
ChargeType clsChargeType = new ChargeType(base.Connection, base.Transaction);
if (iPersonalChargeTypeID != 0)
{ Details.PersonalChargeType = clsChargeType.Details(iPersonalChargeTypeID); }
if (iGroupChargeTypeID != 0)
{ Details.GroupChargeType = clsChargeType.Details(iGroupChargeTypeID); }
return Details;
}
/// <summary>
/// Sep 4, 2014 Remove coz this is redundant
/// </summary>
/// <param name="Details"></param>
/// <returns></returns>
//public Int16 Insert(TerminalDetails Details)
//{
// try
// {
// string SQL="INSERT INTO tblTerminal(" +
// "BranchID, " +
// "TerminalNo, " +
// "TerminalCode, " +
// "TerminalName, " +
// "Status, " +
// "DateCreated, " +
// "MachineSerialNo, " +
// "AccreditationNo " +
// ")VALUES(" +
// "@BranchID, " +
// "@TerminalNo, " +
// "@TerminalCode, " +
// "@TerminalName, " +
// "@Status, " +
// "NOW(), " +
// "@MachineSerialNo, " +
// "@AccreditationNo" +
// ");";
// MySqlCommand cmd = new MySqlCommand();
// cmd.CommandType = System.Data.CommandType.Text;
// cmd.CommandText = SQL;
// MySqlParameter prmBranchID = new MySqlParameter("@BranchID",MySqlDbType.Int32);
// prmBranchID.Value = Details.BranchID;
// cmd.Parameters.Add(prmBranchID);
// MySqlParameter prmTerminalNo = new MySqlParameter("@TerminalNo",MySqlDbType.String);
// prmTerminalNo.Value = Details.TerminalNo;
// cmd.Parameters.Add(prmTerminalNo);
// MySqlParameter prmTerminalCode = new MySqlParameter("@TerminalCode",MySqlDbType.String);
// prmTerminalCode.Value = Details.TerminalCode;
// cmd.Parameters.Add(prmTerminalCode);
// MySqlParameter prmTerminalName = new MySqlParameter("@TerminalName",MySqlDbType.String);
// prmTerminalName.Value = Details.TerminalName;
// cmd.Parameters.Add(prmTerminalName);
// MySqlParameter prmStatus = new MySqlParameter("@Status",MySqlDbType.Int16);
// prmStatus.Value = Details.Status.ToString("d");
// cmd.Parameters.Add(prmStatus);
// MySqlParameter prmDateCreated = new MySqlParameter("@DateCreated",MySqlDbType.DateTime);
// prmDateCreated.Value = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
// cmd.Parameters.Add(prmDateCreated);
// MySqlParameter prmMachineSerialNo = new MySqlParameter("@MachineSerialNo",MySqlDbType.String);
// prmMachineSerialNo.Value = Details.MachineSerialNo;
// cmd.Parameters.Add(prmMachineSerialNo);
// MySqlParameter prmAccreditationNo = new MySqlParameter("@AccreditationNo",MySqlDbType.String);
// prmAccreditationNo.Value = Details.AccreditationNo;
// cmd.Parameters.Add(prmAccreditationNo);
// base.ExecuteNonQuery(cmd);
// SQL = "SELECT LAST_INSERT_ID();";
// cmd.Parameters.Clear();
// cmd.CommandText = SQL;
// System.Data.DataTable dt = new System.Data.DataTable("LAST_INSERT_ID");
// base.MySqlDataAdapterFill(cmd, dt);
// Int16 iID = 0;
// foreach (System.Data.DataRow dr in dt.Rows)
// {
// iID = Int16.Parse(dr[0].ToString());
// }
// TerminalReport clsTerminalReport = new TerminalReport(base.Connection, base.Transaction);
// clsTerminalReport.Insert(Details.BranchID, iID, CompanyDetails.TerminalNo);
// return iID;
// }
// catch (Exception ex)
// {
// throw base.ThrowException(ex);
// }
//}
public void Update(TerminalDetails Details)
{
try
{
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
string SQL = "CALL procTerminalUpdate(@BranchID, @TerminalID, " +
"@IsPrinterAutoCutter, " +
"@AutoPrint, " +
"@IsVATInclusive, " +
"@PrinterName, " +
"@TurretName, " +
"@CashDrawerName, " +
"@ItemVoidConfirmation, " +
"@EnableEVAT, " +
"@MaxReceiptWidth, " +
"@FORM_Behavior, " +
"@MarqueeMessage, " +
"@MachineSerialNo, " +
"@AccreditationNo, " +
"@VAT, " +
"@EVAT, " +
"@LocalTax, " +
"@ShowItemMoreThanZeroQty, " +
"@ShowOnlyPackedTransactions, " +
"@ShowOneTerminalSuspendedTransactions, " +
"@ReceiptType, " +
"@SalesInvoicePrinterName, " +
"@CashCountBeforeReport, " +
"@PreviewTerminalReport, " +
"@IsPrinterDotMatrix, " +
"@IsChargeEditable, " +
"@IsDiscountEditable, " +
"@CheckCutOffTime, " +
"@StartCutOffTime, " +
"@EndCutOffTime, " +
"@WithRestaurantFeatures, " +
"@SeniorCitizenDiscountCode, " +
"@PWDDiscountCode, " +
"@GroupChargeType, " +
"@PersonalChargeType, " +
"@DefaultTransactionChargeCode, " +
"@DineInChargeCode, " +
"@TakeOutChargeCode, " +
"@DeliveryChargeCode, " +
"@IsTouchScreen," +
"@WillContinueSelectionVariation," +
"@WillContinueSelectionProduct," +
"@WillPrintGrandTotal," +
"@ReservedAndCommit," +
"@ShowCustomerSelection);";
cmd.Parameters.AddWithValue("BranchID", Details.BranchID);
cmd.Parameters.AddWithValue("TerminalID", Details.TerminalID);
cmd.Parameters.AddWithValue("IsPrinterAutoCutter", Details.IsPrinterAutoCutter);
cmd.Parameters.AddWithValue("AutoPrint", Details.AutoPrint.ToString("d"));
cmd.Parameters.AddWithValue("IsVATInclusive", Details.IsVATInclusive);
cmd.Parameters.AddWithValue("PrinterName", Details.PrinterName);
cmd.Parameters.AddWithValue("TurretName", Details.TurretName);
cmd.Parameters.AddWithValue("CashDrawerName", Details.CashDrawerName);
cmd.Parameters.AddWithValue("MaxReceiptWidth", Details.MaxReceiptWidth);
cmd.Parameters.AddWithValue("ItemVoidConfirmation", Details.ItemVoidConfirmation);
cmd.Parameters.AddWithValue("EnableEVAT", Details.EnableEVAT);
cmd.Parameters.AddWithValue("FORM_Behavior", Details.FORM_Behavior);
cmd.Parameters.AddWithValue("MarqueeMessage", Details.MarqueeMessage);
cmd.Parameters.AddWithValue("MachineSerialNo", Details.MachineSerialNo);
cmd.Parameters.AddWithValue("AccreditationNo", Details.AccreditationNo);
cmd.Parameters.AddWithValue("VAT", Details.VAT);
cmd.Parameters.AddWithValue("EVAT", Details.EVAT);
cmd.Parameters.AddWithValue("LocalTax", Details.LocalTax);
cmd.Parameters.AddWithValue("ShowItemMoreThanZeroQty", Details.ShowItemMoreThanZeroQty);
cmd.Parameters.AddWithValue("ShowOnlyPackedTransactions", Details.ShowOnlyPackedTransactions);
cmd.Parameters.AddWithValue("ShowOneTerminalSuspendedTransactions", Details.ShowOneTerminalSuspendedTransactions);
cmd.Parameters.AddWithValue("ReceiptType", Details.ReceiptType.ToString("d"));
cmd.Parameters.AddWithValue("SalesInvoicePrinterName", Details.SalesInvoicePrinterName);
cmd.Parameters.AddWithValue("CashCountBeforeReport", Details.CashCountBeforeReport);
cmd.Parameters.AddWithValue("PreviewTerminalReport", Details.PreviewTerminalReport);
cmd.Parameters.AddWithValue("IsPrinterDotMatrix", Details.IsPrinterDotMatrix);
cmd.Parameters.AddWithValue("IsChargeEditable", Details.IsChargeEditable);
cmd.Parameters.AddWithValue("IsDiscountEditable", Details.IsDiscountEditable);
cmd.Parameters.AddWithValue("CheckCutOffTime", Details.CheckCutOffTime);
cmd.Parameters.AddWithValue("StartCutOffTime", Details.StartCutOffTime);
cmd.Parameters.AddWithValue("EndCutOffTime", Details.EndCutOffTime);
cmd.Parameters.AddWithValue("WithRestaurantFeatures", Details.WithRestaurantFeatures);
cmd.Parameters.AddWithValue("SeniorCitizenDiscountCode", Details.SeniorCitizenDiscountCode);
cmd.Parameters.AddWithValue("PWDDiscountCode", Details.PWDDiscountCode);
cmd.Parameters.AddWithValue("GroupChargeType", Details.GroupChargeType.ChargeTypeID);
cmd.Parameters.AddWithValue("PersonalChargeType", Details.PersonalChargeType.ChargeTypeID);
cmd.Parameters.AddWithValue("DefaultTransactionChargeCode", Details.DefaultTransactionChargeCode);
cmd.Parameters.AddWithValue("DineInChargeCode", Details.DineInChargeCode);
cmd.Parameters.AddWithValue("TakeOutChargeCode", Details.TakeOutChargeCode);
cmd.Parameters.AddWithValue("DeliveryChargeCode", Details.DeliveryChargeCode);
cmd.Parameters.AddWithValue("IsTouchScreen", Details.IsTouchScreen);
cmd.Parameters.AddWithValue("WillContinueSelectionVariation", Details.WillContinueSelectionVariation);
cmd.Parameters.AddWithValue("WillContinueSelectionProduct", Details.WillContinueSelectionProduct);
cmd.Parameters.AddWithValue("WillPrintGrandTotal", Details.WillPrintGrandTotal);
cmd.Parameters.AddWithValue("ReservedAndCommit", Details.ReservedAndCommit);
cmd.Parameters.AddWithValue("ShowCustomerSelection", Details.ShowCustomerSelection);
cmd.CommandText = SQL;
base.ExecuteNonQuery(cmd);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public Int32 Save(TerminalDetails Details)
{
try
{
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
string SQL = "CALL procSaveTerminal(@TerminalID, @TerminalNo, @TerminalCode, @TerminalName, @Status, @DateCreated, " +
"@IsPrinterAutoCutter, @MaxReceiptWidth, @TransactionNoLength, @AutoPrint, @PrinterName, " +
"@TurretName, @CashDrawerName, @MachineSerialNo, @AccreditationNo, @ItemVoidConfirmation, " +
"@EnableEVAT, @FORM_Behavior, @MarqueeMessage, @TrustFund, @IsVATInclusive, @VAT, @EVAT, " +
"@LocalTax, @ShowItemMoreThanZeroQty, @ShowOneTerminalSuspendedTransactions, " +
"@ShowOnlyPackedTransactions, @TerminalReceiptType, @SalesInvoicePrinterName, " +
"@CashCountBeforeReport, @PreviewTerminalReport, @OrderSlipPrinter, @DBVersion, @FEVersion, " +
"@BEVersion, @IsPrinterDotmatrix, @IsChargeEditable, @IsDiscountEditable, @CheckCutOffTime, " +
"@StartCutOffTime, @EndCutOffTime, @WithRestaurantFeatures, @SeniorCitizenDiscountCode, " +
"@IsTouchScreen, @WillContinueSelectionVariation, @WillContinueSelectionProduct, " +
"@RETPriceMarkUp, @WSPriceMarkUp, @WillPrintGrandTotal, @ReservedAndCommit, " +
"@ShowCustomerSelection, @EnableRewardPoints, @RewardPointsMinimum, @RewardPointsEvery, " +
"@RewardPoints, @RoundDownRewardPoints, @AutoGenerateRewardCardNo, " +
"@EnableRewardPointsAsPayment, @RewardPointsMaxPercentageForPayment, " +
"@RewardPointsPaymentValue, @RewardPointsPaymentCashEquivalent, @RewardsPermitNo, " +
"@IsFineDining, " +
//"@InHouseIndividualCreditPermitNo, @InHouseGroupCreditPermitNo, @IsFineDining, " +
"@PersonalChargeTypeID, @GroupChargeTypeID, @BranchID, @ProductSearchType, " +
"@IncludeCreditChargeAgreement, @IsParkingTerminal, @WillPrintChargeSlip, @WillPrintVoidItem, " +
"@IncludeTermsAndConditions, @PWDDiscountCode, @DefaultTransactionChargeCode, @DineInChargeCode, " +
"@TakeOutChargeCode, @DeliveryChargeCode, @CreatedOn, @LastModified);";
cmd.Parameters.AddWithValue("TerminalID", Details.TerminalID);
cmd.Parameters.AddWithValue("TerminalNo", Details.TerminalNo);
cmd.Parameters.AddWithValue("TerminalCode", Details.TerminalCode);
cmd.Parameters.AddWithValue("TerminalName", Details.TerminalName);
cmd.Parameters.AddWithValue("Status", Details.Status);
cmd.Parameters.AddWithValue("DateCreated", Details.DateCreated);
cmd.Parameters.AddWithValue("IsPrinterAutoCutter", Details.IsPrinterAutoCutter);
cmd.Parameters.AddWithValue("MaxReceiptWidth", Details.MaxReceiptWidth);
cmd.Parameters.AddWithValue("TransactionNoLength", Details.TransactionNoLength);
cmd.Parameters.AddWithValue("AutoPrint", Details.AutoPrint);
cmd.Parameters.AddWithValue("PrinterName", Details.PrinterName);
cmd.Parameters.AddWithValue("TurretName", Details.TurretName);
cmd.Parameters.AddWithValue("CashDrawerName", Details.CashDrawerName);
cmd.Parameters.AddWithValue("MachineSerialNo", Details.MachineSerialNo);
cmd.Parameters.AddWithValue("AccreditationNo", Details.AccreditationNo);
cmd.Parameters.AddWithValue("ItemVoidConfirmation", Details.ItemVoidConfirmation);
cmd.Parameters.AddWithValue("EnableEVAT", Details.EnableEVAT);
cmd.Parameters.AddWithValue("FORM_Behavior", Details.FORM_Behavior);
cmd.Parameters.AddWithValue("MarqueeMessage", Details.MarqueeMessage);
cmd.Parameters.AddWithValue("TrustFund", Details.TrustFund);
cmd.Parameters.AddWithValue("IsVATInclusive", Details.IsVATInclusive);
cmd.Parameters.AddWithValue("VAT", Details.VAT);
cmd.Parameters.AddWithValue("EVAT", Details.EVAT);
cmd.Parameters.AddWithValue("LocalTax", Details.LocalTax);
cmd.Parameters.AddWithValue("ShowItemMoreThanZeroQty", Details.ShowItemMoreThanZeroQty);
cmd.Parameters.AddWithValue("ShowOneTerminalSuspendedTransactions", Details.ShowOneTerminalSuspendedTransactions);
cmd.Parameters.AddWithValue("ShowOnlyPackedTransactions", Details.ShowOnlyPackedTransactions);
cmd.Parameters.AddWithValue("TerminalReceiptType", Details.ReceiptType.ToString("d"));
cmd.Parameters.AddWithValue("SalesInvoicePrinterName", Details.SalesInvoicePrinterName);
cmd.Parameters.AddWithValue("CashCountBeforeReport", Details.CashCountBeforeReport);
cmd.Parameters.AddWithValue("PreviewTerminalReport", Details.PreviewTerminalReport);
cmd.Parameters.AddWithValue("OrderSlipPrinter", Details.OrderSlipPrinter.ToString("d"));
cmd.Parameters.AddWithValue("DBVersion", Details.DBVersion);
cmd.Parameters.AddWithValue("FEVersion", Details.FEVersion);
cmd.Parameters.AddWithValue("BEVersion", Details.BEVersion);
cmd.Parameters.AddWithValue("IsPrinterDotMatrix", Details.IsPrinterDotMatrix);
cmd.Parameters.AddWithValue("IsChargeEditable", Details.IsChargeEditable);
cmd.Parameters.AddWithValue("IsDiscountEditable", Details.IsDiscountEditable);
cmd.Parameters.AddWithValue("CheckCutOffTime", Details.CheckCutOffTime);
cmd.Parameters.AddWithValue("StartCutOffTime", Details.StartCutOffTime);
cmd.Parameters.AddWithValue("EndCutOffTime", Details.EndCutOffTime);
cmd.Parameters.AddWithValue("WithRestaurantFeatures", Details.WithRestaurantFeatures);
cmd.Parameters.AddWithValue("SeniorCitizenDiscountCode", Details.SeniorCitizenDiscountCode);
cmd.Parameters.AddWithValue("IsTouchScreen", Details.IsTouchScreen);
cmd.Parameters.AddWithValue("WillContinueSelectionVariation", Details.WillContinueSelectionVariation);
cmd.Parameters.AddWithValue("WillContinueSelectionProduct", Details.WillContinueSelectionProduct);
cmd.Parameters.AddWithValue("RETPriceMarkUp", Details.RETPriceMarkUp);
cmd.Parameters.AddWithValue("WSPriceMarkUp", Details.WSPriceMarkUp);
cmd.Parameters.AddWithValue("WillPrintGrandTotal", Details.WillPrintGrandTotal);
cmd.Parameters.AddWithValue("ReservedAndCommit", Details.ReservedAndCommit);
cmd.Parameters.AddWithValue("ShowCustomerSelection", Details.ShowCustomerSelection);
cmd.Parameters.AddWithValue("EnableRewardPoints", Details.RewardPointsDetails.EnableRewardPoints);
cmd.Parameters.AddWithValue("RewardPointsMinimum", Details.RewardPointsDetails.RewardPointsMinimum);
cmd.Parameters.AddWithValue("RewardPointsEvery", Details.RewardPointsDetails.RewardPointsEvery);
cmd.Parameters.AddWithValue("RewardPoints", Details.RewardPointsDetails.RewardPoints);
cmd.Parameters.AddWithValue("RoundDownRewardPoints", Details.RewardPointsDetails.RoundDownRewardPoints);
cmd.Parameters.AddWithValue("AutoGenerateRewardCardNo", Details.AutoGenerateRewardCardNo);
cmd.Parameters.AddWithValue("EnableRewardPointsAsPayment", Details.RewardPointsDetails.EnableRewardPointsAsPayment);
cmd.Parameters.AddWithValue("RewardPointsMaxPercentageForPayment", Details.RewardPointsDetails.RewardPointsMaxPercentageForPayment);
cmd.Parameters.AddWithValue("RewardPointsPaymentValue", Details.RewardPointsDetails.RewardPointsPaymentValue);
cmd.Parameters.AddWithValue("RewardPointsPaymentCashEquivalent", Details.RewardPointsDetails.RewardPointsPaymentCashEquivalent);
cmd.Parameters.AddWithValue("RewardsPermitNo", Details.RewardPointsDetails.RewardsPermitNo);
//cmd.Parameters.AddWithValue("InHouseIndividualCreditPermitNo", Details.InHouseIndividualCreditPermitNo);
//cmd.Parameters.AddWithValue("InHouseGroupCreditPermitNo", Details.InHouseGroupCreditPermitNo);
cmd.Parameters.AddWithValue("IsFineDining", Details.IsFineDining);
cmd.Parameters.AddWithValue("PersonalChargeTypeID", Details.PersonalChargeType.ChargeTypeID);
cmd.Parameters.AddWithValue("GroupChargeTypeID", Details.GroupChargeType.ChargeTypeID);
cmd.Parameters.AddWithValue("BranchID", Details.BranchID);
cmd.Parameters.AddWithValue("ProductSearchType", Details.ProductSearchType);
cmd.Parameters.AddWithValue("IncludeCreditChargeAgreement", Details.IncludeCreditChargeAgreement);
cmd.Parameters.AddWithValue("IsParkingTerminal", Details.IsParkingTerminal);
cmd.Parameters.AddWithValue("WillPrintChargeSlip", Details.WillPrintChargeSlip);
cmd.Parameters.AddWithValue("WillPrintVoidItem", Details.WillPrintVoidItem);
cmd.Parameters.AddWithValue("IncludeTermsAndConditions", Details.IncludeTermsAndConditions);
cmd.Parameters.AddWithValue("PWDDiscountCode", Details.PWDDiscountCode);
cmd.Parameters.AddWithValue("DefaultTransactionChargeCode", Details.DefaultTransactionChargeCode);
cmd.Parameters.AddWithValue("DineInChargeCode", Details.DineInChargeCode);
cmd.Parameters.AddWithValue("TakeOutChargeCode", Details.TakeOutChargeCode);
cmd.Parameters.AddWithValue("DeliveryChargeCode", Details.DeliveryChargeCode);
cmd.Parameters.AddWithValue("CreatedOn", Details.CreatedOn == DateTime.MinValue ? Constants.C_DATE_MIN_VALUE : Details.CreatedOn);
cmd.Parameters.AddWithValue("LastModified", Details.LastModified == DateTime.MinValue ? Constants.C_DATE_MIN_VALUE : Details.LastModified);
cmd.CommandText = SQL;
return base.ExecuteNonQuery(cmd);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public bool IsExist(Int32 BranchID, string TerminalNo, out TerminalDetails OutDetails)
{
try
{
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
bool boRetValue = false;
string SQL= SQLSelect() + "WHERE BranchID = @BranchID AND TerminalNo = @TerminalNo;";
cmd.Parameters.AddWithValue("@BranchID", BranchID);
cmd.Parameters.AddWithValue("@TerminalNo", TerminalNo);
cmd.CommandText = SQL;
string strDataTableName = "tbl" + this.GetType().FullName.Split(new Char[] { '.' })[this.GetType().FullName.Split(new Char[] { '.' }).Length - 1]; System.Data.DataTable dt = new System.Data.DataTable(strDataTableName);
base.MySqlDataAdapterFill(cmd, dt);
OutDetails = SetDetails(dt);
if (OutDetails.TerminalID != 0) boRetValue = true;
return boRetValue;
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}