public List <Page> Page_GetByAll(string Lang)
{
List <DataAccess.Page> list = new List <DataAccess.Page>();
DataAccess.Page obj = new DataAccess.Page();
DbCommand cmd = db.GetStoredProcCommand("Pages_SelectAll", Lang);
using (IDataReader dr = db.ExecuteReader(cmd))
{
while (dr.Read())
{
list.Add(obj.PageIDataReader(dr));
}
dr.Close();
dr.Dispose();
}
return(list);
}
public List <Page> Page_GetByLevel(string Level, string Lang, int LevelLength)
{
List <DataAccess.Page> list = new List <DataAccess.Page>();
DataAccess.Page obj = new DataAccess.Page();
DbCommand cmd = db.GetStoredProcCommand("sp_Page_GetByLevel", Level, Lang, LevelLength);
using (IDataReader dr = db.ExecuteReader(cmd))
{
while (dr.Read())
{
list.Add(obj.PageIDataReader(dr));
}
dr.Close();
dr.Dispose();
}
return(list);
}
public List <Page> Page_GetByTop(string Top, string Where, string Order)
{
List <DataAccess.Page> list = new List <DataAccess.Page>();
DataAccess.Page obj = new DataAccess.Page();
DbCommand cmd = db.GetStoredProcCommand("Pages_SelectTop", Top, Where, Order);
using (IDataReader dr = db.ExecuteReader(cmd))
{
while (dr.Read())
{
list.Add(obj.PageIDataReader(dr));
}
dr.Close();
dr.Dispose();
}
return(list);
}
public Page PageIDataReader(IDataReader dr)
{
DataAccess.Page obj = new DataAccess.Page();
obj.PageID = (dr["PageID"] is DBNull) ? string.Empty : dr["PageID"].ToString();
obj.Name = (dr["Name"] is DBNull) ? string.Empty : dr["Name"].ToString();
obj.Tag = (dr["Tag"] is DBNull) ? string.Empty : dr["Tag"].ToString();
obj.Content = (dr["Content"] is DBNull) ? string.Empty : dr["Content"].ToString();
obj.Detail = (dr["Detail"] is DBNull) ? string.Empty : dr["Detail"].ToString();
obj.Level = (dr["Level"] is DBNull) ? string.Empty : dr["Level"].ToString();
obj.Title = (dr["Title"] is DBNull) ? string.Empty : dr["Title"].ToString();
obj.Description = (dr["Description"] is DBNull) ? string.Empty : dr["Description"].ToString();
obj.Keyword = (dr["Keyword"] is DBNull) ? string.Empty : dr["Keyword"].ToString();
obj.Type = (dr["Type"] is DBNull) ? string.Empty : dr["Type"].ToString();
obj.Link = (dr["Link"] is DBNull) ? string.Empty : dr["Link"].ToString();
obj.Target = (dr["Target"] is DBNull) ? string.Empty : dr["Target"].ToString();
obj.Position = (dr["Position"] is DBNull) ? string.Empty : dr["Position"].ToString();
obj.Index = (dr["Index"] is DBNull) ? string.Empty : dr["Index"].ToString();
obj.Ord = (dr["Ord"] is DBNull) ? string.Empty : dr["Ord"].ToString();
obj.Active = (dr["Active"] is DBNull) ? string.Empty : dr["Active"].ToString();
obj.Lang = (dr["Lang"] is DBNull) ? string.Empty : dr["Lang"].ToString();
return(obj);
}
