// GET: Mahasiswa16
public ActionResult Index()
{
//instantiasi data context ke linq yg baru dibuat
var db = new LINQ016DataContext();
//select tabel
var listMhs = from Mahasiswa in db.Mahasiswas select Mahasiswa;
//membuat list
var mhs = new List <P6_1_0320190016.Models.Mahasiswa16>();
if (listMhs.Any())
{
foreach (var eachMhs in listMhs)
{
mhs.Add(new P6_1_0320190016.Models.Mahasiswa16()
{
nim = eachMhs.nim,
nama = eachMhs.nama,
alamat = eachMhs.alamat,
email = eachMhs.email,
tgl_lahir = eachMhs.tgl_lahir
});
}
}
return(View(mhs));
}
public ActionResult Create(Mahasiswa mahasiswa)
{
try
{
var db = new LINQ016DataContext();
db.Mahasiswas.InsertOnSubmit(mahasiswa);
db.SubmitChanges();
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
public ActionResult Delete(string id, Mahasiswa dtlMhs)
{
try
{
var db = new LINQ016DataContext();
var mhs = db.Mahasiswas.FirstOrDefault(mhsId => mhsId.nim == id);
db.Mahasiswas.DeleteOnSubmit(mhs);
db.SubmitChanges();
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
public ActionResult Details(string id)
{
var db = new LINQ016DataContext();
var dtlMhs = db.Mahasiswas.FirstOrDefault(mhsId => mhsId.nim == id);
var mhs = new P6_1_0320190016.Models.Mahasiswa16();
if (dtlMhs != null)
{
mhs.nim = dtlMhs.nim;
mhs.nama = dtlMhs.nama;
mhs.alamat = dtlMhs.alamat;
mhs.email = dtlMhs.email;
mhs.tgl_lahir = dtlMhs.tgl_lahir;
}
return(View(mhs));
}
public ActionResult Edit(string id, Mahasiswa dtlMhs)
{
try
{
var db = new LINQ016DataContext();
var mhs = db.Mahasiswas.FirstOrDefault(mhsId => mhsId.nim == id);
if (mhs != null)
{
mhs.nim = dtlMhs.nim;
mhs.nama = dtlMhs.nama;
mhs.alamat = dtlMhs.alamat;
mhs.email = dtlMhs.email;
mhs.tgl_lahir = dtlMhs.tgl_lahir;
db.SubmitChanges();
}
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
