public static List <StudentScoreDB> GetAllScores() { List <StudentScoreDB> score = new List <StudentScoreDB>(); int subUserId = GetSubUserId(); try { string query = "SELECT s.stdId,s.name,s.gender,sc.scoreId, sc.quiz, sc.homework,sc.atdScore, sc.assignment, sc.midterm,sc.final FROM score sc INNER JOIN student s ON s.stdId= sc.stdId WHERE s.subUserId= @subUserId"; MySqlCommand cmd = new MySqlCommand(query, Database.connection); cmd.Prepare(); cmd.Parameters.AddWithValue("@subUserId", subUserId); MySqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { StudentScoreDB p = new StudentScoreDB(); p.scoreId = Int16.Parse(controlNULL(reader["scoreId"].ToString())); p.stdId = Int16.Parse(reader["stdId"].ToString()); p.stdName = reader["name"].ToString(); p.gender = Convert.ToBoolean(reader["gender"].ToString()); p.quiz = Int16.Parse(controlNULL(reader["quiz"].ToString())); p.homework = Int16.Parse(controlNULL(reader["homework"].ToString())); p.assignment = Int16.Parse(controlNULL(reader["assignment"].ToString())); p.Attendance = Double.Parse(controlNULL(reader["atdScore"].ToString())); p.midterm = Int16.Parse(controlNULL(reader["midterm"].ToString())); p.final = Int16.Parse(controlNULL(reader["final"].ToString())); score.Add(p); } reader.Close(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } return(score); }
private void btnSave_Click(object sender, EventArgs e) { StudentScoreDB Update = new StudentScoreDB(); Update.QuizPct = trbQuiz.Value; Update.HomeWorkPct = trbHW.Value; Update.AttendencePct = trbAtt.Value; Update.AssignmentPct = trbAss.Value; Update.MidtermPct = trbMidterm.Value; Update.FinalPct = trbFinal.Value; StudentScoreDB.UpdateSetting(Update); Design("Silver", "false"); }
private void SC_List_Load(object sender, EventArgs e) { Database.Open(); myScore = StudentScoreDB.getSelected(SC_List.ScoreId); //StudentScoreDB.EditLoad(); lbName.Text = myScore.stdName; txtHomework.Text = myScore.Homework.ToString(); txtQuiz.Text = myScore.Quiz.ToString(); txtAssignment.Text = myScore.Assignment.ToString(); txtMidterm.Text = myScore.Midterm.ToString(); //txtAttendent.Text = "0"; txtFinal.Text = myScore.Final.ToString(); ChangeLanguage(); }
private void btnUpdate_Click(object sender, EventArgs e) { StudentScoreDB sc = new StudentScoreDB(); try { sc.scoreId = myScore.scoreId; sc.Homework = Int16.Parse(txtHomework.Text); sc.Quiz = Int16.Parse(txtQuiz.Text); sc.Assignment = Int16.Parse(txtAssignment.Text); sc.Midterm = Int16.Parse(txtMidterm.Text); sc.Final = Int16.Parse(txtFinal.Text); StudentScoreDB.Update(sc); (this.Owner as StudentScore).btnList_Click(sender, e); } catch (Exception) { MessageBox.Show("Please fill all score", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } }
public static void Update(StudentScoreDB score) { string query = "UPDATE score SET quiz=@quiz, homework=@homework, assignment=@assignment, midterm=@midterm, final=@final WHERE scoreId=@scoreId"; MySqlCommand cmd = new MySqlCommand(query, Database.connection); cmd.Prepare(); cmd.Parameters.AddWithValue("@scoreId", score.scoreId); cmd.Parameters.AddWithValue("@quiz", score.Quiz); cmd.Parameters.AddWithValue("@homework", score.Homework); cmd.Parameters.AddWithValue("@assignment", score.Assignment); cmd.Parameters.AddWithValue("@midterm", score.Midterm); cmd.Parameters.AddWithValue("@final", score.Final); try { cmd.ExecuteNonQuery(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
private void SC_Settings_Load(object sender, EventArgs e) { Database.Open(); btnSave.Enabled = false; Setting = StudentScoreDB.Setting(); trbQuiz.Value = Setting.QuizPct; trbHW.Value = Setting.HomeWorkPct; trbAtt.Value = Setting.AttendencePct; trbAss.Value = Setting.AssignmentPct; trbMidterm.Value = Setting.MidtermPct; trbFinal.Value = Setting.FinalPct; lbHomework.Text = trbHW.Value.ToString() + " %"; lbQuiz.Text = trbQuiz.Value.ToString() + " %"; lbAssignment.Text = trbAss.Value.ToString() + " %"; lbMidterm.Text = trbMidterm.Value.ToString() + " %"; lbAttendent.Text = trbAtt.Value.ToString() + " %"; lbFinal.Text = trbFinal.Value.ToString() + " %"; }
public static void UpdateSetting(StudentScoreDB Pecertage) { string query = "Update settingscore set Quiz=@Quiz,HomeWork=@HomeWork,Attendence=@Attendence,Assignment=@Assignment,Midterm=@Midterm,Final=@Final Where SubUserID=@SubUserID"; MySqlCommand cmd = new MySqlCommand(query, Database.connection); cmd.Parameters.AddWithValue("@SubUserID", GetSubUserId()); cmd.Parameters.AddWithValue("@Quiz", Pecertage.QuizPct); cmd.Parameters.AddWithValue("@HomeWork", Pecertage.HomeWorkPct); cmd.Parameters.AddWithValue("@Attendence", Pecertage.AttendencePct); cmd.Parameters.AddWithValue("@Assignment", Pecertage.AssignmentPct); cmd.Parameters.AddWithValue("@Midterm", Pecertage.MidtermPct); cmd.Parameters.AddWithValue("@Final", Pecertage.FinalPct); try { // MessageBox.Show(Pecertage.FinalPct.ToString()); cmd.ExecuteNonQuery(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
public static StudentScoreDB Setting() { StudentScoreDB s = new StudentScoreDB(); string query = "Select * From settingscore Where SubUserID =@SubUserID"; MySqlCommand Cmd = new MySqlCommand(query, Database.connection); Cmd.Parameters.AddWithValue("@SubUserID", GetSubUserId()); Cmd.Prepare(); MySqlDataReader reader = Cmd.ExecuteReader(); while (reader.Read()) { s.quizPct = Int16.Parse(controlNULL(reader["Quiz"].ToString())); s.homeWorkPct = Int16.Parse(controlNULL(reader["HomeWork"].ToString())); s.attendencePct = Int16.Parse(controlNULL(reader["Attendence"].ToString())); s.assignmentPct = Int16.Parse(controlNULL(reader["Assignment"].ToString())); s.midtermPct = Int16.Parse(controlNULL(reader["Midterm"].ToString())); s.finalPct = Int16.Parse(controlNULL(reader["Final"].ToString())); } reader.Close(); return(s); }
public void LoadSearch(string keyword) { score = StudentScoreDB.Search(keyword); P = StudentScoreDB.Setting(); int Total = 0; string gender; StudentScoreList.Rows.Clear(); foreach (StudentScoreDB s in score) { if (s.gender == true) { gender = "M"; } else { gender = "F"; } Total = ((s.Quiz * P.QuizPct) + (s.Homework * P.HomeWorkPct) + (s.Assignment * P.AssignmentPct) + (s.Midterm * P.MidtermPct) + (s.Final * P.FinalPct)) / 100; StudentScoreList.Rows.Add(s.scoreId, s.stdId, s.stdName, gender, s.Quiz, s.Homework, s.Assignment, s.Midterm, s.Final, Total); } }
public static StudentScoreDB getSelected(int id) { StudentScoreDB s = new StudentScoreDB(); string query = "SELECT s.name, sc.scoreId ,sc.quiz,sc.homework, sc.assignment, sc.midterm, sc.final FROM score sc INNER JOIN student s ON s.stdId= sc.stdId WHERE sc.scoreId=@scoreId"; MySqlCommand cmd = new MySqlCommand(query, Database.connection); cmd.Prepare(); cmd.Parameters.AddWithValue("@scoreId", id); MySqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { s.scoreId = Int16.Parse(controlNULL(reader["scoreId"].ToString())); s.stdName = reader["name"].ToString(); s.quiz = Int16.Parse(controlNULL(reader["quiz"].ToString())); s.homework = Int16.Parse(controlNULL(reader["homework"].ToString())); s.assignment = Int16.Parse(controlNULL(reader["assignment"].ToString())); s.midterm = Int16.Parse(controlNULL(reader["midterm"].ToString())); s.final = Int16.Parse(controlNULL(reader["final"].ToString())); } reader.Close(); return(s); }