public bool updateData(joborder 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 = "UPDATE tbljoborder SET ORDERNO=@ORDERNO,QUANTITY=@QUANTITY,ITEMSID=@ITEMSID,GDIV=@GDIV, " + " POCUSTOMER=@POCUSTOMER,TYPEID=@TYPEID,CATEGORYID=@CATEGORYID,DATE=@DATE,OFFICER=@OFFICER,CUSTVENDCODE=@CUSTVENDCODE,ADDRESS=@ADDRESS," + " DELIVERYDATE=@DELIVERYDATE,DELIVERY=@DELIVERY,REMARKS=@REMARKS,APPROVE=@APPROVE,APPROVEDATE=@APPROVEDATE, " + " APPROVEBY=@APPROVEBY,WASH=@WASH" + " WHERE ORDERNO=@ORDERNO"; strQuery.Parameters.AddWithValue("@ORDERNO", k.ORDERNO); strQuery.Parameters.AddWithValue("@QUANTITY", k.QUANTITY); strQuery.Parameters.AddWithValue("@ITEMSID", k.ITEMSID); strQuery.Parameters.AddWithValue("@GDIV", k.GDIV); strQuery.Parameters.AddWithValue("@TYPEID", k.TYPEID); strQuery.Parameters.AddWithValue("@CATEGORYID", k.CATEGORYID); strQuery.Parameters.AddWithValue("@POCUSTOMER", k.POCUSTOMER); strQuery.Parameters.AddWithValue("@DATE", k.DATE); strQuery.Parameters.AddWithValue("@OFFICER", k.OFFICER); strQuery.Parameters.AddWithValue("@CUSTVENDCODE", k.CUSTVENDCODE); strQuery.Parameters.AddWithValue("@ADDRESS", k.ADDRESS); strQuery.Parameters.AddWithValue("@DELIVERYDATE", k.DELIVERYDATE); strQuery.Parameters.AddWithValue("@DELIVERY", k.DELIVERY); strQuery.Parameters.AddWithValue("@REMARKS", k.REMARKS); strQuery.Parameters.AddWithValue("@APPROVE", k.APPROVE); strQuery.Parameters.AddWithValue("@APPROVEDATE", k.APPROVEDATE); strQuery.Parameters.AddWithValue("@APPROVEBY", k.APPROVEBY); strQuery.Parameters.AddWithValue("@WASH", k.WASH); strQuery.ExecuteNonQuery(); ConnG.Putus(); stat = true; } catch (Exception ex) { MessageBox.Show(ex.Message); } return(stat); }
public bool insertData(joborder 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 tbljoborder(ORDERNO,QUANTITY,ITEMSID,GDIV,POCUSTOMER,TYPEID,CATEGORYID,DATE,OFFICER,CUSTVENDCODE,ADDRESS,DELIVERYDATE,DELIVERY,REMARKS,APPROVE,APPROVEDATE,APPROVEBY,WASH) " + " VALUES(@ORDERNO,@QUANTITY,@ITEMSID,@GDIV,@POCUSTOMER,@TYPEID,@CATEGORYID,@DATE,@OFFICER,@CUSTVENDCODE,@ADDRESS,@DELIVERYDATE,@DELIVERY,@REMARKS,@APPROVE,@APPROVEDATE,@APPROVEBY,@WASH)"; strQuery.Parameters.AddWithValue("@ORDERNO", k.ORDERNO); strQuery.Parameters.AddWithValue("@QUANTITY", k.QUANTITY); strQuery.Parameters.AddWithValue("@ITEMSID", k.ITEMSID); strQuery.Parameters.AddWithValue("@GDIV", k.GDIV); strQuery.Parameters.AddWithValue("@TYPEID", k.TYPEID); strQuery.Parameters.AddWithValue("@CATEGORYID", k.CATEGORYID); strQuery.Parameters.AddWithValue("@POCUSTOMER", k.POCUSTOMER); strQuery.Parameters.AddWithValue("@DATE", k.DATE); strQuery.Parameters.AddWithValue("@OFFICER", k.OFFICER); strQuery.Parameters.AddWithValue("@CUSTVENDCODE", k.CUSTVENDCODE); strQuery.Parameters.AddWithValue("@ADDRESS", k.ADDRESS); strQuery.Parameters.AddWithValue("@DELIVERYDATE", k.DELIVERYDATE); strQuery.Parameters.AddWithValue("@DELIVERY", k.DELIVERY); strQuery.Parameters.AddWithValue("@REMARKS", k.REMARKS); strQuery.Parameters.AddWithValue("@APPROVE", k.APPROVE); strQuery.Parameters.AddWithValue("@APPROVEDATE", k.APPROVEDATE); strQuery.Parameters.AddWithValue("@APPROVEBY", k.APPROVEBY); strQuery.Parameters.AddWithValue("@WASH", k.WASH); strQuery.ExecuteNonQuery(); stat = true; ConnG.Putus(); } catch (Exception ex) { MessageBox.Show(ex.Message); } return(stat); }