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 void DeleteProject(int projectId) { using (var connection = new SqlConnection(base.ConnectionString)) { var adapter = new ProjectAdapter(); using (var command = new SqlCommand("sp_projectDelete", connection)) { command.Parameters.AddWithValue("@projectId", projectId); command.CommandType = CommandType.StoredProcedure; connection.Open(); var reader = command.ExecuteReader(); connection.Close(); } } }
public IEnumerable<IEmployeeProjectAssignment> GetEmployeesAssignedToProject(int projectId) { var assignments = new List<IEmployeeProjectAssignment>(); using (var connection = new SqlConnection(base.ConnectionString)) { var adapter = new ProjectAdapter(); using (var command = new SqlCommand("sp_ProjectRetrieveEmployees", connection)) { command.Parameters.AddWithValue("@projectId", projectId); command.CommandType = CommandType.StoredProcedure; connection.Open(); var reader = command.ExecuteReader(); var personAdapter = new PersonAdapter(); while (reader.Read()) { var assignment = new EmployeeProjectAssignment(); assignment.ProjectId = projectId; assignment.EmployeeId = Convert.ToInt32(reader["EmployeeId"]); assignment.Person = personAdapter.Resolve(new Person(), reader); assignments.Add(assignment); } connection.Close(); } } return assignments; }
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; }