private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
Ready_productsdb r = new Ready_productsdb();
DataRowView dvr = (DataRowView)comboBox1.SelectedItem;
textBox2.Text = r.getPrice((int)dvr.Row["ID"]) + "";
}
public AddProductToOrder()
{
InitializeComponent();
Ready_productsdb r = new Ready_productsdb();
comboBox1.DataSource = r.getForDropDown();
comboBox1.DisplayMember = "Name";
comboBox1.ValueMember = "ID";
}
private void Ready_Product_Load(object sender, EventArgs e)
{
FormBorderStyle = FormBorderStyle.None;
WindowState = FormWindowState.Maximized;
TopMost = false;
dataGridView1.ColumnHeadersDefaultCellStyle.Font = new Font("Arial", 12);
dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
Ready_productsdb rdb = new Ready_productsdb();
dataGridView1.DataSource = rdb.selectall();
}
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 dataGridView1_MouseClick(object sender, MouseEventArgs e)
{
try
{
string id = dataGridView1.SelectedRows[0].Cells[0].Value.ToString();
Ready_productsdb rdp = new Ready_productsdb();
rdp.get(Int32.Parse(id));
comboBox1.Text = rdp.Product_name;
comboBox2.Text = rdp.Product_packing;
textBox3.Text = rdp.Quantity;
textBox4.Text = rdp.Price;
dateTimePicker1.Text = rdp.date_created;
textBox5.Text = rdp.Remarks;
}
catch (Exception e1)
{
MessageBox.Show(e1.Message);
}
}