public int SimpanMahasiswa(MahasiswaModel model)
{
int hasil = -1;
try
{
string Query = @"Insert into TbMahasiswa ([NPM]
,[Nama]
,[JK]
,[IdJurusan]
,[Alamat]
,[TglLahir]
,[Email])
Values('" + model.NPM + "'," +
"'" + model.Nama + "'," +
"'" + model.JK + "'," +
"'" + model.IdJurusan + "'," +
"'" + model.Alamat + "'," +
"'" + model.TglLahir + "'," +
"'" + model.Email + "')";
hasil = SQLHelpers.ExecQuery(Query);
return(hasil);
}
catch (Exception ex)
{
throw ex;
}
}
public ActionResult Edit(MahasiswaModel model)
{
try
{
Mahasiswa = new MahasiswaService();
Mahasiswa.UpdateMahasiswa(model);
return(Json(new { success = true, message = "Data Update Successfully" }, JsonRequestBehavior.AllowGet));
}
catch
{
return(Json(new { success = false, message = "Save data failed" }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult Create(MahasiswaModel model)
{
try
{
Mahasiswa = new MahasiswaService();
bool IsdataExist = Mahasiswa.IsDataExist(model.NPM);
if (IsdataExist)
{
return(Json(new { success = false, message = "Data already exist" }, JsonRequestBehavior.AllowGet));
}
Mahasiswa.SimpanMahasiswa(model);
return(Json(new { success = true, message = "Data Saved Successfully" }, JsonRequestBehavior.AllowGet));
}
catch
{
return(Json(new { success = false, message = "Data Saved failed" }, JsonRequestBehavior.AllowGet));
}
}
public int UpdateMahasiswa(MahasiswaModel model)
{
int hasil = -1;
try
{
string Query = @"Update TbMahasiswa
SET Nama = '" + model.Nama + "', " +
"JK = '" + model.JK + "', " +
"IdJurusan = '" + model.IdJurusan + "', " +
"Alamat = '" + model.Alamat + "', " +
"TglLahir = '" + model.TglLahir + "', " +
"Email = '" + model.Email + "' " +
"Where NPM = '" + model.NPM + "'";
hasil = SQLHelpers.ExecQuery(Query);
return(hasil);
}
catch (Exception ex)
{
throw ex;
}
}
public IActionResult AddToDb(MahasiswaModel model)
{
_dataContext.Mahasiswas.Add(model);
_dataContext.SaveChanges();
return(Ok("Data Has been saved"));
}
