using System;
using System.Collections;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;

namespace Action_Tire_Payment_Processor
{
    public partial class GiftCardInfoForm : Form
    {
        DataRow CurrentCard = null;
        CardTransaction Transaction = null;

        public GiftCardInfoForm()
        {
            InitializeComponent();
            object[] states = StateArray.States();
            cbGiftState.DataSource = states;
            cbLoyaltyState.DataSource = states;

            panelGift.Visible = false;
            panelLoyalty.Visible = false;
        }

        private void btnFind_Click(object sender, EventArgs e)
        {
            string query = "SELECT * FROM Gift_Card_Registry WHERE ";

            panelGift.Visible = false;
            panelLoyalty.Visible = false;
            CurrentCard = null;

            string registry_query =
            "FirstName LIKE @SEARCH+'%' " +
            "OR LastName LIKE @SEARCH+'%' " +
            "OR Address LIKE @SEARCH+'%' " +
            "OR City LIKE @SEARCH+'%' " +
            "OR State LIKE @SEARCH+'%' " +
            "OR Zip LIKE @SEARCH+'%' " +
            "OR Phone LIKE @SEARCH+'%' " +
            "OR Email LIKE @SEARCH+'%' " +
            "OR CAST(CardNbr as VARCHAR(50)) = @SEARCH ";

            string transaction_query = "OR OrderID LIKE @SEARCH%";

            string[] terms = tbFind.Text.Split(' ');

            for (int i =0; i<terms.Length;i++)
            {
                query += ((i>0)?" OR ":"") + registry_query.Replace("@SEARCH", "@SEARCH" + i);
            }

            SqlCommand cmd = new SqlCommand(query, Database.sql);
            for (int i = 0; i < terms.Length; i++)
            {
                cmd.Parameters.AddWithValue("@SEARCH"+i, terms[i]);
            }

            DataTable results = Database.Query(cmd);

            dgvSearch.DataSource = results;

            if (results.Rows.Count > 1) tabControl1.SelectedTab = tabPageSearch;
            if (results.Rows.Count == 1)
            {
                LoadGiftTab(results.Rows[0]);
            }
        }

        private void tbFind_KeyDown(object sender, KeyEventArgs e)
        {

        }

        private void tbFind_KeyPress(object sender, KeyPressEventArgs e)
        {
            if (e.KeyChar == '\r')
            {
                e.Handled = true;
                btnFind_Click(this, null);
            }
        }

        private void dgvSearch_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
        {
            if (e.RowIndex < 0) return;
            DataTable data = (DataTable)dgvSearch.DataSource;
            LoadGiftTab(data.Rows[e.RowIndex]);
            //tabControl1.SelectedTab = tabPageGift;
        }

