public MahasiswaViewModel GetByNimVM(string nim) { MahasiswaViewModel mhs = new MahasiswaViewModel(); using (SqlConnection conn = new SqlConnection(GetConnStr())) { var strSql = @"select * from Mahasiswa where NIM=@Id"; var param = new { Id = nim }; mhs.OldNim = nim; mhs.mhs = conn.QuerySingleOrDefault <Mahasiswa>(strSql, param); return(mhs); } }
public void Update(MahasiswaViewModel mhs) { using (SqlConnection conn = new SqlConnection(GetConnStr())) { var strsql = @"update Mahasiswa set Nim=@nim, Nama_mhs=@nama, No_hp_mhs=@nohp, No_hp_ortu=@nohportu, Angkatan=@angkatan where Nim='" + mhs.OldNim + "'"; var param = new { nim = mhs.mhs.Nim, nama = mhs.mhs.Nama_mhs, nohp = mhs.mhs.No_hp_mhs, nohportu = mhs.mhs.No_hp_ortu, angkatan = mhs.mhs.Angkatan }; try { conn.Execute(strsql, param); } catch (SqlException x) { throw new Exception($"error : {x.Message}"); }; } }
public IActionResult Edit(MahasiswaViewModel data) { var nim_sub = data.mhs.Nim; var angakatan_sub = nim_sub.Substring(2, 2); var angkatan = "20" + angakatan_sub; data.mhs.Angkatan = angkatan; try { _mhs.Update(data); TempData["pesan"] = Helpers.Message.GetPesan("success", "Data mahasiswa berhasil diubah"); return(RedirectToAction("Index")); } catch (Exception x) { TempData["pesan"] = Helpers.Message.GetPesan("danger", x.Message); return(RedirectToAction("Index")); } }
public MahasiswaPage() { InitializeComponent(); mhsViewModel = new MahasiswaViewModel(); this.BindingContext = mhsViewModel; }