//***********************************************************************************************************************************************************
//***********************************************************************************************************************************************************
public void AdicionarItemAoCarrinho(Produto produto, int quantidade)
{
var carrinhoCompraItem = _aplicacaoDbContext.ItensCarrinhoCompras.SingleOrDefault(icc => icc.Produto.ProdutoId == produto.ProdutoId && icc.CarrinhoCompraId == CarrinhoCompraId);
if (carrinhoCompraItem == null)
{
carrinhoCompraItem = new ItensCarrinhoCompra
{
CarrinhoCompraId = CarrinhoCompraId,
Produto = produto,
Quantidade = 1
};
_aplicacaoDbContext.ItensCarrinhoCompras.Add(carrinhoCompraItem);
}
else
{
carrinhoCompraItem.Quantidade++;
}
_aplicacaoDbContext.SaveChanges();
}
//**********************************************************************************
//**********************************************************************************
public void RegistrarUsuario(Usuario usuario)
{
try
{
usuario.Status = "Ativo";
usuario.Role = "Pessoal";
_aplicacaoDbContext.Usuarios.Add(usuario);
_aplicacaoDbContext.SaveChanges();
}
catch (Exception e)
{
}
}
public IActionResult ColetaAPIFood(IFormFile arquivo)
{
using (var context = new AplicacaoDbContext())
{
using (StreamReader a = new StreamReader(arquivo.OpenReadStream()))
{
var json = a.ReadToEnd();
dynamic foods = JsonConvert.DeserializeObject(json);
Comida c;
c = new Comida();
c.Descricao = foods[0].description.Value;
int idCategoria = Convert.ToInt32(foods[0].category_id.Value);
c.Categoria = context.Categorias.FirstOrDefault(i => i.CategoriaId == idCategoria);
c.QuantidadeBase = Convert.ToInt32(foods[0].base_qty.Value);
c.Unidade = foods[0].base_unit.Value;
c.QuantidadeCalorias = foods[0].attributes.energy.kcal.Value is string || foods[0].attributes.energy.kcal.Value == null ? null : Convert.ToDouble(foods[0].attributes.energy.kcal.Value);
c.QuantidadeCarboidrato = foods[0].attributes.carbohydrate.qty.Value is string || foods[0].attributes.carbohydrate.qty.Value == null ? null : Convert.ToDouble(foods[0].attributes.carbohydrate.qty.Value);
c.QuantidadeFerro = foods[0].attributes.iron.qty.Value is string || foods[0].attributes.iron.qty.Value == null ? null : Convert.ToDouble(foods[0].attributes.iron.qty.Value);
c.QuantidadeFibra = foods[0].attributes.fiber.qty.Value is string || foods[0].attributes.fiber.qty.Value == null ? null : Convert.ToDouble(foods[0].attributes.fiber.qty.Value);
c.QuantidadeFosforo = foods[0].attributes.phosphorus.qty.Value is string || foods[0].attributes.phosphorus.qty.Value == null ? null : Convert.ToDouble(foods[0].attributes.phosphorus.qty.Value);
c.QuantidadeLipidio = foods[0].attributes.lipid.qty.Value is string || foods[0].attributes.lipid.qty.Value == null ? null : Convert.ToDouble(foods[0].attributes.lipid.qty.Value);
c.QuantidadePotassio = foods[0].attributes.potassium.qty.Value is string || foods[0].attributes.potassium.qty.Value == null ? null : Convert.ToDouble(foods[0].attributes.potassium.qty.Value);
c.QuantidadeProteina = foods[0].attributes.protein.qty.Value is string || foods[0].attributes.protein.qty.Value == null ? null : Convert.ToDouble(foods[0].attributes.protein.qty.Value);
c.QuantidadeSodio = foods[0].attributes.sodium.qty.Value is string || foods[0].attributes.sodium.qty.Value == null ? null : Convert.ToDouble(foods[0].attributes.sodium.qty.Value);
c.QuantidadeZinco = foods[0].attributes.zinc.qty.Value is string || foods[0].attributes.zinc.qty.Value == null ? null : Convert.ToDouble(foods[0].attributes.zinc.qty.Value);
c.UnidadeCarboidrato = foods[0].attributes.carbohydrate.unit.Value;
c.UnidadeFerro = foods[0].attributes.iron.unit.Value;
c.UnidadeFibra = foods[0].attributes.fiber.unit.Value;
c.UnidadeFosforo = foods[0].attributes.phosphorus.unit.Value;
c.UnidadeLipidio = foods[0].attributes.lipid.unit.Value;
c.UnidadePotassio = foods[0].attributes.potassium.unit.Value;
c.UnidadeProteina = foods[0].attributes.protein.unit.Value;
c.UnidadeSodio = foods[0].attributes.sodium.Value;
c.UnidadeZinco = foods[0].attributes.zinc.unit.Value;
context.Comidas.Add(c);
context.SaveChanges();
}
}
return(View("index"));
}
public IActionResult SignUp(string username, string email, string pass, string passConfirm)
{
using (var context = new AplicacaoDbContext())
{
HttpContext.Session.Remove("signUpWarning");
var users = context.Usuarios.ToList();
var exist = users.Exists(u => u.Email == email);
if (exist)
{
HttpContext.Session.SetString("signUpWarning", "Usuário já existente");
return(RedirectToAction("Cadastro"));
}
else
{
if (pass != passConfirm)
{
HttpContext.Session.SetString("signUpWarning", "A confirmação da senha deve ser a mesma que a senha normal");
return(RedirectToAction("Cadastro"));
}
else
{
string senhaHash = Criptografia.RetornarMD5(pass);
Usuario user = new Usuario
{
Nome = username,
Email = email,
Perfil = "Usuario",
Provedor = "",
Senha = senhaHash
};
context.Usuarios.Add(user);
context.SaveChanges();
HttpContext.Session.SetString("userName", user.Nome);
HttpContext.Session.SetString("userPerfil", user.Perfil);
HttpContext.Session.SetString("userEmail", user.Email);
return(RedirectToAction("Index", "Dashboard"));
}
}
}
}
public void CreateUser()
{
using (var context = new AplicacaoDbContext())
{
var users = context.Usuarios.ToList();
string userEmail = User.FindFirst(c => c.Type.Contains("email")).Value;
var exist = users.Exists(u => u.Email == userEmail);
if (exist)
{
var user = users.Find(u => u.Email == userEmail);
HttpContext.Session.SetString("userName", user.Nome);
HttpContext.Session.SetString("userPerfil", user.Perfil);
HttpContext.Session.SetString("userEmail", user.Email);
}
else
{
Usuario usuario = new Usuario()
{
Nome = User.Identity.Name,
Perfil = "Usuário",
Email = userEmail,
Senha = "",
Provedor = "Google"
};
HttpContext.Session.SetString("userName", usuario.Nome);
HttpContext.Session.SetString("userPerfil", usuario.Perfil);
HttpContext.Session.SetString("userEmail", usuario.Email);
context.Usuarios.Add(usuario);
context.SaveChanges();
}
}
}