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