using System;
using Npgsql;
using NpgsqlTypes;
using System.Collections.Generic;

namespace Project1
{
	class MainClass
	{
		public static void Main (string[] args)
		{
			DBManagement db = new DBManagement();
			db.getStates ();
			Console.WriteLine ("Please enter a State from the following list:");
			db.printStates ();
			string userState = Console.ReadLine();
		}
	}

	public class DBManagement
	{
		List<string> statelist = new List<string>();
		public void getStates()
		{
			using (var conn = new NpgsqlConnection("Host=localhost; Username=admin; Password=D3c1@nair#; Database=Milestone1DB"))
			{
				conn.Open ();
				using (var cmd = new NpgsqlCommand ())
				{
					cmd.Connection = conn;
					cmd.CommandText = "SELECT DISTINCT state FROM business ORDER BY state";
					using(var reader = cmd.ExecuteReader())
					{
						while (reader.Read())
						{
							statelist.Add(reader.GetString(0));
						}
					}
				}
				conn.Close();
			}
		}
		public void printStates()
		{
			foreach (string state in statelist)
			{
				Console.Write(state + " ");
			}
			Console.WriteLine ("");
		}
	}
}