private void cmbUnionID_changed(object sender, EventArgs e) { //cmbUnionID.SelectedText = ""; areaCls row = allData.Where(x => x.NGEOCODE == Convert.ToInt32(cmbUnionID.SelectedItem)).FirstOrDefault(); cmbUnion.SelectedIndex = cmbUnion.Items.IndexOf(row.UNINAME); }
private void cmbUnion_changed(object sender, EventArgs e) { //cmbUnionID.SelectedText = ""; areaCls row = allData.Where(x => x.UNINAME == cmbUnion.SelectedItem.ToString()).FirstOrDefault(); cmbUnionID.SelectedIndex = cmbUnionID.Items.IndexOf(Convert.ToInt32(row.NGEOCODE).ToString()); //cmbDist.SelectedIndex = cmbDist.Items.IndexOf(Convert.ToInt32(row.NGEOCODE).ToString()); }
private void generate_graph_click(object sender, EventArgs e) { completeTask(); if (cmbUnion.SelectedIndex != -1) { areaCls row = allData.Where(x => x.UNINAME == cmbUnion.SelectedItem.ToString()).FirstOrDefault(); if (row != null) { try { string WINDSPEED_AILA = Convert.ToString(System.Configuration.ConfigurationSettings.AppSettings["aila"]); string WINDSPEED_MAHASEN = Convert.ToString(System.Configuration.ConfigurationSettings.AppSettings["mahasen"]); string WINDSPEED_SIDR = Convert.ToString(System.Configuration.ConfigurationSettings.AppSettings["sidr"]); Dictionary <double, Double> chart_data = new Dictionary <double, Double>(); Dictionary <string, Double> chart_tmp_data = new Dictionary <string, Double>(); foreach (string storms in Directory.GetDirectories(txtDataFolder.Text + pathseperator + cmbScenerio.SelectedItem.ToString() + pathseperator)) { string obs_file = storms + pathseperator + row.obs_point + ".csv"; var reader = new StreamReader(File.OpenRead(obs_file)); int i = 0; while (!reader.EndOfStream) { string line = reader.ReadLine(); i++; if (i == 1) { continue; } string[] values = line.Split(','); if (obs_file.Contains("aila")) { chart_tmp_data.Add("aila", Double.Parse(values[1])); } else if (obs_file.Contains("sidr")) { chart_tmp_data.Add("sidr", Double.Parse(values[1])); } else { chart_tmp_data.Add("mahasen", Double.Parse(values[1])); } } } chart_data.Add(double.Parse(WINDSPEED_MAHASEN), chart_tmp_data["mahasen"]); chart_data.Add(double.Parse(WINDSPEED_AILA), chart_tmp_data["aila"]); chart_data.Add(double.Parse(WINDSPEED_SIDR), chart_tmp_data["sidr"]); gen_chart(chart_data); } catch (Exception ex) { lbllog.Text = ex.Message; } } } }
private void load_data() { string file = txtareaLoc.Text; try { string text = File.ReadAllText(file); var fileName = string.Format(file); var connectionString = string.Format("Provider=Microsoft.ACE.OLEDB.12.0; data source={0}; Extended Properties=Excel 12.0;", fileName); var adapter = new OleDbDataAdapter("SELECT * FROM [Sheet1$]", connectionString); var ds = new DataSet(); adapter.Fill(ds, "area"); DataTable data = ds.Tables["area"]; //dataGridView1.DataSource = data; //dataGridView1.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCellsExceptHeader); var enn = ds.Tables["area"].AsEnumerable(); allData = enn.Where(x => x.Field <object>(0).ToString() != "FID").Select(x => new areaCls { FID = x.Field <Double?>(0), //NGEOCODE = x.Field<Double?>(3), DIVNAME = x.Field <String>(3), DISTNAME = x.Field <String>(4), THANAME = x.Field <String>(5), UNINAME = x.Field <String>(6), NGEOCODE = x.Field <Double?>(7), /*Pol_height = x.Field<Double?>(17), * Pol_nam = x.Field<String>(18), * LinkID = x.Field<Double?>(33), * netCDF_IDs = x.Field<String>(179), * DDIEM_dist = x.Field<Double?>(180), * DDIEM_than = x.Field<Double?>(181),*/ area_cal = x.Field <Double?>(14), DDIEM_unio = x.Field <Double?>(13) //obs_point = x.Field<String>(184) }).ToList(); connectionString = string.Format("Provider=Microsoft.ACE.OLEDB.12.0; data source={0}; Extended Properties=Excel 12.0;", string.Format(txtobsLoc.Text)); adapter = new OleDbDataAdapter("SELECT * FROM [Sheet1$]", connectionString); ds = new DataSet(); adapter.Fill(ds, "obs"); data = ds.Tables["obs"]; enn = ds.Tables["obs"].AsEnumerable(); foreach (areaCls cls in allData) { areaCls tmp = enn.Where(x => x.Field <object>(14).ToString() == cls.NGEOCODE.ToString() && x.Field <object>(10).ToString() == cls.UNINAME).Select(x => new areaCls { FID = x.Field <Double?>(0), //NGEOCODE = x.Field<Double?>(3), /*DIVNAME = x.Field<String>(3), * DISTNAME = x.Field<String>(4), * THANAME = x.Field<String>(5), * UNINAME = x.Field<String>(6), * NGEOCODE = x.Field<Double?>(7),*/ /*Pol_height = x.Field<Double?>(17), * Pol_nam = x.Field<String>(18), * LinkID = x.Field<Double?>(33), * netCDF_IDs = x.Field<String>(179), * DDIEM_dist = x.Field<Double?>(180), * DDIEM_than = x.Field<Double?>(181),*/ /* area_cal = x.Field<Double?>(14), * DDIEM_unio = x.Field<Double?>(13)*/ obs_point = x.Field <String>(184) }).FirstOrDefault(); if (tmp != null) { cls.obs_point = tmp.obs_point; } else { lbllog.Text += " not found " + cls.UNINAME; } } //label1.Text = allData[0].FID.ToString(); //lbllog.Text = "Data Loaded"; cmbThana.Items.Clear(); cmbUnion.Items.Clear(); cmbUnionID.Items.Clear(); cmbDist.Items.Clear(); cmbDist.Items.Add("All"); IList <String> dists = (from dbo in allData orderby dbo.DISTNAME ascending select dbo.DISTNAME).Distinct().ToList(); foreach (String dist in dists) { cmbDist.Items.Add(dist); } IList <String> thanas = (from dbo in allData orderby dbo.THANAME ascending select dbo.THANAME).Distinct().ToList(); foreach (String dist in thanas) { cmbThana.Items.Add(dist); } foreach (areaCls tmp in allData) { cmbUnion.Items.Add(tmp.UNINAME); cmbUnionID.Items.Add(int.Parse(tmp.NGEOCODE.ToString()).ToString()); } foreach (string s in Directory.GetDirectories(txtDataFolder.Text)) { cmbScenerio.Items.Add(Path.GetFileName(Path.GetDirectoryName(s + pathseperator))); cmbScenerio.SelectedIndex = cmbScenerio.Items.Count - 1; } } catch (Exception ex) { lbllog.Text = ex.Message; } }