private void dataGridView1_CellDoubleClick(object sender, DataGridViewCellEventArgs e) { if (dataGridView1.SelectedRows.Count == 0) { //No Data to be edit Alert.show("Please select transaction you want to edit.", Alert.AlertType.warning); return; } if (dataGridView1.SelectedRows[0].Cells["ORNumber"].Value.ToString() != "") { return; } Classes.clsPDCManagement.id = Convert.ToInt32(dataGridView1.SelectedRows[0].Cells["id"].Value.ToString()); Classes.clsPDCManagement.userid = Convert.ToInt32(dataGridView1.SelectedRows[0].Cells["userid"].Value.ToString()); txtEmployeeID.Text = dataGridView1.SelectedRows[0].Cells["EmployeeID"].Value.ToString(); txtName.Text = dataGridView1.SelectedRows[0].Cells["EmpName"].Value.ToString(); //for category if (dataGridView1.SelectedRows[0].Cells["LoanType"].Value.ToString() == "SD") { //Savings radioSavings.Checked = true; txtLoanType.Text = ""; txtLoanNumber.Text = ""; } else if (dataGridView1.SelectedRows[0].Cells["LoanType"].Value.ToString() == "SC") { //Share Capital radioShareCapital.Checked = true; txtLoanType.Text = ""; txtLoanNumber.Text = ""; } else { //Loans radioLoan.Checked = true; txtLoanType.Text = dataGridView1.SelectedRows[0].Cells["LoanType"].Value.ToString(); } txtLoanNumber.Text = dataGridView1.SelectedRows[0].Cells["LoanNumber"].Value.ToString(); dtDatePrepared.Text = dataGridView1.SelectedRows[0].Cells["DatePrepared"].Value.ToString(); cmbBank.Text = clsMembership.returnBankName(dataGridView1.SelectedRows[0].Cells["Bank"].Value.ToString()); dtChequeDate.Text = dataGridView1.SelectedRows[0].Cells["ChequeDate"].Value.ToString(); txtChequeNo.Text = dataGridView1.SelectedRows[0].Cells["ChequeNo"].Value.ToString(); txtAmount.Text = dataGridView1.SelectedRows[0].Cells["Amount"].Value.ToString(); //Put The last Value Classes.clsPDCManagement.LastValueChequeNo = dataGridView1.SelectedRows[0].Cells["ChequeNo"].Value.ToString(); Classes.clsPDCManagement.LastValueAmount = Convert.ToDecimal(dataGridView1.SelectedRows[0].Cells["Amount"].Value.ToString()); //Disable Buttons btnAddCheck.Enabled = false; btnEdit.Enabled = true; btnEdit.Text = "UPDATE"; btnClear.Text = "CANCEL"; btnSearchPayee.Enabled = false; button3.Enabled = false; dtDatePrepared.Enabled = false; }
private void btnNew_Click(object sender, EventArgs e) { if (clsAccess.checkForInsertRestriction(lblTitle.Text, Classes.clsUser.Username) != true) { return; } if (btnNew.Text == "SAVE") { //Required Fields if (RequiredFields(txtCode, txtDescription, txtBranch, txtAccountNo) == true) { Alert.show("All fields with (*) are required.", Alert.AlertType.warning); return; } //Check if theres a duplicate entry for this newly insert CODE if (global.CheckDuplicateEntryParam("Bank_Code", txtCode.Text, "Bank") == true) { Alert.show("Bank Code already exist.", Alert.AlertType.error); return; } //Check description for duplicate if (global.CheckDuplicateEntryParam("Bank_Name", txtDescription.Text, "Bank") == true) { Alert.show("Bank Name already exist.", Alert.AlertType.error); return; } //If all criteria is successfully meet we now proceed to saving code using (SqlConnection con = new SqlConnection(global.connectString())) { con.Open(); cmd = new SqlCommand(); cmd.Connection = con; cmd.CommandText = "sp_InsertBank"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Bank_Code", txtCode.Text.ToUpper()); cmd.Parameters.AddWithValue("@Bank_Name", txtDescription.Text.ToUpper()); cmd.Parameters.AddWithValue("@Branch", txtBranch.Text); cmd.Parameters.AddWithValue("@Account_No", txtAccountNo.Text); cmd.Parameters.AddWithValue("@Bank_Account_Code", cmbBankAccount.SelectedValue); cmd.Parameters.AddWithValue("@Contact_Person", txtContactPerson.Text); cmd.Parameters.AddWithValue("@Position", txtPosition.Text); cmd.Parameters.AddWithValue("@Address", txtAddress.Text); cmd.ExecuteNonQuery(); } //Success Message Alert.show("Successfully added.", Alert.AlertType.success); //load Banks clsbank.loadBanks(dataGridView1, "Bank"); cleartxtField(); restoreBtn(); disabletxtField(); } else { btnNew.Text = "SAVE"; enabletxtField(); cleartxtField(); btnClose.Text = "CANCEL"; btnEdit.Enabled = false; btnDelete.Enabled = false; } }
private void btnAddCheck_Click(object sender, EventArgs e) { if (txtEmployeeID.Text == "") { Alert.show("Please select Member first.", Alert.AlertType.error); return; } if (radioLoan.Checked == true) { if (txtLoanType.Text == "") { Alert.show("Please select Loan first.", Alert.AlertType.error); return; } } if (cmbBank.Text == "") { Alert.show("Please select Bank first.", Alert.AlertType.error); return; } if (txtChequeNo.Text == "") { Alert.show("Cheque Number is required.", Alert.AlertType.error); return; } if (txtAmount.Text == "") { Alert.show("Amount is required.", Alert.AlertType.error); return; } string ssl; //Check for validation for the same cheque no. if (clsPDCManagement.CheckChequeNoIfUsed(txtChequeNo.Text) == true) { //cheque no already used, check if the category is the same. //if category is the same end else continue if (radioLoan.Checked == true) { if (clsPDCManagement.checkCategory(radioLoan.Text, txtChequeNo.Text, txtLoanType.Text) == true) { //Error ssl = "Cheque number cannot be used for " + System.Environment.NewLine + "2 or more loans of the same type."; Alert.show(ssl, Alert.AlertType.error); return; } } else if (radioSavings.Checked == true) { if (clsPDCManagement.checkCategory(radioSavings.Text, txtChequeNo.Text, "") == true) { //Error ssl = "Cheque number cannot be used for " + System.Environment.NewLine + "same category (SD)."; Alert.show(ssl, Alert.AlertType.error); return; } } else { if (clsPDCManagement.checkCategory(radioShareCapital.Text, txtChequeNo.Text, "") == true) { //Error ssl = "Cheque number cannot be used for " + System.Environment.NewLine + "same category (SC)."; Alert.show(ssl, Alert.AlertType.error); return; } } } if (clsPDCManagement.CheckChequeNoIfUsedByOthers(txtChequeNo.Text) == true) { string msg = Environment.NewLine + "Cheque number already used, " + Environment.NewLine + "Do you want to proceed?"; DialogResult result = MessageBox.Show(this, msg, "PLDT Credit Cooperative", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (result == DialogResult.No) { return; } } using (SqlConnection con = new SqlConnection(global.connectString())) { con.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = con; cmd.CommandText = "sp_InsertPDC"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@userid", Classes.clsPDCManagement.userid); cmd.Parameters.AddWithValue("@EmployeeID", txtEmployeeID.Text); cmd.Parameters.AddWithValue("@EmpName", txtName.Text); if (radioLoan.Checked == true) { cmd.Parameters.AddWithValue("@LoanType", txtLoanType.Text); cmd.Parameters.AddWithValue("@LoanNumber", txtLoanNumber.Text); } else if (radioSavings.Checked == true) { cmd.Parameters.AddWithValue("@LoanType", "SD"); cmd.Parameters.AddWithValue("@LoanNumber", txtLoanNumber.Text); } else { cmd.Parameters.AddWithValue("@LoanType", "SC"); cmd.Parameters.AddWithValue("@LoanNumber", txtLoanNumber.Text); } cmd.Parameters.AddWithValue("@Bank", cmbBank.SelectedValue); cmd.Parameters.AddWithValue("@ChequeDate", dtChequeDate.Text); cmd.Parameters.AddWithValue("@ChequeNo", txtChequeNo.Text); cmd.Parameters.AddWithValue("@Amount", txtAmount.Text.Replace(",", "")); cmd.Parameters.AddWithValue("@DatePrepared", dtDatePrepared.Text); cmd.Parameters.AddWithValue("@PreparedBy", Classes.clsUser.Username); cmd.ExecuteNonQuery(); Alert.show("Successfully added.", Alert.AlertType.success); //Remove Cheque Number and Amount txtChequeNo.Text = ""; txtAmount.Text = ""; //Refresh Datagridview clsPDCManagement.loadPDC(dataGridView1); } }
private void btnEdit_Click(object sender, EventArgs e) { if (clsAccess.checkForEditRestriction(lblTitle.Text, Classes.clsUser.Username) != true) { return; } if (txtCode.Text == "") { //No Data to be edit Alert.show("Please select bank you want to edit.", Alert.AlertType.warning); return; } if (btnEdit.Text == "EDIT") { btnEdit.Text = "UPDATE"; btnClose.Text = "CANCEL"; enabletxtField(); txtCode.Enabled = false; btnNew.Enabled = false; btnDelete.Enabled = false; } else { //UPDATE CODE HERE //Required Fields if (RequiredFields(txtCode, txtDescription, txtBranch, txtAccountNo) == true) { Alert.show("All fields with (*) are required.", Alert.AlertType.warning); return; } if (clsbank.CheckDuplicateEntry(txtDescription.Text, txtCode.Text, "Bank") == true) { Alert.show("Bank Name already exist.", Alert.AlertType.error); return; } using (SqlConnection con = new SqlConnection(global.connectString())) { con.Open(); cmd = new SqlCommand(); cmd.Connection = con; cmd.CommandText = "sp_UpdateBank"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Bank_Code", txtCode.Text.ToUpper()); cmd.Parameters.AddWithValue("@Bank_Name", txtDescription.Text.ToUpper()); cmd.Parameters.AddWithValue("@Branch", txtBranch.Text); cmd.Parameters.AddWithValue("@Account_No", txtAccountNo.Text); cmd.Parameters.AddWithValue("@Bank_Account_Code", cmbBankAccount.SelectedValue); cmd.Parameters.AddWithValue("@Contact_Person", txtContactPerson.Text); cmd.Parameters.AddWithValue("@Position", txtPosition.Text); cmd.Parameters.AddWithValue("@Address", txtAddress.Text); cmd.ExecuteNonQuery(); } //Success Message Alert.show("Successfully updated.", Alert.AlertType.success); //load Banks clsbank.loadBanks(dataGridView1, "Bank"); cleartxtField(); restoreBtn(); disabletxtField(); } }
private void btnNew_Click(object sender, EventArgs e) { //CONNECTION TO SQL SERVER AND STORED PROCEDURE using (SqlConnection con = new SqlConnection(global.connectString())) { con.Open(); saveTrigger = false; if (btnNew.Text == "SAVE") { //CHECK FIRST BEFORE SAVING if (txtDescription.Text == "") { Alert.show("All fields with (*) are required.", Alert.AlertType.warning); return; } else { //Check if theres a duplicate entry if (global.CheckDuplicateEntry(txtDescription.Text, "Company") == true) { Alert.show("Company Description Already Exist", Alert.AlertType.error); return; } //Saving here SqlCommand cmd = new SqlCommand(); cmd.Connection = con; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "sp_InsertCompany"; txtDescription.Text = txtDescription.Text.Trim(); //trim space first cmd.Parameters.AddWithValue("@Description", txtDescription.Text.ToUpper()); cmd.Parameters.AddWithValue("@Remark", txtRemarks.Text); cmd.ExecuteNonQuery(); //CLEAR TEXTFIELDS txtCode.Text = ""; txtDescription.Text = ""; txtRemarks.Text = ""; //Enable Buttons btnEdit.Enabled = true; btnDelete.Enabled = true; btnClose.Text = "CLOSE"; //Save here saveTrigger = true; btnNew.Text = "NEW"; //load data global.loadDataForFileMaintenance(dataGridView1, "Company"); //customize alert Alert.show("Successfully Added.", Alert.AlertType.success); txtDescription.Enabled = false; txtRemarks.Enabled = false; } } else { SqlCommand cmd = new SqlCommand("sp_AutoGenerateCompanyCode", con); cmd.CommandType = CommandType.StoredProcedure; SqlDataAdapter adapter = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); adapter.Fill(dt); //REMOVE DESCRIPTION IF HAS A VALUE txtDescription.Text = ""; txtRemarks.Text = ""; txtCode.Text = dt.Rows[0].ItemArray[0].ToString(); //Fill txtCode //Autogenerate //ENABLED ALL FIELDS txtDescription.Enabled = true; txtRemarks.Enabled = true; btnEdit.Enabled = false; btnDelete.Enabled = false; //Change Close to Cancel btnClose.Text = "CANCEL"; //SET FOCUS FIRST TO DESCRIPTION txtDescription.Focus(); } //Change New to Save if (saveTrigger == true) { btnNew.Text = "NEW"; } else { btnNew.Text = "SAVE"; } } }
private void btnEdit_Click(object sender, EventArgs e) { if (txtCode.Text == "") //Check if code is empty { if (dataGridView1.SelectedRows.Count > 0) //make sure user select at least 1 row { string code = dataGridView1.SelectedRows[0].Cells[0].Value + string.Empty; string description = dataGridView1.SelectedRows[0].Cells[1].Value + string.Empty; string remarks = dataGridView1.SelectedRows[0].Cells[2].Value + string.Empty; txtCode.Text = code; txtDescription.Text = description; txtRemarks.Text = remarks; } } //Disable button first btnNew.Enabled = false; btnDelete.Enabled = false; //change button close to cancel btnClose.Text = "CANCEL"; updateTrigger = false; //Enable first the textbox txtDescription.Enabled = true; txtRemarks.Enabled = true; if (btnEdit.Text == "UPDATE") { //Update code goes here //CHECK FIRST BEFORE SAVING if (txtDescription.Text == "") { Alert.show("All fields with (*) are required.", Alert.AlertType.warning); return; } //CONNECTION TO SQL SERVER AND STORED PROCEDURE using (SqlConnection con = new SqlConnection(global.connectString())) { con.Open(); //UPDATE CODE HERE SqlCommand cmd = new SqlCommand(); cmd.Connection = con; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "sp_UpdateCompany"; cmd.Parameters.AddWithValue("@Company_Code", txtCode.Text); txtDescription.Text = txtDescription.Text.Trim(); //trim space first cmd.Parameters.AddWithValue("@Description", txtDescription.Text.ToUpper()); cmd.Parameters.AddWithValue("@Remarks", txtRemarks.Text); cmd.ExecuteNonQuery(); //load data realtime global.loadDataForFileMaintenance(dataGridView1, "Company"); //update trigger call updateTrigger = true; //if successfully updated //Disable textbox txtDescription.Enabled = false; txtRemarks.Enabled = false; //clear txtCode.Text = ""; txtDescription.Text = ""; txtRemarks.Text = ""; //enable buttons btnNew.Enabled = true; btnDelete.Enabled = true; btnClose.Text = "CLOSE"; //success Alert.show("Successfully updated.", Alert.AlertType.success); btnEdit.Text = "EDIT"; } } else { } if (updateTrigger == false) { btnEdit.Text = "UPDATE"; } else { btnEdit.Text = "EDIT"; } }
private void button2_Click(object sender, EventArgs e) { if (dataGridView1.SelectedRows.Count > 0) { CashReceiptVoucher or = new CashReceiptVoucher(); or = (CashReceiptVoucher)Application.OpenForms["CashReceiptVoucher"]; if (or.txtORNo.Text != "") { clsOpen.deleteTransaction("Receipt Voucher", or.txtORNo.Text); } if (clsOpen.checkOpenFormsAndTransaction("Receipt Voucher", dataGridView1.SelectedRows[0].Cells["Or_No"].Value.ToString()) == true) { //Messagebox here for open form with user whos using the form and reference Alert.show(clsOpen.returnUserOnlineAndReference("Receipt Voucher", dataGridView1.SelectedRows[0].Cells["Or_No"].Value.ToString(), "Receipt Voucher"), Alert.AlertType.error); return; } else { //Insert here for register the open form and reference clsOpen.insertTransaction("Receipt Voucher", dataGridView1.SelectedRows[0].Cells["Or_No"].Value.ToString()); } //========================================================================================= // Header Information //========================================================================================= Classes.clsCashReceipt.userID = Convert.ToInt32(dataGridView1.SelectedRows[0].Cells["userID"].Value.ToString()); or.txtORNo.Text = dataGridView1.SelectedRows[0].Cells["Or_No"].Value.ToString(); or.dtOrDate.Text = dataGridView1.SelectedRows[0].Cells["Or_Date"].Value.ToString(); if (dataGridView1.SelectedRows[0].Cells["Payor_Type"].Value.ToString() == "True") { or.radioClient.Checked = true; //Return Company Name According to ID or.txtPayorName.Text = clsSearchCash.returnClientName(dataGridView1.SelectedRows[0].Cells["Payor"].Value.ToString()); } else { or.radioMember.Checked = true; //Return Member Name According to ID or.txtPayorName.Text = clsSearchCash.returnMembersName(dataGridView1.SelectedRows[0].Cells["userID"].Value.ToString()); or.txtPayorCompany.Text = clsCash.returnCompanyDescription(clsSearchCash.GetCompanyPerMember(dataGridView1.SelectedRows[0].Cells["userID"].Value.ToString())); } or.txtPayorID.Text = dataGridView1.SelectedRows[0].Cells["Payor"].Value.ToString(); or.txtParticulars.Text = dataGridView1.SelectedRows[0].Cells["Particulars"].Value.ToString(); //========================================================================================= // COLLECTION TYPE //========================================================================================= //0 = cash //1 = pecci check //2 = non-pecci check if (dataGridView1.SelectedRows[0].Cells["Collection_Type"].Value.ToString() == "0") { or.radioCash.Checked = true; } else if (dataGridView1.SelectedRows[0].Cells["Collection_Type"].Value.ToString() == "1") { or.radioPecciCheck.Checked = true; } else { or.radioNonPecciCheck.Checked = true; } //========================================================================================= // Transaction Header //========================================================================================= clsSearchCash.loadTransaction(or.datagridviewTransaction, dataGridView1.SelectedRows[0].Cells["Or_No"].Value.ToString()); //========================================================================================= // Bank Details //========================================================================================= if (dataGridView1.SelectedRows[0].Cells["Collection_Type"].Value.ToString() == "1" || dataGridView1.SelectedRows[0].Cells["Collection_Type"].Value.ToString() == "2") { clsSearchCash.loadBanksCheck(or.dgvChecks, dataGridView1.SelectedRows[0].Cells["Or_No"].Value.ToString()); //Disable Bank Grid and buttons or.dgvChecks.Enabled = false; or.btnAddCheck.Enabled = false; or.btnRemoveCheck.Enabled = false; } else { or.dgvChecks.Rows.Clear(); } //========================================================================================= // Cash Receipt Details //========================================================================================= clsSearchCash.loadCashReceiptsDetails(or.dataGridView3, dataGridView1.SelectedRows[0].Cells["Or_No"].Value.ToString()); //========================================================================================= // Cash Receipt Footer //========================================================================================= or.txtPostedBy.Text = dataGridView1.SelectedRows[0].Cells["Posted_By"].Value.ToString(); or.txtCancelledBy.Text = dataGridView1.SelectedRows[0].Cells["Cancelled_By"].Value.ToString(); if (dataGridView1.SelectedRows[0].Cells["Posted"].Value.ToString() == "True" || dataGridView1.SelectedRows[0].Cells["Posted"].Value.ToString() == "1") { or.status.Visible = true; or.status.Text = "POSTED"; } else if (dataGridView1.SelectedRows[0].Cells["Cancelled"].Value.ToString() == "True" || dataGridView1.SelectedRows[0].Cells["Cancelled"].Value.ToString() == "1") { or.status.Visible = true; or.status.Text = "CANCELLED"; } else { or.status.Visible = false; } //Location of OR as Per Maam Diane Request if (dataGridView1.SelectedRows[0].Cells["Location"].Value.ToString() == "PEREA") { or.radioLocPerea.Checked = true; } else { or.radioLocTeltech.Checked = true; } //Put Prepared By or.txtPreparedBy.Text = dataGridView1.SelectedRows[0].Cells["Prepared_By"].Value.ToString(); or.txtAuditedBy.Text = dataGridView1.SelectedRows[0].Cells["Audited_By"].Value.ToString(); //Enable Commands or.btnEdit.Enabled = true; or.btnPost.Enabled = true; or.btnCancel.Enabled = true; or.btnAuditted.Enabled = true; //Sorting or.dataGridView3.Sort(or.dataGridView3.Columns["Debit"], ListSortDirection.Descending); this.Close(); } }
public void createSMARTtxtFile() { saveFileDialog1.FileName = "Payroll.txt"; // set filters - this can be done in properties as well saveFileDialog1.Filter = "Text files (*.txt)|*.txt|All files (*.*)|*.*"; if (saveFileDialog1.ShowDialog() == DialogResult.OK) { FileStream fs1 = new FileStream(saveFileDialog1.FileName, FileMode.OpenOrCreate, FileAccess.Write); StreamWriter writer = new StreamWriter(fs1); using (SqlConnection con = new SqlConnection(global.connectString())) { con.Open(); string dtReplace = Convert.ToString(dtBillDate.Value.ToString("MM/dd/yy")); dtReplace = dtReplace.Replace("/", ""); writer.Write("0000000"); //instcode writer.Write("01"); //batchcode writer.Write(" "); //white space writer.Write(dtReplace); //BillDate writer.Write("H"); //Header writer.Write(dtReplace); //Upload Date writer.Write(" "); //white space writer.Write("001"); //Default writer.Write("0967096504353"); //pecciAccountNo writer.Write("2020"); //Default writer.Write(Environment.NewLine); //For New Line //Write Details SqlCommand cmd = new SqlCommand(); cmd.Connection = con; cmd.CommandText = "sp_SmartBillingTextTotxtFile"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@BillDateGenerated", dtBillDate.Text); cmd.Parameters.AddWithValue("@billdate", dtReplace); cmd.Parameters.AddWithValue("@uploaddate", dtReplace); SqlDataAdapter adapter = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); adapter.Fill(dt); for (int x = 0; x < dt.Rows.Count; x++) { writer.Write(dt.Rows[x].ItemArray[0].ToString()); writer.Write(Environment.NewLine); //For New Line } //Write Trailer SqlCommand cmdTrailer = new SqlCommand(); cmdTrailer.Connection = con; cmdTrailer.CommandText = "sp_SmartBillingTextTotxtFileTrailer"; cmdTrailer.CommandType = CommandType.StoredProcedure; cmdTrailer.Parameters.AddWithValue("@BillDateGenerated", dtBillDate.Text); cmdTrailer.Parameters.AddWithValue("@billdate", dtReplace); cmdTrailer.Parameters.AddWithValue("@uploaddate", dtReplace); SqlDataAdapter adapterTrailer = new SqlDataAdapter(cmdTrailer); DataTable dtTrailer = new DataTable(); adapterTrailer.Fill(dtTrailer); writer.Write(dtTrailer.Rows[0].ItemArray[0].ToString()); writer.Close(); } Alert.show("Successfully exported.", Alert.AlertType.success); } }