public ActionResult Create([Bind(Include = "EnrollmentID,Grade,CourseID,StudentID")] Enrollment enrollment)
{
if (ModelState.IsValid)
{
var list = db.Enrollment.Where(x => x.StudentID == enrollment.StudentID &&
x.CourseID == enrollment.CourseID &&
x.Grade == enrollment.Grade).ToList();
if (list.Count > 0)
{
ModelState.AddModelError("message", "Ya está matrículado en el curso");
return(RedirectToAction("Create"));
}
else
{
db.Enrollment.Add(enrollment);
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
ViewBag.CourseID = new SelectList(db.Course, "CourseID", "Title", enrollment.CourseID);
ViewBag.StudentID = new SelectList(db.Student, "StudentID", "LastName", enrollment.StudentID);
return(View(enrollment));
}
//To save data in student table//
public bool Save(Student student)
{
student.CurrentYear = Convert.ToString(DateTime.Parse(student.regDate.ToString()).Year);
dbContext.Students.Add(student);
int rowaffected = dbContext.SaveChanges();
return(rowaffected > 0);
}
//To assign course in Course assign table//
public bool Save(CourseAssign courseAssign)
{
courseAssign.Assign = true;
dbContext.CourseAssigns.Add(courseAssign);
int rowaffected = dbContext.SaveChanges();
return(rowaffected > 0);
}
public ActionResult Create([Bind(Include = "StudentID,LastName,FirstName,Email,EnrollmentDate,DNI")] Student student)
{
if (ModelState.IsValid)
{
db.Student.Add(student);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(student));
}
public ActionResult Create([Bind(Include = "CourseID,Title,Credits")] Course course)
{
if (ModelState.IsValid)
{
db.Course.Add(course);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(course));
}
public ActionResult Create([Bind(Include = "EnrollmentID,CourseID,StudentID")] Enrollment enrollment)
{
if (ModelState.IsValid)
{
db.Enrollment.Add(enrollment);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.CourseID = new SelectList(db.Course, "CourseID", "Title", enrollment.CourseID);
ViewBag.StudentID = new SelectList(db.Student, "StudentID", "LastName", enrollment.StudentID);
return(View(enrollment));
}
public ActionResult Create([Bind(Include = "StudentID,LastName,FirstName,Email,EnrollmentDate,Birthday")] Student student)
{
if (ModelState.IsValid)
{
DateTime today = DateTime.Today;
db.Student.Add(student);
student.EnrollmentDate = today;
student.Enabled = true;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(student));
}
//To save data in course table//
public bool Save(Course course)
{
dbContext.Courses.Add(course);
int rowaffeced = dbContext.SaveChanges();
return(rowaffeced > 0);
}
// To save data in Department table//
public bool Save(Department department)
{
dbContext.Departments.Add(department);
int rowaffected = dbContext.SaveChanges();
return(rowaffected > 0);
}
//To save data in Teacher table//
public bool Save(Teacher teacher)
{
dbContext.Teachers.Add(teacher);
int rowaffected = dbContext.SaveChanges();
return(rowaffected > 0);
}
public bool Commit()
{
transaction = db.Database.BeginTransaction();
int affected = db.SaveChanges();
transaction.Commit();
return(affected > 0);
}
//To save data in AllocateRoom table//
public bool AllocateRoom(RoomAlloted allotedroom)
{
AllotedRoom alloted = new AllotedRoom();
alloted.Assign = true;
alloted.depCode = allotedroom.depCode;
alloted.CourseID = allotedroom.CourseID;
alloted.dayID = allotedroom.dayID;
alloted.roomID = allotedroom.roomID;
alloted.fromTime = allotedroom.FormTime();
alloted.toTime = allotedroom.EndTime();
dbContext.AllotedRooms.Add(alloted);
int rowaffected = dbContext.SaveChanges();
return(rowaffected > 0);
}
public bool Save(Enrollment enrollment)
{
using (UniversityDBEntities db = new UniversityDBEntities())
{
db.Enrollments.AddOrUpdate(enrollment);
db.SaveChanges();
return(true);
}
}
public bool Save(Student student)
{
using (UniversityDBEntities db = new UniversityDBEntities())
{
db.Students.AddOrUpdate(student);
db.SaveChanges();
return(true);
}
}
public bool Delete(Enrollment enrollment)
{
using (UniversityDBEntities db = new UniversityDBEntities())
{
db.Entry(enrollment).State = EntityState.Deleted;
db.SaveChanges();
return(true);
}
}
public bool Update(Department department)
{
using (UniversityDBEntities db = new UniversityDBEntities())
{
db.Departments.AddOrUpdate(department);
db.SaveChanges();
return(true);
}
}
public bool Save(Course course)
{
using (var db = new UniversityDBEntities())
{
db.Courses.AddOrUpdate(course);
db.SaveChanges();
return(true);
}
}
public bool Delete(Course course)
{
using (var db = new UniversityDBEntities())
{
db.Entry(course).State = EntityState.Deleted;
db.SaveChanges();
return(true);
}
}
public bool Delete(Department department)
{
using (UniversityDBEntities db = new UniversityDBEntities())
{
//db.Departments.Remove(department);
db.Entry(department).State = EntityState.Deleted;
db.SaveChanges();
return(true);
}
}
// to save result in student result table//
public bool SaveResult(StudentResultEnrolled StudentResult)
{
Result result = new Result();
result.StudentID = StudentResult.StudentID;
result.gradeID = StudentResult.gradeID;
result.CourseID = StudentResult.CourseID;
dbContext.Results.Add(result);
int rowaffected = dbContext.SaveChanges();
return(rowaffected > 0);
}
