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