public async Task <User> GetUserByUsernameAsync(string username) { User user = null; SqlOperation sqlO = new SqlOperation() { ProcedureName = "RET_USER_BY_USERNAME", }; sqlO.addParameter(username, "Username"); try { List <Dictionary <string, object> > data = await SqlDaoInstance.ExecuteQueryProcedureAsync(sqlO); if (data != null) { foreach (var UserData in data) { user = (User)BuildObject(UserData, (new User())); } } } catch (Exception ex) { throw ex; } return(user); }
public async Task <List <Course> > RetriveUsersAsync() { SqlOperation sqlO = new SqlOperation() { ProcedureName = "RET_USER" }; List <Course> listWM = new List <Course>(); BaseEntity wm = new Course(); try { List <Dictionary <string, object> > data = await SqlDaoInstance.ExecuteQueryProcedureAsync(sqlO); foreach (Dictionary <string, object> dict in data) { listWM.Add((Course)BuildObject(dict, (wm = new Course()))); } } catch (Exception ex) { throw ex; } return(listWM); }
public async Task <List <User> > GetUsersAsync() { try { List <User> users = null; var operation = new SqlOperation { ProcedureName = "RET_ALL_USERS", }; var data = await SqlDaoInstance.ExecuteQueryProcedureAsync(operation); if (data != null) { users = new List <User>(); foreach (Dictionary <string, object> dict in data) { users.Add((User)BuildObject(dict, (new User()))); } } return(users); } catch (Exception) { throw; } }