HospitalConnectedLayer.HospitalDAL.AddAnalysis C# (CSharp) Méthode

        public void AddAnalysis(string policyNumber, Analysis analysis)
        {
            OpenConnection();
            var binFormatter = new ListBinaryFormatter<string>();
            _command.CommandText =
                "INSERT INTO Analyzes(PolicyNumber, TemplateTitle, Data, Date) VALUES(@PolicyNumber, @TemplateTitle, @Data, @Date)";

            _command.Parameters.Add(GetParam("@TemplateTitle", analysis.TemplateTitle));
            _command.Parameters.Add(GetParam("@Data", binFormatter.Serialize(analysis.Data)));
            _command.Parameters.Add(GetParam("@Date", analysis.Date));
            _command.Parameters.Add(GetParam("@PolicyNumber", policyNumber));

            try
            {
                _command.ExecuteNonQuery();
                //LOGGING
                Logger.Info("Analysis was added");
            }
            catch (Exception ex)
            {
                //LOGGING
                Logger.Error("Can't add analysis!",ex);
                throw new InvalidOperationException("Can't add analysis!");
            }
            finally
            {
                CloseConnection();
            }
        }

 public void AddandGetAnalyzes_TwoAnalyzes_ShouldPass(string policyNumber, Analysis analysis)
 {
     var dataStorage = new HospitalDAL(_dataProvider, _connectionString);
     dataStorage.AddAnalysis(policyNumber, analysis);
     int analyzesCount = dataStorage.GetAnalyzes(policyNumber).Count;
     Assert.True(analyzesCount >= 1);
 }