public void Create(EmployeeRequest request) { using (var session = sessionFactory.CreateForEmployee(true)) { try { var now = DateTime.Now; var dbObject = new EmployeeDbObject { FirstName = request.FirstName, LastName = request.LastName, MiddleName = request.MiddleName, BirthdayDate = request.BirthdayDate, PassDate = request.PassDate, IsTemporary = request.IsTemporary, AdditionalDocsPath = request.AdditionalDocsPath, PngPath = request.PngPath, DepartmentId = request.DepartmentId }; employeeRepository.Create( session, dbObject); session.Commit(); } catch (SqlException) { session.Rollback(); throw; } } }
private EmployeeView MapToView(EmployeeDbObject dbObject, IEnumerable <DictionaryItem> securityLevels) { return(new EmployeeView { Id = dbObject.Id, FirstName = dbObject.FirstName, LastName = dbObject.LastName, MiddleName = dbObject.MiddleName, BirthdayDate = dbObject.BirthdayDate, IsTemporary = dbObject.IsTemporary, Department = new DictionaryItem { Id = dbObject.DepartmentId, Name = dbObject.DepartmentName }, SecurityLevel = securityLevels, FullName = $"{dbObject.LastName} {dbObject.FirstName} {dbObject.MiddleName}", LastStatusChangedDate = dbObject.LastChangedStatusDate, StatusId = dbObject.StatusId, StatusName = dbObject.StatusName }); }
public void Create(ISession session, EmployeeDbObject employee) { var parametrs = new { FirstName = employee.FirstName, LastName = employee.LastName, MiddleName = employee.MiddleName, BirthdayDate = employee.BirthdayDate, PassDate = employee.PassDate, IsTemporary = employee.IsTemporary, AdditionalDocsPath = employee.AdditionalDocsPath, PngPath = employee.PngPath, DepartmentId = employee.DepartmentId }; const string query = @" INSERT INTO dbo.Employee (FirstName, LastName, MiddleName, BirthdayDate, LastStatusChangedDate, PassDate, IsTemporary, DepartmentId, PngPath, AdditionalDocsPath, StatusId) VALUES(@FirstName, @LastName, @MiddleName, @BirthdayDate, @LastChangedStatusDate, @PassDate, @IsTemporary, @DepartmentId, @PngPath, @AdditionalDocsPath, @StatusId) "; session.Execute(query, parametrs); }