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