public bool removeStudent(StudentInfo student)
{
/*
* - Remove student infor in Database Table first
* - Remove student grade in Grade table
* - Remove student info in student info table
*/
cmd.CommandText = string.Format(@"DELETE FROM DatabaseTable WHERE DatabaseTable.StudentID = {0}",
student.m_studentID);
try
{
connection.Open();
cmd.ExecuteNonQuery();
connection.Close();
}
catch (Exception exception)
{
connection.Close();
MessageBox.Show(@"Message: " + exception.ToString(), @"Error", MessageBoxButtons.OK,
MessageBoxIcon.Error);
return false;
throw;
}
cmd.CommandText = string.Format(@"DELETE FROM GradeTable WHERE GradeTable.StudentID = {0}",
student.m_studentID);
try
{
connection.Open();
cmd.ExecuteNonQuery();
connection.Close();
}
catch (Exception exception)
{
connection.Close();
MessageBox.Show(@"Message: " + exception.ToString(), @"Error", MessageBoxButtons.OK,
MessageBoxIcon.Error);
return false;
throw;
}
cmd.CommandText = string.Format(@"DELETE FROM Student WHERE Student.StudentID = {0}", student.m_studentID);
try
{
connection.Open();
cmd.ExecuteNonQuery();
connection.Close();
}
catch (Exception exception)
{
MessageBox.Show(@"Message: " + exception.ToString(), @"Error", MessageBoxButtons.OK,
MessageBoxIcon.Error);
connection.Close();
return false;
throw;
}
return true;
}
public DetailForm(StudentInfo studentInfo, int term)
{
InitializeComponent();
m_studentInfo = new StudentInfo(studentInfo);
m_Term = term;
num_Term.ReadOnly = true;
cb_StudentName.Enabled = false;
cb_ABRSMgrade.Enabled = false;
cb_Effort.Enabled = false;
cb_Listening.Enabled = false;
cb_MusicalLiteracy.Enabled = false;
cb_Musicianship.Enabled = false;
cb_Performing.Enabled = false;
cb_Technique.Enabled = false;
tb_TargetComment.ReadOnly = true;
tb_Instrument.ReadOnly = true;
tb_SchoolName.ReadOnly = true;
tb_TeacherName.ReadOnly = true;
}
/*
* - Add student info to student table
* - Add studentID and ABRSMID to database table
*/
public bool addStudent(StudentInfo student)
{
cmd.CommandText =
string.Format(
@"INSERT INTO Student (StudentID, Name, DoB, Address, ABRSMID, TeacherName, Instrument, EnsemblesPartition) VALUES ({0}, '{1}', '{2}', '{3}', {4}, '{5}', '{6}', '{7}')",
student.m_studentID, student.m_studentName,
Convert.ToDateTime(student.m_DoB).ToString("MM-dd-yyyy"),
student.m_Adrress,
student.m_ABRSMGradeID, student.m_TeacherName, student.m_Instrument, student.m_EnsemblesPartition);
try
{
connection.Open();
cmd.ExecuteNonQuery();
connection.Close();
}
catch (Exception exception)
{
MessageBox.Show(@"Message: " + exception.ToString(), @"Error", MessageBoxButtons.OK,
MessageBoxIcon.Error);
connection.Close();
return false;
}
return true;
}
public ChartView(StudentInfo studentInfo)
{
m_studentInfo = new StudentInfo(studentInfo);
InitializeComponent();
chartControl1.Series[0].DataFilters.ClearAndAddRange(new DevExpress.XtraCharts.DataFilter[] {
new DevExpress.XtraCharts.DataFilter("StudentID", "System.Int32", DevExpress.XtraCharts.DataFilterCondition.Equal, m_studentInfo.m_studentID)});
// This line of code is generated by Data Source Configuration Wizard
//databaseTableTableAdapter.Fill(musicalManagementDataSet.DatabaseTable);
connection.ConnectionString = ConnectionStringToDatabase.getConnectionString();
cmd.Connection = connection;
connection.Close();
// Read [DatabaseTable] table and add year to cb_Year
try
{
cmd.CommandText = string.Format(@"select Term, SummaryGrade from DatabaseTable where StudentID = {0}", m_studentInfo.m_studentID);
connection.Open();
reader = cmd.ExecuteReader();
if (reader.HasRows)
{
int year = 0;
int term = 0;
while (reader.Read())
{
year = Convert.ToInt32(reader[0]) / 10;
listYear.Add(year);
term = Convert.ToInt32(reader[0]) % 10;
switch (term)
{
case 1:
summaryGrade[0] = Convert.ToInt32(reader[1]);
break;
case 2:
summaryGrade[1] = Convert.ToInt32(reader[1]);
break;
case 3:
summaryGrade[2] = Convert.ToInt32(reader[1]);
break;
case 4:
summaryGrade[3] = Convert.ToInt32(reader[1]);
break;
case 5:
summaryGrade[4] = Convert.ToInt32(reader[1]);
break;
case 6:
summaryGrade[5] = Convert.ToInt32(reader[1]);
break;
}
}
}
connection.Close();
}
catch (Exception ex)
{
MessageBox.Show(@"Message3: " + ex.Message.ToString(), @"Error");
connection.Close();
}
//list.Distinct().ToArray();
this.cb_Year.Properties.Items.AddRange(listYear.Distinct().ToArray());
}
private void detailButton_Click(object sender, EventArgs e)
{
this.Hide();
var intTerm = 0;
var button = sender as Button;
if (button != null)
{
intTerm = Convert.ToInt32(button.Tag.ToString());
}
StudentInfo studentInfo = null;
if (lb_studentNameBaseOnABRSM.SelectedItem != null)
{
/*Read student info from database*/
_cmd.CommandText = string.Format(@"SELECT * FROM Student WHERE StudentID = {0}",
((ComboBoxItem)lb_studentNameBaseOnABRSM.SelectedItem).MValue);
try
{
_connection.Open();
_reader = _cmd.ExecuteReader();
if (_reader.HasRows)
{
while (_reader.Read())
{
studentInfo = new StudentInfo(_reader[0], _reader[1].ToString(), _reader[4],
DateTime.Parse(_reader[2].ToString()), _reader[3].ToString(), _reader[5].ToString(),
_reader[6].ToString(), _reader[7].ToString());
}
}
_connection.Close();
}
catch (Exception ex)
{
_connection.Close();
MessageBox.Show(@"Message2: " + ex.Message.ToString(), @"Error");
throw;
}
}
DetailForm detailForm = null;
detailForm = intTerm != 0 ? new DetailForm(studentInfo, intTerm) : new DetailForm();
detailForm.Show();
detailForm.FormClosing += detailForm_FormClosing;
//MessageBox.Show(@"Detail button click: " + sender.ToString(), @"Notification", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
private void bt_AddScore_Click(object sender, EventArgs e)
{
//Debug.Assert(lb_studentNameBaseOnABRSM.SelectedItem != null, "lb_studentNameBaseOnABRSM.SelectedItem != null");
StudentInfo studentInfo = null;
if (lb_studentNameBaseOnABRSM.SelectedItem != null)
{
/*Read student info from database*/
_cmd.CommandText = string.Format(@"SELECT * FROM Student WHERE StudentID = {0}",
((ComboBoxItem) lb_studentNameBaseOnABRSM.SelectedItem).MValue);
try
{
_connection.Open();
_reader = _cmd.ExecuteReader();
if (_reader.HasRows)
{
while (_reader.Read())
{
studentInfo = new StudentInfo(_reader[0], _reader[1].ToString(), _reader[4],
DateTime.Parse(_reader[2].ToString()), _reader[3].ToString(), _reader[5].ToString(),
_reader[6].ToString(), _reader[7].ToString());
}
}
_connection.Close();
}
catch (Exception ex)
{
_connection.Close();
MessageBox.Show(@"Message2: " + ex.Message.ToString(), @"Error");
throw;
}
if (studentInfo != null)
{
var addScoreForm = new AddScore(studentInfo);
addScoreForm.Show();
this.Hide();
addScoreForm.FormClosing += addScoreForm_FormClosing;
}
else
{
MessageBox.Show(@"Invalid student: ", @"Error");
}
}
else
MessageBox.Show(
string.Format("There no student on ABRSM: {0}. You need to add student first.",
((ComboBoxItem) cb_ABRSMGrade.SelectedItem).ToString()), @"Error", MessageBoxButtons.OK,
MessageBoxIcon.Error);
}
public StudentInfo(StudentInfo studentInfo)
{
m_studentID = studentInfo.m_studentID;
m_studentName = studentInfo.m_studentName;
m_ABRSMGradeID = studentInfo.m_ABRSMGradeID;
m_DoB = studentInfo.m_DoB;
m_Adrress = studentInfo.m_Adrress;
m_TeacherName = studentInfo.m_TeacherName;
m_Instrument = studentInfo.m_Instrument;
m_EnsemblesPartition = studentInfo.m_EnsemblesPartition;
}
public AddScore(StudentInfo studentInfo)
{
m_studentInfo = new StudentInfo(studentInfo);
InitializeComponent();
}
