public bool updateData(productionsize k, string STYLEID1, string SIZEID1) { bool stat = false; try { Connection ConnG = new Connection(); ConnG.Konek(); strQuery = new MySqlCommand(); strQuery.Connection = ConnG.Conn; strQuery.CommandType = CommandType.Text; strQuery.CommandText = "UPDATE tblproductionsize SET STYLEID=@STYLEID,SIZEID=@SIZEID,NOURUT=@NOURUT,COSUMPTION=@COSUMPTION,RATIO=@RATIO,QTYPLAN=@QTYPLAN" + " WHERE STYLEID=@STYLEID1 AND SIZEID=@SIZEID1 "; //key strQuery.Parameters.AddWithValue("@STYLEID1", STYLEID1); strQuery.Parameters.AddWithValue("@SIZEID1", SIZEID1); strQuery.Parameters.AddWithValue("@STYLEID", k.STYLEID); strQuery.Parameters.AddWithValue("@SIZEID", k.SIZEID); strQuery.Parameters.AddWithValue("@NOURUT", k.NOURUT); strQuery.Parameters.AddWithValue("@COSUMPTION", k.COSUMPTION); strQuery.Parameters.AddWithValue("@RATIO", k.RATIO); strQuery.Parameters.AddWithValue("@QTYPLAN", k.QTYPLAN); strQuery.ExecuteNonQuery(); ConnG.Putus(); stat = true; } catch (Exception ex) { MessageBox.Show(ex.Message); } return(stat); }
public bool insertData(productionsize k) { bool stat = false; try { Connection ConnG = new Connection(); ConnG.Konek(); strQuery = new MySql.Data.MySqlClient.MySqlCommand(); strQuery.Connection = ConnG.Conn; strQuery.CommandType = CommandType.Text; strQuery.CommandText = "INSERT INTO tblproductionsize(STYLEID,SIZEID,NOURUT,COSUMPTION,RATIO,QTYPLAN) " + "VALUES(@STYLEID,@SIZEID,@NOURUT,@COSUMPTION,@RATIO,@QTYPLAN)"; strQuery.Parameters.AddWithValue("@STYLEID", k.STYLEID); strQuery.Parameters.AddWithValue("@SIZEID", k.SIZEID); strQuery.Parameters.AddWithValue("@NOURUT", k.NOURUT); strQuery.Parameters.AddWithValue("@COSUMPTION", k.COSUMPTION); strQuery.Parameters.AddWithValue("@RATIO", k.RATIO); strQuery.Parameters.AddWithValue("@QTYPLAN", k.QTYPLAN); strQuery.ExecuteNonQuery(); stat = true; ConnG.Putus(); } catch (Exception ex) { MessageBox.Show(ex.Message); } return(stat); }