public IActionResult EditStatus(TeacherEditStatusModel shift) { TeacherBusiness shiftBusiness = new TeacherBusiness(); var result = shiftBusiness.EditStatus(shift); return(Ok(result)); }
public IActionResult GetById(int Id) { TeacherBusiness shiftBusiness = new TeacherBusiness(); var result = shiftBusiness.GetById(Id); return(Ok(result)); }
public IActionResult Delete(TeacherDeleteModel shift) { TeacherBusiness shiftBusiness = new TeacherBusiness(); var result = shiftBusiness.Delete(shift); return(Ok(result)); }
public IActionResult Add(AddTeacherModel shift) { TeacherBusiness shiftBusiness = new TeacherBusiness(); var result = shiftBusiness.AddTeacher(shift); return(Ok(result)); }
public IActionResult GetAll() { TeacherBusiness shiftBusiness = new TeacherBusiness(); var result = shiftBusiness.GetAll(); return(Ok(result)); }
public IActionResult GetPaging(BaseCondition <Teacher> condition) { TeacherBusiness shiftBusiness = new TeacherBusiness(); var result = shiftBusiness.GetAllTeacherSearched(condition); return(Ok(result)); }
/// <summary> /// 按部门编号获取教师 /// </summary> /// <param name="departmentId"></param> /// <returns></returns> public IList <TeacherBusiness> GetAllTeacherBusiness(int departmentId) { IList <TeacherBusiness> listTeacherBusiness = new List <TeacherBusiness>(); string sql = @"SELECT Teacher.*, TeacherPosition.TeacherPositionName, TeacherTitle.TeacherTitleName, Specialty.SpecialtyFullName, Department.DepartmentFullName FROM Department INNER JOIN Specialty ON Department.DepartmentId = Specialty.DepartmentId INNER JOIN Teacher ON Department.DepartmentId = Teacher.DepartmentId AND Specialty.SpecialtyId = Teacher.SpecialtyId INNER JOIN TeacherPosition ON Teacher.TeacherPositionId = TeacherPosition.TeacherPositionId INNER JOIN TeacherTitle ON Teacher.TeacherTitleId = TeacherTitle.TeacherTitleId where Teacher.DepartmentId = @DepartmentId"; SqlParameter parameter = new SqlParameter("@DepartmentId", SqlDbType.Int); parameter.Value = departmentId; using (SqlDataReader reader = DBHelper.ExecuteReader(sql, parameter)) { while (reader.Read()) { TeacherBusiness teacherBusiness = new TeacherBusiness(); teacherBusiness.TeacherId = int.Parse(reader["TeacherId"].ToString()); teacherBusiness.DepartmentId = int.Parse(reader["DepartmentId"].ToString()); teacherBusiness.DepartmentFullName = reader["DepartmentFullName"].ToString(); teacherBusiness.SpecialtyId = int.Parse(reader["SpecialtyId"].ToString()); teacherBusiness.SpecialtyFullName = reader["SpecialtyFullName"].ToString(); teacherBusiness.TeacherTitleId = int.Parse(reader["TeacherTitleId"].ToString()); teacherBusiness.TeacherTitleName = reader["TeacherTitleName"].ToString(); teacherBusiness.TeacherPositionId = int.Parse(reader["TeacherPositionId"].ToString()); teacherBusiness.TeacherPositionName = reader["TeacherPositionName"].ToString(); teacherBusiness.TeacherLoginId = reader["TeacherLoginId"].ToString(); teacherBusiness.TeacherLoginPwd = reader["TeacherLoginPwd"].ToString(); teacherBusiness.TeacherNo = reader["TeacherNo"].ToString(); teacherBusiness.TeacherName = reader["TeacherName"].ToString(); teacherBusiness.TeacherGender = reader["TeacherGender"].ToString(); teacherBusiness.TeacherEnabled = bool.Parse(reader["TeacherEnabled"].ToString()); listTeacherBusiness.Add(teacherBusiness); } } return(listTeacherBusiness); }
public void Setup() { _teacher = new TeacherBusiness(); // remove test entry in DB if present using (var db = new SchoolDBContext()) { var selectedTeacher = from t in db.Teachers where t.Username == "TestU" select t; db.Teachers.RemoveRange(selectedTeacher); db.SaveChanges(); } }
public HttpResponseMessage GetTeacher( string calendarYear, [ModelBinder(typeof(Guids))] IEnumerable<Guid> schoolSuperiorId = null, [ModelBinder(typeof(Ints))] IEnumerable<int> schoolClassificationId = null, [ModelBinder(typeof(Ints))] IEnumerable<int> schoolId = null, [ModelBinder(typeof(Ints))] IEnumerable<int> positionId = null, [ModelBinder(typeof(Ints))] IEnumerable<int> courseId = null, [ModelBinder(typeof(Ints))] IEnumerable<int> coursePeriodId = null, [ModelBinder(typeof(Ints))] IEnumerable<int> disciplineId = null, [ModelBinder(typeof(Ints))] IEnumerable<int> teamId = null ) { try { var result = TeacherBusiness.Get(claimData.UserId, claimData.GroupId, calendarYear, schoolSuperiorId, schoolClassificationId, schoolId, positionId,courseId, coursePeriodId, disciplineId, teamId); return Request.CreateResponse(HttpStatusCode.OK, result); } catch (Exception exc) { var logId = LogBusiness.Error(exc); return Request.CreateResponse(HttpStatusCode.InternalServerError, new ErrorModel(logId)); } }
public TeacherController(TeacherBusiness teacheBussiness) { _teacheBusiness = teacheBussiness; }
public TeachersController() { _teacherBusiness = new TeacherBusiness(); }
/// <summary> /// Envia a notificação para os usuários baseados nos filtros e nas permissões do usuário logado /// </summary> /// <param name="userId">Id do usuário logado</param> /// <param name="groupId">Id do gruopo logado</param> /// <param name="entity"></param> /// <returns></returns> public static Guid Save(Guid userId, Guid groupId, Notification.Entity.API.Notification entity) { if (entity.Recipient == null) { throw new NotificationRecipientIsEmptyException(); } if ((entity.Recipient.SystemRecipient == null || !entity.Recipient.SystemRecipient.Any()) && (entity.Recipient.ContributorRecipient == null || !entity.Recipient.ContributorRecipient.Any()) && (entity.Recipient.TeacherRecipient == null || !entity.Recipient.TeacherRecipient.Any())) { throw new NotificationRecipientIsEmptyException(); } var groupRep = new GroupRepository(); var userRep = new UserRepository(); var userSGPRep = new UserSGPRepository(); var groupUser = groupRep.GetById(groupId); var ltUser = new List <Guid>(); if (entity.Recipient.SystemRecipient != null && entity.Recipient.SystemRecipient.Any()) { foreach (var item in entity.Recipient.SystemRecipient) { //pendente de testes if (groupUser.VisionId > 1) { //se não passar Escola, buscar todas as escolas das DRE's selecionadas, e/ou todas que o usuário logado tenha permissão (mesmo se a listagem vier nula) if (!item.AdministrativeUnit.Any()) { item.AdministrativeUnit = SchoolBusiness.GetAUByPermission(userId, groupId, item.AdministrativeUnitSuperior); } //Mesmo se a lista de unidades administrativas vier com valores, dentro do método é preciso garantir que o usuário tenha permissão nelas, por isso executo a verificação novamente dentro dele. ltUser.AddRange(userRep.GetByVisionAll(userId, groupId, item.SystemId, item.GroupId, item.AdministrativeUnitSuperior, item.AdministrativeUnit).Select(u => u.Id)); } else if ((item.AdministrativeUnit != null && item.AdministrativeUnit.Any()) || (item.AdministrativeUnitSuperior != null && item.AdministrativeUnitSuperior.Any())) { if (groupUser.VisionId == 1) { if ((item.AdministrativeUnit != null && item.AdministrativeUnit.Any()) || (item.AdministrativeUnitSuperior != null && item.AdministrativeUnitSuperior.Any())) { ltUser.AddRange(userSGPRep.GetByVisionAdministrator(userId, item.SystemId.First(), item.GroupId, item.AdministrativeUnitSuperior, item.AdministrativeUnit).Select(u => u.Id)); } } //else if(item.AdministrativeUnitSuperior != null && item.AdministrativeUnitSuperior.Any()) // ltUser.AddRange(userRep.GetByVisionAdministrator(userId, item.SystemId.First(), item.GroupId, item.AdministrativeUnitSuperior).Select(u => u.Id)); } else if (item.GroupId != null && item.GroupId.Any()) { if (groupUser.VisionId == 1) { ltUser.AddRange(userRep.GetByVisionAdministrator(userId, item.SystemId.First(), item.GroupId).Select(u => u.Id)); } } else { if (groupUser.VisionId == 1) { ltUser.AddRange(userRep.GetByVisionAdministrator(userId, item.SystemId).Select(u => u.Id)); } } } } if (entity.Recipient.ContributorRecipient != null && entity.Recipient.ContributorRecipient.Any()) { foreach (var item in entity.Recipient.ContributorRecipient) { ltUser.AddRange(ContributorBusiness.Get(userId, groupId, item.Calendar.Name, item.SchoolSuperior, item.SchoolClassification, item.School, item.Position).Select(u => u.Id)); } } if (entity.Recipient.TeacherRecipient != null && entity.Recipient.TeacherRecipient.Any()) { foreach (var item in entity.Recipient.TeacherRecipient) { ltUser.AddRange(TeacherBusiness.Get(userId, groupId, item.Calendar.Name, item.SchoolSuperior, item.SchoolClassification, item.School, item.Position, item.Course, item.CoursePeriod, item.Discipline, item.Team).Select(u => u.Id)); } } if (ltUser != null && ltUser.Any()) { ltUser = ltUser.Distinct().ToList(); return(Save(entity, ltUser, userId)); } else { throw new NotificationWithoutRecipientException(); } }
static void selectTeacher(int id) { TeacherBusiness teacherBusiness = new TeacherBusiness(); teacherBusiness.SelectTeacher(id); }
static void addTeacher() { TeacherBusiness teacherBusiness = new TeacherBusiness(); teacherBusiness.AddTeacher(111, "YJX", "computer", "root"); }