protected void ReservationSubmit_Click(object s, EventArgs e) { NbpDataContext db = new NbpDataContext(); if (ReservationIsValid()) { reservation r = new reservation(); r.reservationEmail = reservationEmail.Text.ToString(); r.reservationId = Guid.NewGuid(); r.reservationName = reservationName.Text.ToString(); r.reservationPartySize = Convert.ToInt32(reservationPartySize.SelectedItem.Value); r.reservationRelationship = reservationRelationship.Text.ToString(); r.reservationRemoteAddr = Request.ServerVariables["REMOTE_ADDR"].ToString(); r.reservationTimestamp = DateTime.Now; r.reservationPhoneNumber = reservationPhoneNumber.Text.ToString(); db.reservations.InsertOnSubmit(r); db.SubmitChanges(); Session["nbpEmail"] = reservationEmail.Text.ToString(); Session["nbpName"] = reservationName.Text.ToString(); // send cookie HttpCookie c = new HttpCookie("MemorialReservation"); c.Expires = DateTime.Now.AddMonths(1); c.Value = reservationName.Text.ToString(); Response.Cookies.Add(c); MultiView1.ActiveViewIndex = 1; } audit a = new audit(); a.auditId = Guid.NewGuid(); a.auditRemoteAddr = Request.ServerVariables["REMOTE_ADDR"].ToString(); a.auditRequestedUrl = "Memorial.aspx"; a.auditSessionEmail = Session["nbpEmail"]!=null ? Session["nbpEmail"].ToString() : ""; a.auditSessionId = Session.SessionID.ToString(); a.auditSessionName = Session["nbpName"]!=null ? Session["nbpName"].ToString() : ""; a.auditTimestamp = DateTime.Now; a.auditType = "Memorial signup"; a.auditDescription = "Email: " + reservationEmail.Text.ToString() + " Name: " + reservationName.Text.ToString() + " PartySize: " + reservationPartySize.SelectedItem.Value.ToString() + " Relationship: " + reservationRelationship.Text.ToString() + " Phone: " + reservationPhoneNumber.Text.ToString(); a.auditReferrer = Request.UrlReferrer.AbsolutePath.ToString(); a.auditLogonUser = Request.ServerVariables["LOGON_USER"]; db.audits.InsertOnSubmit(a); db.SubmitChanges(); }
public ActionResult DeleteConfirmed(int id) { reservation reservation = db.reservations.Find(id); string deleteCreditcardSql = "delete from creditinfo where bID =" + reservation.bId; db.Database.ExecuteSqlCommand(deleteCreditcardSql); string deleteContactSql = "delete from contact where bID =" + reservation.bId; db.Database.ExecuteSqlCommand(deleteContactSql); db.reservations.Remove(reservation); db.SaveChanges(); //clean all the session data. TempData.Clear(); return(RedirectToAction("Index")); }
// GET: Admin/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } reservation reservation = db.reservation.Find(id); if (reservation == null) { return(HttpNotFound()); } ViewBag.guest_id = new SelectList(db.guest, "id", "first_name", reservation.guest_id); return(View(reservation)); }
// GET: Tasks/Edit/5 public ActionResult Edit(int id) { reservation e = service.GetById(id); reservationModels em = new reservationModels { title = e.title, }; List <eventproject> events = service1.GetAllevent().ToList(); em.events = events.ToSelectListItem(); List <user> users = service2.GetAlluser().ToList(); em.users = users.ToSelectListItems(); return(View(em)); }
// GET: reservations/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } reservation reservation = db.reservations.Find(id); if (reservation == null) { return(HttpNotFound()); } ViewBag.user_id = new SelectList(db.AspNetUsers, "Id", "Email", reservation.user_id); ViewBag.location_id = new SelectList(db.locations, "id", "name", reservation.location_id); return(View(reservation)); }
// GET: reservations/Create public ActionResult Create() { if (TempData.ContainsKey("bId")) { return(RedirectToAction("Edit", new { id = int.Parse(TempData["bId"].ToString()) })); } reservation resv = new reservation(); var counts = getAllGuestsAndRoomsCounts(); // Set these number counts in the model. We need to do this because // only the selected value from the DropDownList is posted back, not the whole // list of guests/rooms. resv.counts = getSelectListItems(counts); return(View(resv)); }
public ActionResult Create(CreateView reservation, int?id) { if (ModelState.IsValid) { var misafir = new guest(); Random rnd = new Random(); int num = rnd.Next(1, 10000); misafir.id = num; misafir.e_mail = reservation.e_mail; misafir.first_name = reservation.first_name; misafir.last_name = reservation.last_name; misafir.phone_number = reservation.phone_number; db.guest.Add(misafir); db.SaveChanges(); var rezervasyon = new reservation(); int generated = rezervasyon.GetHashCode(); rezervasyon.id = generated; rezervasyon.guest_id = num; rezervasyon.date_in = DateTime.Now; rezervasyon.date_out = DateTime.Now.AddDays(10); rezervasyon.status = "true"; rezervasyon.made_by = reservation.first_name + " " + reservation.last_name; db.reservation.Add(rezervasyon); db.SaveChanges(); //Database kayıt işlemi //db.Entry(reservation).State = EntityState.Modified; //oda durumunun değiştiği yer var room = db.room.Find(id); room.status = "false"; db.SaveChanges(); return(RedirectToAction("Create", "CreditCards", new { id = id })); } return(View()); }
public ActionResult MakeReservation(int scheduleID, double totalPrice, int numberOfTicket, string seats) { int?[] seatsArray = JsonConvert.DeserializeObject <int?[]>(seats); reservation r = new reservation(); r.scheduleID = scheduleID; r.totalPrice = totalPrice; r.numberOfTicket = numberOfTicket; r.seats = seatsArray; CinemaWebServiceClient c = new CinemaWebServiceClient(); c.makeReservation(r, Session["email"].ToString()); return(RedirectToAction("MyReservation")); }
public CreateReservation() { InitializeComponent(); DataContext = new reservation(); client.SelectAll().ForEach(c => clients.Add(c.id, c.first_name + " " + c.last_name)); atbClientSearch.AutoCompleteSource = clients.Values; _event.SelectAll().ForEach(e => events.Add(e.id, e.name)); atbEventSearch.AutoCompleteSource = events.Values; hall.SelectAll().ForEach(h => halls.Add(h.id, h.name)); atbHallSearch.AutoCompleteSource = halls.Values; item.SelectAll().ForEach(i => items.Add(i.id, i.name)); atbItemSearch.AutoCompleteSource = items.Values; }
// GET: Reservation/Edit/5 public ActionResult Edit(int id) { //debut code khawla IUserService service = new UserService(); user u = service.GetById(User.Identity.GetUserId()); string firstName = u.firstName; string lastName = u.lastName; string email = u.Email; ViewBag.userFirstName = firstName; ViewBag.userLastName = lastName; ViewBag.userMail = email; ViewBag.sexe = u.sexe.ToLower(); //fin code khawla reservation res = ause.GetById(id); return(View(res)); }
// GET: reservations/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } reservation reservation = db.reservations.Find(id); if (reservation == null) { return(HttpNotFound()); } var counts = getAllGuestsAndRoomsCounts(); reservation.counts = getSelectListItems(counts); return(View(reservation)); }
public ActionResult Edit(reservation reservation) { if (ModelState.IsValid) { //Database kayıt işlemi db.Entry(reservation).State = EntityState.Modified; //oda durumunun değiştiği yer db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.guest_id = new SelectList(db.guests, "id", "first_name", reservation.guest_id); return(View(reservation)); }
public ActionResult Edit(reservation res) { //debut code khawla IUserService service = new UserService(); user u = service.GetById(User.Identity.GetUserId()); string firstName = u.firstName; string lastName = u.lastName; string email = u.Email; ViewBag.userFirstName = firstName; ViewBag.userLastName = lastName; ViewBag.userMail = email; ViewBag.sexe = u.sexe.ToLower(); //fin code khawla ause.Update(res); return(RedirectToAction("Index")); }
// GET: Tasks/Delete/5 public ActionResult Delete(int id) { reservation e = service.GetById(id); if (e == null) { return(HttpNotFound()); } reservationModels em = new reservationModels { title = e.title, user_id = e.user_id, eventproject_id = e.eventproject_id }; return(View(em)); }
public ActionResult Edit(int id, FormCollection collection) { reservation e = service.GetById(id); try { service.Update(e); UpdateModel(e); service.Commit(); return(RedirectToAction("Index")); } catch { return(View(e)); } }
private void btnCheck_Click(object sender, EventArgs e) { reservation reserv = client.checkReservationByCode(txtCode.Text); if (reserv != null) { StringBuilder sb = new StringBuilder(); sb.Append("Рейс: ").Append(reserv.flight.code).Append("\n"); sb.Append("Самолет: ").Append(reserv.flight.aircraft.name).Append("\n"); sb.Append("Дата вылета: ").Append(reserv.flight.dateDepart).Append("\n"); sb.Append("Дата прилета: ").Append(reserv.flight.dateCome).Append("\n"); sb.Append("Место: ").Append(reserv.place.seatLetter).Append(reserv.place.seatNumber).Append("\n"); MessageBox.Show(sb.ToString()); } else { MessageBox.Show("Ничего не найдено!"); } }
public ViewReservationWindow(HotelServerClient server) { InitializeComponent(); this.server = server; foreach (Window w in Application.Current.Windows) { if (w is MainWindow) { mainWindow = (MainWindow)w; } } selectedReservation = (reservation)mainWindow.reservationsList.SelectedItem; roomNumber.Text = server.getRoom(selectedReservation.roomId).roomNumber.ToString(); dateFrom.Text = selectedReservation.dateFrom.ToString("dd-MM-yyyy"); dateTo.Text = selectedReservation.dateTo.ToString("dd-MM-yyyy"); duration.Text = selectedReservation.daysAmount.ToString(); price.Text = selectedReservation.price.ToString(); }
private void DeleteReservation_Click(object sender, RoutedEventArgs e) { try { reservation selectedReservation = (reservation)reservationsList.SelectedItem; bool result = server.deleteReservation(selectedReservation.reservationId); if (result) { MessageBox.Show("Reservation successfully removed!"); } else { MessageBox.Show("Oops! Something went wrong"); } reservationsList.ItemsSource = server.getReservations(); } catch (Exception exception) { //obsługa błędu przy próbie usunięcia gdy żadna rezerwacja nie została zaznaczona } }
public ActionResult Create(reservation r) {//debut code khawla IUserService service = new UserService(); user u = service.GetById(User.Identity.GetUserId()); string firstName = u.firstName; string lastName = u.lastName; string email = u.Email; ViewBag.userFirstName = firstName; ViewBag.userLastName = lastName; ViewBag.userMail = email; ViewBag.sexe = u.sexe.ToLower(); //fin code khawla int id = int.Parse(this.RouteData.Values["id"].ToString()); r.reservationState = 1; r.flight_idFlight = 1; ause.Add(r); return(RedirectToAction("Index")); }
public ActionResult Annuler(int id) { if (Session["Client"] != null) { client cc = (client)Session["Client"]; reservation res = db.reservations.Find(cc.reservations.Where(r => r.idTrajet == id).FirstOrDefault().id); db.reservations.Remove(res); cc.reservations.Remove(res); db.SaveChanges(); ViewBag.Reservation = cc.reservations; } if (ViewBag.Rechercher != null) { ViewBag.listeOffres = ViewBag.Rechercher; } else { ViewBag.listeOffres = db.trajets; } return(View("index")); }
public ActionResult Book(reservation res) { if (ModelState.IsValid) { if (res.reservationID == 0) { res.code = AlphaNumbericGenerator.getRandom(8); res.employeeID = 1; DataHandler.newReservation(res); Session["code"] = res.code; Session["title"] = "Booking complete!"; Session["text"] = "You have succesfully booked a reservation at our hotel."; return(RedirectToAction("Complete")); } else { reservation r = (reservation)Session["reservationDraft"]; res.code = r.code; res.employeeID = r.employeeID; DataHandler.editReservation(res); Session["reservationDraft"] = null; Session["isEdited"] = null; Session["code"] = null; Session["title"] = "Booking edited!"; Session["text"] = "You have succesfully edited your reservation at our hotel."; return(RedirectToAction("Complete")); } } ViewBag.speciesList = DDContentGenerator.convertSpecies(DataHandler.getSpeciesList()); return(View(res)); }
public ActionResult Create(ReservationViewModel Reservation) { try { // TODO: Add insert logic here reservation r = new reservation(); r.reservationDate = Reservation.ReservationDate; if (rs.GetPlaces(r.reservationDate) > 0) { rs.Add(r); rs.Commit(); return(RedirectToAction("Index")); } return(View()); } catch { return(View()); } }
public ActionResult Create(CreateView reservation, int?id) { if (ModelState.IsValid) { var misafir = new guest(); misafir.id = 45; misafir.e_mail = reservation.e_mail; misafir.first_name = reservation.first_name; misafir.last_name = reservation.last_name; misafir.phone_number = reservation.phone_number; db.guests.Add(misafir); db.SaveChanges(); var rezervasyon = new reservation(); rezervasyon.date_in = DateTime.Now; rezervasyon.date_out = DateTime.Now.AddDays(10); rezervasyon.guest_id = misafir.id; rezervasyon.status = "true"; rezervasyon.made_by = reservation.first_name + " " + reservation.last_name; db.reservations.Add(rezervasyon); db.SaveChanges(); //Database kayıt işlemi //db.Entry(reservation).State = EntityState.Modified; //oda durumunun değiştiği yer var room = db.rooms.Find(id); room.status = "false"; db.SaveChanges(); return(RedirectToAction("Index", "Home")); } return(View()); }
public ActionResult Create([Bind(Include = "Start,End,Email,Beds,Quality")] ReservationModel res) { if (ModelState.IsValid) { var availableRooms = roomService.FindAvailable(res.Start, res.End); var vacant = availableRooms.Find(room => room.beds == res.Beds && room.quality.ToLower() == res.Quality.ToLower()); var user = userService.CreateIfAbsent(res.Email); if (vacant != null) { reservation reservation = reservationService.CreateReservation(res.Start, res.End, user.id, vacant.id); reservationService.Add(reservation); return(RedirectToAction("Index")); } else { ViewBag.NotVacant = "No rooms that satisfy your needs are available at this moment."; } } return(View(res)); }
public void addreserve(reservation p) { ut.ReservationRepository.Add(p); ut.commit(); }
public void deletereserve(reservation p) { ut.ReservationRepository.Delete(p); ut.commit(); }
public void update(reservation p) { ut.ReservationRepository.Update(p); ut.commit(); }
static void changeReservation(int userId) { Console.WriteLine("Enter your reservation id"); //Convert de string gelijk naar een int int searchId = Convert.ToInt32(Console.ReadLine()); // Gevonden reservatie als een reservatie class initializeren met fake data reservation foundReservation = new reservation(0, 0, 0, new DateTime(), 0); // SQL Request maken om de gegeven reservering ID in database te vinden SqlConnection connection = new SqlConnection("Data Source=luxefood.database.windows.net;Initial Catalog=LuxeFoods;User ID=Klees;Password=Johnny69;Connect Timeout=60;Encrypt=True;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False"); SqlCommand readCommand = new SqlCommand("select * from reservering where Id='" + searchId + "'", connection); connection.Open(); using (SqlDataReader reader = readCommand.ExecuteReader()) { while (reader.Read()) { // Als gevonden dan wordt de data in de eerder gemaakte class opgeslagen foundReservation = new reservation(reader.GetInt32(0), reader.GetInt32(1), reader.GetInt32(2), reader.GetDateTime(3), reader.GetInt32(4)); } // Connectie met database beindigen connection.Close(); } // List met alle restauranten te maken die alleen onze eigen classen (restaurants) zijn List <restaurants> allRestaurants = new List <restaurants>(); // SQL Request maken om alle data van alle restauranten te krijgen SqlCommand restReadCommand = new SqlCommand("select * from restaurant", connection); connection.Open(); using (SqlDataReader reader = restReadCommand.ExecuteReader()) { while (reader.Read()) { // De ontvangen data in een restaurants object zetten en dan in de List restaurants _ = new restaurants(reader.GetInt32(0), reader.GetString(1), reader.GetInt32(3)); allRestaurants.Add(_); } // Connectie met database beindigen connection.Close(); } bool check = false; while (!check) { // Checken of de reservatie klopt als niet dan opnieuw kijken Console.WriteLine("Is this your reservation? (y/n) " + foundReservation.Id + " " + allRestaurants[foundReservation.restaurantId - 1].Naam + " " + foundReservation.Date + " tafel nr. " + foundReservation.tableNr); string answer = Console.ReadLine(); if (answer == "y") { check = !check; } else if (answer == "n") { Console.WriteLine("Leaving..."); check = !check; } else { Console.WriteLine("Please Enter y or n"); } } check = false; while (!check) { Console.WriteLine("What do you want to change?"); Console.WriteLine("1-Datum"); Console.WriteLine("2-Tijd"); Console.WriteLine("3-Tafel Nummer"); Console.WriteLine("4-Restaurant Id"); int changeOption = Convert.ToInt32(Console.ReadLine()); // Als 1 dan datum veranderen if (changeOption == 1) { bool correctData = true; check = !check; string newDate = ""; Console.WriteLine("Changing Datum"); Console.WriteLine("Your Current Date is: " + foundReservation.Date); check = false; while (!check) { Console.WriteLine("Which date do you want it to switch to?"); // nieuwe datum als string houden newDate = Console.ReadLine(); // nieuwe datum in een DateTime variabele opslaan om makkelijker de object te kunnen deconstructen DateTime newDateTime = DateTime.Parse(newDate); //Checken of de nieuwe datum niet zelfde is als de bestaande datum if (newDateTime != foundReservation.Date.Date) { // de zelfe tijd van de oude reservatie op de nieuwe datum string toevoegen newDate += " " + foundReservation.Date.TimeOfDay; //SQL request maken voor alle reserveringen met de gegeven datum te krijgen string q = $"SELECT * FROM [reservering] WHERE datum='{newDate}'"; List <int> restaurantIds = new List <int>(); List <int> tafelNummers = new List <int>(); List <DateTime> datums = new List <DateTime>(); try { // SQL Connection string SqlConnection con = new SqlConnection("Data Source=luxefood.database.windows.net;Initial Catalog=LuxeFoods;User ID=Klees;Password=Johnny69;Connect Timeout=60;Encrypt=True;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False"); con.Open(); if (con.State == System.Data.ConnectionState.Open) { // SQL Request in een SqlCommand class zetten met de SQL connection string erbij SqlCommand cmd = new SqlCommand(q, con); // SQL Request uitvoeren cmd.ExecuteNonQuery(); //De ontvangen data in een dataset zetten SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); //Loopen door de dataset en alle ontvangen string naar de nodige type veranderen in de passende List zetten foreach (DataRow dr in dt.Rows) { datums.Add(Convert.ToDateTime(dr["datum"].ToString())); restaurantIds.Add(Convert.ToInt32(dr["restaurantId"].ToString())); tafelNummers.Add(Convert.ToInt32(dr["tafelNummer"].ToString())); } } // Connectie met database beindigen con.Close(); } // Error handler die de message gelijk print catch (Exception ex) { Console.WriteLine(ex.Message); } int count = 0; // Kijken voor elke ontvangen reservering met zelfde datum of die ook op zelfde restaurant, tafel nummer en tijd gereserveerd zijn, als wel dan niks doen foreach (int x in restaurantIds) { if (x == foundReservation.restaurantId && tafelNummers[count] == foundReservation.tableNr && foundReservation.Date.TimeOfDay == datums[count].TimeOfDay) { Console.WriteLine("This place has already been taken"); correctData = false; } count++; } check = !check; } else { Console.WriteLine("You entered the same date!"); } } // Als correctData door vorige check niet false is dan wordt de data gestuurd if (correctData) { try { // SQL UPDATE Request om de nieuwe datum voor de gegeven reservering id te veranderen SqlCommand Command = new SqlCommand("UPDATE reservering SET datum='" + newDate + "' WHERE Id='" + foundReservation.Id + "'", connection); connection.Open(); // Execute de SQL UPDATE Request Command.ExecuteNonQuery(); // Connectie met database beindigen connection.Close(); Console.WriteLine("Succesfully Changed the date to " + newDate); } // Error handler die de message gelijk print catch (Exception error) { Console.WriteLine(error); } } } // Als 2 dan tijd veranderen else if (changeOption == 2) { bool correctData = true; check = !check; string newTime = ""; string dateString = ""; Console.WriteLine("Changing Tijd"); Console.WriteLine("Your Current DateTime is: " + foundReservation.Date); check = false; while (!check) { Console.WriteLine("Which time do you want it to switch to? just put in the Hour"); // Check of de gegeven uur tussen de opening tijden van het restaurant past int hour = 0; while (hour < 16 || hour > 23) { newTime = Console.ReadLine(); hour = Convert.ToInt32(newTime); } // de nieuwe tijd in een TimeSpan variabele zetten TimeSpan newTimeSpan = new TimeSpan(hour, 0, 0); // Checken of de nieuwe tijd niet zelfde is als de oude tijd if (newTimeSpan != foundReservation.Date.TimeOfDay) { // De nieuwe tijd aan de datum string toevoegen dateString = foundReservation.Date.Year + "-" + foundReservation.Date.Month + "-" + foundReservation.Date.Day; dateString += " " + newTimeSpan; // Datum opnieuw converten naar een DateTime variabele om de object makkelijker te deconstructen DateTime dateDateTime = DateTime.Parse(dateString); // SQL Request om alle data van reserveringen met de gegeven datum te naar ons te sturen string q = $"SELECT * FROM [reservering] WHERE datum='{dateString}'"; List <int> restaurantIds = new List <int>(); List <int> tafelNummers = new List <int>(); List <DateTime> datums = new List <DateTime>(); try { // SQL Connection string SqlConnection con = new SqlConnection("Data Source=luxefood.database.windows.net;Initial Catalog=LuxeFoods;User ID=Klees;Password=Johnny69;Connect Timeout=60;Encrypt=True;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False"); con.Open(); if (con.State == System.Data.ConnectionState.Open) { // SQL Request + Connection String samen SqlCommand cmd = new SqlCommand(q, con); // SQL Command uitvoeren cmd.ExecuteNonQuery(); // SQL Command ontvangen data in een DataTable zetten SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); //Loopen door de dataset en alle ontvangen string naar de nodige type veranderen in de passende List zetten foreach (DataRow dr in dt.Rows) { datums.Add(Convert.ToDateTime(dr["datum"].ToString())); restaurantIds.Add(Convert.ToInt32(dr["restaurantId"].ToString())); tafelNummers.Add(Convert.ToInt32(dr["tafelNummer"].ToString())); } } // Connectie met database beindigen con.Close(); } // Error handler die de message gelijk print catch (Exception ex) { Console.WriteLine(ex.Message); } int count = 0; // Kijken voor elke ontvangen reservering met zelfde datum of die ook op zelfde restaurant, tafel nummer en tijd gereserveerd zijn, als wel dan niks doen foreach (int x in restaurantIds) { if (x == foundReservation.restaurantId && tafelNummers[count] == foundReservation.tableNr && dateDateTime.Date.TimeOfDay == datums[count].TimeOfDay) { Console.WriteLine("This place has already been taken"); correctData = false; } count++; } check = !check; } else { Console.WriteLine("You entered the same date!"); } } // Als correctData door vorige check niet false is dan wordt de data gestuurd if (correctData) { try { // SQL UPDATE Request om de nieuwe datum met tijd voor de gegeven reservering id te veranderen SqlCommand Command = new SqlCommand("UPDATE reservering SET datum='" + dateString + "' WHERE Id='" + foundReservation.Id + "'", connection); connection.Open(); // SQL Command uitvoeren Command.ExecuteNonQuery(); // Connectie met database beindigen connection.Close(); Console.WriteLine("Succesfully Changed the date to " + dateString); } // Error handler die de message gelijk print catch (Exception error) { Console.WriteLine(error); } } } // Als 3 dan Tafel nummer veranderen else if (changeOption == 3) { bool correctData = true; check = !check; int newTableNr = 0; string dateString = ""; Console.WriteLine("Changing Tafel Nummer"); Console.WriteLine("Your Current TableNumber is: " + foundReservation.tableNr); check = false; while (!check) { Console.WriteLine("Which table Number do you want to switch to? Enter a valid number between 1-" + allRestaurants[foundReservation.restaurantId - 1].amountTables); // Check of de gegeven tafel nummer in de gegeven restaurant bestaat while (newTableNr < 1 || newTableNr > allRestaurants[foundReservation.restaurantId - 1].amountTables) { newTableNr = Convert.ToInt32(Console.ReadLine()); } // Checken of de nieuwe tafel nummer niet zelfde is als de oude if (newTableNr != foundReservation.tableNr) { // De foundReservation.Date deconstructen om een valid sql string ervan te maken dateString = foundReservation.Date.Year + "-" + foundReservation.Date.Month + "-" + foundReservation.Date.Day + " " + foundReservation.Date.TimeOfDay; // SQL Request om alle data van reserveringen met de gegeven datum te naar ons te sturen string q = $"SELECT * FROM [reservering] WHERE datum='{dateString}'"; List <int> restaurantIds = new List <int>(); List <int> tafelNummers = new List <int>(); List <DateTime> datums = new List <DateTime>(); try { // SQL Connection String SqlConnection con = new SqlConnection("Data Source=luxefood.database.windows.net;Initial Catalog=LuxeFoods;User ID=Klees;Password=Johnny69;Connect Timeout=60;Encrypt=True;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False"); con.Open(); if (con.State == System.Data.ConnectionState.Open) { // SQL Request + Connection string in een SqlCommand variabele SqlCommand cmd = new SqlCommand(q, con); // SQL Command uitvoeren cmd.ExecuteNonQuery(); // SQL Command ontvangen data in een DataTable zetten SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); //Loopen door de dataset en alle ontvangen string naar de nodige type veranderen in de passende List zetten foreach (DataRow dr in dt.Rows) { datums.Add(Convert.ToDateTime(dr["datum"].ToString())); restaurantIds.Add(Convert.ToInt32(dr["restaurantId"].ToString())); tafelNummers.Add(Convert.ToInt32(dr["tafelNummer"].ToString())); } } // Connectie met database beindigen con.Close(); } // Error handler die de message gelijk print catch (Exception ex) { Console.WriteLine(ex.Message); } int count = 0; // Kijken voor elke ontvangen reservering met zelfde datum of die ook op zelfde restaurant, tafel nummer en tijd gereserveerd zijn, als wel dan niks doen foreach (int x in restaurantIds) { if (x == foundReservation.restaurantId && tafelNummers[count] == newTableNr && foundReservation.Date == datums[count]) { Console.WriteLine("This place has already been taken"); correctData = false; } count++; } check = !check; } else { Console.WriteLine("You entered the same date!"); } } // Als correctData door vorige check niet false is dan wordt de data gestuurd if (correctData) { try { // SQL UPDATE Request om de nieuwe tafel nummer voor de gegeven reservering id te veranderen SqlCommand Command = new SqlCommand("UPDATE reservering SET tafelNummer='" + newTableNr + "' WHERE Id='" + foundReservation.Id + "'", connection); connection.Open(); // SQL Command uitvoeren Command.ExecuteNonQuery(); // Connectie met database beindigen connection.Close(); Console.WriteLine("Succesfully Changed the table Number to " + newTableNr); } // Error handler die de message gelijk print catch (Exception error) { Console.WriteLine(error); } } } // Als 4 dan Restaurant veranderen else if (changeOption == 4) { bool correctData = true; check = !check; int newRestaurantId = 0; string dateString = ""; SqlCommand Cmd = new SqlCommand(); Console.WriteLine("Changing Restaurant"); Console.WriteLine("Your Current Restaurant ID is: " + foundReservation.restaurantId + " name: " + allRestaurants[foundReservation.restaurantId - 1].Naam); check = false; while (!check) { Console.WriteLine("Which restaurant ID do you want to switch to? Enter a valid number between 1-" + allRestaurants.Count); // Check of de gegeven restaurant id bestaat while (newRestaurantId < 1 || newRestaurantId > allRestaurants[foundReservation.restaurantId - 1].amountTables) { newRestaurantId = Convert.ToInt32(Console.ReadLine()); } // Check of de gegeven tafel nummer in de gegeven restaurant while (foundReservation.tableNr > allRestaurants[newRestaurantId - 1].amountTables) { Console.WriteLine("The table number doesnt exist in this restaurant, please choose a different table number between 1-" + allRestaurants[newRestaurantId - 1].amountTables); foundReservation.tableNr = Convert.ToInt32(Console.ReadLine()); } // SQL UPDATE Request om de nieuwe tafel nummer voor de gegeven reservering id te veranderen Cmd = new SqlCommand("UPDATE reservering SET tafelNummer='" + foundReservation.tableNr + "' WHERE Id='" + foundReservation.Id + "'", connection); // Checken of de nieuwe restaurant id niet zelfde is als de oude if (newRestaurantId != foundReservation.restaurantId) { // De foundReservation.Date deconstructen om een valid sql string ervan te maken dateString = foundReservation.Date.Year + "-" + foundReservation.Date.Month + "-" + foundReservation.Date.Day + " " + foundReservation.Date.TimeOfDay; // SQL Request om alle data van reserveringen met de gegeven datum te naar ons te sturen string q = $"SELECT * FROM [reservering] WHERE datum='{dateString}'"; List <int> restaurantIds = new List <int>(); List <int> tafelNummers = new List <int>(); List <DateTime> datums = new List <DateTime>(); try { // SQL Connection String SqlConnection con = new SqlConnection("Data Source=luxefood.database.windows.net;Initial Catalog=LuxeFoods;User ID=Klees;Password=Johnny69;Connect Timeout=60;Encrypt=True;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False"); con.Open(); if (con.State == System.Data.ConnectionState.Open) { // SQL Request + SQL Connection String SqlCommand cmd = new SqlCommand(q, con); // SQL Command uitvoeren cmd.ExecuteNonQuery(); // SQL Command ontvangen data in een DataTable zetten SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); //Loopen door de dataset en alle ontvangen string naar de nodige type veranderen in de passende List zetten foreach (DataRow dr in dt.Rows) { datums.Add(Convert.ToDateTime(dr["datum"].ToString())); restaurantIds.Add(Convert.ToInt32(dr["restaurantId"].ToString())); tafelNummers.Add(Convert.ToInt32(dr["tafelNummer"].ToString())); } } // Connectie met database beindigen con.Close(); } // Error handler die de message gelijk print catch (Exception ex) { Console.WriteLine(ex.Message); } int count = 0; // Kijken voor elke ontvangen reservering met zelfde datum of die ook op zelfde restaurant, tafel nummer en tijd gereserveerd zijn, als wel dan niks doen foreach (int x in restaurantIds) { if (x == newRestaurantId && tafelNummers[count] == foundReservation.tableNr && foundReservation.Date == datums[count]) { Console.WriteLine("This place has already been taken"); correctData = false; } count++; } check = !check; } else { Console.WriteLine("You entered the same date!"); } } // Als correctData door vorige check niet false is dan wordt de data gestuurd if (correctData) { try { // SQL UPDATE Request om de nieuwe restaurant id voor de gegeven reservering id te veranderen SqlCommand Command = new SqlCommand("UPDATE reservering SET restaurantId='" + newRestaurantId + "' WHERE Id='" + foundReservation.Id + "'", connection); connection.Open(); // SQL Command restaurantID Update uitvoeren Command.ExecuteNonQuery(); // SQL Command tafel nummer UPDATE uitvoeren Cmd.ExecuteNonQuery(); // Connectie met database beindigen connection.Close(); Console.WriteLine("Succesfully Changed the restaurant id to " + newRestaurantId + " on the name of " + allRestaurants[newRestaurantId - 1].Naam + " with table number " + foundReservation.tableNr); } // Error handler die de message gelijk print catch (Exception error) { Console.WriteLine(error); } } } else { Console.WriteLine("Enter a valid option"); } } }
partial void Insertreservation(reservation instance);
partial void Updatereservation(reservation instance);
partial void Deletereservation(reservation instance);
/// <summary> /// Create a new reservation /// </summary> /// <param name="oItem"></param> /// <returns></returns> public async Task <ResultModel <reservation> > AddReservation(item oItem) { ResultModel <reservation> results = new ResultModel <reservation>(); //check if item available var resultItem = await GetItemByIdValueAndTypeAsync(oItem); if (resultItem != null) { ItemStatus outStatus = ItemStatus.available; Enum.TryParse(resultItem.resultContent.status, out outStatus); Stopwatch sw = Stopwatch.StartNew(); var invCount = await mapper .FirstOrDefaultAsync <int> ("select available_count from inventory_by_location_and_upc where business_unit=? and location=? and upc=?", "wireless", "ye30cy", "upc123"); sw.Stop(); File.AppendAllText(@"C:\Guids.txt", $"AddReservation:GetCount: Time taken: {sw.Elapsed.Milliseconds}ms\r\n"); if (outStatus == ItemStatus.available && invCount > 0) { //upate inventory status 2 tables item newItem = new item { businessUnit = oItem.businessUnit, location = oItem.location, upc = oItem.upc, identifierValue = oItem.identifierValue, identifierType = oItem.identifierType, serialNumber = oItem.serialNumber, receiptId = oItem.receiptId, status = ItemStatus.reserved.ToString(), dateCreated = TimeUuid.NewId(), dateUpdated = TimeUuid.NewId(), itemAttributes = null, availableCount = invCount - 1 }; //insert item history itemHistory itemHist = new itemHistory { businessUnit = oItem.businessUnit, location = oItem.location, upc = oItem.upc, histItemId = Guid.NewGuid(), identifierValue = oItem.identifierValue, identifierType = oItem.identifierType, serialNumber = oItem.serialNumber, receiptId = oItem.receiptId, status = ItemStatus.reserved.ToString(), dateCreated = TimeUuid.NewId(), dateUpdated = TimeUuid.NewId(), itemAttributes = null }; //insert itembyIdentifier itemByIdentifier itemById = new itemByIdentifier { businessUnit = oItem.businessUnit, location = oItem.location, upc = oItem.upc, identifierValue = oItem.identifierValue, identifierType = oItem.identifierType, serialNumber = oItem.serialNumber, receiptId = oItem.receiptId, status = ItemStatus.reserved.ToString(), dateCreated = TimeUuid.NewId(), dateUpdated = TimeUuid.NewId(), itemAttributes = null }; var reservationId = Guid.NewGuid(); //create a reservation record reservation newReservation = new reservation { businessUnit = oItem.businessUnit, reservationId = reservationId, reserverId = Guid.NewGuid().ToCqlString(), location = oItem.location, upc = oItem.upc, identifierValue = oItem.identifierValue, identifierType = oItem.identifierType, serialNumber = oItem.serialNumber, receiptId = oItem.receiptId, itemStatus = ItemStatus.reserved.ToString(), dateCreated = TimeUuid.NewId(), dateUpdated = TimeUuid.NewId(), itemAttributes = null, reservationStatus = ReservationStatus.created.ToString() }; //create a reservation history reservationHistory newReservationHist = new reservationHistory { businessUnit = oItem.businessUnit, reservationId = reservationId, histReservationId = Guid.NewGuid(), reserverId = Guid.NewGuid().ToCqlString(), location = oItem.location, upc = oItem.upc, identifierValue = oItem.identifierValue, identifierType = oItem.identifierType, serialNumber = oItem.serialNumber, receiptId = oItem.receiptId, itemStatus = ItemStatus.reserved.ToString(), dateCreated = TimeUuid.NewId(), dateUpdated = TimeUuid.NewId(), itemAttributes = null, reservationStatus = ReservationStatus.created.ToString() }; //create a logged batch ICqlBatch itembatch = mapper.CreateBatch(BatchType.Logged); itembatch.Update <item>("SET status =? , available_count=? , date_updated= ? WHERE business_unit =? and location=? and upc=? and identifier_value=? and identifier_type=? IF status=?" , ItemStatus.reserved.ToString(), invCount - 1, TimeUuid.NewId() , oItem.businessUnit, oItem.location, oItem.upc, oItem.identifierValue, oItem.identifierType, ItemStatus.available.ToString()); itembatch.Options.SetConsistencyLevel(ConsistencyLevel.Quorum); sw = Stopwatch.StartNew(); await mapper.ExecuteAsync(itembatch); sw.Stop(); File.AppendAllText(@"C:\Guids.txt", $"AddReservation:itemBatch:Time taken: {sw.Elapsed.Milliseconds}ms\r\n"); //ICqlBatch reservationbatch = mapper.CreateBatch(BatchType.Logged); //reservationbatch.InsertIfNotExists(newReservation); //sw = Stopwatch.StartNew(); //await mapper.ExecuteConditionalAsync<reservation>(reservationbatch); //sw.Stop(); //File.AppendAllText(@"C:\Guids.txt", $"AddReservation:reservationBatch: Time taken: {sw.Elapsed.Milliseconds}ms\r\n"); ICqlBatch allBatch = mapper.CreateBatch(BatchType.Logged); allBatch.Insert <reservation>(newReservation); allBatch.Insert <itemByIdentifier>(itemById); allBatch.Insert <itemHistory>(itemHist); allBatch.Insert <reservationHistory>(newReservationHist); allBatch.Options.SetConsistencyLevel(ConsistencyLevel.Quorum); sw = Stopwatch.StartNew(); await mapper.ExecuteAsync(allBatch); sw.Stop(); File.AppendAllText(@"C:\Guids.txt", $"AddReservation:restOfBatch: Time taken: {sw.Elapsed.Milliseconds}ms\r\n"); results.resultContent = newReservation; results.resultCode = ResultStatus.success; return(results); } } results.resultCode = ResultStatus.failure; return(results); }
public ActionResult Book(string bookStart, string bookEnd, int bookRoom = 0) { var user = (user)Session["user"]; Message info = new Message(); if (user == null) { return RedirectToAction("Index", "Reservation"); } if (String.IsNullOrEmpty(bookStart) || String.IsNullOrEmpty(bookEnd) || bookRoom == 0) { info.text = "You have to choose room number and both dates."; return RedirectToAction("Index", "Reservation", new { info.text }); } DateTime startDate = Convert.ToDateTime(bookStart); DateTime endDate = Convert.ToDateTime(bookEnd); if (startDate >= endDate) { info.text = "Start day must be earlier ther end day."; return RedirectToAction("Index", "Reservation", new { info.text }); } List<DateTime> busyDates = new List<DateTime>(); using (var db = new HotelDBEntities()) { var reservs = db.reservations.ToList(); if (reservs.Count() == 0) { reservation res = new reservation(); res.start_date = startDate; res.end_date = endDate; res.room_id = bookRoom; res.user_id = user.id; res.days = Convert.ToInt32((endDate - startDate).TotalDays); db.reservations.Add(res); db.SaveChanges(); //---------------------------------------------------------------------------- info.type = 1; info.text = "Reservations has been added."; return RedirectToAction("Index", "Reservation", new { info.type, info.text }); } else { foreach (reservation item in reservs) { busyDates.Add(item.start_date); DateTime a = item.start_date; DateTime b = item.end_date; while (a.AddDays(1) != b) { busyDates.Add(a.AddDays(1)); a = a.AddDays(1); } } if (busyDates.Contains(startDate) || busyDates.Contains(endDate.AddDays(-1))) { info.type = 0; info.text = "Room is reserved in those days."; return RedirectToAction("Index", "Reservation", new { info.type, info.text }); } else { reservation res = new reservation(); res.start_date = startDate; res.end_date = endDate; res.room_id = bookRoom; res.user_id = user.id; res.days = Convert.ToInt32((endDate - startDate).TotalDays); db.reservations.Add(res); db.SaveChanges(); //---------------------------------------------------------------------------- info.type = 1; info.text = "Reservations has been added."; return RedirectToAction("Index", "Reservation", new { info.type, info.text }); } } } }
private void reserve_Click(object sender, EventArgs e) { reservation r = new reservation(); r.Show(); }