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