private void button2_Click(object sender, EventArgs e) { if (clsApproval.returnStatusNo(txtLoanNo.Text) == "2") { //APPROVED Alert.show("This Loan is already approved.", Alert.AlertType.error); return; } if (clsApproval.returnStatusNo(txtLoanNo.Text) == "3") { //DISAPPROVED Alert.show("This Loan is already disapproved.", Alert.AlertType.error); return; } if (clsApproval.returnStatusNo(txtLoanNo.Text) == "5") { //DISAPPROVED Alert.show("This Loan is already released.", Alert.AlertType.error); return; } if (clsApproval.returnStatusNo(txtLoanNo.Text) == "7") { //DISAPPROVED Alert.show("Loan already cancelled.", Alert.AlertType.error); return; } string msg = Environment.NewLine + "Are you sure you want to continue?"; DialogResult result = MessageBox.Show(this, msg, "PLDT Credit Cooperative", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (result == DialogResult.Yes) { using (SqlConnection con = new SqlConnection(global.connectString())) { con.Open(); cmd = new SqlCommand(); cmd.Connection = con; cmd.CommandText = "UPDATE LOAN Set Status = '6' WHERE Loan_No ='" + txtLoanNo.Text + "'"; cmd.CommandType = CommandType.Text; cmd.ExecuteNonQuery(); Alert.show("Loan " + txtLoanNo.Text + " Successfully tag as FBA!", Alert.AlertType.success); //Refresh Grid try { Loans frm = new Loans(); frm = (Loans)Application.OpenForms["Loans"]; frm.refreshData(); } catch { } } } }
private void panel1_Click(object sender, EventArgs e) { //Bring To Front (Child Form) //Nikko Melgar foreach (Form form in Application.OpenForms) { if (form.GetType() == typeof(Loans)) { form.Activate(); return; } } Loans frm = new Loans(); MainForm main = new MainForm(); frm.Show(); frm.MdiParent = main; }
private void button22_Click(object sender, EventArgs e) { //Hide Panel panelLoan.Visible = false; //controls foreach (Form form in Application.OpenForms) { if (form.GetType() == typeof(Loans)) { form.Activate(); return; } } Loans frm = new Loans(); frm.Show(); frm.MdiParent = this; }
private void button1_Click(object sender, EventArgs e) { if (clsApproval.returnStatusNo(txtLoanNo.Text) == "2") { //APPROVED Alert.show("This Loan is already approved.", Alert.AlertType.error); return; } if (clsApproval.returnStatusNo(txtLoanNo.Text) == "3") { //DISAPPROVED Alert.show("This Loan is already disapproved.", Alert.AlertType.error); return; } if (clsApproval.returnStatusNo(txtLoanNo.Text) == "5") { //DISAPPROVED Alert.show("This Loan is already released.", Alert.AlertType.error); return; } if (clsApproval.returnStatusNo(txtLoanNo.Text) == "7") { //DISAPPROVED Alert.show("Loan already cancelled.", Alert.AlertType.error); return; } string msg = Environment.NewLine + "Are you sure you want to approve this loan?"; DialogResult result = MessageBox.Show(this, msg, "PLDT Credit Cooperative", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (result == DialogResult.Yes) { using (SqlConnection con = new SqlConnection(global.connectString())) { con.Open(); double srvc; srvc = Convert.ToDouble(txtLoanAmount.Text) * Convert.ToDouble(clsParameter.serviceFee()); //For Loans that not required a service fee SqlDataAdapter adapterSRV = new SqlDataAdapter("SELECT VAL FROM Parameter WHERE val = '" + cmbLoanType.Text + "' and Description = 'No Service Fee'", con); DataTable dtSRV = new DataTable(); adapterSRV.Fill(dtSRV); if (dtSRV.Rows.Count > 0) { srvc = 0.00; } //APPROVED cmd = new SqlCommand(); cmd.Connection = con; cmd.CommandText = "sp_ApprovedLoan"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Loan_No", txtLoanNo.Text); cmd.Parameters.AddWithValue("@Service_Fee", Convert.ToDecimal(decimal.Round(Convert.ToDecimal(srvc), 2))); cmd.Parameters.AddWithValue("@Share_Capital", Convert.ToDecimal(txtShareCapital.Text)); cmd.Parameters.AddWithValue("@Savings", Convert.ToDecimal(txtSavings.Text)); cmd.Parameters.AddWithValue("@Approved_By", Classes.clsUser.Username); cmd.Parameters.AddWithValue("@Note", txtReason.Text); cmd.ExecuteNonQuery(); //Move the Deduct amounts to loan and other deduction if (dataGridView1.Rows.Count >= 1) { //SAVE ALL THAT HAS A VALUE //DATAGRID LOAN BALANCES //Declaration First int x = 0; //RECORDS IN DATAGRIDVIEW LOAN BALANCES while (x != dataGridView1.Rows.Count) { if (dataGridView1.Rows[x].Cells[4].Value == null) { //If No Applied Amount x = x + 1; } else { //If has a deferred value if (Convert.ToDecimal(dataGridView1.Rows[x].Cells[3].Value.ToString()) > 0) { //Check if equal or greater than or less than if (Convert.ToDecimal(dataGridView1.Rows[x].Cells[4].Value.ToString()) == Convert.ToDecimal(dataGridView1.Rows[x].Cells[3].Value.ToString())) { //if loan no has unearned amount if (clsLoan.returnUnearnedInterest(dataGridView1.Rows[x].Cells[0].Value.ToString()) != 0.00) { //INSERT THE AMOUNT OF UNEARED clsLoan.insertLoanDeduction(txtLoanNo.Text, dataGridView1.Rows[x].Cells[7].Value.ToString(), dataGridView1.Rows[x].Cells[0].Value.ToString(), "314", Convert.ToDecimal(clsLoan.returnUnearnedInterest(dataGridView1.Rows[x].Cells[0].Value.ToString()))); //INSERT TO INTEREST ON LOAN (EARNED INTEREST) clsLoan.insertLoanDeduction(txtLoanNo.Text, dataGridView1.Rows[x].Cells[7].Value.ToString(), dataGridView1.Rows[x].Cells[0].Value.ToString(), "401.1", Convert.ToDecimal(clsLoan.returnUnearnedInterest(dataGridView1.Rows[x].Cells[0].Value.ToString()))); } //CHECK IF APPLIED AMOUNT = DEFERRED AMOUNT SqlCommand cmd = new SqlCommand(); cmd.Connection = con; cmd.CommandText = "sp_InsertLoanDeductions"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@userID", Classes.clsLoanDataEntry.userID); cmd.Parameters.AddWithValue("@Loan_No", txtLoanNo.Text); cmd.Parameters.AddWithValue("@Loan_Type", dataGridView1.Rows[x].Cells[7].Value.ToString()); cmd.Parameters.AddWithValue("@Loan_Type_Loan_No", dataGridView1.Rows[x].Cells[0].Value.ToString()); cmd.Parameters.AddWithValue("@Other_Deduction", dataGridView1.Rows[x].Cells[6].Value.ToString()); //Bill Deferred First cmd.Parameters.AddWithValue("@Applied_Amount", dataGridView1.Rows[x].Cells[3].Value.ToString().Replace(",", "")); cmd.Parameters.AddWithValue("@Deduction_Type", "LOAN"); cmd.ExecuteNonQuery(); } else if (Convert.ToDecimal(dataGridView1.Rows[x].Cells[4].Value.ToString()) > Convert.ToDecimal(dataGridView1.Rows[x].Cells[3].Value.ToString())) { //if loan no has unearned amount if (clsLoan.returnUnearnedInterest(dataGridView1.Rows[x].Cells[0].Value.ToString()) != 0.00) { //INSERT THE AMOUNT OF UNEARED clsLoan.insertLoanDeduction(txtLoanNo.Text, dataGridView1.Rows[x].Cells[7].Value.ToString(), dataGridView1.Rows[x].Cells[0].Value.ToString(), "314", Convert.ToDecimal(clsLoan.returnUnearnedInterest(dataGridView1.Rows[x].Cells[0].Value.ToString()))); //INSERT TO INTEREST ON LOAN (EARNED INTEREST) clsLoan.insertLoanDeduction(txtLoanNo.Text, dataGridView1.Rows[x].Cells[7].Value.ToString(), dataGridView1.Rows[x].Cells[0].Value.ToString(), "401.1", Convert.ToDecimal(clsLoan.returnUnearnedInterest(dataGridView1.Rows[x].Cells[0].Value.ToString()))); } MessageBox.Show(clsLoan.returnUnearnedInterest(txtLoanNo.Text).ToString()); //IF APPLIED AMOUNT IS GREATER THAN THE DEFERRED AMOUNT SqlCommand cmd = new SqlCommand(); cmd.Connection = con; cmd.CommandText = "sp_InsertLoanDeductions"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@userID", Classes.clsLoanDataEntry.userID); cmd.Parameters.AddWithValue("@Loan_No", txtLoanNo.Text); cmd.Parameters.AddWithValue("@Loan_Type", dataGridView1.Rows[x].Cells[7].Value.ToString()); cmd.Parameters.AddWithValue("@Loan_Type_Loan_No", dataGridView1.Rows[x].Cells[0].Value.ToString()); cmd.Parameters.AddWithValue("@Other_Deduction", dataGridView1.Rows[x].Cells[6].Value.ToString()); //Bill Deferred First cmd.Parameters.AddWithValue("@Applied_Amount", dataGridView1.Rows[x].Cells[3].Value.ToString().Replace(",", "")); cmd.Parameters.AddWithValue("@Deduction_Type", "LOAN"); cmd.ExecuteNonQuery(); double appliedPrincipal = 0; appliedPrincipal = Convert.ToDouble(dataGridView1.Rows[x].Cells[4].Value.ToString()) - Convert.ToDouble(dataGridView1.Rows[x].Cells[3].Value.ToString()); SqlCommand cmd2 = new SqlCommand(); cmd2.Connection = con; cmd2.CommandText = "sp_InsertLoanDeductions"; cmd2.CommandType = CommandType.StoredProcedure; cmd2.Parameters.AddWithValue("@userID", Classes.clsLoanDataEntry.userID); cmd2.Parameters.AddWithValue("@Loan_No", txtLoanNo.Text); cmd2.Parameters.AddWithValue("@Loan_Type", dataGridView1.Rows[x].Cells[7].Value.ToString()); cmd2.Parameters.AddWithValue("@Loan_Type_Loan_No", dataGridView1.Rows[x].Cells[0].Value.ToString()); cmd2.Parameters.AddWithValue("@Other_Deduction", dataGridView1.Rows[x].Cells[5].Value.ToString()); //Bill Current First cmd2.Parameters.AddWithValue("@Applied_Amount", Convert.ToDecimal(appliedPrincipal)); cmd2.Parameters.AddWithValue("@Deduction_Type", "LOAN"); cmd2.ExecuteNonQuery(); MessageBox.Show(appliedPrincipal.ToString()); } else if (Convert.ToDecimal(dataGridView1.Rows[x].Cells[4].Value.ToString()) < Convert.ToDecimal(dataGridView1.Rows[x].Cells[3].Value.ToString())) { //Applied amount is less than deferred amount //First we should put to unearned interest if they have uneared balance //Insert First reverse unearned entry if (clsLoan.returnUnearnedInterest(dataGridView1.Rows[x].Cells[0].Value.ToString()) != 0.00) { //if applied amount is greater than the unearned amount if (clsLoan.returnUnearnedInterest(dataGridView1.Rows[x].Cells[0].Value.ToString()) >= Convert.ToDouble(dataGridView1.Rows[x].Cells[4].Value.ToString().Replace(",", ""))) { //INSERT THE AMOUNT OF UNEARED clsLoan.insertLoanDeduction(txtLoanNo.Text, dataGridView1.Rows[x].Cells[7].Value.ToString(), dataGridView1.Rows[x].Cells[0].Value.ToString(), "314", Convert.ToDecimal(clsLoan.returnUnearnedInterest(dataGridView1.Rows[x].Cells[0].Value.ToString()))); //INSERT TO INTEREST ON LOAN (EARNED INTEREST) clsLoan.insertLoanDeduction(txtLoanNo.Text, dataGridView1.Rows[x].Cells[7].Value.ToString(), dataGridView1.Rows[x].Cells[0].Value.ToString(), "401.1", Convert.ToDecimal(clsLoan.returnUnearnedInterest(dataGridView1.Rows[x].Cells[0].Value.ToString()))); } else { //INSERT THE AMOUNT OF UNEARED clsLoan.insertLoanDeduction(txtLoanNo.Text, dataGridView1.Rows[x].Cells[7].Value.ToString(), dataGridView1.Rows[x].Cells[0].Value.ToString(), "314", Convert.ToDecimal(dataGridView1.Rows[x].Cells[4].Value.ToString().Replace(",", ""))); //INSERT TO INTEREST ON LOAN (EARNED INTEREST) clsLoan.insertLoanDeduction(txtLoanNo.Text, dataGridView1.Rows[x].Cells[7].Value.ToString(), dataGridView1.Rows[x].Cells[0].Value.ToString(), "401.1", Convert.ToDecimal(dataGridView1.Rows[x].Cells[4].Value.ToString().Replace(",", ""))); } } //INSERT IN PAST DUE(DEFERRED ACCOUNT) SqlCommand cmd = new SqlCommand(); cmd.Connection = con; cmd.CommandText = "sp_InsertLoanDeductions"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@userID", Classes.clsLoanDataEntry.userID); cmd.Parameters.AddWithValue("@Loan_No", txtLoanNo.Text); cmd.Parameters.AddWithValue("@Loan_Type", dataGridView1.Rows[x].Cells[7].Value.ToString()); cmd.Parameters.AddWithValue("@Loan_Type_Loan_No", dataGridView1.Rows[x].Cells[0].Value.ToString()); cmd.Parameters.AddWithValue("@Other_Deduction", dataGridView1.Rows[x].Cells[6].Value.ToString()); //Bill Deferred First cmd.Parameters.AddWithValue("@Applied_Amount", dataGridView1.Rows[x].Cells[4].Value.ToString().Replace(",", "")); cmd.Parameters.AddWithValue("@Deduction_Type", "LOAN"); cmd.ExecuteNonQuery(); } } //IF NO DEFERRED else { SqlCommand cmd2 = new SqlCommand(); cmd2.Connection = con; cmd2.CommandText = "sp_InsertLoanDeductions"; cmd2.CommandType = CommandType.StoredProcedure; cmd2.Parameters.AddWithValue("@userID", Classes.clsLoanDataEntry.userID); cmd2.Parameters.AddWithValue("@Loan_No", txtLoanNo.Text); cmd2.Parameters.AddWithValue("@Loan_Type", dataGridView1.Rows[x].Cells[7].Value.ToString()); cmd2.Parameters.AddWithValue("@Loan_Type_Loan_No", dataGridView1.Rows[x].Cells[0].Value.ToString()); cmd2.Parameters.AddWithValue("@Other_Deduction", dataGridView1.Rows[x].Cells[5].Value.ToString()); //Bill CURRENT First cmd2.Parameters.AddWithValue("@Applied_Amount", Convert.ToDecimal(dataGridView1.Rows[x].Cells[4].Value.ToString())); cmd2.Parameters.AddWithValue("@Deduction_Type", "LOAN"); cmd2.ExecuteNonQuery(); } //COUNTER x = x + 1; } } } if (chckShareCapital.Checked == true && txtShareCapital.Text != "") { SqlCommand cmdShareCapital = new SqlCommand(); cmdShareCapital.Connection = con; cmdShareCapital.CommandText = "sp_InsertLoanDeductions"; cmdShareCapital.CommandType = CommandType.StoredProcedure; cmdShareCapital.Parameters.AddWithValue("@userID", Classes.clsLoanDataEntry.userID); cmdShareCapital.Parameters.AddWithValue("@Loan_No", txtLoanNo.Text); cmdShareCapital.Parameters.AddWithValue("@Loan_Type", ""); cmdShareCapital.Parameters.AddWithValue("@Loan_Type_Loan_No", ""); cmdShareCapital.Parameters.AddWithValue("@Other_Deduction", "363"); cmdShareCapital.Parameters.AddWithValue("@Applied_Amount", Convert.ToDecimal(txtShareCapital.Text)); cmdShareCapital.Parameters.AddWithValue("@Deduction_Type", "OTHER DEDUCTION"); cmdShareCapital.ExecuteNonQuery(); } if (chckSavings.Checked == true && txtSavings.Text != "") { SqlCommand cmdSavings = new SqlCommand(); cmdSavings.Connection = con; cmdSavings.CommandText = "sp_InsertLoanDeductions"; cmdSavings.CommandType = CommandType.StoredProcedure; cmdSavings.Parameters.AddWithValue("@userID", Classes.clsLoanDataEntry.userID); cmdSavings.Parameters.AddWithValue("@Loan_No", txtLoanNo.Text); cmdSavings.Parameters.AddWithValue("@Loan_Type", ""); cmdSavings.Parameters.AddWithValue("@Loan_Type_Loan_No", ""); cmdSavings.Parameters.AddWithValue("@Other_Deduction", "300.1"); cmdSavings.Parameters.AddWithValue("@Applied_Amount", Convert.ToDecimal(txtSavings.Text)); cmdSavings.Parameters.AddWithValue("@Deduction_Type", "OTHER DEDUCTION"); cmdSavings.ExecuteNonQuery(); } Alert.show("Loan " + txtLoanNo.Text + " successfully approved.", Alert.AlertType.success); //Convert.ToString(decimal.Round(Convert.ToDecimal(z), 2))); //reflect adapter = new SqlDataAdapter("SELECT Approved_By,Approved_Date FROM Loan WHERE Loan_No = '" + txtLoanNo.Text + "'", con); dt = new DataTable(); adapter.Fill(dt); txtApprovedBy.Text = dt.Rows[0].ItemArray[0].ToString(); txtAppDissDate.Text = Convert.ToDateTime(dt.Rows[0].ItemArray[1].ToString()).ToShortDateString(); //Refresh Grid try { Loans frm = new Loans(); frm = (Loans)Application.OpenForms["Loans"]; frm.refreshData(); } catch { } } } else { return; } }
private void button4_Click(object sender, EventArgs e) { if (clsApproval.returnStatusNo(txtLoanNo.Text) == "5") { //DISAPPROVED Alert.show("This Loan is already released.", Alert.AlertType.error); return; } if (clsApproval.returnStatusNo(txtLoanNo.Text) == "7") { //DISAPPROVED Alert.show("Loan already cancelled.", Alert.AlertType.error); return; } string msg = Environment.NewLine + "Are you sure you want to cancel this loan?"; DialogResult result = MessageBox.Show(this, msg, "PLDT Credit Cooperative", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (result == DialogResult.Yes) { if (txtReason.Text == "") { Alert.show("Reason for cancellation of loan is required.", Alert.AlertType.error); return; } using (SqlConnection con = new SqlConnection(global.connectString())) { con.Open(); cmd = new SqlCommand(); cmd.Connection = con; cmd.CommandText = "UPDATE LOAN Set Status = '7',Cancelled_Date = GETDATE(), Cancelled_By = '" + Classes.clsUser.Username + "' ,Note = '" + txtReason.Text + "' WHERE Loan_No ='" + txtLoanNo.Text + "'"; cmd.CommandType = CommandType.Text; cmd.ExecuteNonQuery(); Alert.show("Loan " + txtLoanNo.Text + " successfully cancelled.", Alert.AlertType.success); //reflect in the form adapter = new SqlDataAdapter("SELECT Cancelled_Date,Cancelled_By FROM Loan WHERE Loan_No = '" + txtLoanNo.Text + "'", con); dt = new DataTable(); adapter.Fill(dt); txtCancelledBy.Text = dt.Rows[0].ItemArray[1].ToString(); txtDateCancelled.Text = Convert.ToDateTime(dt.Rows[0].ItemArray[0].ToString()).ToShortDateString(); //Refresh Grid try { Loans frm = new Loans(); frm = (Loans)Application.OpenForms["Loans"]; frm.refreshData(); } catch { } } } }