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