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(); } }