public static bool AddToTimetable(int courseId)
{
using (var context = new Classmaister5000Entities())
{
var course = context.Courses.Find(courseId);
ICollection <Timetable> records = context.Timetables.ToList();
ICollection <Course> courses = new List <Course>();
foreach (var item in records)
{
courses.Add(context.Courses.Where(c => c.Id == item.Course_Id).First());
}
bool exists = false;
Course changeThis = null;
foreach (var item in courses)
{
if (item.Subject_Id == course.Subject_Id)
{
exists = true;
changeThis = item;
}
}
if (!exists)
{
int?id = context.Timetables.Max(i => (int?)i.Id) + 1;
if (id == null)
{
id = 0;
}
TimetableModel record = new TimetableModel();
record.UserId = GetUserId;
record.CourseId = courseId;
record.Id = (int)id + 1;
context.Timetables.Add(TimetableMapper.ModelToEntity(record));
context.SaveChanges();
}
else
{
var changeThisPlease = context.Timetables.Where(t => t.Course_Id == changeThis.Id).First();
changeThisPlease.Course_Id = courseId;
context.Entry(changeThisPlease).State = System.Data.Entity.EntityState.Modified;
context.SaveChanges();
}
}
return(true);
}
public void GetCoursesFromLoggedInUsers()
{
CourseModel[] TempMonday = new CourseModel[6];
CourseModel[] TempTuesday = new CourseModel[6];
CourseModel[] TempWednesday = new CourseModel[6];
CourseModel[] TempThursday = new CourseModel[6];
CourseModel[] TempFriday = new CourseModel[6];
CourseModel[] TempSaturday = new CourseModel[6];
CourseModel[] TempSunday = new CourseModel[6];
using (var context = new Classmaister5000Entities())
{
var records = TimetableMapper.EntityCollectionToModelCollection(context.Timetables.Where(c => c.User_Id == UIRepository.Instance.CurrentClientId).ToList());
List <CourseModel> courses = new List <CourseModel>();
//for (int i = 0; i < records.Count; i++)
//{
// courses.Add(records[i].Course);
//}
foreach (var record in records)
{
courses.Add(record.Course);
}
foreach (var course in courses)
{
switch (course.Day_Id)
{
case 1:
TempMonday[SelectIndex(course)] = course;
break;
case 2:
TempTuesday[SelectIndex(course)] = course;
break;
case 3:
TempWednesday[SelectIndex(course)] = course;
break;
case 4:
TempThursday[SelectIndex(course)] = course;
break;
case 5:
TempFriday[SelectIndex(course)] = course;
break;
case 6:
TempSaturday[SelectIndex(course)] = course;
break;
case 7:
TempSunday[SelectIndex(course)] = course;
break;
default: throw new Exception("hiba");
}
}
MondayCourses = TempMonday;
TuesdayCourses = TempTuesday;
WednesdayCourses = TempWednesday;
ThursdayCourses = TempThursday;
FridayCourses = TempFriday;
SaturdayCourses = TempSaturday;
SundayCourses = TempSunday;
}
}
