public bool Add(Class newClass)
{
string sql = "INSERT INTO " + TBL_CLASSES
+ " (" + CLASS_NAME + ") "
+ "VALUES ('" + newClass.name + "');";
return _db.ExecuteInsertUpdateDelete(sql);
}
public bool Edit(Class editClass)
{
string sql = "UPDATE " + TBL_CLASSES + " SET "
+ CLASS_NAME + "='" + editClass.name + "' "
+ "WHERE " + CLASS_ID + "=" + editClass.id + ";";
return _db.ExecuteInsertUpdateDelete(sql);
}
public Student(long id, String name, double grade, int height, Class class_id)
{
this._id = id;
this._name = name;
this._grade = grade;
this._height = height;
this._class_id = class_id;
}
private void bEditClass_Click(object sender, EventArgs e)
{
if (txtEditClassName.Text != "")
{
_editClass = selectedClass;
_editClass.name = txtEditClassName.Text;
this.DialogResult = System.Windows.Forms.DialogResult.OK;
this.Close();
}
else
{
MessageBox.Show("Fill in a name.");
}
}
private bool checkAndGetValues()
{
if(txtAddStudName.Text!=""
&& cmbAddStudClass.SelectedIndex!=-1
&& cmbAddStudClass.Text!=""
&& cmbAddStudClass.SelectedItem!=null){
name = txtAddStudName.Text;
grade = Convert.ToDouble(nudAddStudGrade.Value);
Console.WriteLine("height:" + nudAddStudHeight.Value);
height = Convert.ToInt32(nudAddStudHeight.Value);
studClass = (Class)cmbAddStudClass.SelectedItem;
return true;
}
return false;
}
public bool Add(Class newClass)
{
long newClassId = 1 + Convert.ToInt64(
_doc.Root
.Descendants(CLASSINDEX_EL)
.First()
.Value);
try
{
XElement newClassEl = new XElement(CLASS_EL);
newClassEl.SetAttributeValue(CLASS_NAME_ATT, newClass.name);
newClassEl.SetAttributeValue(ID_ATT, newClassId);
_doc.Root.Add(newClassEl);
_doc.Root.Element(META_EL).SetElementValue(CLASSINDEX_EL, newClassId);
_doc.Save(_path);
return true;
}
catch (Exception)
{
return false;
}
}
public List<Student> GetStudentsInClass(Class fromClass)
{
List<Student> result = new List<Student>();
List<string> stringList = new List<string>();
if (_client.OpenConnection())
{
Console.WriteLine("Connection ok");
stringList = _client.GetStudentsList(fromClass.id.ToString());
_client.CloseConnection();
}
foreach (string s in stringList)
{
string[] parts = s.Split(';');
result.Add(new Student(
Convert.ToInt64(parts[0]),
parts[1],
Convert.ToDouble(parts[2]),
Convert.ToInt32(parts[3]),
fromClass));
}
return result;
}
public bool Delete(Class delClass)
{
try
{
XElement delClassEl = _doc.Root
.Descendants(CLASS_EL)
.Single(s => (string)s.Attribute(ID_ATT).Value == delClass.id.ToString());
if (delClassEl.DescendantNodes().Count() == 0)
{
delClassEl.Remove();
_doc.Save(_path);
}
else {
MessageBox.Show("Cannot remove a class that has students in it.");
return false;
}
}
catch (Exception)
{
return false;
}
return true;
}
public List<Student> GetStudentsInClass(Class fromClass)
{
List<Student> studentsList = new List<Student>();
NumberFormatInfo provider = new NumberFormatInfo();
provider.NumberDecimalSeparator = DECIMAL_SEPERATOR;
IEnumerable<IEnumerable<XElement>> students =
from el in _doc.Root.Elements(CLASS_EL)
where el.Attribute(ID_ATT).Value==fromClass.id.ToString()
select el.Elements(STUD_EL);
foreach(IEnumerable<XElement> el in students){
foreach (XElement s in el) {
studentsList.Add(new Student(
Convert.ToInt64(s.Attribute(ID_ATT).Value),
s.Attribute(STUD_NAME_ATT).Value,
Convert.ToDouble(s.Element(STUD_GRADE_EL).Value, provider),
Convert.ToInt32(s.Element(STUD_HEIGHT_EL).Value),
fromClass));
}
}
return studentsList;
}
public bool Edit(Class editClass)
{
XElement oldClass = _doc.Root
.Descendants(CLASS_EL)
.Single(c => (string)c.Attribute(ID_ATT).Value == editClass.id.ToString());
try
{
oldClass.SetAttributeValue(CLASS_NAME_ATT, editClass.name);
_doc.Save(_path);
return true;
}
catch (Exception)
{
return false;
}
}
private void cmbClassList_SelectedIndexChanged(object sender, EventArgs e)
{
selectedClass= (Class) ((ComboBox)sender).SelectedItem;
txtEditClassName.Text = selectedClass.name;
}
private void cmbClassList_SelectedIndexChanged(object sender, EventArgs e)
{
_selectedClass = (Class)((ComboBox)sender).SelectedItem;
FillStudents(_helper.GetStudentsInClass(_selectedClass));
}
private void CmbClasses_IndexChanged(object sender, EventArgs e)
{
// When a class is chosen, get the Students from this class.
selectedClass = (Class) ((ComboBox)sender).SelectedItem; // Store the selected class.
lblSelectedClass.Text = SELECTEDLABEL_TEXT + selectedClass;
students = helper.GetStudentsInClass(selectedClass); // Get the students that are a member in this class.
txtAmountOfStudents.Text = students.Count.ToString(); // Fill in the amount of Students in the class.
}
public bool Add(Class newClass)
{
throw new NotImplementedException();
}
private void bAddClass_Click(object sender, EventArgs e)
{
_newClass = new Class(0, txtAddClassName.Text);
}
public bool Delete(Class editClass)
{
string sql = "DELETE FROM " + TBL_CLASSES
+ " WHERE " + CLASS_ID + "=" + editClass.id + ";";
return _db.ExecuteInsertUpdateDelete(sql);
}
public bool Edit(Class editClass)
{
throw new NotImplementedException();
}
public List<Student> GetStudentsInClass(Class fromClass)
{
List<Student> studentsList = new List<Student>();
String sql = "SELECT * FROM " + TBL_STUDENTS
+ " WHERE " + CLASS_ID + "=" + fromClass.id + ";";
DataTableReader records = _db.ExecuteSelect(sql);
while (records.Read())
{
studentsList.Add(new Student(
Convert.ToInt32(records[STUD_ID]),
(String)records[STUD_NAME],
Convert.ToDouble(records[STUD_GRADE]),
Convert.ToInt32(records[STUD_HEIGHT]),
fromClass
));
}
records.Close();
return studentsList;
}