private static void AddNewRowToTimetable(TeachersBookEntities2 ctx, int rowCounter, TimeTables timetabelDb, TtSubjectsRow timetablerow) { try { TimeTableRows newRowDb = new TimeTableRows(); newRowDb.id = Guid.NewGuid(); newRowDb.rowNo = rowCounter; newRowDb.timetable = timetabelDb.id; var startEnd = timetablerow.subjects[0].description.Split('-'); newRowDb.start = startEnd[0].Trim(); newRowDb.end = startEnd.Length > 1 ? startEnd[1].Trim() : ""; ctx.TimeTableRows.Add(newRowDb); } catch (Exception ex) { Console.WriteLine("Error"); } }
private static void AddAllSubjectsOfNewRowToTimetable(TimeTableRows newRow, TeachersBookEntities2 ctx, int rowCounter, TtSubjectsRow timetablerow) { int counter = 0; foreach (var subject in timetablerow.subjects) { if (counter > 1) { TimeTableIItems newTimetableItem = new TimeTableIItems(); newTimetableItem.id = Guid.NewGuid(); newTimetableItem.day = counter; newTimetableItem.type = "subject"; SubjectToTimeTableHours newTimetableItemDetails = new SubjectToTimeTableHours(); newTimetableItemDetails.timetableId = newTimetableItem.id; newTimetableItemDetails.subjectId = Guid.Parse(subject.lesson.id); newRow.TimeTableIItems.Add(newTimetableItem); counter++; } } }