public async Task <JsonResult> ToggleCourseCompletion(string coursenumber, string uid) { if (db.Courses.Where(c => c.CourseNumber == coursenumber).Count() > 0) { var qRes = db.CourseTaken.Where(ct => (ct.userId == uid && ct.CourseNumber == coursenumber)); if (qRes.Count() > 0) { db.CourseTaken.RemoveRange(qRes.ToList()); db.SaveChanges(); } else { var ct = new CourseTaken { CourseNumber = coursenumber, userId = uid }; db.CourseTaken.Add(ct); await db.SaveChangesAsync(); } } return(new JsonResult { Data = new { success = true }, JsonRequestBehavior = JsonRequestBehavior.AllowGet }); }
public ActionResult DeleteConfirmed(int id) { CourseTaken courseTaken = db.CourseTakens.Find(id); db.CourseTakens.Remove(courseTaken); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "CourseTakenId,StudentId,SectionId")] CourseTaken courseTaken) { if (ModelState.IsValid) { db.Entry(courseTaken).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.SectionId = new SelectList(db.Sections, "SectionId", "Name", courseTaken.SectionId); ViewBag.StudentId = new SelectList(db.Students, "StudentId", "StudentNumber", courseTaken.StudentId); return(View(courseTaken)); }
protected void gvCoursesList_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e) { // 원래는 selectedIndexChanged 이벤트에서 하는 거였는데 안되서 바꿈 gvCoursesList.EditIndex = -1; gvCoursesList.SelectedIndex = e.RowIndex; var courseTaken = new CourseTaken(); courseTaken.CourseId = int.Parse(gvCoursesList.SelectedRow.Cells[1].Text); courseTaken.CourseName = gvCoursesList.SelectedRow.Cells[2].Text; courseTaken.CoursePrice = double.Parse(gvCoursesList.SelectedRow.Cells[3].Text); (Session["client"] as CoursesOnlineClient)?.AddToCoursesTaken(courseTaken); }
// GET: CourseTaken/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } CourseTaken courseTaken = db.CourseTakens.Find(id); if (courseTaken == null) { return(HttpNotFound()); } return(View(courseTaken)); }
// GET: CourseTaken/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } CourseTaken courseTaken = db.CourseTakens.Find(id); if (courseTaken == null) { return(HttpNotFound()); } ViewBag.SectionId = new SelectList(db.Sections, "SectionId", "Name", courseTaken.SectionId); ViewBag.StudentId = new SelectList(db.Students, "StudentId", "StudentNumber", courseTaken.StudentId); return(View(courseTaken)); }
public static void AddStudentCourse(Student student) { Console.Write("Enter Course Code : "); var courseCode = Console.ReadLine(); Console.Write("Enter Course Unit : "); var courseUnit = Console.ReadLine(); Console.Write("Enter Student Score : "); var courseScore = Console.ReadLine(); var courseValidation = false; if (Validate.ConfirmScoreRange(courseScore) && Validate.ConfirmUnit(courseUnit)) { courseValidation = true; } while (!courseValidation) { Console.WriteLine("Invalid Course Detail"); Console.Write("Enter Course Code : "); courseCode = Console.ReadLine(); Console.Write("Enter Course Unit : "); courseUnit = Console.ReadLine(); Console.Write("Enter Student Score : "); courseScore = Console.ReadLine(); if (Validate.ConfirmScoreRange(courseScore) && Validate.ConfirmUnit(courseUnit)) { courseValidation = true; } } var studentCourse = new CourseTaken( courseCode, Validate.ConvertStringToNumber(courseUnit), Validate.ConvertStringToNumber(courseScore) ); student.Courses.Add(studentCourse); }
public List <CourseTaken> viewgrades() { List <CourseTaken> list = new List <CourseTaken>(); searchbyid fm1 = new searchbyid(); if (fm1.ShowDialog() == DialogResult.OK) { List <DbParameter> newlist = new List <DbParameter>(); DataTable dt = null; string sql = "select CourseNum, Grade from CoursesTaken where StudentId ='" + fm1.StudentId + "'"; dt = idac.GetManyRowsCols(sql, newlist); List <double> glist = new List <double>(); double sum; foreach (DataRow drow in dt.Rows) { string g = drow["Grade"].ToString(); if (g == "A") { sum = 4.0; } else if (g == "A-") { sum = 3.8; } else if (g == "B+") { sum = 3.6; } else if (g == "B") { sum = 3.5; } else if (g == "B-") { sum = 3.4; } else if (g == "C+") { sum = 3.2; } else if (g == "C") { sum = 3.1; } else if (g == "C-") { sum = 3.0; } else if (g == "D") { sum = 2.5; } else { sum = 0; } glist.Add(sum); } double avg = glist.Average(); foreach (DataRow drow in dt.Rows) { CourseTaken ct = new CourseTaken(); ct.CourseNum = drow["CourseNum"].ToString(); ct.Grade = drow["Grade"].ToString(); ct.gpa = avg; list.Add(ct); } } return(list); }