public void RecalculateAll()
{
decimal nettAmount = 0;
decimal subtotal = 0;
decimal nettAmountwGST = 0;
Boolean isAllPricesWithGST = true;
Boolean isAllPricesNoGST = false;
//To check all items are with GST price or not, also cannot contain any discount
foreach (DataRow r in myReceiptItemsTable.Rows)
{
if (myCategoryID == 7 || myCategoryID == 36 || myCategoryID == 37)
{
TblCreditPackage pkg = new TblCreditPackage();
pkg.StrCreditPackageCode = r["strCode"].ToString();
pkg.SelectOne();
if (pkg.MListPriceWGST.IsNull || ACMS.Convert.ToDecimal(pkg.MListPriceWGST) == 0 || r["strDiscountCode"].ToString() != "" || myReceiptMasterTable.Rows[0]["strDiscountCode"].ToString() != "")
{
isAllPricesWithGST = false;
break;
}
pkg.Dispose();
}
if (myCategoryID == 38)
{
isAllPricesWithGST = false;
isAllPricesNoGST = true;
break;
}
else
{
if (myCategoryID == 8 || myCategoryID == 9)
{
TblPackageGroup pkg = new TblPackageGroup();
pkg.StrPackageGroupCode = r["strCode"].ToString();
pkg.SelectOne();
if (pkg.MListPriceWGST.IsNull || ACMS.Convert.ToDecimal(pkg.MListPriceWGST) == 0 || r["strDiscountCode"].ToString() != "" || myReceiptMasterTable.Rows[0]["strDiscountCode"].ToString() != "")
{
isAllPricesWithGST = false;
break;
}
pkg.Dispose();
}
else
{
TblPackage pkg = new TblPackage();
pkg.StrPackageCode = r["strCode"].ToString();
pkg.SelectOne();
if (pkg.MListPriceWGST.IsNull || ACMS.Convert.ToDecimal(pkg.MListPriceWGST) == 0 || r["strDiscountCode"].ToString() != "" || myReceiptMasterTable.Rows[0]["strDiscountCode"].ToString() != "")
{
isAllPricesWithGST = false;
break;
}
pkg.Dispose();
}
}
}
foreach (DataRow r in myReceiptItemsTable.Rows)
{
if ((myCategoryID == 7 || myCategoryID == 36 || myCategoryID == 37) && isAllPricesWithGST)
{
TblCreditPackage pkg = new TblCreditPackage();
pkg.StrCreditPackageCode = r["strCode"].ToString();
pkg.SelectOne();
if (pkg.MListPriceWGST.IsNull == false && ACMS.Convert.ToDecimal(pkg.MListPriceWGST) != 0)
{
subtotal = ACMS.Convert.ToDecimal(r["nQuantity"]) * ACMS.Convert.ToDecimal(pkg.MListPriceWGST);
nettAmountwGST += subtotal;
}
pkg.Dispose();
}
else
{
if ((myCategoryID == 8 || myCategoryID == 9) && isAllPricesWithGST)
{
TblPackageGroup pkg = new TblPackageGroup();
pkg.StrPackageGroupCode = r["strCode"].ToString();
pkg.SelectOne();
if (pkg.MListPriceWGST.IsNull == false && ACMS.Convert.ToDecimal(pkg.MListPriceWGST) != 0)
{
subtotal = ACMS.Convert.ToDecimal(r["nQuantity"]) * ACMS.Convert.ToDecimal(pkg.MListPriceWGST);
nettAmountwGST += subtotal;
}
pkg.Dispose();
}
else if (isAllPricesWithGST)
{
TblPackage pkg = new TblPackage();
pkg.StrPackageCode = r["strCode"].ToString();
pkg.SelectOne();
if (pkg.MListPriceWGST.IsNull == false && ACMS.Convert.ToDecimal(pkg.MListPriceWGST) != 0)
{
subtotal = ACMS.Convert.ToDecimal(r["nQuantity"]) * ACMS.Convert.ToDecimal(pkg.MListPriceWGST);
nettAmountwGST += subtotal;
}
pkg.Dispose();
}
}
subtotal = ACMS.Convert.ToDecimal(r["mSubTotal"]);
nettAmount += subtotal;
}
if (myCategoryID == 11 || myCategoryID == 12)
{
if (nettAmount < 0)
nettAmount = 0;
}
myReceiptMasterTable.Rows[0]["mNettAmount"] = nettAmount;
if (StrDiscountCode.HasValue && StrDiscountCode.ToString().Length > 0)
{
TblPromotion promotion = new TblPromotion();
promotion.StrPromotionCode = myReceiptMasterTable.Rows[0]["strDiscountCode"].ToString();
promotion.SelectOne();
decimal discountValue = (decimal)(promotion.DDiscountValue.IsNull ? 0 : promotion.DDiscountValue.Value);
decimal discountPercent = (decimal)(promotion.DDiscountPercent.IsNull ? 0 : promotion.DDiscountPercent.Value);
decimal discountAmt = 0;
if (discountPercent > 0 && discountValue <= 0)
{
discountAmt = decimal.Round((MNettAmount * discountPercent / 100), 2);
}
else
{
discountAmt = discountValue;
}
if (discountAmt > ACMS.Convert.ToDecimal(myReceiptMasterTable.Rows[0]["mNettAmount"]))
discountAmt = ACMS.Convert.ToDecimal(myReceiptMasterTable.Rows[0]["mNettAmount"]);
myReceiptMasterTable.Rows[0]["DiscountAmt"] = discountAmt;
myReceiptMasterTable.Rows[0]["mNettAmount"] = ACMS.Convert.ToDecimal(myReceiptMasterTable.Rows[0]["mNettAmount"]) - discountAmt;
}
if (StrDeposit.ToString() != "")
{
isAllPricesWithGST = false;
TblMemberPackage myPackage = new TblMemberPackage();
myPackage.StrReceiptNo = StrDeposit;
DataTable tblMemberPkg = myPackage.SelectOneReceipt();
DataTable tblConverted = new DataTable();
DataTable tblCreditConverted = new DataTable();
if (tblMemberPkg.Rows.Count > 0)
tblConverted = myPackage.SelectConvertedPackageID(System.Convert.ToInt32(tblMemberPkg.Rows[0]["nPackageID"]));
TblMemberCreditPackage myCreditPackage = new TblMemberCreditPackage();
myCreditPackage.StrReceiptNo = StrDeposit;
tblCreditConverted = myCreditPackage.SelectAllWstrReceiptNoLogic();
if (tblCreditConverted.Rows.Count > 0)
tblConverted = myPackage.SelectConvertedPackageID(System.Convert.ToInt32(tblCreditConverted.Rows[0]["nCreditPackageID"]));
if (tblConverted.Rows.Count > 0)
{
decimal DepositAmount = System.Convert.ToDecimal(tblConverted.Rows[0]["mConverted"]);
myReceiptMasterTable.Rows[0]["mNettAmount"] = ACMS.Convert.ToDecimal(myReceiptMasterTable.Rows[0]["mNettAmount"]) - DepositAmount;
myReceiptMasterTable.Rows[0]["strRemarks"] = "Deposit from Convert";
}
//else if (tblCreditConverted.Rows.Count > 0)
//{
// decimal DepositAmount = System.Convert.ToDecimal(tblCreditConverted.Rows[0]["mConverted"]);
// myReceiptMasterTable.Rows[0]["mNettAmount"] = ACMS.Convert.ToDecimal(myReceiptMasterTable.Rows[0]["mNettAmount"]) - DepositAmount;
// myReceiptMasterTable.Rows[0]["strRemarks"] = "Deposit from Credit Convert";
//}
else
{
TblReceipt DepositReceipt = new TblReceipt();
DepositReceipt.StrReceiptNo = StrDeposit;
DataTable tblDeposit = DepositReceipt.SelectOne();
decimal DepositAmount = (decimal)(DepositReceipt.MNettAmount.IsNull ? 0 : DepositReceipt.MNettAmount.Value);
myReceiptMasterTable.Rows[0]["mNettAmount"] = ACMS.Convert.ToDecimal(myReceiptMasterTable.Rows[0]["mNettAmount"]) - decimal.Round(DepositAmount, 2);
myReceiptMasterTable.Rows[0]["strRemarks"] = "Deposit from " + StrDeposit;
}
}
//Derek Instalment Plan - Pay OS
if (myCategoryID == 0)
{
myReceiptMasterTable.Rows[0]["mGSTAmount"] = MTotalAmount - MNettAmount;
}
else
{
if (isAllPricesNoGST)
{
myReceiptMasterTable.Rows[0]["mGSTAmount"] = 0;
myReceiptMasterTable.Rows[0]["mTotalAmount"] = decimal.Round(MNettAmount, 2);
}
else
{
myReceiptMasterTable.Rows[0]["mGSTAmount"] = decimal.Round(MNettAmount * myGSTRate, 2);
if (isAllPricesWithGST)
{
myReceiptMasterTable.Rows[0]["mTotalAmount"] = decimal.Round(nettAmountwGST, 2);
}
else
{
myReceiptMasterTable.Rows[0]["mTotalAmount"] = MNettAmount + MGSTAmount;
}
}
}
CalculateOutStanding();
if (WantToUpgradeMemberPackageTable.Rows.Count > 0)
{
double usageBal = 0;
double mTotalUsageWGST = 0;
//Check convert packages' price all with GST
bool isConvertAllPricesWithGST=true;
double mTotalUsage = 0;
if (isAllPricesWithGST)
{
double mTotalAmount=0;
for (int i = 0; i < WantToUpgradeMemberPackageTable.Rows.Count; i++)
{
int nCategory = Convert.ToInt32(WantToUpgradeMemberPackageTable.Rows[i]["nCategoryID"]);
if (nCategory == 7 || nCategory == 36 || nCategory == 37)
{
TblCreditPackage pkg = new TblCreditPackage();
pkg.StrCreditPackageCode = WantToUpgradeMemberPackageTable.Rows[i]["strPackageCode"].ToString();
pkg.SelectOne();
if (pkg.MListPriceWGST.IsNull || WantToUpgradeMemberPackageTable.Rows[i]["strDiscountCode"].ToString() != "")
{
isConvertAllPricesWithGST = false;
break;
}
mTotalAmount += pkg.MCreditAmount.ToDouble();
mTotalUsage += Convert.ToDouble(WantToUpgradeMemberPackageTable.Rows[i]["UsageBalAmt"]);
mTotalUsageWGST += pkg.MListPriceWGST.ToDouble();
pkg.Dispose();
}
else
{
TblPackage pkg = new TblPackage();
pkg.StrPackageCode = WantToUpgradeMemberPackageTable.Rows[i]["strPackageCode"].ToString();
pkg.SelectOne();
if (pkg.MListPriceWGST.IsNull || WantToUpgradeMemberPackageTable.Rows[i]["strDiscountCode"].ToString() != "")
{
isConvertAllPricesWithGST = false;
break;
}
mTotalAmount += pkg.MListPrice.ToDouble();
mTotalUsage += Convert.ToDouble(WantToUpgradeMemberPackageTable.Rows[i]["UsageBalAmt"]);
mTotalUsageWGST += pkg.MListPriceWGST.ToDouble();
pkg.Dispose();
}
}
if (mTotalAmount != mTotalUsage)
isConvertAllPricesWithGST = false;
}
for (int i = 0; i < WantToUpgradeMemberPackageTable.Rows.Count; i++)
{
int mainSession = Convert.ToInt32(WantToUpgradeMemberPackageTable.Rows[i]["nMaxSession"]) - Convert.ToInt32(WantToUpgradeMemberPackageTable.Rows[i]["nFreeSession"]);
int balSession = mainSession - Convert.ToInt32(WantToUpgradeMemberPackageTable.Rows[i]["UsedSession"]);
usageBal += Convert.ToDouble(WantToUpgradeMemberPackageTable.Rows[i]["UsageBalAmt"]);
}
//RecalculateAfterUpgrade(Convert.ToDecimal(usageBal));
if (isConvertAllPricesWithGST && isAllPricesWithGST)
{
nettAmount = ACMS.Convert.ToDecimal(myReceiptMasterTable.Rows[0]["mNettAmount"]) - Convert.ToDecimal(usageBal);
myReceiptMasterTable.Rows[0]["mNettAmount"] = decimal.Round(nettAmount, 2);
myReceiptMasterTable.Rows[0]["mGSTAmount"] = decimal.Round(MNettAmount * myGSTRate, 2);
myReceiptMasterTable.Rows[0]["mTotalAmount"] = decimal.Round(nettAmountwGST - Convert.ToDecimal(mTotalUsageWGST),2);
myReceiptMasterTable.Rows[0]["mOutstandingAmount"] = myReceiptMasterTable.Rows[0]["mTotalAmount"];
}
else
{
nettAmount = ACMS.Convert.ToDecimal(myReceiptMasterTable.Rows[0]["mNettAmount"]) - Convert.ToDecimal(usageBal);
myReceiptMasterTable.Rows[0]["mNettAmount"] = decimal.Round(nettAmount, 2);
myReceiptMasterTable.Rows[0]["mGSTAmount"] = decimal.Round(MNettAmount * myGSTRate, 2);
myReceiptMasterTable.Rows[0]["mTotalAmount"] = MNettAmount + MGSTAmount;
myReceiptMasterTable.Rows[0]["mOutstandingAmount"] = myReceiptMasterTable.Rows[0]["mTotalAmount"];
}
}
}
//2006
// public DataTable SaveIntroduceFriendNew(string strMembershipID, string strIntroducerID, string strPackage, string strRemark, int employeeID)
public bool SaveIntroduceFriendNew(string strMembershipID, string strIntroducerID, string strPackage, string strRemark, int employeeID,int nPackageID)
{
ACMSDAL.ConnectionProvider connProvider = new ConnectionProvider();
TblMember sqlMember = new TblMember();
TblMemberPackage sqlMemberPackage = new TblMemberPackage();
TblPackage sqlPackage = new TblPackage();
try
{
sqlMember.MainConnectionProvider = connProvider;
connProvider.OpenConnection();
connProvider.BeginTransaction("SaveIntroduceFriend");
// sqlMember.UpdateIntroducerMembershipID(strMembershipID, strIntroducerID);
sqlMember.UpdateIntroducerMembershipID(strIntroducerID, strMembershipID);
MemberPackage.CreateFreeMemberSpaPackage_IntroFriend(strMembershipID, strPackage, strRemark, ref nPackageID);
// MemberPackage.CreateFreeMemberSpaPackage_IntroFriend(strIntroducerID, strPackage, strRemark, ref nPackageID);
connProvider.CommitTransaction();
return true;
}
catch (Exception ex)
{
throw;
}
finally
{
if (connProvider.CurrentTransaction != null)
connProvider.CurrentTransaction.Dispose();
if (connProvider.DBConnection != null)
{
if (connProvider.DBConnection.State == ConnectionState.Open)
connProvider.DBConnection.Close();
connProvider.DBConnection.Dispose();
}
sqlPackage.Dispose();
sqlMember.Dispose();
}
}
