private void ActionTakeWhenVoidReceiptForCategory_7(string strReceiptNo, ConnectionProvider connProvider)
{
TblMemberCreditPackage memberCreditPackage = new TblMemberCreditPackage();
memberCreditPackage.MainConnectionProvider = connProvider;
DataTable table = memberCreditPackage.SelectAllWstrReceiptNo(strReceiptNo);
TblMemberPackage sqlMemberPackage = new TblMemberPackage();
sqlMemberPackage.MainConnectionProvider = connProvider;
if (table.Rows.Count > 0)
{
int nCreditPackageID = 0;
foreach (DataRow r in table.Rows)
{
nCreditPackageID = ACMS.Convert.ToInt32(r["nCreditPackageID"]);
sqlMemberPackage.NCreditPackageID = nCreditPackageID;
DataTable memberPackagetable = sqlMemberPackage.SelectAllWnCreditPackageIDLogic();
if (Convert.ToInt32(memberPackagetable.Compute("COUNT(nStatusID)", "nStatusID=0 OR nStatusID=1")) > 0)
throw new Exception("The item(s) has been used, you are not allow to void the receipt");
r["nEmployeeID"] = User.EmployeeID;
r["nStatusID"] = 2;
r["strRemarks"] = "Voided Receipt";
r["dtLastEditDate"] = System.DateTime.Now;
}
memberCreditPackage.SaveData(table);
}
sqlMemberPackage.StrReceiptNo = strReceiptNo;
DataTable tblMemPackage = sqlMemberPackage.SelectAllWstrReceiptNo(strReceiptNo);
TblClassAttendance sqlClassAttendance = new TblClassAttendance();
TblServiceSession sqlServiceSession = new TblServiceSession();
sqlClassAttendance.MainConnectionProvider = connProvider;
sqlServiceSession.MainConnectionProvider = connProvider;
if (tblMemPackage.Rows.Count > 0)
{
int nPackageID = 0;
foreach (DataRow row in tblMemPackage.Rows)
{
nPackageID = ACMS.Convert.ToInt32(row["nPackageID"]);
sqlClassAttendance.NPackageID = nPackageID;
DataTable classAttTable = sqlClassAttendance.SelectAllWnPackageIDLogic();
if (classAttTable.Rows.Count > 0)
throw new Exception("The item(s) has been used, you are not allow to void the receipt");
else
{
sqlServiceSession.NPackageID = nPackageID;
classAttTable = sqlServiceSession.SelectAllWnPackageIDLogic();
if (classAttTable.Rows.Count > 0)
throw new Exception("The item(s) has been used, you are not allow to void the receipt");
}
row["nEmployeeID"] = User.EmployeeID;
row["nStatusID"] = 2;
row["strRemarks"] = "Voided Receipt";
row["dtLastEdit"] = System.DateTime.Now;
}
sqlMemberPackage.SaveData(tblMemPackage);
}
}
private void ActionTakeWhenVoidReceiptForCategory_1_3_4_5_6_8_9_14_23(string strReceiptNo,
ConnectionProvider connProvider)
{
//1 Fitness Package
//3 PT Package
//4 Spa Single Treatment
//5 Spa Package
//6 IPL Package
//8 Fitness Combined Package
//9 Spa Combined Package
TblMemberPackage memberPackage = new TblMemberPackage();
memberPackage.MainConnectionProvider = connProvider;
memberPackage.StrReceiptNo = strReceiptNo;
DataTable table = memberPackage.SelectAllWstrReceiptNo(strReceiptNo);
TblClassAttendance sqlClassAttendance = new TblClassAttendance();
TblServiceSession sqlServiceSession = new TblServiceSession();
sqlClassAttendance.MainConnectionProvider = connProvider;
sqlServiceSession.MainConnectionProvider = connProvider;
if (table.Rows.Count > 0)
{
int nPackageID = 0;
foreach (DataRow r in table.Rows)
{
nPackageID = ACMS.Convert.ToInt32(r["nPackageID"]);
sqlClassAttendance.NPackageID = nPackageID;
DataTable classAttTable = sqlClassAttendance.SelectAllWnPackageIDLogic();
if (classAttTable.Rows.Count > 0)
throw new Exception("The item(s) has been used, you are not allow to void the receipt");
else
{
sqlServiceSession.NPackageID = nPackageID;
classAttTable = sqlServiceSession.SelectAllWnPackageIDLogic();
if (classAttTable.Rows.Count > 0)
throw new Exception("The item(s) has been used, you are not allow to void the receipt");
}
r["nEmployeeID"] = User.EmployeeID;
r["nStatusID"] = 2;
r["strRemarks"] = "Voided Receipt";
r["dtLastEdit"] = System.DateTime.Now;
}
memberPackage.SaveData(table);
}
TblMemberCreditPackage memberCreditPackage = new TblMemberCreditPackage();
memberCreditPackage.MainConnectionProvider = connProvider;
memberCreditPackage.StrReceiptNo = strReceiptNo;
DataTable table2 = memberCreditPackage.SelectAllWstrReceiptNo(strReceiptNo);
TblMemberPackage sqlMemberPackage = new TblMemberPackage();
sqlMemberPackage.MainConnectionProvider = connProvider;
if (table2.Rows.Count > 0)
{
int nCreditPackageID = 0;
foreach (DataRow r in table2.Rows)
{
nCreditPackageID = ACMS.Convert.ToInt32(r["nCreditPackageID"]);
DataTable mpTable = sqlMemberPackage.SelectAllWnCreditPackageIDLogic();
if (mpTable.Rows.Count > 0)
throw new Exception("The item(s) has been used, you are not allow to void the receipt");
r["nEmployeeID"] = User.EmployeeID;
r["nStatusID"] = 2;
r["strRemarks"] = "Voided Receipt";
r["dtLastEditDate"] = System.DateTime.Now;
}
memberCreditPackage.SaveData(table2);
}
}