public void GetCurrentVersion_Success() { //Arrange var connection = CreateConnection(); //Act Value_Reply value_Reply = connection.GetCurrentVersion(new Empty()); //Assert Assert.IsNotNull(value_Reply.Value); }
public void SetSettingValueByName_Success() { //Arrange var connection = CreateConnection(); //Act Value_Reply value_Reply = connection.SetSettingValueByName(new NameValue_Request { Name = "version", Value = "1.5" /*SETTING NAME*/ }); //Assert Assert.IsNotNull(value_Reply.Value); }
public override Task <Value_Reply> GetCurrentVersion(Empty request, ServerCallContext context) { Value_Reply value_Reply = new Value_Reply(); MySqlConnection connection = CreateDBConnection(); var cmd = connection.CreateCommand(); cmd.CommandText = $"SELECT `value` FROM trackerdb.setting WHERE `name` = 'version';"; var reader = cmd.ExecuteReader(); reader.Read(); value_Reply.Value = Convert.ToString(reader["value"]); cmd.Dispose(); connection.Close(); connection.Dispose(); return(Task.FromResult(value_Reply)); }
public override Task <Value_Reply> SetSettingValueByName(NameValue_Request request, ServerCallContext context) { Value_Reply value_Reply = new Value_Reply(); MySqlConnection connection = CreateDBConnection(); var cmd = connection.CreateCommand(); cmd.CommandText = $"UPDATE trackerdb.setting SET `value` = '{request.Value}' WHERE `name` = '{request.Name}';"; cmd.ExecuteNonQuery(); cmd.CommandText = $"SELECT `value` FROM trackerdb.setting WHERE `name` = '{request.Name}';"; var reader = cmd.ExecuteReader(); reader.Read(); value_Reply.Value = Convert.ToString(reader["value"]); cmd.Dispose(); connection.Close(); connection.Dispose(); return(Task.FromResult(value_Reply)); }