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