private void PhoneForm_Load(object sender, EventArgs e)
{
IntPtr pIcon = Resources.phone.GetHicon();
Icon = Icon.FromHandle(pIcon);
textTimer = new Timer();
textTimer.Interval = 1000;
textTimer.Tick += new EventHandler(textTimer_Tick);
Task.Run(() => {
sRepo = new StudentRepo(ApiEndpoint);
tRepo = new TeacherRepo(ApiEndpoint);
Students = sRepo.all();
Teachers = tRepo.all();
var sItems = PhoneItem.FromStudentList(Students);
var tItems = PhoneItem.FromTeacherList(Teachers);
PhoneItems = new List <PhoneItem>();
PhoneItems.AddRange(sItems);
PhoneItems.AddRange(tItems);
PhoneItems = PhoneItems.OrderBy(pi => pi.Name).ToList();
});
}
public void GetAllTeacherRecordsFromDbContextNotNull()
{
var dbContext = new SQLConnType(@"localhost\SQLEXPRESS14", "CSG", "sa", "@1Mops4moa");
var sysUnderTest = new TeacherRepo(dbContext);
var result = sysUnderTest.GetAllAsync();
Assert.NotNull(result);
}
public void GetDataFromDb()
{
Groups = GroupRepo.GetGroupsFromDb();
Teachers = TeacherRepo.GetTeachersFromDb();
Rooms = RoomRepo.GetRoomsFromDb();
GroupSubjects = GroupSubjectRepo.GetGroupSubjectsFromDb();
TeacherSubjects = TeacherSubjectRepo.GetTeacherSubjectsFromDb();
Subjects = SubjectRepo.GetSubjectsFromDb();
}
public void GetDataFromXML()
{
Groups = GroupRepo.DeserializeArray("../../Data/groups.xml").ToList();
Teachers = TeacherRepo.DeserializeArray("../../Data/teachers.xml").ToList();
Rooms = RoomRepo.DeserializeArray("../../Data/rooms.xml").ToList();
GroupSubjects = GroupSubjectRepo.DeserializeArray("../../Data/group_subjects.xml").ToList();
TeacherSubjects = TeacherSubjectRepo.DeserializeArray("../../Data/teacher_subjects.xml").ToList();
Subjects = SubjectRepo.DeserializeArray("../../Data/subjects.xml").ToList();
}
public void GetAllTeacherRecordsFromDbContextGreaterThanZeroRecords()
{
var dbContext = new SQLConnType(@"localhost\SqlExpress14", "CSG", "sa", "@1Mops4moa");
var sysUnderTest = new TeacherRepo(dbContext);
var result = sysUnderTest.GetAllAsync();
Assert.True(result.Count > 0);
}
public static CourseRosterViewModel GetCourseRoster(int courseId)
{
CourseRosterViewModel crvm = new CourseRosterViewModel
{
CourseRosterData = TeacherRepo.GetCourseRosterData(courseId),
ListForReturnAddStudentSearchResults = new List <AddStudentSearchResult>()
};
return(crvm);
}
public DepartmentList(string apiEndpoint)
{
InitializeComponent();
ApiEndpoint = apiEndpoint;
dRepo = new DepartmentRepo(ApiEndpoint);
dhRepo = new DepartmentHeadRepo(ApiEndpoint);
tRepo = new TeacherRepo(ApiEndpoint);
}
public TeacherList(string apiEndpoint)
{
ApiEndpoint = apiEndpoint;
InitializeComponent();
tRepo = new TeacherRepo(ApiEndpoint);
pRepo = new PositionRepo(ApiEndpoint);
expRepo = new ExperienceRepo(ApiEndpoint);
eduRepo = new EducationRepo(ApiEndpoint);
adRepo = new AcademicDegreeRepo(ApiEndpoint);
arRepo = new AcademicRankRepo(ApiEndpoint);
}
public TeacherCardsList(string apiEndpoint)
{
InitializeComponent();
ApiEndpoint = apiEndpoint;
tcRepo = new TeacherCardRepo(ApiEndpoint);
tciRepo = new TeacherCardItemRepo(ApiEndpoint);
dRepo = new DepartmentRepo(ApiEndpoint);
tRepo = new TeacherRepo(ApiEndpoint);
pyrhRepo = new PositionYearRateHoursRepo(ApiEndpoint);
}
public List <AddStudentSearchModel> Post(AddStudentSearchModel model)
{
var results = TeacherRepo.AddStudentSearch(model.LastName, model.GradeLevelKey);
return(results.Select(x => new AddStudentSearchModel()
{
FirstName = x.FirstName,
LastName = x.LastName,
GradeLevelKey = x.GradeLevelKey,
GradeLevelName = x.GradeLevelName
}).ToList());
}
public PlanVsCardList(string apiEndpoint)
{
InitializeComponent();
ApiEndpoint = apiEndpoint;
sRepo = new StudentRepo(ApiEndpoint);
lpRepo = new LearningPlanRepo(ApiEndpoint);
lpdRepo = new LearningPlanDisciplineRepo(ApiEndpoint);
lpdsRepo = new LearningPlanDisciplineSemesterRepo(ApiEndpoint);
tciRepo = new TeacherCardItemRepo(ApiEndpoint);
tRepo = new TeacherRepo(ApiEndpoint);
}
public bool UpdateTeacher(Teacher teacher)
{
try
{
TeacherRepo teacherRepo = new TeacherRepo();
bool result = teacherRepo.UpdateTeacher(teacher);
return(result);
}
catch (Exception)
{
throw;
}
}
public MarkList(string apiEndpoint)
{
ApiEndpoint = apiEndpoint;
InitializeComponent();
mRepo = new MarkRepo(ApiEndpoint);
mtRepo = new MarkTeacherRepo(ApiEndpoint);
sRepo = new StudentRepo(ApiEndpoint);
lpRepo = new LearningPlanRepo(ApiEndpoint);
lpdRepo = new LearningPlanDisciplineRepo(ApiEndpoint);
lpdsRepo = new LearningPlanDisciplineSemesterRepo(ApiEndpoint);
mtypeRepo = new MarkTypeRepo(ApiEndpoint);
mtoRepo = new MarkTypeOptionRepo(ApiEndpoint);
tRepo = new TeacherRepo(ApiEndpoint);
}
public void InsertTeacherRecord_Succeed()
{
var dbContext = new SQLConnType(@"localhost\SqlExpress14", "CSG", "sa", "@1Mops4moa");
var sysUnderTest = new TeacherRepo(dbContext);
var teacher = new Teacher(Guid.NewGuid().ToString());
teacher.Name = "Johan";
teacher.Surname = "Potgieter";
teacher.DateRegistered = DateTime.Now.Date;
sysUnderTest.InsertEntityAsync(teacher);
var result = sysUnderTest.GetAllAsync();
Assert.True(result.Count > 0);
}
public static void GenerateTeachers()
{
// teachers
Teacher t1 = TeacherRepo.CreateTeacher("Квасниця");
TeacherRepo.AddToDb(t1);
Teacher t2 = TeacherRepo.CreateTeacher("Пелюшкевич");
TeacherRepo.AddToDb(t2);
Teacher t3 = TeacherRepo.CreateTeacher("Притула");
TeacherRepo.AddToDb(t3);
Teacher t4 = TeacherRepo.CreateTeacher("Рикалюк");
TeacherRepo.AddToDb(t4);
Teacher t5 = TeacherRepo.CreateTeacher("Жировецький");
TeacherRepo.AddToDb(t5);
Teacher t6 = TeacherRepo.CreateTeacher("Стойко");
TeacherRepo.AddToDb(t6);
Teacher t7 = TeacherRepo.CreateTeacher("Костів");
TeacherRepo.AddToDb(t7);
Teacher t8 = TeacherRepo.CreateTeacher("Сибіль");
TeacherRepo.AddToDb(t8);
Teacher t9 = TeacherRepo.CreateTeacher("Літинський");
TeacherRepo.AddToDb(t9);
Teacher t10 = TeacherRepo.CreateTeacher("Клакович");
TeacherRepo.AddToDb(t10);
Teacher t11 = TeacherRepo.CreateTeacher("Галамага");
TeacherRepo.AddToDb(t11);
Teacher t12 = TeacherRepo.CreateTeacher("Дреботій");
TeacherRepo.AddToDb(t12);
Teacher t13 = TeacherRepo.CreateTeacher("Заболоцький");
TeacherRepo.AddToDb(t13);
Teacher t14 = TeacherRepo.CreateTeacher("Малець");
TeacherRepo.AddToDb(t14);
}
public bool RegisterTeacher(Teacher teacher, string Password, string SecurityQuestion, string SecurityAnswer)
{
try
{
if (teacher != null)
{
if (ValidateTeacher(teacher))
{
UserRepo userRepo = new UserRepo();
TeacherRepo teacherRepo = new TeacherRepo();
User user = new User {
UserID = teacher.UserID, Password = Password, Role = "teacher", SecurityQuestion = SecurityQuestion, SecurityAnswer = SecurityAnswer
};
if (teacher.IsAdmin)
{
user.Role = "admin";
}
if (userRepo.InsertUser(user))
{
if (teacherRepo.InsertTeacher(teacher))
{
return(true);
}
else
{
userRepo.DeleteUser(user);
throw new PrometheusException("Teacher registration failed");
}
}
}
else
{
throw new PrometheusException("Teacher registration failed");
}
}
}
catch (Exception)
{
throw;
}
return(false);
}
public static CourseModel GetCourseInfo(int courseId)
{
TeacherRepo teacherRepo = new TeacherRepo();
CourseModel courseModel = new CourseModel();
foreach (var x in teacherRepo.GetCourseInfo(courseId))
{
courseModel.CourseName = x.CourseName;
courseModel.CourseDescription = x.CourseDescription;
courseModel.EndDate = x.EndDate;
courseModel.GradeLevel = x.GradeLevel;
courseModel.IsArchived = x.IsArchived;
courseModel.StartDate = x.StartDate;
courseModel.SubjectId = x.SubjectId;
courseModel.UserId = x.UserId;
courseModel.SubjectName = teacherRepo.GetSubjectNameSproc(x.SubjectId);
courseModel.CourseId = x.CourseId;
}
return(courseModel);
}
public static TeacherModel GetTeacherDashboardInfo(int userId)
{
TeacherRepo teacherRepo = new TeacherRepo();
TeacherModel teacherModel = new TeacherModel();
teacherModel.CourseList = new List <TeacherCourses>();
//TeacherCourses teacherCourses = new TeacherCourses();
teacherModel.CurrentCourses = teacherRepo.GetClassesByTeacherId(userId).Count(x => x.IsArchived = true);
teacherModel.ArchivedCourses = teacherRepo.GetClassesByTeacherId(userId).Count(x => x.IsArchived = false);
teacherModel.UserId = userId;
foreach (var x in teacherRepo.GetClassesByTeacherId(userId))
{
TeacherCourses tempTC = new TeacherCourses();
tempTC.CourseName = x.CourseName;
tempTC.NumOfStudentsInCourse = teacherRepo.GetCurrentStudentCountInCourse(x.CourseId);
tempTC.CourseId = x.CourseId;
teacherModel.CourseList.Add(tempTC);
}
return(teacherModel);
}
public Teacher GetTeacher(string userID)
{
try
{
TeacherRepo teacherRepo = new TeacherRepo();
List <Teacher> teachers = teacherRepo.GetTeachers();
if (teachers.Any())
{
Teacher result = teachers.SingleOrDefault(item => item.UserID == userID);
return(result);
}
else
{
throw new PrometheusException("No Teachers Found");
}
}
catch (Exception)
{
throw;
}
}
public bool AddTeaches(Course course, int teacherID)
{
try
{
if (course != null)
{
TeacherRepo userRepo = new TeacherRepo();
TeachesRepo teachesRepo = new TeachesRepo();
bool isAdded = teachesRepo.InsertTeaches(teacherID, course.CourseID);
if (isAdded)
{
return(true);
}
}
}
catch (Exception)
{
throw;
}
return(false);
}
public List <Teacher> GetTeachers()
{
List <Teacher> teacherList;
try
{
teacherList = new TeacherRepo().GetTeachers();
User user = new User();
if (teacherList.Any())
{
return(teacherList);
}
else
{
throw new PrometheusException("No Teachers Found!");
}
}
catch (Exception)
{
throw;
}
}
public List <Teacher> GetTeachersByUserID(string userID)
{
try
{
TeacherRepo teacherRepo = new TeacherRepo();
List <Teacher> teachers = teacherRepo.GetTeachers();
var result = teachers.Where(item => item.UserID == userID).ToList();
if (result.Any())
{
return(result);
}
else
{
throw new PrometheusException("No Teacher Found!");
}
}
catch (Exception)
{
throw;
}
}
public bool DeleteTeacher(Teacher teacher)
{
try
{
if (teacher != null)
{
TeacherRepo teacherRepo = new TeacherRepo();
if (teacherRepo.DeleteTeacher(teacher))
{
return(true);
}
else
{
throw new PrometheusException("Teacher Deleted");
}
}
}
catch (Exception)
{
throw;
}
return(false);
}
public static List <GradebookModel> GetGradebookData(int courseId)
{
var tempData = TeacherRepo.GetGradebookDataRepo(courseId);
return(tempData);
}
public TeacherController()
{
teacherRepo = new TeacherRepo();
}
