public ActionResult Create(Class newClass, FormCollection collection)
{
//error message for section id uniqueness
ViewData["IDerror"] = "";
try
{
newClass.semster_id = collection["sem_list"];
newClass.course_id = collection["course_list"];
newClass.sect_id = int.Parse(collection["Classes.sect_id"]?? "0");
newClass.room_id = collection["Classes.room_id"];
newClass.inst_id = collection["inst_list"];
newClass.capacity = int.Parse(collection["Classes.capacity"]);
newClass.waitlist_capacity = int.Parse(collection["Classes.waitlist_capacity"]);
newClass.days = (collection["days_chk"] ?? "0").Split(',').Sum(x => Int32.Parse(x));
newClass.timeslot_id = int.Parse(collection["time_list"]);
newClass.has_children = false;
newClass.parent_class_id = null;
if (db.Classes.Any(c => c.sect_id == newClass.sect_id && c.semster_id == newClass.semster_id && c.course_id == newClass.course_id))
{
ViewData["IDerror"] = "Section IDs must be unique for each course ID and semester.";
throw new Exception();
}
//add new class to database and save changes
db.AddToClasses(newClass);
db.SaveChanges();
//return to Index
return RedirectToAction("Index");
}
catch (Exception ex)
{
var cur = db.Semesters.Single(s => s.semester_id == db.Current_Semester.FirstOrDefault().semester_id);
var viewModel = new ClassManagerCreateViewModel
{
Semesters = db.Semesters.Where(c => c.start_date.CompareTo(cur.start_date) >= 0).ToList(),
Classes = new Class(),
Times = db.Timeslots.ToList(),
Courses = db.Courses.ToList(),
Depts = db.Departments.ToList(),
Users = db.Users.Where(u => u.Role_Type.Any(r => r.role_name == "Instructor")).OrderBy(u => u.last_name).ToList()
};
return View(viewModel);
}
}
public void AddToCart(Class class_add)
{
var cart_item = db.Carts.SingleOrDefault(c => c.user_id == shopping_cart_id && c.class_id == class_add.class_id && c.semester_id == class_add.semster_id);
if (cart_item == null) {
cart_item = new Cart
{
class_id = class_add.class_id,
semester_id = class_add.semster_id,
user_id = shopping_cart_id
};
db.AddToCarts(cart_item);
}
db.SaveChanges();
}
/// <summary>
/// Create a new Class object.
/// </summary>
/// <param name="class_id">Initial value of the class_id property.</param>
/// <param name="semster_id">Initial value of the semster_id property.</param>
/// <param name="course_id">Initial value of the course_id property.</param>
/// <param name="sect_id">Initial value of the sect_id property.</param>
/// <param name="inst_id">Initial value of the inst_id property.</param>
/// <param name="capacity">Initial value of the capacity property.</param>
/// <param name="waitlist_capacity">Initial value of the waitlist_capacity property.</param>
/// <param name="has_children">Initial value of the has_children property.</param>
public static Class CreateClass(global::System.Int32 class_id, global::System.String semster_id, global::System.String course_id, global::System.Int32 sect_id, global::System.String inst_id, global::System.Int32 capacity, global::System.Int32 waitlist_capacity, global::System.Boolean has_children)
{
Class @class = new Class();
@class.class_id = class_id;
@class.semster_id = semster_id;
@class.course_id = course_id;
@class.sect_id = sect_id;
@class.inst_id = inst_id;
@class.capacity = capacity;
@class.waitlist_capacity = waitlist_capacity;
@class.has_children = has_children;
return @class;
}
/// <summary>
/// Deprecated Method for adding a new object to the Classes EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead.
/// </summary>
public void AddToClasses(Class @class)
{
base.AddObject("Classes", @class);
}