public void AddMenu(DateTime date, int typeEatId, int prodId, int userId, int calorie, int weight) { using (CalorieCalculatorDBEntities1 db = new CalorieCalculatorDBEntities1()) { if (db.UserMenu.Any(x => x.ProductsId == prodId && x.TypeEatingId == typeEatId)) { UserMenu prodChange = db.UserMenu.Where(x => x.ProductsId == prodId && x.TypeEatingId == typeEatId).FirstOrDefault(); prodChange.WeightProduct += weight; prodChange.Calorie += calorie; db.SaveChanges(); } else { UserMenu menu = new UserMenu { Date = date, TypeEatingId = typeEatId, ProductsId = prodId, UserId = userId, Calorie = calorie, WeightProduct = weight }; db.UserMenu.Add(menu); db.SaveChanges(); } } }
public List <string> LoadNameProd() { using (CalorieCalculatorDBEntities1 db = new CalorieCalculatorDBEntities1()) { List <string> prod = db.Products.Select(x => x.NameProduct).ToList(); return(prod); } }
public int?GetSummBmr(int idUser, DateTime data) { using (CalorieCalculatorDBEntities1 db = new CalorieCalculatorDBEntities1()) { int?summ = db.UserMenu.Where(x => x.UserId == idUser).Where(x => x.Date == data).Sum(x => x.Calorie); return(summ); } }
public Products SearchCalorieandIdProd(string name) { using (CalorieCalculatorDBEntities1 db = new CalorieCalculatorDBEntities1()) { Products prod = db.Products.FirstOrDefault(x => x.NameProduct == name); return(prod); } }
public int SearchIdTypeProd(string prod) { using (CalorieCalculatorDBEntities1 db = new CalorieCalculatorDBEntities1()) { TypeProduct typeList = new TypeProduct(); typeList = db.TypeProduct.FirstOrDefault(x => x.TypeProd == prod); return(typeList.TypeProductId); } }
public int SearchPassId(string pass, string log) { using (CalorieCalculatorDBEntities1 db = new CalorieCalculatorDBEntities1()) { PassStore passList = new PassStore(); passList = db.PassStore.FirstOrDefault(x => x.Pass == pass && x.Login == log); return(passList.PassStoreId); } }
public int SearchGender(string gender) { using (CalorieCalculatorDBEntities1 db = new CalorieCalculatorDBEntities1()) { Gender user = new Gender(); user = db.Gender.FirstOrDefault(x => x.GenderType == gender); return(user.GenderId); } }
public void RemoveProduct(string nameProd) { using (CalorieCalculatorDBEntities1 db = new CalorieCalculatorDBEntities1()) { Products prod = db.Products.FirstOrDefault(x => x.NameProduct == nameProd); db.Products.Remove(prod); db.SaveChanges(); } }
public void ChangeNameUser(int iduser, string name) { using (CalorieCalculatorDBEntities1 db = new CalorieCalculatorDBEntities1()) { UserInfo userChange = db.UserInfo.Where(x => x.UserId == iduser).First(); userChange.NameUser = name; db.SaveChanges(); } }
public LifeStyle SearchStyle(string style) { using (CalorieCalculatorDBEntities1 db = new CalorieCalculatorDBEntities1()) { LifeStyle styleList = new LifeStyle(); styleList = db.LifeStyle.FirstOrDefault(x => x.Style == style); return(styleList); } }
public UserInfo GetUserProfile(int passId) { using (CalorieCalculatorDBEntities1 db = new CalorieCalculatorDBEntities1()) { UserInfo user = new UserInfo(); user = db.UserInfo.FirstOrDefault(x => x.PassStoreId == passId); return(user); } }
public void ChangeBMRUser(int iduser, int bmr) { using (CalorieCalculatorDBEntities1 db = new CalorieCalculatorDBEntities1()) { UserInfo userChange = db.UserInfo.Where(x => x.UserId == iduser).First(); userChange.BMR = bmr; db.SaveChanges(); } }
public void ChangeAgeUser(int iduser, int age) { using (CalorieCalculatorDBEntities1 db = new CalorieCalculatorDBEntities1()) { UserInfo userChange = db.UserInfo.Where(x => x.UserId == iduser).First(); userChange.Age = age; db.SaveChanges(); } }
public void ChangeHeightUser(int iduser, double height) { using (CalorieCalculatorDBEntities1 db = new CalorieCalculatorDBEntities1()) { UserInfo userChange = db.UserInfo.Where(x => x.UserId == iduser).First(); userChange.Height = height; db.SaveChanges(); } }
public LifeStyle GetUserLifeStyle(int?idStyle) { using (CalorieCalculatorDBEntities1 db = new CalorieCalculatorDBEntities1()) { LifeStyle userStyle = new LifeStyle(); userStyle = db.LifeStyle.FirstOrDefault(x => x.LifeStyleId == idStyle); return(userStyle); } }
public string GetUserGender(int?genderId) { using (CalorieCalculatorDBEntities1 db = new CalorieCalculatorDBEntities1()) { Gender user = new Gender(); user = db.Gender.FirstOrDefault(x => x.GenderId == genderId); return(user.GenderType); } }
public void RemoveUser(int id) { using (CalorieCalculatorDBEntities1 db = new CalorieCalculatorDBEntities1()) { UserInfo user = db.UserInfo.FirstOrDefault(x => x.UserId == id); PassStore pass = db.PassStore.FirstOrDefault(x => x.PassStoreId == user.PassStoreId); db.UserInfo.Remove(user); db.PassStore.Remove(pass); db.SaveChanges(); } }
public void NameUser(int passId) { //string name; using (CalorieCalculatorDBEntities1 db = new CalorieCalculatorDBEntities1()) { var names = db.UserInfo.Where(x => x.PassStoreId == passId).ToList(); foreach (var i in names) { label1.Text = i.NameUser; } } }
public List <UserModel> LoadUsers() { using (CalorieCalculatorDBEntities1 db = new CalorieCalculatorDBEntities1()) { var users = db.UserInfo.Select(x => new UserModel { Id = x.UserId, Name = x.NameUser }); return(users.ToList()); } }
public List <ProdModel> SearchProductsDrink() { using (CalorieCalculatorDBEntities1 db = new CalorieCalculatorDBEntities1()) { var drinkList = db.Products.Where(x => x.TypeProductId == 1).Select(x => new ProdModel { NameProd = x.NameProduct, Calorie = x.Calorie }); return(drinkList.ToList()); } }
public void ShowLog() { using (CalorieCalculatorDBEntities1 db = new CalorieCalculatorDBEntities1()) { listBox1.Items.Clear(); foreach (PassStore pas in db.PassStore) { listBox1.Items.Add(pas.Pass); listBox1.Items.Add(pas.Login); } } }
public List <ProdModel> LoadProd() { using (CalorieCalculatorDBEntities1 db = new CalorieCalculatorDBEntities1()) { //db.Products.Load(); //List<Products> prodList = db.Products.ToList<Products>(); var products = db.Products.Select(x => new ProdModel { NameProd = x.NameProduct, Calorie = x.Calorie }); return(products.ToList()); } }
public void AddPassLog(string pass, string log) { using (CalorieCalculatorDBEntities1 db = new CalorieCalculatorDBEntities1()) { if (db.PassStore.Any(x => x.Pass == pass && x.Login == log)) { throw (new Exception("Такие логин и пароль уже существуют!")); } PassStore passLog = new PassStore { Pass = pass, Login = log }; db.PassStore.Add(passLog); db.SaveChanges(); } }
public int IsLogin(string pass, string log) { using (CalorieCalculatorDBEntities1 db = new CalorieCalculatorDBEntities1()) { int idUser; try { idUser = db.PassStore.Where(x => x.Pass == pass && x.Login == log).Select(x => x.PassStoreId).First(); return(idUser); } catch { return(0); } } }
public void AddProduct(string name, int calorie, int type) { using (CalorieCalculatorDBEntities1 db = new CalorieCalculatorDBEntities1()) { if (db.Products.Any(x => x.NameProduct == name && x.Calorie == calorie)) { throw (new Exception("Такой продукт уже существует!")); } Products prod = new Products { Calorie = calorie, NameProduct = name, TypeProductId = type }; db.Products.Add(prod); db.SaveChanges(); } }
public void RemoveMenu(DateTime date, string nameProd, int calorie, int weight, int typeEat, int userid) { using (CalorieCalculatorDBEntities1 db = new CalorieCalculatorDBEntities1()) { Products prod = db.Products.FirstOrDefault(x => x.NameProduct == nameProd); int idProd = prod.ProductsId; UserMenu menu = db.UserMenu.Where(x => x.Date == date) .Where(x => x.ProductsId == idProd) .Where(x => x.UserId == IdUser.Id) .Where(x => x.WeightProduct == weight) .Where(x => x.Calorie == calorie) .Where(x => x.TypeEatingId == typeEat) .FirstOrDefault(); db.UserMenu.Remove(menu); db.SaveChanges(); } }
public List <ModelMenu> SearchShack(DateTime date, int userId) { using (CalorieCalculatorDBEntities1 db = new CalorieCalculatorDBEntities1()) { var snack = from UserMenu in db.UserMenu join Products in db.Products on UserMenu.ProductsId equals Products.ProductsId where UserMenu.UserId == userId where UserMenu.Date == date where UserMenu.TypeEatingId == 4 select new ModelMenu { NameProd = Products.NameProduct, Calorie = UserMenu.Calorie, Weight = UserMenu.WeightProduct }; return(snack.ToList()); } }
public void AddUser(string name, int age, double weight, double height, int genderId, int lifeStyleId, int bmr, int passStoreId) { using (CalorieCalculatorDBEntities1 db = new CalorieCalculatorDBEntities1()) { if (db.UserInfo.Any(x => x.NameUser == name && x.PassStoreId == passStoreId)) { throw (new Exception("Такой профиль уже существует!")); } UserInfo user = new UserInfo { NameUser = name, Age = age, Weight = weight, Height = height, GenderId = genderId, LifeStyleId = lifeStyleId, BMR = bmr, PassStoreId = passStoreId }; db.UserInfo.Add(user); db.SaveChanges(); } }