public IQueryable <AditionalServiceVO> GetAditionalServicesByUserType(Infrastucture.Enums.UserClientRole userType)
{
var readDb = new EmplomaniaAdminDBContext();
var q = from s in readDb.AditionalServices
where s.UserType == userType
select s;
return(q.ProjectTo <AditionalServiceVO>());
}
public IQueryable <MembershipVO> GetMembershipsByUserType(Infrastucture.Enums.UserClientRole userType)
{
var readDb = new EmplomaniaAdminDBContext();
var q = from m in readDb.Memberships
where m.UserType == userType
select m;
return(q.ProjectTo <MembershipVO>());
}
public WorkerService(EmplomaniaAdminDBContext db, IUserService us, IWorkReferenceService wrs, IWorkerDriverLicenseService wdls, IWorkerVehicleService wvs, IWorkerLanguageService wls, IWorkerCourseService wcs, IWorkAspirationService was) : base(db)
{
this.us = us;
this.wrs = wrs;
this.wdls = wdls;
this.wvs = wvs;
this.wls = wls;
this.wcs = wcs;
this.was = was;
}
public bool Create(UserAdminRole userRole, string userName, string pass)
{
var readDB = new EmplomaniaAdminDBContext();
var users = (from u in readDB.AdminUsers
where u.Role == userRole && u.Name == userName
select u).ToList();
if (users.Count != 0 && users.Any(x => x.Name == userName))
{
return(false);
}
db.AdminUsers.Add(new AdminUser()
{
Id = Guid.NewGuid(), Name = userName, PasswordHash = new PasswordHasher().HashPassword(pass), Role = userRole
});
db.SaveChanges();
return(true);
}
public AdminUserVO Authentic(UserAdminRole role, string adminUserName, string pass)
{
var readDB = new EmplomaniaAdminDBContext();
var users = (from u in readDB.AdminUsers
where u.Role == role && u.Name == adminUserName
select u).ToList();
//Esto es porque el where de Linq no distingue entre mayusculas y minusculas
var us = users.Where(x => x.Name == adminUserName).FirstOrDefault();
if (new PasswordHasher().VerifyHashedPassword(us?.PasswordHash, pass) != PasswordVerificationResult.Success)
{
return(null);
}
else
{
return(Mapper.Map <AdminUserVO>(us));
}
}
public VehicleService(EmplomaniaAdminDBContext db) : base(db)
{
}
public WorkplaceService(EmplomaniaAdminDBContext db) : base(db)
{
}
public WorkerLanguageService(EmplomaniaAdminDBContext db) : base(db)
{
}
public OfferNeedService(EmplomaniaAdminDBContext db) : base(db)
{
}
public DriverLicenseService(EmplomaniaAdminDBContext db) : base(db)
{
}
public LanguageLevelService(EmplomaniaAdminDBContext db) : base(db)
{
}
public MunicipalityService(EmplomaniaAdminDBContext db) : base(db)
{
}
public ComplexionService(EmplomaniaAdminDBContext db) : base(db)
{
}
public AditionalServiceService(EmplomaniaAdminDBContext db) : base(db)
{
}
public WorkAspirationService(EmplomaniaAdminDBContext db) : base(db)
{
}
public TeacherService(EmplomaniaAdminDBContext db, IUserService us) : base(db)
{
this.us = us;
}
public MembershipService(EmplomaniaAdminDBContext db) : base(db)
{
}
public ServiceBase(EmplomaniaAdminDBContext db)
{
this.db = db;
}
public CourseService(EmplomaniaAdminDBContext db) : base(db)
{
}
public CategoryService(EmplomaniaAdminDBContext db) : base(db)
{
}
public CivilStatusService(EmplomaniaAdminDBContext db) : base(db)
{
}
public ProvinceService(EmplomaniaAdminDBContext db) : base(db)
{
}
public CurrencyService(EmplomaniaAdminDBContext db) : base(db)
{
}
public WorkReferenceService(EmplomaniaAdminDBContext db) : base(db)
{
}
public EyeColorService(EmplomaniaAdminDBContext db) : base(db)
{
}
public SchoolGradeService(EmplomaniaAdminDBContext db) : base(db)
{
}
public AdminUserService(EmplomaniaAdminDBContext db) : base(db)
{
}
public SpecialtyService(EmplomaniaAdminDBContext db) : base(db)
{
}
public ScheduleService(EmplomaniaAdminDBContext db) : base(db)
{
}
public IncomeService(EmplomaniaAdminDBContext db) : base(db)
{
}
