public bool updateData(mtermofpayment 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 tblmtermofpayment SET DAYS=@Days,TERMTYPE=@TermType,ACTIVE=@Active WHERE TERMOFPAYMENT=@TermOfPayment"; strQuery.Parameters.AddWithValue("@TermOfPayment", k.TermOfPayment); strQuery.Parameters.AddWithValue("@TERMTYPE", k.TermType); strQuery.Parameters.AddWithValue("@Days", k.Days); strQuery.Parameters.AddWithValue("@Active", k.Active); strQuery.ExecuteNonQuery(); ConnG.Putus(); stat = true; } catch { } return(stat); }
public bool insertData(mtermofpayment 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 tblmtermofpayment VALUES(@TermOfPayment,@Days,@TermType,@Active)"; strQuery.Parameters.AddWithValue("@TermOfPayment", k.TermOfPayment); strQuery.Parameters.AddWithValue("@Days", k.Days); strQuery.Parameters.AddWithValue("@TermType", k.TermType); strQuery.Parameters.AddWithValue("@Active", k.Active); strQuery.ExecuteNonQuery(); stat = true; ConnG.Putus(); } catch (Exception ex) { MessageBox.Show(ex.Message); } return(stat); }