public IQueryable<BatteryCollection> GetBatteryCollectionByStorage(BatteryStorage batteryStorage)
{
var batteryCollection = db.BatteryCollections.Where(x => x.BatteryStorageId.Equals(batteryStorage.ID));
foreach (var collection in batteryCollection)
{
collection.Battery = _batteryRepo.GetBatteryById(collection.BatteryId);
}
return batteryCollection;
}
public void Update(BatteryStorage batteryStorage)
{
BatteryStorage rBatteryStorage = GetBatteryStorageById(batteryStorage.ID);
if (rBatteryStorage == null)
return;
rBatteryStorage.Available = batteryStorage.Available;
rBatteryStorage.Charging = batteryStorage.Charging;
rBatteryStorage.Reserved = batteryStorage.Reserved;
db.SaveChanges();
}
public void UpdateStorageStatus(BatteryStorage batteryStorage)
{
if(batteryStorage == null)
return;
int available = batteryStorage.BatteryCollections.Count(x => x.Battery.Status == 1);
int charging = batteryStorage.BatteryCollections.Count(x => x.Battery.Status == 2);
int reserved = batteryStorage.BatteryCollections.Count(x => x.Battery.Status == 3);
batteryStorage.Available = available;
batteryStorage.Charging = charging;
batteryStorage.Reserved = reserved;
Update(batteryStorage);
}
public void Insert(BatteryStorage batteryStorage)
{
db.BatteryStorages.Add(batteryStorage);
db.SaveChanges();
}
