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 List <Template> GetTemplates()
{
OpenConnection();
_command.CommandText = "SELECT * FROM Templates";
var templates = new List <Template>();
var binFormatter = new ListBinaryFormatter <string>();
try
{
using (DbDataReader dataReader = _command.ExecuteReader())
{
while (dataReader.Read())
{
var title = (string)dataReader["Title"];
IList <string> data = binFormatter.Deserialize((byte[])dataReader["Data"]);
templates.Add(new Template(data, title));
}
}
//LOGGING
Logger.Info("Templates were obtained");
}
catch (Exception ex)
{
//LOGGING
Logger.Error("Can't get templates!", ex);
throw new InvalidOperationException("Can't get templates!");
}
finally
{
CloseConnection();
}
return(templates);
}
public void AddAnalysis(string policyNumber, Analysis analysis)
{
OpenConnection();
using (DbCommand command = _dbProviderFactory.CreateCommand())
{
command.Connection = _sqlConnection;
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();
}
catch (Exception)
{
throw new InvalidOperationException("Can't add analysis!");
}
finally
{
_sqlConnection.Close();
}
}
}
public Template GetTemplate(string title)
{
OpenConnection();
_command.CommandText = "SELECT * FROM Templates WHERE Title = @Title";
_command.Parameters.Add(GetParam("@Title", title));
Template template = null;
var binFormatter = new ListBinaryFormatter <string>();
try
{
using (DbDataReader dataReader = _command.ExecuteReader())
{
while (dataReader.Read())
{
template = new Template(binFormatter.Deserialize((byte[])dataReader["Data"]), title);
}
}
//LOGGING
Logger.Info("Template was obtained");
}
catch (Exception ex)
{
//LOGGING
Logger.Error("Can't get template!", ex);
throw new InvalidOperationException("Can't get template!");
}
finally
{
CloseConnection();
}
return(template);
}
public void AddAnalysis(string policyNumber, Analysis analysis)
{
OpenConnection();
using (DbCommand command = _dbProviderFactory.CreateCommand())
{
command.Connection = _sqlConnection;
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();
}
catch (Exception)
{
throw new InvalidOperationException("Can't add analysis!");
}
finally
{
_sqlConnection.Close();
}
}
}
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 AddTemplate(Template template)
{
OpenConnection();
var binFormatter = new ListBinaryFormatter <string>();
_command.CommandText = "INSERT INTO Templates(Title, Data) VALUES(@Title, @Data)";
_command.Parameters.Add(GetParam("@Title", template.Title));
_command.Parameters.Add(GetParam("@Data", binFormatter.Serialize(template.Data)));
try
{
_command.ExecuteNonQuery();
//LOGGING
Logger.Info("Template was added");
}
catch (SqlException ex)
{
//LOGGING
Logger.Error("This template already exists!", ex);
throw new InvalidOperationException("This template already exists!");
}
catch (Exception ex)
{
//LOGGING
Logger.Error("Can't add template!", ex);
throw new InvalidOperationException("Can't add template!");
}
finally
{
CloseConnection();
}
}
public List <Template> GetTemplates()
{
OpenConnection();
using (DbCommand command = _dbProviderFactory.CreateCommand())
{
command.Connection = _sqlConnection;
command.CommandText = "SELECT * FROM Templates";
var templates = new List <Template>();
var binFormatter = new ListBinaryFormatter <string>();
try
{
using (DbDataReader dataReader = command.ExecuteReader())
{
while (dataReader.Read())
{
var title = (string)dataReader["Title"];
IList <string> data = binFormatter.Deserialize((byte[])dataReader["Data"]);
templates.Add(new Template(data, title));
}
}
}
catch (Exception)
{
throw new InvalidOperationException("Can't get templates!");
}
finally
{
_sqlConnection.Close();
}
return(templates);
}
}
public void AddTemplate(Template template)
{
OpenConnection();
using (DbCommand command = _dbProviderFactory.CreateCommand())
{
command.Connection = _sqlConnection;
var binFormatter = new ListBinaryFormatter <string>();
command.CommandText = "INSERT INTO Templates(Title, Data) VALUES(@Title, @Data)";
command.Parameters.Add(GetParam("@Title", template.Title));
command.Parameters.Add(GetParam("@Data", binFormatter.Serialize(template.Data)));
try
{
command.ExecuteNonQuery();
}
catch (SqlException)
{
throw new InvalidOperationException("This template already exists!");
}
catch (Exception)
{
throw new InvalidOperationException("Can't add template!");
}
finally
{
_sqlConnection.Close();
}
}
}
public List <Analysis> GetAnalyzes(string policyNumber)
{
OpenConnection();
using (DbCommand command = _dbProviderFactory.CreateCommand())
{
command.Connection = _sqlConnection;
command.CommandText =
"SELECT TemplateTitle, Data, Date FROM Analyzes WHERE PolicyNumber = @PolicyNumber";
command.Parameters.Add(GetParam("@PolicyNumber", policyNumber));
var analyzes = new List <Analysis>();
var binFormatter = new ListBinaryFormatter <string>();
try
{
using (DbDataReader dataReader = command.ExecuteReader())
{
while (dataReader.Read())
{
var data = (byte[])dataReader["Data"];
var title = (string)dataReader["TemplateTitle"];
var date = (DateTime)dataReader["Date"];
analyzes.Add(new Analysis(binFormatter.Deserialize(data), title, date));
}
}
}
catch (Exception)
{
throw new InvalidOperationException("Can't get analyzes!");
}
finally
{
_sqlConnection.Close();
}
return(analyzes);
}
}
public List <Analysis> GetAnalyzes(string policyNumber)
{
OpenConnection();
_command.CommandText = "SELECT TemplateTitle, Data, Date FROM Analyzes WHERE PolicyNumber = @PolicyNumber";
_command.Parameters.Add(GetParam("@PolicyNumber", policyNumber));
var analyzes = new List <Analysis>();
var binFormatter = new ListBinaryFormatter <string>();
try
{
using (DbDataReader dataReader = _command.ExecuteReader())
{
while (dataReader.Read())
{
var data = (byte[])dataReader["Data"];
var title = (string)dataReader["TemplateTitle"];
var date = (DateTime)dataReader["Date"];
analyzes.Add(new Analysis(binFormatter.Deserialize(data), title, date));
}
}
//LOGGING
Logger.Info("Analyzes were obtained");
}
catch (Exception ex)
{
//LOGGING
Logger.Error("Can't get analyzes!", ex);
throw new InvalidOperationException("Can't get analyzes!");
}
finally
{
CloseConnection();
}
return(analyzes);
}
public Template GetTemplate(string title)
{
OpenConnection();
using (DbCommand command = _dbProviderFactory.CreateCommand())
{
command.Connection = _sqlConnection;
command.CommandText = "SELECT * FROM Templates WHERE Title = @Title";
command.Parameters.Add(GetParam("@Title", title));
Template template = null;
var binFormatter = new ListBinaryFormatter <string>();
try
{
using (DbDataReader dataReader = command.ExecuteReader())
{
while (dataReader.Read())
{
template = new Template(binFormatter.Deserialize((byte[])dataReader["Data"]), title);
}
}
}
catch (Exception)
{
throw new InvalidOperationException("Can't get template!");
}
finally
{
_sqlConnection.Close();
}
return(template);
}
}
public void AddTemplate(Template template)
{
OpenConnection();
var binFormatter = new ListBinaryFormatter<string>();
_command.CommandText = "INSERT INTO Templates(Title, Data) VALUES(@Title, @Data)";
_command.Parameters.Add(GetParam("@Title", template.Title));
_command.Parameters.Add(GetParam("@Data", binFormatter.Serialize(template.Data)));
try
{
_command.ExecuteNonQuery();
//LOGGING
Logger.Info("Template was added");
}
catch (SqlException ex)
{
//LOGGING
Logger.Error("This template already exists!",ex);
throw new InvalidOperationException("This template already exists!");
}
catch (Exception ex)
{
//LOGGING
Logger.Error("Can't add template!",ex);
throw new InvalidOperationException("Can't add template!");
}
finally
{
CloseConnection();
}
}
public List<Template> GetTemplates()
{
OpenConnection();
using (DbCommand command = _dbProviderFactory.CreateCommand())
{
command.Connection = _sqlConnection;
command.CommandText = "SELECT * FROM Templates";
var templates = new List<Template>();
var binFormatter = new ListBinaryFormatter<string>();
try
{
using (DbDataReader dataReader = command.ExecuteReader())
{
while (dataReader.Read())
{
var title = (string) dataReader["Title"];
IList<string> data = binFormatter.Deserialize((byte[]) dataReader["Data"]);
templates.Add(new Template(data, title));
}
}
}
catch (Exception)
{
throw new InvalidOperationException("Can't get templates!");
}
finally
{
_sqlConnection.Close();
}
return templates;
}
}
public Template GetTemplate(string title)
{
OpenConnection();
using (DbCommand command = _dbProviderFactory.CreateCommand())
{
command.Connection = _sqlConnection;
command.CommandText = "SELECT * FROM Templates WHERE Title = @Title";
command.Parameters.Add(GetParam("@Title", title));
Template template = null;
var binFormatter = new ListBinaryFormatter<string>();
try
{
using (DbDataReader dataReader = command.ExecuteReader())
{
while (dataReader.Read())
{
template = new Template(binFormatter.Deserialize((byte[]) dataReader["Data"]), title);
}
}
}
catch (Exception)
{
throw new InvalidOperationException("Can't get template!");
}
finally
{
_sqlConnection.Close();
}
return template;
}
}
public List<Analysis> GetAnalyzes(string policyNumber)
{
OpenConnection();
using (DbCommand command = _dbProviderFactory.CreateCommand())
{
command.Connection = _sqlConnection;
command.CommandText =
"SELECT TemplateTitle, Data, Date FROM Analyzes WHERE PolicyNumber = @PolicyNumber";
command.Parameters.Add(GetParam("@PolicyNumber", policyNumber));
var analyzes = new List<Analysis>();
var binFormatter = new ListBinaryFormatter<string>();
try
{
using (DbDataReader dataReader = command.ExecuteReader())
{
while (dataReader.Read())
{
var data = (byte[]) dataReader["Data"];
var title = (string) dataReader["TemplateTitle"];
var date = (DateTime) dataReader["Date"];
analyzes.Add(new Analysis(binFormatter.Deserialize(data), title, date));
}
}
}
catch (Exception)
{
throw new InvalidOperationException("Can't get analyzes!");
}
finally
{
_sqlConnection.Close();
}
return analyzes;
}
}
public void AddTemplate(Template template)
{
OpenConnection();
using (DbCommand command = _dbProviderFactory.CreateCommand())
{
command.Connection = _sqlConnection;
var binFormatter = new ListBinaryFormatter<string>();
command.CommandText = "INSERT INTO Templates(Title, Data) VALUES(@Title, @Data)";
command.Parameters.Add(GetParam("@Title", template.Title));
command.Parameters.Add(GetParam("@Data", binFormatter.Serialize(template.Data)));
try
{
command.ExecuteNonQuery();
}
catch (SqlException)
{
throw new InvalidOperationException("This template already exists!");
}
catch (Exception)
{
throw new InvalidOperationException("Can't add template!");
}
finally
{
_sqlConnection.Close();
}
}
}
public List<Template> GetTemplates()
{
OpenConnection();
_command.CommandText = "SELECT * FROM Templates";
var templates = new List<Template>();
var binFormatter = new ListBinaryFormatter<string>();
try
{
using (DbDataReader dataReader = _command.ExecuteReader())
{
while (dataReader.Read())
{
var title = (string) dataReader["Title"];
IList<string> data = binFormatter.Deserialize((byte[]) dataReader["Data"]);
templates.Add(new Template(data, title));
}
}
//LOGGING
Logger.Info("Templates were obtained");
}
catch (Exception ex)
{
//LOGGING
Logger.Error("Can't get templates!",ex);
throw new InvalidOperationException("Can't get templates!");
}
finally
{
CloseConnection();
}
return templates;
}
public Template GetTemplate(string title)
{
OpenConnection();
_command.CommandText = "SELECT * FROM Templates WHERE Title = @Title";
_command.Parameters.Add(GetParam("@Title", title));
Template template = null;
var binFormatter = new ListBinaryFormatter<string>();
try
{
using (DbDataReader dataReader = _command.ExecuteReader())
{
while (dataReader.Read())
{
template = new Template(binFormatter.Deserialize((byte[]) dataReader["Data"]), title);
}
}
//LOGGING
Logger.Info("Template was obtained");
}
catch (Exception ex)
{
//LOGGING
Logger.Error("Can't get template!",ex);
throw new InvalidOperationException("Can't get template!");
}
finally
{
CloseConnection();
}
return template;
}
public List<Analysis> GetAnalyzes(string policyNumber)
{
OpenConnection();
_command.CommandText = "SELECT TemplateTitle, Data, Date FROM Analyzes WHERE PolicyNumber = @PolicyNumber";
_command.Parameters.Add(GetParam("@PolicyNumber", policyNumber));
var analyzes = new List<Analysis>();
var binFormatter = new ListBinaryFormatter<string>();
try
{
using (DbDataReader dataReader = _command.ExecuteReader())
{
while (dataReader.Read())
{
var data = (byte[]) dataReader["Data"];
var title = (string) dataReader["TemplateTitle"];
var date = (DateTime) dataReader["Date"];
analyzes.Add(new Analysis(binFormatter.Deserialize(data), title, date));
}
}
//LOGGING
Logger.Info("Analyzes were obtained");
}
catch (Exception ex)
{
//LOGGING
Logger.Error("Can't get analyzes!", ex);
throw new InvalidOperationException("Can't get analyzes!");
}
finally
{
CloseConnection();
}
return analyzes;
}
