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); }