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