public List <StudentSubject> StudentBySubjects(Guid idStudent) //Meu Funciona OK, torna llista dels IDs dels students i les ID de les seves Subjects.
{
var repo = DepCon.Resolve <IRepository <StudentSubject> >();
var entityId = repo.QueryAll().Where(e => e.StudentId == idStudent).ToList();
return(entityId);
}
public List <StudentSubject> StudentBySubjects(Guid idStudent)
{
var repo = DepCon.Resolve <IRepository <StudentSubject> >();
var entityId = repo.QueryAll().Where(e => e.StudentId == idStudent).ToList();
return(entityId);
}
public Exam FindExam(Guid idExam)
{
var repo = DepCon.Resolve <IRepository <Exam> >();
var entity = repo.QueryAll().FirstOrDefault(x => x.Id == idExam);
return(entity);
}
public static ValidationResult <string> ValidateExist(string dni)
{
var output = new ValidationResult <string>()
{
IsSuccess = true
};
if (string.IsNullOrEmpty(dni))
{
output.IsSuccess = false;
output.Errors.Add("El DNI no puede estar vacío");
}
else if (dni.Length < 9)
{
output.IsSuccess = false;
output.Errors.Add("El DNI no tiene un formato correcto");
}
#region check existence
var repo = DepCon.Resolve <IRepository <Empleat> >();
var entityWithDni = repo.QueryAll().FirstOrDefault(s => s.Dni == dni);
if (entityWithDni == null)
{
output.IsSuccess = false;
output.Errors.Add($"No existe empled@ con ese DNI {dni}");
}
#endregion
if (output.IsSuccess)
{
output.ValidatedResult = dni;
}
return(output);
}
public static ValidationResult <int> ValidateChairNumber(string chairNumberText, Guid currentId = default, bool dublicate = true)
{
var output = new ValidationResult <int>()
{
IsSuccess = true
};
var chairNumber = 0;
var isConversionOk = false;
#region check null or empty
if (string.IsNullOrEmpty(chairNumberText))
{
output.IsSuccess = false;
output.Errors.Add("el número de la silla no puede estar vacío o nulo");
}
#endregion
#region check format conversion
isConversionOk = int.TryParse(chairNumberText, out chairNumber);
if (!isConversionOk)
{
output.IsSuccess = false;
output.Errors.Add($"no se puede convertir {chairNumber} en número");
}
#endregion
#region check if the char is already in use
if (isConversionOk && dublicate)
{
var repoStudents = DepCon.Resolve <IStudentsRepository>();
var currentStudentInChair = repoStudents.QueryAll().FirstOrDefault(s => s.ChairNumber == chairNumber);
if (currentStudentInChair != null)
{
if (currentId == default)
{
output.IsSuccess = false;
output.Errors.Add($"ya hay un alumno {currentStudentInChair.Name} en la silla {chairNumber}");
}
else if (currentId != default && currentStudentInChair.Id != currentId)
{
output.IsSuccess = false;
output.Errors.Add($"ya hay un alumno {currentStudentInChair.Name} en la silla {chairNumber}");
}
}
}
#endregion
if (output.IsSuccess)
{
output.ValidatedResult = chairNumber;
}
return(output);
}
public static ValidationResult <string> ValidateExistSub(string name, Guid currentId = default)
{
var output = new ValidationResult <string>()
{
IsSuccess = true
};
if (string.IsNullOrEmpty(name))
{
output.IsSuccess = false;
output.Errors.Add("No ha introducido el nombre de la asignatura");
}
else
{
var repo = DepCon.Resolve <IRepository <Subjects> >();
var entityWithName = repo.QueryAll().FirstOrDefault(s => s.Name == name);
if (entityWithName.Name == null)
{
output.IsSuccess = false;
output.Errors.Add($"No existe una asignatura con este nombre {name}");
}
}
if (output.IsSuccess)
{
output.ValidatedResult = name;
}
return(output);
}
public virtual SaveResult <T> Save <T>() where T : Entity
{
var output = new SaveResult <T>();
CurrentValidation = Validate();
if (CurrentValidation.IsSuccess)
{
var repo = DepCon.Resolve <IRepository <T> >();
if (this.Id == Guid.Empty)
{
this.Id = Guid.NewGuid(); //Added Jaume 18/01/2020
output = repo.Add(this as T);
}
else
{
output = repo.Update(this as T);
}
}
output.Validation = CurrentValidation;
return(output);
}
public virtual SaveResult <T> Delete <T>() where T : Entity
{
var output = new SaveResult <T>();
var repo = DepCon.Resolve <IRepository <T> >();
repo.Delete(this as T);
return(output);
}
public tRepo GetRepository <tRepo>()
{
if (log.IsInfoEnabled)
{
log.Info(Consts.ENTERED);
}
return(DepCon.GetDependency <tRepo>());
}
public ValidationResult <string> ValidateName(Guid studentId, Guid subjectId, Guid currentId = default)
{
var output = new ValidationResult <string>()
{
IsSuccess = true
};
var studentBySubjects = new List <StudentSubject>();
studentBySubjects = StudentBySubjects(studentId);
//On Delete
if (currentId != default)
{
output.IsSuccess = true;
}
//On Create
else
{
if (studentId == default)
{
output.IsSuccess = false;
output.Errors.Add("el Student no puede estar vacío");
}
else
{
if (subjectId == default)
{
output.IsSuccess = false;
output.Errors.Add("la Asignatura no puede estar vacío");
}
else
{
var repo = DepCon.Resolve <IRepository <StudentSubject> >();
if (studentBySubjects != null && studentBySubjects.Any(x => x.SubjectId == subjectId))
{
output.IsSuccess = false;
output.Errors.Add("Ya está asignada esta Asignatura");
}
}
}
}
return(output);
}
public static ValidationResult <string> ValidateName(string name, Guid currentId = default)
{
var output = new ValidationResult <string>()
{
IsSuccess = true
};
if (string.IsNullOrEmpty(name))
{
output.IsSuccess = false;
output.Errors.Add("el nombre de la asignatura no puede estar vacío");
}
#region check duplication
var repo = DepCon.Resolve <ISubjectsRepository>();
var entityWithName = repo.QueryAll().FirstOrDefault(x => x.Name == name);
// Aqui llamariamos directamente a memoria:
//var repo = DepCon.Resolve<IRepository<Subject>>();
// var entityWithName = repo.QueryAll().FirstOrDefault(x => x.Name == name);
//var repo = new StudentRepository();
//var entityWithDni = repo.GetStudentByDni(dni);
if (entityWithName != null)
{
if (currentId == default && entityWithName != null)
{
// on create
output.IsSuccess = false;
output.Errors.Add("ya existe una asignatura con ese nombre");
}
else if (currentId != default && entityWithName.Id != currentId)
{
// on update
output.IsSuccess = false;
output.Errors.Add("ya existe una asignatura con ese nombre");
}
}
#endregion
if (output.IsSuccess)
{
output.ValidatedResult = name;
}
return(output);
}
public ValidationResult <string> ValidateStudentExam(Guid studentId, Guid examId, Guid currentId = default)
{
var output = new ValidationResult <string>()
{
IsSuccess = true
};
var studentByExams = new List <StudentExam>();
studentByExams = StudentByExams(studentId);
//On Delete
if (currentId != default)
{
output.IsSuccess = true;
}
//On Create
else
{
if (studentId == default)
{
output.IsSuccess = false;
output.Errors.Add("El Student no puede estar vacío");
}
else
{
if (examId == default)
{
output.IsSuccess = false;
output.Errors.Add("El Examen no puede estar vacío");
}
else
{
var repo = DepCon.Resolve <IRepository <StudentSubject> >();
if (studentByExams != null && studentByExams.Any(x => x.ExamId == examId))
{
output.IsSuccess = false;
output.Errors.Add("Ya está registrado este Examen");
}
}
}
}
return(output);
}
public static ValidationResult <string> ValidateDni(string dni, Guid currentId = default)
{
var output = new ValidationResult <string>()
{
IsSuccess = true
};
if (string.IsNullOrEmpty(dni))
{
output.IsSuccess = false;
output.Errors.Add("el dni del alumno no puede estar vacío");
}
#region check duplication
var repo = DepCon.Resolve <IStudentRepository>();
var entityWithDni = repo.FindByDni(dni);
//var repo = new Repository<Student>();
//var entityWithDni = repo.QueryAll().FirstOrDefault(x => x.Dni == dni);
//var repo = new StudentRepository();
//var entityWithDni = repo.GetStudentByDni(dni);
if (entityWithDni != null)
{
if (currentId == default && entityWithDni != null)
{
// on create
output.IsSuccess = false;
output.Errors.Add("ya existe un alumno con ese dni");
}
else if (currentId != default && entityWithDni.Id != currentId)
{
// on update
output.IsSuccess = false;
output.Errors.Add("ya existe un alumno con ese dni");
}
}
#endregion
if (output.IsSuccess)
{
output.ValidatedResult = dni;
}
return(output);
}
public virtual DeleteResult <T> Delete <T>() where T : Entity
{
var output = new DeleteResult <T>();
CurrentValidation = Validate();
if (CurrentValidation.IsSuccess)
{
var repo = DepCon.Resolve <IRepository <T> >();
output = repo.Delete(this as T);
}
output.Validation = CurrentValidation;
return(output);
}
public static ValidationResult <string> ValidateDni(string dni, Guid currentId = default)
{
var output = new ValidationResult <string>()
{
IsSuccess = true
};
if (string.IsNullOrEmpty(dni))
{
output.IsSuccess = false;
output.Errors.Add("Debe informar DNI emplead@");
}
else if (dni.Length < 9)
{
output.IsSuccess = false;
output.Errors.Add("El DNI de emplead@ no tiene un formato correcto");
}
#region check duplication
var repo = DepCon.Resolve <IRepository <Empleat> >();
var entityWithDni = repo.QueryAll().FirstOrDefault(s => s.Dni == dni);
if (currentId == default && entityWithDni != null)
{
// on create
output.IsSuccess = false;
output.Errors.Add("Ya existe emplead@ con este DNI");
}
else if (currentId != default && entityWithDni != null && entityWithDni.Id != currentId)
{
if (entityWithDni.Dni == dni)
{
// on update
output.IsSuccess = false;
output.Errors.Add("Ya existe emplead@ con este DNI");
}
}
#endregion
if (output.IsSuccess)
{
output.ValidatedResult = dni;
}
return(output);
}
public static ValidationResult <int> ValidateChairNumber(string chairNumberText, string namesubject, string dniStudent)
{
var output = new ValidationResult <int>()
{
IsSuccess = true
};
var chairNumber = 0;
var isConversionOk = false;
if (string.IsNullOrEmpty(chairNumberText))
{
output.IsSuccess = false;
output.Errors.Add("Debe informar el número de silla");
}
else
{
// check format conversion
isConversionOk = int.TryParse(chairNumberText, out chairNumber);
if (!isConversionOk)
{
output.IsSuccess = false;
output.Errors.Add($"No se puede convertir {chairNumber} en número");
}
else
{
// check if the char is already in use
var repo = DepCon.Resolve <IRepository <Courses> >();
var entityWithNumber = repo.QueryAll().FirstOrDefault(s => s.NameSubject == namesubject && s.ChairNumber == chairNumber);
if (entityWithNumber != null && entityWithNumber.DniStudent != dniStudent)
{
output.IsSuccess = false;
output.Errors.Add($"Ya existe un alumno en la silla {chairNumber}");
}
}
}
if (output.IsSuccess)
{
output.ValidatedResult = chairNumber;
}
return(output);
}
public static ValidationResult <string> ValidateDni(string dni, Guid currentId = default)
{
var output = new ValidationResult <string>()
{
IsSuccess = true
};
if (string.IsNullOrEmpty(dni))
{
output.IsSuccess = false;
output.Errors.Add("el dni del alumno no puede estar vacío");
}
#region check duplication
var repo = DepCon.Resolve <IRepository <Student> >();
//var entityWithDni = repo.GetStudentByDni(dni, currentId); //Jose
var entityWithDni = repo.QueryAll().FirstOrDefault(s => s.Dni == dni);
if (currentId == default && entityWithDni != null)
{
// on create
output.IsSuccess = false;
output.Errors.Add("ya existe un alumno con ese dni");
}
else if (currentId != default && entityWithDni != null && entityWithDni.Id != currentId) //Modificado
{
if (entityWithDni.Dni == dni)
{
// on update
// Console.WriteLine("Soy Student : Ya existe un alumno con este DNI"); //Meu
output.IsSuccess = false;
output.Errors.Add("ya existe un alumno con ese dni");
}
}
#endregion
if (output.IsSuccess)
{
output.ValidatedResult = dni;
}
return(output);
}
public static ValidationResult <string> ValidateName(string name, Guid currentId = default)
{
var output = new ValidationResult <string>()
{
IsSuccess = true
};
if (string.IsNullOrEmpty(name))
{
output.IsSuccess = false;
output.Errors.Add("el nombre de la asignatura no puede estar vacío");
}
#region check duplication
var repo = DepCon.Resolve <IRepository <Subject> >();
var entityWithName = repo.QueryAll().FirstOrDefault(s => s.Name == name);
if (currentId == default && entityWithName != null)
{
// on create
output.IsSuccess = false;
output.Errors.Add("ya existe una Asignatura con ese nombre");
// Console.WriteLine("Soy Subject : Ya existe una Asignatura con este Nombre");
}
//else if (currentId != default && entityWithName.Id != currentId) //Original
else if (currentId != default && entityWithName != null && entityWithName.Id != currentId) //Modificado
{
if (entityWithName.Name == name)
{
// on update
// Console.WriteLine("Soy Subject : Ya existe una Asignatura con este Nombre");
output.IsSuccess = false;
output.Errors.Add("Ya existe una Asignatura con este Nombre");
}
}
#endregion
if (output.IsSuccess)
{
output.ValidatedResult = name;
}
return(output);
}
public static ValidationResult <string> ValidateEmail(string email, Guid currentId = default)
{
var output = new ValidationResult <string>()
{
IsSuccess = true
};
if (string.IsNullOrEmpty(email))
{
output.IsSuccess = false;
output.Errors.Add("el email del alumno no puede estar vacío");
}
#region check duplication
var repo = DepCon.Resolve <IRepository <Student> >();
var entityWithEmail = repo.QueryAll().FirstOrDefault(s => s.Email == email);
if (currentId == default && entityWithEmail != null)
{
// on create
output.IsSuccess = false;
output.Errors.Add("ya existe un alumno con ese email");
}
else if (currentId != default && entityWithEmail != null && entityWithEmail.Id != currentId) //Modificado
{
if (entityWithEmail.Email == email)
{
// on update
output.IsSuccess = false;
output.Errors.Add("ya existe un alumno con ese email");
}
}
#endregion
if (output.IsSuccess)
{
output.ValidatedResult = email;
}
return(output);
}
public virtual SaveValidation <T> Save <T>() where T : Entity
{
var output = new SaveValidation <T>();
CurrentValidation = Validate();
if (CurrentValidation.ValidationSuccesful)
{
var repo = DepCon.Resolve <IRepository <T> >();
if (this.Id == Guid.Empty)
{
output = repo.Add(this as T);
}
else
{
output = repo.Update(this as T);
}
}
output.Validation = CurrentValidation;
return(output);
}