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