public void Create(DefaultProduct entity) { using (var context = new ListItContext()) { var result = context.Set <DefaultProduct>().Add(entity); try { context.SaveChanges(); } catch (System.Data.Entity.Validation.DbEntityValidationException e) { StringBuilder builder = new StringBuilder(); foreach (var eve in e.EntityValidationErrors) { builder.Append("Entity of type " + eve.Entry.Entity.GetType().Name + " in state " + eve.Entry.State + " has the following" + " validation errors:"); foreach (var ve in eve.ValidationErrors) { builder.Append("Property: " + ve.PropertyName + ", Error: " + ve.ErrorMessage); } } throw new Exception(builder.ToString()); } } }
public ActionResult Index() { User user; int c = 0, f = 0, p = 0, car = 0; List <DefaultProduct> d_products = new List <DefaultProduct> { }; List <CustomProduct> c_products = new List <CustomProduct> { }; using (UserContext db = new UserContext()) { user = db.Users.FirstOrDefault(x => x.Email == User.Identity.Name); } if (user.Sex == null || user.Height == null || user.Weight == null) { return(HttpNotFound()); } var daybook = dbDaybook.Daybooks.Where(x => x.UserId == user.UserId); foreach (var item in daybook) { if (item.Custom == false) { DefaultProduct defaultProduct = dbDefaultProduct.DefaultProducts.Find(item.ProductId); c += defaultProduct.Calories * (item.Gram / 100); f += defaultProduct.Fats * (item.Gram / 100); p += defaultProduct.Protein * (item.Gram / 100); car += defaultProduct.Carbs * (item.Gram / 100); d_products.Add(defaultProduct); } else { CustomProduct customProduct = dbCustomProduct.CustomProducts.Find(item.ProductId); c += customProduct.Calories * (item.Gram / 100); f += customProduct.Fats * (item.Gram / 100); p += customProduct.Protein * (item.Gram / 100); car += customProduct.Carbs * (item.Gram / 100); c_products.Add(customProduct); } } ViewBag.c = c; ViewBag.f = f; ViewBag.p = p; ViewBag.car = car; ViewBag.dp = d_products; ViewBag.cp = c_products; ViewBag.Daybook = daybook; ViewBag.Calories = (int)((user.Weight * 10 + (user.Height * 6.25) - ((DateTime.UtcNow.Month < user.BirthDate.Month || (DateTime.UtcNow.Month == user.BirthDate.Month && DateTime.UtcNow.Day < user.BirthDate.Day)) ? (DateTime.UtcNow.Year - user.BirthDate.Year) : (DateTime.UtcNow.Year - user.BirthDate.Year) - 1) + (user.Sex == true ? 5 : -161)) * 1.2 - c); ViewBag.DefaultProducts = dbDefaultProduct.DefaultProducts.ToList().ToList(); ViewBag.CustomProducts = dbCustomProduct.CustomProducts.Where(x => x.UserId == user.UserId).ToList(); return(View()); }
public ActionResult DeleteProduct() { User user; int allCalories = 0, fats = 0, protein = 0, carbs = 0; using (UserContext db = new UserContext()) { user = db.Users.FirstOrDefault(x => x.Email == User.Identity.Name); } string id = Request.QueryString["id"]; DaybookProduct daybookProduct = dbDaybook.Daybooks.Find(Convert.ToInt32(id)); dbDaybook.Daybooks.Remove(daybookProduct); dbDaybook.SaveChanges(); var daybook = dbDaybook.Daybooks.Where(x => x.UserId == user.UserId); foreach (var item in daybook) { if (item.Custom == false) { DefaultProduct defaultP = dbDefaultProduct.DefaultProducts.Find(item.ProductId); allCalories += defaultP.Calories * (item.Gram / 100); fats += defaultP.Fats * (item.Gram / 100); protein += defaultP.Protein * (item.Gram / 100); carbs += defaultP.Carbs * (item.Gram / 100); } else { CustomProduct customP = dbCustomProduct.CustomProducts.Find(item.ProductId); allCalories += customP.Calories * (item.Gram / 100); fats += customP.Fats * (item.Gram / 100); protein += customP.Protein * (item.Gram / 100); carbs += customP.Carbs * (item.Gram / 100); } } int caloriesNeeded = (int)((user.Weight * 10 + (user.Height * 6.25) - ((DateTime.UtcNow.Month < user.BirthDate.Month || (DateTime.UtcNow.Month == user.BirthDate.Month && DateTime.UtcNow.Day < user.BirthDate.Day)) ? (DateTime.UtcNow.Year - user.BirthDate.Year) : (DateTime.UtcNow.Year - user.BirthDate.Year) - 1) + (user.Sex == true ? 5 : -161)) * 1.2) - allCalories; return(Json(new { caloriesNeeded, allCalories, fats, protein, carbs }, JsonRequestBehavior.AllowGet)); }
public static DefaultProductDto StaticDBToDto(DefaultProduct defaultProduct) { return(new DefaultProductDto { Id = defaultProduct.Id, //Name = defaultProduct.Name, Currency_Id = defaultProduct.Currency_Id, Unit_Id = defaultProduct.UnitType_Id, Price = defaultProduct.Price, //Category_Id = defaultProduct.Category_Id, //ProductTypeId = from ProductTable ProductId = (int)defaultProduct.Product_Id }); }
public static ProductDto StaticDBToDto(Product product, DefaultProduct defaultProduct, ShoppingListEntry entry, TranslationOfProduct translation, LinkDefaultProductToCategory category) { return(new ProductDto { Id = entry.Id, ProductTypeId = product.ProductType_Id, Name = translation.Translation, Currency_Id = (int)defaultProduct.Currency_Id, Unit_Id = (int)defaultProduct.UnitType_Id, Quantity = (int)entry.Quantity, Price = (decimal)defaultProduct.Price, ProductId = product.Id, Category_Id = category.CategoryId }); }
public static DefaultProductDto StaticDBToDto(DefaultProduct defaultProduct, TranslationOfProduct translation, LinkDefaultProductToCategory category) { if (defaultProduct == null || translation == null || category == null) { return(null); } return(new DefaultProductDto { Id = defaultProduct.Id, Name = translation.Translation, Currency_Id = defaultProduct.Currency_Id, Unit_Id = defaultProduct.UnitType_Id, Price = defaultProduct.Price, Category_Id = category.CategoryId, ProductTypeId = 1, //= DefaultProduct ProductId = (int)defaultProduct.Product_Id }); }
public static IProduct GetProduct(DimProduct dimProduct) { IProduct product; switch (dimProduct.ProductKey) { case 0: product = new DefaultProduct(); break; default: product = new Product(); break; } product.Fill(dimProduct); return(product); }
public void Create(DefaultProductDto dto, int langId) { var product = new Product { Id = dto.ProductId, Timestamp = DateTime.Now, ProductType_Id = dto.ProductTypeId }; var prodId = _prodRepository.CreateProduct(product); var defaultProduct = new DefaultProduct { Id = dto.Id, Product_Id = prodId, Currency_Id = dto.Currency_Id, UnitType_Id = dto.Unit_Id, Price = dto.Price, }; _prodRepository.Create(defaultProduct); // Save name var translation = new TranslationOfProduct { Language_Id = langId, Product_Id = prodId, Translation = dto.Name }; _prodRepository.SaveDefaultProductName(translation); // Link category var categoryrelation = new LinkDefaultProductToCategory { DefaultProductId = prodId, CategoryId = (int)dto.Category_Id }; _prodRepository.SaveDefaultProductCategory(categoryrelation); }
public void Create(DefaultProductDto dto) { var product = new Product { Id = dto.ProductId, Timestamp = DateTime.Now, ProductType_Id = dto.ProductTypeId }; var prodId = _prodRepository.CreateProduct(product); var defaultProduct = new DefaultProduct { Id = dto.Id, Product_Id = prodId, Currency_Id = dto.Currency_Id, UnitType_Id = dto.Unit_Id, Price = dto.Price, }; _prodRepository.Create(defaultProduct); // Link category }
public ActionResult AddProduct() { User user; int id; int allCalories = 0, fats = 0, protein = 0, carbs = 0; using (UserContext db = new UserContext()) { user = db.Users.FirstOrDefault(x => x.Email == User.Identity.Name); } string selectId = Request.QueryString["id"]; string product = Request.QueryString["product"]; int gram = Convert.ToInt32(Request.QueryString["g"]); if (Convert.ToBoolean(product)) { CustomProduct customProduct; using (CustomProductContext dbCustomProduct = new CustomProductContext()) { customProduct = dbCustomProduct.CustomProducts.Find(Convert.ToInt32(selectId)); } using (DaybookContext dbDaybook = new DaybookContext()) { DaybookProduct daybookProduct = new DaybookProduct { UserId = user.UserId, ProductId = customProduct.Id, Custom = Convert.ToBoolean(product), Gram = gram }; dbDaybook.Daybooks.Add(daybookProduct); dbDaybook.SaveChanges(); id = daybookProduct.Id; } var daybook = dbDaybook.Daybooks.Where(x => x.UserId == user.UserId); foreach (var item in daybook) { if (item.Custom == false) { DefaultProduct defaultP = dbDefaultProduct.DefaultProducts.Find(item.ProductId); allCalories += defaultP.Calories * (item.Gram / 100); fats += defaultP.Fats * (item.Gram / 100); protein += defaultP.Protein * (item.Gram / 100); carbs += defaultP.Carbs * (item.Gram / 100); } else { CustomProduct customP = dbCustomProduct.CustomProducts.Find(item.ProductId); allCalories += customP.Calories * (item.Gram / 100); fats += customP.Fats * (item.Gram / 100); protein += customP.Protein * (item.Gram / 100); carbs += customP.Carbs * (item.Gram / 100); } } int caloriesNeeded = (int)((user.Weight * 10 + (user.Height * 6.25) - ((DateTime.UtcNow.Month < user.BirthDate.Month || (DateTime.UtcNow.Month == user.BirthDate.Month && DateTime.UtcNow.Day < user.BirthDate.Day)) ? (DateTime.UtcNow.Year - user.BirthDate.Year) : (DateTime.UtcNow.Year - user.BirthDate.Year) - 1) + (user.Sex == true ? 5 : -161)) * 1.2) - allCalories; return(Json(new { addId = id, addName = customProduct.Name, addCalories = customProduct.Calories * gram / 100, addFats = customProduct.Fats * gram / 100, addProtein = customProduct.Protein * gram / 100, addCarbs = customProduct.Carbs * gram / 100, caloriesNeeded, allCalories, fats, protein, carbs }, JsonRequestBehavior.AllowGet)); } else { DefaultProduct defaultProduct; using (DefaultProductContext dbDefaultProduct = new DefaultProductContext()) { defaultProduct = dbDefaultProduct.DefaultProducts.Find(Convert.ToInt32(selectId)); } using (DaybookContext dbDaybook = new DaybookContext()) { DaybookProduct daybookProduct = new DaybookProduct { UserId = user.UserId, ProductId = defaultProduct.Id, Custom = Convert.ToBoolean(product), Gram = gram }; dbDaybook.Daybooks.Add(daybookProduct); dbDaybook.SaveChanges(); id = daybookProduct.Id; } var daybook = dbDaybook.Daybooks.Where(x => x.UserId == user.UserId); foreach (var item in daybook) { if (item.Custom == false) { DefaultProduct defaultP = dbDefaultProduct.DefaultProducts.Find(item.ProductId); allCalories += defaultP.Calories * (item.Gram / 100); fats += defaultP.Fats * (item.Gram / 100); protein += defaultP.Protein * (item.Gram / 100); carbs += defaultP.Carbs * (item.Gram / 100); } else { CustomProduct customP = dbCustomProduct.CustomProducts.Find(item.ProductId); allCalories += customP.Calories * (item.Gram / 100); fats += customP.Fats * (item.Gram / 100); protein += customP.Protein * (item.Gram / 100); carbs += customP.Carbs * (item.Gram / 100); } } int caloriesNeeded = (int)((user.Weight * 10 + (user.Height * 6.25) - ((DateTime.UtcNow.Month < user.BirthDate.Month || (DateTime.UtcNow.Month == user.BirthDate.Month && DateTime.UtcNow.Day < user.BirthDate.Day)) ? (DateTime.UtcNow.Year - user.BirthDate.Year) : (DateTime.UtcNow.Year - user.BirthDate.Year) - 1) + (user.Sex == true ? 5 : -161)) * 1.2) - allCalories; return(Json(new { addId = id, addName = defaultProduct.Name, addCalories = defaultProduct.Calories * gram / 100, addFats = defaultProduct.Fats * gram / 100, addProtein = defaultProduct.Protein * gram / 100, addCarbs = defaultProduct.Carbs * gram / 100, caloriesNeeded, allCalories, fats, protein, carbs }, JsonRequestBehavior.AllowGet)); } }
protected ProductDto ConvertDefaultProductDBToDto(Product entity, DefaultProduct defaultProduct, ShoppingListEntry entry, TranslationOfProduct translation, LinkDefaultProductToCategory category) { return(StaticDBToDto(entity, defaultProduct, entry, translation, category)); }
protected DefaultProductDto ConvertDBToDto(DefaultProduct entity, TranslationOfProduct translation, LinkDefaultProductToCategory productToCategory) { return(StaticDBToDto(entity, translation, productToCategory)); }
protected DefaultProductDto ConvertDBToDto(DefaultProduct entity, TranslationOfProduct translation) { return(StaticDBToDto(entity, translation)); }