public void AddRegFees()
{
TblMember member = new TblMember();
member.StrMembershipID = myMembershipID;
DataTable table = member.SelectOne();
DataRow memberRow = table.Rows[0];
bool isRegistered = ACMS.Convert.ToBoolean(memberRow["fRegistrationFee"]);
if (!isRegistered)
{
DialogResult result = MessageBox.Show("You are no yet paid the registration fees. Do you want to pay it now?", "Warning",
MessageBoxButtons.YesNo);
if (result == DialogResult.Yes)
{
TblPackage pckg = new TblPackage();
pckg.StrPackageCode = "JOINFEE";
pckg.SelectOne();
NewReceiptEntry("JOINFEE", myStaffPurchaseCategoryID, pckg.StrDescription.IsNull ? "" : pckg.StrDescription.Value,
1, ACMS.Convert.ToDecimal(pckg.MListPrice), "");
pckg.StrPackageCode = "FA";
pckg.SelectOne();
NewReceiptEntry("FA", myStaffPurchaseCategoryID, pckg.StrDescription.IsNull ? "" : pckg.StrDescription.Value,
1, ACMS.Convert.ToDecimal(pckg.MListPrice), "");
}
}
}
private void MakeDeposit(ACMSDAL.ConnectionProvider connProvider, ACMSLogic.POS pos)
{
if (pos.NCategoryID == 16)
{
TblMember member = new TblMember();
member.MainConnectionProvider = connProvider;
member.StrMembershipID = pos.StrMembershipID;
member.SelectOne();
member.FLockerDeposit = true;
member.Update();
}
}
private void ReplaceMembershipCardTransaction(ACMSDAL.ConnectionProvider connProvider, ACMSLogic.POS pos)
{
if (pos.NCategoryID == 20)
{
TblMember sqlMember = new TblMember();
sqlMember.MainConnectionProvider = connProvider;
sqlMember.StrMembershipID = pos.StrMembershipID;
sqlMember.SelectOne();
sqlMember.NCardStatusID = 0;
sqlMember.StrCardBranchCode = "WL";
sqlMember.Update();
TblMember sqlIntroduceMember = new TblMember();
sqlIntroduceMember.MainConnectionProvider = connProvider;
sqlIntroduceMember.StrIntroducerMembershipID = pos.StrMembershipID;
DataTable introduceMemberTable = sqlIntroduceMember.SelectAllWstrIntroducerMembershipIDLogic();
if (introduceMemberTable != null && introduceMemberTable.Rows.Count > 0)
{
foreach (DataRow r in introduceMemberTable.Rows)
r["StrIntroducerMembershipID"] = DBNull.Value;
sqlIntroduceMember.SaveData(introduceMemberTable);
}
string membershipID = pos.StrMembershipID;
string newStrMembershipID = "";
bool isMember = !membershipID.StartsWith("NMC");
if (!isMember)
{
TblCardRequest sqlCardRequest = new TblCardRequest();
TblCompany sqlCompany = new TblCompany();
sqlCompany.MainConnectionProvider = connProvider;
sqlCardRequest.MainConnectionProvider = connProvider;
sqlCompany.IncOne();
sqlMember.StrMembershipID = pos.StrMembershipID;
DataTable memberTable = sqlMember.SelectOne();
newStrMembershipID = "NMC" + sqlCompany.NNonMembershipNo.Value.ToString();
string origStrMembershipID = sqlMember.StrMembershipID.Value;
pos.StrNewMembershipID = newStrMembershipID;
memberTable.Rows[0]["nMembershipNo"] = sqlCompany.NNonMembershipNo.Value;
memberTable.Rows[0]["strMembershipID"] = newStrMembershipID;
memberTable.Rows[0]["nCardStatusID"] = (int)CardStatusType.RequestPrint;
string cmdText = "Update tblMember SET strMembershipID = @NewStrMembershipID, " +
" nMembershipNo = @nMembershipNo Where strMembershipID = @OriginalStrMembershipID";
sqlMember.UpdateKey(memberTable, cmdText, "@NewStrMembershipID", newStrMembershipID,
"@OriginalStrMembershipID", origStrMembershipID, new string[] {"@nMembershipNo"},
new object[] {sqlCompany.NNonMembershipNo.Value});
#region ====== Added By Albert ======
//To update member packages after changing MembershipID.
TblMemberPackage mMemberPackage;
mMemberPackage = new TblMemberPackage();
mMemberPackage.StrMembershipIDOld = origStrMembershipID;
mMemberPackage.StrMembershipID = newStrMembershipID;
mMemberPackage.UpdateAllWstrMembershipIDLogic();
TblMemberCreditPackage mMemberCreditPackage;
mMemberCreditPackage = new TblMemberCreditPackage();
mMemberCreditPackage.StrMembershipIDOld = origStrMembershipID;
mMemberCreditPackage.StrMembershipID = newStrMembershipID;
mMemberCreditPackage.UpdateAllWstrMembershipIDLogic();
#endregion
//Request print for new non member
sqlCardRequest.NEmployeeID = pos.NCashierID;
sqlCardRequest.NStatusID = (int)CardStatusType.RequestPrint;
sqlCardRequest.StrBranchCode = pos.StrBranchCode;
sqlCardRequest.StrMembershipID = "NMC" +sqlCompany.NNonMembershipNo;
sqlCardRequest.DtLastEditDate = DateTime.Now;
sqlCardRequest.Insert();
}
else
{
TblCardRequest sqlCardRequest = new TblCardRequest();
TblBranch sqlBranch = new TblBranch();
sqlBranch.MainConnectionProvider = connProvider;
sqlCardRequest.MainConnectionProvider = connProvider;
sqlBranch.StrBranchCode = pos.StrBranchCode;
sqlBranch.IncOne();
sqlMember.StrMembershipID = pos.StrMembershipID;
DataTable memberTable = sqlMember.SelectOne();
newStrMembershipID = pos.StrBranchCode.TrimEnd() + ACMS.Convert.ToInt32(sqlBranch.NMembershipNo);
string origStrMembershipID = sqlMember.StrMembershipID.Value;
pos.StrNewMembershipID = newStrMembershipID;
memberTable.Rows[0]["nMembershipNo"] = ACMS.Convert.ToInt32(sqlBranch.NMembershipNo);
memberTable.Rows[0]["strMembershipID"] = newStrMembershipID;
memberTable.Rows[0]["nCardStatusID"] = (int)CardStatusType.RequestPrint;
string cmdText = "Update tblMember SET strMembershipID = @NewStrMembershipID, " +
" nMembershipNo = @nMembershipNo Where strMembershipID = @OriginalStrMembershipID";
sqlMember.UpdateKey(memberTable, cmdText, "@NewStrMembershipID", newStrMembershipID,
"@OriginalStrMembershipID", origStrMembershipID, new string[] {"@nMembershipNo"},
new object[] {ACMS.Convert.ToInt32(sqlBranch.NMembershipNo)});
#region ====== Added By Albert ======
//To update member packages after changing MembershipID.
TblMemberPackage mMemberPackage;
mMemberPackage = new TblMemberPackage();
mMemberPackage.StrMembershipIDOld = origStrMembershipID;
mMemberPackage.StrMembershipID = newStrMembershipID;
mMemberPackage.UpdateAllWstrMembershipIDLogic();
TblMemberCreditPackage mMemberCreditPackage;
mMemberCreditPackage = new TblMemberCreditPackage();
mMemberCreditPackage.StrMembershipIDOld = origStrMembershipID;
mMemberCreditPackage.StrMembershipID = newStrMembershipID;
mMemberCreditPackage.UpdateAllWstrMembershipIDLogic();
#endregion
//Request print for new non member
sqlCardRequest.NEmployeeID = pos.NCashierID;
sqlCardRequest.NStatusID = (int)CardStatusType.RequestPrint;
sqlCardRequest.StrBranchCode = pos.StrBranchCode;
sqlCardRequest.StrMembershipID = newStrMembershipID;
sqlCardRequest.DtLastEditDate = DateTime.Now;
sqlCardRequest.Insert();
}
if (introduceMemberTable != null && introduceMemberTable.Rows.Count > 0)
{
foreach (DataRow r in introduceMemberTable.Rows)
r["StrIntroducerMembershipID"] = newStrMembershipID;
sqlIntroduceMember.SaveData(introduceMemberTable);
}
TblAudit sqlAudit = new TblAudit();
sqlAudit.MainConnectionProvider = connProvider;
//Audit trail for request print
sqlAudit.NAuditTypeID = ACMSLogic.AuditTypeID.MemberCard;
sqlAudit.NEmployeeID = pos.NCashierID;
sqlAudit.StrAuditEntry = "Replace member card with new ID";
sqlAudit.StrReference = newStrMembershipID;
sqlAudit.DtDate = DateTime.Now;
sqlAudit.Insert();
}
}
private void InitTblReceipt()
{
DataColumn colDiscountAmt = new DataColumn("DiscountAmt", typeof(decimal));
DataColumn colCodeStatus= new DataColumn("CodeStatus", typeof(int));
DataColumn colMemberName = new DataColumn("strMemberName", typeof(string));
DataColumn colTherapistName = new DataColumn("strTherapistName", typeof(string));
DataColumn colSalesPersonName = new DataColumn("strSalesPersonName", typeof(string));
myReceiptMasterTable.Columns.Add(colMemberName);
myReceiptMasterTable.Columns.Add(colDiscountAmt);
myReceiptMasterTable.Columns.Add(colCodeStatus);// this is use to determine what kind of code store in strCode
myReceiptMasterTable.Columns.Add(colTherapistName);
myReceiptMasterTable.Columns.Add(colSalesPersonName);
TblMember member = new TblMember();
member.StrMembershipID = myMembershipID;
member.SelectOne();
DataRow r = myReceiptMasterTable.NewRow();
r["strReceiptNo"] = GenerateAutoID();
r["strMembershipID"] = myMembershipID;
r["strBranchCode"] = myBranchCode;
r["nCategoryID"] = myCategoryID;
/*
if (myGIROID == 1)
{
TblReceipt receipt = new TblReceipt();
Decimal mTotalOutstanding = 0;
object obj = receipt.GetConvertFitnessGirotoGiroFitness(myMembershipID);
if (obj != null)
{
mTotalOutstanding = (int)obj;
}
if (mTotalOutstanding > 0)
{
r["nCategoryID"] = 35;//GIRO Fitness Jackie 11/10/2012
}
else
{
r["nCategoryID"] = 2;//GIRO Fitness Jackie 11/10/2012
}
}
else
{
r["nCategoryID"] = myCategoryID;
}*/
r["dtDate"] = DateTime.Now.Date;
r["nCashierID"] = myEmployeeID;
r["nShiftID"] = myShiftID;
r["nTerminalID"] = myTerminalID;
r["nTaxID"] = myTaxID;
r["strMemberName"] = member.StrMemberName.IsNull ? "" : member.StrMemberName.Value;
r["fVoid"] = 0;
r["strLocation"] = myLocation;
// r["nPackageID"] = myPackageID;
r["dtDateTime"] = DateTime.Now;
myReceiptMasterTable.Rows.Add(r);
}
//DEREK Instalment Plan Need to Update Receipt Here
public void PrintReceipt(string receiptNo)
{
DataColumn colItemDiscountAmt = new DataColumn("DiscountAmt", typeof(decimal));
DataColumn colBillDiscountAmt = new DataColumn("DiscountAmt", typeof(decimal));
DataColumn colMemberName = new DataColumn("strMemberName", typeof(string));
DataColumn colRewardPoint = new DataColumn("RewardPoint", typeof(decimal));
DataColumn colGSTPaid = new DataColumn("GSTPaid", typeof(decimal));
//DataColumn colOSAmt = new DataColumn("mOutstandingAmount", typeof(decimal));
TblReceipt receipt = new TblReceipt();
receipt.StrReceiptNo = receiptNo;
DataTable tableReceipt = receipt.SelectOne();
tableReceipt.TableName = "TblReceipt";
tableReceipt.Columns.Add(colBillDiscountAmt);
tableReceipt.Columns.Add(colMemberName);
tableReceipt.Columns.Add(colRewardPoint);
tableReceipt.Columns.Add(colGSTPaid);
// tableReceipt.Columns.Add(colOSAmt);
TblMember sqlMember = new TblMember();
sqlMember.StrMembershipID = receipt.StrMembershipID;
sqlMember.SelectOne();
tableReceipt.Rows[0]["strMemberName"] = sqlMember.StrMemberName.IsNull ? "" : sqlMember.StrMemberName.Value.ToUpper();
TblBranch sqlBranch = new TblBranch();
sqlBranch.StrBranchCode = receipt.StrBranchCode == SqlString.Null ? "" : receipt.StrBranchCode.Value;
DataTable branchTable = sqlBranch.SelectOne();
TblRewardsTransaction sqlRewTrans = new TblRewardsTransaction();
decimal rewardpoint = sqlRewTrans.GetMemberLoyaltyPoint(receipt.StrMembershipID.Value);
tableReceipt.Rows[0]["RewardPoint"] = System.Math.Round(rewardpoint);
TblReceiptEntries receiptEntries = new TblReceiptEntries();
receiptEntries.StrReceiptNo = receiptNo;
DataTable tableReceiptEntries = receiptEntries.SelectAllWstrReceiptNoLogic();
tableReceiptEntries.TableName = "TblReceiptEntries";
tableReceiptEntries.Columns.Add(colItemDiscountAmt);
TblReceiptFreebie freebie = new TblReceiptFreebie();
freebie.StrReceiptNo = receiptNo;
DataTable tableReceiptFreebie = freebie.SelectReceiptFreebie();
tableReceiptFreebie.TableName = "TblReceiptFreebie";
TblMemberPackage FreePackage = new TblMemberPackage();
FreePackage.StrReceiptNo = receiptNo;
DataTable tableFreePackage = FreePackage.GetFreePackage(receiptNo);
tableFreePackage.TableName = "TblFreePackage";
TblMemberPackage ConvertedPackage = new TblMemberPackage();
ConvertedPackage.StrReceiptNo = receiptNo;
DataTable tableConvertedPackage = ConvertedPackage.GetConvertedPackage(receiptNo);
tableConvertedPackage.TableName = "TblConvertedPackage";
TblPaymentPlan myPaymentPlan = new TblPaymentPlan();
DataTable tablePaymentPlan = myPaymentPlan.GetInhouseIPPOSByReceiptNo(receiptNo);
tablePaymentPlan.TableName = "TblPaymentPlan";
DataTable tableDeposit = myPaymentPlan.GetInhouseIPPReceiptDeposit(receiptNo);
tableDeposit.TableName = "TblReceiptDeposit";
// TblProduct Product = new TblProduct();
// // Product.StrProductCode = tableReceiptFreebie.Rows[0]["strItemCode"].ToString();
// DataTable tableProduct = Product.SelectAll();
// tableProduct.TableName = "TblProductName";
decimal nettAmountB4Discount = 0;
decimal discoutnAmt =0;
decimal depositAmt = 0;
if (tableDeposit.Rows.Count > 0)
{
depositAmt = Convert.ToDecimal(tableDeposit.Rows[0]["TotalDeposit"]);
}
foreach (DataRow r in tableReceiptEntries.Rows)
{
int qty = ACMS.Convert.ToInt32(r["nQuantity"]);
decimal unitPrice = ACMS.Convert.ToDecimal(r["mUnitPrice"]);
decimal currSubtotal = ACMS.Convert.ToDecimal(r["mSubTotal"]);
discoutnAmt = (unitPrice * qty) - currSubtotal;
r["DiscountAmt"] = decimal.Round(discoutnAmt, 2);
nettAmountB4Discount += currSubtotal;
}
//Sub Total
DataColumn colSubTotal = new DataColumn("mSubTotal", typeof(decimal));
tableReceipt.Columns.Add(colSubTotal);
tableReceipt.Rows[0]["mSubTotal"] = nettAmountB4Discount;
decimal nettAmountAfterDiscount = ACMS.Convert.ToDecimal(tableReceipt.Rows[0]["mNettAmount"]);
if (tableReceipt.Rows[0]["strDiscountCode"].ToString().Length > 0 &&
tableReceipt.Rows[0]["strDiscountCode"] != DBNull.Value)
{
tableReceipt.Rows[0]["DiscountAmt"] = nettAmountB4Discount - (nettAmountAfterDiscount + depositAmt);
}
TblReceiptPayment receiptPayment = new TblReceiptPayment();
receiptPayment.StrReceiptNo = receiptNo;
DataTable tableReceiptPayment = receiptPayment.SelectAllWstrReceiptNoLogic();
tableReceiptPayment.TableName = "TblReceiptPayment";
TblCompany comp = new TblCompany();
DataTable compTable = comp.SelectAll();
int myTaxID = ACMS.Convert.ToInt32(compTable.Rows[0]["NTaxID"]);
TblTax tax = new TblTax();
tax.NTaxID = myTaxID;
tax.SelectOne();
decimal myGSTRate = tax.DTaxRate.IsNull ? 0 : (decimal)tax.DTaxRate.Value;
decimal GSTAmtPaid=0;
decimal GSTRate1=myGSTRate;//0.05M;
decimal GSTRate2=myGSTRate+1;// 1.05M;
foreach (DataRow p in tableReceiptPayment.Rows)
{
GSTAmtPaid=GSTAmtPaid+ACMS.Convert.ToDecimal(p[3])* GSTRate1 /GSTRate2;
}
if (receipt.NCategoryID.ToString() != "38")
{
tableReceipt.Rows[0]["GSTPaid"] = decimal.Round(GSTAmtPaid, 2);
}
else
{
tableReceipt.Rows[0]["GSTPaid"] = decimal.Round(0, 2);
}
DataSet newDS = new DataSet("Receipt");
newDS.Tables.Add(tableReceipt);
newDS.Tables.Add(tableReceiptEntries);
newDS.Tables.Add(tableReceiptPayment);
newDS.Tables.Add(branchTable);
// newDS.Tables.Add(tableProduct);
newDS.Tables.Add(tableReceiptFreebie);
newDS.Tables.Add(tableFreePackage);
newDS.Tables.Add(tableConvertedPackage);
newDS.Tables.Add(tablePaymentPlan);
newDS.Tables.Add(tableDeposit);
DataRelation relation1 = new DataRelation("Receipt_ReceiptEntries_Relation", newDS.Tables["TblReceipt"].Columns["strReceiptNo"],
newDS.Tables["TblReceiptEntries"].Columns["strReceiptNo"], false);
DataRelation relation2 = new DataRelation("Receipt_ReceiptPayment_Relation", newDS.Tables["TblReceipt"].Columns["strReceiptNo"],
newDS.Tables["TblReceiptPayment"].Columns["strReceiptNo"], false);
DataRelation relation3 = new DataRelation("Receipt_ReceiptFreebie_Relation", newDS.Tables["TblReceipt"].Columns["strReceiptNo"],
newDS.Tables["TblReceiptFreebie"].Columns["strReceiptNo"], false);
DataRelation relation4 = new DataRelation("Receipt_FreePackage_Relation", newDS.Tables["TblReceipt"].Columns["strReceiptNo"],
newDS.Tables["TblFreePackage"].Columns["strReceiptNo"], false);
DataRelation relation5 = new DataRelation("Receipt_ConvertedPackage_Relation", newDS.Tables["TblReceipt"].Columns["strReceiptNo"],
newDS.Tables["TblConvertedPackage"].Columns["strReceiptNo"], false);
DataRelation relation6 = new DataRelation("Receipt_PaymentPlan_Relation", newDS.Tables["TblReceipt"].Columns["strReceiptNo"],
newDS.Tables["TblPaymentPlan"].Columns["strReceiptNo"], false);
DataRelation relation7 = new DataRelation("Receipt_Deposit_Relation", newDS.Tables["TblReceipt"].Columns["strReceiptNo"],
newDS.Tables["TblReceiptDeposit"].Columns["strReceiptNo"], false);
newDS.Relations.Add(relation1);
newDS.Relations.Add(relation2);
newDS.Relations.Add(relation3);
newDS.Relations.Add(relation4);
newDS.Relations.Add(relation5);
newDS.Relations.Add(relation6);
newDS.Relations.Add(relation7);
//display GST %
DataColumn colGstTax = new DataColumn("GstTax", typeof(int));
tableReceipt.Columns.Add(colGstTax);
tableReceipt.Rows[0]["GstTax"] = myGSTRate * 100;
ACMSLogic.Report.Receipt receiptReport = new ACMSLogic.Report.Receipt();
receiptReport.DataSource = newDS;
// if (ACMS.Convert.ToDecimal(tableReceipt.Rows[0]["DiscountAmt"])==0)
// {
// receiptReport.HideFields(false);
// }
// else
// {
// receiptReport.HideFields(true);
// }
// receiptReport.ShowDesignerDialog();
receiptReport.Print();
}
private void sbtnIntroduce_Click(object sender, System.EventArgs e)
{
//0506
if ((lkpEdtLoyalPoint.EditValue != null || lkFreebie.EditValue != null || lkTreatment.EditValue != null) && ucMemberID1.EditValue.ToString().Length != 0)
{
if (string.Compare(strMembershipID.Trim(), ucMemberID1.EditValue.ToString().Trim(), true) == 0)
{
UI.ShowErrorMessage(this, "Member introduce him/herself is not allow.");
ucMemberID1.Focus();
DialogResult = DialogResult.None;
return;
}
TblMember sqlMember = new TblMember();
sqlMember.StrMembershipID = ucMemberID1.EditValue.ToString();
DataTable memberTable = sqlMember.SelectOne();
if (memberTable.Rows.Count > 0)
{
if (string.Compare(memberTable.Rows[0]["strIntroducerMembershipID"].ToString().Trim(), strMembershipID.Trim(), true)==0)
{
UI.ShowErrorMessage(this, "Introducer selected was introduced by this member.");
ucMemberID1.Focus();
DialogResult = DialogResult.None;
return;
}
}
string PointType =lkpEdtLoyalPoint.Text;
double point = 0.0;
string promoteFreebie = "";
if (lkpEdtLoyalPoint.EditValue != null)
{
point = System.Convert.ToDouble(lkpEdtLoyalPoint.EditValue);
}
else if (lkFreebie.EditValue != null)
{
promoteFreebie = lkFreebie.EditValue.ToString();
}
else if (lkTreatment.EditValue != null)
{
promoteFreebie = lkTreatment.EditValue.ToString();
}
string introducerID = ucMemberID1.EditValue.ToString();
if (point>0)
{
if (myMemberRecord.SaveIntroduceFriend(strMembershipID, introducerID, point, employeeID))
{
this.DialogResult = DialogResult.OK;
PrintIntroReceipt(strMembershipID,introducerID,point,PointType);
}
}//0506
else if (lkTreatment.EditValue != null)
{
bool success = false;
//success = myMemberRecord.SaveIntroduceFriendNew(strMembershipID, introducerID, "BM004(58)", "INTRO " + introducerID, employeeID, 0);
//Amended by TBBC on 22 September 2015 for Intro friend package.
//success = myMemberRecord.SaveIntroduceFriendNew( introducerID,strMembershipID, "BM004(58)", "INTRO " + strMembershipID, employeeID, 0);
success = myMemberRecord.SaveIntroduceFriend(strMembershipID, introducerID, 0, employeeID);
success = myMemberRecord.SaveIntroduceFriendforPackage(strMembershipID, introducerID, lkTreatment.EditValue.ToString(), employeeID);
if (success)
{
this.DialogResult = DialogResult.OK;
//PrintIntroReceipt(strMembershipID, introducerID, PrintIntroReceiptServices);
PrintIntroReceiptServices(strMembershipID, introducerID, lkTreatment.Text);
}
}
else if (promoteFreebie != "")
{
DataTable IntroFriendFreebie = myMemberRecord.SaveIntroduceFriend(strMembershipID, introducerID, promoteFreebie, User.BranchCode,employeeID);
if (IntroFriendFreebie.Rows.Count > 0)
{
this.DialogResult = DialogResult.OK;
PrintIntroReceipt(strMembershipID,introducerID,IntroFriendFreebie);
}
}
}
else
{
ACMS.Utils.UI.ShowErrorMessage(this, "Please fill in all field.", "Error");
lkpEdtLoyalPoint.Focus();
DialogResult = DialogResult.None;
}
}
private void OnConfirmLockerDeposit()
{
ACMSDAL.TblBranch branch = new ACMSDAL.TblBranch();
branch.StrBranchCode = myPOS.StrBranchCode;
branch.SelectOne();
decimal lockerDeposit = ACMS.Convert.ToDecimal(branch.MLockerDepositRate);
ACMSDAL.TblMember member = new ACMSDAL.TblMember();
member.StrMembershipID = myPOS.StrMembershipID;
member.SelectOne();
if (myPOS.ReceiptItemsTable.Rows.Count == 0)
{
ACMSDAL.TblLocker sqlLocker = new ACMSDAL.TblLocker();
DataTable table = sqlLocker.GetOccupiedLocker(myPOS.StrBranchCode, myPOS.StrMembershipID);
if (table.Rows.Count > 0)
{
MessageBox.Show(this, "Please return your locker before a new Deposit can make.");
return;
}
if (!member.FLockerDeposit.IsNull)
{
if (member.FLockerDeposit.IsTrue)
MessageBox.Show(this, "Deposit has been saved in system.");
else
{
DialogResult result = MessageBox.Show(this, string.Format("Locker Deposit is $ {0}, Continue?", lockerDeposit), "Add Deposit", MessageBoxButtons.OKCancel);
if (result == DialogResult.OK)
myPOS.NewReceiptEntry(myPOS.StrMembershipID, -1, "Locker Deposit", 1, lockerDeposit, myPOS.StrMembershipID);
}
}
else
{
DialogResult result = MessageBox.Show(this, string.Format("Locker Deposit is $ {0}, Continue?", lockerDeposit), "Add Deposit", MessageBoxButtons.OKCancel);
if (result == DialogResult.OK)
myPOS.NewReceiptEntry(myPOS.StrMembershipID, -1, "Locker Deposit", 1, lockerDeposit, myPOS.StrMembershipID);
}
}
else
{
MessageBox.Show(this, "Only one deposit is allow in one receipt.");
}
}
public FormPOS2(string strMembershipID,
string strBranchCode, int nTerminalID, int nEmployeeID, int nShiftID, string strLocation)
{
//
// Required for Windows Form Designer support
//
InitializeComponent();
//
// TODO: Add any constructor code after InitializeComponent call
//
//groupControl5.Left = 10;
Command = ACMSLogic.POSCommand.Create();
myNEmployeeID = nEmployeeID;
myNShiftID = nShiftID;
myNTerminalID = nTerminalID;
myStrBranchCode = strBranchCode;
myStrMembershipID = strMembershipID;
lblMembershipID.Text = myStrMembershipID;//1503
lblLocation.Text = strLocation;
myStrLocation = strLocation;
connectionString = (string)ConfigurationSettings.AppSettings["Main.ConnectionString"];
connection = new SqlConnection(connectionString);
TblMember member = new TblMember();
member.StrMembershipID = myStrMembershipID;
member.SelectOne();
lblMemberName.Text = member.StrMemberName.IsNull ? "" : member.StrMemberName.Value;
}
private void ActionTakeWhenVoidReceiptForCategory_15(string strReceiptNo, ConnectionProvider connProvider)
{
TblLocker locker = new TblLocker();
TblMember member = new TblMember();
DataTable table = locker.SelectAllWstrReceiptNo(strReceiptNo);
if (table != null && table.Rows.Count > 0)
{
member.MainConnectionProvider = connProvider;
foreach (DataRow r in table.Rows)
{
r["nStatusID"] = "0";
r["strReceiptNo"] = DBNull.Value;
r["dtExpiry"] = DBNull.Value;
r["strRemarks"] = DBNull.Value;
string memberID = r["strMembershipID"].ToString();
r["strMembershipID"] = DBNull.Value;
member.StrMembershipID = memberID;
member.SelectOne();
member.FLockerDeposit = System.Data.SqlTypes.SqlBoolean.True;
member.Update();
}
locker.MainConnectionProvider = connProvider;
locker.SaveData(table);
}
}
/// <summary>
/// Method use to validate at beginning of Introduce friend.
/// </summary>
/// <returns></returns>
public string IntroduceFriendValidation(string strMembershipID, bool hasIntroRight)
{
TblMember sqlMember = new TblMember();
sqlMember.StrMembershipID = strMembershipID;
DataTable myTable = sqlMember.SelectOne();
sqlMember.Dispose();
if (ACMS.Convert.ToDateTime(myTable.Rows[0]["dtSignupDate"]).Date !=
DateTime.Now.Date)
{
if (!hasIntroRight)
return "This member is not signup today. Therefore, can't introduce by anyone.";
}
if (myTable.Rows[0]["strIntroducerMembershipID"] != DBNull.Value)
{
return "This member already been introduced.";
}
return "";
}