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; }