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