public static async Task <string> Apiget()
{
try
{ //"Mae Hong Son""Uttaradit"
//"Chiang Rai", String[] province = new String[] { "Chiang Mai", "Lampang","Chiang Rai", "Lamphun", "Nan", "Phayao", "Phrae",
//"Kalasin", "Khon Kaen", "Chaiyaphum", "Nakhon Phanom", "Nakhon Ratchasima", "Bueng Kan", "Buriram", "Maha Sarakham", "Mukdahan", "Yasothon", "Roi Et",
// "Loei","Sakon Nakhon","Surin","Sisaket","Nong Khai","Nong Bua Lamphu","Udon Thani","Ubon Ratchathani","Amnat Charoen",
// "Bangkok","Kamphaeng Phet","Chai Nat","Nakhon Nayok","Nakhon Pathom","Nakhon Sawan","Nonthaburi","Pathum Thani","Phra Nakhon Si Ayutthaya","Phichit ","Phitsanulok ","Phetchabun ",
// "Lopburi ","Samut Prakan","Samut Songkhram","Samut Sakhon","Sing Buri","Sukhothai","Suphan Buri","Saraburi","Ang Thong","Uthai Thani",
// "Chanthaburi","Chachoengsao","Chonburi","Trat","Prachinburi","Rayong","Sa Kaeo","Kanchanaburi","Tak","Prachuap Khiri Khan","Phetchaburi","Ratchaburi",
// "Krabi","Chumphon","Trang","Nakhon Si Thammarat","Narathiwat","Pattani","Phang Nga","Phatthalung","Phuket","Ranong","Satun","Songkhla","Surat Thani","Yala"};
String[] province = new String[] { "Chiang Mai", "Chiang Rai", "Lampang", "Lamphun", "Nan", "Phayao", "Phrae",
"Khon Kaen", "Nakhon Ratchasima", "Loei", "Nong Khai", "Ubon Ratchathani", "Bangkok" };
using (test_dbContext ctx = new test_dbContext())
{
foreach (string cityname in province)
{
var m = await fetch(cityname);
var datatest = m.data;
var datatest1 = m.data.iaqi;
MstDataRaw getdata = new MstDataRaw()
{
Aqi = datatest.aqi,
Idx = datatest.idx,
City = datatest.city.name,
//Co = datatest1.co.V,
H = datatest1.h.V,
//No2 = datatest1.no2.V,
//O3 = datatest1.o3.V,
P = datatest1.p.V,
Pm25 = datatest1.pm25.V,
Pm10 = datatest1.pm10.V,
//So2 = datatest1.so2.V,
T = datatest1.t.V,
W = datatest1.w.V,
time = DateTime.Now,
CreateAt = DateTime.Now,
UploadAt = DateTime.Now,
};
ctx.MstDataRaws.Add(getdata);
}
ctx.SaveChanges();
ctx.Database.CommitTransaction();
}
}
catch (Exception ex)
{
}
return("kkkkkk");
}
public PostsController(test_dbContext context)
{
_context = context;
}
public PersonService(test_dbContext db)
{
this.db = db;
}
public PersonContactController(test_dbContext context)
{
_context = context;
}
public MstRsisController(test_dbContext context)
{
_context = context;
}
public GreetingsController(test_dbContext context)
{
_context = context;
}
public MstDataRawsController(test_dbContext context)
{
_context = context;
}
public BlogsController(test_dbContext context)
{
_context = context;
}
public CountriesController(test_dbContext context)
{
_context = context;
}
public PeopleController(test_dbContext context)
{
_context = context;
}
public ContactsController(test_dbContext context)
{
_context = context;
}
