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");
}
