private void TryAddPrice(CostPriceEntity toSave)
{
using (BlueBuilderDBContext context = new BlueBuilderDBContext())
{
context.CostsAndPrices.Add(toSave);
context.SaveChanges();
}
}
private void TrySettingPrice(int componentType, float newPrice)
{
using (BlueBuilderDBContext context = new BlueBuilderDBContext())
{
CostPriceEntity record = context.CostsAndPrices.FirstOrDefault(cp => cp.ComponentType == componentType);
record.Price = newPrice;
context.SaveChanges();
}
}
private float TryGettingCost(int componentType)
{
float cost;
using (BlueBuilderDBContext context = new BlueBuilderDBContext())
{
CostPriceEntity query = context.CostsAndPrices.FirstOrDefault(cp => cp.ComponentType == componentType);
cost = query.Cost;
}
return(cost);
}
private CostPriceEntity BuildCostPriceEntity(int componentType, float cost, float price)
{
CostPriceEntity toSave = new CostPriceEntity()
{
ComponentType = componentType,
Cost = cost,
Price = price
};
return(toSave);
}
public void AddCostPrice(int componentType, float cost, float price)
{
CostPriceEntity toSave = BuildCostPriceEntity(componentType, cost, price);
try {
TryAddPrice(toSave);
}
catch (EntityException) {
throw new InaccessibleDataException();
}
}
