//method ubah data provinsi
public ActionResult UbahDataProv(Provinsi prov)
{
//db.Biodata.Add(bio);
db.Entry(prov).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();//setiap ada perubahan di db harus ada saveChanges
return(Json(new { success = 1 }, JsonRequestBehavior.AllowGet));
}
public async Task <IActionResult> Edit(int id, [Bind("Id,Nama")] Provinsi provinsi)
{
if (id != provinsi.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(provinsi);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!ProvinsiExists(provinsi.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(provinsi));
}
public async Task <ProvinsiResponse> DeletePost(ProvinsiRequest request)
{
ProvinsiResponse response = new ProvinsiResponse();
if (db != null)
{
try
{
Provinsi model = await db.Provinsi.Where(x => x.RowStatus == true && x.Id == request.ID).FirstOrDefaultAsync();
if (model != null)
{
model.Modified = DateTime.Now;
model.ModifiedBy = request.UserName;
model.RowStatus = false;
await db.SaveChangesAsync();
response.IsSuccess = true;
response.Message = "Data has been Saved";
}
else
{
response.IsSuccess = false;
response.Message = "Data Not Found";
}
}
catch (Exception ex)
{
response.Message = ex.ToString();
response.IsSuccess = false;
}
}
return(response);
}
public async Task <SeedProvinsiResponse> Handle(SeedProvinsiRequest request, CancellationToken cancellationToken)
{
var result = new SeedProvinsiResponse();
var dataOld = await _entityRepository.GetAllProvinsi();
List <Provinsi> provinsis = await _context.Provinsis.ToListAsync(cancellationToken);
foreach (var data in dataOld)
{
Provinsi provinsi = new Provinsi();
provinsi = provinsis
.SingleOrDefault(x => x.id_provinsi == data.id_provinsi);
if (provinsi == null)
{
provinsi = new Provinsi
{
id_provinsi = data.id_provinsi,
Name = data.nama_provinsi
};
provinsis.Add(provinsi);
_context.Provinsis.Add(provinsi);
}
}
await _context.SaveChangesAsync(cancellationToken);
result.IsSuccessful = true;
return(result);
}
public EditPraktik()
{
InitializeComponent();
provincies = Alamat.GetProvinsiList();
comboBox1.Items.AddRange(Provinsi.getAllName(provincies));
loadData();
}
private void combo_change_select(object sender, EventArgs e)
{
comboBox2.Text = "";
string id = Provinsi.getIdFromName(provincies, comboBox1.Text);
comboBox2.Items.Clear();
comboBox2.Items.AddRange(Alamat.GetKotaList(id));
}
//method hapus data provinsi
public ActionResult HapusDataProv(string id)
{
Provinsi prov = db.Provinsi.Find(id);
db.Provinsi.Remove(prov);
db.SaveChanges();
return(Json(new { success = 1 }, JsonRequestBehavior.AllowGet));
}
public async Task <IActionResult> Create([Bind("Id,Nama")] Provinsi provinsi)
{
if (ModelState.IsValid)
{
_context.Add(provinsi);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(provinsi));
}
public async Task <Provinsi> GetByName(string req)
{
Provinsi response = new Provinsi();
try
{
response = await db.Provinsi.Where(x => x.RowStatus == true && x.Name.ToLower().Equals(req.ToLower())).FirstOrDefaultAsync();
}
catch (Exception ex)
{
throw ex;
}
return(response);
}
public async Task <Provinsi> GetPostByID(long ID)
{
Provinsi response = new Provinsi();
if (db != null)
{
try
{
response = await db.Provinsi.Where(x => x.RowStatus == true && x.Id == ID).FirstOrDefaultAsync();
}
catch (Exception ex)
{
throw ex;
}
}
return(response);
}
public async Task <ProvinsiResponse> AddPost(ProvinsiRequest req)
{
ProvinsiResponse response = new ProvinsiResponse();
long result = 0;
try
{
Provinsi getModel = await dep.GetByName(req.Name);
if (getModel == null)
{
Provinsi provinsi = new Provinsi();
provinsi.Name = req.Name;
provinsi.Description = req.Description;
provinsi.Created = DateTime.Now;
provinsi.CreatedBy = req.UserName;
provinsi.RowStatus = true;
result = await dep.AddPost(provinsi);
if (result > 0)
{
response.Message = "Data Already Saved";
response.IsSuccess = true;
}
else
{
response.Message = "Save data failed";
response.IsSuccess = false;
}
}
else
{
response.Message = "Duplicate with Existing Data";
response.IsSuccess = false;
}
}
catch (Exception ex)
{
log.Error(ex);
response.Message = ex.ToString();
response.IsSuccess = false;
}
return(response);
}
public async Task <long> UpdatePost(Provinsi request)
{
long result = 0;
if (db != null)
{
try
{
db.Provinsi.Update(request);
result = await db.SaveChangesAsync();
}
catch (Exception)
{
result = 0;
}
}
return(result);
}
//method simpandataprovinsi
public ActionResult SimpanDataProv(Provinsi prov)
{
var cek = db.Provinsi.Where(b => b.kode_provinsi.Equals(prov.kode_provinsi));
int hasil = cek.Count();//cek database, jika ada (1) maka simpan gagal
if (hasil >= 1)
{
return(Json(new { success = 2, count = hasil }, JsonRequestBehavior.AllowGet));
}
else
{
db.Provinsi.Add(prov);
db.SaveChanges();//setiap ada perubahan di db harus ada saveChanges
return(Json(new { success = 1, count = hasil }, JsonRequestBehavior.AllowGet));
}
//db.Provinsi.Add(prov);
//db.SaveChanges();//setiap ada perubahan di db harus ada saveChanges
//return Json(new { success = 1 }, JsonRequestBehavior.AllowGet);
}
private void SetWilayahCustomer(Customer obj)
{
Provinsi provinsi = null;
Kabupaten kabupaten = null;
Kecamatan kecamatan = null;
if (!string.IsNullOrEmpty(obj.provinsi_id))
{
provinsi = _listOfWilayah.Where(f => f.provinsi_id == obj.provinsi_id)
.Select(f => new Provinsi {
provinsi_id = f.provinsi_id, nama_provinsi = f.nama_provinsi
})
.FirstOrDefault();
}
if (!string.IsNullOrEmpty(obj.kabupaten_id))
{
kabupaten = _listOfWilayah.Where(f => f.kabupaten_id == obj.kabupaten_id)
.Select(f => new Kabupaten {
kabupaten_id = f.kabupaten_id, nama_kabupaten = f.nama_kabupaten
})
.FirstOrDefault();
}
if (!string.IsNullOrEmpty(obj.kecamatan_id))
{
kecamatan = _listOfWilayah.Where(f => f.kecamatan_id == obj.kecamatan_id)
.Select(f => new Kecamatan {
kecamatan_id = f.kecamatan_id, nama_kecamatan = f.nama_kecamatan
})
.FirstOrDefault();
}
obj.Provinsi = provinsi;
obj.Kabupaten = kabupaten;
obj.Kecamatan = kecamatan;
}
//method edit data provinsi
public ActionResult EditDataProv(string id)
{
Provinsi prov = db.Provinsi.Find(id);
return(Json(new { data = prov }, JsonRequestBehavior.AllowGet));
}
public void loadProvinsi()
{
//Ambil data api kemudian taruh di combobox
comboBox1.Items.AddRange(Provinsi.getAllName(Alamat.GetProvinsiList()));
}
