public ActionResult _deleteFormData <T>(T saveObj) { ActionResult ActionResult; _dbContext = getDbContext(); try { _dbContext.Entry(saveObj).State = EntityState.Deleted; _dbContext.SaveChanges(); ActionResult = new ActionResult() { State = true, Data = saveObj }; } catch (Exception ex) { ActionResult = new ActionResult() { State = false, Data = ex.Message }; } return(ActionResult); }
public ActionResult _saveFormData <T>(T saveObj, bool generatedValues = false) { ActionResult ActionResult; try { _dbContext = getDbContext(); var _db = _dbContext.Set(saveObj.GetType()); if (generatedValues) { Object modelObj = Activator.CreateInstance(saveObj.GetType()); MethodInfo methodInfo = saveObj.GetType().GetMethod("GetId"); dynamic result = methodInfo.Invoke(modelObj, new object[] { saveObj }); saveObj = result; } _db.Add(saveObj); _dbContext.SaveChanges(); ActionResult = new ActionResult() { State = true, Data = saveObj }; } catch (Exception ex) { ActionResult = new ActionResult() { State = false, Data = ex.Message }; } return(ActionResult); }
public ActionResult _getFormData(Type modelType, string Type) { ActionResult ActionResult; try { _dbContext = getDbContext(); Object modelObj = Activator.CreateInstance(modelType); MethodInfo methodInfo = modelType.GetMethod("GetFormData"); dynamic result = methodInfo.Invoke(modelObj, new object[] { _dbContext, Type }); ActionResult = new ActionResult() { State = true, Data = result }; } catch (Exception ex) { ActionResult = new ActionResult() { State = false, Data = ex.Message }; } return(ActionResult); }
protected override void Seed(TimeTable_App.Global.TimeTableDbContext context) { // Adding Forms context.AppForms.Add(new AppFormsModel() { FormId = 1, FormName = "Lecturers", FormDesc = "Manage Lecturers", FormController = "LecturersForm", Status = "A" }); context.AppForms.Add(new AppFormsModel() { FormId = 2, FormName = "Subjects", FormDesc = "Manage Lecturers", FormController = "SubjectsForm", Status = "A" }); context.AppForms.Add(new AppFormsModel() { FormId = 3, FormName = "Students", FormDesc = "Manage Lecturers", FormController = "StudentsForm", Status = "A" }); context.AppForms.Add(new AppFormsModel() { FormId = 4, FormName = "Tags", FormDesc = "Manage Tags", FormController = "TagsForm", Status = "A" }); context.AppForms.Add(new AppFormsModel() { FormId = 5, FormName = "Locations", FormDesc = "Manage Lecturers", FormController = "LocationsForm", Status = "A" }); context.AppForms.Add(new AppFormsModel() { FormId = 6, FormName = "Statistics", FormDesc = "Manage Statistics", FormController = "StatisticsForm", Status = "A" }); context.AppForms.Add(new AppFormsModel() { FormId = 7, FormName = "Working D and H", FormDesc = "Working Days and Time", FormController = "WorkingDayTimeForm", Status = "A" }); context.AppForms.Add(new AppFormsModel() { FormId = 8, FormName = "Time Table", FormDesc = "Manage Timetable", FormController = "TimeTableForm", Status = "A" }); // Adding Sub Forms context.AppSubForms.Add(new AppSubFormsModel() { SubFormName = "Year And Semester", SubFormDesc = "Manage ASY ", SubFormController = "ASYSubForm", Status = "A", FormId = 3 }); context.AppSubForms.Add(new AppSubFormsModel() { SubFormName = "Programme", SubFormDesc = "Manage Programme ", SubFormController = "ProgrammeSubForm", Status = "A", FormId = 3 }); context.AppSubForms.Add(new AppSubFormsModel() { SubFormName = "Groups", SubFormDesc = "Manage Groups", SubFormController = "GroupsSubForm", Status = "A", FormId = 3 }); context.AppSubForms.Add(new AppSubFormsModel() { SubFormName = "Group ID", SubFormDesc = "Manage Group ID", SubFormController = "GroupIDSubForm", Status = "A", FormId = 3 }); context.AppSubForms.Add(new AppSubFormsModel() { SubFormName = "Sub Group ID", SubFormDesc = "Manage Sub Group ID", SubFormController = "SubGroupIDSubForm", Status = "A", FormId = 3 }); context.AppSubForms.Add(new AppSubFormsModel() { SubFormName = "Rooms With Tags", SubFormDesc = "Rooms With Tags", SubFormController = "RoomsWithTagsSubForm", Status = "A", FormId = 8 }); context.AppSubForms.Add(new AppSubFormsModel() { SubFormName = "Rooms for a Subject", SubFormDesc = "Rooms for a Subject", SubFormController = "RoomsForASubjectSubForm", Status = "A", FormId = 8 }); context.AppSubForms.Add(new AppSubFormsModel() { SubFormName = "Rooms for a Lecturer", SubFormDesc = "Rooms for a Lecturer", SubFormController = "RoomsforaLecturerSubForm", Status = "A", FormId = 8 }); context.AppSubForms.Add(new AppSubFormsModel() { SubFormName = "Rooms for a SubGroup", SubFormDesc = "Rooms for a SubGroup", SubFormController = "RoomsforaSubGroupSubForm", Status = "A", FormId = 8 }); context.AppSubForms.Add(new AppSubFormsModel() { SubFormName = "Rooms for a Time Not Reserved", SubFormDesc = "Rooms for a Time Not Reserved", SubFormController = "RoomsforTimeNotReservedSubForm", Status = "A", FormId = 8 }); context.AppSubForms.Add(new AppSubFormsModel() { SubFormName = "Rooms for Consective Session", SubFormDesc = "Rooms for Consective Session", SubFormController = "RoomsforConsectiveSessionSubForm", Status = "A", FormId = 8 }); context.AppSubForms.Add(new AppSubFormsModel() { SubFormName = "Rooms for Session", SubFormDesc = "RoomsforSession", SubFormController = "RoomsforSessionSubForm", Status = "A", FormId = 8 }); context.AppSubForms.Add(new AppSubFormsModel() { SubFormName = "Buildings", SubFormDesc = "Manage Buildings", SubFormController = "BuildingsSubForm", Status = "A", FormId = 5 }); context.AppSubForms.Add(new AppSubFormsModel() { SubFormName = "Rooms", SubFormDesc = "Manage Rooms", SubFormController = "RoomsSubForm", Status = "A", FormId = 5 }); context.AppSubForms.Add(new AppSubFormsModel() { SubFormName = "Lecturers Statistics", SubFormDesc = "Lecturers Statistics", SubFormController = "LecStatisticsSubForm", Status = "A", FormId = 6 }); context.AppSubForms.Add(new AppSubFormsModel() { SubFormName = "Subjects Statistics", SubFormDesc = "Subjects Statistics", SubFormController = "SubStatisticsSubForm", Status = "A", FormId = 6 }); context.AppSubForms.Add(new AppSubFormsModel() { SubFormName = "Students Statistics", SubFormDesc = "Students Statistics", SubFormController = "StuStatisticsSubForm", Status = "A", FormId = 6 }); context.AppSubForms.Add(new AppSubFormsModel() { SubFormName = "Working Days", SubFormDesc = "Working Days", SubFormController = "WorkingDaySubForm", Status = "A", FormId = 7 }); context.AppSubForms.Add(new AppSubFormsModel() { SubFormName = "Time Slots", SubFormDesc = "Time Slots", SubFormController = "TimeSlotSubForm", Status = "A", FormId = 7 }); context.AppSubForms.Add(new AppSubFormsModel() { SubFormName = "Not Available Time Of Lecturer", SubFormDesc = "Not Available Time Of Lecturer", SubFormController = "NATLectureSubForm", Status = "A", FormId = 8 }); context.AppSubForms.Add(new AppSubFormsModel() { SubFormName = "Consective Sessions", SubFormDesc = "Consective Sessions", SubFormController = "ConsectiveSessionsSubForm", Status = "A", FormId = 8 }); context.AppSubForms.Add(new AppSubFormsModel() { SubFormName = "Not Overlap Sessions", SubFormDesc = "Not Overlap Sessions", SubFormController = "NOSSubForm", Status = "A", FormId = 8 }); context.AppSubForms.Add(new AppSubFormsModel() { SubFormName = "Parallel Sessions", SubFormDesc = "Parallel Sessions", SubFormController = "ParallelSessionsSubForm", Status = "A", FormId = 8 }); context.AppSubForms.Add(new AppSubFormsModel() { SubFormName = "Sessions", SubFormDesc = "Sessions", SubFormController = "SessionsSubForm", Status = "A", FormId = 8 }); // Adding Faculties [Kusal Perera] context.Faculties.Add(new FacultyModel() { FacultyName = "Computing", FacultyDesc = "Computing Faculty" }); context.Faculties.Add(new FacultyModel() { FacultyName = "Engineering", FacultyDesc = "Engineering Faculty" }); context.Faculties.Add(new FacultyModel() { FacultyName = "Business", FacultyDesc = "Business Faculty" }); // Adding Departments [Kusal Perera] context.Departments.Add(new DepartmentModel() { DepartmentName = "SE Department", DepartmentDesc = "SE Department", FacultyId = 1 }); context.Departments.Add(new DepartmentModel() { DepartmentName = "IT Department", DepartmentDesc = "IT Department", FacultyId = 1 }); context.Departments.Add(new DepartmentModel() { DepartmentName = "Cyber Department", DepartmentDesc = "Cyber Department", FacultyId = 1 }); // Adding Centers [Kusal Perera] context.Centers.Add(new CenterModel() { CenterName = "Malabe", CenterDesc = "Malabe Center" }); context.Centers.Add(new CenterModel() { CenterName = "Metro", CenterDesc = "Metro Center" }); context.Centers.Add(new CenterModel() { CenterName = "Matara", CenterDesc = "Matara Center" }); context.Centers.Add(new CenterModel() { CenterName = "Kandy", CenterDesc = "Kandy Center" }); // Adding Buildings [Kusal Perera] context.Buildings.Add(new BuildingModel() { BuildingName = "New Building", BuildingDesc = "New Building" }); context.Buildings.Add(new BuildingModel() { BuildingName = "D-block", BuildingDesc = "D-block" }); // Adding EmployeeLevels [Kusal Perera] context.EmployeeLevels.Add(new EmployeeLevelModel() { EmployeeLevelName = "Professor", EmployeeLevelDesc = "Professor" }); context.EmployeeLevels.Add(new EmployeeLevelModel() { EmployeeLevelName = "Assistant Professor", EmployeeLevelDesc = "Assistant Professor" }); context.EmployeeLevels.Add(new EmployeeLevelModel() { EmployeeLevelName = "Senior Lecturer(HG)", EmployeeLevelDesc = "Senior Lecturer(HG)" }); context.EmployeeLevels.Add(new EmployeeLevelModel() { EmployeeLevelName = "Senior Lecturer", EmployeeLevelDesc = "Senior Lecturer" }); context.EmployeeLevels.Add(new EmployeeLevelModel() { EmployeeLevelName = "Lecturer", EmployeeLevelDesc = "Lecturer" }); context.EmployeeLevels.Add(new EmployeeLevelModel() { EmployeeLevelName = "Assistant Lecturer", EmployeeLevelDesc = "Assistant Lecturer" }); context.EmployeeLevels.Add(new EmployeeLevelModel() { EmployeeLevelName = "Instructors", EmployeeLevelDesc = "Instructors" }); // Adding Working Days & Hours [Dimuthu Abeysinghe] context.WorkingDays.Add(new WorkingDaySubFormModel() { StrWorkingDays = "Sunday", WorkHourPerDay = 0, status = "I" }); context.WorkingDays.Add(new WorkingDaySubFormModel() { StrWorkingDays = "Monday", WorkHourPerDay = 0, status = "I" }); context.WorkingDays.Add(new WorkingDaySubFormModel() { StrWorkingDays = "Tuesday", WorkHourPerDay = 0, status = "I" }); context.WorkingDays.Add(new WorkingDaySubFormModel() { StrWorkingDays = "Wednesday", WorkHourPerDay = 0, status = "I" }); context.WorkingDays.Add(new WorkingDaySubFormModel() { StrWorkingDays = "Thursday", WorkHourPerDay = 0, status = "I" }); context.WorkingDays.Add(new WorkingDaySubFormModel() { StrWorkingDays = "Friday", WorkHourPerDay = 0, status = "I" }); context.WorkingDays.Add(new WorkingDaySubFormModel() { StrWorkingDays = "Saturday", WorkHourPerDay = 0, status = "I" }); // Adding Subjects context.Subjects.Add(new SubjectsFormModel() { SubjectCode = "IT1010", SubjectName = "IP", Year = "Y1", Semester = "S1", LectureHours = 2, LabHours = 0, TuteHours = 2, EvaluationHours = 0 }); context.Subjects.Add(new SubjectsFormModel() { SubjectCode = "IT1020", SubjectName = "SPM", Year = "Y1", Semester = "S2", LectureHours = 2, LabHours = 0, TuteHours = 2, EvaluationHours = 2 }); // Adding Consective Sessions context.ConsectiveSessions.Add(new ConsectiveSessionsModel() { Year = "Y1", Semester = "S1", Subject = "OOP", Lecture = "YES", Tutorial = "YES", Lab = "NO" }); }
private TimeTableDbContext getDbContext() { //if (_dbContext == null) { _dbContext = new TimeTableDbContext(); } _dbContext = new TimeTableDbContext(); return(_dbContext); }