public GrpcGreeter.Mahasiswa DetailMahasiswa(string nim)
{
GrpcGreeter.Mahasiswa Res = new GrpcGreeter.Mahasiswa();
using var connection = new MySqlConnection(strconn);
try
{
connection.Open();
string strquery = "SELECT * FROM mahasiswa WHERE NIM = '" + nim + "'";
var commannd = new MySqlCommand(strquery, connection);
var reader = commannd.ExecuteReader();
while (reader.Read())
{
GrpcGreeter.Mahasiswa mhs = new GrpcGreeter.Mahasiswa();
mhs.Nama = Convert.ToString(reader["Nama"]);
mhs.Nim = Convert.ToString(reader["NIM"]);
mhs.Asal = Convert.ToString(reader["Asal"]);
mhs.Datebirth = Convert.ToString(reader["Tanggal Lahir"]);
Res = mhs;
}
}
catch (Exception)
{
throw;
}
return(Res);
}
public string InsertMahasiswa(GrpcGreeter.Mahasiswa mhs)
{
string Res = "1~General Error";
using var connection = new MySqlConnection(strconn);
try
{
connection.Open();
string strquery = "INSERT INTO mahasiswa VALUES" +
"('" + mhs.Nama + "', '" + mhs.Nim + "', '" + mhs.Asal + "', '" + mhs.Datebirth + "')";
var commannd = new MySqlCommand(strquery, connection);
var reader = commannd.ExecuteReader();
Res = "0~Insert Berhasil";
}
catch (Exception e)
{
Res = "1~" + e.Message.ToString();
throw;
}
return(Res);
}
public string EditMahasiswa(GrpcGreeter.Mahasiswa mhs)
{
string Res = "1~General Error";
using var connection = new MySqlConnection(strconn);
try
{
connection.Open();
string strquery = "UPDATE mahasiswa SET " +
"Nama = '" + mhs.Nama + "'" +
", Asal = '" + mhs.Asal + "'" +
", `Tanggal Lahir` = '" + mhs.Datebirth + "' " +
"WHERE NIM = '" + mhs.Nim + "'";
var commannd = new MySqlCommand(strquery, connection);
var reader = commannd.ExecuteReader();
Res = "0~Edit Berhasil";
}
catch (Exception e)
{
Res = "1~" + e.Message.ToString();
throw;
}
return(Res);
}
