public static void Switch()
{
Console.WriteLine("Switch timetable");
var roomsTask = DataFactory.RoomService.Value.GetByPartitionKeyAsync(Configuration.Year);
roomsTask.Wait();
var rooms = roomsTask.Result.Where(x => x.RoomType != RoomType.CoffeeRoom).ToList();
Console.WriteLine("Chose room:");
var i = 0;
foreach (var room in rooms)
{
Console.WriteLine("{0} {1}", i++, room.Title);
}
i = int.Parse(Console.ReadLine());
var selectedRoom = rooms[i];
var timetableTask = DataFactory.TimetableService.Value.GetByPartitionKeyAsync(selectedRoom.Id.ToString("N"));
timetableTask.Wait();
var timetables = timetableTask.Result.Select(x => x.TopicId).ToList();
var topicTask = DataFactory.TopicService.Value.GetByPartitionKeyAsync(Configuration.Year);
topicTask.Wait();
var topics = topicTask.Result.Where(x => timetables.Contains(x.Id)).ToList();
Console.WriteLine("Chose topics to shitch:");
i = 0;
foreach (var topic in topics)
{
Console.WriteLine("{0} {1}", i++, topic.Title);
}
i = int.Parse(Console.ReadLine());
var k = int.Parse(Console.ReadLine());
var topic1 = topics[i];
var topic2 = topics[k];
var topicTmp = new WebSite.Data.Entity.Table.Topic
{
LanguageId = topic2.LanguageId,
Description = topic2.Description,
Title = topic2.Title
};
var speakersTopicTask = DataFactory.SpeakerTopicService.Value.GetAllAsync();
speakersTopicTask.Wait();
var speakersTopics = speakersTopicTask.Result.Where(x => x.TopicId == topic1.Id || x.TopicId == topic2.Id).ToList();
var speakers1 = speakersTopics.Where(x => x.TopicId == topic1.Id).ToList();
var speakers2 = speakersTopics.Where(x => x.TopicId == topic2.Id).ToList();
topic2.LanguageId = topic1.LanguageId;
topic2.Title = topic1.Title;
topic2.Description = topic1.Description;
topic1.LanguageId = topicTmp.LanguageId;
topic1.Title = topicTmp.Title;
topic1.Description = topicTmp.Description;
Console.WriteLine("Processing...");
DataFactory.TopicService.Value.ReplaceAsync(topic1).Wait();
DataFactory.TopicService.Value.ReplaceAsync(topic2).Wait();
foreach (var speakerTopic in speakers1)
{
DataFactory.SpeakerTopicService.Value.DeleteAsync(speakerTopic).Wait();
DataFactory.SpeakerTopicService.Value.InsertAsync(new WebSite.Data.Entity.Table.SpeakerTopic
{
OrderN = speakerTopic.OrderN,
SpeakerId = speakerTopic.SpeakerId,
TopicId = topic2.Id
}).Wait();
}
foreach (var speakerTopic in speakers2)
{
DataFactory.SpeakerTopicService.Value.DeleteAsync(speakerTopic).Wait();
DataFactory.SpeakerTopicService.Value.InsertAsync(new WebSite.Data.Entity.Table.SpeakerTopic
{
OrderN = speakerTopic.OrderN,
SpeakerId = speakerTopic.SpeakerId,
TopicId = topic1.Id
}).Wait();
}
Console.WriteLine("Done.");
}
internal static void Add()
{
Console.WriteLine("Add timetable");
var rooms = new List<string>
{
"0b67e087498043cfa0a5f32a02d4bdb3", //dev
"221b1c6fecdd4e218a9ddf84fd1e5c3b", //work
"748802a3a8a34ebe9945b2a321da438b", //it
"83d518c5927a4d0488aeb7c1e1f17cda" //ops
};
var coffeeRoomId = "f05b87486e2e46a9a1d4dedc74087bc8";
for (var i = 1; i <= 3; i++)
{
var topic = new WebSite.Data.Entity.Table.Topic
{
Id = Guid.NewGuid(),
Title = string.Format("Coffee {1}", coffeeRoomId, i),
Description = "Тема в процессе формирования.",
LanguageId = Guid.Parse("05cd0801f82c4428bd84ab10e31ec528")
};
var timeTable = new WebSite.Data.Entity.Table.Timetable
{
RoomId = Guid.Parse(coffeeRoomId),
TopicId = topic.Id,
TimeStartHours = i,
TimeEndHours = i,
TimeStartMinutes = 0,
TimeEndMinutes = 0
};
DataFactory.TopicService.Value.InsertAsync(topic).Wait();
DataFactory.TimetableService.Value.InsertAsync(timeTable).Wait();
}
// merged
//for (var i = 1; i <= 3; i++)
//{
// var roomId = "0b67e087498043cfa0a5f32a02d4bdb3";
// var topic = new WebSite.Data.Entity.Table.Topic
// {
// Id = Guid.NewGuid(),
// Title = string.Format("Merged {1}", roomId, i),
// Description = "Тема в процессе формирования.",
// LanguageId = Guid.Parse("05cd0801f82c4428bd84ab10e31ec528")
// };
// var timeTable = new WebSite.Data.Entity.Table.Timetable
// {
// RoomId = Guid.Parse(roomId),
// TopicId = topic.Id,
// TimeStartHours = i,
// TimeEndHours = i,
// TimeStartMinutes = 0,
// TimeEndMinutes = 0
// };
// DataFactory.TopicService.Value.InsertAsync(topic).Wait();
// DataFactory.TimetableService.Value.InsertAsync(timeTable).Wait();
//}
// regular
//for (var i = 1; i <= 6; i++)
//{
// foreach (var roomId in rooms)
// {
// var topic = new WebSite.Data.Entity.Table.Topic
// {
// Id = Guid.NewGuid(),
// Title = string.Format("{0} {1}", roomId, i),
// Description = "Тема в процессе формирования.",
// LanguageId = Guid.Parse("05cd0801f82c4428bd84ab10e31ec528")
// };
// var timeTable = new WebSite.Data.Entity.Table.Timetable
// {
// RoomId = Guid.Parse(roomId),
// TopicId = topic.Id,
// TimeStartHours = i,
// TimeEndHours = i,
// TimeStartMinutes = 0,
// TimeEndMinutes = 0
// };
// DataFactory.TopicService.Value.InsertAsync(topic).Wait();
// DataFactory.TimetableService.Value.InsertAsync(timeTable).Wait();
// }
//}
}