private void LoginButtonClicked(object sender, RoutedEventArgs routedEventArgs)
{
UpdateActivities();
try
{
ProfessionalPracticesContext professionalPracticesContext = new ProfessionalPracticesContext();
UnitOfWork unitOfWork = new UnitOfWork(professionalPracticesContext);
if (!IsAccount(unitOfWork))
{
if (IsValidAccountPassword())
{
if (IsActiveUser(unitOfWork))
{
OpenWindowUser();
}
else
{
MessageBox.Show("La cuenta no esta activa", "Cuenta inactiva", MessageBoxButton.OK, MessageBoxImage.Exclamation);
}
}
else
{
MessageBox.Show("Contraseña incorrecta", "Login Fallido", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
else
{
MessageBox.Show("Usuario incorrecto", "Login Fallido", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
catch (EntityException)
{
MessageBox.Show("No se pudo Iniciar sesión. Intente más tarde", "Inicio de sesión Fallido", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
private void LoadActiveCoordinator()
{
ProfessionalPracticesContext professionalPracticesContext = new ProfessionalPracticesContext();
UnitOfWork unitOfWork = new UnitOfWork(professionalPracticesContext);
try
{
Coordinator retrievedCoordinator = unitOfWork.Coordinators.GetActiveCoordinator();
if (retrievedCoordinator != null)
{
Coordinator = retrievedCoordinator;
PrintUserGender();
}
else
{
MessageBox.Show("Error. No existe ningún coordinador activo en la base de datos.");
GoBackToCoordinatorConsultation();
}
}
catch (SqlException)
{
MessageBox.Show("No hay conexión a la base de datos. Intente más tarde");
GoBackToCoordinatorConsultation();
}
finally
{
unitOfWork.Dispose();
}
}
private void TryRegisterNewCoordinator()
{
ProfessionalPracticesContext professionalPracticesContext = new ProfessionalPracticesContext();
UnitOfWork unitOfWork = new UnitOfWork(professionalPracticesContext);
try
{
if (!CoordinatorIsAlreadyRegistered(unitOfWork))
{
if (!ThereIsAnActiveCoordinator(unitOfWork))
{
HashAccountPassword();
RegisterNewCoordinator(unitOfWork);
MessageBox.Show("Coordinador registrado exitosamente");
GoBackToManagerMenu();
}
else
{
MessageBox.Show("Ya existe un coordinador activo en el sistema.");
}
}
else
{
MessageBox.Show("Este coordinador ya está registrado");
}
}catch (EntityException)
{
MessageBox.Show("Sin conexión a bd");
}
finally
{
unitOfWork.Complete();
unitOfWork.Dispose();
}
}
private void GeneratePartialReportButtonClicked(object sender, RoutedEventArgs routedEventArgs)
{
ProfessionalPracticesContext professionalPracticesContext = new ProfessionalPracticesContext();
UnitOfWork unitOfWork = new UnitOfWork(professionalPracticesContext);
try
{
Assignment assignment = unitOfWork.Assignments.FindFirstOccurence(Assignment => Assignment.Enrollment == _practicionerEnrollment);
if (assignment != null)
{
Practicioner practicioner = unitOfWork.Practicioners.FindFirstOccurence(Practicioner => Practicioner.Enrollment.Equals(_practicionerEnrollment));
if (practicioner.Group != null)
{
IEnumerable <ActivityPracticioner> activities = unitOfWork.ActivityPracticioners.Find(ActivityPracticioner => ActivityPracticioner.Enrollment.Equals(_practicionerEnrollment) &&
ActivityPracticioner.Activity.ActivityType == ActivityType.PartialReport && ActivityPracticioner.Activity.ActivityStatus == ActivityStatus.ACTIVE);
if (IENumerableHasActivityPracticioners(activities))
{
IEnumerable <PartialReport> partialReports = unitOfWork.PartialReports.Find(PartialReport => PartialReport.Enrollment.Equals(practicioner.Enrollment));
if (IENumberPartialRepot(partialReports) < 2)
{
PartialReportGeneration partialReportGeneration = new PartialReportGeneration();
if (partialReportGeneration.InitializePartialReportGeneration(_practicionerEnrollment))
{
partialReportGeneration.Show();
Close();
}
else
{
MessageBox.Show("No hay conexión a la base de datos. Intente más tarde", "Generación Fallida", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
else
{
MessageBox.Show("No puede generar más de dos reportes parciales", "No se puede acceder", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
else
{
MessageBox.Show("No tiene activas actividades de reporte parcial. Contacte a su profesor", "Consulta Fallida", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
else
{
MessageBox.Show("No esta asignado a un grupo Contacte a su coordinador", "Consulta Fallida", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
else
{
MessageBox.Show("No tiene un proyecto asignado. Contacte a su coordinador", "Consulta Fallida", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
catch (EntityException)
{
MessageBox.Show("No hay conexión a la base de datos. Intente más tarde", "Generación Fallida", MessageBoxButton.OK, MessageBoxImage.Error);
}
finally
{
unitOfWork.Dispose();
}
}
private void RequestProject(object sender, RoutedEventArgs routedEventArgs)
{
ProfessionalPracticesContext professionalPracticesContext = new ProfessionalPracticesContext();
UnitOfWork unitOfWork = new UnitOfWork(professionalPracticesContext);
try
{
bool practicionerHaveAProject = unitOfWork.Practicioners.PracticionerHasActiveProject(_practicionerEnrollment);
IList <Project> projecsAvailableForThosPracticioner = unitOfWork.Projects.GetProjectsAvailableToRequest(_practicionerEnrollment);
int requestMade = unitOfWork.RequestProjects.GetPracticionerRequest(_practicionerEnrollment);
if (practicionerHaveAProject || projecsAvailableForThosPracticioner.Count == 0 || requestMade == 3)
{
MessageBox.Show("Ya has solocitado un proyecto o no hay proyectos disponibles", "Consulta Fallida", MessageBoxButton.OK, MessageBoxImage.Error);
}
else
{
RequestProjects requestProject = new RequestProjects(_practicionerEnrollment);
requestProject.Show();
Close();
}
}
catch (EntityException)
{
MessageBox.Show("No hay conexión a la base de datos. Intente más tarde", "Consulta Fallida", MessageBoxButton.OK, MessageBoxImage.Error);
}
finally
{
unitOfWork.Dispose();
}
}
private void AddActivityToPracticioners()
{
ProfessionalPracticesContext professionalPracticesContext = new ProfessionalPracticesContext();
UnitOfWork unitOfWork = new UnitOfWork(professionalPracticesContext);
try
{
IList <Practicioner> practicioners = unitOfWork.Activities.GetPracticionersToActivity(_group);
int idActivity = unitOfWork.Activities.GetId();
ActivityPracticioner activity = new ActivityPracticioner
{
Qualification = 0,
IdActivity = idActivity,
ActivityPracticionerStatus = ActivityPracticionerStatus.NOTQUALIFIED
};
foreach (Practicioner practicioner in practicioners)
{
activity.Enrollment = practicioner.Enrollment;
unitOfWork.ActivityPracticioners.Add(activity);
unitOfWork.Complete();
}
unitOfWork.Dispose();
}
catch (EntityException)
{
CatchDBException();
}
}
public UnitOfWork(ProfessionalPracticesContext context)
{
_context = context;
Accounts = new Repository <Account>(_context);
Assignments = new Repository <Assignment>(_context);
Coordinators = new CoordinatorRepository(_context);
LinkedOrganizations = new LinkedOrganizationRepository(_context);
Practicioners = new PracticionerRepository(_context);
Projects = new ProjectRepository(_context);
PartialReports = new Repository <PartialReport>(_context);
MonthlyReports = new MonthlyReportRepository(_context);
RequestProjects = new RequestProjectRepository(_context);
ResponsibleProjects = new ResponsibleProjectRepository(_context);
Teachers = new TeacherRepository(_context);
Users = new UserRepository(_context);
States = new StateRepository(_context);
Sectors = new Repository <Sector>(_context);
Phones = new PhoneRepository(_context);
SchedulingActivities = new Repository <SchedulingActivity>(_context);
Groups = new GroupRepository(_context);
Activities = new ActivityRepository(_context);
ActivityPracticioners = new Repository <ActivityPracticioner>(_context);
Documents = new Repository <Document>(_context);
ActivityMades = new Repository <ActivityMade>(_context);
AdvanceQuestions = new Repository <AdvanceQuestion>(_context);
}
public void TestInitialize()
{
string dateConvert = "2021-04-04 12:14:11";
IFormatProvider format = new System.Globalization.CultureInfo("es-ES", false);
DateTime date = new DateTime();
date = DateTime.ParseExact(dateConvert, "yyyy-MM-dd HH:mm:ss", format);
_data = new List <ActivityPracticioner>
{
new ActivityPracticioner
{
IdActivityPracticioner = 9,
Qualification = 0,
ActivityPracticionerStatus = ActivityPracticionerStatus.NOTQUALIFIED,
Enrollment = "zS18012149",
Activity = new Activity
{
IdActivity = 1,
Name = "Primer reporte parcial",
ActivityType = ActivityType.PartialReport,
ActivityStatus = ActivityStatus.ACTIVE,
Description = "Entregar el primer reporte parcial corresponsdiente a 200 horas.",
ValueActivity = 10,
StartDate = new DateTime(),
FinishDate = date,
StaffNumberTeacher = "5678"
}
}
};
DbSet <ActivityPracticioner> _mockSet = DbContextMock.GetQueryableMockDbSet(_data, x => x.IdActivityPracticioner);
ProfessionalPracticesContext _mockContext = DbContextMock.GetContext(_mockSet);
_unitOfWork = new UnitOfWork(_mockContext);
}
public void AddReport()
{
List <Document> data = new List <Document>
{
new Document
{
IdDocument = 9,
Name = "DoctoProyecto.docx"
}
};
DbSet <Document> _mockSet = DbContextMock.GetQueryableMockDbSet(data, x => x.IdDocument);
ProfessionalPracticesContext _mockContext = DbContextMock.GetContext(_mockSet);
UnitOfWork unitOfWork = new UnitOfWork(_mockContext);
Document documentUpdate = unitOfWork.Documents.Get(9);
documentUpdate.Name = "DoctoProyecto.docx";
documentUpdate.RouteSave = "C:/Users/MARTHA/Documents/Activity/1";
documentUpdate.TypeDocument = "Reporte Mensual";
documentUpdate.TypeDocument = "Reporte Parcial";
DateTime deliveryDate = DateTime.Now;
documentUpdate.DeliveryDate = deliveryDate;
ActivityPracticioner activityPracticionerUpdate = _unitOfWork.ActivityPracticioners.Get(9);
activityPracticionerUpdate.Activity.ActivityStatus = ActivityStatus.ACTIVE;
activityPracticionerUpdate.Answer = "Entrega";
int expected = 1;
int actual = _data.Count;
Assert.AreEqual(expected, actual);
}
public void AddActivityCorrect()
{
List <Activity> actvities = new List <Activity>();
DbSet <Activity> mockSet = DbContextMock.GetQueryableMockDbSet(actvities, a => a.IdActivity);
ProfessionalPracticesContext mockContext = DbContextMock.GetContext(mockSet);
UnitOfWork unitOfWork = DbContextMock.GetUnitOfWork(mockContext);
string date = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
Activity newActivity = new Activity
{
IdGroup = 1,
Name = "Actividad 2 reporte mensual",
ActivityType = ActivityType.MonthlyReport,
ActivityStatus = ActivityStatus.ACTIVE,
IdActivity = 2,
Description = " Deberan de subir su primer reporte mensual",
ValueActivity = 100,
StartDate = Convert.ToDateTime(date),
FinishDate = Convert.ToDateTime(date),
teacher = new Teacher
{
StaffNumber = "12345"
}
};
unitOfWork.Activities.Add(newActivity);
int expected = 1;
int actual = actvities.Count;
Assert.AreEqual(expected, actual);
}
private void DeleteButtonClicked(object sender, RoutedEventArgs routedEventArgs)
{
ResponsibleProject responsibleProject = ((ResponsibleProject)ListViewResponsibleProject.SelectedItem);
try
{
ProfessionalPracticesContext professionalPracticesContext = new ProfessionalPracticesContext();
UnitOfWork unitOfWork = new UnitOfWork(professionalPracticesContext);
bool responsibleProjectIsAssigned = unitOfWork.ResponsibleProjects.ResponsibleProjectIsAssigned(responsibleProject.IdResponsibleProject);
if (responsibleProjectIsAssigned)
{
MessageBox.Show("El responsable del proyecto está asignado, no se puede eliminar", "Eliminar", MessageBoxButton.OK, MessageBoxImage.Warning);
}
else
{
ResponsibleProjectDeletion deleteResponsibleProject = new ResponsibleProjectDeletion();
deleteResponsibleProject.InitializeDataResponsibleProject(responsibleProject);
deleteResponsibleProject.Show();
Close();
}
}
catch (EntityException)
{
MessageBox.Show("No se pudo obtener información de la base de datos. Intente más tarde", "Consulta Fallida", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
public void RegisterActivitiesMade_Exists()
{
DateTime localDate = DateTime.Now;
List <ActivityMade> activitiesMades = new List <ActivityMade>();
DbSet <ActivityMade> mockSet = DbContextMock.GetQueryableMockDbSet(activitiesMades, p => p.IdActivity);
ProfessionalPracticesContext mockContext = DbContextMock.GetContext(mockSet);
UnitOfWork unitOfWork = DbContextMock.GetUnitOfWork(mockContext);
List <ActivityMade> newActivities = new List <ActivityMade>
{
new ActivityMade
{
Name = "Pruebas",
IdPartialReport = 1,
PlannedWeek = "S1 S2 S3",
RealWeek = "S1 S2 S3"
},
new ActivityMade
{
Name = "Modelo de dominio",
IdPartialReport = 1,
PlannedWeek = "S1 S2 S3",
RealWeek = "S1 S2 S3"
}
};
unitOfWork.ActivityMades.AddRange(newActivities);
int expected = 2;
int actual = newActivities.Count;
Assert.AreEqual(expected, actual);
}
private void DeleteButtonClicked(object sender, RoutedEventArgs routedEventArgs)
{
MessageBoxResult messageBoxResult = MessageBox.Show("¿Seguro desea eliminar el profesor?", "Confirmación", MessageBoxButton.YesNo, MessageBoxImage.Question);
if (messageBoxResult == MessageBoxResult.Yes)
{
try
{
ProfessionalPracticesContext professionalPracticesContext = new ProfessionalPracticesContext();
UnitOfWork unitOfWork = new UnitOfWork(professionalPracticesContext);
Teacher deleteTeacher = unitOfWork.Teachers.Get(teacher.StaffNumber);
deleteTeacher.User.UserStatus = UserStatus.INACTIVE;
int rowsAffected = unitOfWork.Complete();
unitOfWork.Dispose();
if (rowsAffected == 1)
{
MessageBox.Show("El Profesor se eliminó exitosamente", "Elimiación Exitosa", MessageBoxButton.OK, MessageBoxImage.Information);
}
else
{
MessageBox.Show("El Profesor no pudo eliminarse", "Eliminación Fallida", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
catch (EntityException)
{
MessageBox.Show("El Profesor no pudo eliminarse", "Eliminación Fallida", MessageBoxButton.OK, MessageBoxImage.Error);
}
TeacherConsultation teacherConsultation = new TeacherConsultation();
teacherConsultation.Show();
Close();
}
}
private void LoadReportsInformation()
{
ProfessionalPracticesContext professionalPracticesContext = new ProfessionalPracticesContext();
UnitOfWork unitOfWork = new UnitOfWork(professionalPracticesContext);
try
{
IList <ActivityPracticioner> partialReport = unitOfWork.Practicioners.GetPracticionerPartialReports(_enrollment);
foreach (ActivityPracticioner partial in partialReport)
{
ListViewPartialReport.Items.Add(partial);
}
IList <ActivityPracticioner> monthlyReport = unitOfWork.Practicioners.GetPracticionerMonthlyReports(_enrollment);
foreach (ActivityPracticioner monthly in monthlyReport)
{
ListViewMonthlyReport.Items.Add(monthly);
}
_hourCovered = unitOfWork.Practicioners.GetAccumulatedHours(_enrollment);
}
catch (EntityException)
{
ShowException();
}
finally
{
unitOfWork.Dispose();
}
}
private void DeleteButtonClicked(object sender, RoutedEventArgs routedEventArgs)
{
Practicioner practicioner = ((Practicioner)ListViewPracticioners.SelectedItem);
try
{
ProfessionalPracticesContext professionalPracticesContext = new ProfessionalPracticesContext();
UnitOfWork unitOfWork = new UnitOfWork(professionalPracticesContext);
bool practicionerCantBeDeleted = unitOfWork.Practicioners.PracticionerHasActiveProject(practicioner.Enrollment);
unitOfWork.Practicioners.PracticionerHasActiveProject(practicioner.Enrollment);
if (practicionerCantBeDeleted)
{
MessageBox.Show("El practicante tiene asignado un proyecto activo, no se puede eliminar", "No se puede eliminar", MessageBoxButton.OK, MessageBoxImage.Warning);
}
else
{
PracticionerDeletion practicionerDeletion = new PracticionerDeletion();
practicionerDeletion.InitializeDataPracticioner(practicioner);
practicionerDeletion.Show();
Close();
}
}
catch (EntityException)
{
MessageBox.Show("No hay conexión con la base de datos. Por favor intente más tarde", "Consulta Fallida", MessageBoxButton.OK, MessageBoxImage.Error);
CoordinatorMenu coordinatorMenu = new CoordinatorMenu();
coordinatorMenu.Show();
this.Close();
}
}
public void TestInitialize()
{
_practicioners = new List <Practicioner> {
new Practicioner
{
Enrollment = "zS18012124",
}
};
_request = new List <RequestProject>
{
new RequestProject
{
IdRequestProject = 1,
RequestDate = DateTime.Now,
IdProject = 1,
Enrollment = "zS18012124",
RequestStatus = RequestStatus.REQUESTED
}
};
_mockSetPracticioners = DbContextMock.GetQueryableMockDbSet(_practicioners, p => p.Enrollment);
_mockContext = DbContextMock.GetContext(_mockSetPracticioners);
_mockSetRequest = DbContextMock.GetQueryableMockDbSet(_request, r => r.IdRequestProject);
_mockContext = DbContextMock.GetContext(_mockSetRequest);
_unitOfWork = new UnitOfWork(_mockContext);
}
private void AddButtonClicked(object sender, RoutedEventArgs routedEventArgs)
{
CreateActivity();
if (ValidateData())
{
ProfessionalPracticesContext professionalPracticesContext = new ProfessionalPracticesContext();
UnitOfWork unitOfWork = new UnitOfWork(professionalPracticesContext);
try
{
unitOfWork.Activities.Add(Activity);
unitOfWork.Complete();
AddActivityToPracticioners();
MessageBox.Show("Actividad agregada exitosamente.");
this.Close();
}
catch (SqlException)
{
CatchDBException();
}
finally
{
unitOfWork.Dispose();
}
}
else
{
MessageBox.Show("Ingrese datos válidos");
}
}
public void RegisterSchedulingActivities_Exists()
{
List <SchedulingActivity> schedulingActivities = new List <SchedulingActivity>()
{
new SchedulingActivity
{
Month = "Febrero",
Activity = "Análisis de requerimientos, recopilación de información, documentación y revisión de procedimientos.Capacitación en el IDE de desarrollo y metodología.",
IdProject = 3
},
new SchedulingActivity
{
Month = "Mayo",
Activity = "Pruebas y ajustes",
IdProject = 3
}
};
DbSet <SchedulingActivity> mockSet = DbContextMock.GetQueryableMockDbSet(schedulingActivities, s => s.IdSchedulingActivity);
ProfessionalPracticesContext mockContext = DbContextMock.GetContext(mockSet);
UnitOfWork unitOfWork = DbContextMock.GetUnitOfWork(mockContext);
unitOfWork.SchedulingActivities.AddRange(schedulingActivities);
int expected = 4;
int actual = schedulingActivities.Count;
Assert.AreEqual(expected, actual);
}
private void ConsultTeacherButtonClicked(object sender, RoutedEventArgs routedEventArgs)
{
ProfessionalPracticesContext professionalPracticesContext = new ProfessionalPracticesContext();
UnitOfWork unitOfWork = new UnitOfWork(professionalPracticesContext);
try
{
IEnumerable<Teacher> thereAreTeachers = unitOfWork.Teachers.GetAll();
if (IENumerableHasTeachers(thereAreTeachers))
{
TeacherConsultation teacherConsultation = new TeacherConsultation();
teacherConsultation.Show();
Close();
}
else
{
MessageBox.Show("No hay profesores registrados. Por favor registre uno");
}
}
catch (SqlException)
{
MessageBox.Show("No hay conexión a la base de datos. Intente más tarde");
}
catch (EntityException)
{
MessageBox.Show("No hay conexión a la base de datos. Intente más tarde");
}
finally
{
unitOfWork.Dispose();
}
}
public void SoftDeleteResponsibleProject_Exists()
{
List <ResponsibleProject> responsiblesProject = new List <ResponsibleProject>();
DbSet <ResponsibleProject> mockSet = DbContextMock.GetQueryableMockDbSet(responsiblesProject, r => r.EmailAddress);
ProfessionalPracticesContext mockContext = DbContextMock.GetContext(mockSet);
UnitOfWork unitOfWork = DbContextMock.GetUnitOfWork(mockContext);
ResponsibleProject responsibleProject = new ResponsibleProject
{
IdResponsibleProject = 1,
Name = "Gustavo Antonio",
LastName = "Ruiz Zapata",
EmailAddress = "*****@*****.**",
Charge = "Jefe de departamento de Tecnología Educativa"
};
responsiblesProject.Add(responsibleProject);
ResponsibleProject responsobleProjectCurrent = unitOfWork.ResponsibleProjects.Get(responsibleProject.IdResponsibleProject);
if (responsobleProjectCurrent != null)
{
responsobleProjectCurrent.ResponsibleProjectStatus = ResponsibleProjectStatus.INACTIVE;
}
responsiblesProject.Remove(responsibleProject);
int expected = 0;
int actual = responsiblesProject.Count;
Assert.AreEqual(expected, actual);
}
public void TestInitialize()
{
_teacherValidator = new TeacherValidator(true);
_teachers = new List <Teacher> {
new Teacher
{
StaffNumber = "54321",
RegistrationDate = DateTime.Now,
User = new User
{
IdUser = 1,
Name = "Alejandra",
LastName = "Luna Ceballos",
Gender = Gender.FEMALE,
UserStatus = UserStatus.ACTIVE,
Email = "*****@*****.**",
AlternateEmail = "*****@*****.**",
PhoneNumber = "2281213456"
}
}
};
_mockSet = DbContextMock.GetQueryableMockDbSet(_teachers, t => t.StaffNumber);
_mockContext = DbContextMock.GetContext(_mockSet);
_unitOfWork = DbContextMock.GetUnitOfWork(_mockContext);
}
public void TestInitialize()
{
_data = new List <Teacher>
{
new Teacher
{
StaffNumber = "124987",
User = new User
{
Name = "Jorge Octavio",
LastName = "Ocharan Hernandez",
Gender = Gender.MALE,
UserStatus = UserStatus.ACTIVE,
PhoneNumber = "2284564791",
UserType = UserType.Teacher,
Email = "*****@*****.**",
AlternateEmail = "*****@*****.**",
Account = new Account
{
Username = "******",
Password = "******",
FirstLogin = true
}
}
}
};
DbSet <Teacher> _mockSet = DbContextMock.GetQueryableMockDbSet(_data, x => x.StaffNumber);
ProfessionalPracticesContext _mockContext = DbContextMock.GetContext(_mockSet);
_unitOfWork = new UnitOfWork(_mockContext);
}
private void ConsultProgressButtonClicked(object sender, RoutedEventArgs routedEventArgs)
{
ProfessionalPracticesContext professionalPracticesContext = new ProfessionalPracticesContext();
UnitOfWork unitOfWork = new UnitOfWork(professionalPracticesContext);
try
{
bool practicionerHaveAProject = unitOfWork.Practicioners.PracticionerHasActiveProject(_practicionerEnrollment);
if (practicionerHaveAProject)
{
ConsultProgress consultProgress = new ConsultProgress(_practicionerEnrollment);
consultProgress.Show();
Close();
}
else
{
MessageBox.Show("No tiene un proyecto asignado. Contacte a su coordinador", "Consulta Fallida", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
catch (EntityException)
{
MessageBox.Show("No hay conexión a la base de datos. Intente más tarde", "Consulta Fallida", MessageBoxButton.OK, MessageBoxImage.Error);
}
finally
{
unitOfWork.Dispose();
}
}
private async void GenerateReportButtonClickedAsync(object sender, RoutedEventArgs e)
{
if (TextBoxSavingPath.Text == "")
{
MessageBox.Show("Por favor ingrese una ruta de guardado válida");
}
else
{
ProfessionalPracticesContext professionalPracticesContext = new ProfessionalPracticesContext();
UnitOfWork unitOfWork = new UnitOfWork(professionalPracticesContext);
try
{
LoadDataFromDatabase(unitOfWork);
GenerateReportAsync();
MessageBox.Show("El reporte fue generado con éxito");
}
catch (SqlException)
{
MessageBox.Show("Error en la conexión con la base de datos. Por favor, intente más tarde");
}
catch (EntityException)
{
MessageBox.Show("Error en la conexión con la base de datos. Por favor, intente más tarde");
}
catch (NullReferenceException)
{
MessageBox.Show("No se pudo generar el reporte");
}
finally
{
unitOfWork.Dispose();
GoBackToCoordinatorMenu();
}
}
}
private void LoadInformation()
{
ProfessionalPracticesContext professionalPracticesContext = new ProfessionalPracticesContext();
UnitOfWork unitOfWork = new UnitOfWork(professionalPracticesContext);
try
{
IEnumerable <Group> groups = unitOfWork.Groups.GetAll();
foreach (Group group in groups)
{
ListViewGroups.Items.Add(group);
}
}
catch (EntityException)
{
MessageBox.Show("No hay conexión con la base de datos. Intente más tarde");
CoordinatorMenu coordinatorMenu = new CoordinatorMenu();
coordinatorMenu.Show();
this.Close();
}
finally
{
unitOfWork.Dispose();
}
}
public void TestInitialize()
{
_data = new List <User>
{
new User
{
IdUser = 1,
Name = "Martha Miroslava",
LastName = "Ortiz",
Gender = Gender.FEMALE,
UserStatus = UserStatus.ACTIVE,
Email = "*****@*****.**",
AlternateEmail = "*****@*****.**",
PhoneNumber = "9711609017",
UserType = UserType.Coordinator,
Account = new Account
{
IdAccount = 1,
Username = "******",
Password = "******"
}
}
};
_mockSet = DbContextMock.GetQueryableMockDbSet(_data, x => x.IdUser);
_mockContext = DbContextMock.GetContext(_mockSet);
_repository = new Repository <User>(_mockContext);
_unitOfWork = new UnitOfWork(_mockContext);
}
private void DeleteButtonClicked(object sender, RoutedEventArgs e)
{
MessageBoxResult messageBoxResult = MessageBox.Show("¿Seguro que desea eliminar al coordinador?",
"Confirmación", MessageBoxButton.YesNo, MessageBoxImage.Question);
if (messageBoxResult == MessageBoxResult.Yes)
{
ProfessionalPracticesContext professionalPracticesContext = new ProfessionalPracticesContext();
UnitOfWork unitOfWork = new UnitOfWork(professionalPracticesContext);
try
{
unitOfWork.Coordinators.SetCoordinatorStatusAsInactive(Coordinator.StaffNumber);
unitOfWork.Complete();
MessageBox.Show("Coordinador eliminado exitosamente");
}
catch (SqlException)
{
MessageBox.Show("No hay conexión a la base de datos. Intente más tarde");
}
finally
{
unitOfWork.Dispose();
GoBackToCoordinatorConsultation();
}
}
}
private void DeleteActivityButtonClicked(object sender, RoutedEventArgs routedEventArgs)
{
SchedulingActivity schedulingActivity = ((SchedulingActivity)ListViewSchedulingActivities.SelectedItem);
MessageBoxResult messageBoxResult = MessageBox.Show("¿Seguro desea eliminar la actividad?", "Confirmación", MessageBoxButton.YesNo, MessageBoxImage.Question);
if (messageBoxResult == MessageBoxResult.Yes && !object.ReferenceEquals(null, schedulingActivity))
{
try
{
ProfessionalPracticesContext professionalPracticesContext = new ProfessionalPracticesContext();
UnitOfWork unitOfWork = new UnitOfWork(professionalPracticesContext);
SchedulingActivity schedulingActivityDelete = unitOfWork.SchedulingActivities.Get(schedulingActivity.IdSchedulingActivity);
unitOfWork.SchedulingActivities.Remove(schedulingActivityDelete);
int rowsAffected = unitOfWork.Complete();
unitOfWork.Dispose();
if (rowsAffected == 1)
{
MessageBox.Show("La actividad se eliminó exitosamente", "Eliminación exitosa", MessageBoxButton.OK, MessageBoxImage.Information);
}
else
{
MessageBox.Show("No se pudo eliminar la actividad. Intente más tarde.", "Eliminación Fallida", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
catch (EntityException)
{
MessageBox.Show("No se pudo eliminar la actividad. Intente más tarde.", "Eliminación Fallida", MessageBoxButton.OK, MessageBoxImage.Error);
}
UpdateListViewSchedulingActivities();
}
}
public void TestInitialize()
{
_data = new List <Coordinator>
{
new Coordinator
{
StaffNumber = "XGC16215",
RegistrationDate = DateTime.Now,
DischargeDate = null,
User = new User
{
IdUser = 1,
Name = "Eduardo Aldair",
LastName = "Hernández Solís",
Gender = Gender.MALE,
UserStatus = UserStatus.ACTIVE,
Email = "*****@*****.**",
AlternateEmail = "*****@*****.**",
PhoneNumber = "2298046218",
Account = new Account
{
Username = "******",
Password = "******",
FirstLogin = true
}
}
}
};
_mockSet = DbContextMock.GetQueryableMockDbSet(_data, x => x.StaffNumber);
_mockContext = DbContextMock.GetContext(_mockSet);
_repository = new CoordinatorRepository(_mockContext);
_unitOfWork = new UnitOfWork(_mockContext);
}
private void DeleteButtonClicked(object sender, RoutedEventArgs routedEventArgs)
{
MessageBoxResult messageBoxResult = MessageBox.Show("¿Seguro desea eliminar el practicante?", "Confirmación", MessageBoxButton.YesNo, MessageBoxImage.Question);
if (messageBoxResult == MessageBoxResult.Yes)
{
ProfessionalPracticesContext professionalPracticesContext = new ProfessionalPracticesContext();
UnitOfWork unitOfWork = new UnitOfWork(professionalPracticesContext);
try
{
unitOfWork.Practicioners.SetPracticionerStatusAsInactive(practicioner.Enrollment);
unitOfWork.Complete();
MessageBox.Show("Practicante eliminado exitosamente");
}
catch (EntityException)
{
MessageBox.Show("No hay conexión a la base de datos. Por favor intente más tarde");
}
finally
{
unitOfWork.Dispose();
PracticionerConsult practicionerConsult = new PracticionerConsult();
practicionerConsult.Show();
this.Close();
}
}
}