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