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));
}
