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