public void AddProject_Success() { //Arrange var connection = CreateConnection(); //Act Project_Reply project_Reply = connection.AddProject(new Name_Request { Name = "An_Added_Project" }); //Assert Assert.IsNotNull(project_Reply); }
public override Task <Project_Reply> AddProject(Name_Request request, ServerCallContext context) { Project_Reply project_Reply = new Project_Reply(); MySqlConnection connection = CreateDBConnection(); var cmd = connection.CreateCommand(); cmd.CommandText = $"INSERT INTO trackerdb.project (`name`, `active`) VALUES ('{request.Name}','Y');"; cmd.ExecuteNonQuery(); cmd.CommandText = $"SELECT `projectId`, `name`, `active` FROM trackerdb.project WHERE `name` = '{request.Name}' LIMIT 1;"; var reader = cmd.ExecuteReader(); reader.Read(); project_Reply.ProjectId = Convert.ToInt32(reader["projectId"]); project_Reply.Name = Convert.ToString(reader["name"]); project_Reply.Active = Convert.ToString(reader["active"]); cmd.Dispose(); connection.Close(); connection.Dispose(); return(Task.FromResult(project_Reply)); }