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