public ActionResult DeleteConfirmed(int id)
{
CHITIETTRAM cHITIETTRAM = db.CHITIETTRAMS.Find(id);
db.CHITIETTRAMS.Remove(cHITIETTRAM);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "MATRAM,DA,MO,YEAR,NHIETDO,APSUAT,TOCDOGIO,TMAX,TMIN,LUONGMUA")] CHITIETTRAM cHITIETTRAM)
{
if (ModelState.IsValid)
{
db.Entry(cHITIETTRAM).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.MATRAM = new SelectList(db.TRAMS, "MATRAM", "MANUOC", cHITIETTRAM.MATRAM);
return(View(cHITIETTRAM));
}
// GET: CHITIETTRAMs/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
CHITIETTRAM cHITIETTRAM = db.CHITIETTRAMS.Find(id);
if (cHITIETTRAM == null)
{
return(HttpNotFound());
}
return(View(cHITIETTRAM));
}
// GET: CHITIETTRAMs/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
CHITIETTRAM cHITIETTRAM = db.CHITIETTRAMS.Find(id);
if (cHITIETTRAM == null)
{
return(HttpNotFound());
}
ViewBag.MATRAM = new SelectList(db.TRAMS, "MATRAM", "MANUOC", cHITIETTRAM.MATRAM);
return(View(cHITIETTRAM));
}
public static List <CHITIETTRAM> Update(string matram, string mo, string da)
{
List <CHITIETTRAM> re = new List <CHITIETTRAM>();
// Add file json.
using (BigQueryClient client = BigQueryClient.Create("phantantai", GoogleCredential.FromFile(@"C:\Users\ykdn1\OneDrive\Máy tính\oracle18.5\oracleteam3\oraclenhom3\oraclenhom3\App_Data\phantantai-c3450caeb9b5.json")))
{
string query = $@"
SELECT stn as MATRAM,da as DA,mo as MO,year as YEAR ,temp as NHIETDO,slp as APSUAT,wdsp as TOCDOGIO,max as TMAX,min as TMIN,prcp as LUONGMUA
FROM `bigquery-public-data.noaa_gsod.gsod2019`
where stn = '{matram}' and mo = '{mo}' and da = '{da}'" ;
BigQueryJob job = client.CreateQueryJob(
sql: query,
parameters: null,
options: new QueryOptions {
UseQueryCache = false
});
// Wait for the job to complete.
job.PollUntilCompleted();
CHITIETTRAM chitie = new CHITIETTRAM();
foreach (BigQueryRow row in client.GetQueryResults(job.Reference))
{
chitie.MATRAM = int.Parse($"{row["MATRAM"]}");
chitie.MO = byte.Parse($"{row["MO"]}");
chitie.DA = short.Parse($"{row["DA"]}");
chitie.YEAR = short.Parse($"{row["YEAR"]}");
var nd = float.Parse($"{row["NHIETDO"]}");
chitie.NHIETDO = (byte)nd;
var tmp = float.Parse($"{row["APSUAT"]}");
chitie.APSUAT = tmp < 900 ? (short)tmp : (short)0;
tmp = float.Parse($"{row["TOCDOGIO"]}");
chitie.TOCDOGIO = tmp < 900 ? (short)tmp : (short)0;
tmp = float.Parse($"{row["TMAX"]}");
chitie.TMAX = tmp < 900 ? (short)tmp : (short)0;
tmp = float.Parse($"{row["TMIN"]}");
chitie.TMIN = tmp < 900 ? (short)tmp : (short)0;
tmp = float.Parse($"{row["LUONGMUA"]}");
chitie.LUONGMUA = tmp < 900 ? (short)tmp : (short)0;
re.Add(chitie);
}
return(re);
}
}
