private void button1_Click(object sender, EventArgs e) { int itemId = int.Parse(textBox1.Text); int count = int.Parse(textBox3.Text); string loc = (String)comboBox1.SelectedItem; string floc = (String)comboBox3.SelectedItem; String name = textBox1.Text; String ttype = "Issue"; String datenw = DateTime.Now.ToString(); string qry = "Select * from inventory where item_id='" + itemId + "';"; MySqlConnection connst = new MySqlConnection("server=localhost;user id=root;database=harasara"); MySqlCommand cmd1 = new MySqlCommand(qry, connst); MySqlDataReader reader; connst.Open(); reader = cmd1.ExecuteReader(); while (reader.Read()) { Int32 rolt = reader.GetInt32("rol"); Int32 countt = reader.GetInt32("count"); //float pricet = reader.GetFloat("price"); if (countt >= rolt) { Int32 countf = countt - count; //float pricef = (pricet + price) / 2; try { String qry2 = "Insert into inv_trans(item_id,count,location,type,factory,date) values('" + itemId + "','" + count + "','" + loc + "','" + ttype + "','" + floc + "','" + datenw + "')"; String qry1 = "Update inventory set count='" + countf + "',last_update='" + datenw + "' where (item_id='" + itemId + "'or name='" + name + "')and location='" + loc + "'"; dbconnect conn = new dbconnect(); conn.ExQuery(qry1); conn.ExQuery(qry2); MessageBox.Show("Entry Added Success"); textBox1.Text = ""; textBox2.Text = ""; textBox3.Text = ""; //textBox4.Text = ""; } catch (Exception ex) { MessageBox.Show(ex.Message, "Check database connection"); } } else { MessageBox.Show("Low Inventory Unable to Issue"); } } }
private void button2_Click(object sender, EventArgs e) { dbconnect dbcon = new dbconnect(); String loc = (String)comboBox2.SelectedItem; String qry3 = "SELECT * from inventory_fd where location='" + loc + "' "; BindingSource bsource = new BindingSource(); bsource.DataSource = dbcon.ReadValue(qry3); dataGridView2.DataSource = bsource; }
private void button3_Click(object sender, EventArgs e) { String stadate = dateTimePicker1.Text; String enddate = dateTimePicker2.Text; String loc = (String)comboBox4.SelectedItem; String typ = (String)comboBox3.SelectedItem; dbconnect dbcon = new dbconnect(); String qry1 = "SELECT * FROM fd_trans WHERE location='" + loc + "' AND type='" + typ + "' AND Date BETWEEN '" + stadate + "' AND '" + enddate + "' "; BindingSource bsource = new BindingSource(); bsource.DataSource = dbcon.ReadValue(qry1); dataGridView3.DataSource = bsource; }
private void button1_Click(object sender, EventArgs e) { String prodid = textBox1.Text; int count = int.Parse(textBox2.Text); String loc = (String)comboBox1.SelectedItem; String typet = "Receipt"; String datenw = DateTime.Today.Date.ToString("yyyy-MM-dd"); String prodname = (String)textBox5.Text; String qry = "Select * from inventory_fd where productID='" + prodid + "'"; MySqlConnection connst = new MySqlConnection("server=localhost;user id=root;database=harasara"); MySqlCommand cmd1 = new MySqlCommand(qry, connst); MySqlDataReader reader; connst.Open(); reader = cmd1.ExecuteReader(); reader.Read(); Int32 countt = reader.GetInt32("Count"); Int32 countf = countt + count; try { String qry2 = "Insert into fd_trans(productID,productName,count,location,type,date) values('" + prodid + "','" + prodname + "','" + count + "','" + loc + "','" + typet + "','" + datenw + "')"; String qry1 = "Update inventory_fd set count='" + countf + "' where productID='" + prodid + "'and location='" + loc + "'"; dbconnect conn = new dbconnect(); conn.ExQuery(qry1); conn.ExQuery(qry2); textBox1.Text = ""; textBox2.Text = ""; MessageBox.Show("Success", "Stock Added Successfully", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); } catch (Exception ex) { MessageBox.Show(ex.Message, "Check database connection"); } finally { MessageBox.Show(""); } }