private void button4_Click(object sender, EventArgs e)
{
int id = (int)dataGridView1.SelectedRows[0].Cells[0].Value;
rdb.delete(id);
this.Close();
Form f = new Ready_Product();
f.Show();
}
private void button1_Click(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection("Data Source=DELL-PC\\SQLEXPRESS;Initial Catalog=NGOIdatabase;Integrated Security=True");
conn.Open();
try
{
SqlCommand comd = conn.CreateCommand();
comd.CommandType = CommandType.Text;
DateTime d = Convert.ToDateTime(dateTimePicker1.Text);
if (textBox1.Text == "")
{
//MessageBox.Show("I will create new");
Ready_Product r = new Ready_Product();
int abc = Int32.Parse(textBox4.Text);
int id;
//SqlDataAdapter sda = new SqlDataAdapter ( "Select Product_id from Ready_products where product_name=" +comboBox1, conn);
SqlDataAdapter sda = new SqlDataAdapter("select * from Ready_Products where Product_name=" + comboBox1, conn);
sda.Fill(dt);
id = Int32.Parse(dt.Rows[0]["Product_id"].ToString());
// r.get(id);
// abc = abc + r.Quantity;
comd.CommandText = "Update Ready_products SET Quantity='" + abc + "'where Product_id = " + textBox1.Text;
this.Close();
r.Show();
}
else
{
//MessageBox.Show("I will update");
comd.CommandText = "UPDATE Ready_products SET Prooduct_name='" + comboBox1.Text + "',Product_packing'" + comboBox2.Text + "',Quantity='" + textBox3.Text + "',Price='" + textBox4.Text + "',date_created='" + d.Year + "-" + d.Month + "-" + d.Day + "',Remarks='" + textBox5.Text + "' where Product_id=" + textBox1.Text;
}
//comd.CommandText = "INSERT INTO Ready_products (Product_name, Product_packing, Quantity, Price, date_created, Remarks) values ('" + textBox2.Text + "','" + comboBox2.Text + "','" + textBox3.Text + "','" + textBox4.Text + "','" + dateTimePicker1.Text + "','" + textBox5.Text + "','" + "')";
comd.ExecuteNonQuery();
Ready_productsdb rdb = new Ready_productsdb();
dataGridView1.DataSource = rdb.selectall();
conn.Close();
// Ready_productsdb rdb = new Ready_productsdb;
rdb.selectall();
}
catch (Exception e2)
{
MessageBox.Show(e2.Message);
}
reset_layout();
}
private void button1_Click(object sender, EventArgs e)
{
Ready_Product f1 = new Ready_Product();
f1.ShowDialog();
}