public GradeControl(Grade grade)
{
InitializeComponent();
List <Lesson> lessonlist = duombaze.Getlesson();
List <Course> courselist = duombaze.GetCourse();
List <Grade> gradelist = duombaze.GetGrade();
string lessonname = "";
foreach (Lesson lesson in lessonlist)
{
if (grade.LessonId == lesson.Id)
{
foreach (Course course in courselist)
{
if (lesson.Courseid == course.Id)
{
lessonname = course.Name;
}
}
}
}
labelCourseName.Text = lessonname.ToString();
labelGrade.Text = "Ivertinimas:" + " " + grade.Gradenumber.ToString();
}
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();
}
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];
*/
}
