public static SageFrameUserCollection SearchUsers(string RoleID, string SearchText, int PortalID, string UserName) { string sp = "[dbo].[usp_SageFrameUserListSearch]"; SageFrameSQLHelper sagesql = new SageFrameSQLHelper(); SageFrameUserCollection userColl = new SageFrameUserCollection(); List<UserInfo> lstUsers = new List<UserInfo>(); List<KeyValuePair<string, object>> ParamCollInput = new List<KeyValuePair<string, object>>(); ParamCollInput.Add(new KeyValuePair<string, object>("@RoleID", RoleID)); ParamCollInput.Add(new KeyValuePair<string, object>("@SearchText", SearchText)); ParamCollInput.Add(new KeyValuePair<string, object>("@PortalID", PortalID)); ParamCollInput.Add(new KeyValuePair<string, object>("@Username", UserName)); try { SqlDataReader reader; reader = sagesql.ExecuteAsDataReader(sp, ParamCollInput); while (reader.Read()) { UserInfo obj = new UserInfo(); obj.UserID = new Guid(reader["userid"].ToString()); obj.UserName = reader["username"].ToString(); obj.FirstName = reader["firstname"].ToString(); obj.LastName = reader["lastname"].ToString(); obj.Email = reader["email"].ToString(); obj.IsActive = bool.Parse(reader["IsActive"].ToString()); lstUsers.Add(obj); } reader.Close(); userColl.UserList = lstUsers; return userColl; } catch (Exception ex) { throw (ex); } }
public static SageFrameUserCollection GetAllUsers() { string sp = "[dbo].[usp_UsersGetAll]"; SQLHandler sagesql = new SQLHandler(); SageFrameUserCollection userColl = new SageFrameUserCollection(); List<UserInfo> lstUsers = new List<UserInfo>(); try { SqlDataReader reader; reader = sagesql.ExecuteAsDataReader(sp); while (reader.Read()) { UserInfo obj = new UserInfo(); obj.UserID = new Guid(reader["userid"].ToString()); obj.UserName = reader["username"].ToString(); obj.FirstName = reader["firstname"].ToString(); obj.LastName = reader["lastname"].ToString(); obj.Email = reader["email"].ToString(); lstUsers.Add(obj); } reader.Close(); userColl.UserList = lstUsers; return userColl; } catch (Exception ex) { throw (ex); } }