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