//public static Users GetSingle(int id)
//{
// StringBuilder sql = new StringBuilder();
// sql.Append("SELECT * ");
// sql.Append("FROM [COURSERESULTS] ");
// sql.Append("WHERE [ID] = @ID ");
// return DbCon.Query<Users>(sql.ToString(), new { ID = id }).SingleOrDefault();
//}
public static bool Insert(CourseResults bean)
{
int rowsAffected;
StringBuilder sql = new StringBuilder();
sql.Append("INSERT INTO [COURSERESULTS] ");
sql.Append("([COU_FK], [RES_FK]) ");
sql.Append("VALUES( @COU_FK, @RES_FK)");
try
{
using (SqlConnection cn = ResourceFactory.GetConnection())
{
rowsAffected = cn.Execute(sql.ToString(), bean);
}
}
catch (Exception e)
{
ExceptionExtras eh = new ExceptionExtras("Errore durante la lettura dei CourseResults");
eh.AddParam("sql", sql);
eh.AddParam("bean", bean);
throw new CustomException(eh.ToString(), e);
}
if (rowsAffected > 0)
{
return(true);
}
return(false);
}
private void buttonApproveDrop_Click(object sender, EventArgs e)
{
string fullName = comboBoxSelectCourse.Text;
string nameCourse = fullName.Remove(fullName.Length - 2, 2);
string nameSection = comboBoxSelectCourse.Text;
nameSection = "" + nameSection[fullName.Length - 1];
CourseResults cr = new CourseResults();
cr.CourseName = nameCourse;
cr.Semester = "Spring 17-18";
cr.Section = nameSection;
cr.AccountId = comboBoxSelectStudent.Text;
cr.Quiz = 0;
cr.Term = 0;
cr.FinalMark = 0;
cr.Grade = 0;
cr.Status = "Drop";
CourseResultsRepository crr = new CourseResultsRepository();
if (crr.UpdateStatus(cr))
{
MessageBox.Show("Student ID dropped from the course");
}
else
{
MessageBox.Show("OOPS!!! Something went wrong");
}
}
private void buttonUploadQuiz_Click(object sender, EventArgs e)
{
string fullName = comboBoxSelectCourse.Text;
string nameCourse = fullName.Remove(fullName.Length - 2, 2);
string nameSection = comboBoxSelectCourse.Text;
nameSection = "" + nameSection[fullName.Length - 1];
string selectedId = comboBoxSelectStudent.Text;
selectedId = selectedId.Substring(0, selectedId.IndexOf(" ")).Trim();
CourseResults cr = new CourseResults();
cr.CourseName = nameCourse;
cr.Section = nameSection;
cr.Semester = comboBoxSelectSemester.Text;
cr.AccountId = selectedId;
cr.Quiz = (double)numericUpDownUploadQuizMark.Value;
cr.Term = 0;
cr.FinalMark = 0;
cr.Grade = 0;
cr.Status = "Active";
CourseResultsRepository crr = new CourseResultsRepository();
if (crr.UpdateQuizMark(cr))
{
MessageBox.Show("Quiz Mark uploaded Successfully");
}
else
{
MessageBox.Show("OOPS !!! Something went wr");
}
}
public List <CourseResults> GetAllDroppedStudent(string semester, string course, string section)
{
string query = "SELECT * from CourseResultsTable WHERE Semester='" + semester + "' AND CourseName='" + course + "' AND Section='" + section + "'";
List <CourseResults> cList = new List <CourseResults>();
DatabaseConnectionClass dcc = new DatabaseConnectionClass();
dcc.ConnectWithDB();
SqlDataReader sdr = dcc.GetData(query);
while (sdr.Read())
{
CourseResults c = new CourseResults();
c.CourseName = sdr["CourseName"].ToString();
c.Section = sdr["Section"].ToString();
c.Semester = sdr["Semester"].ToString();
c.AccountId = sdr["AccountId"].ToString();
c.Quiz = Convert.ToDouble(sdr["Quiz"]);
c.Term = Convert.ToDouble(sdr["Term"]);
c.FinalMark = Convert.ToDouble(sdr["FinalMark"]);
c.Grade = Convert.ToDouble(sdr["Grade"]);
c.Status = sdr["Status"].ToString();
cList.Add(c);
}
dcc.CloseConnection();
return(cList);
}
// We use a default department per the assignment instructions, but the API will accept any valid department code.
public async Task <CourseResults> GetCourses(string department = "ENGL")
{
string requestURL = string.Concat(BellvueRestApiURL, department);
var request = new HttpRequestMessage(HttpMethod.Get, requestURL);
request.Headers.Add("Accept", "application/json");
var client = _clientFactory.CreateClient();
var response = await client.SendAsync(request);
// Check our status codes
if (response.IsSuccessStatusCode)
{
_courseResult = JsonConvert.DeserializeObject <CourseResults>(await response.Content.ReadAsStringAsync());
}
else
{
// Set the error check to true so it can be handled in the controller
// Also set the course list to an empty array just to reduce the potential for null handling errors.
_courseResult.RequestHadErrors = true;
_courseResult.courses = Array.Empty <Course>();
}
return(_courseResult);
}
public bool UpdateTermMark(CourseResults a)
{
try
{
string query = "UPDATE CourseResultsTable SET Term= '" + a.Term + "' , FinalMark = '" + a.FinalMark + "' , Grade='" + a.Grade + "' WHERE AccountId= '" + a.AccountId + "' AND CourseName = '" + a.CourseName + "' AND Section='" + a.Section + "' AND Semester='" + a.Semester + "'";
DatabaseConnectionClass dcc = new DatabaseConnectionClass();
dcc.ConnectWithDB();
int x = dcc.ExecuteSQL(query);
dcc.CloseConnection();
return(true);
}
catch
{
return(false);
}
}
public bool UpdateStatus(CourseResults c)
{
try
{
string query = "UPDATE CourseResultsTable SET Status = '" + c.Status + "' WHERE AccountId= '" + c.AccountId + "' AND CourseName = '" + c.CourseName + "' AND Section='" + c.Section + "' AND Semester='" + c.Semester + "'";
DatabaseConnectionClass dcc = new DatabaseConnectionClass();
dcc.ConnectWithDB();
int x = dcc.ExecuteSQL(query);
dcc.CloseConnection();
return(true);
}
catch
{
return(false);
}
}
public double GetQuizMark(CourseResults cr)
{
string query = "SELECT * from CourseResultsTable WHERE AccountId= '" + cr.AccountId + "' AND CourseName='" + cr.CourseName + "' AND Semester='" + cr.Semester + "' AND Section='" + cr.Section + "'";
double quizMark = 0;
DatabaseConnectionClass dcc = new DatabaseConnectionClass();
dcc.ConnectWithDB();
SqlDataReader sdr = dcc.GetData(query);
if (sdr.Read())
{
quizMark = Convert.ToDouble(sdr["Quiz"]);
}
dcc.CloseConnection();
return(quizMark);
}
public void AddResults(ResultsModel model, string username)
{
var courseResult = new CourseResults
{
CourseID = model.CourseID,
Date = DateTime.Now,
UserID = username,
Points = model.AnswerList.Count(a => a != null && a.Right == true)
};
_context.CourseResults.Add(courseResult);
_context.SaveChanges();
foreach (var answer in model.AnswerList)
{
if (answer != null)
{
var learnableResult = _context.LearnableResults.Find(username, answer.LearnableID);
if (learnableResult == null)
{
learnableResult = new LearnableResults
{
LearnableID = answer.LearnableID,
UserID = username,
RightAnswerNum = (answer.Right == true) ? 1 : 0,
WrongAnswerNum = (answer.Right == false) ? 1 : 0
};
_context.LearnableResults.Add(learnableResult);
}
else
{
if (answer.Right == true)
{
learnableResult.RightAnswerNum += 1;
}
else
{
learnableResult.WrongAnswerNum += 1;
}
}
_context.SaveChanges();
}
}
}
public IHttpActionResult PutResults([FromBody] List <SurveyResults> bean, int id)
{
if (ModelState.IsValid)
{
CourseResultsDAO.Delete(id);
foreach (SurveyResults r in bean)
{
CourseResults b = new CourseResults()
{
COU_FK = id, RES_FK = r.ID
};
CourseResultsDAO.Insert(b);
}
return(Ok());
}
else
{
return(BadRequest(ModelState));
}
}
public CourseResults GetSampleCourses()
{
CourseResults cr = new CourseResults();
cr.RequestHadErrors = false;
cr.courses = new Course[] {
new Course()
{
Title = "19th Century English Lit", Credits = "3", Description = "Very exciting 19th Century Dickinson Poems."
},
new Course()
{
Title = "20th Century English Lit", Credits = "3", Description = "Cyberpunk as foreshadowing of the Modern Internet"
},
new Course()
{
Title = "21th Century English Lit", Credits = "3", Description = "LitRPG, is it literature or a video game or both?"
},
};
return(cr);
}
public List <CourseResults> GetAllResult(string ID)
{
string query = "SELECT * from CourseResultsTable WHERE AccountId= '" + ID + "'";
List <CourseResults> cgList = new List <CourseResults>();
DatabaseConnectionClass dcc = new DatabaseConnectionClass();
dcc.ConnectWithDB();
SqlDataReader sdr = dcc.GetData(query);
while (sdr.Read())
{
CourseResults c = new CourseResults();
//c.CourseName = sdr["CourseName"].ToString();
//c.Section = sdr["Section"].ToString();
//c.Quiz = Convert.ToDouble(sdr["Quiz"]);
//c.Term = Convert.ToDouble(sdr["Term"]);
//c.FinalMark = Convert.ToDouble(sdr["FinalMark"]);
c.Grade = Convert.ToDouble(sdr["Grade"]);
c.Status = sdr["Status"].ToString();
cgList.Add(c);
}
dcc.CloseConnection();
return(cgList);
}
private void buttonUploadTerm_Click(object sender, EventArgs e)
{
string fullName = comboBoxSelectCourse.Text;
string nameCourse = fullName.Remove(fullName.Length - 2, 2);
string nameSection = comboBoxSelectCourse.Text;
nameSection = "" + nameSection[fullName.Length - 1];
string selectedId = comboBoxSelectStudent.Text;
selectedId = selectedId.Substring(0, selectedId.IndexOf(" ")).Trim();
CourseResults cr = new CourseResults();
CourseResultsRepository crr = new CourseResultsRepository();
cr.CourseName = nameCourse;
cr.Section = nameSection;
cr.Semester = comboBoxSelectSemester.Text;
cr.AccountId = selectedId;
cr.Quiz = 0;
cr.Term = (double)numericUpDownUploadTermMark.Value;
cr.FinalMark = 0;
cr.Grade = 0;
cr.Status = "Active";
double term = cr.Term;
double quiz = crr.GetQuizMark(cr);
cr.FinalMark = quiz + term;
if (cr.FinalMark >= 80)
{
cr.Grade = 4.00;
}
if (cr.FinalMark >= 70 && cr.FinalMark <= 79)
{
cr.Grade = 3.75;
}
if (cr.FinalMark >= 60 && cr.FinalMark <= 69)
{
cr.Grade = 3.5;
}
if (cr.FinalMark >= 50 && cr.FinalMark <= 59)
{
cr.Grade = 3.25;
}
if (cr.FinalMark >= 40 && cr.FinalMark <= 49)
{
cr.Grade = 3.0;
}
if (cr.FinalMark >= 30 && cr.FinalMark <= 39)
{
cr.Grade = 2.75;
}
if (cr.FinalMark < 30)
{
cr.Grade = 0;
}
if (crr.UpdateTermMark(cr))
{
MessageBox.Show("Term Mark uploaded Successfully");
}
if (!crr.UpdateTermMark(cr))
{
MessageBox.Show("OOPS !!! Something went wrong");
}
}
public CourseService(IHttpClientFactory clientFactory)
{
_clientFactory = clientFactory;
_courseResult = new CourseResults();
}
