public bool DeleteAccessPermissionGroup(DTO_AccessPermissionGroup deleteAccPerGr)
{
string sql = $"delete from AccessPermissionGroup where AccessPermissionID = '{deleteAccPerGr.AccessPermissionID}' and EmployeeTypeID = '{deleteAccPerGr.EmployeeTypeID}'";
SQLiteCommand insert = new SQLiteCommand(sql, getConnection().OpenAndReturn());
try
{
insert.ExecuteNonQuery();
return(true);
}
catch (Exception)
{
return(false);
}
}
public bool CreateAccessPermissionGroup(DTO_AccessPermissionGroup newAccPerGr)
{
//insert SQLite
string sql = $"insert into AccessPermissionGroup('EmployeeTypeID','AccessPermissionID') VALUES ('{newAccPerGr.EmployeeTypeID}','{newAccPerGr.AccessPermissionID}')";
SQLiteCommand insert = new SQLiteCommand(sql, getConnection().OpenAndReturn());
try
{
insert.ExecuteNonQuery();
return(true);
}
catch (Exception)
{
return(false);
}
}
public bool DeleteAccessPermissionGroup(DTO_AccessPermissionGroup accPerGr)
{
return(dalAccPerGr.DeleteAccessPermissionGroup(accPerGr));
}
public bool CreateAccessPermissionGroup(DTO_AccessPermissionGroup newAccPerGr)
{
return(dalAccPerGr.CreateAccessPermissionGroup(newAccPerGr));
}