private void SaveRecord()
{
RewardPointsDetails clsDetails = new RewardPointsDetails();
clsDetails.EnableRewardPoints = chkEnableRewardPoints.Checked;
clsDetails.RoundDownRewardPoints = chkRoundDownRewardPoints.Checked;
clsDetails.RewardPointsMinimum = Convert.ToDecimal(txtRewardPointsMinimum.Text);
clsDetails.RewardPointsEvery = Convert.ToDecimal(txtRewardPointsEvery.Text);
clsDetails.RewardPoints = Convert.ToDecimal(txtRewardPoints.Text);
clsDetails.EnableRewardPointsAsPayment = chkEnableRewardPointsAsPayment.Checked;
clsDetails.RewardPointsMaxPercentageForPayment = Convert.ToDecimal(txtRewardPointsMaxPercentageForPayment.Text);
clsDetails.RewardPointsPaymentValue = Convert.ToDecimal(txtRewardPointsPaymentValue.Text);
clsDetails.RewardPointsPaymentCashEquivalent = Convert.ToDecimal(txtRewardPointsPaymentCashEquivalent.Text);
Terminal clsTerminal = new Terminal();
clsTerminal.UpdateRewardPointSystem(clsDetails);
clsTerminal.CommitAndDispose();
}
public RewardPointsDetails RewardPointsDetails()
{
try
{
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
string SQL = "SELECT " +
"EnableRewardPoints, " +
"RoundDownRewardPoints, " +
"RewardPointsMinimum, " +
"RewardPointsEvery, " +
"RewardPoints, " +
"EnableRewardPointsAsPayment, " +
"RewardPointsMaxPercentageForPayment, " +
"RewardPointsPaymentValue, " +
"RewardPointsPaymentCashEquivalent, " +
"RewardsPermitNo " +
"FROM tblTerminal LIMIT 1 ";
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);
RewardPointsDetails clsRewardPointsDetails = new RewardPointsDetails();
foreach(System.Data.DataRow dr in dt.Rows)
{
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());
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();
}
return clsRewardPointsDetails;
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
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;
}
public void UpdateRewardPointSystem(RewardPointsDetails Details)
{
try
{
string SQL = "CALL procTerminalUpdateRewardPointSystem(@EnableRewardPoints, " +
"@RoundDownRewardPoints, " +
"@RewardPointsMinimum," +
"@RewardPointsEvery," +
"@RewardPoints," +
"@EnableRewardPointsAsPayment," +
"@RewardPointsMaxPercentageForPayment," +
"@RewardPointsPaymentValue," +
"@RewardPointsPaymentCashEquivalent);";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = SQL;
cmd.Parameters.AddWithValue("@EnableRewardPoints", Convert.ToInt16(Details.EnableRewardPoints));
cmd.Parameters.AddWithValue("@RoundDownRewardPoints", Convert.ToInt16(Details.RoundDownRewardPoints));
cmd.Parameters.AddWithValue("@RewardPointsMinimum", Details.RewardPointsMinimum);
cmd.Parameters.AddWithValue("@RewardPointsEvery", Details.RewardPointsEvery);
cmd.Parameters.AddWithValue("@RewardPoints", Details.RewardPoints);
cmd.Parameters.AddWithValue("@EnableRewardPointsAsPayment", Convert.ToInt16(Details.EnableRewardPointsAsPayment));
cmd.Parameters.AddWithValue("@RewardPointsMaxPercentageForPayment", Details.RewardPointsMaxPercentageForPayment);
cmd.Parameters.AddWithValue("@RewardPointsPaymentValue", Details.RewardPointsPaymentValue);
cmd.Parameters.AddWithValue("@RewardPointsPaymentCashEquivalent", Details.RewardPointsPaymentCashEquivalent);
base.ExecuteNonQuery(cmd);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
