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