public DataContracts.IProject AddProject(DataContracts.IProject project)
{
using (var connection = new SqlConnection(base.ConnectionString))
{
var adapter = new ProjectAdapter();
using (var command = new SqlCommand("sp_projectCreate", connection))
{
command.Parameters.AddRange(adapter.ResolveToParameters(project).ToArray());
command.CommandType = CommandType.StoredProcedure;
connection.Open();
var reader = command.ExecuteReader();
while (reader.Read())
{
project = (Project)adapter.Resolve(new Project(), reader);
}
connection.Close();
}
}
return project;
}
public IEnumerable<DataContracts.IProject> GetProjectsForCompanyId(int companyId)
{
var projects = new List<IProject>();
using (var connection = new SqlConnection(base.ConnectionString))
{
var adapter = new ProjectAdapter();
using (var command = new SqlCommand("sp_projectsRetrieveByCompanyId", connection))
{
command.Parameters.AddWithValue("@companyId", companyId);
command.CommandType = CommandType.StoredProcedure;
connection.Open();
var reader = command.ExecuteReader();
while(reader.Read())
{
projects.Add(adapter.Resolve(new Project(), reader));
}
connection.Close();
}
}
return projects;
}
