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