public void Put(int id, Event eventToUpdate) { if (!_eventService.Update(id, eventToUpdate)) { throw new HttpResponseException(HttpStatusCode.NotFound); } }
public HttpResponseMessage Put(Event eventToSave) { eventToSave.Id = _eventService.Save(eventToSave); return string.IsNullOrEmpty(User.Identity.Name) ? Request.CreateErrorResponse(HttpStatusCode.Unauthorized, "Please log in.") : Request.CreateResponse(HttpStatusCode.OK, eventToSave); }
public void AddEvent_EmptyDB_ShouldReturnOneEvent() { var eventToSave = new Event { Name = "sadlaskd", StartDate = DateTime.Now, EndDate = DateTime.Now.AddHours(4), Address = "City", GroupId = 1 }; _eventRepository.Save(eventToSave); IList<Event> events = _eventRepository.GetAll(); Assert.Greater(events.Count, 0); }
public Event AddEvent() { var @event = new Event { Name = "sadlaskd", StartDate = DateTime.Now, EndDate = DateTime.Now.AddHours(1), Address = "City", GroupId = 1 }; long eventId = _eventRepository.Save(@event); @event.Id = eventId; return @event; }
public long Save(Event eventToSave) { using (var connection = OpenConnection()) { const string sql = "INSERT INTO [Events] ([Name], StartDate, EndDate, Address, GroupId) VALUES (@Name, @StartDate, @EndDate, @Address, @GroupId);" + "SELECT cast(scope_identity() as int)"; return connection.Execute(sql, new { eventToSave.Name, eventToSave.StartDate, eventToSave.EndDate, eventToSave.Address, eventToSave.GroupId }); } }
private void PopulateWithSampleData(IContainer container) { using (var connection = new SqlConnection(ConfigurationManager.ConnectionStrings["EventOrganizerDb"].ConnectionString)) { var sql = "DELETE FROM [Events]; DELETE FROM [Users]; DELETE FROM [Groups]; DELETE FROM [UsersEvents]; DELETE FROM [UsersGroups]"; var command = connection.CreateCommand(); command.CommandText = sql; command.CommandType = CommandType.Text; connection.Open(); command.ExecuteNonQuery(); } var userRepo = container.Resolve<IUserRepository>(); var groupsRepo = container.Resolve<IGroupRepository>(); var eventsRepo = container.Resolve<IEventRepository>(); var eventMemberId = userRepo.Save(new User { Email = "*****@*****.**", Password = "******", Name = "Paweł", Surname = "Bejger" }); var groupId = groupsRepo.Save(new Group { Name = "Goyello integration", OwnerId = eventMemberId, Description = "Party hard!!" }); var eventToSave = new Event { GroupId = groupId, Name = "Laser-tag nite!", StartDate = DateTime.Now.AddDays(2), EndDate = DateTime.Now.AddDays(2).AddHours(2), Address = "Gdańsk", }; var eventId = eventsRepo.Save(eventToSave); userRepo.AddEventMember(eventId, eventMemberId); }
public bool Update(int id, Event eventToUpdate) { using (var connection = OpenConnection()) { const string sql = "UPDATE [Events] SET [Name] = @Name, StartDate = @StartDate, EndDate = @EndDate, Address = @Address, Description = @Description WHERE Id = @Id"; connection.Execute(sql, new { Id = id, eventToUpdate.Name, eventToUpdate.Description, eventToUpdate.StartDate, eventToUpdate.EndDate, eventToUpdate.Address }); return true; } }
public bool Update(int id, Event eventToUpdate) { return _eventRepository.Update(id, eventToUpdate); }
public long Save(Event eventToSave) { return _eventRepository.Save(eventToSave); }
public HttpResponseMessage Post(Event eventToSave) { eventToSave.Id = _eventService.Save(eventToSave); return Request.CreateResponse(HttpStatusCode.OK, eventToSave); }