private void DisplayInvoiceData()
{
if (m_nInvoiceID == 0)
{
GenerateID();
}
//string strCol = "invoice_id";
//string query =
// "SELECT "
// + m_strTableInvoice + "." + m_strInvoiceID + ","
// + "invoice_date_created" + ","
// + "invoice_date_modified" + ","
// + "paid_price_1" + ","
// + "paid_price_2" + ","
// + "payment_method" + ","
// + "(SELECT sum(total_price) "
// + "FROM order_txn "
// + "WHERE "
// + m_strOrderTxn + "." + strCol + " = " + m_strTableInvoice + "." + "id" + ") total_amount"
// + " FROM " + m_strTableInvoice
// + " WHERE "
// + " 1 = 1 AND "
// + m_strTableInvoice + "." + m_strInvoiceID + " = " + m_nInvoiceID
// ;
string query = SingletonSonar.Instance.OrderInvoiceSelectQuery(m_nInvoiceID);
dbConnect.GridDisplay(dataGridView2, query);
}
private void DisplayData()
{
//string strTableCategory = "category";
//string strQuery =
// " SELECT "
// + m_strTableName + "." + m_strID + ","
// + "type" + ","
// + m_strValue + ","
// + m_strTableName + "." + m_strModifiedOn
// + " FROM " + m_strTableName
// + " JOIN " + strTableCategory
// + " ON (" + m_strTableName + ".category_id = " + strTableCategory + ".id) "
// + " WHERE "
// + " 1 = 1 "
// ;
//if (chkCurrentDate.Checked == true)
//{
// strQuery = strQuery
// + " AND " + m_strTableName + "." + m_strModifiedOn + " = '" + m_strModifiedOnValue + "'";
//}
string strQuery = SingletonSonar.Instance.SettingSelectQuery(
chkCurrentDate.Checked, DateTime.Now.ToString("yyyy-MM-dd"));
dbConnect.GridDisplay(dataGridView1, strQuery);
}
private void DisplayData()
{
//string strTableCategory = "category";
//string strQuery =
// " SELECT "
// + m_strTableName + "." + m_strID + ","
// + m_strTableName + "." + m_strName + ","
// + m_strTableName + "." + m_strDetails + ","
// + strTableCategory + "." + m_strType
// + " FROM " + m_strTableName
// + " JOIN " + strTableCategory
// + " ON (" + m_strTableName + "." + m_strCategoryID
// + " = " + strTableCategory + "." + m_strID + ") "
// + " WHERE "
// + " 1 = 1 "
// + " AND " + m_strName + " like '%" + txtName.Text + "%'"
// + " AND " + m_strDetails + " like '%" + txtDetails.Text + "%'"
// //+ " AND " + m_strCategory + " like '%" + cmbCategory.Text + "%'"
// + " AND " + strTableCategory + "." + m_strType + " like '%" + cmbCategory.Text + "%'"
// ;
string strQuery = SingletonSonar.Instance.ProductSelectQuery(
txtName.Text, txtDetails.Text, cmbCategory.Text);
dbConnect.GridDisplay(dataGridView1, strQuery);
}
private void DisplayData()
{
string strQuery = SingletonSonar.Instance.EmployeeSelectQuery(txtCode.Text, txtFirstName.Text, txtMiddleName.Text, txtLastName.Text,
txtAddress.Text, txtPhoneNo.Text);
dbConnect.GridDisplay(dataGridView1, strQuery);
}
private void DisplayData()
{
string strQuery = SingletonSonar.Instance.AssignmentSelectQuery(chkWithDate.Checked,
dtpDate.Value.ToString("yyyy-MM-dd"), m_nEmployeeID);
dbConnect.GridDisplay(dataGridView1, strQuery);
}
private void DisplayData()
{
//// set query to fetch data "Select * from tabelname";
//string strQuery =
// " SELECT * FROM " + m_strTableName
// + " WHERE "
// + " 1 = 1 "
// + " AND " + m_strFirstName + " like '%" + txtFirstName.Text + "%'"
// + " AND " + m_strMiddleName + " like '%" + txtMiddleName.Text + "%'"
// + " AND " + m_strLastName + " like '%" + txtLastName.Text + "%'"
// + " AND " + m_strAddress + " like '%" + txtLastName.Text + "%'"
// + " AND " + m_strPhone + " like '%" + txtPhoneNo.Text + "%'"
// ;
string strQuery = SingletonSonar.Instance.CustomerSelectQuery(txtFirstName.Text, txtMiddleName.Text, txtLastName.Text,
txtAddress.Text, txtPhoneNo.Text);
dbConnect.GridDisplay(dataGridView1, strQuery);
}
private void DisplayInvoiceData()
{
//string strCol = "invoice_id";
//string query =
// "SELECT "
// + m_strTableInvoice + "." + m_strInvoiceID + ","
// + "invoice_date_created" + ","
// + "invoice_date_modified" + ","
// + "paid_price_1" + ","
// + "paid_price_2" + ","
// + "payment_method" + ","
// + "(SELECT sum(total_price) "
// + "FROM " + m_strOrderTxn
// + " WHERE "
// + m_strOrderTxn + "." + strCol + " = " + m_strTableInvoice + "." + "id" + ") total_amount" + ","
// + "(SELECT sum(total_price) "
// + "FROM " + m_strOrderTxn
// + " WHERE "
// + m_strOrderTxn + "." + strCol + " = " + m_strTableInvoice + "." + "id" + ") "+"- (paid_price_1 + paid_price_2) Balance"
// + " FROM " + m_strTableInvoice
// + " JOIN " + m_strCustomer
// + " ON (" + m_strCustomer + ".id = " + m_strTableInvoice + "." + m_strCustomerID + ") "
// + " WHERE "
// + " 1 = 1 AND "
// + m_strCustomer + "." + "id = " + m_nCustomerID
// ;
//if (chkWithDate.Checked == true)
//{
// query = query
// + " AND " + m_strTableInvoice + "." + m_strModifiedOn + " = '" + dtpDate.Value.ToString("yyyy-MM-dd") + "'";
//}
string query = SingletonSonar.Instance.InvoiceSelectQuery(chkWithDate.Checked,
dtpDate.Value.ToString("yyyy-MM-dd"), m_nCustomerID);
dbConnect.GridDisplay(dataGridView1, query);
}
