public List <CourseWithName> ReadCourse()
{
List <CourseWithName> list = new List <CourseWithName>();
if (connect.State == ConnectionState.Open)
{
cmd = new SqlCommand("Select * from Course", connect);
try
{
reader = cmd.ExecuteReader();
while (reader.Read())
{
CourseWithName courseWithName = new CourseWithName();
courseWithName.course.id = reader[0].ToString();
courseWithName.course.teacher = reader[1].ToString();
courseWithName.course.lectures = reader[2].ToString();
courseWithName.course.min_days = reader[3].ToString();
courseWithName.course.students = reader[4].ToString();
courseWithName.course.double_lectures = reader[5].ToString();
courseWithName.name = reader[6].ToString();
list.Add(courseWithName);
}
reader.Close();
}
catch (Exception)
{
reader.Close();
}
}
return(list);
}
private void btnSave_Click(object sender, RoutedEventArgs e)
{
CourseWithName courseWithName = new CourseWithName();
courseWithName.course.id = txtID.Text;
courseWithName.course.lectures = txtLectures.Text;
courseWithName.course.min_days = txtMinDays.Text;
courseWithName.course.students = txtStudents.Text;
Teacher t = cmpTeacher.SelectedValue as Teacher;
courseWithName.course.teacher = t.id;
if (radYes.IsChecked == true)
{
courseWithName.course.double_lectures = "yes";
}
else
{
courseWithName.course.double_lectures = "no";
}
courseWithName.name = txtCourseName.Text;
string messageResult;
if (xmlCon.InsertCourse(courseWithName, out messageResult) == true)
{
txtLectures.Text = "";
txtMinDays.Text = "";
txtStudents.Text = "";
cmpTeacher.SelectedValue = "";
txtCourseName.Text = "";
radYes.IsChecked = false;
radNo.IsChecked = false;
Properties.Settings.Default.CourseId = txtID.Text.Remove(0, 1);
Properties.Settings.Default.Save();
txtID.Text = GenerateId();
lbCourses.ItemsSource = null;
lbCourses.ItemsSource = xmlCon.ReadCourse();
}
// Teacher t = cmpTeacher.SelectedValue as Teacher;
// MessageBox.Show(t.id);
}
// out - e ndryshon vleren e parametrit qe eshte perdor
public bool InsertCourse(CourseWithName courseWithName, out string message)
{
bool rez = false;
message = "";
if (connect.State == ConnectionState.Open)
{
cmd = new SqlCommand("Insert into Course(id, teacherID, lectures, min_days, students, double_lectures, course_name)" +
"values(@id, @teacherID, @lectures, @min_days, @students, @double_lectures, @name)", connect);
cmd.Parameters.Add("@id", SqlDbType.VarChar, 10).Value = courseWithName.course.id;
cmd.Parameters.Add("@teacherID", SqlDbType.VarChar, 10).Value = courseWithName.course.teacher;
cmd.Parameters.Add("@lectures", SqlDbType.Int).Value = Convert.ToInt32(courseWithName.course.lectures);
cmd.Parameters.Add("@min_days", SqlDbType.Int).Value = Convert.ToInt32(courseWithName.course.min_days);
cmd.Parameters.Add("@students", SqlDbType.Int).Value = Convert.ToInt32(courseWithName.course.students);
cmd.Parameters.Add("@double_lectures", SqlDbType.VarChar, 5).Value = courseWithName.course.double_lectures;
cmd.Parameters.Add("@name", SqlDbType.VarChar, 200).Value = courseWithName.name;
try
{
cmd.ExecuteNonQuery();
rez = true;
}
catch (Exception ex)
{
message = ex.Message;
rez = false;
}
}
else
{
rez = false;
message = "Connection is closed";
}
return(rez);
}
