public ActionResult DetalhesProduto(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
//LMPCEntities1 db = new LMPCEntities1();
//var prod = db.tbProdutoes.Find(id);
detalhesmodel model = new detalhesmodel();
Models.LMPCEntities1 db = new LMPCEntities1();
ViewBag.id = id;
//Produtos
model.detalheprod = db.tbProdutoes.Find(id);
//Comentarios
model.listacomentario = db.sp_exibircomentarioproduto(id);
//Media
model.Media = (from a in db.tbComentarios
where a.CodigoProduto == id
select a.Avaliacao).Average();
if (db == null)
{
return(HttpNotFound());
}
return(View(model));
}
public ActionResult MensagemCupom()
{
Models.LMPCEntities1 db = new LMPCEntities1();
var data = db.sp_cupomadquirido();
data.AsEnumerable();
return(View(data));
}
public ActionResult Cupons()
{
Models.LMPCEntities1 db = new LMPCEntities1();
int Codigo = Convert.ToInt32(Session["CodigoCliente"]);
var data = db.pesq_cupom(Codigo);
data.AsEnumerable();
return(View(data));
}
// GET: Home
public ActionResult Index()
{
Models.LMPCEntities1 db = new LMPCEntities1();
var data = db.produtosrecentes();
data.AsEnumerable();
return(View(data));
}
public ActionResult CadastrarCliente(Models.tbCliente cli)
{
if (ModelState.IsValid)
{
using (LMPCEntities1 db = new LMPCEntities1())
{
db.tbClientes.Add(cli);
db.SaveChanges();
ModelState.Clear();
cli = null;
ViewBag.Mensagem = "Cliente registrado com sucesso";
return(RedirectToAction("MensagemCupom", "Home"));
}
}
else
{
return(View());
}
}
public ActionResult CadastrarMensagem(Models.tbContato cont)
{
if (ModelState.IsValid)
{
using (LMPCEntities1 db = new LMPCEntities1())
{
cont.DataContato = DateTime.Today;
cont.StatusContato = 0;
db.tbContatoes.Add(cont);
db.SaveChanges();
ModelState.Clear();
cont = null;
ViewBag.Mensagem = "Mensagem registrada com sucesso";
return(RedirectToAction("MensagemFaleConosco", "Home"));
}
}
else
{
return(View());
}
}
public ActionResult VerificarLogin(tbCliente log)
{
if (ModelState.IsValid)
{
using (Models.LMPCEntities1 db = new LMPCEntities1())
{
var v = db.tbClientes.Where(a => a.Cpf.Equals(log.Cpf) && log.Senha.Equals(log.Senha)).FirstOrDefault();
if (v != null)
{
Session["CodigoCliente"] = Convert.ToInt32(v.CodigoCliente);
Session["NomeCliente"] = Convert.ToString(v.Nome);
return(RedirectToAction("ClienteLogado", "Login"));
}
else
{
ViewData["LoginApresenta"] = "Login e/ou senha invalido";
return(RedirectToAction("Loginn", "Login"));
}
}
}
return(View(log));
}
