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);
}
