// // GET: /Zgloszenia/ public ActionResult Index() { using (var db = new ZgloszeniaEntities()) //return View(db.Zgloszenies.SqlQuery("SELECT * FROM Zgloszenie WHERE status = 'zgłoszona'").ToList()); return(View(db.Zgloszenies.ToList())); }
// // GET: /Zgloszenia/Delete/5 public ActionResult Delete(int id) { using (var db = new ZgloszeniaEntities()) { return(View(db.Zgloszenies.Find(id))); } }
public ActionResult Status() { using (var db = new ZgloszeniaEntities()) if (User.Identity.Name == "admin") { return(View(db.Zgloszenies.SqlQuery("SELECT * FROM Zgloszenie WHERE status = 'zgloszona'").ToList())); } else { return(RedirectToAction("Index")); } }
public ActionResult Delete(int id, Zgloszenie zgloszenie) { try { // TODO: Add delete logic here using (var db = new ZgloszeniaEntities()) { db.Entry(zgloszenie).State = System.Data.EntityState.Deleted; db.SaveChanges(); } return(RedirectToAction("Index")); } catch { return(View()); } }
public ActionResult Create(Zgloszenie zgloszenie) { try { // TODO: Add insert logic here using (var db = new ZgloszeniaEntities()) { db.Zgloszenies.Add(zgloszenie); zgloszenie.Data = DateTime.Now; zgloszenie.status = "zgloszona"; zgloszenie.tresc_zgloszenia = User.Identity.Name; zgloszenie.zdjecie = "pierwsze pole do googlemapsa"; zgloszenie.komentarz_admina = "drugie ppole do googlemapsa"; //zgloszenie.zdjecie = GetPhoto("c:/a.jpg"); db.SaveChanges(); } return(RedirectToAction("Index")); } catch { return(View()); } }