private void pro_id_TextChanged(object sender, EventArgs e) { try{ DBConnect connection = new DBConnect(); connection.OpenConnection(); MySqlConnection returnConn = new MySqlConnection(); returnConn = connection.GetConnection(); string query = "SELECT * FROM products WHERE productId = '" + pro_id.Text + "'"; MySqlCommand cmd = new MySqlCommand(query, returnConn); using (MySqlDataReader read = cmd.ExecuteReader()) { while (read.Read()) { pro_name.Text = read.GetString("name").ToString(); //txt_amound.Text = read.GetString().ToString(); } } } catch (Exception ex) { MetroMessageBox.Show(this.MdiParent, ex.Message); //MessageBox.Show(ex.Message); } try { DBConnect connection = new DBConnect(); connection.OpenConnection(); MySqlConnection returnConn = new MySqlConnection(); returnConn = connection.GetConnection(); string query1 = "SELECT * FROM inv_newitems WHERE productId = '" + pro_id.Text + "'"; MySqlCommand cmd1 = new MySqlCommand(query1, returnConn); using (MySqlDataReader read = cmd1.ExecuteReader()) { while (read.Read()) { pro_amound.Text = read.GetString("MaximumRetailPrice").ToString(); } } } catch (Exception ex) { MetroMessageBox.Show(this.MdiParent, ex.Message); //MessageBox.Show(ex.Message); } try { DBConnect connection = new DBConnect(); connection.OpenConnection(); MySqlConnection returnConn = new MySqlConnection(); returnConn = connection.GetConnection(); string query1 = "SELECT * FROM available WHERE productID = '" + pro_id.Text + "'"; MySqlCommand cmd1 = new MySqlCommand(query1, returnConn); using (MySqlDataReader read = cmd1.ExecuteReader()) { while (read.Read()) { quantityy.Text = read.GetString("Total").ToString(); } } } catch (Exception ex) { MetroMessageBox.Show(this.MdiParent, "ex"); //MessageBox.Show(ex.Message); } }
private void button4_Click(object sender, EventArgs e) { if (txt_receiveddate.Text != "" && batchno.Text != "" && productid.Text != "" && manufactureddate.Text != "" && expireddate.Text != "" && textBox1.Text != "" && priceperunit.Text != "" && quantity.Text != "") { // string id = txt_id.Text; string receivedate = txt_receiveddate.Value.ToString("yyyy-MM-dd"); string Batchno = batchno.Text; string Productid = productid.Text; string Manufactureddate = manufactureddate.Value.ToString("yyyy-MM-dd"); string Expireddate = expireddate.Value.ToString("yyyy-MM-dd"); string Productname = textBox1.Text; string Priceperunit = priceperunit.Text; string Quantity = quantity.Text; string Box = box.Text; string Packet = packet.Text; string UnitPrice = unitprice.Text; try { DBConnect conn = new DBConnect(); conn.OpenConnection(); MySqlConnection returnConn = new MySqlConnection(); returnConn = conn.GetConnection(); string query = ("insert into inv_newitems (ReceivedDate,BatchNo,ManufacturedDate,ExpiredDate,ProductID,ProductName,Quantity,MaximumRetailPrice,UnitPrice,Packed) values(@receiveddate,@batchno,@manufactureddate,@expireddate,@productid,@productname,@quantity,@ppunit,@unitpp,@packed)"); MySqlCommand cmd = new MySqlCommand(query, returnConn); //cmd.Parameters.AddWithValue("@id", id); cmd.Parameters.AddWithValue("@receiveddate", receivedate); cmd.Parameters.AddWithValue("@batchno", Batchno); cmd.Parameters.AddWithValue("@productid", Productid); cmd.Parameters.AddWithValue("@manufactureddate", Manufactureddate); if (manufactureddate.Value != expireddate.Value) { cmd.Parameters.AddWithValue("@expireddate", Expireddate); } else { MetroMessageBox.Show(this.MdiParent, "Manufactured Date and Expired Date can't Be Same"); return; } if (manufactureddate.Value > expireddate.Value) { MetroMessageBox.Show(this.MdiParent, "Expired Date Should Be Future Date of Manufacture Date"); return; } cmd.Parameters.AddWithValue("@productname", Productname); cmd.Parameters.AddWithValue("@quantity", Quantity); cmd.Parameters.AddWithValue("@ppunit", Priceperunit); cmd.Parameters.AddWithValue("@unitpp", UnitPrice); if (box.Checked == true) { cmd.Parameters.AddWithValue("@packed", Box); } else if (packet.Checked == true) { cmd.Parameters.AddWithValue("@packed", Packet); } //cmd.Parameters.AddWithValue("@packed", packet.Text); cmd.ExecuteNonQuery(); conn.CloseConnection(); MetroMessageBox.Show(this.MdiParent, "Added Successfully"); DisplayData(); ClearData(); } catch (Exception ex) { MetroMessageBox.Show(this.MdiParent, ex.Message); } } else { MetroMessageBox.Show(this.MdiParent, "Insert Values"); } }
private void button1_Click(object sender, EventArgs e) { if (pro_id.Text != "" && pro_name.Text != "" && pro_quantity.Text != "" && pro_amound.Text != "") { try { if (status.Text == "Approved") { //MessageBox.Show(pro_quantity.Text); // MessageBox.Show(quantityy.Text); if ((pro_id.Text != "" && pro_name.Text != "" && pro_quantity.Text != "" && pro_amound.Text != "")) { // MessageBox.Show("if success"); try { DBConnect connection = new DBConnect(); connection.OpenConnection(); MySqlConnection returnConn = new MySqlConnection(); returnConn = connection.GetConnection(); string query; query = "INSERT INTO inv_inventoryout (orderid, orderdate, deliverydate, productid, productname, quantity, unitprice, status) VALUES (@1, @2, @3, @4, @5, @6, @7, @8)"; //query = "insert into inv_inventoryout(orderid,orderdate,deliverydate,productid,productname,quantity,unitprice,status) values (@1,@2,@3,@4,@5,@6,@7,@8)"; MySqlCommand cmd = new MySqlCommand(query, returnConn); cmd.Parameters.AddWithValue("@1", txitid.Text); cmd.Parameters.AddWithValue("@2", date_order.Value.ToString("yyyy/MM/dd")); cmd.Parameters.AddWithValue("@3", date_delivery.Value.ToString("yyyy/MM/dd")); cmd.Parameters.AddWithValue("@4", pro_id.Text); cmd.Parameters.AddWithValue("@5", pro_name.Text); cmd.Parameters.AddWithValue("@6", Convert.ToInt32(pro_quantity.Text)); cmd.Parameters.AddWithValue("@7", Convert.ToInt32(pro_amound.Text)); cmd.Parameters.AddWithValue("@8", status.Text); cmd.ExecuteNonQuery(); MetroMessageBox.Show(this.MdiParent, "Record Updated Sucessfully!"); int quantity1 = Int32.Parse(pro_quantity.Text); int quantity2 = Int32.Parse(quantityy.Text); int quantity3 = quantity2 - quantity1; //MessageBox.Show("Converted"); if (quantity3 < 0) { MetroMessageBox.Show(this.MdiParent, "Not Having Enough Quantity! Sent a Work Order Request"); //invoice(); } connection.CloseConnection(); invoice(); DisplayData(); ClearData(); } catch (Exception ex) { MetroMessageBox.Show(this, ex.Message); } } else { MetroMessageBox.Show(this.MdiParent, "Select the Field to Update"); } } } catch (Exception ex) { MetroMessageBox.Show(this.MdiParent, ex.Message); } } }