public bool updateData(cutt k, string CUTNO1) { bool stat = false; try { Connection ConnG = new Connection(); ConnG.Konek(); strQuery = new MySqlCommand(); strQuery.Connection = ConnG.Conn; strQuery.CommandType = CommandType.Text; strQuery.CommandText = "UPDATE tblcutt SET CUTNO=@CUTNO,OFFICER=@OFFICER,DATE=@DATE,JONO=@JONO,STYLEID=@STYLEID,COLORID=@COLORID,CREATEDATE=@CREATEDATE,NOOFCUT=@NOOFCUT,NOOFLAYER=@NOOFLAYER,LINE=@LINE" + " WHERE CUTNO=@CUTNO1 "; //key strQuery.Parameters.AddWithValue("@CUTNO1", CUTNO1); //no key strQuery.Parameters.AddWithValue("@CUTNO", k.CUTNO); strQuery.Parameters.AddWithValue("@OFFICER", k.OFFICER); strQuery.Parameters.AddWithValue("@DATE", k.DATE); strQuery.Parameters.AddWithValue("@JONO", k.JONO); strQuery.Parameters.AddWithValue("@STYLEID", k.STYLEID); strQuery.Parameters.AddWithValue("@COLORID", k.COLORID); strQuery.Parameters.AddWithValue("@CREATEDATE", k.CREATEDATE); strQuery.Parameters.AddWithValue("@NOOFCUT", k.NOOFCUT); strQuery.Parameters.AddWithValue("@NOOFLAYER", k.NOOFLAYER); strQuery.Parameters.AddWithValue("@LINE", k.LINE); strQuery.ExecuteNonQuery(); ConnG.Putus(); stat = true; } catch (Exception ex) { MessageBox.Show(ex.Message); } return(stat); }
public bool insertData(cutt 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 tblcutt(CUTNO,OFFICER,DATE,JONO,STYLEID,COLORID,CREATEDATE,NOOFCUT,NOOFLAYER,LINE) " + "VALUES(@CUTNO,@OFFICER,@DATE,@JONO,@STYLEID,@COLORID,@CREATEDATE,@NOOFCUT,@NOOFLAYER,@LINE)"; strQuery.Parameters.AddWithValue("@CUTNO", k.CUTNO); strQuery.Parameters.AddWithValue("@OFFICER", k.OFFICER); strQuery.Parameters.AddWithValue("@DATE", k.DATE); strQuery.Parameters.AddWithValue("@JONO", k.JONO); strQuery.Parameters.AddWithValue("@STYLEID", k.STYLEID); strQuery.Parameters.AddWithValue("@COLORID", k.COLORID); strQuery.Parameters.AddWithValue("@CREATEDATE", k.CREATEDATE); strQuery.Parameters.AddWithValue("@NOOFCUT", k.NOOFCUT); strQuery.Parameters.AddWithValue("@NOOFLAYER", k.NOOFLAYER); strQuery.Parameters.AddWithValue("@LINE", k.LINE); strQuery.ExecuteNonQuery(); stat = true; ConnG.Putus(); } catch (Exception ex) { MessageBox.Show(ex.Message); } return(stat); }