SQL to LINQ Conversion: Calculate Charge Capacity by Year, Month, and Day

var startTimeYear_1 = new DateTime(2023, 1, 1, 0, 0, 0);\nvar endTimeYear_2 = new DateTime(2023, 12, 31, 23, 59, 59, 999);\nvar startTimeMonth_3 = new DateTime(2023, 7, 1, 0, 0, 0);\nvar endTimeMonth_4 = new DateTime(2023, 7, 31, 23, 59, 59, 999);\nvar startTimeDay_5 = new DateTime(2023, 7, 4, 0, 0, 0);\nvar endTimeDay_6 = new DateTime(2023, 7, 4, 23, 59, 59, 999);\n\nvar chargeCapacityYear = (\n from c0 in Charging_Order\n join e1 in Equipment_ChargingGunsInfo on c0.ChargingGunId equals e1.Id\n join e2 in Equipment_ChargingPileInfo on e1.ChargingPileId equals e2.Id\n where !c0.Deleted && !e1.Deleted && e1.IsEnable && !e2.Deleted && e2.IsEnable && e2.EnterpriseId == "1638003434462388224" && c0.ChargingBeginTime >= startTimeYear_1 && c0.ChargingBeginTime <= endTimeYear_2\n select c0.ChargeCapacity ?? 0.0\n).Sum();\n\nvar chargeCapacityMonth = (\n from c1 in Charging_Order\n join e3 in Equipment_ChargingGunsInfo on c1.ChargingGunId equals e3.Id\n join e4 in Equipment_ChargingPileInfo on e3.ChargingPileId equals e4.Id\n where !c1.Deleted && !e3.Deleted && e3.IsEnable && !e4.Deleted && e4.IsEnable && e4.EnterpriseId == "1638003434462388224" && c1.ChargingBeginTime >= startTimeMonth_3 && c1.ChargingBeginTime <= endTimeMonth_4\n select c1.ChargeCapacity ?? 0.0\n).Sum();\n\nvar chargeCapacityDay = (\n from c2 in Charging_Order\n join e5 in Equipment_ChargingGunsInfo on c2.ChargingGunId equals e5.Id\n join e6 in Equipment_ChargingPileInfo on e5.ChargingPileId equals e6.Id\n where !c2.Deleted && !e5.Deleted && e5.IsEnable && !e6.Deleted && e6.IsEnable && e6.EnterpriseId == "1638003434462388224" && c2.ChargingBeginTime >= startTimeDay_5 && c2.ChargingBeginTime <= endTimeDay_6\n select c2.ChargeCapacity ?? 0.0\n).Sum();\n\nvar result = new {\n ChargeCapacityYear = chargeCapacityYear,\n ChargeCapacityMonth = chargeCapacityMonth,\n ChargeCapacityDay = chargeCapacityDay\n};