public ActionResult CreateRestoran(RESTORAN restoran)
{
var restarauntWithSameID = db.RESTORANs.Where(m => m.NAZIV_RESTORANA == restoran.NAZIV_RESTORANA).SingleOrDefault();
if (ModelState.IsValid)
{
if (restarauntWithSameID == null)
{
restoran.BROJ_KOLONA = 1;
db.RESTORANs.Add(restoran);
for (int i = 1; i <= restoran.BROJ_STOLOVA; i++)
{
STO sto = new STO();
sto.ID_STOLA = i.ToString();
sto.BR_STOLICA = 4;
sto.ID_RESTORANA = restoran.ID_RESTORANA;
db.STOes.Add(sto);
db.SaveChanges();
}
db.SaveChanges();
return(RedirectToAction("ProfilAdmina"));
}
else
{
ViewBag.Message = "Postoji restoran sa ovim nazivom!";
return(View(restoran));
}
}
return(View());
}
public ActionResult UbaciStolove(string idRest)
{
TempData["idRest"] = idRest;
RESTORAN rest = db.RESTORANs.Find(idRest);
return(View(rest));
}
public ActionResult InformacijeORestoranu(string id)
{
RESTORAN rest = db.RESTORANs.Find(id);
var jel = from x in db.JELOVNIKs
where (x.ID_RESTORANA == id)
select x.ID_JELA;
List <JELOVNIK> jelLista = new List <JELOVNIK>();
foreach (var item in jel)
{
jelLista.Add(db.JELOVNIKs.Where(x => x.ID_JELA == item).Single());
}
ViewBag.jel = jelLista;
if (rest.LATITUDA == null || rest.LONGITUDA == null)
{
ViewBag.MapUrl = MapAddress(rest.ADRESA_RESTORANA, 10000, "ROAD", 240, 320);
}
else
{
ViewBag.MapUrl = MapCoordinates((double)rest.LATITUDA, (double)rest.LONGITUDA, 10000, "ROAD", 240, 320);
}
return(View(rest));
}
public ActionResult DeleteConfirmed(string id)
{
RESTORAN restoran = db.RESTORANs.Find(id);
db.RESTORANs.Remove(restoran);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Delete(string id = null)
{
RESTORAN restoran = db.RESTORANs.Find(id);
if (restoran == null)
{
return(HttpNotFound());
}
return(View(restoran));
}
public ActionResult EditRestoran(RESTORAN jel)
{
if (ModelState.IsValid)
{
db.Entry(jel).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("ProfilMenadzera"));
}
return(View(jel));
}
public ActionResult EditRestoran(string id)
{
RESTORAN rest = db.RESTORANs.Find(id);
if (rest == null)
{
return(HttpNotFound());
}
return(View(rest));
}
public ActionResult Edit(RESTORAN restoran)
{
if (ModelState.IsValid)
{
db.Entry(restoran).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(restoran));
}
public ActionResult Create(RESTORAN restoran)
{
if (ModelState.IsValid)
{
db.RESTORANs.Add(restoran);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(restoran));
}
public ActionResult PromeniKoordinate(RESTORAN rest)
{
if (ModelState.IsValid)
{
db.Entry(rest).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("ProfilMenadzera"));
}
return(View(rest));
}
public ActionResult DeleteRestoran(string id)
{
//GOST gost = db.GOSTs.Find(id);
RESTORAN rest = db.RESTORANs.Find(id);
if (rest == null)
{
return(HttpNotFound());
}
return(View(rest));
}
public ActionResult PromeniKonfiguraciju(string id)
{
RESTORAN rest = db.RESTORANs.Find(id);
if (rest == null)
{
return(HttpNotFound());
}
return(View(rest));
}
public ActionResult PromeniKonfiguraciju(RESTORAN rest)
{
string sesija = (string)Session["IDMenadzera"];
String idrest = db.MENADZERs.Where(z => z.IDMENADZERA == sesija).Select(z => z.ID_RESTORANA).Single().ToString();
if (ModelState.IsValid)
{
db.Entry(rest).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("ProfilMenadzera"));
}
return(View(rest));
}
public ActionResult RezervisiRestoran2(string id)
{
RESTORAN r = db.RESTORANs.Find(id);
ViewBag.BrojRedova = r.BROJ_KOLONA; //prekoprofilamenadzera
int stolova = (from x in db.STOes where x.ID_RESTORANA == id select x).Count();
ViewBag.BrojStolova = stolova;
//var cb = TempData["ckeckboxovi"];
TempData["r"] = r.ID_RESTORANA;
List <string> lista = TempData["checkboxovi"] as List <string>;
ViewBag.listaDostupnih = lista;
return(View());
}
public ActionResult PromeniKoordinate(string id)
{
var idd = (string)Session["IDMenadzera"];
var g = db.MENADZERs.Where(x => x.IDMENADZERA == idd).SingleOrDefault();
String idrest = db.MENADZERs.Where(z => z.IDMENADZERA == idd).Select(z => z.ID_RESTORANA).SingleOrDefault().ToString();
RESTORAN jel = db.RESTORANs.Find(idrest);
if (jel == null)
{
return(HttpNotFound());
}
return(View(jel));
}
public ActionResult EditRestoran(RESTORAN rest)
{
var restarauntWithSameID = db.RESTORANs.Where(m => m.NAZIV_RESTORANA == rest.NAZIV_RESTORANA).SingleOrDefault();
if (ModelState.IsValid)
{
if (restarauntWithSameID == null)
{
db.Entry(rest).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("ProfilAdmina"));
}
else
{
ViewBag.Message = "Postoji restoran sa ovim nazivom!";
}
return(View(rest));
}
return(View(rest));
}
public ActionResult RezervisiRestoran(string id)
{
string email = Session["idGosta"].ToString();
var genID = db.REZERVACIJAs.Count() + 1;
RESTORAN rest = db.RESTORANs.Find(id);
REZERVACIJA rez = new REZERVACIJA();
rez.EMAIL_GOSTA = email;
rez.ID = genID;
rez.ID_RESTORANA = rest.ID_RESTORANA;
if (rest.BROJ_STOLOVA > 0)
{
return(View(rez));
}
else
{
ViewBag.Message = "Nema dostupnih stolova u ovom restoranu";
}
return(View(rez));
}
public ActionResult DeleteRestoranConfirmed(string id)
{
RESTORAN rest = db.RESTORANs.Find(id);
var brisanjeRez = db.REZERVACIJAs.Where(x => x.ID_RESTORANA == id);
foreach (var item in brisanjeRez)
{
var brisanjePrijRez = db.PRIJATELJI_REZERVACIJA.Where(x => x.ID == item.ID);
db.PRIJATELJI_REZERVACIJA.RemoveRange(brisanjePrijRez);
}
var brisanjeStolova = db.STOes.Where(x => x.ID_RESTORANA == id);
var brisanjeMen = db.MENADZERs.Where(x => x.ID_RESTORANA == id);
db.REZERVACIJAs.RemoveRange(brisanjeRez);
db.STOes.RemoveRange(brisanjeStolova);
db.MENADZERs.RemoveRange(brisanjeMen);
db.RESTORANs.Remove(rest);
db.SaveChanges();
return(RedirectToAction("ProfilAdmina"));
}
public ActionResult UbaciStolove(RESTORAN rest)
{
db.unosStolova(rest.BROJ_STOLOVA, rest.ID_RESTORANA);
db.SaveChanges();
return(RedirectToAction("ProfilMenadzera"));
}