        private void LoadGiftTab(DataRow card)
        {
            string query = "SELECT * FROM Gift_Card_Transactions WHERE CardNbr = @CARDNUMBER ORDER BY DateCreated DESC";
            SqlCommand cmd = new SqlCommand(query, Database.sql);
            cmd.Parameters.AddWithValue("@CARDNUMBER", card["CardNbr"]);
            DataTable transactions = Database.Query(cmd);

            Transaction = new CardTransaction();
            CurrentCard = card;
            
            if (card["CardType"].ToString().Equals("Gift Card"))
            {                
                tabControl1.SelectedTab = tabPageGift;
                panelGift.Visible = true;
                panelLoyalty.Visible = false;

                lblGiftCardNumber.Text = card["CardNbr"].ToString();
                lblGiftBalance.Text = String.Format("{0:C}", (decimal)card["Balance"]);

                tbGiftFirstName.Text = card["FirstName"].ToString();
                tbGiftLastName.Text = card["LastName"].ToString();

                tbGiftAddress.Text = card["Address"].ToString();
                tbGiftCity.Text = card["City"].ToString();
                if (!card["State"].ToString().Equals(""))
                {
                    for (int i = 0; i < cbGiftState.Items.Count; i++)
                    {
                        US_State state = (US_State)cbGiftState.Items[i];

                        if (state.Name.Contains(card["State"].ToString()))
                        {
                            cbGiftState.SelectedIndex = i;
                            break;
                        }
                    }
                }
                tbGiftZip.Text = card["Zip"].ToString();
                tbGiftPhone.Text = card["Phone"].ToString();
                tbGiftEmail.Text = card["Email"].ToString();
                dgvGiftTransactions.DataSource = transactions;
            }

            if (card["CardType"].ToString().Equals("Loyalty Card"))
            {
                tabControl1.SelectedTab = tabPageLoyalty;
                panelLoyalty.Visible = true;
                panelGift.Visible = false;

                lblLoyaltyCardNumber.Text = card["CardNbr"].ToString();
                lblLoyaltyBalance.Text = String.Format("{0:C}", (decimal)card["Balance"]);

                tbLoyaltyFirstName.Text = card["FirstName"].ToString();
                tbLoyaltyLastName.Text = card["LastName"].ToString();

                tbLoyaltyAddress.Text = card["Address"].ToString();
                tbLoyaltyCity.Text = card["City"].ToString();
                if (!card["State"].ToString().Equals(""))
                {
                    cbLoyaltyState.SelectedIndex = StateArray.StateIndex(card["State"].ToString());
                }
                tbLoyaltyZip.Text = card["Zip"].ToString();
                tbLoyaltyPhone.Text = card["Phone"].ToString();
                tbLoyaltyEmail.Text = card["Email"].ToString();
                dgvLoyaltyTransactions.DataSource = transactions;
            }
        }

        private void tbGiftFirstName_TextChanged(object sender, EventArgs e)
        {

        }

        private void tbGiftLastName_TextChanged(object sender, EventArgs e)
        {

        }

        private void tbGiftAddress_TextChanged(object sender, EventArgs e)
        {

        }

        private void tbGiftCity_TextChanged(object sender, EventArgs e)
        {

        }

        private void cbGiftState_SelectedIndexChanged(object sender, EventArgs e)
        {

        }

        private void tbGiftZip_TextChanged(object sender, EventArgs e)
        {

        }

        private void tbGiftPhone_TextChanged(object sender, EventArgs e)
        {

        }

        private void tbGiftEmail_TextChanged(object sender, EventArgs e)
        {

        }

        private void btnLoyaltyProcess_Click(object sender, EventArgs e)
        {
            ProcessCard(true);
        }

        private void btnGiftProcess_Click(object sender, EventArgs e)
        {
            ProcessCard(false);
        }

