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(); }