public bool EnrollUser(Student_Progress sp) { try { List <User_Details> u = db.User_Details.ToList(); foreach (var x in u) { if (x.UserName == sp.UserName) { sp.UserID = x.UserID; break; } } sp.Certi_status = "Not Generated"; sp.Prog_status = 0; sp.Test_scores = 0; db.Student_Progress.Add(sp); db.SaveChanges(); return(true); } catch (Exception e) { Console.WriteLine(e); } return(false); }
public bool EditProgress(Student_Progress u) { try { List <Student_Progress> cou = db.Student_Progress.ToList(); foreach (var i in cou) { if (u.UserID == i.UserID && u.CourseID == i.CourseID && u.UserName == i.UserName) { i.Prog_status = u.Prog_status; if (!(i.Prog_status >= 0 && i.Prog_status <= 100)) { return(false); } db.SaveChanges(); return(true); } } } catch (Exception e) { Console.WriteLine(e); } return(false); }
public bool EditTest(Student_Progress u) { try { List <Student_Progress> cou = db.Student_Progress.ToList(); foreach (var i in cou) { if (u.UserID == i.UserID && u.CourseID == i.CourseID && u.UserName == i.UserName) { i.Test_scores = 100; db.SaveChanges(); return(true); } } } catch (Exception e) { Console.WriteLine(e); } return(false); }
public bool EditCertificate(Student_Progress u) { try { List <Student_Progress> cou = db.Student_Progress.ToList(); foreach (var i in cou) { if (u.UserID == i.UserID && u.CourseID == i.CourseID && u.UserName == i.UserName) { if (i.Test_scores == 100 && i.Prog_status >= 85) { i.Certi_status = "Generated"; db.SaveChanges(); return(true); } } } } catch (Exception e) { Console.WriteLine(e); } return(false); }