public IEnumerable <GetSpecials> GetSpecials() { List <GetSpecials> specials = new List <GetSpecials>(); using (var conn = new SqlConnection(Settings.GetConnectionString())) { SqlCommand cmd = new SqlCommand("GetAllSpecials", conn); cmd.CommandType = CommandType.StoredProcedure; conn.Open(); using (SqlDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { GetSpecials hp = new GetSpecials(); hp.SpecialId = int.Parse(dr["SpecialId"].ToString()); hp.SpecialTitle = dr["SpecialTitle"].ToString(); hp.SpecialDescription = dr["SpecialDescription"].ToString(); specials.Add(hp); } } } return(specials); }
public IEnumerable <GetSpecials> GetSpecials() { List <GetSpecials> specials = new List <GetSpecials>(); GetSpecials hp = new GetSpecials(); foreach (var spec in specials) { spec.SpecialId = hp.SpecialId; spec.SpecialTitle = hp.SpecialTitle; spec.SpecialDescription = hp.SpecialDescription; specials.Add(spec); } return(specials); }
public IEnumerable <GetSpecials> GetSpecials() { List <GetSpecials> specials = new List <GetSpecials>(); using (_ctx) { var listOfSpecials = _ctx.GetAllSpecials(); foreach (var s in listOfSpecials) { GetSpecials hp = new GetSpecials(); hp.SpecialId = s.SpecialId; hp.SpecialTitle = s.SpecialTitle; hp.SpecialDescription = s.SpecialDescription; specials.Add(hp); } } return(specials); }
public List <GetSpecials> GetAllSpecials() { List <GetSpecials> specials = new List <GetSpecials>(); using (_ctx = new GuildCarsEntities()) { var listOfSpecials = _ctx.GetAllSpecials(); foreach (var s in listOfSpecials) { GetSpecials hp = new GetSpecials(); hp.SpecialId = s.SpecialId; hp.SpecialTitle = s.SpecialTitle; hp.SpecialDescription = s.SpecialDescription; specials.Add(hp); } } return(specials); //throw new NotImplementedException(); }