private void button2_Click(object sender, EventArgs e)
{
if (clsAccess.checkForViewingRestriction("Loan Data Entry", Classes.clsUser.Username) != true)
{
return;
}
if (dataGridView1.SelectedRows.Count == 0)
{
//No Data to be edit
Alert.show("Please select transaction you want to edit.", Alert.AlertType.warning);
return;
}
//show form
foreach (Form form in Application.OpenForms)
{
if (form.GetType() == typeof(LoansDataEntry))
{
form.Activate();
x = true;
}
else
{
x = false;
}
}
LoansDataEntry loansDataEntry = new LoansDataEntry();
if (x != true)
{
loansDataEntry.Show();
}
loansDataEntry = (LoansDataEntry)Application.OpenForms["LoansDataEntry"];
//=============================================================================
// MEMBERS INFORMATION
//=============================================================================
Classes.clsLoanDataEntry.userID = Convert.ToInt32(dataGridView1.SelectedRows[0].Cells["userID"].Value.ToString());
using (SqlConnection con = new SqlConnection(global.connectString()))
{
con.Open();
cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandText = "sp_ReturnLoanMembersInformation";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@userID", Classes.clsLoanDataEntry.userID);
adapter = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
adapter.Fill(dt);
if (dt.Rows.Count > 0)
{
loansDataEntry.txtEmployeeID.Text = dt.Rows[0].ItemArray[1].ToString();
if (dt.Rows[0].ItemArray[2].ToString() == "False")
{
loansDataEntry.txtPrincipal.Text = clsLookUp.returnPrincipal(dt.Rows[0].ItemArray[1].ToString());
}
loansDataEntry.txtName.Text = dt.Rows[0].ItemArray[3].ToString();
if (dt.Rows[0].ItemArray[4].ToString() != "")
{
loansDataEntry.txtSalary.Text = Convert.ToDecimal(dt.Rows[0].ItemArray[4].ToString()).ToString("#,0.00");
}
loansDataEntry.txtDateHired.Text = Convert.ToString(Convert.ToDateTime(dt.Rows[0].ItemArray[5].ToString()).ToShortDateString());
loansDataEntry.txtMemberShipDate.Text = Convert.ToString(Convert.ToDateTime(dt.Rows[0].ItemArray[6].ToString()).ToShortDateString());
try
{
loansDataEntry.txtPMSDate.Text = Convert.ToString(Convert.ToDateTime(dt.Rows[0].ItemArray[7].ToString()).ToShortDateString());
}
catch
{
}
//For Getting the years in service
var yrsDate = new DateTime();
int yrsFrmDateHire, yrsToday, total;
yrsDate = Convert.ToDateTime(loansDataEntry.txtDateHired.Text);
yrsFrmDateHire = Convert.ToInt32(yrsDate.Date.Year.ToString());
yrsToday = Convert.ToInt32(DateTime.Today.Year.ToString());
total = yrsToday - yrsFrmDateHire;
loansDataEntry.txtYrsInService.Text = total.ToString();
loansDataEntry.txtCompany.Text = clsLoanDataEntry.returnCompanyDescription(Classes.clsLoanDataEntry.userID);
//Share Capital Balance
loansDataEntry.txtShareCapitalBalance.Text = clsLoanDataEntry.returnShareCapital(Classes.clsLoanDataEntry.userID).ToString("#,0.00");
}
//==================================================================================================================
// END MEMBERS INFORMATION DETAIL
//==================================================================================================================
//============================================================
// DETAILS OF LOAN
//============================================================
loansDataEntry.txtLoanNo.Text = dataGridView1.SelectedRows[0].Cells["Loan_No"].Value.ToString();
loansDataEntry.txtTermsInMonth.Text = dataGridView1.SelectedRows[0].Cells["Terms"].Value.ToString();
loansDataEntry.txtMonthlyAmort.Text = Convert.ToString(Convert.ToDecimal(dataGridView1.SelectedRows[0].Cells["Monthly_Amort"].Value.ToString()).ToString("#,0.00"));
loansDataEntry.txtSemiMonthlyAmort.Text = Convert.ToString(Convert.ToDecimal(dataGridView1.SelectedRows[0].Cells["Semi_Monthly_Amort"].Value.ToString()).ToString("#,0.00"));
loansDataEntry.cmbPaymentOption.Text = dataGridView1.SelectedRows[0].Cells["Payment_Option"].Value.ToString();
loansDataEntry.cmbPaymentOption.Enabled = false;
loansDataEntry.cmbReleaseOption.Text = dataGridView1.SelectedRows[0].Cells["ReleaseOption"].Value.ToString();
loansDataEntry.cmbReleaseOption.Enabled = false;
//============================================================
// END DETAILS OF LOAN
//============================================================
//============================================================
// CO MAKERS DETAILS
//============================================================
loansDataEntry.dataGridView1.Rows.Clear();
adapter = new SqlDataAdapter("select * FROM vw_CoMakers WHERE Loan_No = '" + dataGridView1.SelectedRows[0].Cells["Loan_No"].Value.ToString() + "'", con);
dt = new DataTable();
adapter.Fill(dt);
if (dt.Rows.Count >= 1)
{
loansDataEntry.dataGridView1.Rows.Add(dt.Rows.Count);
for (int i = 0; i < dt.Rows.Count; i++)
{
loansDataEntry.dataGridView1.Rows[i].Cells[0].Value = dt.Rows[i].ItemArray[1].ToString(); //UserID of CO Makers
loansDataEntry.dataGridView1.Rows[i].Cells[1].Value = dt.Rows[i].ItemArray[2].ToString();
loansDataEntry.dataGridView1.Rows[i].Cells[2].Value = dt.Rows[i].ItemArray[3].ToString();
loansDataEntry.dataGridView1.Rows[i].Cells[3].Value = dt.Rows[i].ItemArray[4].ToString();
loansDataEntry.dataGridView1.Rows[i].Cells[4].Value = dt.Rows[i].ItemArray[5].ToString();
}
loansDataEntry.lblTotalCntMakers.Text = dt.Rows.Count.ToString();
}
//============================================================
// END CO MAKERS DETAILS
//============================================================
//===================================
// FOOTER
//===================================
loansDataEntry.txtDateEncoded.Text = Convert.ToString(Convert.ToDateTime(dataGridView1.SelectedRows[0].Cells["Encoded_Date"].Value).ToString("MM/dd/yyyy"));
loansDataEntry.txtEncodedBy.Text = dataGridView1.SelectedRows[0].Cells["Encoded_By"].Value.ToString();
//===================================
// STATUS
//===================================
loansDataEntry.status.Visible = true;
loansDataEntry.status.Text = dataGridView1.SelectedRows[0].Cells["status_description"].Value.ToString();
/*
* IF STATUS IS CANCELLED THEN DISPLAY THE CANCELLED NOTE
*/
if (dataGridView1.SelectedRows[0].Cells["Status"].Value.ToString() == "7")
{
loansDataEntry.txtCancel.Visible = true;
loansDataEntry.lblReason.Visible = true;
loansDataEntry.txtCancel.Text = dataGridView1.SelectedRows[0].Cells["Note"].Value.ToString();
}
else
{
loansDataEntry.txtCancel.Visible = false;
loansDataEntry.lblReason.Visible = false;
}
//If Approve BtnForward visible = false and Cancel will be visible
if (dataGridView1.SelectedRows[0].Cells["status_description"].Value.ToString() == "APPROVED")
{
loansDataEntry.btnForward.Visible = false;
loansDataEntry.btnCancel.Visible = true;
loansDataEntry.lblReason.Visible = true; //Label Reason
loansDataEntry.txtCancel.Visible = true; //Text reason
}
else if (dataGridView1.SelectedRows[0].Cells["status_description"].Value.ToString() == "FOR APPROVAL" || dataGridView1.SelectedRows[0].Cells["status_description"].Value.ToString() == "FBA")
{
loansDataEntry.btnForward.Visible = true;
loansDataEntry.btnCancel.Visible = false;
loansDataEntry.lblReason.Visible = false; //Label Reason
loansDataEntry.txtCancel.Visible = false;
}
if (dataGridView1.SelectedRows[0].Cells["Status"].Value.ToString() == "1" || dataGridView1.SelectedRows[0].Cells["Status"].Value.ToString() == "6")
{
//1 = FOR APPROVAL
loansDataEntry.btnSave.Text = "EDIT";
loansDataEntry.btnClose.Text = "CLOSE";
loansDataEntry.cmbLoanType.Enabled = false;
loansDataEntry.btnSearch.Enabled = false;
loansDataEntry.txtLoanAmount.Enabled = false;
loansDataEntry.txtTermsInMonth.Enabled = false;
//Put the Loan Amount to Class First
Classes.clsLoanDataEntry.loan_amount = Convert.ToDecimal(dataGridView1.SelectedRows[0].Cells["Loan_Amount"].Value.ToString());
}
else if (dataGridView1.SelectedRows[0].Cells["Status"].Value.ToString() == "2" || dataGridView1.SelectedRows[0].Cells["Status"].Value.ToString() == "3" || dataGridView1.SelectedRows[0].Cells["Status"].Value.ToString() == "5" || dataGridView1.SelectedRows[0].Cells["Status"].Value.ToString() == "7" || dataGridView1.SelectedRows[0].Cells["Status"].Value.ToString() == "8")
{
//2 = APPROVED 3 = DISAPPROVED 5 = RELEASED 7 = CANCELLED
loansDataEntry.btnSave.Text = "NEW";
loansDataEntry.btnClose.Text = "CLOSE";
loansDataEntry.cmbLoanType.Enabled = false;
loansDataEntry.btnSearch.Enabled = false;
loansDataEntry.txtLoanAmount.Enabled = false;
loansDataEntry.txtTermsInMonth.Enabled = false;
}
//Loan Details
loansDataEntry.cmbLoanType.SelectedValue = dataGridView1.SelectedRows[0].Cells["Type"].Value.ToString();
loansDataEntry.txtLoanAmount.Text = Convert.ToString(Convert.ToDecimal(dataGridView1.SelectedRows[0].Cells["Loan_Amount"].Value.ToString()).ToString("#,0.00"));
//Disable If Company is Non payroll
if (clsLookUp.returnCompanyCode(loansDataEntry.txtCompany.Text) == "COMP010")
{
//NON-PAYROLL
loansDataEntry.button1.Enabled = false;
}
else
{
loansDataEntry.button1.Enabled = true;
}
}
}
private void button2_Click(object sender, EventArgs e)
{
// dataGridView1.Rows[selectedRow].Cells[selected].Value = dataGridView3.SelectedRows[0].Cells["EmployeeID"].Value.ToString() + " - " + dataGridView3.SelectedRows[0].Cells["Name"].Value.ToString();
LoansDataEntry loanDataEntry = new LoansDataEntry();
loanDataEntry = (LoansDataEntry)Application.OpenForms["LoansDataEntry"];
//Disable If Company is Non payroll
if (clsLookUp.returnCompanyCode(loanDataEntry.txtCompany.Text) != "COMP010")
{
//NOT NON-PAYROLL
//Validation For Co Makers
if (clsLoanDataEntry.isShortTerm(loanDataEntry.cmbLoanType.SelectedValue.ToString()) == true)
{
if (loanDataEntry.dataGridView1.Rows.Count >= 6)
{
Alert.show("Already exceeds the No. of required Co-Makers.", Alert.AlertType.error);
return;
}
}
else
{
//Long Term
if (loanDataEntry.txtLoanAmount.Text != "" && loanDataEntry.txtTermsInMonth.Text != "")
{
string str = loanDataEntry.txtLoanAmount.Text;
str = str.Replace(",", "");
decimal answer;
double ttalCO = Convert.ToDouble(loanDataEntry.txtLoanAmount.Text) / 500000.00;
answer = Convert.ToDecimal(ttalCO);
if ((answer % 1) > 0)
{
//is decimal
answer = clsLoanDataEntry.GetDot(Convert.ToString(ttalCO)) * 6;
}
else
{
answer = answer * 6;
}
if (loanDataEntry.dataGridView1.Rows.Count >= answer)
{
Alert.show("Already exceeds the No. of required Co-Makers.", Alert.AlertType.error);
return;
}
}
else
{
Alert.show("Please fill up Loan amount and Loan term in months.", Alert.AlertType.error);
return;
}
//For RPL Loans must be 10 years above
if (clsParameter.checkForRPLloans(getLoanType) == true)
{
//Selected loan type is RPL
if (clsParameter.check10yearsAbove(Convert.ToInt32(dataGridView1.SelectedRows[0].Cells["userID"].Value.ToString())) == false)
{
//Must be 10 years above
Alert.show("Co-maker should be 10 years above in the company.", Alert.AlertType.error);
return;
}
}
}
}
//==========================================================================================
foreach (Form form in Application.OpenForms)
{
if (form.GetType() == typeof(LoansDataEntry))
{
//===============================================================================
// If form is already open
//===============================================================================
form.Activate();
loanDataEntry = (LoansDataEntry)Application.OpenForms["LoansDataEntry"];
//check first if this member is already been a co maker in his/her list
for (int i = 0; i < loanDataEntry.dataGridView1.Rows.Count; i++)
{
if (dataGridView1.SelectedRows[0].Cells["userID"].Value.ToString() == loanDataEntry.dataGridView1.Rows[i].Cells[0].Value.ToString())
{
alreadyUsed = true;
}
}
if (Classes.clsLoanDataEntry.userID.ToString() == dataGridView1.SelectedRows[0].Cells["userID"].Value.ToString())
{
Alert.show("You cannot be a Co-Maker to your own loan.", Alert.AlertType.error);
return;
}
if (alreadyUsed == true)
{
Alert.show("Member already used as co-maker.", Alert.AlertType.error);
alreadyUsed = false;
return;
}
var index = loanDataEntry.dataGridView1.Rows.Add();
loanDataEntry.dataGridView1.Rows[index].Cells[0].Value = dataGridView1.SelectedRows[0].Cells["userID"].Value.ToString();
loanDataEntry.dataGridView1.Rows[index].Cells[1].Value = dataGridView1.SelectedRows[0].Cells["EmployeeID"].Value.ToString();
loanDataEntry.dataGridView1.Rows[index].Cells[2].Value = dataGridView1.SelectedRows[0].Cells["LastName"].Value.ToString() + ", " + dataGridView1.SelectedRows[0].Cells["FirstName"].Value.ToString() + " " + dataGridView1.SelectedRows[0].Cells["MiddleName"].Value.ToString() + dataGridView1.SelectedRows[0].Cells["Suffix"].Value.ToString();
loanDataEntry.dataGridView1.Rows[index].Cells[3].Value = dataGridView1.SelectedRows[0].Cells["Cellphone_No"].Value.ToString();
loanDataEntry.dataGridView1.Rows[index].Cells[4].Value = dataGridView1.SelectedRows[0].Cells["Residential_Address"].Value.ToString();
loanDataEntry.lblTotalCntMakers.Text = loanDataEntry.dataGridView1.Rows.Count.ToString();
//return to false
alreadyUsed = false;
return;
}
}
this.Close();
}
private void button2_Click(object sender, EventArgs e)
{
//For Resigned Member
if (clsMembership.isResigned(Convert.ToInt32(dataGridView1.SelectedRows[0].Cells["userID"].Value.ToString())) == true)
{
//Already Resigned
DialogResult result = MessageBox.Show(this, "This member already resigned, are you sure you want to continue?", "PLDT Credit Cooperative", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (result == DialogResult.No)
{
return;
}
}
//Check for hold accounts
if (clsHoldAccount.checkIfHoldAccount(Convert.ToInt32(dataGridView1.SelectedRows[0].Cells["userID"].Value.ToString())) == true)
{
Alert.show("Member's account is on hold.", Alert.AlertType.error);
return;
}
if (clsHoldAccount.checkIfTHeresADependent(dataGridView1.SelectedRows[0].Cells["EmployeeID"].Value.ToString()) == true)
{
Alert.show("Member's account is on hold.", Alert.AlertType.error);
return;
}
LoansDataEntry loanDataEntry = new LoansDataEntry();
foreach (Form form in Application.OpenForms)
{
if (form.GetType() == typeof(LoansDataEntry))
{
//===============================================================================
// If form is already open
//===============================================================================
form.Activate();
loanDataEntry = (LoansDataEntry)Application.OpenForms["LoansDataEntry"];
Classes.clsLoanDataEntry.userID = Convert.ToInt32(dataGridView1.SelectedRows[0].Cells["userID"].Value.ToString());
//===============================================================================
// IF SELECTED MEMBER IS A DEPENDENT
//===============================================================================
if (dataGridView1.SelectedRows[0].Cells["Principal"].Value.ToString() == "False")
{
loanDataEntry.txtPrincipal.Text = clsLookUp.returnPrincipal(dataGridView1.SelectedRows[0].Cells["EmployeeID"].Value.ToString());
}
loanDataEntry.txtEmployeeID.Text = dataGridView1.SelectedRows[0].Cells["EmployeeID"].Value.ToString();
loanDataEntry.txtName.Text = dataGridView1.SelectedRows[0].Cells["LastName"].Value.ToString() + ", " + dataGridView1.SelectedRows[0].Cells["FirstName"].Value.ToString() + " " + dataGridView1.SelectedRows[0].Cells["MiddleName"].Value.ToString() + dataGridView1.SelectedRows[0].Cells["Suffix"].Value.ToString();
if (dataGridView1.SelectedRows[0].Cells["Salary"].Value.ToString() != "")
{
loanDataEntry.txtSalary.Text = Convert.ToDecimal(dataGridView1.SelectedRows[0].Cells["Salary"].Value).ToString("#,0.00");
}
loanDataEntry.txtDateHired.Text = Convert.ToString(Convert.ToDateTime(dataGridView1.SelectedRows[0].Cells["Date_Hired"].Value.ToString()).ToShortDateString());
loanDataEntry.txtMemberShipDate.Text = Convert.ToString(Convert.ToDateTime(dataGridView1.SelectedRows[0].Cells["Date_Of_Membership"].Value.ToString()).ToShortDateString());
try
{
loanDataEntry.txtPMSDate.Text = Convert.ToString(Convert.ToDateTime(dataGridView1.SelectedRows[0].Cells["Date_Of_PMS"].Value.ToString()).ToShortDateString());
}
catch
{
}
//For Getting the years in service
var yrsDate = new DateTime();
int yrsFrmDateHire, yrsToday, total;
yrsDate = Convert.ToDateTime(loanDataEntry.txtDateHired.Text);
yrsFrmDateHire = Convert.ToInt32(yrsDate.Date.Year.ToString());
yrsToday = Convert.ToInt32(DateTime.Today.Year.ToString());
total = yrsToday - yrsFrmDateHire;
loanDataEntry.txtYrsInService.Text = total.ToString();
loanDataEntry.txtCompany.Text = clsLoanDataEntry.returnCompanyDescription(Classes.clsLoanDataEntry.userID);
//Share Capital Balance
loanDataEntry.txtShareCapitalBalance.Text = clsLoanDataEntry.returnShareCapital(Classes.clsLoanDataEntry.userID).ToString("#,0.00");
//Disable If Company is Non payroll
if (clsLookUp.returnCompanyCode(loanDataEntry.txtCompany.Text) == "COMP010")
{
//NON-PAYROLL
loanDataEntry.button1.Enabled = false;
}
else
{
loanDataEntry.button1.Enabled = true;
}
//Clear details value first
foreach (var c in loanDataEntry.panel11.Controls)
{
if (c is TextBox)
{
((TextBox)c).Text = String.Empty;
}
if (c is ComboBox)
{
((ComboBox)c).SelectedIndex = -1;
}
}
this.Close();
return;
}
}
Classes.clsLoanDataEntry.userID = Convert.ToInt32(dataGridView1.SelectedRows[0].Cells["userID"].Value.ToString());
//===============================================================================
// IF SELECTED MEMBER IS A DEPENDENT
//===============================================================================
if (dataGridView1.SelectedRows[0].Cells["Principal"].Value.ToString() == "False")
{
loanDataEntry.txtPrincipal.Text = clsLookUp.returnPrincipal(dataGridView1.SelectedRows[0].Cells["EmployeeID"].Value.ToString());
}
loanDataEntry.txtEmployeeID.Text = dataGridView1.SelectedRows[0].Cells["EmployeeID"].Value.ToString();
loanDataEntry.txtName.Text = dataGridView1.SelectedRows[0].Cells["LastName"].Value.ToString() + ", " + dataGridView1.SelectedRows[0].Cells["FirstName"].Value.ToString() + " " + dataGridView1.SelectedRows[0].Cells["MiddleName"].Value.ToString() + dataGridView1.SelectedRows[0].Cells["Suffix"].Value.ToString();
if (dataGridView1.SelectedRows[0].Cells["Salary"].Value.ToString() != "")
{
loanDataEntry.txtSalary.Text = Convert.ToDecimal(dataGridView1.SelectedRows[0].Cells["Salary"].Value).ToString("#,0.00");
}
loanDataEntry.txtDateHired.Text = Convert.ToString(Convert.ToDateTime(dataGridView1.SelectedRows[0].Cells["Date_Hired"].Value.ToString()).ToShortDateString());
loanDataEntry.txtMemberShipDate.Text = Convert.ToString(Convert.ToDateTime(dataGridView1.SelectedRows[0].Cells["Date_Of_Membership"].Value.ToString()).ToShortDateString());
loanDataEntry.txtPMSDate.Text = Convert.ToString(Convert.ToDateTime(dataGridView1.SelectedRows[0].Cells["Date_Of_PMS"].Value.ToString()).ToShortDateString());
loanDataEntry.txtCompany.Text = clsLoanDataEntry.returnCompanyDescription(Classes.clsLoanDataEntry.userID);
this.Close();
}
