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