public void EditDiscipline(int disciplineId, string name, int?lectorId)
{
var disc = _db.Disciplines.FirstOrDefault(t => t.Id == disciplineId);
if (lectorId != null)
{
if (_db.LectorDisciplines.Any(t => t.DisciplineId == disciplineId))
{
var connect = _db.LectorDisciplines.FirstOrDefault(t => t.DisciplineId == disciplineId);
if (connect != null)
{
connect.LectorId = Convert.ToInt32(lectorId);
}
_db.SaveChanges();
}
else
{
var lecturesTable = _db.Set <LectorDiscipline>();
lecturesTable.Add(new LectorDiscipline()
{
LectorId = Convert.ToInt32(lectorId), DisciplineId = disciplineId
});
}
}
if (disc != null)
{
disc.Name = name;
}
_db.SaveChanges();
}
public void AddNewDiscipline(string name, int?lectorId)
{
var disciplinesTable = _db.Set <Discipline>();
disciplinesTable.Add(new Discipline()
{
Name = name
});
_db.SaveChanges();
var disciplineId = _db.Disciplines.FirstOrDefault(t => t.Name == name).Id;
var lecturesTable = _db.Set <LectorDiscipline>();
lecturesTable.Add(new LectorDiscipline()
{
LectorId = Convert.ToInt32(lectorId), DisciplineId = disciplineId
});
_db.SaveChanges();
}
