public async Task <IActionResult> Edit(int id, [Bind("Id,NamaKos,JumlahKamar,DeskripsiTambahan,Alamat")] Kos kos)
{
if (id != kos.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(kos);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!KosExists(kos.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(kos));
}
public async Task <IActionResult> Create([Bind("Id,NamaKos,JumlahKamar,DeskripsiTambahan,Alamat")] Kos kos)
{
if (ModelState.IsValid)
{
_context.Add(kos);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(kos));
}
private void InsertKos(object sender, RoutedEventArgs e)
{
// generate GUID
Guid guid = Guid.NewGuid();
Console.WriteLine("GUID: " + guid);
//generate random number for ID
Random rnd = new Random();
//int id = rnd.Next(0, 100);
//get current time
DateTime currentTime = DateTime.Now;
//generate random string for delovni_nalog
int length = rnd.Next(10, 30);
const string chars = "ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz";
string delovni_nalog = new string(Enumerable.Repeat(chars, length).Select(s => s[rnd.Next(s.Length)]).ToArray());
//id delovni nalog - just a random number
int id_delovni_nalog = rnd.Next(0, 20);
//create object
Kos kos = new Kos(0, guid, delovni_nalog, currentTime, id_delovni_nalog);
//connect to database
using (IDbConnection connection = new SqlConnection(Utility.ConnVal("ec38")))
{
//insert into table kosi
connection.Query("INSERT INTO kosi(guid, delovni_nalog, cas_vnosa, id_dn)" +
"VALUES(@guid, @delovni_nalog, @currentTime, @id_dn);",
new { guid = kos.Guid, delovni_nalog = kos.DelovniNalog, currentTime = kos.CasVnosa, id_dn = kos.Id_delovni_nalog });
//select last added id
int tmp = connection.Query <int>("SELECT TOP 1 id_kos FROM kosi ORDER BY id_kos DESC").Single();
kos.Id = tmp;
Utility.kosData.Add(kos);
lvKosi.ItemsSource = Utility.kosData;
}
//read guid after inserting
ReadGuid();
}
