private void MyFormLoad()
{
InstallementsService.InstallementsServiceClient a = new InstallementsService.InstallementsServiceClient();
dataGridView1.DataSource = a.GetLoanInstallements(Id1).Select(x => new { x.Id, x.Amount, x.PaymentDate, x.IsPayed }).ToList();
decimal sum = 0;
for (int i = 0; i < dataGridView1.RowCount; i++)
{
sum += decimal.Parse(dataGridView1.Rows[i].Cells["Amount"].Value.ToString());
}
LoanTransactionsService.LoanTransactionsServiceClient b = new LoanTransactionsService.LoanTransactionsServiceClient();
var l = b.GetLoanTransactions().Where(x => x.Id == Id1).ToList();
label1.Text = string.Empty;
if (l[0].Amount - sum != 0)
{
label1.Text = " •جمع اقساط با مبلغ وام همخوانی ندارد";
if ((l[0].Amount - sum) < 0)
{
label1.Text += "جمع اقساط بیشتر از مبلغ وام است" + "\r\n";
}
else
{
label1.Text += "جمع اقساط کمتر از مبلغ وام است" + "\r\n";
}
label1.Text += "\r\n" + "اختلاف مبلغ دریافتی با اقساط مقدار : " + ((l[0].Amount - sum) < 0? (l[0].Amount - sum) * (-1): (l[0].Amount - sum)).ToString() + " است .";
}
}
private void AdminHome_Load(object sender, EventArgs e)
{
InstallementsService.InstallementsServiceClient a = new InstallementsService.InstallementsServiceClient();
dataGridView1.DataSource = a.GetPeopleInstallements().Select(x => new { x.InstallementId, x.Fullname, x.NationalCode, x.Amount, x.PaymentDate, x.InstallementIsPayed }).Where(x => x.InstallementIsPayed == false && x.PaymentDate <= System.DateTime.Now).ToList();
LoanTransactionsService.LoanTransactionsServiceClient b = new LoanTransactionsService.LoanTransactionsServiceClient();
dataGridView2.DataSource = b.GetPeopleLoanTransactions().Select(x => new { x.LoanId, x.Fullname, x.NationalCode, x.Amount, x.DateTime, x.AdminPermission }).Where(x => x.AdminPermission == false).ToList();
DepositTransactionsService.DepositTransactionsServiceClient c = new DepositTransactionsService.DepositTransactionsServiceClient();
dataGridView3.DataSource = c.GetPeopleDepositTransactions().Select(x => new { x.DepositId, x.Fullname, x.NationalCode, x.Amount, x.BankFollowUpCode, x.DateTime, x.AdminPermission }).Where(x => x.AdminPermission == false).ToList();
Status.StatusClient d = new Status.StatusClient();
var bank = d.GetPeopleBank();
label15.Text = bank.Loan.ToString();
label14.Text = bank.Deposit.ToString();
label12.Text = bank.NonPayedInstallements.ToString();
label13.Text = bank.PayedInstallements.ToString();
label10.Text = bank.Amount.ToString();
PeopleService.PeopleServiceClient j = new PeopleService.PeopleServiceClient();
var q = j.GetPerson(Data.NationalCode);
label4.Text = "نام : " + q.FirstName;
label1.Text = "نام خانوادگی : " + q.LastName;
label3.Text = "کد ملی : " + q.NationalCode;
label5.Text = "تاریخ افتتاح " + q.CreateDateTime;
}
private void InstallmentsAE_Load(object sender, EventArgs e)
{
if (rol == 1)//edit
{
InstallementsService.InstallementsServiceClient a = new InstallementsService.InstallementsServiceClient();
var b = a.GetLoanInstallements(id).Where(x => x.Id == idIns).FirstOrDefault();
Amount.Text = b.Amount.ToString();
dateTimePicker1.Value = b.PaymentDate.Value;
}
}
private void button1_Click(object sender, EventArgs e)
{
if (decimal.Parse(Mojododi.Text) >= decimal.Parse(Amount.Text))
{
InstallementsService.InstallementsServiceClient a = new InstallementsService.InstallementsServiceClient();
a.PayInstallement(InsId, true);
MessageBox.Show("با موفقیت وصول شد");
this.Close();
}
else
{
MessageBox.Show("موجودی کاربر کافی نیست");
}
}
private void PayedInstallment_Load(object sender, EventArgs e)
{
InstallementsService.InstallementsServiceClient a = new InstallementsService.InstallementsServiceClient();
var b = a.GetPeopleInstallements().Select(x => new { x.InstallementId, x.Fullname, x.NationalCode, x.Amount, x.PaymentDate, x.InstallementIsPayed }).Where(x => x.InstallementIsPayed == false && x.PaymentDate <= System.DateTime.Now).ToList();
NationalCode.Text = b[0].NationalCode;
LastName.Text = b[0].Fullname;
Phone.Text = new PeopleService.PeopleServiceClient().GetPerson(b[0].NationalCode).Mobile;
Amount.Text = b[0].Amount.ToString();
Status.StatusClient c = new Status.StatusClient();
Mojododi.Text = c.GetPeopleBank().Amount.ToString();
}
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
// if (e.ColumnIndex == ((sender as DataGridView).Columns.Count) - 1)
if (e.ColumnIndex == 0)
{
Guid id = Guid.Parse(dataGridView1.Rows[e.RowIndex].Cells["InstallementId"].Value.ToString());
PayedInstallment f = new PayedInstallment();
f.InsId = id;
f.ShowDialog();
InstallementsService.InstallementsServiceClient b = new InstallementsService.InstallementsServiceClient();
dataGridView1.DataSource = b.GetPeopleInstallements().Select(x => new { x.InstallementId, x.Fullname, x.NationalCode, x.Amount, x.PaymentDate, x.InstallementIsPayed }).Where(x => x.InstallementIsPayed == false).ToList();
}
}
private void button1_Click(object sender, EventArgs e)
{
LoanTransactionsService.LoanTransactionsServiceClient a = new LoanTransactionsService.LoanTransactionsServiceClient();
Guid g = Guid.NewGuid();
a.InsertLoanTransactions(g, DateTime.Now, Decimal.Parse(Amount.Text), BankFollowUp.Text, true, Data.NationalCode, NationalCode1, true, false);
MessageBox.Show("وام با موفقیت ایجاد شد");
InstallementsService.InstallementsServiceClient b = new InstallementsService.InstallementsServiceClient();
b.AutomaticInstallement(g, int.Parse(countInstallment.Text));
MessageBox.Show("اقساط با موفقیت ایجاد شد");
Installments f = new Installments();
f.Id1 = g;
f.ShowDialog();
this.Close();
}
private void button1_Click(object sender, EventArgs e)
{
InstallementsService.InstallementsServiceClient a = new InstallementsService.InstallementsServiceClient();
if (rol == 1)
{
a.UpdateInstallements(idIns, dateTimePicker1.Value.Date, decimal.Parse(Amount.Text), id);
MessageBox.Show("قسط با موفقیت ویرایش شد");
this.Close();
}
else if (rol == 0)
{
a.InsertInstallements(Guid.NewGuid(), dateTimePicker1.Value.Date, decimal.Parse(Amount.Text), id);
MessageBox.Show("قسط با موفقیت ثبت شد");
this.Close();
}
}
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
Guid id = Guid.Parse(dataGridView1.Rows[e.RowIndex].Cells["Id"].Value.ToString());
InstallementsService.InstallementsServiceClient a = new InstallementsService.InstallementsServiceClient();
if (e.ColumnIndex == 0) // Edit mode
{
InstallmentsAE f = new InstallmentsAE();
f.id = Id1;
f.idIns = id;
f.rol = 1;
f.ShowDialog();
a = new InstallementsService.InstallementsServiceClient();
dataGridView1.DataSource = a.GetLoanInstallements(Id1).Select(x => new { x.Id, x.Amount, x.PaymentDate, x.IsPayed }).ToList();
MyFormLoad();
//InstallmentsAddOrEdit f = new InstallmentsAddOrEdit();
//f.IdInstalment = id;
//f.Type = 0;
//f.ShowDialog();
}
else if (e.ColumnIndex == 1) // Delete mode
{
if (MessageBox.Show("آیا از حذف این قسط اطمینان دارید؟", "خطا", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
InstallementsService.InstallementsServiceClient b = new InstallementsService.InstallementsServiceClient();
b.DeleteInstallements(id);
MessageBox.Show("با موفقیت حذف شد");
a = new InstallementsService.InstallementsServiceClient();
dataGridView1.DataSource = a.GetLoanInstallements(Id1).Select(x => new { x.Id, x.Amount, x.PaymentDate, x.IsPayed }).ToList();
MyFormLoad();
}
}
else if (e.ColumnIndex == 2) // Done mode
{
PayedInstallment f = new PayedInstallment();
f.InsId = id;
f.ShowDialog();
MyFormLoad();
}
}
