//Tworzy wątki, które pobierają odcinki (w jednej paczce przechodzi max. 100 odcinków) private void add() { ep = new DownloadEpisodes().getEpisodes(main.SelectedSeries._id); if (new ReadFromDataBase().DatabaseConnected()) { try { AddToDataBase add = new AddToDataBase(); add.addTvSeries(main.SelectedSeries); foreach (Episode e in ep) { add.addEpisode(main.SelectedSeries._id, e); } } catch (Exception e) { MessageBox.Show(e.Message, "Error", MessageBoxButton.OK, MessageBoxImage.Error); } } Application.Current.Dispatcher.Invoke(new Action(() => main.setExist(true))); Application.Current.Dispatcher.Invoke(new Action(() => main.LoadingScreen = Visibility.Hidden)); }
public void TestAddDeleteToDatabaseSpecialty() { Specialty spec = new Specialty() { Id = 1, SpecName = "Машино- и приборостроение", NameGroup = "МТ-21", NameGroup_2 = "МТ-22" }; AddToDataBase add = new AddToDataBase(); add.AddNewSpecialty(spec); DataContext db = new DataContext(connectionString); Specialty sp = db.GetTable <Specialty>().OrderByDescending(u => u.Id).FirstOrDefault(); var except_EndElement = true; var actual_EndElement = spec.Equals(sp); DeleteToDataBase del = new DeleteToDataBase(); del.DeleteSpecialty(); sp = db.GetTable <Specialty>().OrderByDescending(u => u.Id).FirstOrDefault(); var except_EndElement_2 = false; var actual_EndElement_2 = spec.Equals(sp); Assert.AreEqual(except_EndElement, actual_EndElement); Assert.AreEqual(except_EndElement_2, actual_EndElement_2); }
public void TestAddDeleteToDatabaseExaminer() { Examiner examiner = new Examiner { Id = 5, Name = "Илья", SurName = "Шутов", Patronymic = "Борисович", Examen = "Математика", Examen_2 = "Информатика" }; AddToDataBase add = new AddToDataBase(); add.AddNewExaminer(examiner); DataContext db = new DataContext(connectionString); Examiner ex = db.GetTable <Examiner>().OrderByDescending(u => u.Id).FirstOrDefault(); var except_EndElement = true; var actual_EndElement = examiner.Equals(ex); DeleteToDataBase del = new DeleteToDataBase(); del.DeleteEndExaminer(); ex = db.GetTable <Examiner>().OrderByDescending(u => u.Id).FirstOrDefault(); var except_EndElement_2 = false; var actual_EndElement_2 = examiner.Equals(ex); Assert.AreEqual(except_EndElement, actual_EndElement); Assert.AreEqual(except_EndElement_2, actual_EndElement_2); }
//Aktualizuje wszystkie zaznaczone seriale i tworzy log z procesu private void getEpisodes() { Application.Current.Dispatcher.Invoke(new Action(() => main.clearLog())); foreach (Series s in main.seriesList) { if (s._update) { List <Episode> ep = new List <Episode>(); ReadFromDataBase RD = new ReadFromDataBase(); UpdateDataBase UD = new UpdateDataBase(); AddToDataBase AD = new AddToDataBase(); Application.Current.Dispatcher.Invoke(new Action(() => main.addToLog("Pobieram " + s._seriesName))); ep = new DownloadEpisodes().getEpisodes(s._id); Application.Current.Dispatcher.Invoke(new Action(() => main.addToLog("Aktualizuję " + s._seriesName))); int update = 0, added = 0; foreach (Episode e in ep) { if (RD.EpisodeExist(e._id)) { if (RD.EpisodeLastUpdate(e._id) < e._lastUpdate) { UD.UpdateEpisode(e); update++; } } else { AD.addEpisode(s._id, e); added++; } } Application.Current.Dispatcher.Invoke(new Action(() => main.addToLog(" Zaktualizowałem " + update + " odcinków"))); Application.Current.Dispatcher.Invoke(new Action(() => main.addToLog(" Dodałem " + added + " odcinków"))); } else { Application.Current.Dispatcher.Invoke(new Action(() => main.addToLog("Pomijam " + s._seriesName))); } } Application.Current.Dispatcher.Invoke(new Action(() => main.LoadingScreen = Visibility.Hidden)); }
private void clear() { Application.Current.Dispatcher.Invoke(new Action(() => main.clearLog())); foreach (Series s in main.seriesList) { if (s._update) { AddToDataBase AD = new AddToDataBase(); List <Episode> ep = new List <Episode>(); Episode last = new ReadFromDataBase().GetLastEpisode(s._id); Application.Current.Dispatcher.Invoke(new Action(() => main.addToLog("Pobieram " + s._seriesName))); ep = new DownloadEpisodes().getEpisodes(s._id); Application.Current.Dispatcher.Invoke(new Action(() => main.addToLog("Aktualizuję " + s._seriesName))); new DeleteFromDataBase().deleteEpisodes(s._id); foreach (Episode e in ep) { AD.addEpisode(s._id, e); } if (last != null) { new UpdateDataBase().AllBelowWatched(s._id, last._episodeNumber, last._seasonNumber, true); new UpdateDataBase().AllAboveUnwatched(s._id, last._episodeNumber, last._seasonNumber, false); } else { new UpdateDataBase().AllWatched(s._id, true); new UpdateDataBase().AllNotAiredUnwatched(s._id); } } else { Application.Current.Dispatcher.Invoke(new Action(() => main.addToLog("Pomijam " + s._seriesName))); } } Application.Current.Dispatcher.Invoke(new Action(() => main.LoadingScreen = Visibility.Hidden)); }
public void TestAddDeleteToDatabaseStudent() { Student student = new Student() { Id = 12, Name = "Юрий", SurName = "Корнеев", Patronymic = "Олегович", DateBr = new DateTime(2002, 4, 2), Sex = "Муж", Group = "ИТП-21", ExamName_1 = "ООП", ExamName_2 = "КС", ExamName_3 = "Экономика", ExamDate_1 = new DateTime(2021, 1, 12), ExamDate_2 = new DateTime(2021, 1, 14), ExamDate_3 = new DateTime(2021, 1, 16), Mark_1 = 7, Mark_2 = 8, Mark_3 = 6 }; AddToDataBase add = new AddToDataBase(); add.AddNewStudent(student); DataContext db = new DataContext(connectionString); Student st = db.GetTable <Student>().OrderByDescending(u => u.Id).FirstOrDefault(); var except_EndElement = true; var actual_EndElement = student.Equals(st); DeleteToDataBase del = new DeleteToDataBase(); del.DeleteEndStudent(); st = db.GetTable <Student>().OrderByDescending(u => u.Id).FirstOrDefault(); var except_EndElement_2 = false; var actual_EndElement_2 = student.Equals(st); Assert.AreEqual(except_EndElement, actual_EndElement); Assert.AreEqual(except_EndElement_2, actual_EndElement_2); }