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