        public void ProcessCard(bool loyalty)
        {
            
            DataTable search = dgvSearch.DataSource as DataTable;
            bool update = false;

            string firstName = loyalty ? tbLoyaltyFirstName.Text : tbGiftFirstName.Text;
            string lastName = loyalty ? tbLoyaltyLastName.Text : tbGiftLastName.Text;
            string address = loyalty ? tbLoyaltyAddress.Text : tbGiftAddress.Text;
            string city = loyalty ? tbLoyaltyCity.Text : tbGiftCity.Text;
            string state = loyalty ? ((US_State)cbLoyaltyState.SelectedItem).Name : ((US_State)cbGiftState.SelectedItem).Name;
            string zip = loyalty ? tbLoyaltyZip.Text : tbGiftZip.Text;
            string phone = loyalty ? tbLoyaltyPhone.Text : tbGiftPhone.Text;
            string email = loyalty ? tbLoyaltyEmail.Text : tbGiftEmail.Text;
            string cardNumber = loyalty ? lblLoyaltyCardNumber.Text : lblGiftCardNumber.Text;
            string orderNumber = loyalty ? tbLoyaltyOrderNumber.Text : tbGiftOrderNumber.Text;
            string cardType = loyalty ? "Loyalty Card" : "Gift Card"; 

            if ((loyalty && cbLoyaltyUpdateInfo.Checked) || (!loyalty && cbGiftUpdateInfo.Checked))
            {
                if (!firstName.Equals(CurrentCard["FirstName"]) ||
                    !lastName.Equals(CurrentCard["LastName"]))
                {
                    string query = "SELECT * FROM Gift_Card_Registry WHERE FirstName = @FirstName AND LastName = @LastName";
                    SqlCommand cmd = new SqlCommand(query, Database.sql);
                    cmd.Parameters.AddWithValue("@FirstName", firstName);
                    cmd.Parameters.AddWithValue("@LastName", lastName);
                    DataTable results = Database.Query(cmd);

                    if (results.Rows.Count > 0)
                    {
                        DialogResult dr = MessageBox.Show("This customer already has " + results.Rows.Count + " cards registered.  Are you sure you want to update this card?", "Multiple Cards Exist", MessageBoxButtons.YesNo);
                        if (dr == DialogResult.No) update = false;
                        if (dr == DialogResult.Yes) update = true;
                    }
                    else
                    {
                        update = true;
                    }
                }
                else
                {
                    update = true;
                }

                if (update)
                {
                    string query = "UPDATE Gift_Card_Registry SET CardType = @CardType, FirstName = @FirstName, LastName = @LastName, Address = @Address, City = @City, State = @State, Zip = @Zip, Phone = @Phone, Email = @Email WHERE CardNbr = @CardNumber";
                    SqlCommand cmd = new SqlCommand(query, Database.sql);
                    cmd.Parameters.AddWithValue("@CardType", cardType);
                    cmd.Parameters.AddWithValue("@FirstName", firstName);
                    cmd.Parameters.AddWithValue("@LastName", lastName);
                    cmd.Parameters.AddWithValue("@Address", address);
                    cmd.Parameters.AddWithValue("@City", city);
                    cmd.Parameters.AddWithValue("@State", state);
                    cmd.Parameters.AddWithValue("@Zip", zip);
                    cmd.Parameters.AddWithValue("@Phone", phone);
                    cmd.Parameters.AddWithValue("@Email", email);
                    cmd.Parameters.AddWithValue("@CardNumber", cardNumber);
                    Database.NonQuery(cmd);

                    tbFind.Text = CurrentCard["CardNbr"].ToString();
                    btnFind_Click(null, null);
                    //LoadCard(int.Parse(lblLoyaltyCardNumber.Text));
                    //LoadGiftTab(CurrentCard);
                }
            }
            else
            {
                float amount = loyalty ? float.Parse(tbLoyaltyAmount.Text) : float.Parse(tbGiftAmount.Text);
                float balance = loyalty ? float.Parse(lblLoyaltyBalance.Text.Replace("$", "").Replace(",", "")) : float.Parse(lblGiftBalance.Text.Replace("$", "").Replace(",", ""));

                if ((balance - amount) < 0.0f)
                {
                    MessageBox.Show("The payment amount cannot exceed the balance of the card.");
                    tbLoyaltyAmount.Focus();
                    return;
                }

                DialogResult dr = MessageBox.Show("Are you sure you would like to make a payment from " + cardType + " " + cardNumber + " with " + String.Format("{0:C}", amount) + "\nbringing the card balance to " + String.Format("{0:C}", balance - amount) + " ?", "Confirm Payment", MessageBoxButtons.YesNo);
                if (dr == DialogResult.No) return;

                string query = "INSERT INTO Gift_Card_Transactions (StoreID, OrderID, TransType, Amount, CardNbr, CardType, FirstName, LastName, Address, City, State, Zip, Phone, Email, DateCreated, CreatedBy) Values (@StoreID, @OrderID, @TransType, @Amount, @CardNbr, @CardType, @FirstName, @LastName, @Address, @City, @State, @Zip, @Phone, @Email, @DateCreated, @CreatedBy); SELECT IDENT_CURRENT('Gift_Card_Transactions') AS RecID;";
                SqlCommand cmd = new SqlCommand(query, Database.sql);
                cmd.Parameters.AddWithValue("@StoreID", Settings.GetOption("STORE"));
                cmd.Parameters.AddWithValue("@OrderID", orderNumber);
                cmd.Parameters.AddWithValue("@TransType", "sale");
                cmd.Parameters.AddWithValue("@Amount", amount);
                cmd.Parameters.AddWithValue("@CardNbr", cardNumber);
                cmd.Parameters.AddWithValue("@CardType", cardType);
                cmd.Parameters.AddWithValue("@FirstName", firstName);
                cmd.Parameters.AddWithValue("@LastName", lastName);
                cmd.Parameters.AddWithValue("@Address", address);
                cmd.Parameters.AddWithValue("@City", city);
                cmd.Parameters.AddWithValue("@State", state);
                cmd.Parameters.AddWithValue("@Zip", zip);
                cmd.Parameters.AddWithValue("@Phone", phone);
                cmd.Parameters.AddWithValue("@Email", email);
                cmd.Parameters.AddWithValue("@DateCreated", DateTime.Now);
                cmd.Parameters.AddWithValue("@CreatedBy", Environment.UserName);
                DataTable result = Database.Query(cmd);

                query = "UPDATE Gift_Card_Registry SET CardType = @CardType, FirstName = @FirstName, LastName = @LastName, Address = @Address, City = @City, State = @State, Zip = @Zip, Phone = @Phone, Email = @Email, Balance = @Balance WHERE CardNbr = @CardNumber";
                cmd = new SqlCommand(query, Database.sql);
                cmd.Parameters.AddWithValue("@CardType", cardType);
                cmd.Parameters.AddWithValue("@FirstName", firstName);
                cmd.Parameters.AddWithValue("@LastName", lastName);
                cmd.Parameters.AddWithValue("@Address", address);
                cmd.Parameters.AddWithValue("@City", city);
                cmd.Parameters.AddWithValue("@State", state);
                cmd.Parameters.AddWithValue("@Zip", zip);
                cmd.Parameters.AddWithValue("@Phone", phone);
                cmd.Parameters.AddWithValue("@Email", email);
                cmd.Parameters.AddWithValue("@CardNumber", cardNumber);
                cmd.Parameters.AddWithValue("@Balance", balance - amount);
                Database.NonQuery(cmd);

                int RecID = int.Parse(result.Rows[0][0].ToString());

                ReceiptForm rf = new ReceiptForm(RecID, true);
                rf.pnlBackground.BackColor = Color.Green;
               
                rf.lblAmount.Text = String.Format("{0:C}", amount);
                rf.lblCardNumber.Text = cardNumber;
                rf.lblType.Text = cardType;
                rf.lblTransactionID.Text = RecID + "";

                rf.ShowDialog();
                tbFind.Text = CurrentCard["CardNbr"].ToString();
                btnFind_Click(null, null);
            }
        }

