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