private void btn_save_Click(object sender, EventArgs e)
{
string query = "insert into login(name,password) values ('" + textBox_name.Text + "','" + textBox_pass.Text + "')";
db.Insert_Update_DeleteDB(query);
MessageBox.Show("Your Data Saved");
}
private void btn_save_Click_1(object sender, EventArgs e)
{
string query = "insert into CATEGROIES ([name]) values('" + textBox_name.Text + "')";
db.Insert_Update_DeleteDB(query);
MessageBox.Show("Your Data Saved");
}
private void btn_save_Click(object sender, EventArgs e)
{
string query = "insert into DEVICES (id,name,sales,DESCRIPTION,issus,MANUFACTURE,type,cate_id) values(" + textBox_num.Text + ",'" + textBox_name.Text + "'," + textBox_sales.Text + ",'" + textBox_dasc.Text + "','" + textBox_issus.Text + "','" + textBox_man.Text + "','" + textBox_type.Text + "'," + comboBoxCategories.SelectedValue + ")";
db.Insert_Update_DeleteDB(query);
MessageBox.Show("Your Data Saved");
}
private void btn_save_Click(object sender, EventArgs e)
{
string query = "insert into CUSTOMER (name,title,phone) values('" + textBox_name.Text + "','" + textBox_title.Text + "','" + textBox_phone.Text + "')";
db.Insert_Update_DeleteDB(query);
MessageBox.Show("Your Data Saved");
}
private void btn_save_Click(object sender, EventArgs e)
{
// DataSet ds4 = new DataSet();
// ds4 = db.SetectDB("select MAX(BILL_SALES_NO) from BILL_SALES_TABLE", "id_BILL");
//textBox_IdBill.DataBindings.Add("text", ds4, "id_BILL");
string query2 = "insert into SALES ( DEVICE_NO , QUANITY , BILL_SALE_NO ) values(" + comboBoxDevices.SelectedValue + "," + textBox_Quanity.Text + "," + comboBox_bill.SelectedValue + ")";
db.Insert_Update_DeleteDB(query2);
MessageBox.Show("Your Data Saved");
}
private void btn_delet_Click(object sender, EventArgs e)
{
if (MessageBox.Show("Are you sure you want to delete the record", "Delete Categroies", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes)
{
string query = "delete from DEVICES where id =" + textBox_num.Text;
db.Insert_Update_DeleteDB(query);
MessageBox.Show("Your Data Deleted");
}
}