public Advertise AdvertiseIDataReader(IDataReader dr)
{
DataAccess.Advertise obj = new DataAccess.Advertise();
obj.AdvID = (dr["AdvID"] is DBNull) ? string.Empty : dr["AdvID"].ToString();
obj.RealEstateId = (dr["RealEstateId"] is DBNull) ? string.Empty : dr["RealEstateId"].ToString();
obj.AdvName = (dr["AdvName"] is DBNull) ? string.Empty : dr["AdvName"].ToString();
obj.Image = (dr["Image"] is DBNull) ? string.Empty : dr["Image"].ToString();
obj.Width = (dr["Width"] is DBNull) ? string.Empty : dr["Width"].ToString();
obj.Height = (dr["Height"] is DBNull) ? string.Empty : dr["Height"].ToString();
obj.Link = (dr["Link"] is DBNull) ? string.Empty : dr["Link"].ToString();
obj.Target = (dr["Target"] is DBNull) ? string.Empty : dr["Target"].ToString();
obj.Content = (dr["Content"] is DBNull) ? string.Empty : dr["Content"].ToString();
obj.Position = (dr["Position"] is DBNull) ? string.Empty : dr["Position"].ToString();
obj.PageId = (dr["PageId"] is DBNull) ? string.Empty : dr["PageId"].ToString();
obj.Click = (dr["Click"] is DBNull) ? string.Empty : dr["Click"].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);
}
public List <Advertise> Advertise_GetByAll(string Lang)
{
List <DataAccess.Advertise> list = new List <DataAccess.Advertise>();
using (SqlCommand dbCmd = new SqlCommand("Advertise_SelectAll", GetConnection()))
{
DataAccess.Advertise obj = new DataAccess.Advertise();
dbCmd.CommandType = CommandType.StoredProcedure;
dbCmd.Parameters.Add(new SqlParameter("@Lang", Lang));
SqlDataReader dr = dbCmd.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
list.Add(obj.AdvertiseIDataReader(dr));
}
}
dr.Close();
obj = null;
}
return(list);
}
public List <Advertise> Advertise_GetByTop(string Top, string Where, string Order)
{
List <DataAccess.Advertise> list = new List <DataAccess.Advertise>();
using (SqlCommand dbCmd = new SqlCommand("Advertise_SelectTop", GetConnection()))
{
DataAccess.Advertise obj = new DataAccess.Advertise();
dbCmd.CommandType = CommandType.StoredProcedure;
dbCmd.Parameters.Add(new SqlParameter("@Top", Top));
dbCmd.Parameters.Add(new SqlParameter("@Where", Where));
dbCmd.Parameters.Add(new SqlParameter("@Order", Order));
SqlDataReader dr = dbCmd.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
list.Add(obj.AdvertiseIDataReader(dr));
}
}
dr.Close();
obj = null;
}
return(list);
}
