public SAS.Common.Generic.List<TeamInfo> GetAllTeamList()
{
string commandText = string.Format("SELECT * FROM [{0}teamInfo] ORDER BY [createdate]", BaseConfigs.GetTablePrefix);
IDataReader reader = DbHelper.ExecuteReader(CommandType.Text, commandText);
SAS.Common.Generic.List<TeamInfo> tlist = new SAS.Common.Generic.List<TeamInfo>();
while (reader.Read())
{
TeamInfo team = new TeamInfo();
team.TeamID = TypeConverter.ObjectToInt(reader["teamID"], 0);
team.Name = reader["name"].ToString();
team.Teamdomain = reader["teamdomain"].ToString();
team.Templateid = TypeConverter.ObjectToInt(reader["templateid"].ToString(), 0);
team.BuildDate = Utils.GetStandardDate(reader["builddate"].ToString());
team.CreateDate = Utils.GetStandardDate(reader["createdate"].ToString());
team.UpdateDate = Utils.GetStandardDate(reader["updatedate"].ToString());
team.Imgs = reader["imgs"].ToString();
team.Bio = reader["bio"].ToString();
team.Content1 = reader["content1"].ToString();
team.Content2 = reader["content2"].ToString();
team.Content3 = reader["content3"].ToString();
team.Content4 = reader["content4"].ToString();
team.Stutas = TypeConverter.ObjectToInt(reader["stutas"], 0);
team.Pageviews = TypeConverter.ObjectToInt(reader["pageviews"], 0);
team.Displayorder = TypeConverter.ObjectToInt(reader["displayorder"], 0);
team.TeamMember = reader["teammember"].ToString();
team.Seokeywords = reader["seokeywords"].ToString();
team.Seodescription = reader["seodescription"].ToString();
team.Creater = reader["creater"].ToString();
tlist.Add(team);
}
reader.Close();
return tlist;
}
public SAS.Common.Generic.List<AlbumCategoryInfo> GetAlbumCategory()
{
string commandText = string.Format("SELECT * FROM [{0}albumcategories] ORDER BY [displayorder]", BaseConfigs.GetTablePrefix);
IDataReader reader = DbHelper.ExecuteReader(CommandType.Text, commandText);
SAS.Common.Generic.List<AlbumCategoryInfo> acic = new SAS.Common.Generic.List<AlbumCategoryInfo>();
while (reader.Read())
{
AlbumCategoryInfo aci = new AlbumCategoryInfo();
aci.Albumcateid = TypeConverter.ObjectToInt(reader["albumcateid"], 0);
aci.Albumcount = TypeConverter.ObjectToInt(reader["albumcount"], 0);
aci.Description = reader["description"].ToString();
aci.Displayorder = TypeConverter.ObjectToInt(reader["displayorder"], 0);
aci.Title = reader["title"].ToString();
acic.Add(aci);
}
reader.Close();
return acic;
}