public override Task <PhoneReply> GetPhoneNumber(PhoneRequest request, ServerCallContext context)
{
PhoneReply output = new PhoneReply();
if (request.ID == 1)
{
}
//viet code lay data sql o
return(Task.FromResult(output));
}
public override async Task GetNewPhoneNumber(NewPhoneRequest request, IServerStreamWriter <PhoneReply> responseStream, ServerCallContext context)
{
try
{
if (connection.State != ConnectionState.Open)
{
connection.Open();
}
String insertQuery = @"Select * from phone limit 10";
MySqlCommand command = new MySqlCommand(insertQuery, connection);
MySqlDataReader reader = command.ExecuteReader();
String PhoneNumbers = "";
PhoneReply phoneReply = new PhoneReply();
while (reader.Read())
{
String phone = $"{reader.GetString("number")} ";
if (PhoneNumbers == "")
{
PhoneNumbers = phone;
}
else
{
PhoneNumbers += phone;
}
}
phoneReply.Number = PhoneNumbers;
await responseStream.WriteAsync(phoneReply);
}
catch (Exception error)
{
String eror = error.Message;
}
finally
{
if (connection.State == ConnectionState.Open)
{
connection.Close();
}
}
}
