repo

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data.Entity;
using ProjectManagementSoftware.Model;

namespace ProjectManagementSoftware.DAL
{
    public class EmployeeRepository
    {
        public bool SignIn(string login, string pass)
        {
            return PMSoftwareContext.Instance.Employees.Any(r => r.Login == login && r.Pass == pass);
        }

        public void Register(string nick, string login, string password, string email)
        {
            PMSoftwareContext.Instance.Employees.Add(new Employee(nick, login, CryptoHelper.GetHashString(password), email));
            PMSoftwareContext.Instance.SaveChanges();
        }

        public bool CheckLogin(string login)
        {
            return !PMSoftwareContext.Instance.Employees.Any(t => t.Login == login);
        }

        public Employee FindByLogin(string login)
        {
            return PMSoftwareContext.Instance.Employees.Where(r => r.Login == login).SingleOrDefault();
        }

        public Employee Find(int id)
        {
            return PMSoftwareContext.Instance.Employees.Where(e => e.Id == id).SingleOrDefault();
        }

        public ICollection<Employee> Find()
        {
            return PMSoftwareContext.Instance.Employees.ToArray();
        }

        public TeamRole GetRole(int employeeId, int teamId)
        {
            return PMSoftwareContext.Instance.TeamEmployees.Where(et => et.TeamId == teamId && et.EmployeeId == employeeId).Select(et => et.TeamRole).FirstOrDefault();
        }
        public void AssignTeam(int employeeId, int teamId, TeamRole role)
        {
            PMSoftwareContext.Instance.TeamEmployees.Add(new TeamEmployee(employeeId, teamId, role));
            PMSoftwareContext.Instance.SaveChanges();
        }
    }
}