public async Task <IActionResult> Edit(int id, [Bind("Kd_wilayah,Nama_Wilayah")] Wilayah wilayah) { if (id != wilayah.Kd_wilayah) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(wilayah); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!WilayahExists(wilayah.Kd_wilayah)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } return(View(wilayah)); }
public string GetData() { DataSet ds = Wilayah.GetWilayah(); string Json = JsonConvert.SerializeObject(ds, Formatting.Indented); return(Json); }
public async Task <ServiceResponse <GetWilayahDto> > AddWilayah(string nama_wilayah) { var response = new ServiceResponse <GetWilayahDto>(); if (nama_wilayah == null) { response.Status = false; response.Message = "Masukkan Nama Wilayah"; return(response); } var data = new Wilayah(); data.Nama_wilayah = nama_wilayah; data.Status_wilayah = "1"; data.Sistem_created_time = DateTime.Now; data.Sistem_updated_time = Convert.ToDateTime("1900-01-01"); try { await _context.Tb_wilayah.AddAsync(data); await _context.SaveChangesAsync(); response.Data = _mapper.Map <GetWilayahDto>(data); response.Message = "Tambah Wilayah Berhasil"; } catch (Exception ex) { response.Status = false; response.Message = ex.Message; } return(response); }
public async Task <IActionResult> Create([Bind("Kd_wilayah,Nama_Wilayah")] Wilayah wilayah) { if (ModelState.IsValid) { _context.Add(wilayah); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(wilayah)); }
public Wilayah GetKabupaten(string name) { Wilayah obj = null; try { var sql = @"SELECT * FROM m_kabupaten2 WHERE LOWER(nama_kabupaten) = @name"; name = name.ToLower(); obj = _context.db.QuerySingleOrDefault <Wilayah>(sql, new { name }); } catch (Exception ex) { _log.Error("Error:", ex); } return(obj); }
public int Delete(Wilayah obj) { throw new NotImplementedException(); }