public void DeleteItem(int id)
{
using (SqlConnection connection = new SqlConnection(_connectionString))
{
connection.Open();
SqlCommand command = new SqlCommand(ManipulationScriptsEmployee.Sql_DELETE_Employee(id), connection);
command.ExecuteNonQuery();
}
}
public void Create(Employee employee)
{
using (SqlConnection connection = new SqlConnection(_connectionString))
{
connection.Open();
SqlCommand command = new SqlCommand(ManipulationScriptsEmployee.Sql_INSERT_INTO_Employees(employee.Company.CompanyName), connection);
command.Parameters.AddWithValue("@position", employee.Position);
command.Parameters.AddWithValue("@empDate", employee.EmploymentDate);
command.Parameters.AddWithValue("@patronymic", employee.Patronymic);
command.Parameters.AddWithValue("@surname", employee.Surname);
command.Parameters.AddWithValue("@name", employee.Name);
command.ExecuteNonQuery();
}
}
public Employee GetItem(int?id)
{
var employee = new Employee();
using (SqlConnection connection = new SqlConnection(_connectionString))
{
connection.Open();
SqlCommand command = new SqlCommand(ManipulationScriptsEmployee.Sql_SELECT_SingleEmployee(id), connection);
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
employee.Id = reader.GetInt32(0);
employee.Name = reader.GetString(1);
employee.Surname = reader.GetString(2);
employee.Patronymic = reader.GetString(3);
employee.EmploymentDate = reader.GetDateTime(4);
employee.Position = reader.GetString(5);
var companyId = reader.GetInt32(7);
if (companyId != default)
{
var companyName = reader.GetString(6);
employee.Company = new Company()
{
CompanyName = companyName, Id = companyId
};
}
}
}
reader.Close();
}
return(employee);
}
