private void btnSave_Click(object sender, RoutedEventArgs e) { if (tbFName.Text != null && tbLName.Text != null) { StudentList = new StudentDetail(); if (int.TryParse(tbSId.Text.ToString(), out int SId)) { StudentList.studentId = SId; } StudentList.firstName = tbFName.Text; StudentList.lastName = tbLName.Text; if (int.TryParse(tbEId.Text.ToString(), out int EId)) { StudentList.educatorId = EId; } if (int.TryParse(tbGLevel.Text.ToString(), out int gLvl)) { StudentList.gradeLevel = gLvl; } StudentList.sFullName = tbLName.Text.ToString() + "," + tbFName.Text.ToString(); Sqlite.ExecuteNonQuery(Query.insertStudent(StudentList)); Close(); } }
private void dgAllStudents_SelectionChanged(object sender, SelectionChangedEventArgs e) { StudentDetail group = (StudentDetail)dgAllStudents.SelectedItem; addstudentnum = group.index; addgroupNum = groupID; }
public List <StudentDetail> makeStudentList() { List <StudentDetail> tempStudentList = new List <StudentDetail>(); int retVal = 0; DataSet ds = Sqlite.ExecuteSQLStatement(Query.getStudentData(), ref retVal); for (int i = 0; i < retVal; i++) { StudentDetail temp = new StudentDetail(); //index if (int.TryParse(ds.Tables[0].Rows[i].ItemArray[0].ToString(), out int index)) { temp.index = index; } //studnet Id if (int.TryParse(ds.Tables[0].Rows[i].ItemArray[1].ToString(), out int sId)) { temp.studentId = sId; } //studnet first name temp.firstName = ds.Tables[0].Rows[i].ItemArray[2].ToString(); //student last name temp.lastName = ds.Tables[0].Rows[i].ItemArray[3].ToString(); //gradeLevel if (int.TryParse(ds.Tables[0].Rows[i].ItemArray[4].ToString(), out int gradeLevel)) { temp.gradeLevel = gradeLevel; } //educator Id if (int.TryParse(ds.Tables[0].Rows[i].ItemArray[4].ToString(), out int educatorId)) { temp.educatorId = educatorId; } temp.sFullName = temp.lastName.ToString() + "," + temp.firstName.ToString(); tempStudentList.Add(temp); } return(tempStudentList); }
public void addStudent(StudentDetail student) { StudentList.Add(student); }
public string UpdateStudent(StudentDetail student) { return("UPDATE Student SET FirstName = '" + student.firstName + "', LastName = '" + student.lastName + "', StudentId = " + student.studentId + ", GradeLevel = " + student.gradeLevel + ",Educator_id= " + student.gradeLevel + " WHERE(_id =" + student.index + ");"); }
public string insertStudent(StudentDetail student) { return("INSERT INTO Student (StudentId,FirstName,LastName,GradeLevel,Educator_id)" + "VALUES (" + student.studentId + ",'" + student.firstName + "','" + student.lastName + "'," + student.gradeLevel + "," + student.educatorId + ");"); }