var connectionString : String = "Data Source=LAPTOP-F5GQ6QN2\SQLEXPRESS2014; Initial Catalog=ParsleyTankPortal; Integrated Security=SSPI;";

function LoadComboBoxesPick_CommandExecuted(sender : System.Object, cmdArgs : Ico.Gwx.CommandExecutionEventArgs)
{
	var commandString : String;
	commandString = "SELECT PropertyName+ ' (' +CONVERT(VARCHAR(20),PropertyID)+ ')' as PropertyName, PropertyID FROM dbo.tbl_DisposalLocation";
	//PopulateCombo("SitesComboBox", commandString);

	var wfCtl : Ico.Gwx.GwxWindowsFormsControl;
	var comboBox : System.Windows.Forms.ComboBox;

	wfCtl = Ico.Gwx.GwxWindowsFormsControl(ThisConfiguration.GetObjectByName("StateComboBox"));
	comboBox = System.Windows.Forms.ComboBox(wfCtl.Control);
	var stateShortName: String[] = ["AL",
"AK",
"AZ",
"AR",
"CA",
"CO",
"CT",
"DE",
"FL",
"GA",
"HI",
"ID",
"IL",
"IN",
"IA",
"KS",
"KY",
"LA",
"ME",
"MD",
"MA",
"MI",
"MN",
"MS",
"MO",
"MT",
"NE",
"NV",
"NH",
"NJ",
"NM",
"NY",
"NC",
"ND",
"OH",
"OK",
"OR",
"PA",
"RI",
"SC",
"SD",
"TN",
"TX",
"UT",
"VT",
"VA",
"WA",
"WV",
"WI",
"WY"];



var stateFullName: String[] = ["Alabama",
"Alaska",
"Arizona",
"Arkansas",
"California",
"Colorado",
"Connecticut",
"Delaware",
"Florida",
"Georgia",
"Hawaii",
"Idaho",
"Illinois",
"Indiana",
"Iowa",
"Kansas",
"Kentucky",
"Louisiana",
"Maine",
"Maryland",
"Massachusetts",
"Michigan",
"Minnesota",
"Mississippi",
"Missouri",
"Montana",
"Nebraska",
"Nevada",
"New Hampshire",
"New Jersey",
"New Mexico",
"New York",
"North Carolina",
"North Dakota",
"Ohio",
"Oklahoma",
"Oregon",
"Pennsylvania",
"Rhode Island",
"South Carolina",
"South Dakota",
"Tennessee",
"Texas",
"Utah",
"Vermont",
"Virginia",
"Washington",
"West Virginia",
"Wisconsin",
"Wyoming"];

//comboBox.Items.Add
	var dataTable : System.Data.DataTable;

	dataTable = new DataTable();

	var dataColumn1 : System.Data.DataColumn;
	dataColumn1 = new DataColumn("Text")
	dataTable.Columns.Add(dataColumn1);

	var dataColumn2 : System.Data.DataColumn;
	dataColumn2 = new DataColumn("Key")
	dataTable.Columns.Add(dataColumn2);


	for(var i=0; i<stateShortName.Length; i++){
		var row : System.Data.DataRow;
		row = dataTable.NewRow();
		row[0] = stateFullName[i];
		row[1] = stateShortName[i];
		dataTable.Rows.Add(row);
	}


	comboBox.DataSource = dataTable;

	comboBox.DisplayMember = "Text";
	comboBox.ValueMember = "Key";

	ThisWindow.SetGlobalAliases("#CustomerState="+comboBox.SelectedValue+";");
}

function PopulateCombo(comboName, commandString)
{
	// Declare variables
	var wfCtl : Ico.Gwx.GwxWindowsFormsControl;
	var combo : System.Windows.Forms.ComboBox;
	var conn : System.Data.SqlClient.SqlConnection;
	var command : System.Data.SqlClient.SqlCommand;
	var dataAdaptor: System.Data.SqlClient.SqlDataAdapter;
	var dataTable: System.Data.DataTable;

	// Initialize variables
	conn = new System.Data.SqlClient.SqlConnection(connectionString);
	conn.Open();
	command = new System.Data.SqlClient.SqlCommand(commandString, conn);
	dataAdapter = new System.Data.SqlClient.SqlDataAdapter(command);
	dataTable = new System.Data.DataTable();
	//MessageBox.Show("HI");
	dataAdapter.Fill(dataTable);

		// Get the control and give it properties
	wfCtl = Ico.Gwx.GwxWindowsFormsControl(ThisConfiguration.GetObjectByName(comboName));
	combo = System.Windows.Forms.ComboBox(wfCtl.Control);
	combo.DataSource = dataTable;
	combo.DisplayMember = dataTable.Columns[0].ColumnName;
	combo.ValueMember = dataTable.Columns[1].ColumnName;

	conn.Close();

	//ThisWindow.SetGlobalAliases("#P18ReportSite="+combo.SelectedValue+";");
	ThisWindow.SetGlobalAliases("#CustDisppropertyID="+combo.SelectedValue+";");


}