public IActionResult AddRoom([FromBody] RoomModel room) { try { if (room == null) { return(BadRequest("Empty body request")); } else { RoomDto room1 = new RoomDto { //Id = room.Id, Description = room.Description, ReservationPrize = room.ReservationPrize }; _db.Rooms.Add(room1); _db.SaveChanges(); return(Created("Room Added", room1)); } } catch (Exception ex) { return(BadRequest("Bład przy dodawaniu pokoju do bazy /n" + ex.Message)); } }
public IActionResult Delete(int id) { var del = _res.Reservations.Find(id); _res.Reservations.Remove(del); _res.SaveChanges(); _toastNotification.AddWarningToastMessage("You deleted your reservation"); return(RedirectToAction("Index")); }
public ActionResult Create([Bind(Include = "Id,TrainId,Stop,ArrivalTime")] TrainSchedule trainSchedule) { if (ModelState.IsValid) { db.TrainSchedules.Add(trainSchedule); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(trainSchedule)); }
public ActionResult Create([Bind(Include = "ID,LastName,FirstName,Phone,StrAdd,City,State")] Client client) { if (ModelState.IsValid) { db.Clients.Add(client); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(client)); }
public ActionResult Create([Bind(Include = "Id,BookISBN,StudentId,Doyoureserve,Date")] Reservation reservation) { if (ModelState.IsValid) { db.Reservation.Add(reservation); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(reservation)); }
public ActionResult Create([Bind(Include = "Id,Name,SName,Grade")] Student student) { if (ModelState.IsValid) { db.Student.Add(student); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(student)); }
public ActionResult Create([Bind(Include = "id,check_in_date,check_out_date,room_count,reserve_date,cancel_date,notes,user_id")] Reservation reservation) { if (ModelState.IsValid) { db.Reservations.Add(reservation); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(reservation)); }
public ActionResult Create([Bind(Include = "Id,TrainId,TrainName,Source,Destination,DateOfTravel,TimeOfArrival,TrainType,SeatAvailability,NoOfSeat")] Train train) { if (ModelState.IsValid) { db.Trains.Add(train); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(train)); }
public ActionResult Create([Bind(Include = "ID,UserName,Hair,Gender")] User user) { if (ModelState.IsValid) { db.Users.Add(user); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(user)); }
public ActionResult Create([Bind(Include = "ID,LastName,FirstName,Occupation")] Employee employee) { if (ModelState.IsValid) { db.Employees.Add(employee); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(employee)); }
public ActionResult Create([Bind(Include = "ISBN,Title,Detail")] Book book) { if (ModelState.IsValid) { db.Book.Add(book); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(book)); }
public ActionResult Create([Bind(Include = "ReservationID,UserID,Hair,ReservationDate")] Reservation reservation) { if (ModelState.IsValid) { db.Reservations.Add(reservation); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.UserID = new SelectList(db.Users, "ID", "UserName", reservation.UserID); return(View(reservation)); }
public ActionResult Create([Bind(Include = "ID,ReservationDate,CourseID,StudentID")] Reservation reservation) { if (ModelState.IsValid) { db.Reservations.Add(reservation); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.CourseID = new SelectList(db.Courses, "CourseID", "Name", reservation.CourseID); ViewBag.StudentID = new SelectList(db.Students, "StudentID", "FirstName", reservation.StudentID); return(View(reservation)); }
public ActionResult Create([Bind(Include = "ReservationID,ClientID,EmployeeID,Date,Time,ClientName,EmployeeName")] Reservation reservation) { if (ModelState.IsValid) { db.Reservations.Add(reservation); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.ClientID = new SelectList(db.Clients, "ID", "LastName", reservation.ClientID); ViewBag.EmployeeID = new SelectList(db.Employees, "ID", "LastName", reservation.EmployeeID); return(View(reservation)); }
public void Save(Contact contact) { try { _context.contacts.Update(contact); _context.SaveChanges(); } catch (Exception) { throw; } }
public ActionResult Register(User user) { if (ModelState.IsValid) { con.Users.Add(user); con.SaveChanges(); //return View(); //Response.Write("<script>alert('Registered successfully')</script>"); return(RedirectToAction("Login", "User", new { msg = "success" })); } return(View(user)); }
public ActionResult Newpassword(FormCollection form) { try { string newpass = form["Newpass"].ToString(); string conpass = form["Conpass"].ToString(); string adid = (string)Session["passrecovery"]; if (newpass == conpass) { var admin = con.Admins.Where(t => t.UserId == adid).FirstOrDefault(); admin.password = newpass; con.SaveChanges(); return(RedirectToAction("Passwordsuccess", "Admin")); } else { //ModelState.AddModelError("", "Newpassword and confirm password does not match"); Response.Write("<center><h2 style=" + "color:red" + ">Newpassword and confirm password does not match</h2></center>"); // return View(); } return(View()); } catch { Response.Write("<center><h2 style=" + "color:red" + ">Password cannot be empty</h2></center>"); return(View()); } }
public bool InsertIntoCoutries(string coutryName) { if (find.FindCountry(coutryName) == null) { context.Countries.Add( new Country() { Name = coutryName }); context.SaveChanges(); return(true); } else { return(false); } }
public virtual void Edit(T entity) { using (context = new ReservationContext()) { context.Entry(entity).State = EntityState.Modified; context.SaveChanges(); //context.Entry(entity).Reload(); } }
public ReservationController(ReservationContext context) { _context = context; if (_context.ReservationItems.Count() == 0) { _context.SaveChanges(); } }
public ActionResult <IEnumerable <string> > Get() { var room = new Room { Name = "room1" }; _db.Rooms.Add(room); _db.SaveChanges(); return(new string[] { "value1", "value2" }); }
public void TearDown() { using var context = new ReservationContext(); var dummyData = context.Reservations.Where(x => x.StartTime > new DateTime(2021, 12, 31)); foreach (var reservation in dummyData) { context.Reservations.Remove(reservation); } context.SaveChanges(); }
public int Add(T entity) { using (context = new ReservationContext()) { context.Set <T>().Add(entity); context.SaveChanges(); DbPropertyValues sa = context.Entry(entity).GetDatabaseValues(); string keyName = sa.PropertyNames.First(); int Id = sa.GetValue <int>(keyName); return(Id); } }
public void DeleteReservation(Guid reservationId) { ReservationContext context = new ReservationContext(); Reservation reservation = (from r in context.Reservations where r.Id == reservationId select r).FirstOrDefault(); if (reservation == null) { throw new ArgumentException(string.Format("There's no reservation by ID {0}", reservationId)); } context.Entry <Reservation>(reservation).State = System.Data.Entity.EntityState.Deleted; context.SaveChanges(); }
public void AddReservation(AddReservationValidationResult addReservationValidationResult) { ReservationContext context = new ReservationContext(); if (addReservationValidationResult.ValidationComplete) { context.Entry <Reservation>(addReservationValidationResult.ToBeInserted).State = System.Data.Entity.EntityState.Added; } else { throw new InvalidOperationException("Validation is not complete. You have to call the AddReservation method of the Timetable class first."); } context.SaveChanges(); }
public XmlExtractorController(ExpenseContext expenseContext, ReservationContext reservationContext) { ReservationContext = reservationContext; if (reservationContext.ReservationItems.Count() == 0) { reservationContext.SaveChanges(); } ExpenseContext = expenseContext; if (expenseContext.ExpenseItems.Count() == 0) { expenseContext.SaveChanges(); } }
private Order CreateOrder(int customerID, int eventID, List <Seat> seats) { if (seats.Count > 0) { Order newOrder = new Order(); using (var db = new ReservationContext()) using (DbContextTransaction transaction = db.Database.BeginTransaction()) { try { newOrder.CustomerID = customerID; newOrder.EventID = eventID; db.Orders.Add(newOrder); foreach (Seat seat in seats) { OrderSeat newSeat = new OrderSeat(); newSeat.OrderID = newOrder.ID; newSeat.SeatID = seat.ID; newOrder.OrderSeats.Add(newSeat); db.OrderSeats.Add(newSeat); } db.SaveChanges(); transaction.Commit(); newOrder = db.Orders .Include(i => i.OrderSeats.Select(s => s.Seat.Row)) .Where(w => w.ID.Equals(newOrder.ID)) .FirstOrDefault(); return(newOrder); } catch { transaction.Rollback(); } } } return(null); }
public async Task <bool> Logout(string username) { using var context = new ReservationContext(); var currentUser = await context.Users.FirstOrDefaultAsync(x => x.Username.Equals(username)); if (currentUser == null) { return(false); } currentUser.HasCurrentSession = false; context.SaveChanges(); //Default for HasCurrentSession should be false return(!currentUser.HasCurrentSession); }
//[HttpGet] public IActionResult EditIncoming(int exchangeid, bool accept) { ExchangeReservation exchangeReservation = _databaseHandler.GetExchangeReservationById(exchangeid); if (_userManager.GetUserAsync(User).Result.Id == exchangeReservation.TeacherFrom) { exchangeReservation.ExchangeAccepted = accept; if (accept) { _databaseHandler.ExchangeReservation(exchangeReservation.TeacherFrom, exchangeReservation.ReservationFromId, exchangeReservation.TeacherTo, exchangeReservation.ReservationOfferId); } } exchangeReservation.ExchangeStatus = true; _reservationContext.Entry(exchangeReservation).State = EntityState.Modified; _reservationContext.SaveChanges(); return(RedirectToAction("Anfragen")); }
public async Task <bool> UpdateReservation(Reservation currReservation, DateTime newTime, int newSlot) { await using var context = new ReservationContext(); var reservation = await context.Reservations .Where(x => x.ReservationId == currReservation.ReservationId) .Include(y => y.User) .ThenInclude(z => z.Rights) .FirstOrDefaultAsync(); if (reservation == null) { return(false); } var timestamp = getTimestampsFromTimeslot(newSlot, newTime); reservation.StartTime = timestamp.start; reservation.EndTime = timestamp.end; return(context.SaveChanges() > 0); }