protected void Page_Load(object sender, EventArgs e)
{
DBLayare.Loan loanInfo = new Loan();
Loan.LoanStruct?loanInfoByClientNumber = loanInfo.getLoanInfoByClientNumber((string)Session["UserName"]);
if (loanInfoByClientNumber != null)
{
lblNoteLoan.Visible = false;
DBLayare.Loan.LoanStruct loanInfoResult = (Loan.LoanStruct)loanInfoByClientNumber;
loanDS.SelectCommand =
"SELECT InstallmentTable.Installment_Number, InstallmentTable.DUE_DATE, InstallmentTable.Installment_Amount, InstallmentTable.Installment_Status" +
" FROM InstallmentTable WHERE (((InstallmentTable.Loan_ID)=" + loanInfoResult.loanNumber + "))";
}
else
{
lblNoteLoan.Font.Size = 12;
lblNoteLoan.Text = @"در حال حاضر تسهیلات اعطا شده ای وجود ندارد";
lblNoteLoan.Visible = true;
}
for (int i = 0; i < GridView2.Rows.Count; i++)
{
string a = GridView2.Rows[i].Cells[1].Text;
PersianCalendar pc1 = new PersianCalendar();
string datetime = pc1.GetYear(Convert.ToDateTime(a)) + "/" + pc1.GetMonth(Convert.ToDateTime(a)) +
"/" +
pc1.GetDayOfMonth(Convert.ToDateTime(a));
GridView2.Rows[i].Cells[1].Text = datetime;
decimal balanceString = Convert.ToDecimal(GridView2.Rows[i].Cells[2].Text);
GridView2.Rows[i].Cells[2].Text = balanceString.ToString("0,0") + @" ريال ";
switch (GridView2.Rows[i].Cells[3].Text)
{
case "0":
{
GridView2.Rows[i].Cells[3].Text = @"پرداخت نشده";
break;
}
case "2":
{
GridView2.Rows[i].Cells[3].Text = @"پرداخت شده";
GridView2.Rows[i].BackColor = System.Drawing.Color.Aquamarine;
break;
}
case "1":
{
GridView2.Rows[i].Cells[3].Text = @"سررسید گذشته";
GridView2.Rows[i].BackColor = System.Drawing.Color.LightPink;
break;
}
}
}
}
/// <summary>
/// جستجوی مشتری
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSearch_Click(object sender, EventArgs e)
{
Label2.Text = "نام: ";
Label3.Text = "نام خانوادگی: ";
Label4.Text = "مانده حساب: ";
var dataTable = dataLayerClass.fillClientByClientNumber(txtClientNum.Text);
DBLayare.Loan loanInfoClass = new Loan();
Loan.LoanStruct?loanInfoByClientNumber = loanInfoClass.getLoanInfoByClientNumber(txtClientNum.Text);
if (loanInfoByClientNumber != null)
{
DBLayare.Loan.LoanStruct loanInfo = (Loan.LoanStruct)loanInfoByClientNumber;
Label11.Text = "شماره تسهیلات: " + loanInfo.loanNumber;
hfLoanId.Value = loanInfo.loanNumber.ToString();
hfInstallmentAmount.Value = loanInfo.installmentAmount.ToString();
Label12.Text = "مبلغ قسط تسهیلات: " + loanInfo.installmentAmount.ToString("0,0") + " ريال";
Label13.Text = "وضعیت تسهیلات: ";
loanPanel.Visible = true;
switch (loanInfo.loanStatus)
{
case 0:
{
Label13.Text = Label13.Text + "جاری";
break;
}
case 1:
{
Label13.Text = Label13.Text + "سررسید گذشته";
Label13.ForeColor = System.Drawing.Color.Red;
break;
}
case 2:
{
Label13.Text = Label13.Text + "مشکوک الوصول";
Label13.ForeColor = System.Drawing.Color.Red;
break;
}
case 3:
{
Label13.Text = Label13.Text + "تسویه شده";
loanPanel.Visible = false;
break;
}
}
numberOfinstallment = dataLayerClass.getNumberOfinstallment((int)loanInfo.loanNumber);
Label9.Text = numberOfinstallment.ToString();
}
else
{
loanPanel.Visible = false;
Label11.Text = "";
Label12.Text = "";
Label13.Text = "";
}
hfClientName.Value = dataTable.Rows[0]["FirstName"].ToString() + " " + dataTable.Rows[0]["LastName"].ToString();
Label2.Text = " " + Label2.Text + dataTable.Rows[0]["FirstName"].ToString();
Label3.Text = " " + Label3.Text + dataTable.Rows[0]["LastName"].ToString();
var param = dataLayerClass.getParameterById(1);
decimal aa = 1;
aa = Convert.ToDecimal(dataTable.Rows[0]["FamilyCount"].ToString());
decimal signAmount = (aa * (Convert.ToDecimal((param.value.ToString()))));
string txtsignAmount = signAmount.ToString("0,0");
Label5.Text = "مبلغ عضویت: " + txtsignAmount + " ريال ";
if (dataTable.Rows[0]["Balance"].ToString() != "")
{
balanceAmount = (decimal)Convert.ToDouble(dataTable.Rows[0]["Balance"].ToString());
string balanceString = balanceAmount.ToString("0,0");
Label4.Text = " " + Label4.Text + balanceString + " ریال ";
}
accountId = Convert.ToDecimal(dataTable.Rows[0]["ID"].ToString());
hfAccountID.Value = dataTable.Rows[0]["ID"].ToString();
hfBalanceAmount.Value = dataTable.Rows[0]["Balance"].ToString();
btnok.Enabled = true;
lblnote.Text = "";
txtAmount.Text = "";
}
protected void Page_Load(object sender, EventArgs e)
{
lblName.Text = " صفحه شخصی " + Session["ClientFirstName"] + " " + Session["ClientLastName"];
this.Page.Title = lblName.Text;
PnlAdmin.Visible = (string)Session["UserName"] == "000";
AccessDataSource1.SelectCommand =
"SELECT [Amount], [date], [Description] FROM [payment] where Account_ID=" + Session["AccountId"] +
" ORDER BY [date] DESC";
GridView1.Caption = "ریز پرداختهای مشتری";
GridView1.CaptionAlign = TableCaptionAlign.Left;
int count = GridView1.Rows.Count;
for (int i = 0; i < count; i++)
{
try
{
string a = GridView1.Rows[i].Cells[0].Text;
PersianCalendar pc1 = new PersianCalendar();
string datetime = pc1.GetYear(Convert.ToDateTime(a)) + "/" + pc1.GetMonth(Convert.ToDateTime(a)) + "/" +
pc1.GetDayOfMonth(Convert.ToDateTime(a));
GridView1.Rows[i].Cells[0].Text = datetime;
decimal balanceString = Convert.ToDecimal(GridView1.Rows[i].Cells[1].Text);
GridView1.Rows[i].Cells[1].Text = balanceString.ToString("0,0") + " ريال ";
}
catch (Exception err)
{
lblNoteLoan.Text = "مشکل لود ریز پرداختها" + err.Message;
}
}
var dataTable = _dataLayerClass.fillClientByClientNumber(Session["UserName"].ToString());
var balanceAmount = (decimal)Convert.ToDouble(dataTable.Rows[0][2].ToString());
string balanceString1 = balanceAmount.ToString("0,0");
lblBalance.Text = " " + lblBalance.Text + balanceString1 + " ریال ";
var param = _dataLayerClass.getParameterById(1);
decimal aa = 1;
aa = Convert.ToDecimal(dataTable.Rows[0]["FamilyCount"].ToString());
decimal signAmount = (aa * (Convert.ToDecimal((param.value.ToString()))));
string txtsignAmount = " مبلغ عضویت: " + signAmount.ToString("0,0");
lblSignAmount.Text = lblSignAmount.Text + txtsignAmount;
DBLayare.Loan loanInfo = new Loan();
Loan.LoanStruct?loanInfoByClientNumber = loanInfo.getLoanInfoByClientNumber((string)Session["UserName"]);
if (loanInfoByClientNumber != null)
{
lblNoteLoan.Visible = false;
DBLayare.Loan.LoanStruct loanInfoResult = (Loan.LoanStruct)loanInfoByClientNumber;
lblLoanNumber.Text = "شماره تسهیلات: " + loanInfoResult.loanNumber.ToString();
lblLoanAmount.Text = "مبلغ تسهیلات: " + loanInfoResult.amount.ToString("0,0");
PersianCalendar pc1 = new PersianCalendar();
string datetime = pc1.GetYear(Convert.ToDateTime(loanInfoResult.grantDate)) + "/" + pc1.GetMonth(Convert.ToDateTime(loanInfoResult.grantDate)) + "/" +
pc1.GetDayOfMonth(Convert.ToDateTime(loanInfoResult.grantDate));
lblGrantDate.Text = "تاریخ اعطای تسهیلات: " + datetime.ToString();
loanDS.SelectCommand = "SELECT InstallmentTable.Installment_Number, InstallmentTable.DUE_DATE, InstallmentTable.Installment_Amount, InstallmentTable.Installment_Status" +
" FROM InstallmentTable WHERE (((InstallmentTable.Loan_ID)=" + loanInfoResult.loanNumber + "))";
}
else
{
lblNoteLoan.Font.Size = 12;
lblNoteLoan.Text = "در حال حاضر تسهیلات اعطا شده ای وجود ندارد";
lblNoteLoan.Visible = true;
}
for (int i = 0; i < GridView2.Rows.Count; i++)
{
try
{
string a = GridView2.Rows[i].Cells[1].Text;
PersianCalendar pc1 = new PersianCalendar();
string datetime = pc1.GetYear(Convert.ToDateTime(a)) + "/" + pc1.GetMonth(Convert.ToDateTime(a)) + "/" +
pc1.GetDayOfMonth(Convert.ToDateTime(a));
GridView2.Rows[i].Cells[1].Text = datetime;
decimal balanceString = Convert.ToDecimal(GridView2.Rows[i].Cells[2].Text);
GridView2.Rows[i].Cells[2].Text = balanceString.ToString("0,0") + " ريال ";
switch (GridView2.Rows[i].Cells[3].Text)
{
case "0":
{
GridView2.Rows[i].Cells[3].Text = "پرداخت نشده";
break;
}
case "2":
{
GridView2.Rows[i].Cells[3].Text = "پرداخت شده";
GridView2.Rows[i].BackColor = System.Drawing.Color.LightCyan;
break;
}
case "1":
{
GridView2.Rows[i].Cells[3].Text = "سررسید گذشته";
GridView2.Rows[i].BackColor = System.Drawing.Color.LightPink;
break;
}
case "3":
{
GridView2.Rows[i].Cells[3].Text = "سررسید شده";
GridView2.Rows[i].BackColor = System.Drawing.Color.Beige;
break;
}
}
}
catch (Exception)
{
}
}
}
