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