public ActionResult Create([Bind(Include = "Id,DeptCode,DeptName")] Department department)
{
if (ModelState.IsValid)
{
db.Departments.Add(department);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(department));
}
public ActionResult Create([Bind(Include = "TeacherId,Name,LastName")] Teacher teacher)
{
if (ModelState.IsValid)
{
db.Teachers.Add(teacher);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(teacher));
}
public ActionResult Create([Bind(Include = "HeadquartersId,Name,Address,Phone")] Headquarter headquarter)
{
if (ModelState.IsValid)
{
db.Headquarters.Add(headquarter);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(headquarter));
}
public ActionResult Create([Bind(Include = "FirstName,LastName,EnrollmentDate")] Student student)
{
if (!ModelState.IsValid)
{
return(View(student));
}
_universityDb.Students.Add(student);
_universityDb.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Create([Bind(Include = "Id,Name,Email,RegNo,DepartmentId")] Student student)
{
if (ModelState.IsValid)
{
db.Students.Add(student);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.DepartmentId = new SelectList(db.Departments, "Id", "DeptCode", student.DepartmentId);
return(View(student));
}
public ActionResult Create([Bind(Include = "SubjectID,TeacherId,Name,Schedule")] Subject subject)
{
if (ModelState.IsValid)
{
db.Subjects.Add(subject);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.TeacherId = new SelectList(db.Teachers, "TeacherId", "Name", subject.TeacherId);
return(View(subject));
}
public ActionResult Create([Bind(Include = "StudentID,Name,LastName,HeadquartersId")] Student student)
{
if (ModelState.IsValid)
{
db.Students.Add(student);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.HeadquartersId = new SelectList(db.Headquarters, "HeadquartersId", "Name", student.HeadquartersId);
return(View(student));
}
private static void UpdateExample2()
{
// For example, we got a student change request from UI
// User changed the student with ID = 1 and sent us the object
var studentFromGui = new Student()
{
FirstName = "User changed first name",
LastName = "User changed last name",
Id = 1
};
// We need to update student with ID = 1 with the new data
using (var db = new UniversityDb(ConnectionString))
{
// One way... not so practical (check update example 3 for better approach):
// We are using .First this time... maybe we want the exception
// if user was changing non existing student
var studentFromDb = db.Students.First(s => s.Id == studentFromGui.Id);
studentFromDb.FirstName = studentFromGui.FirstName;
studentFromDb.LastName = studentFromGui.LastName;
// ...
db.SaveChanges();
// What if we add a new property to student? we have to remember to update
// this method as well. And you will forget :)
}
}
public ActionResult NewSelection(StudentView studentView)
{
studentView = Session["selectionView"] as StudentView;
var student = db.Students.Find(studentView.Student.StudentID);
//foreach (var item in studentView.Subjects)
//{
// var subject = db.Subjects.Find(item.SubjectID);
// subject.Students.Add(student);
// db.SaveChanges();
//}
foreach (var item in studentView.Subjects)
{
var subject = db.Subjects.Find(item.SubjectID);
student.Subjects.Add(subject);
db.SaveChanges();
}
studentView.Student = new Student();
studentView.Subjects = new List <Subject>();
return(View(studentView));
}
static void Main(string[] args)
{
var dbContext = new UniversityDb();
Database.SetInitializer(new MigrateDatabaseToLatestVersion <UniversityDb, Configuration>());
dbContext.Database.CreateIfNotExists();
//Seed
var databases = new Course
{
Id = 1,
Name = "Databases",
Description = "malko e tegavo"
};
var iliyan = new Student
{
Name = "Iliyan",
Number = 111,
Courses = new HashSet <Course>()
{
databases
}
};
dbContext.Courses.Add(databases);
dbContext.Students.Add(iliyan);
dbContext.SaveChanges();
}
private static void DeleteExample1()
{
using (var db = new UniversityDb(ConnectionString))
{
var studentToRemove = db.Students.LastOrDefault();
if (studentToRemove != null)
{
db.Students.Remove(studentToRemove);
db.SaveChanges();
}
}
}
private static void UpdateExample1()
{
using (var db = new UniversityDb(ConnectionString))
{
// or shorter: .FirstOrDefault(s => s.Mentor != null)
var student = db.Students.Where(s => s.Mentor != null).FirstOrDefault();
if (student != null)
{
student.FirstName = "Hehe";
db.SaveChanges();
}
}
}
public ActionResult RetireSubject(int subjectID)
{
var studentView = Session["removalView"] as StudentView;
var subject = db.Subjects.Find(subjectID);
var student = db.Students.Find(studentView.Student.StudentID);
var subjectToRemove = studentView.Subjects.Find(s => s.SubjectID == subject.SubjectID);
studentView.Subjects.Remove(subjectToRemove);
student.Subjects.Remove(subject);
db.SaveChanges();
return(View("SubjectSelected", studentView));
}
private static void UpdateExample3()
{
var studentFromGui = new Student()
{
FirstName = "User changed first name again",
LastName = "User changed last name again",
Id = 1
};
using (var db = new UniversityDb(ConnectionString))
{
// Mark entry as modified. Context will start tracking it.
db.Entry(studentFromGui).State = EntityState.Modified;
// Let EF update everything...
db.SaveChanges();
}
}
private static void SaveExample2()
{
using (var db = new UniversityDb(ConnectionString))
{
try
{
var pero = new Student();
db.Students.Add(pero);
db.SaveChanges();
}
catch (DbEntityValidationException)
{
// Calling at this point will cause DbEntityValidationException
// We tried to save a student without first name and last name set
// (marked as required)
}
}
}
private static void SaveExample3()
{
using (var db = new UniversityDb(ConnectionString))
{
var ivica = new Professor()
{
LastName = "Boticki",
FirstName = "Ivica"
};
var lovro = new Student()
{
FirstName = "Lovro",
LastName = "Lovric",
Mentor = ivica
};
db.Students.Add(lovro);
db.SaveChanges();
}
}
private static void SaveExample1()
{
using (var db = new UniversityDb(ConnectionString))
{
var ivan = new Student()
{
FirstName = "Ivan",
LastName = "Horvat"
};
db.Students.Add(ivan);
// Save changes is a required step which actually
// pushes changes to the database.
//
// Usually you want to use SaveChangesAsync() variant
db.SaveChanges();
// Ivan.Id before SaveChanges() => 0
// Ivan.Id after SaveChanges() => 1...N
}
}
