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);
}
