public async void ShowCourses()
{
List <Course> courses = await App.DB.ShowCourses(termValue);
foreach (Course course in courses)
{
CourseList.Add(course);
}
if (CourseList.Count > 0)
{
CourseLabel = true;
}
ButtonEnabled = CourseList.Count >= 6 ? false : true;
}
private void DoFilter(object o)
{
string instructor = o.ToString();
var course = CourseAll;
if (instructor != "All")
{
course = CourseAll.Where(c => c.CourseInstructors.Exists(e => e == instructor)).ToList();
}
CourseList.Clear();
foreach (var item in course)
{
CourseList.Add(item);
}
}
private async void GetCourses()
{
List <Course> courses = await App.Database.GetCoursesAsync(_term);
foreach (Course course in courses)
{
CourseList.Add(course);
}
if (CourseList.Count > 0)
{
ShowCourseLabel = true;
}
AddButtonEnabled = CourseList.Count >= 6 ? false : true;
RaiseAllProperties();
}
internal static CourseList DataTableToTitleList(DataTable Dt)
{
CourseList courses = new CourseList();
try
{
foreach (DataRow item in Dt.Rows)
{
courses.Add(DataRowToTitle(item));
}
}
catch
{
}
return(courses);
}
private void DoFilter(object o)
{
string teacher = o.ToString();
List <CourseModel> temp = courseAll;
if (teacher != "全部")
{
temp = courseAll.Where(c => c.Teachers.Exists(e => e == teacher)).ToList();
}
CourseList.Clear();
foreach (var item in temp)
{
CourseList.Add(item);
}
}
public bool MakeCourses(Courses courses)
{
if (courses.Status == "Compulsory")
{
SettingStatus = "Big";
Sizee = "C";
}
else if (courses.Status == "Required")
{
SettingStatus = "Medium";
Sizee = "R";
}
else
{
if (courses.Status == "Elective")
{
SettingStatus = "Small";
Sizee = "E";
}
}
int count = CourseList.Count <Courses>(chk => chk.Name == courses.Name);
if (count > 0)
{
return(false);
}
else
{
CourseList.Add(new Courses
{
Name = courses.Name,
Status = SettingStatus,
Size = Sizee
});
CourseList.CollectionChanged += CourseList_CollectionChanged;
}
//int search = CourseList.IndexOf(courses.Name);
// CourseList.Contains(courses.Name);
//CourseList.Where(chk=> chk.CourseList.Contains(courses.Name))
return(true);
}
async Task ExecuteLoadCourses()
{
if (IsBusy)
{
return;
}
IsBusy = true;
try
{
CourseList.Clear();
var courses = await App.DB.ShowCourses(Term);
foreach (var course in courses)
{
CourseList.Add(course);
}
}
catch (Exception exception) { }
finally { IsBusy = false; }
}
//Responsible of submitting the course with all its details to the database
private void ButtonSubmit_Click(object sender, EventArgs e)
{
//Check if there is an empty field
bool isValid = true;
foreach (Control ctr in Controls)
{
if (ctr is TextBox)
{
if (ctr.Text == "" || ctr.Text is null)
{
isValid = false;
}
}
}
//Check if there is an empty field that wasn't put
if (isValid)
{
Course course = new Course();
course.CourseID = textBoxID.Text.ToString();
course.Title = textBoxTitle.Text;
course.Credits = textBoxCredits.Text;
courseList.Add(course);
if (course.getValid())
{
//Show confirmation message
MessageBox.Show("Course Added Successfully!");
Clear();
}
else
{
MessageBox.Show(course.geterrorMessage());
}
}
else
{
MessageBox.Show("A field is empty");
}
}
private void InitCourseList()
{
for (int i = 0; i < 10; i++)
{
CourseList.Add(new CourseModel {
IsShowSkeleton = true
});
}
Task.Run(new Action(async() =>
{
courseAll = LocalDataAccess.GetInstance().GetCourses();
await Task.Delay(4000);
Application.Current.Dispatcher.Invoke(new Action(() =>
{
CourseList.Clear();
foreach (var item in courseAll)
{
CourseList.Add(item);
}
}));
}));
}
bool IModel.addCourse(string courseID, string name, string deptid, double priceEU, double priceNonEU, string desc, int points, int capacity, int curCapacity, int isNight)
{
ICourse duplicateCourse = this.CourseList.FirstOrDefault(cour => cour.CourseID == courseID.Trim());
if (duplicateCourse != null)
{
return(false);
}
else
{
try
{
ICourse acourse = UserFactory.GetCourse(courseID, name, deptid, priceEU, priceNonEU, desc, points, capacity, curCapacity, isNight);
CourseList.Add(acourse);
DataLayer.addNewCourseToDB(acourse);
return(true);
}
catch (System.Exception excep)
{
return(false);
}
}
}
/// <summary>
/// Gets a list of Courses
/// </summary>
/// <returns>List of Courses</returns>
public static CourseList GetItem()
{
CourseList myCourseList = null;
using (SqlConnection myConnection = new SqlConnection(AppSettings.ConnectionString))
{
SqlCommand myCommand = new SqlCommand("spSelectCourseList", myConnection);
myCommand.CommandType = CommandType.StoredProcedure;
myConnection.Open();
using (SqlDataReader myDataReader = myCommand.ExecuteReader())
{
if (myDataReader.HasRows)
{
myCourseList = new CourseList();
while (myDataReader.Read())
{
myCourseList.Add(FillRecord(myDataReader));
}
}
myDataReader.Close();
}
myConnection.Close();
}
return myCourseList;
}
/// <summary>
/// Gets list of courses taken by a student.
/// </summary>
/// <param name="id">A unique student id.</param>
/// <param name="isStudent">Boolean flag for student. True if user is a student else false.</param>
/// <returns>A list of courses.</returns>
public static CourseList GetItem(string id, bool isStudent)
{
CourseList myCourseList = null;
using (SqlConnection myConnection = new SqlConnection(AppSettings.ConnectionString))
{
//SqlCommand cmd = new SqlCommand("Select * from Course where CourseID = 'cid01'",myConnection);
string callProcedure = isStudent ?
"spGetEnrolledCourseListByStudent" : "spGetEnrolledCourseListByInstructor";
SqlCommand myCommand = new SqlCommand(callProcedure, myConnection);
myCommand.CommandType = CommandType.StoredProcedure;
myCommand.Parameters.AddWithValue("@id", id);
myConnection.Open();
using (SqlDataReader myDataReader = myCommand.ExecuteReader())
{
if (myDataReader.HasRows)
{
myCourseList = new CourseList();
while (myDataReader.Read())
{
myCourseList.Add(FillRecord(myDataReader));
}
}
myDataReader.Close();
}
myConnection.Close();
}
return myCourseList;
}
public void AddCourse(CourseList <C> course)
{
CourseList.Add(course);
}
private void ExecuteSearch(object parameter)
{
String QueryBaseAddition = "";
String dynamic_query_part = "";
foreach (var v in text_criteria)
{
if (v.isChecked)
{
if (dynamic_query_part == "")
{
dynamic_query_part = dynamic_query_part + v.representation + " LIKE '%" + v.input + "%'";
}
else
{
dynamic_query_part = dynamic_query_part + " AND " + v.representation + " LIKE '%" + v.input + "%'";
}
}
}
foreach (var v in list_criteria)
{
if (v.isChecked)
{
bool used = false;
if (v.representation == "Läsperiod" && v.Selected != "")
{
QueryBaseAddition += "JOIN Läsperioder USING (Kurskod) ";
used = true;
}
if (v.representation == "Specialisering" && v.Selected != "")
{
QueryBaseAddition += "JOIN Specialiseringar USING (Kurskod) ";
used = true;
}
if (dynamic_query_part == "" && used)
{
dynamic_query_part = dynamic_query_part + v.representation + " LIKE '%" + v.Selected + "%'";
}
else if (used || v.representation == "Poängtyp")
{
dynamic_query_part = dynamic_query_part + " AND " + v.representation + " LIKE '%" + v.Selected + "%'";
}
}
}
foreach (var v in Interval_criteria)
{
if (v.isChecked)
{
String lower = v.LowerBounds.ToString().Replace(',', '.');
String upper = v.UpperBounds.ToString().Replace(',', '.');
if (dynamic_query_part == "")
{
dynamic_query_part = dynamic_query_part + v.representation + " >= " + lower + " AND " + v.representation + " <= " + upper;
}
else
{
dynamic_query_part = dynamic_query_part + " AND " + v.representation + " >= " + lower + " AND " + v.representation + " <= " + upper;
}
}
}
CourseList.Clear();
String query = "SELECT DISTINCT Kurskod, Antal_poäng, Poängtyp, Kursnamn, Beskrivning, Representant_email FROM spec_course_info " + QueryBaseAddition + " WHERE " + dynamic_query_part + ";";
if (dynamic_query_part != "")
{
foreach (var v in PerformDatabaseCourseAccess(query))
{
CourseList.Add(v);
}
}
}
