public List <QuangCao> QuangCao_GetByTop(string Top, string Where, string Order) { List <Entity.QuangCao> list = new List <Entity.QuangCao>(); using (SqlCommand dbCmd = new SqlCommand("sp_QuangCao_GetByTop", GetConnection())) { Entity.QuangCao obj = new Entity.QuangCao(); 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(); dr.Close(); dr = dbCmd.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { list.Add(obj.QuangCaoIDataReader(dr)); } } dr.Close(); obj = null; } return(list); }
public Entity.QuangCao QuangCaoIDataReader(IDataReader dr) { Entity.QuangCao obj = new Entity.QuangCao(); obj.Id = (dr["Id"] is DBNull) ? string.Empty : dr["Id"].ToString(); obj.UrlImage = (dr["UrlImage"] is DBNull) ? string.Empty : dr["UrlImage"].ToString(); obj.Active = (dr["Active"] is DBNull) ? string.Empty : dr["Active"].ToString(); obj.Count_Click = (dr["Count_Click"] is DBNull) ? string.Empty : dr["Count_Click"].ToString(); return(obj); }