protected override async Task OnInitializedAsync()
{
Household = await HouseholdDataService.GetHouseholdById(int.Parse(HouseholdId));
Fridges.AddRange(Household.Fridges);
IsOffline = !FrinfoHttpClient.IsOnline;
EventAggregator.SubscribeOnPublishedThread(this);
}
public async Task DeleteFridge(int fridgeID)
{
try
{
var fridgeToDelete = Fridges.FirstOrDefault(x => x.FridgeId == fridgeID);
context.Fridge.Remove(fridgeToDelete);
await context.SaveChangesAsync();
}
catch (Microsoft.EntityFrameworkCore.DbUpdateException)
{
return;
}
}
public IQueryable <Fridge> GetFridgesNaviagtion()
{
return(Fridges
.Include(col => col.ShelfSet)
.ThenInclude(sh => sh.ShelfSymbolNavigation)
.Include(col => col.HandleSet)
.ThenInclude(han => han.HandleSymbolNavigation)
.Include(col => col.AdditionalSet)
.ThenInclude(ad => ad.AdditionalEqSymbolNavigation)
.Include(col => col.BalconySet)
.ThenInclude(bl => bl.BalconySymbolNavigation)
.Include(col => col.BodySymbolNavigation)
.Include(col => col.CompressorSymbolNavigation));
}
protected async Task DeleteFridge(Fridge fridge)
{
var wasRemoveSuccessfull = await FridgeDataService.DeleteFridge(Household.HouseholdId, fridge.FridgeId);
if (wasRemoveSuccessfull)
{
Fridges.Remove(fridge);
StateHasChanged();
ToastService.ShowInfo($"Removed {fridge.Name}");
}
else
{
ToastService.ShowError($"Failed to remove {fridge.Name}", "Delete Failed");
}
}
public bool HasFridge(Fridge compareFridge)
{
//bool hasFridge = false;
//foreach (Fridge fridge in Fridges)
//{
// if (fridge.Equals(compareFridge))
// {
// hasFridge = true;
// }
//}
//return hasFridge;
return(Fridges.Contains(compareFridge));
}
public void Fill()
{
FillMainData();
Checks = _dataSet.Tables[0].AsEnumerable().Select(dataRow =>
new Check
{
Id = dataRow.Field <long>("Id"),
Number = dataRow.Field <string>("Number"),
Date = dataRow.Field <DateTime>("Date"),
Buyer = Buyers.Where(b => b.Id == dataRow.Field <long>("BuyerFk")).Single(),
Seller = Sellers.Where(s => s.Id == dataRow.Field <long>("SellerFk")).Single(),
Fridge = Fridges.Where(f => f.Id == dataRow.Field <long>("FridgeFk")).Single()
}).ToList();
_dataSet.Clear();
}
private List <Fridge> FillFridgeList()
{
Fridges.Clear();
_dataSet.Clear();
_command = "SELECT Id, Brand, Number FROM Fridges";
_sqlDataAdapter.SelectCommand = new SqlCommand(_command, _sqlConnection);
_sqlDataAdapter.Fill(_dataSet);
Fridges = _dataSet.Tables[0].AsEnumerable().Select(dataRow =>
new Fridge
{
Id = dataRow.Field <long>("Id"),
Brand = dataRow.Field <string>("Brand"),
Number = dataRow.Field <string>("Number").ToString()
}).ToList();
_dataSet.Clear();
return(Fridges);
}
public async Task CreateOrder(int userID, int addressID, IEnumerable <Fridge> fridges, decimal price)
{
PurchaseOrder order = new PurchaseOrder
{
UserId = userID,
AddressId = addressID,
ActualState = 1,
OrderState = new List <OrderState>
{
new OrderState
{
Data = DateTime.Now,
State = 1
}
},
TotalValue = price
};
context.PurchaseOrder.Add(order);
context.SaveChanges();
foreach (var fridge in fridges)
{
var result = IsRepeated(fridge);
if (result == null)
{
await CreateFridge(fridge);
result = fridge.FridgeId;
}
else
{
Fridges.Where(x => x.FridgeId == result).FirstOrDefault().Bought += 1;
}
await CreateSpecimen(fridge, (int)result, order.OrderId);
}
await context.SaveChangesAsync();
}
public int GetFridgesQuantity()
{
return(Fridges.Count());
}
public IEnumerable <Fridge> GetFridges()
{
return(Fridges.AsEnumerable());
}
public Fridge GetFridge(int fridgeId)
{
return(Fridges.Include(x => x.BodySymbolNavigation).FirstOrDefault(x => x.FridgeId == fridgeId));
}
