// Add Software Used public ActionResult SoftwareUsedAdd(FormCollection software) { //retrieve the Id passed from the update page (Method = "GET") int syllabusIDFK = Convert.ToInt32(Request.QueryString["syllabusId"]); string softUsed = software["software"].ToString(); //connect to db Syllabus_ManagementEntities4 syllabus = new Syllabus_ManagementEntities4(); //retrieve specific table data based from the detail Id (firstName, lastName, etc.) Software_Used s = new Software_Used(); //assigning the table data through the input s.syllabus_FK = syllabusIDFK; s.software = softUsed.Replace(System.Environment.NewLine, "<br />"); try { //add data to db syllabus.Software_Used.Add(s); //save data to db syllabus.SaveChanges(); ViewBag.Result = "Saved"; } catch (Exception e) { ViewBag.Result = "Not Saved" + e.Message; } syllabus.SaveChanges(); return(RedirectToAction("SoftwareUsed", "SoftwareUsed")); }
public ActionResult Create([Bind(Include = "activeValues_ID,columnName,programOutcomeAbbr,activeStatus,courseOutcomes_FK")] Active_Values active_Values) { if (ModelState.IsValid) { db.Active_Values.Add(active_Values); db.SaveChanges(); return(RedirectToAction("ShowResults", active_Values)); } ViewBag.courseOutcomes_FK = new SelectList(db.Course_Outcomes, "courseOutcomes_ID", "codeName", active_Values.courseOutcomes_FK); return(View(active_Values)); }
public ActionResult UpdateNow(FormCollection fc) { string code = fc["code"].ToString(); string desc = fc["desc"].ToString(); string status = fc["status"].ToString(); int id2 = Convert.ToInt32(Request.QueryString["id"]); Syllabus_ManagementEntities4 f = new Syllabus_ManagementEntities4(); Core_Value cores = new Core_Value(); var stat = (from u in f.Core_Value where u.name == status select u.coreValue_ID).FirstOrDefault(); var d = f.Program_Educational_Objs.SingleOrDefault(b => b.programEduOutcome_ID == id2); d.objectives = code; d.codeName = code; d.coreValue_FK = stat; f.SaveChanges(); return(RedirectToAction("ProgramObj2", "Chairman")); }
public ActionResult AddDeli(FormCollection fc) { string code = fc["code"].ToString(); string desc = fc["desc"].ToString(); int co = 7; string ass1 = fc["ass1"].ToString(); string ass2 = fc["ass2"].ToString(); int syllabus = 1; Syllabus_ManagementEntities4 f = new Syllabus_ManagementEntities4(); Course_Deliverable d = new Course_Deliverable(); d.outputName = code; d.output_description = desc; d.courseOutcomeAddressed_FK = co; d.assessmentTypeA = ass1; d.assessmentTypeB = ass2; d.syllabus_FK = syllabus; try { f.Course_Deliverable.Add(d); f.SaveChanges(); ViewBag.Result = "Saved"; } catch (Exception e) { ViewBag.Result = e; } return(RedirectToAction("outputs_requirements", "Teacher")); //return View("../teacher/outputs_requirements"); }
public ActionResult SubmitUpdatedCriteria(FormCollection fc) { string criterianame = fc["criterianame"].ToString(); int poorpts = Convert.ToInt32(fc["poorpts"]); string poordesc = fc["poordesc"].ToString(); int fairpts = Convert.ToInt32(fc["fairpts"]); string fairdesc = fc["fairdesc"].ToString(); int epts = Convert.ToInt32(fc["epts"]); string edesc = fc["edesc"].ToString(); int spts = Convert.ToInt32(fc["spts"]); string sdesc = fc["sdesc"].ToString(); int webID = Convert.ToInt32(Request.QueryString["WebID"]); Syllabus_ManagementEntities4 sm = new Syllabus_ManagementEntities4(); var ac = sm.Assessment_Criteria.SingleOrDefault(b => b.assesmentCriteria_ID == webID); ac.criteriaName = criterianame; ac.poor_pts = poorpts; ac.poor_desc = poordesc.Replace(System.Environment.NewLine, "<br />"); ac.fair_pts = fairpts; ac.fair_desc = fairdesc.Replace(System.Environment.NewLine, "<br />"); ac.satisfactory_pts = spts; ac.satisfactory_desc = sdesc.Replace(System.Environment.NewLine, "<br />"); ac.excellent_pts = epts; ac.excellent_desc = edesc.Replace(System.Environment.NewLine, "<br />"); ac.highestPoints = epts; sm.SaveChanges(); return(RedirectToAction("AssessmentCriteria", "Teacher")); }
// Teacher and Coordinator Learning Plan //Note CO Addressed and Academic Term updated yet because no value public ActionResult LearningPlanUpdated(FormCollection fc) { Syllabus_ManagementEntities4 syllabus = new Syllabus_ManagementEntities4(); Learning_Plan p = new Learning_Plan(); //string topics = lp_info["topics"]; //int hrs = Convert.ToInt32(lp_info["noOfHrs"]); int learningPlanId = Convert.ToInt32(Request.QueryString["learn_id"]); string learning_outcome = fc["learningOutcome"]; int hours = Convert.ToInt32(fc["noOfHrs"]); string topics = fc["topics"]; string teacher_act = fc["teacherAct"]; string learner_act = fc["learnAct"]; string ass_act = fc["assessAct"]; var d = syllabus.Learning_Plan.SingleOrDefault(b => b.learning_ID == learningPlanId); d.learningOutcomeDesc = learning_outcome; d.hours = hours; d.topics = topics.Replace(System.Environment.NewLine, "<br />"); d.teacherActivity = teacher_act.Replace(System.Environment.NewLine, "<br />"); d.learnerActivity = learner_act.Replace(System.Environment.NewLine, "<br />"); d.assessmentActivity = ass_act.Replace(System.Environment.NewLine, "<br />"); try { syllabus.SaveChanges(); } catch (Exception e) { ViewBag.Result = e; } return(RedirectToAction("LearningPlan", "LearningPlan")); }
public ActionResult insert_grading(FormCollection fc) { string require_grading = fc["requirements"].ToString(); string type_grading = fc["type"].ToString(); double weight_grading = Convert.ToDouble(fc["weight"]); Syllabus_ManagementEntities4 fe = new Syllabus_ManagementEntities4(); Grading_System d = new Grading_System(); d.syllabus_FK = 1; d.typeOfGrading = type_grading; d.weight = weight_grading; d.requirementsName = require_grading; ; try { fe.Grading_System.Add(d); fe.SaveChanges(); ViewBag.Result = "Save Changes"; } catch (Exception e) { ViewBag.Result = "Error! " + e.Message; } return RedirectToAction("grading_system", "Teacher"); }
public ActionResult insert_revision(FormCollection getRevisionDetails) { string items = getRevisionDetails["revision_items"].ToString(); string revisedBy = getRevisionDetails["revision_revisedBy"].ToString(); string revisionDate = getRevisionDetails["revision_revisionDate"].ToString(); string approvedBy = getRevisionDetails["revision_approvedBy"].ToString(); string approvedDate = getRevisionDetails["revision_approvedDate"].ToString(); Syllabus_ManagementEntities4 fe = new Syllabus_ManagementEntities4(); Revision getTable = new Revision(); getTable.syllabus_FK = 1; getTable.versionNum = 1.0; getTable.fieldsRevised = items; getTable.dateRevised = revisionDate; getTable.approvedDate = approvedDate; getTable.revisedBy = revisedBy; getTable.approvedBy = approvedBy; try { fe.Revisions.Add(getTable); fe.SaveChanges(); ViewBag.Result = "Save Changes"; } catch (Exception) { ViewBag.Result = "Error! "; } return RedirectToAction("revision_history", "Teacher"); }
// Chair Update public ActionResult UpdatedCoreValue(FormCollection cv_info) { //retrieve the Id passed from the update page (Method = "GET") int cv_attrbId = Convert.ToInt32(Request.QueryString["CoreValueAttrbId"]); string cv_desc = cv_info["cvCoreAttrbU"].Replace(System.Environment.NewLine, "<br />"); string cv_CoreValueName = cv_info["cvCoreValueU"]; //connect to db Syllabus_ManagementEntities4 syllabus = new Syllabus_ManagementEntities4(); //retrieve specific table data based from the detail Id (firstName, lastName, etc.) //retrieve table details (firstName, lastName, etc.) //find the id base from the selected var coreValue_FKRet = (from u in syllabus.Core_Value where u.name == cv_CoreValueName select u.coreValue_ID).FirstOrDefault(); var cvaDetail = syllabus.Core_Value_Attribute.SingleOrDefault(b => b.coreValueAttrib_ID == cv_attrbId); //assigning the table data through the input cvaDetail.coreValue_FK = coreValue_FKRet; cvaDetail.description = cv_desc; syllabus.SaveChanges(); return(RedirectToAction("InstGradAttrb", "InstGradAttrb")); //ViewBag.Result = cv_desc; //return View(); }
// Chair Create public ActionResult AddCoreValue(FormCollection cv_info) { //retrieve data from URL because passed through form string cv_desc = Convert.ToString(Request.QueryString["cvAttrib"]).Replace(System.Environment.NewLine, "<br />"); string cv_CoreValueName = Convert.ToString(Request.QueryString["cvCoreValue"]); //connect to db Syllabus_ManagementEntities4 syllabus = new Syllabus_ManagementEntities4(); //retrieve table details (firstName, lastName, etc.) Core_Value_Attribute cv_a = new Core_Value_Attribute(); Core_Value cv = new Core_Value(); //find the id base from the selected var core_val = (from u in syllabus.Core_Value where u.name == cv_CoreValueName select u); //assigning the table data through the input using only the FIRST cv_a.coreValue_FK = core_val.First().coreValue_ID; cv_a.description = cv_desc; try { //add data to db syllabus.Core_Value_Attribute.Add(cv_a); //save data to db syllabus.SaveChanges(); } catch (Exception) { } return(RedirectToAction("InstGradAttrb", "InstGradAttrb")); }
// Teacher and Coordinator Learning Plan public ActionResult LearningPlanAddData(FormCollection lp_info) { //connect to db Syllabus_ManagementEntities4 syllabus = new Syllabus_ManagementEntities4(); int syllabusIdFK = Convert.ToInt32(Request.QueryString["syllabusIdFK"]); int courseIdFK = Convert.ToInt32(Request.QueryString["courseIdFK"]); string quarter = lp_info["academicTerm"]; //static as of the moment int co_IdFk = Convert.ToInt32("1"); int quarterValue_FKRet = (from u in syllabus.Quarters where u.quarter_name == quarter select u.quarter_ID).FirstOrDefault(); string lOutcome = lp_info["learningOutcome"]; int hrs = Convert.ToInt32(lp_info["noOfHrs"]); string topics = lp_info["topics"]; string teachAct = lp_info["teacherAct"]; string learnAct = lp_info["learnAct"]; string assessAct = lp_info["assessAct"]; if (assessAct == " ") { assessAct = null; } Learning_Plan lp = new Learning_Plan(); //assigning the table data through the input lp.courseOutcome_FK = co_IdFk; lp.course_id_fk = courseIdFK; lp.quarter_FK = quarterValue_FKRet; lp.syllabus_FK = syllabusIdFK; lp.learningOutcomeDesc = lOutcome.Replace(System.Environment.NewLine, "<br />"); lp.hours = hrs; lp.topics = topics.Replace(System.Environment.NewLine, "<br />"); lp.teacherActivity = teachAct.Replace(System.Environment.NewLine, "<br />"); lp.learnerActivity = learnAct.Replace(System.Environment.NewLine, "<br />"); lp.assessmentActivity = assessAct.Replace(System.Environment.NewLine, "<br />"); try { //add data to db syllabus.Learning_Plan.Add(lp); //save data to db syllabus.SaveChanges(); ViewBag.Result = "Saved"; } catch (Exception e) { ViewBag.Result = "Not Saved" + e.Message; } return(RedirectToAction("LearningPlan", "LearningPlan")); }
public ActionResult Create([Bind(Include = "courseOutcomes_ID,syllabus_FK,codeName,outcomeDescription,domainLearningLVL")] Course_Outcomes course_Outcomes) { if (ModelState.IsValid) { db.Course_Outcomes.Add(course_Outcomes); db.SaveChanges(); db.Entry(course_Outcomes).GetDatabaseValues(); int newID = course_Outcomes.courseOutcomes_ID; int numOfPO = db.Program_Outcomes.Select(d => d.code_outcome).Distinct().Count(); int syllabusID = course_Outcomes.syllabus_FK; PopulateModels(numOfPO, newID); return(RedirectToAction("ShowResults", "Active_Values", new { id = syllabusID })); } ViewBag.syllabus_FK = new SelectList(db.Syllabus, "syllabus_ID", "title", course_Outcomes.syllabus_FK); return(View(course_Outcomes)); }
public ActionResult Create([Bind(Include = "madeBy_FK, course_FK, title, academicYear, academicPeriod, status")]Syllabu newSyllabus) { if (ModelState.IsValid) { sm.Syllabus.Add(newSyllabus); sm.SaveChanges(); return RedirectToAction("Creation"); } return View("Creation"); }
// Add/Edit Software Used public ActionResult SoftwareUsedDelete() { Syllabus_ManagementEntities4 syllabus = new Syllabus_ManagementEntities4(); int softUID = Convert.ToInt32(Request.QueryString["softUID"]); var delData = (from u in syllabus.Software_Used where u.softwareUsed_ID == softUID select u).FirstOrDefault(); syllabus.Software_Used.Remove(delData); syllabus.SaveChanges(); return(RedirectToAction("SoftwareUsed", "SoftwareUsed")); }
public ActionResult EditPolicy(FormCollection fc) { int policyID = Convert.ToInt32(fc["policyID_uneditable"]); string edited = fc["policyName"].ToString(); Syllabus_ManagementEntities4 sm = new Syllabus_ManagementEntities4(); var policy = sm.Class_Policy.SingleOrDefault(b => b.policy_ID == policyID); policy.policyItem = edited; var res = sm.SaveChanges(); return(RedirectToAction("EditClassroomPolicies", "Syllabus")); }
// Chair Delete public ActionResult DeleteCoreValue(FormCollection cv_info) { //connect to db Syllabus_ManagementEntities4 syllabus = new Syllabus_ManagementEntities4(); int cv_attr_id = Convert.ToInt32(Request.QueryString["coreValAttrIdD"]); var delData = (from u in syllabus.Core_Value_Attribute where u.coreValueAttrib_ID == cv_attr_id select u).FirstOrDefault(); syllabus.Core_Value_Attribute.Remove(delData); syllabus.SaveChanges(); return(RedirectToAction("InstGradAttrb", "InstGradAttrb")); }
public ActionResult DeleteBook() { int bookID = Convert.ToInt32(Request.QueryString["BookID"]); Syllabus_ManagementEntities4 sm = new Syllabus_ManagementEntities4(); var c = (from p in sm.Books where p.book_id == bookID select p).FirstOrDefault(); sm.Books.Remove(c); sm.SaveChanges(); return(RedirectToAction("Bibliography", "Teacher")); }
public ActionResult DeleteOnlineResource() { int webID = Convert.ToInt32(Request.QueryString["WebID"]); Syllabus_ManagementEntities4 sm = new Syllabus_ManagementEntities4(); var webrow = (from p in sm.Online_Sources where p.onlineSource_ID == webID select p).FirstOrDefault(); sm.Online_Sources.Remove(webrow); sm.SaveChanges(); return(RedirectToAction("Bibliography", "Teacher")); }
public ActionResult AddNewPolicyToDB(FormCollection fc) { //int syllabusID = Convert.ToInt32(Request.QueryString["SyllabusID"]); int syllabusID = 1; string policy = fc["PolicyString"].ToString(); Class_Policy cp = new Class_Policy(); cp.policyItem = policy; cp.syllabus_FK = syllabusID; try { sm.Class_Policy.Add(cp); sm.SaveChanges(); ViewBag.Result = "Saved"; } catch { ViewBag.Result = "Not saved"; } return(RedirectToAction("ClassroomPolicy", "Teacher")); }
public ActionResult DeletePolicy(FormCollection fc) { Syllabus_ManagementEntities4 sm = new Syllabus_ManagementEntities4(); int policyID = Convert.ToInt32(Request.QueryString["PolicyID"]); var c = (from p in sm.Class_Policy where p.policy_ID == policyID select p).FirstOrDefault(); sm.Class_Policy.Remove(c); sm.SaveChanges(); return(RedirectToAction("EditClassroomPolicies", "Syllabus")); }
public ActionResult DeleteCriteria() { int webID = Convert.ToInt32(Request.QueryString["WebID"]); Syllabus_ManagementEntities4 sm = new Syllabus_ManagementEntities4(); var ac = (from p in sm.Assessment_Criteria where p.assesmentCriteria_ID == webID select p).FirstOrDefault(); sm.Assessment_Criteria.Remove(ac); sm.SaveChanges(); return(RedirectToAction("AssessmentCriteria", "Teacher")); }
// Teacher and Coordinator Learning Plan public ActionResult LearningPlanDelete() { int learningPlanId = Convert.ToInt32(Request.QueryString["lpId"]); //connect to db Syllabus_ManagementEntities4 syllabus = new Syllabus_ManagementEntities4(); var delData = (from u in syllabus.Learning_Plan where u.learning_ID == learningPlanId select u).FirstOrDefault(); syllabus.Learning_Plan.Remove(delData); syllabus.SaveChanges(); return(RedirectToAction("LearningPlan", "LearningPlan")); }
public ActionResult DeleteThings() { Syllabus_ManagementEntities4 f = new Syllabus_ManagementEntities4(); Program_Educational_Objs d = new Program_Educational_Objs(); int ids = Convert.ToInt32(Request.QueryString["ids"]); var c = (from p in f.Program_Educational_Objs where p.programEduOutcome_ID == ids select p).FirstOrDefault(); f.Program_Educational_Objs.Remove(c); f.SaveChanges(); return(RedirectToAction("ProgramObj2", "Chairman")); }
// Update to DB Software Used public ActionResult SoftwareUsedUpdated(FormCollection software) { //retrieve the Id passed from the update page (Method = "GET") int softUID = Convert.ToInt32(Request.QueryString["softUid"]); string syllabusDesc = software["software"]; //connect to db Syllabus_ManagementEntities4 syllabus = new Syllabus_ManagementEntities4(); //retrieve specific table data based from the detail Id (firstName, lastName, etc.) var softwareDetail = syllabus.Software_Used.SingleOrDefault(b => b.softwareUsed_ID == softUID); //assigning the table data through the input softwareDetail.software = syllabusDesc.Replace(System.Environment.NewLine, "<br />"); syllabus.SaveChanges(); return(RedirectToAction("SoftwareUsed", "SoftwareUsed")); }
//------- ASSESSMENT CRITERIA ------- // public ActionResult AddNewCriteria(FormCollection fc) { string criterianame = fc["n_criterianame"].ToString(); string poordesc = fc["n_poordesc"].ToString(); string fairdesc = fc["n_fairdesc"].ToString(); string edesc = fc["n_edesc"].ToString(); string sdesc = fc["n_sdesc"].ToString(); int poorpts = Convert.ToInt32(fc["n_poorpts"]); int fairpts = Convert.ToInt32(fc["n_fairpts"]); int epts = Convert.ToInt32(fc["n_epts"]); int spts = Convert.ToInt32(fc["n_spts"]); Syllabus_ManagementEntities4 sm = new Syllabus_ManagementEntities4(); Assessment_Criteria ac = new Assessment_Criteria(); ac.syllabus_FK = 1; // static ac.criteriaName = criterianame; ac.poor_pts = poorpts; ac.poor_desc = poordesc.Replace(System.Environment.NewLine, "<br />"); ac.fair_pts = fairpts; ac.fair_desc = fairdesc.Replace(System.Environment.NewLine, "<br />"); ac.satisfactory_pts = spts; ac.satisfactory_desc = sdesc.Replace(System.Environment.NewLine, "<br />"); ac.excellent_pts = epts; ac.excellent_desc = edesc.Replace(System.Environment.NewLine, "<br />"); ac.highestPoints = epts; try { sm.Assessment_Criteria.Add(ac); sm.SaveChanges(); ViewBag.Result = "Saved"; } catch (Exception e) { ViewBag.Result = e; } return(RedirectToAction("AssessmentCriteria", "Teacher")); /*return View()*/ ; }
public ActionResult DeleteDeliverablesAndRequirements() { Syllabus_ManagementEntities4 sm = new Syllabus_ManagementEntities4(); Course_Deliverable d = new Course_Deliverable(); int id = Convert.ToInt32(Request.QueryString["DRID"]); var c = (from u in sm.Course_Deliverable where u.courseDeliverables_ID == id select u).FirstOrDefault(); try { sm.Course_Deliverable.Remove(c); sm.SaveChanges(); } catch (Exception e) { ViewBag.Result = e; } return(RedirectToAction("outputs_requirements", "Teacher")); }
public ActionResult ProgramEduObj(FormCollection fc) { string code = fc["code"].ToString(); string desc = fc["desc"].ToString(); string status = fc["status"].ToString(); int sylid = 1; Syllabus_ManagementEntities4 f = new Syllabus_ManagementEntities4(); Program_Educational_Objs d = new Program_Educational_Objs(); var coreid = (from u in f.Core_Value where u.name == status select u.coreValue_ID).FirstOrDefault(); ViewBag.code = code; ViewBag.desc = desc; ViewBag.status = status; ViewBag.coreid = coreid; d.objectives = desc; d.codeName = code; d.syllabus_FK = sylid; d.coreValue_FK = Convert.ToInt32(coreid); try { f.Program_Educational_Objs.Add(d); f.SaveChanges(); ViewBag.Result = "Saved"; } catch (Exception e) { ViewBag.Result = e; } return(RedirectToAction("ProgramObj2", "Chairman")); }
public ActionResult UpdateNow2(FormCollection fc) { int id = Convert.ToInt32(Request.QueryString["id"]); string name = fc["name"].ToString(); string desc = fc["desc"].ToString(); string ass1 = fc["ass1"].ToString(); string ass2 = fc["ass2"].ToString(); Syllabus_ManagementEntities4 sm = new Syllabus_ManagementEntities4(); Course_Deliverable d = new Course_Deliverable(); var c = (from u in sm.Course_Deliverable where u.courseDeliverables_ID == id select u).FirstOrDefault(); c.outputName = name; c.output_description = desc; c.assessmentTypeA = ass1; c.assessmentTypeB = ass2; sm.SaveChanges(); return(RedirectToAction("outputs_requirements", "Teacher")); }
// --------------- BOOKS ---------------- // public ActionResult UpdateBooks(FormCollection fc) { //int courseID = Convert.ToInt32(Request.QueryString["CourseID"]); string bID = fc["BookID"].ToString(); if (bID == "") { ViewBag.res = "add"; string cnum = fc["CallNumber"].ToString(); string title = fc["Title"].ToString(); string author = fc["Author"].ToString(); int year = Convert.ToInt32(fc["Year"].ToString()); Syllabus_ManagementEntities4 sm = new Syllabus_ManagementEntities4(); Book b = new Book(); b.course_fk = 1; b.callNumber = cnum; b.title = title; b.author = author; b.year = year; try { sm.Books.Add(b); sm.SaveChanges(); //Book fb = new Book(); //var d = sm.Books.SingleOrDefault(newBook => fb.title == title); //ViewBag.bID = d.book_id; //Source s = new Source(); //s.type_of_resource = "book"; //s.resource_fk = d.book_id; //sm.Sources.Add(s); ViewBag.Result = "Saved"; } catch (Exception e) { ViewBag.Result = e; } } else { Syllabus_ManagementEntities4 sm = new Syllabus_ManagementEntities4(); ViewBag.res = "update"; int bookID = Convert.ToInt32(bID); var book = sm.Books.SingleOrDefault(b => b.book_id == bookID); string cnum = fc["CallNumber"].ToString(); string title = fc["Title"].ToString(); string author = fc["Author"].ToString(); int year = Convert.ToInt32(fc["Year"].ToString()); book.callNumber = cnum; book.title = title; book.author = author; book.year = year; book.course_fk = 1; sm.SaveChanges(); } return(RedirectToAction("Bibliography", "Teacher")); //return View(); }