private void cmbPolicy_EditValueChanged(object sender, EventArgs e)
{
if (cmbPolicy.EditValue != null)
{
frmLoading _loading = new frmLoading();
_loading.Show();
dsMembers.Members.Clear();
dsMembers.Members.Merge(DataHelper.GetTableData(dsMembers.Members, " Where IID = '" + cmbPolicy.GetColumnValue("MemberID").ToString() + "'").Tables[0]);
DataRow dr = dsMembers.Members.Rows[0];
// MemberID = dr["IID"].ToString();
txtFatherHusbandName.Text = dr["FatherHusbandName"].ToString();
txtFullName.Text = dr["FullName"].ToString();
txtLAddress.Text = dr["LLocation"].ToString();
txtLDistrict.Text = dr["LDistrict"].ToString();
txtLpostCode.Text = dr["LPostCode"].ToString();
txtLPostOffice.Text = dr["LPostOffice"].ToString();
txtLThana.Text = dr["LThana"].ToString();
txtLVillage.Text = dr["LVillage"].ToString();
if (dr["Photo"].ToString() != "")
{
byte[] image = (byte[])dr["Photo"];
System.IO.MemoryStream stream = new System.IO.MemoryStream(image, 0, image.Length, false);
this.imgPhoto.Image = System.Drawing.Image.FromStream(stream);
}
else
{
imgPhoto.Image = null;
}
dsMembers.Policy.Clear();
dsMembers.Policy.Merge(DataHelper.GetTableData(dsMembers.Policy, " WHERE IID = '" + cmbPolicy.EditValue.ToString() + "'").Tables[0]);
dtpEnlistedDate.DateTime = (DateTime)dsMembers.Policy.Rows[0]["EnlistedDate"];
txtDepositRatio.Text = dsMembers.Policy.Rows[0]["SavingRatio"].ToString();
DataTable dt = DataHelper.GetData("SELECT COUNT(*) AS TotalDeposite FROM dbo.DepositDetails Where MasterID = '" + cmbPolicy.EditValue.ToString() + "' AND Description = 'Deposit'").Tables[0];
double TInstall = double.Parse(dt.Rows[0][0].ToString());
dt = DataHelper.GetData("SELECT COUNT(*) AS TotalDeposite FROM dbo.DepositDetails Where MasterID = '" + cmbPolicy.EditValue.ToString() + "' AND Description = 'Withdraw'").Tables[0];
double TWithdraw = double.Parse(dt.Rows[0][0].ToString());
dt = DataHelper.GetData("SELECT ISNULL(SUM(DepositProfit), 0) AS TotalDeposit, ISNULL(SUM(Withdrawal), 0) AS TotalWithdraw FROM dbo.DepositDetails Where MasterID = '" + cmbPolicy.EditValue.ToString() + "'").Tables[0];
double TInAmount = double.Parse(dt.Rows[0]["TotalDeposit"].ToString());
double TWthAmount = double.Parse(dt.Rows[0]["TotalWithdraw"].ToString());
txtTotalInstall.Text = TInstall.ToString();
txtTotalWithdraw.Text = TWithdraw.ToString();
txtTotalDepositAmount.Text = TInAmount.ToString();
txtTotalWithdrawAmount.Text = TWthAmount.ToString();
txtNetDepositAmount.Text = (TInAmount - TWthAmount).ToString();
txtNetDepositAmount2.Text = txtNetDepositAmount.Text;
txtAvgInstall.Text = ((TInAmount - TWthAmount) / double.Parse(txtDepositRatio.Text)).ToString();
_loading.Dispose();
LoanDataset dsLoan = new LoanDataset();
dsLoan.LoanStatus.Clear();
dsLoan.LoanStatus.Merge(DataHelper.GetTableData(dsLoan.LoanStatus, " Where PolicyID = '" + cmbPolicy.EditValue.ToString() + "' AND Status = 'true'").Tables[0]);
if (!(bool)dsMembers.Policy.Rows[0]["Status"])
{
MessageBox.Show("This is a closed policy...", "Disposed Policy", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
btnSave.Enabled = false;
return;
}
if (dsLoan.LoanStatus.Rows.Count > 0)
{
MessageBox.Show("This Policy is Continuing a loan... You can not despose this policy...", "Loan Exist", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
btnSave.Enabled = false;
return;
}
btnSave.Enabled = true;
}
}