private void cmdpay_Click(object sender, EventArgs e) { DataTable dt = Loans1.ListofMemberLoans(txtidnumber.Text); cboloans.Items.Clear(); if (dt.Rows.Count > 0) { foreach (DataRow row in dt.Rows) { string LoanDetails = row[2].ToString() + "-" + row[1].ToString(); cboloans.Items.Add(LoanDetails); } cmdpay.Enabled = true; } else { MessageBox.Show("This member does not have a loan due", "ISUGURU MIS", MessageBoxButtons.OK, MessageBoxIcon.Warning); txtidnumber.Focus(); cmdpay.Enabled = false; } if (cboloans.Items.Count > 0) { cboloans.SelectedIndex = 0; } }
private void approveSelectedLoanToolStripMenuItem_Click_1(object sender, EventArgs e) { if (grid.SelectedRows.Count > 0) { foreach (DataGridViewRow row in grid.SelectedRows) { string LoanApplicationID = row.Cells["MemberID"].Value.ToString(); Loans1.ChangeLoanStatus(Properties.Settings.Default.ApprovedLoanStatus, LoanApplicationID); } ReloadGridContent(); MessageBox.Show("Loan Status was updated Successfully", "SACCO MIS", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
private void btnSaveLoanApp_Click(object sender, EventArgs e) { if (Program.GetMemberSystemID(txtidnumber.Text) == "") { MessageBox.Show("Please provide a valid Identification Number", "SACCO MIS", MessageBoxButtons.OK, MessageBoxIcon.Error); txtidnumber.Focus(); return; } if (txtamount.Value < 1) { MessageBox.Show("The loan amount can not be zero or less than zero", "SACCO MIS", MessageBoxButtons.OK, MessageBoxIcon.Error); txtamount.Focus(); return; } //Process and Save Loan Details string sql = "Insert into Loans(MemberID,LoanAmount,Period,Status,ApplicationDate,ApprovalDate,DisburseDate,TotalInterest,PaymentAmount)" + "values(@MID,@LAmount,@Period,@Status,@ApplicationDate,@ApprovalDate,@DisburseDate,@TotalInterest,@Amount)"; string status = Properties.Settings.Default.AppliedLoanStatus; string ApprovalDate = "", DisburseDate = ""; if (chkapprove.Checked) { status = Properties.Settings.Default.ApprovedLoanStatus; ApprovalDate = txtdate.Value.ToString(); } if (chkdisburse.Checked) { status = Properties.Settings.Default.DisbursedLoanStatus; ApprovalDate = txtdate.Value.ToString(); DisburseDate = txtdate.Value.ToString(); } //Calculate Interest & Repayable Amount int years = (int)(Convert.ToDecimal(txtperiod.Text) / 12); // int InstallationsPerYear = (int)txtinstallations.Value / years; double interest = Loans1.SimpleInterest((double)txtamount.Value, Properties.Settings.Default.interest, years); double TotalAmount = interest + (double)txtamount.Value; SqlCommand cmd = new SqlCommand(); cmd.CommandText = sql; cmd.Parameters.AddWithValue("MID", Program.GetMemberSystemID(txtidnumber.Text)); cmd.Parameters.AddWithValue("LAmount", txtamount.Value); cmd.Parameters.AddWithValue("Period", txtperiod.Text); cmd.Parameters.AddWithValue("Status", status); cmd.Parameters.AddWithValue("ApplicationDate", DateTime.Now); cmd.Parameters.AddWithValue("ApprovalDate", ApprovalDate); cmd.Parameters.AddWithValue("DisburseDate", DisburseDate); cmd.Parameters.AddWithValue("TotalInterest", interest); cmd.Parameters.AddWithValue("Amount", TotalAmount); txtamount.Value = 0; txtperiod.Text = ""; Database.CreateRecord(cmd); MessageBox.Show("Sucess!", "ISUGURU SACCO", MessageBoxButtons.OK, MessageBoxIcon.Information); }