/// <summary>
/// Gets a list reservations by phone number of the customer
/// </summary>
/// <param name="phone">The customers phone number</param>
/// <returns>Returns the list of the reservations</returns>
public List <Reservation> GetReservationByCusPhone(string phone)
{
DBCustomer dbC = new DBCustomer();
Customer cus = dbC.GetByPhone(phone);
int id = cus.CusID;
List <Reservation> list = new List <Reservation>();
var db = new ConnectToDatabaseDataContext();
list = db.Reservations.Select(x => x).Where(x => x.CustomerID == id).ToList();
return(list);
}
public IEnumerable GetReservation()
{
ConnectToDatabaseDataContext db = new ConnectToDatabaseDataContext();
DBCustomer dbCustomer = new DBCustomer();
List <Customer> customers = dbCustomer.GetAllCustomers().Cast <Customer>().ToList();
List <Reservation> reservation = db.Reservations.Select(x => x).AsEnumerable().ToList();
var cusResJoin = from res in reservation
join cust in customers on res.CustomerID equals cust.CusID
select res;
return(cusResJoin);
}