        public void LoadCard(int CardNumber)
        {
            string query = "SELECT * FROM Gift_Card_Registry WHERE CardNbr = @CARDNUMBER";
            SqlCommand cmd = new SqlCommand(query, Database.sql);
            cmd.Parameters.AddWithValue("@CARDNUMBER", CardNumber);
            DataTable cards = Database.Query(cmd);
            if (cards.Rows.Count > 0)
            {
                dgvSearch.DataSource = cards;
                LoadGiftTab(cards.Rows[0]);
            }
        }

        private void tbLoyaltyOrderNumber_TextChanged(object sender, EventArgs e)
        {
            bool amountGood = false;

            try
            {
                float a = float.Parse(tbLoyaltyAmount.Text);
                if (a <= 0f) throw new Exception("Bad Amount");
                else amountGood = true;
            }
            catch { amountGood = false;  }

            if (!tbLoyaltyOrderNumber.Text.Equals("") && amountGood) btnLoyaltyProcess.Enabled = true;
            else btnLoyaltyProcess.Enabled = false;
        }

        private void tbGiftOrderNumber_TextChanged(object sender, EventArgs e)
        {
            bool amountGood = false;

            try
            {
                float a = float.Parse(tbGiftAmount.Text);
                if (a <= 0f) throw new Exception("Bad Amount");
                else amountGood = true;
            }
            catch { amountGood = false; }

            if (!tbGiftOrderNumber.Text.Equals("") && amountGood) btnGiftProcess.Enabled = true;
            else btnGiftProcess.Enabled = false;
        }

        private void tbLoyaltyAmount_TextChanged(object sender, EventArgs e)
        {
            tbLoyaltyOrderNumber_TextChanged(null, null);
        }

