Exemple #1
0
    public override bool IsUserInRole(string username, string roleName)
    {
        bool outputResult = false;

        string[] namerole = roleName.Split(',');

        using (KursovikTP db = new KursovikTP())
        {
            foreach (var rn in namerole)
            {
                var user = (from u in db.People
                            where u.Login == username
                            select u).SingleOrDefault();
                if (user != null)
                {
                    var role = (from r in db.Role
                                where r.idRole == user.idRole
                                select r).SingleOrDefault();

                    if (role.NameRole.Equals(rn))
                    {
                        outputResult = true;
                    }
                }
            }
        }
        return(outputResult);
    }
Exemple #2
0
    public override string[] GetRolesForUser(string username)
    {
        string[] role = new string[] { };
        using (KursovikTP db = new KursovikTP())
        {
            try
            {
                // Получаем пользователя
                var user = (from u in db.People
                            where u.Login == username
                            select u).SingleOrDefault();
                if (user != null)
                {
                    // получаем роль
                    var userRole = (from r in db.Role
                                    where r.idRole == user.idRole
                                    select r).SingleOrDefault();

                    if (userRole != null)
                    {
                        role = new string[] { userRole.NameRole };
                    }
                }
            }
            catch
            {
                role = new string[] { };
            }
        }
        return(role);
    }
Exemple #3
0
 public void editStatus(string Login, string role)
 {
     using (KursovikTP db = new KursovikTP()) {
         var user = (from u in db.People
                     where u.Login == Login
                     select u).SingleOrDefault();
         if (role == "Applicant")
         {
             var resume = user.Applicant.Resume;
             foreach (var rm in resume)
             {
                 rm.Status = 0;
             }
         }
         else if (role == "Employer")
         {
             var jobs = user.Employer.Jobs;
             foreach (var jb in jobs)
             {
                 jb.Status = 0;
             }
         }
         db.SaveChanges();
     }
 }
Exemple #4
0
 public void CheckTime(string Login)
 {
     using (KursovikTP db = new KursovikTP()) {
         var user = (from u in db.People
                     where u.Login == Login
                     select u).SingleOrDefault();
         var role = (from r in db.Role
                     where r.idRole == user.idRole
                     select r).SingleOrDefault();
         var date = DateTime.Now;
         if (role.NameRole == "Applicant")
         {
             int result = DateTime.Compare(date.Date, user.Applicant.TimeAction.Date);
             if (result > 0)
             {
                 user.idRole = 4;
                 editStatus(user.Login, role.NameRole);
             }
         }
         else if (role.NameRole == "Employer")
         {
             int result = DateTime.Compare(date.Date, user.Employer.TimeAction.Date);
             if (result > 0)
             {
                 user.idRole = 4;
                 editStatus(user.Login, role.NameRole);
             }
         }
         db.SaveChanges();
     }
 }
    public override bool ValidateUser(string username, string password)
    {
        using (KursovikTP db = new KursovikTP())
        {
            var result = (from u in db.People where (u.Login == username && u.Password == password) select u).SingleOrDefault();

            if (result != null)
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }
    }