private List <Depasments> OTDetailOTList() { List <Depasments> add = new List <Depasments>(); foreach (var i in Department) { var DataParts = DetailOTnew.Where(d => d.Employee.Department_DepartmentID == i.DepartmentID).ToList(); Depasments DataDepasments = new Depasments(); DataDepasments.DepasmentsName = i.DepartmentName; DataDepasments.DepasmentsID = i.DepartmentID; DataDepasments.DepasmentsCount = DataParts.Count; DataDepasments.CarCount = DetailOTnew.Where(d => !d.Type.Equals("No") && d.Employee.Department_DepartmentID == i.DepartmentID).ToList().Count; DataDepasments.FoodCount = DetailOTnew.Where(d => d.Employee.Department_DepartmentID == i.DepartmentID && !d.FoodSet.NameSet.Equals("No")).ToList().Count; List <Parts> Listparts = new List <Parts>(); foreach (var j in Part) { Parts parts = new Parts(); parts.PartID = j.PartID; parts.PartName = j.Name; IList <DetailOT> DataPart = DataParts.Where(d => !d.Point.Part.Name.Equals("No")).ToList(); DataPart = DataPart.Where(d => d.Employee.Department_DepartmentID == i.DepartmentID).ToList(); DataPart = DataPart.Where(d => d.Point.Point_PartID == j.PartID).ToList(); parts.PartsCount = DataPart.Where(d => !d.Type.Equals("No")).ToList().Count; if (parts.PartsCount != 0) { Listparts.Add(parts); } } DataDepasments.ListParts = Listparts; List <Foods> Listfoods = new List <Foods>(); foreach (var j in FoodSet) { Foods foods = new Foods(); foods.FoodID = j.FoodSetID; foods.FoodName = j.NameSet; var DataPart = DataParts; DataPart = DataPart.Where(d => d.FoodSet_FoodSetID == j.FoodSetID && ((d.TimeEnd.Hour == 17 && d.TimeEnd.Minute == 0) || (d.TimeStart.Hour == 8 && d.TimeStart.Minute == 0))).ToList(); foods.FoodsCount = DataPart.Count; if (foods.FoodsCount != 0) { Listfoods.Add(foods); } } DataDepasments.ListFoods = Listfoods; add.Add(DataDepasments); } return(add); }
private List <Depasments> OTDetailOTList() { List <Depasments> add = new List <Depasments>(); foreach (var i in Department) { Depasments DataDepasments = new Depasments(); DataDepasments.DepasmentsName = i.DepartmentName; DataDepasments.DepasmentsID = i.DepartmentID; DataDepasments.DepasmentsCount = DetailOTnew.Where(d => d.Employee.Employee_DepartmentID == i.DepartmentID).ToList().Count; DataDepasments.CarCount = DetailOTnew.Where(d => !d.Type.Equals("No") && d.Employee.Employee_DepartmentID == i.DepartmentID).ToList().Count; DataDepasments.FoodCount = DetailOTnew.Where(d => d.FoodSet_FoodSetID != 1 && d.Employee.Employee_DepartmentID == i.DepartmentID).ToList().Count; List <Parts> Listparts = new List <Parts>(); foreach (var j in Part) { Parts parts = new Parts(); parts.PartID = j.PartID; parts.PartName = j.Name; IList <DetailOT> DataPart = DetailOTnew.Where(d => d.Part_PaetID != 1).ToList(); DataPart = DataPart.Where(d => d.Employee.Employee_DepartmentID == i.DepartmentID).ToList(); DataPart = DataPart.Where(d => d.Part_PaetID == j.PartID).ToList(); parts.PartsCount = DataPart.Where(d => !d.Type.Equals("No")).ToList().Count; if (parts.PartsCount != 0) { Listparts.Add(parts); } } DataDepasments.ListParts = Listparts; List <Foods> Listfoods = new List <Foods>(); foreach (var j in FoodSet) { Foods foods = new Foods(); foods.FoodID = j.FoodSetID; foods.FoodName = j.NameSet; IList <DetailOT> DataPart = DetailOTnew.Where(d => d.FoodSet_FoodSetID != 1).ToList(); DataPart = DataPart.Where(d => d.Employee.Employee_DepartmentID == i.DepartmentID).ToList(); DataPart = DataPart.Where(d => d.FoodSet_FoodSetID == j.FoodSetID).ToList(); foods.FoodsCount = DataPart.Where(d => !d.Type.Equals("No")).ToList().Count; if (foods.FoodsCount != 0) { Listfoods.Add(foods); } } DataDepasments.ListFoods = Listfoods; add.Add(DataDepasments); } return(add); }