private void SavePriceProduct()
{
using (var db = new CowRationContext())
{
foreach (var item in storages)
{
Korm korm = db.Korms.Where(k => k.Id_korm == item.Id).FirstOrDefault();
korm.Price_korm = item.Price;
}
db.SaveChanges();
}
}
private DataRation GetRation()
{
using (var db = new CowRationContext())
{
foreach (var item in db.RationCows.Include("Milk").Include("Korm").Where(r => r.Milk.MilkQuantity == quantity).ToList())
{
RationGrid date = ration.Rations.Where(r => r.Name == item.Korm.Name_korm).FirstOrDefault();
if (date != null)
{
ration.Rations.Where(r => r.Name == item.Korm.Name_korm).FirstOrDefault().Value = item.Value;
ration.Rations.Where(r => r.Name == item.Korm.Name_korm).FirstOrDefault().Cost = item.Value * (double)item.Korm.Price_korm;
}
}
}
return(ration);
}
public RationFeetViewModel()
{
storages = new ObservableCollection <FeetGrid>();
using (var db = new CowRationContext())
{
foreach (var item in db.Korms.ToList())
{
storages.Add(new FeetGrid
{
Id = item.Id_korm,
Name = item.Name_korm,
Value = true,
Price = item.Price_korm
});
}
}
}
public LogicViewModel()
{
storages = new ObservableCollection <ProductGrid>();
using (var db = new CowRationContext())
{
foreach (var item in db.Storages.Include("Korm").ToList())
{
if (MainWindowViewModel.Rations.Where(r => r.Name == item.Korm.Name_korm).FirstOrDefault() != null)
{
storages.Add(new ProductGrid
{
Name = item.Korm.Name_korm,
Value = item.Quantity
});
}
}
}
}
public ArticleViewModel(DataMilk date)
{
this.date = date;
list = new ObservableCollection <ExpensisGrid>();
using (var db = new CowRationContext())
{
foreach (var item in db.Expenses.ToList())
{
double v = item.Value;
double p = v / expenses * 100;
list.Add(new ExpensisGrid
{
Article = item.Article,
Value = v,
Percenent = p
});
}
}
}
public LaboratoryViewModel(DataRation ration)
{
this.ration = ration;
list = new ObservableCollection <LaboratoryGrid>();
using (var db = new CowRationContext())
{
foreach (var item in db.Korms.ToList())
{
list.Add(new LaboratoryGrid
{
Name = item.Name_korm,
Sv = (db.FNutritionalCharacteristics.Where(k => k.Id_korm == item.Id_korm).Where(f => f.Id_index == 3).FirstOrDefault() ?? new FNutritionalCharacteristic()).FValue,
Sp = (db.FNutritionalCharacteristics.Where(k => k.Id_korm == item.Id_korm).Where(f => f.Id_index == 4).FirstOrDefault() ?? new FNutritionalCharacteristic()).FValue,
Sg = (db.FNutritionalCharacteristics.Where(k => k.Id_korm == item.Id_korm).Where(f => f.Id_index == 5).FirstOrDefault() ?? new FNutritionalCharacteristic()).FValue,
Sk = (db.FNutritionalCharacteristics.Where(k => k.Id_korm == item.Id_korm).Where(f => f.Id_index == 6).FirstOrDefault() ?? new FNutritionalCharacteristic()).FValue
});
}
}
}
public LogicController(CowRationContext db)
{
this.db = db;
}
public ResultFoodViewModel(DataRation ration)
{
this.ration = ration;
using (var db = new CowRationContext())
{
//Молокообразование ЧЭЛ,кг
double sumForm1 = 0;
foreach (var item in ration.Rations)
{
sumForm1 += item.Value * (db.NNutritionalCharacteristics.Include("Korm")
.Where(k => k.Korm.Name_korm == item.Name)
.Where(f => f.Id_index == 7).FirstOrDefault() ?? new NNutritionalCharacteristic())
.NValue;
}
MilkFormation = sumForm1 - ((0.528 * Math.Pow(535, 0.75) * 0.6 * 1.05) + 6);
////////////////////////
//Молокообразование nXP,кг
double sumForm2 = 0;
foreach (var item in ration.Rations)
{
sumForm2 += item.Value * (db.NNutritionalCharacteristics.Include("Korm")
.Where(k => k.Korm.Name_korm == item.Name)
.Where(f => f.Id_index == 13).FirstOrDefault() ?? new NNutritionalCharacteristic())
.NValue;
}
MilkXp = (sumForm2 - ((400 * 1.12) - 132)) / 84;
//////////////////////
//Потребление СВ,кг
double sumSv = 0;
string name;
for (int i = 0; i < 4; i++)
{
name = ration.Rations[i].Name.Trim();
sumSv += (ration.Rations[i].Value) * (db.FNutritionalCharacteristics.Include("Korm")
.Where(k => k.Korm.Name_korm == name)
.Where(f => f.Id_index == 3).FirstOrDefault() ?? new FNutritionalCharacteristic())
.FValue;
}
name = ration.Rations[5].Name.Trim();
MilkSv = sumSv + ((ration.Rations[5].Value) * (db.FNutritionalCharacteristics.Include("Korm")
.Where(k => k.Korm.Name_korm == name)
.Where(f => f.Id_index == 3).FirstOrDefault() ?? new FNutritionalCharacteristic())
.FValue);
////////////////////
//Клетчатка в СВ
double sumK1 = 0;
double sumK2 = 0;
foreach (var item in ration.Rations)
{
sumK1 += item.Value * (db.FNutritionalCharacteristics.Include("Korm")
.Where(k => k.Korm.Name_korm == item.Name)
.Where(f => f.Id_index == 3).FirstOrDefault() ?? new FNutritionalCharacteristic())
.FValue;
sumK2 += item.Value * (db.FNutritionalCharacteristics.Include("Korm")
.Where(k => k.Korm.Name_korm == item.Name)
.Where(f => f.Id_index == 6).FirstOrDefault() ?? new FNutritionalCharacteristic())
.FValue;
}
MilkCellulose = (sumK1 * 100) / (sumK2 * 1000);
//////////////////
//Ca:P
double sumCa1 = 0;
double sumCa2 = 0;
foreach (var item in ration.Rations)
{
sumCa1 += item.Value * (db.NNutritionalCharacteristics.Include("Korm")
.Where(k => k.Korm.Name_korm == item.Name)
.Where(f => f.Id_index == 9).FirstOrDefault() ?? new NNutritionalCharacteristic())
.NValue;
sumCa2 += item.Value * (db.NNutritionalCharacteristics.Include("Korm")
.Where(k => k.Korm.Name_korm == item.Name)
.Where(f => f.Id_index == 10).FirstOrDefault() ?? new NNutritionalCharacteristic())
.NValue;
}
MilkCa = sumCa1 / sumCa2;
/////////////////
//Влажность кормосмеси
double sumHumidity = 0;
foreach (var item in ration.Rations)
{
sumHumidity += item.Value * (db.FNutritionalCharacteristics.Include("Korm")
.Where(k => k.Korm.Name_korm == item.Name)
.Where(f => f.Id_index == 3).FirstOrDefault() ?? new FNutritionalCharacteristic())
.FValue;
}
//////////////////
Humidity = 100 - (sumHumidity / ration.Rations.Sum(r => r.Value)) * 100;
}
}
public EconomyController(CowRationContext context)
{
db = context;
}
public RationController(CowRationContext context)
{
db = context;
}
