private void btnSave_Click(object sender, EventArgs e) { bool bReturn = false; if (txtFirstName.Text != "") { bReturn = true; } else { MessageBox.Show("First Name sould not be empty"); } if (bReturn == true) { DialogResult dialogResult = MessageBox.Show("Your are trying to Insert record", "Insert", MessageBoxButtons.YesNo); if (dialogResult == DialogResult.Yes) { bReturn = true; } else if (dialogResult == DialogResult.No) { bReturn = false; } } if (bReturn == true) { //string strQuery = // "INSERT INTO " // + m_strTableName // + "(" // + m_strFirstName + "," // + m_strMiddleName + "," // + m_strLastName + "," // + m_strAddress + "," // + m_strPhone // + ") VALUES(" // + "'" + txtFirstName.Text + "', " // + "'" + txtMiddleName.Text + "', " // + "'" + txtLastName.Text + "', " // + "'" + txtAddress.Text + "', " // + "'" + txtPhoneNo.Text + "'" // + ")"; string strQuery = SingletonSonar.Instance.CustomerInsertQuery(txtFirstName.Text, txtMiddleName.Text, txtLastName.Text, txtAddress.Text, txtPhoneNo.Text); bReturn = dbConnect.Insert(strQuery); if (bReturn == true) { MessageBox.Show("Record Inserted"); ClearData(); DisplayData(); } } }
private void btnSave_Click(object sender, EventArgs e) { bool bReturn = false; if (txtFirstName.Text != "") { bReturn = true; } else { MessageBox.Show("First Name sould not be empty"); } if (bReturn == true) { DialogResult dialogResult = MessageBox.Show("Your are trying to Insert record", "Insert", MessageBoxButtons.YesNo); if (dialogResult == DialogResult.Yes) { bReturn = true; } else if (dialogResult == DialogResult.No) { bReturn = false; } } if (bReturn == true) { string strQuery = SingletonSonar.Instance.EmployeeInsertQuery(txtCode.Text, txtFirstName.Text, txtMiddleName.Text, txtLastName.Text, txtAddress.Text, txtPhoneNo.Text); bReturn = dbConnect.Insert(strQuery); if (bReturn == true) { MessageBox.Show("Record Inserted"); ClearData(); DisplayData(); } } }
private void btnSave_Click(object sender, EventArgs e) { bool bReturn = false; if (txtName.Text != "") { bReturn = true; } else { MessageBox.Show("Name sould not be empty"); } if (bReturn == true) { DialogResult dialogResult = MessageBox.Show("Your are trying to Insert record", "Insert", MessageBoxButtons.YesNo); if (dialogResult == DialogResult.Yes) { bReturn = true; } else if (dialogResult == DialogResult.No) { bReturn = false; } } if (bReturn == true) { //string strTableCategory = "category"; //string strQueryID = // " SELECT " // + m_strID // + " FROM " // + strTableCategory // + " WHERE " // + " 1 = 1 " // + " AND " + strTableCategory + "." + m_strType + " like '%" + cmbCategory.Text + "%'" // ; string strQueryID = SingletonSonar.Instance.ProductCategorySelectQuery(cmbCategory.Text); string strDataValue; strDataValue = dbConnect.GetDataValue(strQueryID, m_strID); int nID = Convert.ToInt32(strDataValue); //string strQuery = // "INSERT INTO " // + m_strTableName // + "(" // + m_strName + "," // + m_strDetails + "," // + m_strCategoryID // + ") VALUES(" // + "'" + txtName.Text + "', " // + "'" + txtDetails.Text + "', " // + nID // + ")"; string strQuery = SingletonSonar.Instance.ProductInsertQuery(txtName.Text, txtDetails.Text, nID); bReturn = dbConnect.Insert(strQuery); if (bReturn == true) { MessageBox.Show("Record inserted"); ClearData(); DisplayData(); } } }
private void btnAdd_Click(object sender, EventArgs e) { bool bReturn = true; if (txtFirstName.Text == "") { bReturn = false; MessageBox.Show("First Name sould not be empty"); } if ((m_nCustomerID == 0) || (m_nProductID == 0) || (m_nEmployeeID == 0)) { bReturn = false; MessageBox.Show("Customer/Product/Employee is not selected"); } if (bReturn == true) { DialogResult dialogResult = MessageBox.Show("Your are trying to Insert record", "Insert", MessageBoxButtons.YesNo); if (dialogResult == DialogResult.No) { bReturn = false; } } if (bReturn == true) { GenerateID(); InsertOrUpdateInvoice(); //string strInvoice_ID = "invoice_id"; //string strQuery = // "INSERT INTO " // + m_strOrderTxn // + "(" // + m_strCustomerID + "," // + m_strProductID + "," // + m_strQuantity + "," // + m_strAmount + "," // + m_strSGST + "," // + m_strCGST + "," // + m_strTotalPrice + "," // + strInvoice_ID + "," // + m_strModifiedOn // + ") VALUES(" // + m_nCustomerID + ", " // + m_nProductID + ", " // + txtQuantity.Text + ", " // + txtCalAmount.Text + ", " // + txtCGST.Text + ", " // + txtSGST.Text + ", " // + txtAmount.Text + ", " // + m_nInvoiceID + ", " // + "'" + m_strModifiedOnValue + "'" // + ")"; string strQuery = SingletonSonar.Instance.OrderInsertQuery(m_nCustomerID, m_nProductID, m_nEmployeeID, txtQuantity.Text, txtCalAmount.Text, txtCGST.Text, txtSGST.Text, txtAmount.Text, m_nInvoiceID); bReturn = dbConnect.Insert(strQuery); if (bReturn == true) { MessageBox.Show("Record Inserted"); ClearData(); DisplayData(); } } }
//Insert button clicked private void bInsert_Click(object sender, EventArgs e) { dbConnect.Insert(); }