public List <Employee> GetEmployeeByManagerId(int id)
{
using (LeaveDBContext departmentContext = new LeaveDBContext())
{
return(departmentContext.Employees.Where(u => u.ManagerId == id).ToList());
}
}
public IEnumerable <Employee> GetEmployee()
{
using (LeaveDBContext departmentContext = new LeaveDBContext())
{
return(departmentContext.Employees.Include("Designation").Include("Department").Include("Manager").ToList());
}
}
public Manager EditManager(int ManagerId)
{
using (LeaveDBContext departmentContext = new LeaveDBContext())
{
return(departmentContext.Managers.Find(ManagerId));
}
}
public Employee EditEmployee(int EmployeeId)
{
using (LeaveDBContext departmentContext = new LeaveDBContext())
{
return(departmentContext.Employees.Find(EmployeeId));
}
}
public Designation EditDesignation(int DesignationId)
{
using (LeaveDBContext departmentContext = new LeaveDBContext())
{
return(departmentContext.Designations.Find(DesignationId));
}
}
public IEnumerable <Manager> GetManager()
{
using (LeaveDBContext departmentContext = new LeaveDBContext())
{
return(departmentContext.Managers.ToList());
}
}
public IEnumerable <Department> GetDepartment()
{
using (LeaveDBContext departmentContext = new LeaveDBContext())
{
return(departmentContext.Departments.ToList());
}
}
public int SetEmployeeId(string EmployeeEmail)
{
using (LeaveDBContext departmentContext = new LeaveDBContext())
{
Employee employee = departmentContext.Employees.Where(x => x.EmployeeEmail == EmployeeEmail).SingleOrDefault();
return(employee.EmployeeId);
}
}
public void AddAccount(Account account)
{
using (LeaveDBContext departmentContext = new LeaveDBContext())
{
departmentContext.Accounts.Add(account);
departmentContext.SaveChanges();
}
}
public void AddEmployeeList(Employee employee)
{
using (LeaveDBContext departmentContext = new LeaveDBContext())
{
departmentContext.Employees.Add(employee);
departmentContext.SaveChanges();
}
}
public void AddDepartmentList(Department department)
{
using (LeaveDBContext departmentContext = new LeaveDBContext())
{
departmentContext.Departments.Add(department);
departmentContext.SaveChanges();
}
}
public Department EditDepartment(int DepartmentId)
{
using (LeaveDBContext departmentContext = new LeaveDBContext())
{
return(departmentContext.Departments.Find(DepartmentId));
}
}
public string GetEmployeeNameByGmail(string Gmail)
{
using (LeaveDBContext departmentContext = new LeaveDBContext())
{
Employee employee = departmentContext.Employees.Where(u => u.EmployeeEmail == Gmail).SingleOrDefault();
return(employee.EmployeeName);
}
}
public void AddLeaveRequest(Leave leaveRequest)
{
using (LeaveDBContext departmentContext = new LeaveDBContext())
{
departmentContext.LeaveRequest.Add(leaveRequest);
departmentContext.SaveChanges();
}
}
public void UpdateDesignation(Designation designation)
{
using (LeaveDBContext departmentContext = new LeaveDBContext())
{
departmentContext.Entry(designation).State = System.Data.Entity.EntityState.Modified;
departmentContext.SaveChanges();
}
}
public void AddDesignationList(Designation designation)
{
using (LeaveDBContext departmentContext = new LeaveDBContext())
{
departmentContext.Designations.Add(designation);
departmentContext.SaveChanges();
}
}
public string GetEmployeeNameById(int Id)
{
using (LeaveDBContext departmentContext = new LeaveDBContext())
{
Employee employee = departmentContext.Employees.Where(u => u.EmployeeId == Id).SingleOrDefault();
return(employee.EmployeeName);
}
}
public void UpdateEmployee(Employee employee)
{
using (LeaveDBContext departmentContext = new LeaveDBContext())
{
departmentContext.Entry(employee).State = System.Data.Entity.EntityState.Modified;
departmentContext.SaveChanges();
}
}
public int GetManagerIdByName(string Name)
{
using (LeaveDBContext departmentContext = new LeaveDBContext())
{
Manager manager = departmentContext.Managers.Where(u => u.ManagerName == Name).FirstOrDefault();
return(manager.ManagerId);
}
}
public void DeleteDesignation(int DesignationId)
{
using (LeaveDBContext departmentContext = new LeaveDBContext())
{
Designation designation = departmentContext.Designations.Find(DesignationId);
departmentContext.Designations.Remove(designation);
departmentContext.SaveChanges();
}
}
public void DeleteEmployee(int EmployeeId)
{
using (LeaveDBContext departmentContext = new LeaveDBContext())
{
Employee employee = departmentContext.Employees.Find(EmployeeId);
departmentContext.Employees.Remove(employee);
departmentContext.SaveChanges();
}
}
public void DeclineRequest(int LeaveId)
{
using (LeaveDBContext departmentContext = new LeaveDBContext())
{
var leaveRequest = departmentContext.LeaveRequest.Find(LeaveId);
leaveRequest.Status = "Declined";
departmentContext.SaveChanges();
}
}
public void DeleteDepartment(int DepartmentId)
{
using (LeaveDBContext departmentContext = new LeaveDBContext())
{
Department department = departmentContext.Departments.Find(DepartmentId);
departmentContext.Departments.Remove(department);
departmentContext.SaveChanges();
}
}
public void AddManagerList(Manager manager)
{
using (LeaveDBContext departmentContext = new LeaveDBContext())
{
//SqlParameter sql = new SqlParameter("@ManagerName", manager.ManagerName);
//int count = departmentContext.Database.ExecuteSqlCommand("Manager_Insert @ManagerName", sql);
departmentContext.Managers.Add(manager);
departmentContext.SaveChanges();
}
}
public void DeleteManager(int ManagerId)
{
using (LeaveDBContext departmentContext = new LeaveDBContext())
{
//SqlParameter sql = new SqlParameter("@ManagerId", ManagerId);
//int count = departmentContext.Database.ExecuteSqlCommand("Manager_Delete @ManagerId", sql);
Employee employee = departmentContext.Employees.Find(ManagerId);
departmentContext.Employees.Remove(employee);
departmentContext.SaveChanges();
}
}
public void UpdateManager(Manager manager)
{
using (LeaveDBContext departmentContext = new LeaveDBContext())
{
//SqlParameter sql = new SqlParameter("@ManagerId", manager.ManagerId);
//SqlParameter sqlName = new SqlParameter("@ManagerName", manager.ManagerName);
//var data = departmentContext.Database.ExecuteSqlCommand("Manager_Update @ManagerId,@ManagerName", sql, sqlName);
//int count = departmentContext.Database.ExecuteSqlCommand("Manager_Update @ManagerId", sql);
departmentContext.Entry(manager).State = System.Data.Entity.EntityState.Modified;
departmentContext.SaveChanges();
}
}
public Account CheckLogin(Account account)
{
using (LeaveDBContext departmentContext = new LeaveDBContext())
{
Account user = departmentContext.Accounts.Where(u => u.UserName == account.UserName && u.Password == account.Password).SingleOrDefault();
if (user != null)
{
return(user);
}
else
{
return(null);
}
}
}
public List <Leave> GetLeaveRequestByManager(List <Employee> employee)
{
using (LeaveDBContext departmentContext = new LeaveDBContext())
{
List <Leave> list = new List <Leave>();
foreach (Employee details in employee)
{
List <Leave> leave = departmentContext.LeaveRequest.Where(u => u.EmployeeId == details.EmployeeId && u.Status == "Pending").ToList();
foreach (Leave leaves in leave)
{
list.Add(leaves);
}
}
return(list);
}
}
public IEnumerable <Designation> GetDesignation()
{
LeaveDBContext departmentContext = new LeaveDBContext();
return(departmentContext.Designations.ToList());
}