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(); }