private void RemarkForm_Load(object sender, EventArgs e)
{
duombaze = new UserDB();
int studentid = 0;
List <Student> studentlist = duombaze.GetStudent();
List <Grade> gradelist = duombaze.GetGrade();
int gradetest = 0;
foreach (Student student in studentlist)
{
if (MainWindow.LoggedInUser.GetFullName() == student.Name + " " + student.Surname)
{
studentid = student.Id;
}
}
foreach (Grade grade in gradelist)
{
if (studentid == grade.StudentId) // jeigu prisijungusio sutdenot id sutampa su pazymio id esancio studento
{
gradetest = grade.Gradenumber;
GradeControl gg = new GradeControl(grade);
flowLayoutPanel1.Controls.Add(gg);
}
}
}
private void button1_Click(object sender, EventArgs e)
{
string studentselected = this.comboBox1.GetItemText(this.comboBox1.SelectedItem);
int studentid = 0;
int studentgrade = 0;
int lessonid = 0;
int teacherid = 0;
List <Student> studenlist = duombaze.GetStudent();
foreach (Student student in studenlist)
{
if (studentselected == student.Name + " " + student.Surname)
{
studentid = student.Id;
}
}
List <Grade> gradelist = duombaze.GetGrade();
foreach (Grade grade in gradelist)
{
if (studentid == grade.StudentId)
{
studentgrade = grade.Gradenumber;
}
}
Console.WriteLine(studentgrade);
studentgrade = Int32.Parse(this.comboBox2.GetItemText(this.comboBox2.SelectedItem));
List <Teacher> teacherlist = duombaze.GetTeacher();
foreach (Teacher teacher in teacherlist)
{
if (MainWindow.LoggedInUser.GetFullName() == teacher.Name + " " + teacher.Surname)
{
teacherid = teacher.Id;
}
}
List <Lesson> lessonlist = duombaze.Getlesson();
foreach (Grade grade in gradelist)
{
if (teacherid == grade.TeacherId)
{
foreach (Lesson lesson in lessonlist)
{
if (teacherid == lesson.Teacherid)
{
lessonid = lesson.Id;
}
}
}
}
duombaze.ChangeGrade(studentgrade, studentid, teacherid, lessonid);
MessageBox.Show("Sekmingai pakeistas pazymis!");
this.Close();
}
public RemoveStudent()
{
InitializeComponent();
duombaze = new UserDB();
List <Student> studentlist = duombaze.GetStudent();
foreach (Student student in studentlist)
{
comboBox1.Items.Add(student.Name + " " + student.Surname);
}
}
private void button1_Click(object sender, EventArgs e)
{
string studentselected = this.comboBox1.GetItemText(this.comboBox1.SelectedItem);
string gradetext = this.comboBox2.GetItemText(this.comboBox2.SelectedItem);
int grade = Int32.Parse(gradetext);
int studentid = 0;
int teacherid = 0;
List <Teacher> teacherlist = duombaze.GetTeacher();
foreach (Teacher teacher in teacherlist)
{
if (MainWindow.LoggedInUser.GetFullName() == teacher.Name + " " + teacher.Surname)
{
teacherid = teacher.Id;
}
}
int lessonid = 0;
List <Student> studentlist = duombaze.GetStudent();
foreach (Student student in studentlist)
{
if (studentselected == student.Name + " " + student.Surname)
{
studentid = student.Id;
}
}
List <Lesson> lessonlist = duombaze.Getlesson();
foreach (Lesson lesson in lessonlist)
{
if (lesson.Teacherid == teacherid)
{
lessonid = lesson.Id;
}
}
duombaze.AddNewGrade(grade, studentid, teacherid, lessonid);
MessageBox.Show("Pazymis sekmingai pridetas");
this.Close();
}
private void button1_Click(object sender, EventArgs e)
{
string studentselected = this.comboBox1.GetItemText(this.comboBox1.SelectedItem);
int studentid = 0;
string studentname = "";
string studentsurname = "";
List <Student> studentlist = duombaze.GetStudent();
foreach (Student student in studentlist)
{
if (studentselected == student.Name + " " + student.Surname)
{
studentid = student.Id;
studentname = student.Name;
studentsurname = student.Surname;
}
}
Console.WriteLine(studentid);
duombaze.RemoveStudent(studentid, studentname, studentsurname);
}
private void button1_Click(object sender, EventArgs e)
{
string studentselected = this.comboBox1.GetItemText(this.comboBox1.SelectedItem);
int studentid = 0;
string studentname = "";
string studentsurname = "";
List <Student> studentlist = duombaze.GetStudent();
foreach (Student student in studentlist)
{
if (studentselected == student.Name + " " + student.Surname)
{
studentid = student.Id;
studentname = student.Name;
studentsurname = student.Surname;
}
}
duombaze.RemoveStudent(studentid, studentname, studentsurname);
MessageBox.Show("Studentas sekmingai pasalintas");
this.Close();
}
private void RemarkForm_Load(object sender, EventArgs e)
{
duombaze = new UserDB();
int studentid = 0;
List <Student> studentlist = duombaze.GetStudent();
List <Grade> gradelist = duombaze.GetGrade();
int gradetest = 0;
foreach (Student student in studentlist)
{
if (MainWindow.LoggedInUser.GetFullName() == student.Name + " " + student.Surname)
{
studentid = student.Id;
}
}
foreach (Grade grade in gradelist)
{
if (studentid == grade.StudentId) // jeigu prisijungusio sutdenot id sutampa su pazymio id esancio studento
{
gradetest = grade.Gradenumber;
GradeControl gg = new GradeControl(grade);
flowLayoutPanel1.Controls.Add(gg);
}
}
Console.WriteLine(gradetest);
/* var select = "SELECT * FROM grade";
* conn = new SqlConnection(@"Server=.;Database=AcademicDB;Trusted_Connection=true;");
* var dataAdapter = new SqlDataAdapter(select, conn);
* var commandBuilder = new SqlCommandBuilder(dataAdapter);
* var ds = new DataSet();
* dataAdapter.Fill(ds);
* dataGridView1.ReadOnly = true;
* dataGridView1.DataSource = ds.Tables[0];
*/
}
public ChangeGrade()
{
InitializeComponent();
duombaze = new UserDB();
List <Student> studentlist = duombaze.GetStudent();
List <Group> grouplist = duombaze.GetGroup();
List <Lesson> lessonlist = duombaze.Getlesson();
List <Teacher> teacherlist = duombaze.GetTeacher();
int studentgroupid = 0;
int teacherid = 0;
foreach (Teacher teacher in teacherlist)
{
if (MainWindow.LoggedInUser.GetFullName() == teacher.Name + " " + teacher.Surname)
{
teacherid = teacher.Id;
}
}
foreach (Student student in studentlist)
{
foreach (Group group in grouplist)
{
if (student.GroupName == group.GroupName)
{
studentgroupid = group.Id;
foreach (Lesson lesson in lessonlist)
{
if (teacherid == lesson.Teacherid && studentgroupid == lesson.Groupid)
{
comboBox1.Items.Add(student.Name + " " + student.Surname);
}
}
}
}
}
}
