public string UpdateMahasiswaByNIM(Mahasiswa mhs)
{
string msg = "Gagal";
sqlConnection = new SqlConnection(connectionString);
string query = string.Format("Update dbo.Mahasiswa set Nama = '{0}', Prodi = '{1}', Angkatan = '{2}' where NIM = '{3}'", mhs.nama, mhs.prodi, mhs.angkatan, mhs.nim);
SqlCommand cmd = new SqlCommand(query, sqlConnection);
try
{
sqlConnection.Open();
cmd.ExecuteNonQuery();
sqlConnection.Close();
msg = "Sukses";
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
Console.WriteLine(query);
}
return(msg);
}
public string CreateMahasiswa(Mahasiswa mhs)
{
string msg = "Gagal";
sqlConnection = new SqlConnection(connectionString);
string query = string.Format("Insert into dbo.Mahasiswa values ('{0}', '{1}', '{2}', '{3}')", mhs.nim, mhs.nama, mhs.prodi, mhs.angkatan);
SqlCommand cmd = new SqlCommand(query, sqlConnection);
try
{
sqlConnection.Open();
Console.WriteLine(query);
cmd.ExecuteNonQuery();
sqlConnection.Close();
msg = "Sukses";
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
Console.WriteLine(query);
}
return(msg);
}