public async Task <IActionResult> Edit(Guid id, [Bind("Id,Nama,Type,Alamat,Latitude,Longitude,Create,Update")] Rumah rumah)
{
if (id != rumah.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
rumah.Update = DateTime.Now;
_context.Update(rumah);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!RumahExists(rumah.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(rumah));
}
public async Task <IActionResult> Create([Bind("Id,Nama,Type,Alamat,Latitude,Longitude,Create,Update")] Rumah rumah)
{
if (ModelState.IsValid)
{
rumah.Id = Guid.NewGuid();
_context.Add(rumah);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(rumah));
}
public ActionResult Create(Rumah rumah)
{
try
{
AppDb.conn.Close();
AppDb.conn.Open();
string sql = "INSERT INTO rumah VALUES (" + rumah.id + ", '" + rumah.tipe + "', '" + rumah.alamat + "', " + rumah.latitude + ", " + rumah.longitude + ")";
MySqlCommand cmd = new MySqlCommand(sql, AppDb.conn);
MySqlDataReader rdr = cmd.ExecuteReader();
return(RedirectToAction("Create"));
}
catch
{
return(View());
}
}