        private void tbGiftAmount_TextChanged(object sender, EventArgs e)
        {
            tbGiftOrderNumber_TextChanged(null, null);
        }

        private void cbGiftUpdateInfo_CheckedChanged(object sender, EventArgs e)
        {
            btnGiftProcess.Enabled = cbGiftUpdateInfo.Checked;
            tbGiftAmount.Enabled = !cbGiftUpdateInfo.Checked;
            tbGiftOrderNumber.Enabled = !cbGiftUpdateInfo.Checked;
            btnGiftProcess.Text = cbGiftUpdateInfo.Checked ? "Update Info" : "Process Payment";
        }

        private void cbLoyaltyUpdateInfo_CheckedChanged(object sender, EventArgs e)
        {
            btnLoyaltyProcess.Enabled = cbLoyaltyUpdateInfo.Checked;
            tbLoyaltyAmount.Enabled = !cbLoyaltyUpdateInfo.Checked;
            tbLoyaltyOrderNumber.Enabled = !cbLoyaltyUpdateInfo.Checked;
            btnLoyaltyProcess.Text = cbLoyaltyUpdateInfo.Checked ? "Update Info" : "Process Payment";
        }

        private void btnGiftReload_Click(object sender, EventArgs e)
        {

            ReloadCard(false);
        }

        private void btnLoyaltyReload_Click(object sender, EventArgs e)
        {

            ReloadCard(true);
        }

        private void ReloadCard(bool Loyalty)
        {
            float amount = float.Parse(Loyalty ? tbLoyaltyReloadAmount.Text : tbGiftReloadAmount.Text);
            string query = "INSERT INTO Gift_Card_Transactions (StoreID, TransType, Amount, CardNbr, CardType, DateCreated, CreatedBy) VALUES (" +
                "@StoreID, @TransType, @Amount, @CardNbr, @CardType, GetDate(), @CreatedBy)";
            SqlCommand cmd = new SqlCommand(query, Database.sql);
            cmd.Parameters.AddWithValue("@StoreID", Settings.GetOption("STORE"));
            cmd.Parameters.AddWithValue("@TransType", "reload");
            cmd.Parameters.AddWithValue("@Amount", amount);
            cmd.Parameters.AddWithValue("@CardNbr", CurrentCard["CardNbr"].ToString());
            cmd.Parameters.AddWithValue("@CardType", Loyalty ? "Loyalty Card" : "Gift Card");
            cmd.Parameters.AddWithValue("@CreatedBy", Environment.UserName);
            Database.NonQuery(cmd);

            query = "UPDATE Gift_Card_Registry SET Balance = @AMOUNT WHERE CardNbr = @CARDNUMBER";
            cmd = new SqlCommand(query, Database.sql);
            cmd.Parameters.AddWithValue("@AMOUNT", float.Parse(CurrentCard["Balance"].ToString()) + amount);
            cmd.Parameters.AddWithValue("@CARDNUMBER", CurrentCard["CardNbr"].ToString());
            Database.NonQuery(cmd);

            tbFind.Text = CurrentCard["CardNbr"].ToString();
            btnFind_Click(null, null);
        }

        private void tbGiftReloadAmount_TextChanged(object sender, EventArgs e)
        {
            try
            {
                float a = float.Parse(tbGiftReloadAmount.Text);
                if (a <= 0f) throw new Exception("Bad Amount");
                btnGiftReload.Enabled = true;
            }
            catch
            {
                btnGiftReload.Enabled = false;
            }
        }

        private void tbLoyaltyReloadAmount_TextChanged(object sender, EventArgs e)
        {
            try
            {
                float a = float.Parse(tbLoyaltyReloadAmount.Text);
                if (a <= 0f) throw new Exception("Bad Amount");
                btnLoyaltyReload.Enabled = true;
            }
            catch
            {
                btnLoyaltyReload.Enabled = false;
            }
        }

        private void btnLoyaltyReplace_Click(object sender, EventArgs e)
        {
            ReplaceCard();
        }


