public JsonResult GunlukdurumGetir(string[] dataliste) { GunlukDurum gunlukNesne = new GunlukDurum(); DBMysql db = new DBMysql(); db.OpenConnection(); MySqlDataReader reader; int hours = DateTime.Now.Hour; int day = DateTime.Now.Day; int month = DateTime.Now.Month; string h1 = ""; string h2 = ""; string month_ = ""; string dd = ""; if (day == 1 && hours < 3) { month--; day = 30; } if (month < 10) { month_ = "0" + month.ToString(); } else { month_ = month.ToString(); } if (hours < 3 || hours >= 15) { h1 = "14"; h2 = "16"; day--; } else { h1 = "02"; h2 = "04"; } if (day < 10) { dd = "0" + day.ToString(); } else { dd = day.ToString(); } string date = DateTime.Now.ToString($"yyyy-{month_}-{dd} {h1}:00:00"); string date1 = DateTime.Now.ToString($"yyyy-{month_}-{dd} {h2}:00:00"); int dayWeather = Int32.Parse(dataliste[3]) - 1; reader = db.CommandReader($"SELECT * FROM DailyForecasts WHERE ilAdi='{dataliste[0]}' AND ilceAdi='{dataliste[1]}' AND (InsertDate BETWEEN '{date}' AND '{date1}')"); while (reader.Read()) { gunlukNesne.EnDusukSicaklik = reader.GetDecimal(9 + dayWeather); gunlukNesne.EnyuksekSicaklik = reader.GetDecimal(14 + dayWeather); gunlukNesne.hadiseKodu = reader.GetString(29 + dayWeather); gunlukNesne.EnDusukNem = reader.GetDecimal(19 + dayWeather); gunlukNesne.EnYuksekNem = reader.GetDecimal(24 + dayWeather); gunlukNesne.RuzgarHizi = reader.GetDecimal(34 + dayWeather); gunlukNesne.RuzgarYon = reader.GetDecimal(39 + dayWeather); } db.CloseConnection(); return(Json(gunlukNesne, JsonRequestBehavior.AllowGet)); }
public JsonResult VerileriGetir() { DBMysql db = new DBMysql(); List <GunlukDurum> nesneListem = new List <GunlukDurum>(); GunlukDurum gunlukNesne; db.OpenConnection(); List <SelectListItem> Liste_il = new List <SelectListItem>(); MySqlDataReader reader = db.CommandReader("select * from CityMasterTable"); while (reader.Read()) { if (reader.GetInt32(2) > 0) { gunlukNesne = new GunlukDurum(); gunlukNesne.lat = reader.GetDouble(4); gunlukNesne.lang = reader.GetDouble(5); gunlukNesne.ilAdi = reader.GetString(0); gunlukNesne.GunlukistNo = reader.GetInt32(6); nesneListem.Add(gunlukNesne); } } reader.Close(); int hours = DateTime.Now.Hour; int day = DateTime.Now.Day; int month = DateTime.Now.Month; string h1 = ""; string h2 = ""; string month_ = ""; string dd = ""; if (day == 1 && hours < 3) { month--; day = 30; } if (month < 10) { month_ = "0" + month.ToString(); } else { month_ = month.ToString(); } if (hours < 3 || hours >= 15) { h1 = "14"; h2 = "16"; day--; } else { h1 = "02"; h2 = "04"; } if (day < 10) { dd = "0" + day.ToString(); } else { dd = day.ToString(); } string date = DateTime.Now.ToString($"yyyy-{month_}-{dd} {h1}:00:00"); string date1 = DateTime.Now.ToString($"yyyy-{month_}-{dd} {h2}:00:00"); reader = db.CommandReader($"SELECT * FROM DailyForecasts WHERE (InsertDate BETWEEN '{date}' AND '{date1}')"); while (reader.Read()) { if (Convert.ToInt32(reader.GetInt32(2)) % 100 == 1) { int index = nesneListem.FindIndex(a => a.GunlukistNo == reader.GetInt32(2)); nesneListem[index].EnDusukSicaklik = reader.GetDecimal(9); nesneListem[index].EnyuksekSicaklik = reader.GetDecimal(14); nesneListem[index].hadiseKodu = reader.GetString(29); nesneListem[index].Resim = reader.GetString(29) + ".png"; } } db.CloseConnection(); return(Json(nesneListem, JsonRequestBehavior.AllowGet)); }
public JsonResult VeriGetir(string[] veriler) { DBMysql db = new DBMysql(); db.OpenConnection(); MySqlDataReader reader; List <model> Nesneler = new List <model>(); model md; if (veriler[0] != "il Seçin" && veriler[1] == "2") { reader = db.CommandReader($"select * from CityMasterTable Where Oncelik='1'"); } else if (veriler[0] != "il Seçin") { reader = db.CommandReader($"select * from CityMasterTable Where ilAdi='{veriler[0]}'"); } else { reader = db.CommandReader($"select * from CityMasterTable Where Oncelik='1'"); } while (reader.Read()) { if (reader.GetInt32(6) % 100 != 1 || reader.GetInt32(2) != 0) { md = new model(); md.lat = reader.GetDouble(4); //enlem md.lang = reader.GetDouble(5); //boylam md.ilAd = reader.GetString(0); //il ad md.ilceAd = reader.GetString(1); //ilce ad md.GunlukIstasyon = reader.GetInt32(6); //Gunlük istasyon no if (!reader.IsDBNull(reader.GetOrdinal("SaatlikTahminIstNo"))) { md.SaatlikIstasyon = reader.GetString(7);//Saatlik istasyon no } if (!reader.IsDBNull(reader.GetOrdinal("SonDurumTahminIstNo"))) { md.SonDurumIstasyon = reader.GetInt32(8);//son durum tahmin istasyon } Nesneler.Add(md); } } if (veriler[1] == "1") { List <GunlukDurum> gunlukNesne = new List <GunlukDurum>(); GunlukDurum g_nesne; reader.Close(); string date = DateTime.Now.ToString($"{veriler[3]} 02:00:00"); string date1 = DateTime.Now.ToString($"{veriler[3]} 04:00:00"); int dayWeather = int.Parse(veriler[2]) - 1; if (veriler[0] != "il Seçin") { reader = db.CommandReader($"SELECT * FROM DailyForecasts WHERE (InsertDate BETWEEN '{date}' AND '{date1}') AND ilAdi='{veriler[0]}'"); while (reader.Read()) { int index = Nesneler.FindIndex(a => a.GunlukIstasyon == reader.GetInt32(2)); g_nesne = new GunlukDurum(); g_nesne.ilAdi = Nesneler[index].ilAd; g_nesne.lat = Nesneler[index].lat; g_nesne.lang = Nesneler[index].lang; g_nesne.ilceAdi = Nesneler[index].ilceAd; g_nesne.GunlukistNo = Nesneler[index].GunlukIstasyon; g_nesne.EnDusukSicaklik = reader.GetDecimal(9 + dayWeather); g_nesne.EnyuksekSicaklik = reader.GetDecimal(14 + dayWeather); g_nesne.hadiseKodu = reader.GetString(29 + dayWeather); g_nesne.Resim = reader.GetString(29 + dayWeather) + ".png"; g_nesne.EnDusukNem = reader.GetDecimal(19 + dayWeather); g_nesne.EnYuksekNem = reader.GetDecimal(24 + dayWeather); g_nesne.RuzgarHizi = reader.GetDecimal(34 + dayWeather); g_nesne.RuzgarYon = reader.GetDecimal(39 + dayWeather); gunlukNesne.Add(g_nesne); } } else { int indexSayac = 0; reader = db.CommandReader($"SELECT * FROM DailyForecasts WHERE (InsertDate BETWEEN '{date}' AND '{date1}')"); while (reader.Read()) { if (Convert.ToInt32(reader.GetInt32(2)) % 100 == 1) { int index = Nesneler.FindIndex(a => a.GunlukIstasyon == reader.GetInt32(2)); g_nesne = new GunlukDurum(); g_nesne.ilAdi = Nesneler[index].ilAd; g_nesne.lat = Nesneler[index].lat; g_nesne.lang = Nesneler[index].lang; g_nesne.ilceAdi = Nesneler[index].ilceAd; g_nesne.GunlukistNo = Nesneler[index].GunlukIstasyon; g_nesne.EnDusukSicaklik = reader.GetDecimal(9 + dayWeather); g_nesne.EnyuksekSicaklik = reader.GetDecimal(14 + dayWeather); g_nesne.hadiseKodu = reader.GetString(29 + dayWeather); g_nesne.Resim = reader.GetString(29 + dayWeather) + ".png"; g_nesne.EnDusukNem = reader.GetDecimal(19 + dayWeather); g_nesne.EnYuksekNem = reader.GetDecimal(24 + dayWeather); g_nesne.RuzgarHizi = reader.GetDecimal(34 + dayWeather); g_nesne.RuzgarYon = reader.GetDecimal(39 + dayWeather); if (indexSayac == 0 || gunlukNesne[indexSayac - 1].GunlukistNo != g_nesne.GunlukistNo) { gunlukNesne.Add(g_nesne); indexSayac++; } } } } return(Json(gunlukNesne, JsonRequestBehavior.AllowGet)); } else if (veriler[1] == "2") { List <SaatlikDurum> saatlikNesne_; int DataHours = ((int.Parse(veriler[2])) - 1); int saat = 0; saatlikNesne_ = SaatlikIstek(db, reader, Nesneler, veriler, saat); while (saatlikNesne_.Count < 70) { reader.Close(); saat += 3; saatlikNesne_ = SaatlikIstek(db, reader, Nesneler, veriler, saat); } return(Json(saatlikNesne_, JsonRequestBehavior.AllowGet)); } db.CloseConnection(); return(Json(Nesneler, JsonRequestBehavior.AllowGet)); }