public void ChangeTo(Speciality old, Speciality anew)
{
if (old.IdSpeciality != anew.IdSpeciality &&
base.FindAll(x => x.ToString().Trim() == anew.ToString().Trim()).Count > 0)
{
throw new Exception($"Специальность \"{anew}\" уже существует!");
}
old.Name = anew.Name;
old.Number = anew.Number;
base.Sort();
if (!Loaded)
{
return;
}
var server = new OleDbServer {
Connection = Helper.ConnectionString
};
var columns = new Dictionary <string, object>
{
{ "IdSpeciality", "P" + anew.IdSpeciality.ToString() },
{ "Name", anew.Name },
{ "Number", anew.Number }
};
server.UpdateInto("Specialities", columns);
if (!string.IsNullOrWhiteSpace(server.LastError))
{
throw new Exception(server.LastError);
}
}
public void ChangeTo(Matter old, Matter anew)
{
if (old.IdMatter != anew.IdMatter &&
base.FindAll(x => x.ToString().Trim() == anew.ToString().Trim()).Count > 0)
{
throw new Exception($"Предмет \"{anew}\" уже существует!");
}
old.Name = anew.Name;
base.Sort();
if (!Loaded)
{
return;
}
var server = new OleDbServer {
Connection = Helper.ConnectionString
};
var columns = new Dictionary <string, object>
{
{ "IdMatter", "P" + anew.IdMatter.ToString() },
{ "Name", anew.Name }
};
server.UpdateInto("Matters", columns);
if (!string.IsNullOrWhiteSpace(server.LastError))
{
throw new Exception(server.LastError);
}
}
public void ChangeTo(Semester old, Semester anew)
{
if (old.IdSemester != anew.IdSemester &&
base.FindAll(x => x.ToString().Trim() == anew.ToString().Trim()).Count > 0)
{
throw new Exception($"Семестр \"{anew}\" уже существует!");
}
old.Number = anew.Number;
base.Sort();
// -- Changed = true;
// добавлено 29.06.2019
if (!Loaded)
{
return;
}
var server = new OleDbServer {
Connection = Helper.ConnectionString
};
var columns = new Dictionary <string, object>
{
{ "IdSemester", "P" + anew.IdSemester.ToString() },
{ "Number", anew.Number }
};
server.UpdateInto("Semesters", columns);
if (!string.IsNullOrWhiteSpace(server.LastError))
{
throw new Exception(server.LastError);
}
}
public new void Add(StudyGroup item)
{
if (base.Exists(x => x.ToString().Trim() == item.ToString().Trim()))
{
throw new Exception($"Группа \"{item}\" уже существует!");
}
base.Add(item);
base.Sort();
if (!Loaded)
{
return;
}
var server = new OleDbServer {
Connection = Helper.ConnectionString
};
var columns = new Dictionary <string, object>
{
{ "IdStudyGroup", "P" + item.IdStudyGroup.ToString() },
{ "Number", item.Number },
{ "TrainingPeriod", item.TrainingPeriod },
{ "IdSpeciality", "P" + item.IdSpeciality.ToString() },
{ "IdSpecialization", "P" + item.IdSpecialization.ToString() }
};
server.InsertInto("StudyGroups", columns);
if (!string.IsNullOrWhiteSpace(server.LastError))
{
throw new Exception(server.LastError);
}
}
public void ChangeTo(StudyGroup old, StudyGroup anew)
{
if (old.IdStudyGroup != anew.IdStudyGroup &&
base.FindAll(x => x.ToString().Trim() == anew.ToString().Trim()).Count > 0)
{
throw new Exception($"Группа \"{anew}\" уже существует!");
}
old.Number = anew.Number;
old.TrainingPeriod = anew.TrainingPeriod;
old.IdSpeciality = anew.IdSpeciality;
old.IdSpecialization = anew.IdSpecialization;
base.Sort();
if (!Loaded)
{
return;
}
var server = new OleDbServer {
Connection = Helper.ConnectionString
};
var columns = new Dictionary <string, object>
{
{ "IdStudyGroup", "P" + anew.IdStudyGroup.ToString() },
{ "Number", anew.Number },
{ "TrainingPeriod", anew.TrainingPeriod },
{ "IdSpeciality", "P" + anew.IdSpeciality.ToString() },
{ "IdSpecialization", "P" + anew.IdSpecialization.ToString() }
};
server.UpdateInto("StudyGroups", columns);
if (!string.IsNullOrWhiteSpace(server.LastError))
{
throw new Exception(server.LastError);
}
}
public new void Remove(StudyGroup item)
{
if (Helper.StudyGroupUsed(item.IdSpecialization))
{
throw new Exception($"Группа \"{item}\" ещё используется!");
}
base.Remove(item);
if (!Loaded)
{
return;
}
var server = new OleDbServer {
Connection = Helper.ConnectionString
};
var columns = new Dictionary <string, object>
{
{ "IdStudyGroup", "P" + item.IdStudyGroup.ToString() },
};
server.DeleteInto("StudyGroups", columns);
if (!string.IsNullOrWhiteSpace(server.LastError))
{
throw new Exception(server.LastError);
}
}
public void ChangeTo(Teacher old, Teacher anew)
{
if (old.IdTeacher != anew.IdTeacher &&
base.FindAll(x => x.ToString().Trim() == anew.ToString().Trim()).Count > 0)
{
throw new Exception($"Преподаватель \"{anew}\" уже существует!");
}
old.FullName = anew.FullName;
old.IdMatter = anew.IdMatter;
old.Login = anew.Login;
old.Password = anew.Password;
base.Sort();
if (!Loaded)
{
return;
}
var server = new OleDbServer {
Connection = Helper.ConnectionString
};
var columns = new Dictionary <string, object>
{
{ "IdTeacher", "P" + anew.IdTeacher.ToString() },
{ "FullName", anew.FullName },
{ "IdMatter", "P" + anew.IdMatter.ToString() },
{ "Login", anew.Login },
{ "Password", anew.Password }
};
server.UpdateInto("Teachers", columns);
if (!string.IsNullOrWhiteSpace(server.LastError))
{
throw new Exception(server.LastError);
}
}
public new void Remove(Teacher item)
{
if (Helper.MatterUsed(item.IdMatter))
{
throw new Exception($"Преподаватель \"{item}\" ещё используется!");
}
base.Remove(item);
if (!Loaded)
{
return;
}
var server = new OleDbServer {
Connection = Helper.ConnectionString
};
var columns = new Dictionary <string, object>
{
{ "IdTeacher", "P" + item.IdTeacher.ToString() },
};
server.DeleteInto("Teachers", columns);
if (!string.IsNullOrWhiteSpace(server.LastError))
{
throw new Exception(server.LastError);
}
}
public void ChangeTo(Specialization old, Specialization anew)
{
if (old.IdSpecialization != anew.IdSpecialization &&
base.FindAll(x => x.ToString().Trim() == anew.ToString().Trim()).Count > 0)
{
throw new Exception($"Специализация \"{anew}\" уже существует!");
}
old.Name = anew.Name;
old.IdSpeciality = anew.IdSpeciality;
base.Sort();
// -- Changed = true;
// добавлено 29.06.2019
if (!Loaded)
{
return;
}
var server = new OleDbServer {
Connection = Helper.ConnectionString
};
var columns = new Dictionary <string, object>
{
{ "IdSpecialization", "P" + anew.IdSpecialization.ToString() },
{ "Name", anew.Name },
{ "IdSpeciality", "P" + anew.IdSpeciality.ToString() }
};
server.UpdateInto("Specializations", columns);
if (!string.IsNullOrWhiteSpace(server.LastError))
{
throw new Exception(server.LastError);
}
}
public new void Add(Student item)
{
base.Add(item);
base.Sort();
if (!Loaded)
{
return;
}
var server = new OleDbServer {
Connection = Helper.ConnectionString
};
var columns = new Dictionary <string, object>
{
{ "IdStudent", "P" + item.IdStudent.ToString() },
{ "FullName", item.FullName },
{ "BirthDay", item.BirthDay },
{ "EducationCertificate", item.EducationCertificate },
{ "ReceiptDate", item.ReceiptDate },
{ "Address", item.Address },
{ "PhoneNumber", item.PhoneNumber },
{ "SocialStatus", item.SocialStatus },
{ "Notes", item.Notes },
{ "Photo", item.Photo ?? new byte[] { } },
{ "IdSpeciality", "P" + item.IdSpeciality.ToString() },
{ "IdSpecialization", "P" + item.IdSpecialization.ToString() },
{ "IdStudyGroup", "P" + item.IdStudyGroup.ToString() }
};
server.InsertInto("Students", columns);
if (!string.IsNullOrWhiteSpace(server.LastError))
{
throw new Exception(server.LastError);
}
}
public new void Remove(Speciality item)
{
if (Helper.SpecialityUsed(item.IdSpeciality))
{
throw new Exception($"Специальность \"{item}\" ещё используется!");
}
base.Remove(item);
if (!Loaded)
{
return;
}
var server = new OleDbServer {
Connection = Helper.ConnectionString
};
var columns = new Dictionary <string, object>
{
{ "IdSpeciality", "P" + item.IdSpeciality.ToString() },
};
server.DeleteInto("Specialities", columns);
if (!string.IsNullOrWhiteSpace(server.LastError))
{
throw new Exception(server.LastError);
}
}
public new void Remove(Semester item)
{
if (Helper.SemesterUsed(item.IdSemester))
{
throw new Exception($"Семестр \"{item}\" ещё используется!");
}
base.Remove(item);
// -- Changed = true;
// добавлено 29.06.2019
if (!Loaded)
{
return;
}
var server = new OleDbServer {
Connection = Helper.ConnectionString
};
var columns = new Dictionary <string, object>
{
{ "IdSemester", "P" + item.IdSemester.ToString() },
};
server.DeleteInto("Semesters", columns);
if (!string.IsNullOrWhiteSpace(server.LastError))
{
throw new Exception(server.LastError);
}
}
// -- [NonSerialized]
// -- public bool Changed;
public new void Add(Semester item)
{
if (base.Exists(x => x.ToString().Trim() == item.ToString().Trim()))
{
throw new Exception($"Семестр \"{item}\" уже существует!");
}
base.Add(item);
base.Sort();
// -- Changed = true;
// добавлено 29.06.2019
if (!Loaded)
{
return;
}
var server = new OleDbServer {
Connection = Helper.ConnectionString
};
var columns = new Dictionary <string, object>
{
{ "IdSemester", "P" + item.IdSemester.ToString() },
{ "Number", item.Number }
};
server.InsertInto("Semesters", columns);
if (!string.IsNullOrWhiteSpace(server.LastError))
{
throw new Exception(server.LastError);
}
}
// -- [NonSerialized]
// -- public bool Changed;
public new void Add(Performance item)
{
if (base.Exists(x => x.ToString().Trim() == item.ToString().Trim()))
{
throw new Exception($"Успеваемость \"{item}\" уже существует!");
}
base.Add(item);
base.Sort();
// -- Changed = true;
// добавлено 29.06.2019
if (!Loaded)
{
return;
}
var server = new OleDbServer {
Connection = Helper.ConnectionString
};
var columns = new Dictionary <string, object>
{
{ "IdPerformance", "P" + item.IdPerformance.ToString() },
{ "IdSemester", "P" + item.IdSemester.ToString() },
{ "IdMatter", "P" + item.IdMatter.ToString() },
{ "Grade", item.Grade },
{ "IdStudent", "P" + item.IdStudent.ToString() }
};
server.InsertInto("Performances", columns);
if (!string.IsNullOrWhiteSpace(server.LastError))
{
throw new Exception(server.LastError);
}
}
public new void Add(Semester item)
{
if (base.Exists(x => x.ToString().Trim() == item.ToString().Trim()))
{
throw new Exception($"Семестр \"{item}\" уже существует!");
}
else
{
base.Add(item);
}
base.Sort();
if (!Loaded)
{
return;
}
var server = new OleDbServer {
Connection = Helper.ConnectionString
};
var columns = new Dictionary <string, object>
{
{ "IdSemester", "P" + item.IdSemester.ToString() },
{ "Number", item.Number }
};
server.InsertInto("Semesters", columns);
}
public new void Remove(Performance item)
{
if (Helper.PerformanceUsed(item.IdPerformance))
{
throw new Exception($"Успеваемость \"{item}\" ещё используются!");
}
base.Remove(item);
// -- Changed = true;
// добавлено 29.06.2019
if (!Loaded)
{
return;
}
var server = new OleDbServer {
Connection = Helper.ConnectionString
};
var columns = new Dictionary <string, object>
{
{ "IdPerformance", "P" + item.IdPerformance.ToString() },
};
server.DeleteInto("Performances", columns);
if (!string.IsNullOrWhiteSpace(server.LastError))
{
throw new Exception(server.LastError);
}
}
// -- [NonSerialized]
// -- public bool Changed;
public new void Add(Teacher item)
{
if (base.Exists(x => x.ToString().Trim() == item.ToString().Trim()))
{
throw new Exception($"Преподаватель \"{item}\" уже существует!");
}
base.Add(item);
base.Sort();
// -- Changed = true;
// добавлено 29.06.2019
if (!Loaded)
{
return;
}
var server = new OleDbServer {
Connection = Helper.ConnectionString
};
var columns = new Dictionary <string, object>
{
{ "IdTeacher", "P" + item.IdTeacher.ToString() },
{ "FullName", item.FullName },
{ "IdMatter", "P" + item.IdMatter.ToString() },
{ "Login", item.Login },
{ "Password", item.Password }
};
server.InsertInto("Teachers", columns);
if (!string.IsNullOrWhiteSpace(server.LastError))
{
throw new Exception(server.LastError);
}
}
public new void Add(MattersCourse item)
{
if (base.Exists(x => x.ToString().Trim() == item.ToString().Trim()))
{
throw new Exception($"Курс \"{item}\" уже существует!");
}
base.Add(item);
base.Sort();
if (!Loaded)
{
return;
}
var server = new OleDbServer {
Connection = Helper.ConnectionString
};
var columns = new Dictionary <string, object>
{
{ "IdMattersCourse", "P" + item.IdMatter.ToString() },
{ "IdSpeciality", "P" + item.IdSpeciality.ToString() },
{ "IdSpecialization", "P" + item.IdSpecialization.ToString() },
{ "IdMatter", "P" + item.IdMatter.ToString() },
{ "CourseType", item.CourseType },
{ "RatingSystem", item.RatingSystem },
{ "HoursCount", item.HoursCount }
};
server.InsertInto("MattersCourses", columns);
}
public new void Remove(Student item)
{
if (Helper.StudentUsed(item.IdStudent))
{
throw new Exception($"Данные о студенте \"{item}\" ещё используются!");
}
base.Remove(item);
if (!Loaded)
{
return;
}
var server = new OleDbServer {
Connection = Helper.ConnectionString
};
var columns = new Dictionary <string, object>
{
{ "IdStudent", "P" + item.IdStudent.ToString() },
};
server.DeleteInto("Students", columns);
if (!string.IsNullOrWhiteSpace(server.LastError))
{
throw new Exception(server.LastError);
}
}
public new void Add(Speciality item)
{
if (base.Exists(x => x.ToString().Trim() == item.ToString().Trim()))
{
throw new Exception($"Специальность \"{item}\" уже существует!");
}
base.Add(item);
base.Sort();
if (!Loaded)
{
return;
}
var server = new OleDbServer {
Connection = Helper.ConnectionString
};
var columns = new Dictionary <string, object>
{
{ "IdSpeciality", "P" + item.IdSpeciality.ToString() },
{ "Name", item.Name },
{ "Number", item.Number }
};
server.InsertInto("Specialities", columns);
if (!string.IsNullOrWhiteSpace(server.LastError))
{
throw new Exception(server.LastError);
}
}
public new void Add(Matter item)
{
if (base.Exists(x => x.ToString().Trim() == item.ToString().Trim()))
{
throw new Exception($"Предмет \"{item}\" уже существует!");
}
else
{
base.Add(item);
}
base.Sort();
if (!Loaded)
{
return;
}
var server = new OleDbServer {
Connection = Helper.ConnectionString
};
var columns = new Dictionary <string, object>
{
{ "IdMatter", "P" + item.IdMatter.ToString() },
{ "Name", item.Name }
};
server.InsertInto("Matters", columns);
if (!string.IsNullOrWhiteSpace(server.LastError))
{
throw new Exception(server.LastError);
}
}
public void ChangeTo(Student old, Student anew)
{
if (old.IdStudent != anew.IdStudent &&
base.FindAll(x => x.ToString().Trim() == anew.ToString().Trim()).Count > 0)
{
throw new Exception($"Студент \"{anew}\" уже существует!");
}
old.FullName = anew.FullName;
old.BirthDay = anew.BirthDay;
old.EducationCertificate = anew.EducationCertificate;
old.ReceiptDate = anew.ReceiptDate;
old.Address = anew.Address;
old.PhoneNumber = anew.PhoneNumber;
old.SocialStatus = anew.SocialStatus;
old.Notes = anew.Notes;
old.Photo = anew.Photo.DeepClone();
old.IdSpeciality = anew.IdSpeciality;
old.IdSpecialization = anew.IdSpecialization;
old.IdStudyGroup = anew.IdStudyGroup;
base.Sort();
// -- Changed = true;
// добавлено 29.06.2019
if (!Loaded)
{
return;
}
var server = new OleDbServer {
Connection = Helper.ConnectionString
};
var columns = new Dictionary <string, object>
{
{ "IdStudent", "P" + anew.IdStudent.ToString() },
{ "FullName", anew.FullName },
{ "BirthDay", anew.BirthDay },
{ "EducationCertificate", anew.EducationCertificate },
{ "ReceiptDate", anew.ReceiptDate },
{ "Address", anew.Address },
{ "PhoneNumber", anew.PhoneNumber },
{ "SocialStatus", anew.SocialStatus },
{ "Notes", anew.Notes },
{ "Photo", anew.Photo ?? new byte[] { } },
{ "IdSpeciality", "P" + anew.IdSpeciality.ToString() },
{ "IdSpecialization", "P" + anew.IdSpecialization.ToString() },
{ "IdStudyGroup", "P" + anew.IdStudyGroup.ToString() }
};
server.UpdateInto("Students", columns);
if (!string.IsNullOrWhiteSpace(server.LastError))
{
throw new Exception(server.LastError);
}
}
public void ChangeTo(MattersCourse old, MattersCourse anew)
{
if (old.IdMattersCourse != anew.IdMattersCourse &&
base.FindAll(x => x.ToString().Trim() == anew.ToString().Trim()).Count > 0)
{
throw new Exception($"Курс \"{anew}\" уже существует!");
}
old.IdSpeciality = anew.IdSpeciality;
old.IdSpecialization = anew.IdSpecialization;
old.IdMatter = anew.IdMatter;
old.CourseType = anew.CourseType;
old.RatingSystem = anew.RatingSystem;
old.HoursCount = anew.HoursCount;
base.Sort();
// -- Changed = true;
// добавлено 29.06.2019
if (!Loaded)
{
return;
}
var server = new OleDbServer {
Connection = Helper.ConnectionString
};
var columns = new Dictionary <string, object>
{
{ "IdMattersCourse", "P" + anew.IdMatter.ToString() },
{ "IdSpeciality", "P" + anew.IdSpeciality.ToString() },
{ "IdSpecialization", "P" + anew.IdSpecialization.ToString() },
{ "IdMatter", "P" + anew.IdMatter.ToString() },
{ "CourseType", anew.CourseType },
{ "RatingSystem", anew.RatingSystem },
{ "HoursCount", anew.HoursCount }
};
server.UpdateInto("MattersCourses", columns);
if (!string.IsNullOrWhiteSpace(server.LastError))
{
throw new Exception(server.LastError);
}
}
// -- [NonSerialized]
// -- public bool Changed;
public new void Add(Student item)
{
// -- Допускаются студенты с одиковым полным именем
// -- if (base.Exists(x => x.ToString().Trim() == item.ToString().Trim()))
// -- throw new Exception($"Студент \"{item}\" уже существует!");
base.Add(item);
base.Sort();
// -- Changed = true;
// добавлено 29.06.2019
if (!Loaded)
{
return;
}
var server = new OleDbServer {
Connection = Helper.ConnectionString
};
var columns = new Dictionary <string, object>
{
{ "IdStudent", "P" + item.IdStudent.ToString() },
{ "FullName", item.FullName },
{ "BirthDay", item.BirthDay },
{ "EducationCertificate", item.EducationCertificate },
{ "ReceiptDate", item.ReceiptDate },
{ "Address", item.Address },
{ "PhoneNumber", item.PhoneNumber },
{ "SocialStatus", item.SocialStatus },
{ "Notes", item.Notes },
{ "Photo", item.Photo ?? new byte[] { } },
{ "IdSpeciality", "P" + item.IdSpeciality.ToString() },
{ "IdSpecialization", "P" + item.IdSpecialization.ToString() },
{ "IdStudyGroup", "P" + item.IdStudyGroup.ToString() }
};
server.InsertInto("Students", columns);
if (!string.IsNullOrWhiteSpace(server.LastError))
{
throw new Exception(server.LastError);
}
}
public new void Remove(Matter item)
{
base.Remove(item);
if (!Loaded)
{
return;
}
var server = new OleDbServer {
Connection = Helper.ConnectionString
};
var columns = new Dictionary <string, object>
{
{ "IdMatter", "P" + item.IdMatter.ToString() },
};
server.DeleteInto("Matters", columns);
if (!string.IsNullOrWhiteSpace(server.LastError))
{
throw new Exception(server.LastError);
}
}
public void ChangeTo(Performance old, Performance anew)
{
if (old.IdPerformance != anew.IdPerformance &&
base.FindAll(x => x.IdStudent != anew.IdStudent &&
x.ToString().Trim() == anew.ToString().Trim()).Count > 0)
{
throw new Exception($"Успеваемость \"{anew}\" уже существует!");
}
old.IdSemester = anew.IdSemester;
old.IdMatter = anew.IdMatter;
old.Grade = anew.Grade;
old.IdStudent = anew.IdStudent;
base.Sort();
// -- Changed = true;
// добавлено 29.06.2019
if (!Loaded)
{
return;
}
var server = new OleDbServer {
Connection = Helper.ConnectionString
};
var columns = new Dictionary <string, object>
{
{ "IdPerformance", "P" + anew.IdPerformance.ToString() },
{ "IdSemester", "P" + anew.IdSemester.ToString() },
{ "IdMatter", "P" + anew.IdMatter.ToString() },
{ "Grade", anew.Grade },
{ "IdStudent", "P" + anew.IdStudent.ToString() }
};
server.UpdateInto("Performances", columns);
if (!string.IsNullOrWhiteSpace(server.LastError))
{
throw new Exception(server.LastError);
}
}
/// <summary>
/// Метод загрузки сохранённой ранее конфигурации из базы данных
/// </summary>
/// <param name="connection"></param>
/// <returns></returns>
public static Root LoadFromBase(string connection)
{
var root = new Root();
var server = new OleDbServer {
Connection = connection
};
// предметы
var dataSet = server.GetRows("Matters");
if (dataSet.Tables.Count > 0)
{
foreach (var row in dataSet.Tables[0].Rows.Cast <DataRow>())
{
if (row.ItemArray.Length != 2)
{
continue;
}
root.Matters.Add(new Matter
{
IdMatter = Guid.Parse(row.ItemArray[0].ToString().Substring(1)),
Name = row.ItemArray[1].ToString()
});
}
}
// -- root.Matters.Changed = false;
root.Matters.Loaded = true; // добавлено 29.06.2019
OperationResult = server.LastError;
if (!string.IsNullOrWhiteSpace(OperationResult))
{
return(root);
}
// специальности
dataSet = server.GetRows("Specialities");
if (dataSet.Tables.Count > 0)
{
foreach (var row in dataSet.Tables[0].Rows.Cast <DataRow>())
{
if (row.ItemArray.Length != 3)
{
continue;
}
root.Specialities.Add(new Speciality
{
IdSpeciality = Guid.Parse(row.ItemArray[0].ToString().Substring(1)),
Name = row.ItemArray[1].ToString(),
Number = int.Parse(row.ItemArray[2].ToString())
});
}
}
// -- root.Specialities.Changed = false;
root.Specialities.Loaded = true; // добавлено 29.06.2019
OperationResult = server.LastError;
if (!string.IsNullOrWhiteSpace(OperationResult))
{
return(root);
}
// специализации
dataSet = server.GetRows("Specializations");
if (dataSet.Tables.Count > 0)
{
foreach (var row in dataSet.Tables[0].Rows.Cast <DataRow>())
{
if (row.ItemArray.Length != 3)
{
continue;
}
root.Specializations.Add(new Specialization
{
IdSpecialization = Guid.Parse(row.ItemArray[0].ToString().Substring(1)),
Name = row.ItemArray[1].ToString(),
IdSpeciality = Guid.Parse(row.ItemArray[2].ToString().Substring(1))
});
}
}
// -- root.Specializations.Changed = false;
root.Specializations.Loaded = true; // добавлено 29.06.2019
OperationResult = server.LastError;
if (!string.IsNullOrWhiteSpace(OperationResult))
{
return(root);
}
// курсы предметов
dataSet = server.GetRows("MattersCourses");
if (dataSet.Tables.Count > 0)
{
foreach (var row in dataSet.Tables[0].Rows.Cast <DataRow>())
{
if (row.ItemArray.Length != 7)
{
continue;
}
root.MattersCourses.Add(new MattersCourse
{
IdMattersCourse = Guid.Parse(row.ItemArray[0].ToString().Substring(1)),
IdSpeciality = Guid.Parse(row.ItemArray[1].ToString().Substring(1)),
IdSpecialization = Guid.Parse(row.ItemArray[2].ToString().Substring(1)),
IdMatter = Guid.Parse(row.ItemArray[3].ToString().Substring(1)),
CourseType = (CourseType)Enum.Parse(typeof(CourseType), row.ItemArray[4].ToString()),
RatingSystem = (RatingSystem)Enum.Parse(typeof(RatingSystem), row.ItemArray[5].ToString()),
HoursCount = float.Parse(row.ItemArray[6].ToString())
});
}
}
// -- root.MattersCourses.Changed = false;
root.MattersCourses.Loaded = true; // добавлено 29.06.2019
OperationResult = server.LastError;
if (!string.IsNullOrWhiteSpace(OperationResult))
{
return(root);
}
// семестры
dataSet = server.GetRows("Semesters");
if (dataSet.Tables.Count > 0)
{
foreach (var row in dataSet.Tables[0].Rows.Cast <DataRow>())
{
if (row.ItemArray.Length != 2)
{
continue;
}
root.Semesters.Add(new Semester
{
IdSemester = Guid.Parse(row.ItemArray[0].ToString().Substring(1)),
Number = int.Parse(row.ItemArray[1].ToString())
});
}
}
// -- root.Semesters.Changed = false;
root.Semesters.Loaded = true; // добавлено 29.06.2019
OperationResult = server.LastError;
if (!string.IsNullOrWhiteSpace(OperationResult))
{
return(root);
}
// учебные группы
dataSet = server.GetRows("StudyGroups");
if (dataSet.Tables.Count > 0)
{
foreach (var row in dataSet.Tables[0].Rows.Cast <DataRow>())
{
if (row.ItemArray.Length != 5)
{
continue;
}
root.StudyGroups.Add(new StudyGroup
{
IdStudyGroup = Guid.Parse(row.ItemArray[0].ToString().Substring(1)),
Number = row.ItemArray[1].ToString(),
TrainingPeriod = float.Parse(row.ItemArray[2].ToString()),
IdSpeciality = Guid.Parse(row.ItemArray[3].ToString().Substring(1)),
IdSpecialization = Guid.Parse(row.ItemArray[4].ToString().Substring(1))
});
}
}
// -- root.StudyGroups.Changed = false;
root.StudyGroups.Loaded = true; // добавлено 29.06.2019
OperationResult = server.LastError;
if (!string.IsNullOrWhiteSpace(OperationResult))
{
return(root);
}
// успеваемости
dataSet = server.GetRows("Performances");
if (dataSet.Tables.Count > 0)
{
foreach (var row in dataSet.Tables[0].Rows.Cast <DataRow>())
{
if (row.ItemArray.Length != 5)
{
continue;
}
root.Performances.Add(new Performance
{
IdPerformance = Guid.Parse(row.ItemArray[0].ToString().Substring(1)),
IdSemester = Guid.Parse(row.ItemArray[1].ToString().Substring(1)),
IdMatter = Guid.Parse(row.ItemArray[2].ToString().Substring(1)),
Grade = (Grade)Enum.Parse(typeof(Grade), row.ItemArray[3].ToString()),
IdStudent = Guid.Parse(row.ItemArray[4].ToString().Substring(1))
});
}
}
// -- root.Performances.Changed = false;
root.Performances.Loaded = true; // добавлено 29.06.2019
OperationResult = server.LastError;
if (!string.IsNullOrWhiteSpace(OperationResult))
{
return(root);
}
// студенты
dataSet = server.GetRows("Students");
if (dataSet.Tables.Count > 0)
{
foreach (var row in dataSet.Tables[0].Rows.Cast <DataRow>())
{
if (row.ItemArray.Length != 13)
{
continue;
}
var buff = (byte[])row.ItemArray[9];
root.Students.Add(new Student
{
IdStudent = Guid.Parse(row.ItemArray[0].ToString().Substring(1)),
FullName = row.ItemArray[1].ToString(),
BirthDay = DateTime.Parse(row.ItemArray[2].ToString()),
EducationCertificate = row.ItemArray[3].ToString(),
ReceiptDate = DateTime.Parse(row.ItemArray[4].ToString()),
Address = row.ItemArray[5].ToString(),
PhoneNumber = row.ItemArray[6].ToString(),
SocialStatus = row.ItemArray[7].ToString(),
Notes = row.ItemArray[8].ToString(),
Photo = buff,
IdSpeciality = Guid.Parse(row.ItemArray[10].ToString().Substring(1)),
IdSpecialization = Guid.Parse(row.ItemArray[11].ToString().Substring(1)),
IdStudyGroup = Guid.Parse(row.ItemArray[12].ToString().Substring(1))
});
}
}
// -- root.Students.Changed = false;
root.Students.Loaded = true; // добавлено 29.06.2019
OperationResult = server.LastError;
if (!string.IsNullOrWhiteSpace(OperationResult))
{
return(root);
}
// преподаватели
dataSet = server.GetRows("Teachers");
if (dataSet.Tables.Count > 0)
{
foreach (var row in dataSet.Tables[0].Rows.Cast <DataRow>())
{
if (row.ItemArray.Length != 5)
{
continue;
}
root.Teachers.Add(new Teacher
{
IdTeacher = Guid.Parse(row.ItemArray[0].ToString().Substring(1)),
FullName = row.ItemArray[1].ToString(),
IdMatter = Guid.Parse(row.ItemArray[2].ToString().Substring(1)),
Login = row.ItemArray[3].ToString(),
Password = row.ItemArray[4].ToString()
});
}
}
// -- root.Teachers.Changed = false;
root.Teachers.Loaded = true; // добавлено 29.06.2019
OperationResult = server.LastError;
if (!string.IsNullOrWhiteSpace(OperationResult))
{
return(root);
}
return(root);
}
