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