public bool insertData(production 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 tblproduction(JONO,STYLEID,COLORID,DELIVERYDATE,BUTTONING,WASHING,STARTDATE,CLOSEDATE) " + "VALUES(@JONO,@STYLEID,@COLORID,@DELIVERYDATE,@BUTTONING,@WASHING,@STARTDATE,@CLOSEDATE)"; strQuery.Parameters.AddWithValue("@JONO", k.JONO); strQuery.Parameters.AddWithValue("@STYLEID", k.STYLEID); strQuery.Parameters.AddWithValue("@COLORID", k.COLORID); strQuery.Parameters.AddWithValue("@DELIVERYDATE", k.DELIVERYDATE); strQuery.Parameters.AddWithValue("@BUTTONING", k.BUTTONING); strQuery.Parameters.AddWithValue("@WASHING", k.WASHING); strQuery.Parameters.AddWithValue("@STARTDATE", k.STARTDATE); strQuery.Parameters.AddWithValue("@CLOSEDATE", k.CLOSEDATE); strQuery.ExecuteNonQuery(); stat = true; ConnG.Putus(); } catch (Exception ex) { MessageBox.Show(ex.Message); } return(stat); }
public bool updateData(production k, string JONO1, string STYLEID1, string COLORID1) { bool stat = false; try { Connection ConnG = new Connection(); ConnG.Konek(); strQuery = new MySqlCommand(); strQuery.Connection = ConnG.Conn; strQuery.CommandType = CommandType.Text; strQuery.CommandText = "UPDATE tblproduction SET JONO=@JONO,STYLEID=@STYLEID,COLORID=@COLORID,DELIVERYDATE=@DELIVERYDATE,BUTTONING=@BUTTONING," + "WASHING=@WASHING,STARTDATE=@STARTDATE,CLOSEDATE=@CLOSEDATE" + " WHERE JONO=@JONO1 AND STYLEID=@STYLEID1 AND COLORID=@COLORID1 "; //key strQuery.Parameters.AddWithValue("@JONO1", JONO1); strQuery.Parameters.AddWithValue("@STYLEID1", STYLEID1); strQuery.Parameters.AddWithValue("@COLORID1", COLORID1); strQuery.Parameters.AddWithValue("@JONO", k.JONO); strQuery.Parameters.AddWithValue("@STYLEID", k.STYLEID); strQuery.Parameters.AddWithValue("@COLORID", k.COLORID); strQuery.Parameters.AddWithValue("@DELIVERYDATE", k.DELIVERYDATE); strQuery.Parameters.AddWithValue("@BUTTONING", k.BUTTONING); strQuery.Parameters.AddWithValue("@WASHING", k.WASHING); strQuery.Parameters.AddWithValue("@STARTDATE", k.STARTDATE); strQuery.Parameters.AddWithValue("@CLOSEDATE", k.CLOSEDATE); strQuery.ExecuteNonQuery(); ConnG.Putus(); stat = true; } catch (Exception ex) { MessageBox.Show(ex.Message); } return(stat); }