public IEnumerable <Manager> GetManager()
{
using (ContextClass contextClass = new ContextClass())
{
return(contextClass.Managers.ToList());
}
}
public IEnumerable <EmployeeDesignation> GetEmployeeDesignations()
{
using (ContextClass contextClass = new ContextClass())
{
return(contextClass.EmployeeDesignations.ToList());
}
}
public List <Employee> GetEmployees()
{
using (ContextClass contextClass = new ContextClass())
{
return(contextClass.Employees.Include("Departments").Include("EmployeeDesignations").Include("Manager").ToList());
}
}
public void AddAccount(Account account)
{
using (ContextClass contextClass = new ContextClass())
{
contextClass.Accounts.Add(account);
contextClass.SaveChanges();
}
}
public void AddEmployee(Employee employee)
{
using (ContextClass contextClass = new ContextClass())
{
contextClass.Employees.Add(employee);
contextClass.SaveChanges();
}
}
public void AddCircular(Circular circular)
{
using (ContextClass contextClass = new ContextClass())
{
contextClass.Circulars.Add(circular);
contextClass.SaveChanges();
}
}
public int GetCircularId(string filename)
{
using (ContextClass contextClass = new ContextClass())
{
Circular circular = contextClass.Circulars.Where(x => x.FilePath == filename).SingleOrDefault();
return(circular.CircularId);
}
}
public Account Login(string username, string password)
{
using (ContextClass contextClass = new ContextClass())
{
Account account = contextClass.Accounts.Where(x => x.EmployeeEmail == username).Where(y => y.Password == password).SingleOrDefault();
return(account);
}
}
public Department GetEachDepartment(int departmentId)
{
using (ContextClass contextClass = new ContextClass())
{
Department department = contextClass.departments.Where(id => id.DepartmentId == departmentId).SingleOrDefault();
return(department);
}
}
public int GetEmployeeId(string EmployeeEmail)
{
using (ContextClass contextClass = new ContextClass())
{
Employee employee = contextClass.Employees.Where(x => x.EmployeeEmail == EmployeeEmail).SingleOrDefault();
return(employee.EmployeeId);
}
}
public void AddDepartment(Department department)
{
using (ContextClass contextClass = new ContextClass())
{
contextClass.departments.Add(department);
contextClass.SaveChanges();
}
}
public Employee GetEmployee(int employeeid)
{
using (ContextClass contextClass = new ContextClass())
{
Employee employee = contextClass.Employees.Include("Departments").Where(id => id.EmployeeId == employeeid).SingleOrDefault();
return(employee);
}
}
public void EditEmployee(Employee employee)
{
using (ContextClass contextClass = new ContextClass())
{
contextClass.Entry(employee).State = System.Data.Entity.EntityState.Modified;
contextClass.SaveChanges();
}
}
public void DeleteEmployee(Employee employee)
{
using (ContextClass contextClass = new ContextClass())
{
SqlParameter EmployeeId = new SqlParameter("@EmployeeId", employee.EmployeeId);
contextClass.Database.ExecuteSqlCommand("Employee_Delete @EmployeeId", EmployeeId);
}
}
public void DeleteDepartment(Department department)
{
using (ContextClass contextClass = new ContextClass())
{
Department departmentDetail = contextClass.departments.Where(id => id.DepartmentId == department.DepartmentId).SingleOrDefault();
contextClass.departments.Attach(departmentDetail);
contextClass.departments.Remove(departmentDetail);
contextClass.SaveChanges();
}
}
public bool CheckDepartment(string departmentName)
{
using (ContextClass contextClass = new ContextClass())
{
Department department = contextClass.departments.Where(id => id.DepartmentName.ToLower() == departmentName).SingleOrDefault();
if (department != null)
{
return(true);
}
return(false);
}
}
public string GetRole(int managerId)
{
using (ContextClass contextClass = new ContextClass())
{
Manager manager = contextClass.Managers.Where(x => x.ManagerId == managerId).SingleOrDefault();
if (manager != null)
{
return(manager.ManagerName);
}
}
return("");
}
public bool CheckEmployee(string employeeEmail, long phoneNumber)
{
using (ContextClass contextClass = new ContextClass())
{
Employee employeeCheckMail = contextClass.Employees.Where(x => x.EmployeeEmail == employeeEmail).SingleOrDefault();
Employee employeeCheckPhone = contextClass.Employees.Where(x => x.EmployeePhoneNumber == phoneNumber).SingleOrDefault();
if (employeeCheckMail != null || employeeCheckPhone != null)
{
return(true);
}
return(false);
}
}
public Employee GetEmployeeDetails(string email)
{
using (ContextClass context = new ContextClass())
{
Employee Employee = null;
try
{
Employee = context.Employees.Where(x => x.EmployeeEmail == email).SingleOrDefault();
return(Employee);
}
catch (Exception)
{
return(Employee);
}
}
}
public Account GetUserDetails(string emailId)
{
using (ContextClass context = new ContextClass())
{
Account account = null;
try
{
account = context.Accounts.Where(x => x.EmployeeEmail == emailId).SingleOrDefault();
return(account);
}
catch (Exception)
{
return(account);
}
}
}
public Circular GetCircular(int circularId)
{
using (ContextClass contextClass = new ContextClass())
return(contextClass.Circulars.Where(x => x.CircularId == circularId).SingleOrDefault());
}
public List <Circular> GetCirculars()
{
using (ContextClass contextClass = new ContextClass())
return(contextClass.Circulars.ToList());
}
public IEnumerable <Department> GetDepartment()
{
using (ContextClass contextClass = new ContextClass())
return(contextClass.departments.ToList());
}
