private Employee MapToBE(EmployeeDbModel employee)
{
return(new Employee
{
Id = employee.Id,
Name = employee.Name,
Surname = employee.Surname,
Patronomyc = employee.Patronomyc,
Birthday = employee.Birthday,
Position = employee.Position,
});
}
/**
* Возвращает id добавленного сотрудника
*/
public static int Create(EmployeeClientModel employeeModel)
{
var employee = new EmployeeDbModel
{
Id = employeeModel.Id,
Name = employeeModel.Name,
Surname = employeeModel.Surname,
Phone = employeeModel.Phone,
CompanyId = employeeModel.CompanyId,
Number = employeeModel.Passport.Number,
Type = employeeModel.Passport.Type
};
int employeeId;
using (IDbConnection db = new SqlConnection(ConnectionString))
{
const string sqlQueryPassport = "INSERT INTO Passport (type, number) VALUES (@type, @number); SELECT CAST(SCOPE_IDENTITY() as int)";
var passportId = db.Query <int>(sqlQueryPassport, new { type = employee.Type, number = employee.Number }).FirstOrDefault();
const string sqlQueryEmployee = "INSERT INTO Employee (name, surname, phone, companyId, passport) VALUES(@name, @surname, @phone, @companyId, @passportId); SELECT CAST(SCOPE_IDENTITY() as int)";
employeeId = db.Query <int>(sqlQueryEmployee, employee).FirstOrDefault();
}
return(employeeId);
}
