public static Role Get(int roleID)
{
Role role = new Role();
string query = "SELECT role_id,role_name,role_description FROM kk_user_role WHERE role_id = @role_id;";
using (SqliteConnection conn = new SqliteConnection(connectionString))
{
using (SqliteCommand cmd = new SqliteCommand(query, conn))
{
cmd.Parameters.Add("@role_id", System.Data.DbType.Int32).Value = roleID;
conn.Open();
using (SqliteDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
DBFill(reader, role);
}
}
}
}
return role;
}
public static List<Role> GetAll()
{
List<Role> roles = new List<Role>();
string query = "SELECT role_id,role_name,role_description FROM kk_user_role;";
using (SqliteConnection conn = new SqliteConnection(connectionString))
{
using (SqliteCommand cmd = new SqliteCommand(query, conn))
{
conn.Open();
using (SqliteDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
Role role = new Role();
DBFill(reader, role);
roles.Add(role);
}
}
}
}
return roles;
}
// add user access role
// delete user access role
public static void DBFill(SqliteDataReader reader, Role role)
{
role.RoleID = Convert.ToInt32(reader["role_id"]);
role.RoleName = reader["role_name"].ToString();
role.RoleDescription = reader["role_description"].ToString();
}
