private void UpdateRegistrationFee(ACMSDAL.ConnectionProvider connProvider, ACMSLogic.POS pos)
{
if (pos.ReceiptItemsTable.Select("strCode = 'Reg'", "", DataViewRowState.CurrentRows).Length == 1)
{
TblMember member = new TblMember();
member.MainConnectionProvider = connProvider;
TblMemberPackage mp = new TblMemberPackage();
DataTable table = member.LoadData("Select * from tblMember Where strMembershipID = @strMembershipID",
new string[] {"@strMembershipID"}, new object[]{pos.StrMembershipID});
table.Rows[0]["fRegistrationFee"] = 1;
member.SaveData(table);
}
}
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();
}
}