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