private void button12_Click(object sender, EventArgs e)
{
//Hide sub menu filemaintenance
panelProcessSub.Visible = false;
//controls
foreach (Form form in Application.OpenForms)
{
if (form.GetType() == typeof(DisbursementVoucher))
{
form.Activate();
return;
}
}
DisbursementVoucher frm = new DisbursementVoucher();
frm.Show();
frm.MdiParent = this;
}
private void button1_Click(object sender, EventArgs e)
{
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();
//=====================================================
// LOAN DETAIL INSERT HERE
//=====================================================
clsLoanDataEntry.createSchedule(txtLoanNo.Text, clsLoanDataEntry.returnPaymentOption(txtLoanNo.Text), clsLoanDataEntry.loanAmountGross(txtLoanNo.Text), Convert.ToDouble(txtInterest.Text), Convert.ToDouble(txtTermsInMonth.Text), cmbLoanType.Text, txtProcessdDate.Text);
string cvno;
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandText = "sp_InsertDisbursementHeader";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@CVDate", DateTime.Today.ToShortDateString());
//FOr Payee Type
//Member = 0 Client = 1
cmd.Parameters.AddWithValue("@Payee_Type", "1");
cmd.Parameters.AddWithValue("@userID", userID);
cmd.Parameters.AddWithValue("@Payee", txtEmployeeID.Text);
cmd.Parameters.AddWithValue("@Payee_Name", txtName.Text);
cmd.Parameters.AddWithValue("@Particulars", txtParticular.Text);
cmd.Parameters.AddWithValue("@Loan_No", txtLoanNo.Text);
cmd.Parameters.AddWithValue("@Bank_Code", "BDO");
cmd.Parameters.AddWithValue("@Check_No", DBNull.Value);
cmd.Parameters.AddWithValue("@Check_Date", DBNull.Value);
cmd.Parameters.AddWithValue("@Amount", Convert.ToDecimal(txtNetAmount.Text));
cmd.Parameters.AddWithValue("@Transaction_Type", "TRAN002");
cmd.Parameters.AddWithValue("@Prepared_By", Classes.clsUser.Username);
cmd.ExecuteNonQuery();
//Get The CV NO.
SqlCommand cmdCV = new SqlCommand();
cmdCV.Connection = con;
cmdCV.CommandText = "sp_GetCVNoAfterSaving";
cmdCV.CommandType = CommandType.StoredProcedure;
cmdCV.Parameters.AddWithValue("@CV_Date", DateTime.Today.ToShortDateString());
cmdCV.Parameters.AddWithValue("@Prepared_By", Classes.clsUser.Username);
SqlDataAdapter adapter = new SqlDataAdapter(cmdCV);
DataTable dt = new DataTable();
adapter.Fill(dt);
if (dt.Rows.Count > 0)
{
cvno = dt.Rows[0].ItemArray[0].ToString();
}
else
{
return;
}
//=================================================================================
//DISBURSEMENT DETAILS FIRST CURRENT LOAN AND BANK OF MEMBERS
//=================================================================================
//FOR CURRENT LOAN - LOAN AVAIL BY THE MEMBER
SqlCommand cmd1 = new SqlCommand();
cmd1.Connection = con;
cmd1.CommandText = "sp_InsertDisbursementDetail";
cmd1.CommandType = CommandType.StoredProcedure;
cmd1.Parameters.AddWithValue("@CV_No", cvno);
cmd1.Parameters.AddWithValue("@Account_Code", clsLoanComputation.returnChartAccountCode(cmbLoanType.Text));
cmd1.Parameters.AddWithValue("@userID", userID);
cmd1.Parameters.AddWithValue("@Subsidiary_Code", clsCollection.GetSubsidiary(userID));
cmd1.Parameters.AddWithValue("@Loan_No", txtLoanNo.Text);
cmd1.Parameters.AddWithValue("@Debit", Convert.ToDecimal(txtLoanReceivable.Text.Replace(",", "")));
cmd1.Parameters.AddWithValue("@Credit", Convert.ToDecimal("0.00"));
cmd1.ExecuteNonQuery();
//FOR MEMBERS BANK INFORMATION
SqlCommand cmd2 = new SqlCommand();
cmd2.Connection = con;
cmd2.CommandText = "sp_InsertDisbursementDetail";
cmd2.CommandType = CommandType.StoredProcedure;
cmd2.Parameters.AddWithValue("@CV_No", cvno);
cmd2.Parameters.AddWithValue("@Account_Code", "102.02");
cmd2.Parameters.AddWithValue("@userID", userID);
cmd2.Parameters.AddWithValue("@Subsidiary_Code", clsCollection.GetSubsidiary(userID));
cmd2.Parameters.AddWithValue("@Loan_No", "");
cmd2.Parameters.AddWithValue("@Debit", Convert.ToDecimal("0.00"));
cmd2.Parameters.AddWithValue("@Credit", Convert.ToDecimal(txtNetAmount.Text.Replace(",", "")));
cmd2.ExecuteNonQuery();
//FOR SERVICE FEE
if (txtServiceFee.Text != "0.00")
{
SqlCommand cmd3 = new SqlCommand();
cmd3.Connection = con;
cmd3.CommandText = "sp_InsertDisbursementDetail";
cmd3.CommandType = CommandType.StoredProcedure;
cmd3.Parameters.AddWithValue("@CV_No", cvno);
cmd3.Parameters.AddWithValue("@Account_Code", "405");
cmd3.Parameters.AddWithValue("@userID", userID);
cmd3.Parameters.AddWithValue("@Subsidiary_Code", clsCollection.GetSubsidiary(userID));
cmd3.Parameters.AddWithValue("@Loan_No", "");
cmd3.Parameters.AddWithValue("@Debit", Convert.ToDecimal("0.00"));
cmd3.Parameters.AddWithValue("@Credit", Convert.ToDecimal(txtServiceFee.Text.Replace(",", "")));
cmd3.ExecuteNonQuery();
}
//===================================================================================================
// IF EVER HE HAS OTHER DEDUCTION MADE
//===================================================================================================
SqlDataAdapter adapter2 = new SqlDataAdapter("SELECT * FROM vw_loanDeductionToVoucher WHERE Loan_No = '" + txtLoanNo.Text + "'", con);
DataTable dt2 = new DataTable();
adapter2.Fill(dt2);
if (dt2.Rows.Count > 0)
{
int x = 0;
while (x != dt2.Rows.Count)
{
SqlCommand cmdDeduction = new SqlCommand();
cmdDeduction.Connection = con;
cmdDeduction.CommandText = "sp_InsertDisbursementDetail";
cmdDeduction.CommandType = CommandType.StoredProcedure;
cmdDeduction.Parameters.AddWithValue("@CV_No", cvno);
cmdDeduction.Parameters.AddWithValue("@Account_Code", dt2.Rows[x].ItemArray[7].ToString());
cmdDeduction.Parameters.AddWithValue("@userID", userID);
cmdDeduction.Parameters.AddWithValue("@Subsidiary_Code", clsCollection.GetSubsidiary(userID));
if (dt2.Rows[x].ItemArray[4].ToString() != "")
{
cmdDeduction.Parameters.AddWithValue("@Loan_No", dt2.Rows[x].ItemArray[4].ToString());
}
else
{
cmdDeduction.Parameters.AddWithValue("@Loan_No", "");
}
cmdDeduction.Parameters.AddWithValue("@Debit", Convert.ToDecimal("0.00"));
cmdDeduction.Parameters.AddWithValue("@Credit", Convert.ToDecimal(dt2.Rows[x].ItemArray[5].ToString()));
cmdDeduction.ExecuteNonQuery();
x = x + 1;//Increment
}
}
//=====================================================================================================================
//Display Disbursement Screen
DisbursementVoucher cv = new DisbursementVoucher();
cv.Show();
//=========================================================================================
// Header Information
//=========================================================================================
SqlDataAdapter adapter3 = new SqlDataAdapter("SELECT * FROM Disbursement_Header WHERE CV_No = '" + cvno + "'", con);
DataTable dt3 = new DataTable();
adapter3.Fill(dt3);
cv.txtCVNo.Text = cvno;
cv.dtCVDate.Text = dt3.Rows[0].ItemArray[1].ToString();
if (dt3.Rows[0].ItemArray[3].ToString() == "True")
{
cv.radioClient.Checked = true;
}
else
{
cv.radioMember.Checked = true;
}
cv.txtPayee.Text = dt3.Rows[0].ItemArray[5].ToString();
if (dt3.Rows[0].ItemArray[4].ToString() != "" || dt3.Rows[0].ItemArray[4].ToString() != string.Empty)
{
Classes.clsDisbursement.userID = Convert.ToInt32(dt3.Rows[0].ItemArray[4].ToString());
cv.txtPayeeName.Text = clsDisbursement.fullName(Convert.ToInt32(dt3.Rows[0].ItemArray[4].ToString()));
}
else
{
cv.txtPayeeName.Text = clsDisbursement.ClientName(dt3.Rows[0].ItemArray[5].ToString());
}
cv.txtLoanNo.Text = dt3.Rows[0].ItemArray[8].ToString();
cv.cmbTransaction.SelectedValue = dt3.Rows[0].ItemArray[13].ToString();
cv.cmbBank.SelectedValue = dt3.Rows[0].ItemArray[9].ToString();
cv.txtChequeNo.Text = dt3.Rows[0].ItemArray[10].ToString();
cv.dtChequeDate.Text = dt3.Rows[0].ItemArray[11].ToString();
cv.txtAmount.Text = Convert.ToDecimal(dt3.Rows[0].ItemArray[12].ToString()).ToString("#,0.00");
cv.txtParticular.Text = dt3.Rows[0].ItemArray[7].ToString();
//================================
// DISPLAY DETAILS
//================================
cv.dataGridView1.Rows.Clear();
clsDisbursement.loadDetails(cv.dataGridView1, cv.txtCVNo.Text);
//=========================================================================================
// Enable Buttons
//=========================================================================================
cv.btnEdit.Enabled = true;
cv.btnPost.Enabled = true;
cv.btnCancel.Enabled = true;
cv.btnPrint.Enabled = true;
cv.btnPrintCheque.Enabled = true;
Alert.show("Loan# " + txtLoanNo.Text + " For Cheque Release", Alert.AlertType.success);
//Update loan net proceeds loan header
SqlCommand cmdLoanHeader = new SqlCommand();
cmdLoanHeader.Connection = con;
cmdLoanHeader.CommandText = "UPDATE Loan SET NetProceeds = '" + txtNetAmount.Text.Replace(",", "") + "', cv_no = '" + cvno + "', Status = '5' WHERE loan_no = '" + txtLoanNo.Text + "'";
cmdLoanHeader.CommandType = CommandType.Text;
cmdLoanHeader.ExecuteNonQuery();
//Refresh the grid
clsLoanComputation.loadLoanApprovedDetails(dataGridView1, lblTotalCount);
//Set Loan Released Date
SqlCommand cmdRelease = new SqlCommand();
cmdRelease.Connection = con;
cmdRelease.CommandText = "sp_LoanReleasedDate";
cmdRelease.CommandType = CommandType.StoredProcedure;
cmdRelease.Parameters.AddWithValue("@LoanNo", txtLoanNo.Text);
cmdRelease.ExecuteNonQuery();
}
clearTextFIelds();
//RESET TO DEFAULT
button1.Enabled = false;
}
}
private void btnReplenish_Click(object sender, EventArgs e)
{
if (clsAccess.checkForInsertRestriction(lblTitle.Text, Classes.clsUser.Username) != true)
{
return;
}
if (dataGridView1.Rows.Count == 0)
{
Alert.show("No record(s) found.", Alert.AlertType.warning);
return;
}
string msg = Environment.NewLine + "Are you sure you want to proceed?";
DialogResult result = MessageBox.Show(this, msg, "PLDT Credit Cooperative", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (result == DialogResult.Yes)
{
//=================================================================================
//COnnection
//=================================================================================
using (SqlConnection con = new SqlConnection(global.connectString()))
{
con.Open();
string jvNo;
//=================================================================================
//Create JV For Replenished Withdrawal
//=================================================================================
//=================================================================================
//JOURNAL HEADER
//=================================================================================
SqlCommand cmdHeader = new SqlCommand();
cmdHeader.Connection = con;
cmdHeader.CommandText = "sp_InsertJournalHeader";
cmdHeader.CommandType = CommandType.StoredProcedure;
cmdHeader.Parameters.AddWithValue("@JV_Date", DateTime.Today.ToShortDateString());
cmdHeader.Parameters.AddWithValue("@userID", DBNull.Value);
cmdHeader.Parameters.AddWithValue("@AdjTo", DBNull.Value);
cmdHeader.Parameters.AddWithValue("@Particular", "REPLENISHMENT OF SAVINGS WITHDRAWAL");
cmdHeader.Parameters.AddWithValue("@Loan_No", DBNull.Value);
cmdHeader.Parameters.AddWithValue("@Posted", true);
cmdHeader.Parameters.AddWithValue("@Transaction_Type", "TRAN001");
cmdHeader.Parameters.AddWithValue("@summarize", true);
cmdHeader.Parameters.AddWithValue("@Prepared_By", Classes.clsUser.Username);
cmdHeader.Parameters.AddWithValue("@Poseted_By", Classes.clsUser.Username);
cmdHeader.ExecuteNonQuery();
//=================================================================================
//GET JV
//=================================================================================
SqlCommand cmdJV = new SqlCommand();
cmdJV.Connection = con;
cmdJV.CommandText = "sp_GetJVNoAfterSaving";
cmdJV.CommandType = CommandType.StoredProcedure;
cmdJV.Parameters.AddWithValue("@jv_date", DateTime.Today.ToShortDateString());
cmdJV.Parameters.AddWithValue("@Prepared_By", Classes.clsUser.Username);
SqlDataAdapter adapter = new SqlDataAdapter(cmdJV);
DataTable dt = new DataTable();
adapter.Fill(dt);
if (dt.Rows.Count > 0)
{
jvNo = dt.Rows[0].ItemArray[0].ToString();
}
else
{
return;
}
//=================================================================================
//JOURNAL DETAILS
//=================================================================================
if (dataGridView1.Rows.Count > 0)
{
foreach (DataGridViewRow row in dataGridView1.Rows)
{
//Adding all the Debit 300.1 code
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandText = "sp_InsertJournalDetail";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@JV_No", jvNo);
cmd.Parameters.AddWithValue("@Account_Code", "300.1");
cmd.Parameters.AddWithValue("@userID", Convert.ToInt32(row.Cells["userID"].Value));
cmd.Parameters.AddWithValue("@Subsidiary_Code", row.Cells["EmployeeID"].Value);
cmd.Parameters.AddWithValue("@Loan_No", DBNull.Value);
cmd.Parameters.AddWithValue("@Debit", Convert.ToDecimal(row.Cells["AmtWithdrawn"].Value));
cmd.Parameters.AddWithValue("@Credit", Convert.ToDecimal("0.00"));
cmd.ExecuteNonQuery();
}
SqlCommand cmd1 = new SqlCommand();
cmd1.Connection = con;
cmd1.CommandText = "sp_InsertJournalDetail";
cmd1.CommandType = CommandType.StoredProcedure;
cmd1.Parameters.AddWithValue("@JV_No", jvNo);
cmd1.Parameters.AddWithValue("@Account_Code", "104");
cmd1.Parameters.AddWithValue("@userID", DBNull.Value);
cmd1.Parameters.AddWithValue("@Subsidiary_Code", DBNull.Value);
cmd1.Parameters.AddWithValue("@Loan_No", DBNull.Value);
cmd1.Parameters.AddWithValue("@Debit", Convert.ToDecimal("0.00"));
cmd1.Parameters.AddWithValue("@Credit", Convert.ToDecimal(txtAmount.Text));
cmd1.ExecuteNonQuery();
}
//=================================================================================
//Replenish Withdrawal
//=================================================================================
if (dataGridView1.Rows.Count > 0)
{
//Get all details of withdrawal slip in temp table
foreach (DataGridViewRow row in dataGridView1.Rows)
{
//For Saving of Replenishment and JVNO
SqlCommand cmd2 = new SqlCommand();
cmd2.Connection = con;
cmd2.CommandText = "sp_UpdateReplenishAndJVNoWithdrawalSlip";
cmd2.CommandType = CommandType.StoredProcedure;
cmd2.Parameters.AddWithValue("@Withdrawal_Slip_No", row.Cells["Withdrawal_Slip_No"].Value);
cmd2.Parameters.AddWithValue("@JV_No", jvNo);
cmd2.Parameters.AddWithValue("@Posted_By", Classes.clsUser.Username);
cmd2.ExecuteNonQuery();
}
}
//=================================================================================
//Call Disbursement
//=================================================================================
DisbursementVoucher cv = new DisbursementVoucher();
cv.ForReplenishment();
foreach (Form form in Application.OpenForms)
{
if (form.GetType() == typeof(DisbursementVoucher))
{
form.Activate();
DisbursementVoucher cv1 = new DisbursementVoucher();
cv1 = (DisbursementVoucher)Application.OpenForms["DisbursementVoucher"];
cv1.dataGridView1.Rows[0].Cells[3].Value = txtAmount.Text; //==Debit
cv1.dataGridView1.Rows[1].Cells[4].Value = txtAmount.Text; //==Credit
cv1.cmbTransaction.SelectedValue = "TRAN001";
cv1.cmbBank.SelectedValue = "PCIB";
cv1.txtAmount.Text = txtAmount.Text;
cv1.txtParticular.Text = "REPLENISHMENT OF SAVINGS WITHDRAWAL - IN REFERENCE TO JV#" + jvNo;
cv1.radioClient.Checked = true;
cv1.txtPayee.Text = "CASHIER";
cv1.txtPayeeName.Text = clsCashReplenishment.getCashier();
return;
}
}
cv.dataGridView1.Rows.Add(1);
//for (int i = 0; i < 1; i++)
//{
// cv.dataGridView1.Rows[i].Cells[3].Value = txtAmount.Text; //==Debit
// cv.dataGridView1.Rows[1].Cells[4].Value = txtAmount.Text; //==Credit
//}
cv.getBankFromWithdrawal = "";
cv.getTransaction = "TRAN001";
cv.cmbBank.SelectedValue = "PCIB";
cv.txtAmount.Text = txtAmount.Text;
cv.txtParticular.Text = "REPLENISHMENT OF SAVINGS WITHDRAWAL - IN REFERENCE TO JV#" + jvNo;
cv.radioClient.Checked = true;
cv.txtPayee.Text = "CASHIER";
cv.txtPayeeName.Text = clsCashReplenishment.getCashier();
cv.dataGridView1.Rows[0].Cells[0].Value = "104";
cv.dataGridView1.Rows[0].Cells[3].Value = txtAmount.Text;
int rowId = cv.dataGridView1.Rows.Add();
// Grab the new row!
DataGridViewRow row2 = cv.dataGridView1.Rows[rowId];
// Add the data
row2.Cells[0].Value = "102.17";
row2.Cells[4].Value = txtAmount.Text;
//put jv to disbursement
cv.jvno = jvNo;
//=================================================================================
//Load Data Replenish
//=================================================================================
clsCashReplenishment.loadReplenishment(dataGridView1, Convert.ToInt32(txtRangingFrom.Text), Convert.ToInt32(txtRangingTo.Text), dtFrom.Text, dtTo.Text, txtTotalNoSlips, txtAmount);
//=================================================================================
//MessageBox Before Showing Disbursement
//=================================================================================
this.Close();
cv.Show();
}
Alert.show("Cash withdrawal successfully replenished.", Alert.AlertType.success);
} //User Click No For Return
else
{
return;
}
}
private void btnUse_Click(object sender, EventArgs e)
{
if (whosLookUp == "2") //From OR
{
//==========================================================================================
// CASH RECEIPT CODE
//==========================================================================================
CashReceiptVoucher cashOR = new CashReceiptVoucher();
foreach (Form form in Application.OpenForms)
{
if (form.GetType() == typeof(CashReceiptVoucher))
{
//===============================================================================
// If form is already open
//===============================================================================
form.Activate();
cashOR = (CashReceiptVoucher)Application.OpenForms["CashReceiptVoucher"];
cashOR.txtPayorID.Text = dataGridView1.SelectedRows[0].Cells["Client_Code"].Value.ToString();
cashOR.txtPayorName.Text = dataGridView1.SelectedRows[0].Cells["Name"].Value.ToString();
this.Close();
return;
}
}
cashOR.txtPayorID.Text = dataGridView1.SelectedRows[0].Cells["Client_Code"].Value.ToString();
cashOR.txtPayorName.Text = dataGridView1.SelectedRows[0].Cells["Name"].Value.ToString();
cashOR.Show();
this.Close();
}
else
{
DisbursementVoucher disbursement = new DisbursementVoucher();
foreach (Form form in Application.OpenForms)
{
if (form.GetType() == typeof(DisbursementVoucher))
{
//===============================================================================
// If form is already open
//===============================================================================
form.Activate();
disbursement = (DisbursementVoucher)Application.OpenForms["DisbursementVoucher"];
disbursement.txtPayee.Text = dataGridView1.SelectedRows[0].Cells["Client_Code"].Value.ToString();
disbursement.txtPayeeName.Text = dataGridView1.SelectedRows[0].Cells["Name"].Value.ToString();
disbursement.radioClient.Checked = true;
Classes.clsDisbursement.userID = 0;
this.Close();
return;
}
}
disbursement.txtPayee.Text = dataGridView1.SelectedRows[0].Cells["Client_Code"].Value.ToString();
disbursement.txtPayeeName.Text = dataGridView1.SelectedRows[0].Cells["Name"].Value.ToString();
disbursement.radioClient.Checked = true;
Classes.clsDisbursement.userID = 0;
disbursement.Show();
this.Close();
disbursement.Show();
}
}
public void btnRelease_Click(object sender, EventArgs e)
{
if (txtWithdrawalSlipNo.Text == "")
{
Alert.show("No withdrawal for release.", Alert.AlertType.error);
return;
}
if (status.Text == "POSTED")
{
Alert.show("This Withdrawal Already Posted!", Alert.AlertType.warning);
return;
}
if (txtCancelledBy.Text != "")
{
Alert.show("This Withdrawal Already Cancelled!", Alert.AlertType.error);
return;
}
if (dtReleaseDate.Text != "")
{
Alert.show("This Withdrawal Already Released!", Alert.AlertType.error);
return;
}
using (SqlConnection con = new SqlConnection(global.connectString()))
{
con.Open();
if (radioCheque.Checked == true)
{
SqlDataAdapter adapter = new SqlDataAdapter("SELECT CV_No FROM Withdrawal_Slip WHERE Withdrawal_Slip_No = '" + txtWithdrawalSlipNo.Text + "'", con);
DataTable dt = new DataTable();
adapter.Fill(dt);
if (dt.Rows[0].ItemArray[0].ToString() != "")
{
}
}
string msg = Environment.NewLine + "Are you sure you want to release this?";
DialogResult result = MessageBox.Show(this, msg, "PLDT Credit Cooperative", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (result == DialogResult.Yes)
{
if (btnRelease.Text == "RELEASE")
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandText = "sp_ReleaseWithdrawalDate";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Withdrawal_Slip_No", txtWithdrawalSlipNo.Text);
cmd.ExecuteNonQuery();
//Put the date to the textbox
dtReleaseDate.Text = Convert.ToDateTime(clsSavingsDataEntry.returnReleaseDate(txtWithdrawalSlipNo.Text)).ToShortDateString();
status.Visible = true;
status.Text = "RELEASED";
//refresh
savings = (Savings)Application.OpenForms["Savings"];
savings.refreshData();
btnSave.Text = "NEW";
//=================================================================================
//MessageBox Before Showing Disbursement
//=================================================================================
this.Close();
Alert.show("Successfully Released!", Alert.AlertType.success);
}
//CHECK IF WITHDRAWABLE METHOD IS CHECK
//IF CHECK GO TO DISBURSEMENT AND SAVE THE RELEASED VALUE
//===========================================================================================================
if (radioCheque.Checked == true)
{
//Put true for disbursement posting if withdrawal from check
Classes.clsDisbursement.releaseCashWithdrawal = true;
Classes.clsDisbursement.slipFromWithdrawal = txtWithdrawalSlipNo.Text;
//=================================================================================
//Call Disbursement
//=================================================================================
DisbursementVoucher cv = new DisbursementVoucher();
//03-10-2019
cv.ForReplenishment();
cv.fromWithdrawal = true;
cv.dataGridView1.Rows.Add(1);
cv.getTransaction = "TRAN001";
cv.getBankFromWithdrawal = cmbBankName.SelectedValue.ToString();
Classes.clsDisbursement.userID = Classes.clsSavingsDataEntry.userID;
cv.txtChequeNo.Text = txtCheque.Text;
cv.txtAmount.Text = txtAmountWithdrawn.Text;
slip = txtWithdrawalSlipNo.Text;
slip = slip.Substring(12, 4);
cv.txtParticular.Text = "Withdrawal of Savings per Slip receipt no. " + slip + " Dated : " + DateTime.Now.ToShortDateString();
cv.radioMember.Checked = true;
cv.txtPayee.Text = txtEmployeeID.Text;
cv.txtPayeeName.Text = txtName.Text;
cv.dataGridView1.Rows[0].Cells[0].Value = "300.1";
cv.dataGridView1.Rows[0].Cells[3].Value = txtAmountWithdrawn.Text;
//Put the Subsidiary or the Member ID and Name in Disbursement Details
cv.dataGridView1.Rows[0].Cells[1].Value = txtEmployeeID.Text + " - " + txtName.Text;
cv.dataGridView1.Rows[0].Cells[5].Value = Classes.clsSavingsDataEntry.userID;
int rowId = cv.dataGridView1.Rows.Add();
// Grab the new row!
DataGridViewRow row2 = cv.dataGridView1.Rows[rowId];
//Added March 10 , 2019 as Per Sir Manny Request For Cheque Release
SqlDataAdapter adapterBank = new SqlDataAdapter("SELECT Bank_Account_Code FROM Bank WHERE Bank_Code ='" + cmbBankName.SelectedValue.ToString() + "'", con);
DataTable dtBank = new DataTable();
adapterBank.Fill(dtBank);
// Add the data
row2.Cells[0].Value = dtBank.Rows[0].ItemArray[0].ToString();
row2.Cells[4].Value = txtAmountWithdrawn.Text;
cv.btnEdit.Enabled = false;
cv.btnPost.Enabled = true;
cv.btnCancel.Enabled = true;
cv.btnPrint.Enabled = true;
cv.btnPrintCheque.Enabled = true;
cv.btnSearch.Enabled = false;
cv.dataGridView1.Enabled = false;
cv.txtChequeNo.Enabled = false;
cv.dtChequeDate.Enabled = false;
cv.txtAmount.Enabled = false;
cv.txtParticular.Enabled = false;
cv.btnSearchPayee.Enabled = false;
cv.btnSearchLoan.Enabled = false;
cv.btnNew.Enabled = false;
cv.btnNew.Text = "NEW";
//BEFORE NEXT WINDOW REMOVE THE OPEN TRANSACTION
//============================================================
// REMOVE OPEN FORM
//============================================================
clsOpen.deleteTransaction("Savings", txtWithdrawalSlipNo.Text);
cv.Show();
//=================================================================================
//SAVING DISBURSEMENT
//=================================================================================
SqlCommand cmdHeader = new SqlCommand();
cmdHeader.Connection = con;
cmdHeader.CommandText = "sp_InsertDisbursementHeader";
cmdHeader.CommandType = CommandType.StoredProcedure;
cmdHeader.Parameters.AddWithValue("@CVDate", DateTime.Now.ToShortDateString());
//FOr Payee Type
//Member = 0 Client = 1
if (cv.radioMember.Checked == true)
{
cmdHeader.Parameters.AddWithValue("@Payee_Type", "0");
}
else
{
cmdHeader.Parameters.AddWithValue("@Payee_Type", "1");
}
//Check if Theres a Member or Client
if (Classes.clsDisbursement.userID.ToString() == "")
{
cmdHeader.Parameters.AddWithValue("@userID", DBNull.Value);
}
else if (Classes.clsDisbursement.userID == 0)
{
cmdHeader.Parameters.AddWithValue("@userID", DBNull.Value);
}
else
{
cmdHeader.Parameters.AddWithValue("@userID", Classes.clsDisbursement.userID.ToString());
}
cmdHeader.Parameters.AddWithValue("@Payee", cv.txtPayee.Text);
cmdHeader.Parameters.AddWithValue("@Payee_Name", cv.txtPayeeName.Text);
cmdHeader.Parameters.AddWithValue("@Particulars", cv.txtParticular.Text);
cmdHeader.Parameters.AddWithValue("@Loan_No", cv.txtLoanNo.Text);
cmdHeader.Parameters.AddWithValue("@Bank_Code", cv.cmbBank.SelectedValue);
cmdHeader.Parameters.AddWithValue("@Check_No", cv.txtChequeNo.Text);
cmdHeader.Parameters.AddWithValue("@Check_Date", cv.dtChequeDate.Text);
cmdHeader.Parameters.AddWithValue("@Amount", Convert.ToDecimal(cv.txtAmount.Text));
cmdHeader.Parameters.AddWithValue("@Transaction_Type", cv.cmbTransaction.SelectedValue);
cmdHeader.Parameters.AddWithValue("@Prepared_By", Classes.clsUser.Username);
cmdHeader.ExecuteNonQuery();
//Get The CV NO.
SqlCommand cmdCV = new SqlCommand();
cmdCV.Connection = con;
cmdCV.CommandText = "sp_GetCVNoAfterSaving";
cmdCV.CommandType = CommandType.StoredProcedure;
cmdCV.Parameters.AddWithValue("@CV_Date", DateTime.Now.ToShortDateString());
cmdCV.Parameters.AddWithValue("@Prepared_By", Classes.clsUser.Username);
SqlDataAdapter adapter = new SqlDataAdapter(cmdCV);
DataTable dt = new DataTable();
adapter.Fill(dt);
if (dt.Rows.Count > 0)
{
cv.txtCVNo.Text = dt.Rows[0].ItemArray[0].ToString();
}
else
{
return;
}
//Insert CV Details
//SAVE DETAILS ============================================================================================
if (cv.dataGridView1.Rows.Count > 0)
{
foreach (DataGridViewRow row in cv.dataGridView1.Rows)
{
if (row.Cells[0].Value != null)
{
SqlCommand cmdDetail = new SqlCommand();
cmdDetail.Connection = con;
cmdDetail.CommandText = "sp_InsertDisbursementDetail";
cmdDetail.CommandType = CommandType.StoredProcedure;
cmdDetail.Parameters.AddWithValue("@CV_No", cv.txtCVNo.Text);
cmdDetail.Parameters.AddWithValue("@Account_Code", row.Cells[0].Value);
if (Convert.ToInt32(row.Cells[5].Value) == 0)
{
cmdDetail.Parameters.AddWithValue("@userID", DBNull.Value);
}
else
{
cmdDetail.Parameters.AddWithValue("@userID", Convert.ToInt32(row.Cells[5].Value));
}
if (row.Cells[1].Value != null)
{
cmdDetail.Parameters.AddWithValue("@Subsidiary_Code", row.Cells[1].Value);
}
else
{
cmdDetail.Parameters.AddWithValue("@Subsidiary_Code", DBNull.Value);
}
if (row.Cells[2].Value != null)
{
cmdDetail.Parameters.AddWithValue("@Loan_No", row.Cells[2].Value);
}
else
{
cmdDetail.Parameters.AddWithValue("@Loan_No", DBNull.Value);
}
cmdDetail.Parameters.AddWithValue("@Debit", Convert.ToDecimal(row.Cells[3].Value));
cmdDetail.Parameters.AddWithValue("@Credit", Convert.ToDecimal(row.Cells[4].Value));
cmdDetail.ExecuteNonQuery();
}
}
}
//=================================================================================
// SAVE WITHDRAWAL SLIP FOR CHANGING PURPOSES
//=================================================================================
SqlCommand cmdWD = new SqlCommand();
cmdWD.Connection = con;
cmdWD.CommandText = "UPDATE Disbursement_Header SET wd_slip_no = '" + txtWithdrawalSlipNo.Text + "' WHERE CV_No = '" + cv.txtCVNo.Text + "'";
cmdWD.CommandType = CommandType.Text;
cmdWD.ExecuteNonQuery();
//=================================================================================
// SAVE CV NO FOR WITHDRAWAL SLIP
//=================================================================================
SqlCommand cmdWDCV = new SqlCommand();
cmdWDCV.Connection = con;
cmdWDCV.CommandText = "UPDATE Withdrawal_Slip SET cv_no = '" + cv.txtCVNo.Text + "' WHERE Withdrawal_Slip_No = '" + txtWithdrawalSlipNo.Text + "'";
cmdWDCV.CommandType = CommandType.Text;
cmdWDCV.ExecuteNonQuery();
Alert.show("Withdrawal voucher successfully prepared.", Alert.AlertType.success);
SqlDataAdapter adapterchck = new SqlDataAdapter("SELECT CV_No FROM Withdrawal_Slip WHERE Withdrawal_Slip_No = '" + txtWithdrawalSlipNo.Text + "'", con);
DataTable dtchck = new DataTable();
adapterchck.Fill(dtchck);
status.Text = "FOR RELEASE - CV#" + dtchck.Rows[0].ItemArray[0].ToString();
status.Visible = true;
btnRelease.Enabled = false;
}
}
else
{
return;
}
}
}
private void button2_Click(object sender, EventArgs e)
{
switch (Classes.clsLookUp.whosLookUp)
{
case "0": //Savings
SavingsDataEntry savingsDataentry = new SavingsDataEntry();
//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;
}
//for dependent purposes
//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;
}
}
foreach (Form form in Application.OpenForms)
{
//Start Validation first if selected account is hold
if (form.GetType() == typeof(SavingsDataEntry))
{
//===============================================================================
// If form is already open
//===============================================================================
form.Activate();
savingsDataentry = (SavingsDataEntry)Application.OpenForms["SavingsDataEntry"];
savingsDataentry.txtEmployeeID.Text = dataGridView1.SelectedRows[0].Cells["EmployeeID"].Value.ToString();
Classes.clsSavingsDataEntry.userID = Convert.ToInt32(dataGridView1.SelectedRows[0].Cells["userID"].Value.ToString());
savingsDataentry.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["Savings_Deposit"].Value == DBNull.Value)
{
savingsDataentry.txtSDDeduction.Text = "0.00";
}
else
{
savingsDataentry.txtSDDeduction.Text = Convert.ToDecimal(dataGridView1.SelectedRows[0].Cells["Savings_Deposit"].Value).ToString("#,##0.00");
}
savingsDataentry.txtCurrentBalanceBeforeWithdrawal.Text = clsSavingsDataEntry.returnMembersSaving(dataGridView1.SelectedRows[0].Cells["userID"].Value.ToString());
//If theres a deposited check
savingsDataentry.txtdepositedCheque.Text = clsSavings.returnDepositedChequeAmount(Convert.ToInt32(dataGridView1.SelectedRows[0].Cells["userID"].Value.ToString()));
savingsDataentry.txtDepositedDate.Text = clsSavings.returnDepositedChequeDate(Convert.ToInt32(dataGridView1.SelectedRows[0].Cells["userID"].Value.ToString()));
//MINUS THE CHECK AMOUNT
if (savingsDataentry.txtdepositedCheque.Text != "")
{
Decimal widAmnt;
widAmnt = Convert.ToDecimal(savingsDataentry.txtCurrentBalanceBeforeWithdrawal.Text) - Convert.ToDecimal(savingsDataentry.txtdepositedCheque.Text);
savingsDataentry.txtWithdrawalBalance.Text = widAmnt.ToString("#,0.00");
}
else
{
savingsDataentry.txtWithdrawalBalance.Text = clsSavingsDataEntry.returnMembersSaving(dataGridView1.SelectedRows[0].Cells["userID"].Value.ToString());
}
savingsDataentry.txtCompany.Text = clsSavingsDataEntry.returnCompanyDescription(dataGridView1.SelectedRows[0].Cells["Company_Code"].Value.ToString());
savingsDataentry.txtLastDateWithdrawal.Text = clsSavings.returnLastWithdrawalDate(Convert.ToInt32(dataGridView1.SelectedRows[0].Cells["userID"].Value.ToString()));
//For Account number and Bank Code
savingsDataentry.txtAccntNo.Text = dataGridView1.SelectedRows[0].Cells["ATM_Account_No"].Value.ToString();
savingsDataentry.txtBankCode.Text = dataGridView1.SelectedRows[0].Cells["Bank_Code"].Value.ToString();
savingsDataentry.txtAmountWithdrawn.Focus();
this.Close();
return;
}
}
savingsDataentry.txtEmployeeID.Text = dataGridView1.SelectedRows[0].Cells["EmployeeID"].Value.ToString();
savingsDataentry.txtLastDateWithdrawal.Text = clsSavings.returnLastWithdrawalDate(Convert.ToInt32(dataGridView1.SelectedRows[0].Cells["userID"].Value.ToString()));
Classes.clsSavingsDataEntry.userID = Convert.ToInt32(dataGridView1.SelectedRows[0].Cells["userID"].Value.ToString());
savingsDataentry.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["Savings_Deposit"].Value == DBNull.Value)
{
savingsDataentry.txtSDDeduction.Text = "0.00";
}
else
{
savingsDataentry.txtSDDeduction.Text = Convert.ToDecimal(dataGridView1.SelectedRows[0].Cells["Savings_Deposit"].Value).ToString("#,##0.00");
}
savingsDataentry.txtCurrentBalanceBeforeWithdrawal.Text = clsSavingsDataEntry.returnMembersSaving(dataGridView1.SelectedRows[0].Cells["userID"].Value.ToString());
//If theres a deposited check
savingsDataentry.txtdepositedCheque.Text = clsSavings.returnDepositedChequeAmount(Convert.ToInt32(dataGridView1.SelectedRows[0].Cells["userID"].Value.ToString()));
savingsDataentry.txtDepositedDate.Text = clsSavings.returnDepositedChequeDate(Convert.ToInt32(dataGridView1.SelectedRows[0].Cells["userID"].Value.ToString()));
//MINUS THE CHECK AMOUNT
if (savingsDataentry.txtdepositedCheque.Text != "")
{
Decimal widAmnt;
widAmnt = Convert.ToDecimal(savingsDataentry.txtCurrentBalanceBeforeWithdrawal.Text) - Convert.ToDecimal(savingsDataentry.txtdepositedCheque.Text);
savingsDataentry.txtWithdrawalBalance.Text = widAmnt.ToString("#,0.00");
}
else
{
savingsDataentry.txtWithdrawalBalance.Text = clsSavingsDataEntry.returnMembersSaving(dataGridView1.SelectedRows[0].Cells["userID"].Value.ToString());
}
savingsDataentry.txtCompany.Text = clsSavingsDataEntry.returnCompanyDescription(dataGridView1.SelectedRows[0].Cells["Company_Code"].Value.ToString());
//For Account number and Bank Code
savingsDataentry.txtAccntNo.Text = dataGridView1.SelectedRows[0].Cells["ATM_Account_No"].Value.ToString();
savingsDataentry.txtBankCode.Text = dataGridView1.SelectedRows[0].Cells["Bank_Code"].Value.ToString();
savingsDataentry.Show();
this.Close();
savingsDataentry.txtAmountWithdrawn.Focus();
savingsDataentry.Show();
break;
case "1":
//==========================================================================================
// DISBURSEMENT CODE
//==========================================================================================
DisbursementVoucher disbursement = new DisbursementVoucher();
foreach (Form form in Application.OpenForms)
{
if (form.GetType() == typeof(DisbursementVoucher))
{
//===============================================================================
// If form is already open
//===============================================================================
form.Activate();
disbursement = (DisbursementVoucher)Application.OpenForms["DisbursementVoucher"];
Classes.clsDisbursement.userID = Convert.ToInt32(dataGridView1.SelectedRows[0].Cells["userID"].Value.ToString());
LoanLookUpProcess.clsLoanLookUpMember.userid = Convert.ToInt32(dataGridView1.SelectedRows[0].Cells["userID"].Value.ToString());
disbursement.txtLoanNo.Text = "";
disbursement.txtLoanType.Text = "";
disbursement.txtPayee.Text = dataGridView1.SelectedRows[0].Cells["EmployeeID"].Value.ToString();
disbursement.txtPayeeName.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();
this.Close();
return;
}
}
Classes.clsDisbursement.userID = Convert.ToInt32(dataGridView1.SelectedRows[0].Cells["userID"].Value.ToString());
LoanLookUpProcess.clsLoanLookUpMember.userid = Convert.ToInt32(dataGridView1.SelectedRows[0].Cells["userID"].Value.ToString());
disbursement.txtLoanNo.Text = "";
disbursement.txtLoanType.Text = "";
disbursement.txtPayee.Text = dataGridView1.SelectedRows[0].Cells["EmployeeID"].Value.ToString();
disbursement.txtPayeeName.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();
disbursement.Show();
this.Close();
break;
case "2":
//==========================================================================================
// CASH RECEIPT CODE
//==========================================================================================
CashReceiptVoucher cashOR = new CashReceiptVoucher();
foreach (Form form in Application.OpenForms)
{
if (form.GetType() == typeof(CashReceiptVoucher))
{
//===============================================================================
// If form is already open
//===============================================================================
form.Activate();
cashOR = (CashReceiptVoucher)Application.OpenForms["CashReceiptVoucher"];
Classes.clsCashReceipt.userID = Convert.ToInt32(dataGridView1.SelectedRows[0].Cells["userID"].Value.ToString());
cashOR.txtPayorID.Text = dataGridView1.SelectedRows[0].Cells["EmployeeID"].Value.ToString();
cashOR.txtPayorName.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();
cashOR.txtPayorCompany.Text = clsCash.returnCompanyDescription(dataGridView1.SelectedRows[0].Cells["Company_Code"].Value.ToString());
this.Close();
return;
}
}
Classes.clsCashReceipt.userID = Convert.ToInt32(dataGridView1.SelectedRows[0].Cells["userID"].Value.ToString());
cashOR.txtPayorID.Text = dataGridView1.SelectedRows[0].Cells["EmployeeID"].Value.ToString();
cashOR.txtPayorName.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();
cashOR.txtPayorCompany.Text = clsCash.returnCompanyDescription(dataGridView1.SelectedRows[0].Cells["Company_Code"].Value.ToString());
cashOR.Show();
this.Close();
break;
}
}