//===================================================CRUD public bool insertData(moduluser k) { bool stat = false; try { Connection ConnG = new Connection(); ConnG.Konek(); strQuery = new MySqlCommand(); strQuery.Connection = ConnG.Conn; strQuery.CommandType = CommandType.Text; strQuery.CommandText = "INSERT INTO tblmoduluser(USERID,MODUL,SAVE,UPDAT,DEL,PRINT,APPROVE,ACKNOWLEGMENT,UNAPPROVE,CEK,SEE) VALUES(@USERID,@MODUL,@SAVE,@UPDAT,@DEL,@PRINT,@APPROVE,@ACKNOWLEGMENT,@UNAPPROVE,@CEK,@SEE)"; strQuery.Parameters.AddWithValue("@USERID", k.USERID); strQuery.Parameters.AddWithValue("@MODUL", k.MODUL); strQuery.Parameters.AddWithValue("@SAVE", k.SAVE); strQuery.Parameters.AddWithValue("@UPDAT", k.UPDAT); strQuery.Parameters.AddWithValue("@DEL", k.DEL); strQuery.Parameters.AddWithValue("@PRINT", k.PRINT); strQuery.Parameters.AddWithValue("@APPROVE", k.APPROVE); strQuery.Parameters.AddWithValue("@ACKNOWLEGMENT", k.ACKNOWLEGMENT); strQuery.Parameters.AddWithValue("@UNAPPROVE", k.UNAPPROVE); strQuery.Parameters.AddWithValue("@CEK", k.CEK); strQuery.Parameters.AddWithValue("@SEE", k.SEE); strQuery.ExecuteNonQuery(); stat = true; ConnG.Putus(); } catch (Exception ex) { MessageBox.Show(ex.Message); } return(stat); }
public bool updateData(moduluser k) { bool stat = false; try { Connection ConnG = new Connection(); ConnG.Konek(); strQuery = new MySqlCommand(); strQuery.Connection = ConnG.Conn; strQuery.CommandType = CommandType.Text; strQuery.CommandText = "UPDATE tblmoduluser SET SAVE=@SAVE,UPDAT=@UPDAT,DEL=@DEL,PRINT=@PRINT,APPROVE=@APPROVE,ACKNOWLEGMENT=@ACKNOWLEGMENT,UNAPPROVE=@UNAPPROVE,CEK=@CEK,SEE=@SEE WHERE USERID=@USERID AND MODUL=@MODUL"; strQuery.Parameters.AddWithValue("@USERID", k.USERID); strQuery.Parameters.AddWithValue("@MODUL", k.MODUL); strQuery.Parameters.AddWithValue("@SAVE", k.SAVE); strQuery.Parameters.AddWithValue("@UPDAT", k.UPDAT); strQuery.Parameters.AddWithValue("@DEL", k.DEL); strQuery.Parameters.AddWithValue("@PRINT", k.PRINT); strQuery.Parameters.AddWithValue("@APPROVE", k.APPROVE); strQuery.Parameters.AddWithValue("@ACKNOWLEGMENT", k.ACKNOWLEGMENT); strQuery.Parameters.AddWithValue("@UNAPPROVE", k.UNAPPROVE); strQuery.Parameters.AddWithValue("@CEK", k.CEK); strQuery.Parameters.AddWithValue("@SEE", k.SEE); strQuery.ExecuteNonQuery(); ConnG.Putus(); stat = true; } catch { } return(stat); }