public void CreateCalendarRaidEvent(CreateCalendarDto calendarDto) { var raid = new Raid(); // map calender to raid _databaseService.CreateRaid(raid); }
public long CreateCalendar(CreateCalendarDto dto) { using (var db = DataAccessUtil.CreateSqlConnection()) { db.Open(); var command = GetCreateCalendarCommand(db, dto, UniqueIdUtil.GenerateUniqueId(), false); command.ExecuteNonQuery(); return(QueryUtil.GetLastInsertedPrimaryKey(db)); } }
public void CreateCalendar() { var calendarToCreate = new CreateCalendarDto("MM-DD-YYYY", "Test library", "test desc", testLibrary.LibraryId); var calendarId = repository.CreateCalendar(calendarToCreate); var calendarRetrieved = repository.GetCalendar(calendarId); Assert.AreEqual(calendarId, calendarRetrieved.CalendarId); Assert.AreEqual(calendarToCreate.Name, calendarRetrieved.Name); Assert.AreEqual(calendarToCreate.Description, calendarRetrieved.Description); Assert.AreEqual(calendarToCreate.LibraryId, calendarRetrieved.LibraryId); Assert.AreEqual(calendarToCreate.DateFormat, calendarRetrieved.DateFormat); Assert.IsNotNull(calendarRetrieved.UniqueId); }
public void ShouldNotDeleteCalendar_WhenDifferentLibraryDeleted() { var otherLibrary = CreateAndRetrieveLibrary(new CreateLibraryDto("test 2")); var calendarToCreate = new CreateCalendarDto("MM-DD-YYYY", "Test library", "test desc", otherLibrary.LibraryId); var calendarId = repository.CreateCalendar(calendarToCreate); var calendarRetrieved = repository.GetCalendar(calendarId); libraryRepository.DeleteLibrary(testLibrary.LibraryId); CollectionAssert.AreEquivalent(new List <Calendar>(), repository.GetDeletedCalendars(GetFirstPage()).Result.Results); CollectionAssert.AreEquivalent(new List <Calendar>() { calendarRetrieved }, repository.GetCalendars(GetFirstPage()).Result.Results); }
private SqliteCommand GetCreateCalendarCommand(SqliteConnection db, CreateCalendarDto dto, string guid, bool ignoreDuplicates) { var ignoreClause = ignoreDuplicates ? "OR IGNORE" : ""; var command = new SqliteCommand(); command.Connection = db; command.CommandText = $"INSERT {ignoreClause} INTO calendar(name, date_format, description, library_id, deleted, deletion_due_to_cascade, unique_id) VALUES(@Name, @DateFormat, @Description, @LibraryId, false, false, @UniqueId)"; command.Parameters.AddWithValue("@Name", dto.Name); command.Parameters.AddWithValue("@DateFormat", dto.DateFormat); command.Parameters.AddWithValue("@Description", dto.Description); command.Parameters.AddWithValue("@LibraryId", dto.LibraryId); command.Parameters.AddWithValue("@UniqueId", guid); return(command); }
public void TestUpdateCalendar_ShouldNotUpdateDifferentCalendar() { var calendarDto = new CreateCalendarDto("MM-DD-YYYY", "Test library", "test desc", testLibrary.LibraryId); var calendarToUpdateId = repository.CreateCalendar(calendarDto); var calendarNotUpdatedId = repository.CreateCalendar(calendarDto); var calendarToUpdate = repository.GetCalendar(calendarToUpdateId); calendarToUpdate.Description += "1"; repository.UpdateCalendar(calendarToUpdate); var calendarToNotUpdate = repository.GetCalendar(calendarNotUpdatedId); Assert.AreNotEqual(calendarToUpdate.Description, calendarToNotUpdate.Description); }
//[RequireUserPermission(GuildPermission.ManageGuild)] public async Task CreateNewRaid(string raid, string difficulty, string dateTime, IUser user = null) { user ??= Context.User; var parsedDate = DateTime.Parse(dateTime); var dTo = new CreateCalendarDto() { RaidNaam = raid, Difficulty = difficulty, User = user, }; CalenderService.CreateCalendarRaidEvent(dTo); await ReplyAsync("Event Created"); }
public void ShouldNotRestoreCalendarDeletedNormally_WhenLibraryRestored() { var calendarToCreate = new CreateCalendarDto("MM-DD-YYYY", "Test library", "test desc", testLibrary.LibraryId); var calendarId = repository.CreateCalendar(calendarToCreate); repository.DeleteCalendar(calendarId); libraryRepository.DeleteLibrary(testLibrary.LibraryId); libraryRepository.RestoreDeletedLibrary(testLibrary.LibraryId); var calendarRetrieved = repository.GetCalendar(calendarId); CollectionAssert.AreEquivalent(new List <Calendar>() { calendarRetrieved }, repository.GetDeletedCalendars(GetFirstPage()).Result.Results); CollectionAssert.AreEquivalent(new List <Calendar>(), repository.GetCalendars(GetFirstPage()).Result.Results); }
public void TestUpdateCalendar() { var calendarToCreate = new CreateCalendarDto("MM-DD-YYYY", "Test library", "test desc", testLibrary.LibraryId); var calendarId = repository.CreateCalendar(calendarToCreate); var calendarRetrieved = repository.GetCalendar(calendarId); calendarRetrieved.Description += "1"; calendarRetrieved.Name += "2"; calendarRetrieved.DateFormat += "[TEST]"; repository.UpdateCalendar(calendarRetrieved); var updatedCalendarRetrieved = repository.GetCalendar(calendarId); Assert.AreEqual(calendarRetrieved.CalendarId, updatedCalendarRetrieved.CalendarId); Assert.AreEqual(calendarRetrieved.Name, updatedCalendarRetrieved.Name); Assert.AreEqual(calendarRetrieved.Description, updatedCalendarRetrieved.Description); Assert.AreEqual(calendarRetrieved.LibraryId, updatedCalendarRetrieved.LibraryId); Assert.AreEqual(calendarRetrieved.DateFormat, updatedCalendarRetrieved.DateFormat); CollectionAssert.AreEquivalent(new List <Calendar>() { updatedCalendarRetrieved }, repository.GetCalendars(GetFirstPage()).Result.Results); }
private Calendar CreateAndRetrieveCalendar(CreateCalendarDto dto) { var id = repository.CreateCalendar(dto); return(repository.GetCalendar(id)); }
public Calendar CreateAndRetrieveCalendar(CreateCalendarDto dto) { long libraryId = CreateCalendar(dto); return(new Calendar(libraryId, dto)); }
public long CreateCalendar(CreateCalendarDto dto) { return(calendarRepository.CreateCalendar(dto)); }