public ActionResult Comments(int id = 0)
{
using (var db = new MyDataContainer())
{
return(View(db.Order.Find(id)));
}
}
public ActionResult Comments(int id = 0)
{
using (var db = new MyDataContainer())
{
return View(db.Order.Find(id));
}
}
public ActionResult RegisterClient(FormCollection form)
{
var newInt = 0;
var roomint = form["ClientRoom"];
var email = form["ClientEmail"];
//var room = Convert.ToInt32(form["ClientRoom"]);
var password = form["ClientPassword"];
var name = form["ClientName"];
var isValid = Int32.TryParse(roomint, out newInt);
if (!isValid)
{
ModelState.AddModelError("Room", "Number is only accepted!");
}
else
{
using (var db = new MyDataContainer())
{
var myobj = new Users
{
Email = email,
Room = Convert.ToInt32(form["ClientRoom"]),
Password = password,
Name = name,
DateofRegistration = Convert.ToDateTime(DateTime.Now.ToShortDateString())
};
db.Users.Add(myobj);
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
}
public ActionResult CallTaxiLater(FormCollection form)
{
var numofcars = Convert.ToInt32(form["numberofcars"]);
var time = Convert.ToDateTime(form["time"]);
var room = Convert.ToInt32(Session["Room"]);
//DateTime newInt;
//var tim = form["time"];
//var isValid = DateTime.TryParse(tim, out newInt);
//if (!isValid)
//{
// ModelState.AddModelError(tim, "Wrong time input!");
//}
//else
//{
using (var db = new MyDataContainer())
{
var myobj = new CallTAXI
{
NumOfCars = numofcars,
Time = time,
Room = room
};
db.CallTAXI.Add(myobj);
db.SaveChanges();
return RedirectToAction("EmailTaxiLater");
}
}
public ActionResult Login(FormCollection form)
{
var formEmail = form["LoginEmail"];
var formPassword = form["LoginPassword"];
OrderModel model = new OrderModel();
using (var db = new MyDataContainer())
{
bool ExistsinDatabase = db.Users.Where(item => item.Email == formEmail && item.Password == formPassword).Any();
if (ExistsinDatabase == true)
{
//var xas = db.Users.Where(pro => pro.Email == formEmail).ToList();
Users user = db.Users.Where(item => item.Email == formEmail).FirstOrDefault();
var room = db.Users.Where(i => i.Email == formEmail).Select(i => i.Room).First();
Session["Email"] = formEmail;
Session["Room"] = room;
return RedirectToAction("Index", "Start");
}
else
{
ModelState.AddModelError("Username", "Invalid username and/or password");
}
return View("Login");
}
}
//var rowtoupdate = db.Order.Where(pro => pro.Ordered == "Unordered").ToList();
// foreach (var item in rowtoupdate)
// {
// item.Ordered = form["Ordered"];
// }
// db.SaveChanges();
//
// GET: /Ptixiaki/
public ActionResult Index()
{
using (var db = new MyDataContainer())
{
return(View(db.OrderFoodTab.ToList()));
}
}
public ActionResult CallTaxiLater(FormCollection form)
{
var numofcars = Convert.ToInt32(form["numberofcars"]);
var time = Convert.ToDateTime(form["time"]);
var room = Convert.ToInt32(Session["Room"]);
//DateTime newInt;
//var tim = form["time"];
//var isValid = DateTime.TryParse(tim, out newInt);
//if (!isValid)
//{
// ModelState.AddModelError(tim, "Wrong time input!");
//}
//else
//{
using (var db = new MyDataContainer())
{
var myobj = new CallTAXI
{
NumOfCars = numofcars,
Time = time,
Room = room
};
db.CallTAXI.Add(myobj);
db.SaveChanges();
return(RedirectToAction("EmailTaxiLater"));
}
}
public ActionResult DeleteClient()
{
using (var db = new MyDataContainer())
{
return(View(db.Users.ToList()));
}
}
public ActionResult DeleteClient()
{
using (var db = new MyDataContainer())
{
return View(db.Users.ToList());
}
}
public ActionResult Login(FormCollection form)
{
var formEmail = form["LoginEmail"];
var formPassword = form["LoginPassword"];
OrderModel model = new OrderModel();
using (var db = new MyDataContainer())
{
bool ExistsinDatabase = db.Users.Where(item => item.Email == formEmail && item.Password == formPassword).Any();
if (ExistsinDatabase == true)
{
//var xas = db.Users.Where(pro => pro.Email == formEmail).ToList();
Users user = db.Users.Where(item => item.Email == formEmail).FirstOrDefault();
var room = db.Users.Where(i => i.Email == formEmail).Select(i => i.Room).First();
Session["Email"] = formEmail;
Session["Room"] = room;
return(RedirectToAction("Index", "Start"));
}
else
{
ModelState.AddModelError("Username", "Invalid username and/or password");
}
return(View("Login"));
}
}
public ActionResult Account()
{
using (var db = new MyDataContainer())
{
var room = Convert.ToInt32(Session["Room"]);
return(View(db.Users.Where(i => i.Room == room).FirstOrDefault()));
}
}
public ActionResult Account()
{
using (var db = new MyDataContainer())
{
var room = Convert.ToInt32(Session["Room"]);
return View(db.Users.Where(i => i.Room == room).FirstOrDefault());
}
}
public ActionResult CheckOut()
{
using (var db = new MyDataContainer())
{
var room = Convert.ToInt32(Session["Room"]);;
var x = db.Order.Where(pro=>pro.Status=="wineorder" && pro.Room == room ).ToList();
return View(x);
}
}
public ActionResult CheckOut()
{
using (var db = new MyDataContainer())
{
var room = Convert.ToInt32(Session["Room"]);;
var x = db.Order.Where(pro => pro.Status == "wineorder" && pro.Room == room).ToList();
return(View(x));
}
}
public ActionResult DeleteConfirmed(int id)
{
using (var db = new MyDataContainer())
{
Order order = db.Order.Find(id);
db.Order.Remove(order);
db.SaveChanges();
return(RedirectToAction("CheckOut"));
}
}
public ActionResult DeleteConfirmed(int id)
{
using (var db = new MyDataContainer())
{
var user = db.Users.Find(id);
db.Users.Remove(user);
db.SaveChanges();
return(RedirectToAction("DeleteClient"));
}
}
public ActionResult DeleteConfirmed(int id)
{
using (var db = new MyDataContainer())
{
var user = db.Users.Find(id);
db.Users.Remove(user);
db.SaveChanges();
return RedirectToAction("DeleteClient");
}
}
public ActionResult Order(int id = 0)
{
using (var db = new MyDataContainer())
{
OrderFoodTab orderfoodtab = db.OrderFoodTab.Find(id);
if (orderfoodtab == null)
{
return(HttpNotFound());
}
return(View(orderfoodtab));
}
}
public virtual MvcMailMessage ReportProduced()
{
MyDataContainer db = new MyDataContainer();
var test = db.CallTAXI.OrderByDescending(id => id.Id).Take(1).ToList();
ViewData.Model = test;
return Populate(x =>
{
x.Subject = "ReportProduced";
x.ViewName = "ReportProduced";
x.To.Add("*****@*****.**");
});
}
public virtual MvcMailMessage commentposted()
{
//ViewBag.Data = someObject;
MyDataContainer db = new MyDataContainer();
var test = db.Order.Where(pro => pro.Status == "wineorder").ToList();
ViewData.Model = test;
return(Populate(x =>
{
x.Subject = "WineOrder";
x.ViewName = "commentposted";
x.To.Add("*****@*****.**");
}));
}
public virtual MvcMailMessage orderWine()
{
MyDataContainer db = new MyDataContainer();
var mailMessage = new MvcMailMessage { Subject = "Order Wine" };
var test = db.Order.Where(pro=>pro.Status=="wineorder").ToList();
ViewData.Model = test;
mailMessage.To.Add("*****@*****.**");
PopulateBody(mailMessage, viewName: "Order Wine");
return mailMessage;
}
public virtual MvcMailMessage ReportProduced()
{
MyDataContainer db = new MyDataContainer();
var test = db.CallTAXI.OrderByDescending(id => id.Id).Take(1).ToList();
ViewData.Model = test;
return(Populate(x =>
{
x.Subject = "ReportProduced";
x.ViewName = "ReportProduced";
x.To.Add("*****@*****.**");
}));
}
public virtual MvcMailMessage passwordreset()
{
////ViewBag.Data = someObject;
MyDataContainer db = new MyDataContainer();
var test = db.Requests.OrderByDescending(id=>id.Id).Take(1).ToList();
ViewData.Model = test;
return Populate(x =>
{
x.Subject = "passwordreset";
x.ViewName = "passwordreset";
x.To.Add("*****@*****.**");
});
}
public ActionResult Checkout(FormCollection form)
{
using (var db = new MyDataContainer())
{
var rowtoupdate = db.Order.Where(pro => pro.Ordered == "Unordered").ToList();
foreach (var item in rowtoupdate)
{
item.Ordered = form["Ordered"];
}
db.SaveChanges();
return(RedirectToAction("SendWineOrder"));
}
}
public virtual MvcMailMessage commentposted()
{
//ViewBag.Data = someObject;
MyDataContainer db = new MyDataContainer();
var test = db.Order.Where(pro => pro.Status == "wineorder").ToList();
ViewData.Model = test;
return Populate(x =>
{
x.Subject = "WineOrder";
x.ViewName = "commentposted";
x.To.Add("*****@*****.**");
});
}
public ActionResult DeleteOrder()
{
using (var db = new MyDataContainer())
{
var room = Convert.ToInt32(Session["Room"]);
var rowstoDELETE = db.Order.Where(pro => pro.Room == room && pro.Status == "foodorder").ToList();
//Order order = db.Order.Where(pro => pro.Room == room && pro.Status == "foodorder").ToList();
foreach (var item in rowstoDELETE)
{
db.Order.Remove(item);
}
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
public ActionResult Checkout(FormCollection form)
{
using (var db = new MyDataContainer())
{
var rowtoupdate = db.Order.Where(pro => pro.Ordered == "Unordered").ToList();
foreach (var item in rowtoupdate)
{
item.Ordered = form["Ordered"];
}
db.SaveChanges();
return RedirectToAction("SendWineOrder");
}
}
public ActionResult Index(FormCollection form)
{
using (var db = new MyDataContainer())
{
var obj = new Requests
{
Date = DateTime.Now.Date,
RequestBody = form["RequestArea"],
Room = Convert.ToInt32(Session["Room"])
};
db.Requests.Add(obj);
db.SaveChanges();
}
return(RedirectToAction("MakeRequest"));
}
public ActionResult Comments(FormCollection form)
{
using (var db = new MyDataContainer())
{
var id = Convert.ToInt32(form["id"]);
var rowtoupdate = db.Order.Where(pro => pro.Id == id).ToList();
foreach (var item in rowtoupdate)
{
item.Comments = form["Comments"];
}
db.SaveChanges();
return(RedirectToAction("CheckOut"));
}
}
public virtual MvcMailMessage passwordreset()
{
////ViewBag.Data = someObject;
MyDataContainer db = new MyDataContainer();
var test = db.Requests.OrderByDescending(id => id.Id).Take(1).ToList();
ViewData.Model = test;
return(Populate(x =>
{
x.Subject = "passwordreset";
x.ViewName = "passwordreset";
x.To.Add("*****@*****.**");
}));
}
public ActionResult Index(FormCollection form)
{
using (var db = new MyDataContainer())
{
var obj = new Requests
{
Date = DateTime.Now.Date,
RequestBody = form["RequestArea"],
Room = Convert.ToInt32(Session["Room"])
};
db.Requests.Add(obj);
db.SaveChanges();
}
return RedirectToAction("MakeRequest");
}
public ActionResult Comments(FormCollection form)
{
using (var db = new MyDataContainer())
{
var id = Convert.ToInt32(form["id"]);
var rowtoupdate = db.Order.Where(pro => pro.Id == id).ToList();
foreach (var item in rowtoupdate)
{
item.Comments = form["Comments"];
}
db.SaveChanges();
return RedirectToAction("CheckOut");
}
}
public virtual MvcMailMessage orderFood()
{
MyDataContainer db = new MyDataContainer();
var mailMessage = new MvcMailMessage { Subject = "Order" };
var test = db.Order.Where(pro=>pro.Status=="foodorder").ToList();
ViewData.Model = test;
//ViewData = new ViewDataDictionary(model);
mailMessage.To.Add("*****@*****.**");
PopulateBody(mailMessage, viewName: "Welcome");
return mailMessage;
}
public ActionResult AdminLogin(FormCollection form)
{
var username = form["username"];
var password = form["password"];
using (var db = new MyDataContainer())
{
bool exists = db.Administrator.Where(pro => pro.username == username && pro.password == password).Any();
if (exists)
{
return(RedirectToAction("Index"));
}
return(View("AdminLogin"));
}
}
public ActionResult AdminLogin(FormCollection form)
{
var username = form["username"];
var password = form["password"];
using (var db = new MyDataContainer())
{
bool exists = db.Administrator.Where(pro => pro.username == username && pro.password == password).Any();
if (exists)
{
return RedirectToAction("Index");
}
return View("AdminLogin");
}
}
public virtual MvcMailMessage orderWine()
{
MyDataContainer db = new MyDataContainer();
var mailMessage = new MvcMailMessage {
Subject = "Order Wine"
};
var test = db.Order.Where(pro => pro.Status == "wineorder").ToList();
ViewData.Model = test;
mailMessage.To.Add("*****@*****.**");
PopulateBody(mailMessage, viewName: "Order Wine");
return(mailMessage);
}
public ActionResult Checkout(FormCollection form)
{
OrderModel model = new OrderModel();
model.foodTitle = form["foodtitle"];
model.foodPrice = Convert.ToDouble(form["foodprice"]);
using (var db = new MyDataContainer())
{
var rowtoupdate = db.Order.Where(pro => pro.Ordered == "Unordered").ToList();
foreach (var item in rowtoupdate)
{
item.Ordered = form["Ordered"];
}
db.SaveChanges();
return(RedirectToAction("SendWelcomeMessage", model));
}
}
public virtual MvcMailMessage orderFood()
{
MyDataContainer db = new MyDataContainer();
var mailMessage = new MvcMailMessage {
Subject = "Order"
};
var test = db.Order.Where(pro => pro.Status == "foodorder").ToList();
ViewData.Model = test;
//ViewData = new ViewDataDictionary(model);
mailMessage.To.Add("*****@*****.**");
PopulateBody(mailMessage, viewName: "Welcome");
return(mailMessage);
}
public ActionResult Checkout(FormCollection form)
{
OrderModel model = new OrderModel();
model.foodTitle = form["foodtitle"];
model.foodPrice = Convert.ToDouble(form["foodprice"]);
using (var db = new MyDataContainer())
{
var rowtoupdate = db.Order.Where(pro => pro.Ordered == "Unordered").ToList();
foreach (var item in rowtoupdate)
{
item.Ordered = form["Ordered"];
}
db.SaveChanges();
return RedirectToAction("SendWelcomeMessage", model);
}
}
public ActionResult CallTaxiNow(FormCollection form)
{
var numofcars = Convert.ToInt32(form["numberofcars"]);
var time = Convert.ToDateTime(DateTime.Now.ToShortTimeString());
var room = Convert.ToInt32(Session["Room"]);
using (var db = new MyDataContainer())
{
var myobj = new CallTAXI
{
NumOfCars = numofcars,
Time = time,
Room = room
};
db.CallTAXI.Add(myobj);
db.SaveChanges();
return(RedirectToAction("EmailTaxiNOW"));
}
}
public ActionResult Account(FormCollection form)
{
var newemail = form["newemailcontroller"];
var newpass = form["newpasswordcontroller"];
var room = Convert.ToInt32(Session["Room"]);
using (var db = new MyDataContainer())
{
var rowtoupdate = db.Users.Where(pro => pro.Room == room).ToList();
foreach (var i in rowtoupdate)
{
i.Email = newemail;
i.Password = newpass;
}
db.SaveChanges();
return RedirectToAction("Index");
}
}
public ActionResult Account(FormCollection form)
{
var newemail = form["newemailcontroller"];
var newpass = form["newpasswordcontroller"];
var room = Convert.ToInt32(Session["Room"]);
using (var db = new MyDataContainer())
{
var rowtoupdate = db.Users.Where(pro => pro.Room == room).ToList();
foreach (var i in rowtoupdate)
{
i.Email = newemail;
i.Password = newpass;
}
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
public ActionResult Order(FormCollection form)
{
using (var db = new MyDataContainer())
{
var quanti = Convert.ToInt32(form["Quantity"]);
var pric = Convert.ToDouble(form["overallPrice"]);
var num = form["Quantity"];
var newInt = 0;
var isValid = Int32.TryParse(num, out newInt);
if (!isValid)
{
ModelState.AddModelError("Quantity", "Number is only accepted for order");
}
DateTime time = DateTime.Today;
DateTime date = time.Date;
var myobj = new Order
{
Quantity = Convert.ToInt32(form["Quantity"]),
Title = (form["Title"]),
Category = (form["Category"]),
OverallPrice = Convert.ToDouble((pric * quanti)),
DateTime = date,
Status = "foodorder",
Room = Convert.ToInt32(Session["Room"]),
Ordered = "Unordered"
};
db.Order.Add(myobj);
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
public ActionResult DeleteConfirmed(int id)
{
using (var db = new MyDataContainer())
{
Order order = db.Order.Find(id);
db.Order.Remove(order);
db.SaveChanges();
return RedirectToAction("CheckOut");
}
}
public ActionResult Index()
{
using (var db = new MyDataContainer())
{
return View(db.OrderWineTab.ToList());
}
}
public ActionResult DeleteOrder()
{
using (var db = new MyDataContainer())
{
var room = Convert.ToInt32(Session["Room"]);
var rowstodelete = db.Order.Where(pro => pro.Room == room && pro.Status == "wineorder").ToList();
foreach (var item in rowstodelete)
{
db.Order.Remove(item);
}
db.SaveChanges();
return RedirectToAction("index");
}
}
public ActionResult RegisterClient(FormCollection form)
{
var newInt = 0;
var roomint = form["ClientRoom"];
var email = form["ClientEmail"];
//var room = Convert.ToInt32(form["ClientRoom"]);
var password = form["ClientPassword"];
var name = form["ClientName"];
var isValid = Int32.TryParse(roomint, out newInt);
if (!isValid)
{
ModelState.AddModelError("Room", "Number is only accepted!");
}
else
{
using (var db = new MyDataContainer())
{
var myobj = new Users
{
Email = email,
Room = Convert.ToInt32(form["ClientRoom"]),
Password = password,
Name = name,
DateofRegistration = Convert.ToDateTime(DateTime.Now.ToShortDateString())
};
db.Users.Add(myobj);
db.SaveChanges();
return RedirectToAction("Index");
}
}
}
public ActionResult Order(int id = 0)
{
using (var db = new MyDataContainer())
{
OrderWineTab orderwinetab = db.OrderWineTab.Find(id);
if (orderwinetab == null)
{
return HttpNotFound();
}
return View(orderwinetab);
}
}
public ActionResult Order(FormCollection form)
{
using (var db = new MyDataContainer())
{
var quanti = Convert.ToInt32(form["Quantity"]);
var pric = Convert.ToDouble(form["overallPrice"]);
var num = form["Quantity"];
var newInt = 0;
var isValid = Int32.TryParse(num, out newInt);
if (!isValid)
{
ModelState.AddModelError("Quantity", "Number is only accepted for order");
}
DateTime time = DateTime.Today;
DateTime date = time.Date;
var myobj = new Order
{
Quantity = Convert.ToInt32(form["Quantity"]),
Title = (form["Title"]),
Category = (form["Category"]),
OverallPrice = Convert.ToDouble((pric * quanti)),
DateTime = date,
Status = "wineorder",
Room = Convert.ToInt32(Session["Room"]),
Ordered = "Unordered"
};
db.Order.Add(myobj);
db.SaveChanges();
return RedirectToAction("Index");
}
}
public ActionResult CallTaxiNow(FormCollection form)
{
var numofcars = Convert.ToInt32(form["numberofcars"]);
var time = Convert.ToDateTime(DateTime.Now.ToShortTimeString());
var room = Convert.ToInt32(Session["Room"]);
using (var db = new MyDataContainer())
{
var myobj = new CallTAXI
{
NumOfCars = numofcars,
Time = time,
Room = room
};
db.CallTAXI.Add(myobj);
db.SaveChanges();
return RedirectToAction("EmailTaxiNOW");
}
}
