//Insert All-Transactions House Price Index for Arizona public void InsertAZSTHPI(System.Web.UI.WebControls.ListBox ListBox1) { string a, b, c, d, e, f, g, h, i; FRED m = new FRED(); a = m.getDate(); // date b = "Arizona"; // stateName c = m.AZSTHPI(); // all-transactions HPI d = "NULL"; // 20rsa e = "NULL"; // 20rnsa f = "NULL"; // 20rpsnsa g = "NULL"; // 10rsa h = "NULL"; // 10rnsa i = "NULL"; // 10rpsnsa if (c == "DNF") { ListBox1.Text += "AZSTHPI up to date! \n"; } else { try { String query = String.Format("INSERT INTO state_stats VALUES('{0}', '{1}', '{2}', {3}, {4}, {5}, {6}, {7}, {8})", a, b, c, d, e, f, g, h, i); //create command and assign the query and connection from the constructor MySqlCommand cmd = new MySqlCommand(query, connection); //Execute command cmd.ExecuteNonQuery(); ListBox1.Text += String.Format("{0} has been updated with AZSTHPI. \n", a); } catch { UpdateAZSTHPI(c, a, ListBox1); } } }
//Insert PHOENIX CITY unemployment_NSA statement public void InsertPhoeURN(System.Web.UI.WebControls.ListBox ListBox1) { string a, b, c, d, e; FRED f = new FRED(); b = "Phoenix"; // cityName c = "Maricopa"; // countyName d = "NULL"; // home_price_index a = f.getDate(); // date e = f.phoeURN(); // unemployment if (e == "DNF") { ListBox1.Text += "phoeURN up to date! \n"; } else { try { String query = String.Format("INSERT INTO city_stats VALUES('{0}', '{1}', '{2}', {3}, '{4}')", a, b, c, d, e); //create command and assign the query and connection from the constructor MySqlCommand cmd = new MySqlCommand(query, connection); //Execute command cmd.ExecuteNonQuery(); ListBox1.Text += String.Format("{0} has been updated with phoeURN. \n", a); } catch { UpdatePhoeURN(e, a, ListBox1); } } }
//Insert PHOENIX CITY home_price_index statement public void InsertPHXrnsa(System.Web.UI.WebControls.ListBox ListBox1) { //open connection if (this.OpenConnection() == true) { string a, b, c, d, e; FRED f = new FRED(); b = "Phoenix"; // cityName c = "Maricopa"; // countyName d = f.phxrnsa(); // home_price_index a = f.getDate(); // date e = "NULL"; // unemployment MessageBox.Show(a); if (d == "DNF") { ListBox1.Text = "PHXrnsa up to date! \n"; } else { try { String query = String.Format("INSERT INTO city_stats VALUES('{0}', '{1}', '{2}', '{3}', {4})", a, b, c, d, e); //create command and assign the query and connection from the constructor MySqlCommand cmd = new MySqlCommand(query, connection); //Execute command cmd.ExecuteNonQuery(); ListBox1.Text = String.Format("{0} has been updated with PHXrnsa. \n", a); } catch { UpdatePHXrnsa(d, a, ListBox1); } } } }
//Insert MARICOPA COUNTY unemployment_NSA statement public void InsertMariURN(System.Web.UI.WebControls.ListBox ListBox1) { string a, b, c, d, e, f; FRED m = new FRED(); a = m.getDate(); // date b = "Maricopa"; //countyName c = "Arizona"; // stateName d = m.AZMARIURN(); // unemployment_NSA e = "NULL"; // population_NSA f = "NULL"; // labor_force_NSA if (d == "DNF") { ListBox1.Text += "mariURN up to date! \n"; } else { try { String query = String.Format("INSERT INTO county_stats VALUES('{0}', '{1}', '{2}', '{3}', {4}, {5})", a, b, c, d, e, f); //create command and assign the query and connection from the constructor MySqlCommand cmd = new MySqlCommand(query, connection); //Execute command cmd.ExecuteNonQuery(); ListBox1.Text += String.Format("{0} has been updated with MariURN. \n", a); } catch { UpdateMariURN(d, a, ListBox1); } } }