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