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);
}
