示例#1
0
        public List <ShiftsEmployee> GetEmployeesBySearch(string fname, string lname, Nullable <int> dep)
        {
            List <ShiftsEmployee> list = new List <ShiftsEmployee>();

            List <Employee> emplist = db.Employees.Where(x => x.FirstName.Contains(fname) && x.LastName.Contains(lname) && x.DepatmentID == dep).ToList();

            //      List<Employee> emplist = new List<Employee>();
            //
            //      if(dep != null)
            //      {
            //          emplist = elist.Where(x => x.DepatmentID == dep).ToList();
            //      }
            //      else
            //      {
            //          emplist = elist;
            //      }

            foreach (var item in emplist)
            {
                var result = from emp in db.Employees
                             join empshift in db.EmployeeShifts on emp.ID equals empshift.EmployeeID
                             join shift in db.Shifts on empshift.ShiftID equals shift.ID
                             where empshift.EmployeeID == item.ID
                             select new Shifts
                {
                    Date      = (DateTime)shift.Date,
                    StartTime = shift.StartTime,
                    EndTime   = shift.EndTime
                };
                List <Shifts> slist = new List <Shifts>();
                foreach (var x in result)
                {
                    Shifts s = x;
                    slist.Add(s);
                }


                ShiftsEmployee se = new ShiftsEmployee();
                se.EmployeeID    = item.ID;
                se.FirstName     = item.FirstName;
                se.LastName      = item.LastName;
                se.StartWorkYear = item.StartWorkYear;
                se.DepartmentID  = item.DepatmentID;
                se.list          = slist;
                list.Add(se);
            }

            return(list);
        }
示例#2
0
        public List <ShiftsEmployee> GetAllEmployeeData()
        {
            List <ShiftsEmployee> list = new List <ShiftsEmployee>();

            List <Employee> emplist = db.Employees.ToList();

            foreach (var item in emplist)
            {
                var result = from emp in db.Employees
                             join empshift in db.EmployeeShifts on emp.ID equals empshift.EmployeeID
                             join shift in db.Shifts on empshift.ShiftID equals shift.ID
                             where empshift.EmployeeID == item.ID
                             select new Shifts
                {
                    Date      = (DateTime)shift.Date,
                    StartTime = shift.StartTime,
                    EndTime   = shift.EndTime
                };
                List <Shifts> slist = new List <Shifts>();
                foreach (var x in result)
                {
                    Shifts s = x;
                    slist.Add(s);
                }


                ShiftsEmployee se = new ShiftsEmployee();
                se.EmployeeID    = item.ID;
                se.FirstName     = item.FirstName;
                se.LastName      = item.LastName;
                se.StartWorkYear = item.StartWorkYear;
                se.DepartmentID  = item.DepatmentID;
                se.list          = slist;
                list.Add(se);
            }

            return(list);
        }