public Prepack AddPrepack(string name, string description, double finalVolume, byte measure,
string vendorCode, DateTime start, DateTime end,
double cleanLoss, double fryLoss, double otherLosses,
double protains, double fats, double carbohydrates, double energyCalorie, double energyJoule)
{
Prepack p = new Prepack
{
Name = name,
Description = description,
FinalVolume = finalVolume,
IsExist = true,
Measure = (Measure)measure,
VendorCode = vendorCode,
CookStartTime = start,
CookEndTime = end,
LossDuringCleaning = cleanLoss,
LossDuringFrying = fryLoss,
OtherLosses = otherLosses,
Energy =
{
Protains = protains,
Fats = fats,
Carbohydrates = carbohydrates,
EnergyCalorie = energyCalorie,
EnergyJoule = energyJoule,
},
};
cont.Prepack.Add(p);
cont.SaveChanges();
return(p);
}
public Prepack AddPrepack(Prepack prepack)
{
Prepack p = new Prepack
{
Name = prepack.Name,
Description = prepack.Description,
FinalVolume = prepack.FinalVolume,
IsExist = true,
Measure = prepack.Measure,
VendorCode = prepack.VendorCode,
CookStartTime = prepack.CookStartTime,
CookEndTime = prepack.CookEndTime,
LossDuringCleaning = prepack.LossDuringCleaning,
LossDuringFrying = prepack.LossDuringFrying,
OtherLosses = prepack.OtherLosses,
Energy = prepack.Energy,
};
prepack.IsExist = false;
cont.Prepack.Add(p);
cont.SaveChanges();
return(p);
}
static public IEnumerable <RecipePrepPrep> GetRecipesPrepIngsByResult(Prepack result, IEnumerable <RecipePrepPrep> RecipePrepPreps)
{
if (RecipePrepPreps == null)
{
RecipePrepPreps = cont.RecipePrepPrep.OrderBy(c => c.Id);
}
return(RecipePrepPreps.ToList().FindAll(p => p.Result.Id == result.Id));
}
static public IEnumerable <RecipeDishPrep> GetRecipesPrepIngsByPrepack(Prepack prepack, IEnumerable <RecipeDishPrep> RecipeDishPreps)
{
if (RecipeDishPreps == null)
{
RecipeDishPreps = cont.RecipeDishPrep.OrderBy(c => c.Id);
}
return(RecipeDishPreps.ToList().FindAll(p => p.Prepack.Id == prepack.Id));
}
static public IEnumerable <RecipePrepIngr> GetRecipesPrepIngsByPrepack(Prepack prepack, IEnumerable <RecipePrepIngr> recipePrepIngrs)
{
if (recipePrepIngrs == null)
{
recipePrepIngrs = cont.RecipePrepIngr.OrderBy(c => c.Id);
}
return(recipePrepIngrs.ToList().FindAll(p => p.Prepack.Id == prepack.Id));
}
public ActionResult Index(Prepack model)
{
if (ModelState.IsValid)
{
model.Save();
}
ViewBag.UnitsList = model.Unit.ToSelectList();
ViewBag.Title = Helpers.PageHelpers.GetPageTitle(model);
return(View(model));
}
public RecipePrepPrep AddRecipePrepPrep(double volume, string description, Prepack prepack, Prepack result)
{
RecipePrepPrep p = new RecipePrepPrep
{
Volume = volume,
Description = description,
Prepack = prepack,
Result = result,
};
cont.RecipePrepPrep.Add(p);
cont.SaveChanges();
return(p);
}
public RecipeDishPrep AddRecipeDishPrep(double volume, string description, Prepack prepack, Dish dish)
{
RecipeDishPrep p = new RecipeDishPrep
{
Volume = volume,
Description = description,
Prepack = prepack,
Dish = dish,
};
cont.RecipeDishPrep.Add(p);
cont.SaveChanges();
return(p);
}
public PrepackViewModel()
{
Entity = new Prepack();
}
public Prepack EditPrepack(string vendorCode, string name, string description, double finalVolume, byte measure,
DateTime start, DateTime end,
double cleanLoss, double fryLoss, double otherLosses,
double protains, double fats, double carbohydrates, double energyCalorie, double energyJoule)
{
Prepack p = cont.Prepack.SingleOrDefault(pr => pr.IsExist && pr.VendorCode == vendorCode);
if (cont.RecipeDishPrep.ToList().Exists(r => r.Prepack.Id == p.Id) ||
cont.RecipePrepPrep.ToList().Exists(r => r.Prepack.Id == p.Id) ||
cont.RecipePrepPrep.ToList().Exists(r => r.Result.Id == p.Id) ||
cont.RecipePrepIngr.ToList().Exists(r => r.Prepack.Id == p.Id))
{
IEnumerable <RecipeDishPrep> rdp = cont.RecipeDishPrep.ToList().FindAll(r => r.Dish.IsExist && r.Prepack.IsExist && r.Prepack.VendorCode == vendorCode);
IEnumerable <RecipePrepPrep> rrp = cont.RecipePrepPrep.ToList().FindAll(r => r.Result.IsExist && r.Prepack.IsExist && r.Prepack.VendorCode == vendorCode);
IEnumerable <RecipePrepPrep> rpr = cont.RecipePrepPrep.ToList().FindAll(r => r.Result.IsExist && r.Prepack.IsExist && r.Result.VendorCode == vendorCode);
IEnumerable <RecipePrepIngr> rpi = cont.RecipePrepIngr.ToList().FindAll(r => r.Ingredient.IsExist && r.Prepack.IsExist && r.Prepack.VendorCode == vendorCode);
p = AddPrepack(p);
List <Dish> dishes = new List <Dish>(rdp.Select(r => r.Dish)).Distinct().ToList();
foreach (Dish d in dishes)
{
Dish dish = new DishRepository(cont).AddDish(d);
foreach (RecipeDishPrep rd in cont.RecipeDishPrep.ToList().FindAll(r => r.Dish.Id == d.Id))
{
new RecipeDishPrepRepository(cont).AddRecipeDishPrep(rd.Volume, rd.Description, p, dish);
}
}
List <Prepack> results = new List <Prepack>(rrp.Select(r => r.Result)).Distinct().ToList();
foreach (Prepack res in results)
{
Prepack result = AddPrepack(res);
foreach (RecipePrepPrep rd in cont.RecipePrepPrep.ToList().FindAll(r => r.Result.Id == res.Id))
{
new RecipePrepPrepRepository(cont).AddRecipePrepPrep(rd.Volume, rd.Description, p, result);
}
}
foreach (RecipePrepPrep r in rpr)
{
new RecipePrepPrepRepository(cont).AddRecipePrepPrep(r.Volume, r.Description, r.Prepack, p);
}
foreach (RecipePrepIngr r in rpi)
{
new RecipePrepIngrRepository(cont).AddRecipePrepIngr(r.Volume, r.Description, r.Ingredient, p);
}
}
else
{
p = cont.Prepack.SingleOrDefault(c => c.VendorCode.Equals(vendorCode));
p.Name = name;
p.Description = description;
p.FinalVolume = finalVolume;
p.Measure = (Measure)measure;
p.CookStartTime = start;
p.CookEndTime = end;
p.LossDuringCleaning = cleanLoss;
p.LossDuringFrying = fryLoss;
p.OtherLosses = otherLosses;
p.Energy = new EnergyValue
{
Protains = protains,
Fats = fats,
Carbohydrates = carbohydrates,
EnergyCalorie = energyCalorie,
EnergyJoule = energyJoule,
};
}
cont.SaveChanges();
return(p);
}
public RecipePrepIngr AddRecipePrepIngr(double volume, string description, Product ingredient, Prepack prepack)
{
RecipePrepIngr p = new RecipePrepIngr
{
Volume = volume,
Description = description,
Ingredient = ingredient,
Prepack = prepack,
};
cont.RecipePrepIngr.Add(p);
cont.SaveChanges();
return(p);
}
