public ActionResult Create(Booking booking) { /*[Bind(Include = "BookingId,CustomerID,Dob")]*/ ViewBag.CustomerID = new SelectList(db.Customers, "CustomerId", "FirstName", booking.CustomerID); ViewBag.EmployeeID = new SelectList(db.Employees, "EmployeeId", "FirstName", booking.EmployeeID); ViewBag.RoomID = new SelectList(db.Rooms, "RoomId", "Name", booking.RoomID); if (ModelState.IsValid) { booking.customer = db.Customers.Find(booking.CustomerID); booking.employee = db.Employees.Find(booking.EmployeeID); booking.room = db.Rooms.Find(booking.RoomID); db.Bookings.Add(booking); db.SaveChanges(); return RedirectToAction("Index"); } return View(booking); }
public void FillCustomerDropdownData(Booking booking, bool searchCustomer, string customerCreditials) { string[] customers = new string[db.Customers.Count()]; int i = 0; foreach (Customer c in db.Customers) { customers[i] = c.CustomerId + ". " + c.FirstName + " " + c.LastName; i++; } Customer customer = db.Customers.Find(booking.CustomerID); if (searchCustomer) customerCreditials = customer.CustomerId + ". " + customer.FirstName + " " + customer.LastName; ViewData["CustomerID"] = new SelectList(customers .Select(x => new { value = x, text = x }), "value", "text", customerCreditials); }
public void FillRoomDropdownData(Booking booking, bool searchRoom, string roomName) { string[] rooms = new string[db.Rooms.Count()]; int i = 0; foreach (Room r in db.Rooms) { rooms[i] = r.RoomId + ". " + r.Name; i++; } Room room = db.Rooms.Find(booking.RoomID); if (searchRoom) roomName = room.RoomId + ". " + room.Name; ViewData["RoomID"] = new SelectList(rooms .Select(x => new { value = x, text = x }), "value", "text", roomName); }
public ActionResult Edit(Booking booking, string CustomerID, string EmployeeID, string RoomID) { booking.CustomerID = Int32.Parse(CustomerID.Substring(0, CustomerID.IndexOf(". "))); booking.EmployeeID = Int32.Parse(EmployeeID.Substring(0, EmployeeID.IndexOf(". "))); booking.RoomID = Int32.Parse(RoomID.Substring(0, RoomID.IndexOf(". "))); FillCustomerDropdownData(booking, false, CustomerID); FillEmployeeDropdownData(booking, false, EmployeeID); FillRoomDropdownData(booking, false, RoomID); //if (ModelState.IsValid) { booking.customer = db.Customers.Find(booking.CustomerID); booking.employee = db.Employees.Find(booking.EmployeeID); booking.room = db.Rooms.Find(booking.RoomID); db.Entry(booking).State = EntityState.Modified; db.SaveChanges(); return RedirectToAction("Index"); } return View(booking); }
public void FillEmployeeDropdownData(Booking booking, bool searchEmployee, string employeeCreditials) { string[] employees = new string[db.Employees.Count()]; int i = 0; foreach (Employee e in db.Employees) { employees[i] = e.EmployeeId + ". " + e.FirstName + " " + e.LastName; i++; } Employee employee = db.Employees.Find(booking.EmployeeID); if (searchEmployee) employeeCreditials = employee.EmployeeId + ". " + employee.FirstName + " " + employee.LastName; ViewData["EmployeeID"] = new SelectList(employees .Select(x => new { value = x, text = x }), "value", "text", employeeCreditials); }