public List<UserInfo> User_GetActivedItems()
{
SQLDataHelper SQLDB = new SQLDataHelper();
SqlDataReader rd = SQLDB.executereader("sp_User_GetActivedItems", CommandType.StoredProcedure);
List<UserInfo> list = new List<UserInfo>();
UserInfo item = null;
while (rd.Read())
{
item = new UserInfo();
item.UserID = int.Parse(rd["UserID"].ToString());
item.UserName = rd["UserName"].ToString();
list.Add(item);
}
return list;
}
public List<UserInfo> User_GetItems([Optional, DefaultParameterValue(0)] int UserID)
{
SQLDataHelper SQLDB = new SQLDataHelper();
SQLDB.Addparameter("@UserID", UserID);
SqlDataReader rd = SQLDB.executereader("sp_User_GetItems", CommandType.StoredProcedure);
List<UserInfo> list = new List<UserInfo>();
UserInfo item = null;
while (rd.Read())
{
item = new UserInfo();
item.UserID = int.Parse(rd["UserID"].ToString());
item.UserName = rd["UserName"].ToString();
item.FullName = rd["FullName"].ToString();
item.DisplayName = rd["DisplayName"].ToString();
item.IsActived = int.Parse(rd["IsActived"].ToString());
list.Add(item);
}
return list;
}
public UserInfo User_GetItem(int UserID)
{
SQLDataHelper SQLDB = new SQLDataHelper();
SQLDB.Addparameter("@UserID", UserID);
SqlDataReader rd = SQLDB.executereader("sp_User_GetItem", CommandType.StoredProcedure);
UserInfo item = null;
while (rd.Read())
{
item = new UserInfo();
item.UserID = int.Parse(rd["UserID"].ToString());
item.UserName = rd["UserName"].ToString();
item.FullName = rd["FullName"].ToString();
item.DisplayName = rd["DisplayName"].ToString();
item.IsActived = int.Parse(rd["IsActived"].ToString());
}
return item;
}
