public async Task <IActionResult> Edit(Guid id, [Bind("Id,Aqi,Idx,City,Longitude,Latitude,Co,H,No2,O3,P,Pm10,Pm25,So2,T,W,time,CreateAt,UploadAt")] MstDataRaw mstDataRaw)
{
if (id != mstDataRaw.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(mstDataRaw);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!MstDataRawExists(mstDataRaw.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(mstDataRaw));
}
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 async Task <IActionResult> Create([Bind("Id,Aqi,Idx,City,Longitude,Latitude,Co,H,No2,O3,P,Pm10,Pm25,So2,T,W,time,CreateAt,UploadAt")] MstDataRaw mstDataRaw)
{
if (ModelState.IsValid)
{
mstDataRaw.Id = Guid.NewGuid();
_context.Add(mstDataRaw);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(mstDataRaw));
}
