private static void Aggreation_On_Cars(List <Car> cars)
{
var Query = from car in cars
group car by car.Division
into CarGroup
select new
{
name = CarGroup.Key,
max = CarGroup.Max(c => c.FE_Comb),
min = CarGroup.Min(c => c.FE_Comb),
avg = CarGroup.Average(c => c.FE_Comb)
} into result
orderby result.max descending
select result;
var Query2 = cars.GroupBy(c => c.Division)
.Select(g => new
{
name = g.Key,
max = g.Max(c => c.FE_Comb),
min = g.Min(c => c.FE_Comb),
avg = g.Average(c => c.FE_Comb)
})
.OrderByDescending(r => r.max);
foreach (var result in Query2)
{
Console.WriteLine($"Name : {result.name}");
Console.WriteLine($"\tMaximum FE : {result.max}");
Console.WriteLine($"\tMinimum FE : {result.min}");
Console.WriteLine($"\tAverage FE : {result.avg}");
}
}
public List <CarGroup> CarGroupListGetByCountryID(string countryID)
{
var carGroupList = new List <CarGroup>();
SqlConnection con = DBManager.CreateConnection();
SqlCommand cmd = DBManager.CreateProcedure(StoredProcedures.CarGroupGetByCountryID, con);
cmd.Parameters.Add(Parameters.Country, SqlDbType.VarChar, 3);
cmd.Parameters[Parameters.Country].Value = countryID;
cmd.Parameters[Parameters.Country].Direction = ParameterDirection.Input;
using (con)
{
con.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
var carGroup = new CarGroup();
if (reader["car_group_id"] != DBNull.Value)
{
carGroup.CarGroupID = Convert.ToInt32(reader["car_group_id"]);
}
if (reader["car_group"] != DBNull.Value)
{
carGroup.CarGroupDescription = reader["car_group"].ToString();
}
carGroupList.Add(carGroup);
}
}
return(carGroupList);
}
public async Task Add(CarGroup carGroup)
{
await Context.Set <CarGroup>()
.AddAsync(carGroup);
await Context.SaveChangesAsync();
}
public async Task Add(CarGroupAddDto carGroupDto)
{
var carGroupRepository = DataContextManager.CreateRepository <ICarGroupRepository>();
var carGroup = await carGroupRepository.GetByName(carGroupDto.Name);
if (carGroup != null)
{
throw new AddingException();
}
var carSubgroupRepository = DataContextManager.CreateRepository <ICarSubgroupRepository>();
var carSubgroups = await carSubgroupRepository.GetByIds(carGroupDto.CarSubgroupIds);
var newCarGroup = new CarGroup
{
Name = carGroupDto.Name,
CreateDate = DateTime.Now,
CarSubgroupInCarGroups = carSubgroups.Select(carSubgroup => new CarSubgroupInCarGroup
{
CarSubgroup = carSubgroup
})
.ToList()
};
await carGroupRepository.Add(newCarGroup);
}
public ActionResult DeleteConfirmed(int id)
{
CarGroup carGroup = db.CarGroups.Find(id);
db.CarGroups.Remove(carGroup);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "CarGroupId,CarGroupType")] CarGroup carGroup)
{
if (ModelState.IsValid)
{
db.Entry(carGroup).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(carGroup));
}
public ActionResult Create([Bind(Include = "CarGroupId,CarGroupType")] CarGroup carGroup)
{
if (ModelState.IsValid)
{
db.CarGroups.Add(carGroup);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(carGroup));
}
// GET: CarGroups/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
CarGroup carGroup = db.CarGroups.Find(id);
if (carGroup == null)
{
return(HttpNotFound());
}
return(View(carGroup));
}
private void DeleteCarSubgroups(CarGroup carGroup, IEnumerable <CarSubgroup> carSubgroups)
{
var carSubgroupIdsToDelete = new List <int>();
foreach (var carSubgroupInCarGroup in carGroup.CarSubgroupInCarGroups)
{
if (!carSubgroups.Any(x => x.Id == carSubgroupInCarGroup.CarSubgroupId))
{
carSubgroupIdsToDelete.Add(carSubgroupInCarGroup.CarSubgroupId);
}
}
carGroup.CarSubgroupInCarGroups.RemoveAll(x => carSubgroupIdsToDelete.Contains(x.CarSubgroupId));
}
private void AddCarSubgroups(CarGroup carGroup, IEnumerable <CarSubgroup> carSubgroups)
{
foreach (var carSubgroup in carSubgroups)
{
if (!carGroup.CarSubgroupInCarGroups.Any(x => x.CarSubgroupId == carSubgroup.Id))
{
carGroup.CarSubgroupInCarGroups.Add(new CarSubgroupInCarGroup
{
CarGroupId = carGroup.Id,
CarSubgroupId = carSubgroup.Id
});
}
}
}
public ICollection <CarGroup> GetCarCategories()
{
List <CarGroup> carGroups = new List <CarGroup>();
string filePath = "C:\\AUTOS_GROUP.xlsx";
FileInfo fileInfo = new FileInfo(filePath);
using (ExcelPackage excelPackage = new ExcelPackage(fileInfo))
{
ExcelWorksheet worksheet = excelPackage.Workbook.Worksheets.FirstOrDefault();
int totalColum = worksheet.Dimension.End.Column;
int totalRow = worksheet.Dimension.End.Row;
for (int row = 2; row <= totalRow; row++)
{
CarGroup carGroup = new CarGroup();
for (int col = 1; col <= totalColum; col++)
{
if (col == 1)
{
carGroup.GroupId = worksheet.Cells[row, col].Value.ToString();
}
if (col == 2)
{
carGroup.NMarc = worksheet.Cells[row, col].Value.ToString();
}
if (col == 3)
{
carGroup.CGroup = worksheet.Cells[row, col].Value.ToString();
}
if (col == 4)
{
carGroup.NGroup = worksheet.Cells[row, col].Value.ToString();
}
}
carGroups.Add(carGroup);
}
}
return(carGroups);
}
public List <CarGroup> CarsWithAverageConsumption()
{
List <RefuelingEntry> r;
List <CarGroup> groupslist = new List <CarGroup>();
using (UnitOfWork uof = new UnitOfWork(new Fuel.DAL.EF6.FuelContext()))
{
r = uof.RefuelingRepository.GetRefuelingHistory();
}
var collection = r.GroupBy(x => x.carname);
foreach (var group in collection)
{
CarGroup cargroup = new CarGroup();
cargroup.groupname = group.Key;
cargroup.averageconsumption = group.ToList().Average(x => x.consumption);
groupslist.Add(cargroup);
}
return(groupslist);
}
public IActionResult Index()
{
List <CarGroup> carGroups = _carGroupService.GetCarCategories().ToList();
List <CarRequest> carRequest = _carService.GetCarRequest().ToList();
List <CarGroup> carGroupResponse = new List <CarGroup>();
List <CarResponse> carResponse = new List <CarResponse>();
carRequest.Select(cr =>
{
CarGroup carGroup = carGroups.Where(cg => cg.CGroup == cr.Amis).FirstOrDefault();;
if (carGroup == null)
{
int newCarGroupId = carGroups.Max(x => Convert.ToInt32(x.GroupId) + 1);
carGroup = new CarGroup
{
GroupId = newCarGroupId.ToString(),
CGroup = cr.Amis,
NGroup = cr.Tipo,
NMarc = cr.Marca
};
carGroups.Add(carGroup);
carGroupResponse.Add(carGroup);
}
CarResponse carResp = new CarResponse
{
Anioe = cr.Modelo,
Codia = cr.Amis,
Model = cr.Descripcion,
Marca = cr.Marca,
NGrup = cr.Tipo,
CGrup = carGroup.GroupId,
Creas = "0",
IDSX = "0",
NMarca = "0",
NMode = "0",
Pre01 = "0",
Pre02 = "0",
Pre03 = "0",
Pre04 = "0",
Pre05 = "0",
Pre06 = "0",
Pre07 = "0",
Pre08 = "0",
Pre09 = "0",
Pre10 = "0",
Pre11 = "0",
Pre12 = "0",
Pre13 = "0",
Pre14 = "0",
Pre15 = "0",
Pre16 = "0",
Pre17 = "0",
Pre18 = "0",
Pre19 = "0",
Pre20 = "0"
};
carResponse.Add(carResp);
return(true);
}).ToList();
//return CarGroupCSV(carGroupResponse);
return(CarCSV(carResponse));
}
public NecessaryFleet()
{
Country = new Country();
LocationGroup = new LocationGroup();
CarGroup = new CarGroup();
}
public async Task Update(CarGroup carGroup)
{
Context.Entry <CarGroup>(carGroup).State = EntityState.Modified;
await Context.SaveChangesAsync();
}
