private void CalculateAmount()
{
ACMSDAL.TblMemberPackage memberPackage = new ACMSDAL.TblMemberPackage();
memberPackage.NPackageID = myPackageID;
DataTable tblmemberpackage = memberPackage.SelectOne();
mPayAmount = GetTotalPayment(tblmemberpackage.Rows[0]["strReceiptNo"].ToString());
}
private void CalculateUsage()
{
ACMSDAL.TblMemberPackage memberPackage = new ACMSDAL.TblMemberPackage();
memberPackage.NPackageID = myPackageID;
DataTable tblmemberpackage = memberPackage.SelectOne();
ACMSDAL.TblPackage myPackage = new ACMSDAL.TblPackage();
myPackage.StrPackageCode = tblmemberpackage.Rows[0]["strPackageCode"].ToString();
DataTable tblPackage = myPackage.SelectOne();
mUsageAmount = ACMS.Convert.ToDecimal(tblPackage.Rows[0]["mBaseUnitPrice"]) * myMemberPackageSession;
}
public FormTopUpSingleTreatment(ACMSLogic.POS pos)
{
//
// Required for Windows Form Designer support
//
InitializeComponent();
//
// TODO: Add any constructor code after InitializeComponent call
//
myPOS = pos;
ACMSDAL.TblMemberPackage sqlMemberPackage = new ACMSDAL.TblMemberPackage();
myDataTable = sqlMemberPackage.GetActiveMemberPackageForSpaSingleTreatment(myPOS.StrMembershipID);
ACMSLogic.MemberPackage.CalculateMemberPackageBalance(myDataTable);
myDataTable.DefaultView.RowFilter = "Balance > 0 ";
GridControl6.DataSource = myDataTable.DefaultView;
}
public FormTopUpSingleTreatment(ACMSLogic.POS pos)
{
//
// Required for Windows Form Designer support
//
InitializeComponent();
//
// TODO: Add any constructor code after InitializeComponent call
//
myPOS = pos;
ACMSDAL.TblMemberPackage sqlMemberPackage = new ACMSDAL.TblMemberPackage();
myDataTable = sqlMemberPackage.GetActiveMemberPackageForSpaSingleTreatment(myPOS.StrMembershipID);
ACMSLogic.MemberPackage.CalculateMemberPackageBalance(myDataTable);
myDataTable.DefaultView.RowFilter = "Balance > 0 ";
GridControl6.DataSource = myDataTable.DefaultView;
}
private decimal GetTotalPayment(string strReceipt)
{
ACMSDAL.TblReceipt myReceipt = new ACMSDAL.TblReceipt();
myReceipt.StrReceiptNo = strReceipt;
DataTable tblReceiptPaid = myReceipt.SelectOne();
if (tblReceiptPaid.Rows[0]["strParentReceiptNo"].ToString() == "" && tblReceiptPaid.Rows[0]["strChildReceiptNo"].ToString() == "")
{
// Add payment for full payment
mPayAmount = GetPayment(strReceipt) / System.Convert.ToDecimal("1.07");
}
// Get the Parent Total paid amount from tblmemberpackage + this receipt Total Payment
else if (tblReceiptPaid.Rows[0]["strParentReceiptNo"].ToString() != "")
{
ACMSDAL.TblMemberPackage myMemberPackage = new ACMSDAL.TblMemberPackage();
myMemberPackage.StrReceiptNo = tblReceiptPaid.Rows[0]["strParentReceiptNo"].ToString();
myMemberPackage.SelectOneReceipt();
decimal mParentTotal = myMemberPackage.MTotalPaid.ToDecimal();
decimal mNetPayAmount;
if (System.Convert.ToDateTime(tblReceiptPaid.Rows[0]["dtdate"]) < System.Convert.ToDateTime("01/Jul/2007"))
{
mPayAmount = GetPayment(tblReceiptPaid.Rows[0]["strReceiptNo"].ToString()) / System.Convert.ToDecimal("1.05") + mParentTotal;
}
else
{
mPayAmount = GetPayment(tblReceiptPaid.Rows[0]["strReceiptNo"].ToString()) / System.Convert.ToDecimal("1.07") + mParentTotal;
}
GetChild(tblReceiptPaid.Rows[0]["strReceiptNo"].ToString());
if (strChild != null)
{
string[] arrSubTask = strChild.Substring(0, strChild.Length - 1).Split(',');
for (int j = 0; j < arrSubTask.Length; j++)
{
mNetPayAmount = GetPayment(arrSubTask[j].ToString());
if (System.Convert.ToDateTime(tblReceiptPaid.Rows[0]["dtdate"]) < System.Convert.ToDateTime("01/Jul/2007"))
{
mNetPayAmount = mNetPayAmount / System.Convert.ToDecimal("1.05");
}
else
{
mNetPayAmount = mNetPayAmount / System.Convert.ToDecimal("1.07");
}
mPayAmount = mPayAmount + mNetPayAmount;
}
}
}
else if (tblReceiptPaid.Rows[0]["strChildReceiptNo"].ToString() != "")
{
// Add payment for the receipt and find the child receipt and add back
// decimal mReceiptAmount;
decimal mNetPayAmount;
if (System.Convert.ToDateTime(tblReceiptPaid.Rows[0]["dtdate"]) < System.Convert.ToDateTime("01/Jul/2007"))
{
mPayAmount = GetPayment(tblReceiptPaid.Rows[0]["strReceiptNo"].ToString()) / System.Convert.ToDecimal("1.05");
}
else
{
mPayAmount = GetPayment(tblReceiptPaid.Rows[0]["strReceiptNo"].ToString()) / System.Convert.ToDecimal("1.07");
}
//this.a_audit_spaTableAdapter.GetPaidAmount(tblReceiptPaid.Rows[i]["strChildReceiptNo"].ToString());
GetChild(tblReceiptPaid.Rows[0]["strReceiptNo"].ToString());
string[] arrSubTask = strChild.Substring(0, strChild.Length - 1).Split(',');
for (int j = 0; j < arrSubTask.Length; j++)
{
mNetPayAmount = GetPayment(arrSubTask[j].ToString());
if (System.Convert.ToDateTime(tblReceiptPaid.Rows[0]["dtdate"]) < System.Convert.ToDateTime("01/Jul/2007"))
{
mNetPayAmount = mNetPayAmount / System.Convert.ToDecimal("1.05");
}
else
{
mNetPayAmount = mNetPayAmount / System.Convert.ToDecimal("1.07");
}
mPayAmount = mPayAmount + mNetPayAmount;
// this.a_audit_spaTableAdapter.updatePaidAmount(mReceiptAmount, tblReceiptPaid.Rows[0]["strReceiptNo"].ToString());
}
}
return(mPayAmount);
}
private void CalculateUsage()
{
ACMSDAL.TblMemberPackage memberPackage = new ACMSDAL.TblMemberPackage();
memberPackage.NPackageID = myPackageID;
DataTable tblmemberpackage = memberPackage.SelectOne();
ACMSDAL.TblPackage myPackage = new ACMSDAL.TblPackage();
myPackage.StrPackageCode = tblmemberpackage.Rows[0]["strPackageCode"].ToString();
DataTable tblPackage = myPackage.SelectOne();
mUsageAmount = ACMS.Convert.ToDecimal(tblPackage.Rows[0]["mBaseUnitPrice"]) * myMemberPackageSession;
}
private decimal GetTotalPayment( string strReceipt)
{
ACMSDAL.TblReceipt myReceipt = new ACMSDAL.TblReceipt();
myReceipt.StrReceiptNo = strReceipt;
DataTable tblReceiptPaid = myReceipt.SelectOne();
if (tblReceiptPaid.Rows[0]["strParentReceiptNo"].ToString() == "" && tblReceiptPaid.Rows[0]["strChildReceiptNo"].ToString() == "")
{
// Add payment for full payment
mPayAmount = GetPayment(strReceipt) / System.Convert.ToDecimal("1.07");
}
// Get the Parent Total paid amount from tblmemberpackage + this receipt Total Payment
else if (tblReceiptPaid.Rows[0]["strParentReceiptNo"].ToString() != "")
{
ACMSDAL.TblMemberPackage myMemberPackage = new ACMSDAL.TblMemberPackage();
myMemberPackage.StrReceiptNo = tblReceiptPaid.Rows[0]["strParentReceiptNo"].ToString();
myMemberPackage.SelectOneReceipt();
decimal mParentTotal = myMemberPackage.MTotalPaid.ToDecimal();
decimal mNetPayAmount;
if (System.Convert.ToDateTime(tblReceiptPaid.Rows[0]["dtdate"]) < System.Convert.ToDateTime("01/Jul/2007"))
mPayAmount = GetPayment(tblReceiptPaid.Rows[0]["strReceiptNo"].ToString()) / System.Convert.ToDecimal("1.05") + mParentTotal;
else
mPayAmount = GetPayment(tblReceiptPaid.Rows[0]["strReceiptNo"].ToString()) / System.Convert.ToDecimal("1.07") + mParentTotal;
GetChild(tblReceiptPaid.Rows[0]["strReceiptNo"].ToString());
if (strChild != null)
{
string[] arrSubTask = strChild.Substring(0, strChild.Length - 1).Split(',');
for (int j = 0; j < arrSubTask.Length; j++)
{
mNetPayAmount = GetPayment(arrSubTask[j].ToString());
if (System.Convert.ToDateTime(tblReceiptPaid.Rows[0]["dtdate"]) < System.Convert.ToDateTime("01/Jul/2007"))
mNetPayAmount = mNetPayAmount / System.Convert.ToDecimal("1.05");
else
mNetPayAmount = mNetPayAmount / System.Convert.ToDecimal("1.07");
mPayAmount = mPayAmount + mNetPayAmount;
}
}
}
else if (tblReceiptPaid.Rows[0]["strChildReceiptNo"].ToString() != "")
{
// Add payment for the receipt and find the child receipt and add back
// decimal mReceiptAmount;
decimal mNetPayAmount;
if (System.Convert.ToDateTime(tblReceiptPaid.Rows[0]["dtdate"]) < System.Convert.ToDateTime("01/Jul/2007"))
mPayAmount = GetPayment(tblReceiptPaid.Rows[0]["strReceiptNo"].ToString()) / System.Convert.ToDecimal("1.05");
else
mPayAmount = GetPayment(tblReceiptPaid.Rows[0]["strReceiptNo"].ToString()) / System.Convert.ToDecimal("1.07");
//this.a_audit_spaTableAdapter.GetPaidAmount(tblReceiptPaid.Rows[i]["strChildReceiptNo"].ToString());
GetChild(tblReceiptPaid.Rows[0]["strReceiptNo"].ToString());
string[] arrSubTask = strChild.Substring(0, strChild.Length - 1).Split(',');
for (int j = 0; j < arrSubTask.Length; j++)
{
mNetPayAmount = GetPayment(arrSubTask[j].ToString());
if (System.Convert.ToDateTime(tblReceiptPaid.Rows[0]["dtdate"]) < System.Convert.ToDateTime("01/Jul/2007"))
mNetPayAmount = mNetPayAmount / System.Convert.ToDecimal("1.05");
else
mNetPayAmount = mNetPayAmount / System.Convert.ToDecimal("1.07");
mPayAmount = mPayAmount + mNetPayAmount;
// this.a_audit_spaTableAdapter.updatePaidAmount(mReceiptAmount, tblReceiptPaid.Rows[0]["strReceiptNo"].ToString());
}
}
return mPayAmount;
}
private void CalculateAmount()
{
ACMSDAL.TblMemberPackage memberPackage = new ACMSDAL.TblMemberPackage();
memberPackage.NPackageID = myPackageID;
DataTable tblmemberpackage = memberPackage.SelectOne();
mPayAmount = GetTotalPayment(tblmemberpackage.Rows[0]["strReceiptNo"].ToString());
}
public void Refresh(int nPackageID)
{
ACMSDAL.TblMemberPackage memberPackage = new ACMSDAL.TblMemberPackage();
memberPackage.NPackageID = nPackageID;
memberPackage.SelectOne();
myStrPackageCode = memberPackage.StrPackageCode.IsNull ? "" : memberPackage.StrPackageCode.Value;
Refresh();
}
public ServiceCodeLookupEditBuilder2(RepositoryItemLookUpEdit lookupEdt, int nPackageID)
: base(lookupEdt)
{
//
// TODO: Add constructor logic here
//
ACMSDAL.TblMemberPackage memberPackage = new ACMSDAL.TblMemberPackage();
memberPackage.NPackageID = nPackageID;
memberPackage.SelectOne();
myStrPackageCode = memberPackage.StrPackageCode.IsNull ? "" : memberPackage.StrPackageCode.Value;
myDisplayMember = "strServiceCode";
myValueMember = "strServiceCode";
Refresh();
myLookupEdit.Columns.Clear();
myLookupEdit.Columns.AddRange(new DevExpress.XtraEditors.Controls.LookUpColumnInfo[] {
new DevExpress.XtraEditors.Controls.LookUpColumnInfo("strServiceCode", "Service Code", 20, DevExpress.Utils.FormatType.None, "", true, DevExpress.Utils.HorzAlignment.Default, DevExpress.Data.ColumnSortOrder.None),
new DevExpress.XtraEditors.Controls.LookUpColumnInfo("strDescription", "Description", 50, DevExpress.Utils.FormatType.None, "", true, DevExpress.Utils.HorzAlignment.Default, DevExpress.Data.ColumnSortOrder.None)});
}
public override void Refresh()
{
if (myStrMemberShipID != "")
{
if (myIsServiceSession)
{
ACMSDAL.TblMemberPackage memberPackage = new ACMSDAL.TblMemberPackage();
myDataTable = memberPackage.GetActiveMemberPackageForServiceSession(myStrMemberShipID);
Init();
}
else
{
ACMSDAL.TblMemberPackage memberPackage = new ACMSDAL.TblMemberPackage();
myDataTable = memberPackage.GetAllMemberPackageForClassAttendance(myStrMemberShipID);
ACMSLogic.MemberPackage myMemberPackage = new ACMSLogic.MemberPackage();
myMemberPackage.CalculateMemberPackageBalance(myStrMemberShipID, myDataTable);
foreach (DataRow dr in myDataTable.Rows)
{
if (Convert.ToInt32(dr["Balance"]) <= 0)
dr.Delete();
}
myDataTable.AcceptChanges();
Init();
}
}
}
public override void Refresh()
{
ACMSDAL.TblMemberPackage memberPckg = new ACMSDAL.TblMemberPackage();
if (myIsServiceSession)
myDataTable = memberPckg.GetActiveMemberPackageForServiceSession(myMembershipID);
else
myDataTable = memberPckg.GetActiveMemberPackageForClassAttendance(myMembershipID);
Init();
}
