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