using System;
using System.Collections.Generic;
using System.Linq;
using System.Net;
using System.Net.Http;
using System.Web.Http;
using TelerikAcademy.Data;
using System.Text;

namespace EmptyWebApplication.Controllers
{
    public class TownsController : ApiController
    {
        // GET /api/towns/get-towns
        [ActionName("get-towns")]
        public string GetTown()
        {
            List<string> towns;
            using (var telerikDb = new TelerikAcademyEntities())
            {
                towns = telerikDb.Towns.Where(t => t.Name.StartsWith("S")).Select(t => t.Name).ToList();
            }
            StringBuilder sb = new StringBuilder();
            foreach (var item in towns)
            {
                sb.AppendLine(item + "\n");
            }
            return sb.ToString();
        }
    }
}