        private void ReplaceCard()
        {
            DialogResult dr = MessageBox.Show("Are you sure you want to remove the lost card from the card registry?", "Confirm Card Removal", MessageBoxButtons.YesNo);
            if (dr == DialogResult.No) return;

            ReplacementCardDialog rcd = new ReplacementCardDialog();
            dr = rcd.ShowDialog();
            if (dr == DialogResult.Cancel) return;
            string NewCardNumber = rcd.CardNumber;
            float NewBalance = float.Parse(CurrentCard["Balance"].ToString());
            string NewCardType = CurrentCard["CardType"].ToString();
            float b = GetCardBalance(NewCardNumber);
            if (b != -1000f)
            {
                MessageBox.Show(String.Format("Card #"+NewCardNumber+" is already registered with a balance of {0:C}", b));
                return;
            }

            string query = "UPDATE Gift_Card_Registry SET CardNbr = @NewCardNumber WHERE CardNbr = @OldCardNumber;" +
                "UPDATE Gift_Card_Transactions SET CardNbr = @NewCardNumber WHERE CardNbr = @OldCardNumber;" +
                "INSERT INTO Gift_Card_Transactions (StoreID, TransType, Amount, CardNbr, CardType, FirstName, DateCreated, CreatedBy) VALUES (@StoreID, 'replacement', 0, @NewCardNumber, 'Loyalty Card', @ReportedLost, GetDate(), @CreatedBy);" +
                "INSERT INTO Gift_Card_Registry (CardNbr, CardType, Balance, OriginalAmount, FirstName) VALUES (@OldCardNumber, 'Loyalty Card', 0, 0, @ReportedLost)" +
                "INSERT INTO Gift_Card_Transactions (StoreID, TransType, Amount, CardNbr, CardType, FirstName, DateCreated, CreatedBy) VALUES (@StoreID, 'replaced', 0, @OldCardNumber, 'Loyalty Card', @ReportedLost, GetDate(), @CreatedBy)";
            SqlCommand cmd = new SqlCommand(query, Database.sql);
            cmd.Parameters.AddWithValue("@OldCardNumber", CurrentCard["CardNbr"].ToString());
            cmd.Parameters.AddWithValue("@NewCardNumber", NewCardNumber);
            cmd.Parameters.AddWithValue("@StoreID", Settings.GetOption("STORE"));
            cmd.Parameters.AddWithValue("@CreatedBy", Environment.UserName);
            cmd.Parameters.AddWithValue("@ReportedLost", "REPORTED LOST; Replaced with Card #" + NewCardNumber);
            Database.NonQuery(cmd);

            tbFind.Text = NewCardNumber;
            btnFind_Click(null, null);
        }

        private float GetCardBalance(string CardNumber)
        {
            string query = "SELECT * FROM Gift_Card_Registry WHERE CardNbr = @CardNumber";
            SqlCommand cmd = new SqlCommand(query, Database.sql);
            cmd.Parameters.AddWithValue("@CardNumber", CardNumber);
            DataTable results = Database.Query(cmd);
            if (results.Rows.Count > 0)
            {
                return float.Parse(results.Rows[0]["Balance"].ToString());
            }

            else return -1000f;
        }

        private void DeleteCard()
        {
            string query = "DELETE FROM Gift_Card_Registry WHERE CardNbr = @CardNumber; DELETE FROM Gift_Card_Transactions WHERE CardNbr = @CardNumber;";
            SqlCommand cmd = new SqlCommand(query, Database.sql);
            cmd.Parameters.AddWithValue("@CardNumber", CurrentCard["CardNbr"].ToString());
            Database.NonQuery(cmd);
        }
    }

    public class CardTransaction
    {
        public string FirstName { get; set; }
        public string LastName { get; set; }
        
        public string Address { get; set; }
        public string City { get; set; }
        public string State { get; set; }
        public string Zip { get; set; }

        public string Phone { get; set; }
        public string Email { get; set; }

        public string CardType { get; set; }
        public string CardNumber { get; set; }
        public string OrderNumber { get; set; }
        public string Amount { get; set; }
    }

    static class StateArray
    {

        static List<US_State> states;

