public List <UserRoleItem> GetUserRoles(User user) { var parameters = new List <DbQueryParameter>() { new DbQueryParameter("InsCode", user.InsCode), new DbQueryParameter("UserId", user.Id) }; List <UserRoleItem> userRoleItems = new List <UserRoleItem>(); var result = SqlDbManager.Instance().ExecuteProcedureDataSets(UserSpHelper.GetUserRolesSpName(), parameters, SqlDbManager.SqlConnectionMode.QUERYBOOK); if (result != null) { if (result.Tables.Count > 0 && result.Tables[0].Rows.Count > 0) { foreach (DataRow item in result.Tables[0].Rows) { UserRoleItem userRoleItem = new UserRoleItem { RoleName = item["RoleName"].ToString() }; userRoleItems.Add(userRoleItem); } } } return(userRoleItems); }
public User Get(User filter) { var parameters = new List <DbQueryParameter>() { new DbQueryParameter("InsCode", filter.InsCode), new DbQueryParameter("Email", filter.Email) }; return(LoadDataSetUser(SqlDbManager.Instance().ExecuteProcedureDataSets(UserSpHelper.GetSpName(), parameters, SqlDbManager.SqlConnectionMode.QUERYBOOK))); }