public Semester InsertSemesterDiscipline(SemesterDiscipline _semesterDiscipline)
{
using (Bit8Entities entities = new Bit8Entities())
{
entities.SemesterDisciplines.Add(_semesterDiscipline);
entities.SaveChanges();
}
return(new Semester());
}
public Discipline InsertDiscipline(Discipline _discipline)
{
using (Bit8Entities entities = new Bit8Entities())
{
entities.Disciplines.Add(_discipline);
entities.SaveChanges();
}
return(_discipline);
}
public Semester InsertSemester(Semester _semester)
{
using (Bit8Entities entities = new Bit8Entities())
{
entities.Semesters.Add(_semester);
entities.SaveChanges();
}
return(_semester);
}
public void DeleteDiscipline(Discipline _discipline)
{
using (Bit8Entities entities = new Bit8Entities())
{
Discipline discipline = (from c in entities.Disciplines
where c.ID == _discipline.ID
select c).FirstOrDefault();
entities.Disciplines.Remove(_discipline);
entities.SaveChanges();
}
}
public void DeleteSemester(Semester _semester)
{
using (Bit8Entities entities = new Bit8Entities())
{
Semester semester = (from c in entities.Semesters
where c.Id == _semester.Id
select c).FirstOrDefault();
entities.Semesters.Remove(semester);
entities.SaveChanges();
}
}
// GET: Semester
public ActionResult Index()
{
Bit8Entities entities = new Bit8Entities();
List <Semester> semesters = entities.Semesters.ToList();
if (semesters.Count == 0)
{
semesters.Add(new Semester());
}
return(View(semesters));
}
public ActionResult Index()
{
Bit8Entities entities = new Bit8Entities();
List <Discipline> discipline = entities.Disciplines.ToList();
if (discipline.Count == 0)
{
discipline.Add(new Discipline());
}
return(View(discipline));
}
public Semester DeleteSemesterDiscipline(SemesterDiscipline _semesterDiscipline)
{
using (Bit8Entities entities = new Bit8Entities())
{
SemesterDiscipline semesterDiscipline = (from c in entities.SemesterDisciplines
where c.SemesterID == _semesterDiscipline.SemesterID &&
c.DisciplineID == _semesterDiscipline.DisciplineID
select c).FirstOrDefault();
entities.SemesterDisciplines.Remove(semesterDiscipline);
entities.SaveChanges();
}
return(new Semester());
}
public bool UpdateDiscipliner(Discipline _discipline)
{
using (Bit8Entities entities = new Bit8Entities())
{
Discipline updatedDiscipline = (from c in entities.Disciplines
where c.ID == _discipline.ID
select c).FirstOrDefault();
updatedDiscipline.DisciplineName = _discipline.DisciplineName;
updatedDiscipline.ProfesorName = _discipline.ProfesorName;
entities.SaveChanges();
}
return(true);
}
public bool UpdateSemester(Semester _semester)
{
using (Bit8Entities entities = new Bit8Entities())
{
Semester updatedSemester = (from c in entities.Semesters
where c.Id == _semester.Id
select c).FirstOrDefault();
updatedSemester.Name = _semester.Name;
updatedSemester.StartDate = _semester.StartDate;
updatedSemester.EndDate = _semester.EndDate;
entities.SaveChanges();
}
return(true);
}