        static StateArray()
        {
            states = new List<US_State>(50);
            states.Add(new US_State("AL", "Alabama"));
            states.Add(new US_State("AK", "Alaska"));
            states.Add(new US_State("AZ", "Arizona"));
            states.Add(new US_State("AR", "Arkansas"));
            states.Add(new US_State("CA", "California"));
            states.Add(new US_State("CO", "Colorado"));
            states.Add(new US_State("CT", "Connecticut"));
            states.Add(new US_State("DE", "Delaware"));
            states.Add(new US_State("DC", "District Of Columbia"));
            states.Add(new US_State("FL", "Florida"));
            states.Add(new US_State("GA", "Georgia"));
            states.Add(new US_State("HI", "Hawaii"));
            states.Add(new US_State("ID", "Idaho"));
            states.Add(new US_State("IL", "Illinois"));
            states.Add(new US_State("IN", "Indiana"));
            states.Add(new US_State("IA", "Iowa"));
            states.Add(new US_State("KS", "Kansas"));
            states.Add(new US_State("KY", "Kentucky"));
            states.Add(new US_State("LA", "Louisiana"));
            states.Add(new US_State("ME", "Maine"));
            states.Add(new US_State("MD", "Maryland"));
            states.Add(new US_State("MA", "Massachusetts"));
            states.Add(new US_State("MI", "Michigan"));
            states.Add(new US_State("MN", "Minnesota"));
            states.Add(new US_State("MS", "Mississippi"));
            states.Add(new US_State("MO", "Missouri"));
            states.Add(new US_State("MT", "Montana"));
            states.Add(new US_State("NE", "Nebraska"));
            states.Add(new US_State("NV", "Nevada"));
            states.Add(new US_State("NH", "New Hampshire"));
            states.Add(new US_State("NJ", "New Jersey"));
            states.Add(new US_State("NM", "New Mexico"));
            states.Add(new US_State("NY", "New York"));
            states.Add(new US_State("NC", "North Carolina"));
            states.Add(new US_State("ND", "North Dakota"));
            states.Add(new US_State("OH", "Ohio"));
            states.Add(new US_State("OK", "Oklahoma"));
            states.Add(new US_State("OR", "Oregon"));
            states.Add(new US_State("PA", "Pennsylvania"));
            states.Add(new US_State("RI", "Rhode Island"));
            states.Add(new US_State("SC", "South Carolina"));
            states.Add(new US_State("SD", "South Dakota"));
            states.Add(new US_State("TN", "Tennessee"));
            states.Add(new US_State("TX", "Texas"));
            states.Add(new US_State("UT", "Utah"));
            states.Add(new US_State("VT", "Vermont"));
            states.Add(new US_State("VA", "Virginia"));
            states.Add(new US_State("WA", "Washington"));
            states.Add(new US_State("WV", "West Virginia"));
            states.Add(new US_State("WI", "Wisconsin"));
            states.Add(new US_State("WY", "Wyoming"));
        }

        public static string[] Abbreviations()
        {
            List<string> abbrevList = new List<string>(states.Count);
            foreach (var state in states)
            {
                abbrevList.Add(state.Abbreviations);
            }
            return abbrevList.ToArray();
        }

        public static string[] Names()
        {
            List<string> nameList = new List<string>(states.Count);
            foreach (var state in states)
            {
                nameList.Add(state.Name);
            }
            return nameList.ToArray();
        }

        public static US_State[] States()
        {
            return states.ToArray();
        }

        public static int StateIndex(string what)
        {
            for (int i = 0; i < states.Count; i++)
            {
                if (states[i].ToString().ToUpper().Contains(what.ToUpper())) return i;
            }

            return -1;
        }

    }

    class US_State
    {

        public US_State()
        {
            Name = null;
            Abbreviations = null;
        }

        public US_State(string ab, string name)
        {
            Name = name;
            Abbreviations = ab;
        }

        public string Name { get; set; }

        public string Value { get { return this.Name; } }

        public string Abbreviations { get; set; }

        public override string ToString()
        {
            return string.Format("{0} - {1}", Abbreviations, Name);
        }

    }
}