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