/// <summary> /// /// </summary> /// <param name="hotelId"></param> /// <returns></returns> public List <MenuCardEntities> GetHotelMenuDetails(int hotelId) { List <MenuCardEntities> menuCardEntities = new List <MenuCardEntities>(); using (bookmytableEntities Context = new bookmytableEntities()) { var result = Context.Sp_GetHotelMenuDetails(hotelId).ToList(); foreach (var item in result) { menuCardEntities.Add(new MenuCardEntities { HotelId = item.HotelId, HotelName = item.HotelName, MenuID = Convert.ToInt32(item.MenuID), MenuName = item.MenuName, MenuDescription = Convert.ToString(item.MenuDescription), IsVeg = Convert.ToInt32(item.IsVeg), IsAvailable = Convert.ToInt32(item.IsAvailable), Price = Convert.ToDecimal(item.Price), CreateDate = Convert.ToDateTime(item.CreateDate) }); } }; return(menuCardEntities); }
/// <summary> /// /// </summary> /// <param name="od"></param> /// <returns></returns> public List <OrderDetails> AddTablesAndOrderBooking(OrderDetailsEntities od) { List <OrderDetails> oredrDetails = new List <OrderDetails>(); using (bookmytableEntities Context = new bookmytableEntities()) { var result = Context.AddTableBookAndMenuOrder(od.HotelId, 1, od.TotalAmount, od.ApprovalName, od.CustomerName, od.PhoneNumber, od.EmailID, od.City, od.Country, od.Address).ToList(); foreach (var menuItem in od.MenuList) { var result2 = Context.AddOrderMenuDetails(od.HotelId, menuItem.MenuID, od.TotalAmount, result[0].OrderID, menuItem.Quantity, menuItem.MenuName); } foreach (var item in result) { oredrDetails.Add(new OrderDetails { CustomerID = Convert.ToInt32(item.CustomerID), OrderID = Convert.ToInt32(item.OrderID), OrderPaymentID = Convert.ToInt32(item.OrderPaymentID), }); } //od.EmailID = "*****@*****.**"; if (!string.IsNullOrEmpty(od.EmailID)) { string subject = "Your Order confirmation : " + oredrDetails[0].OrderID; string message = "Your order has been Succesfully placed </br> Your Total Amount : " + od.TotalAmount; SendMailToCustomer(od.EmailID, message, subject); } }; return(oredrDetails); }
public UserDetails GetUserDetails(string userName, string Password) { UserDetails userDetail = new UserDetails(); using (bookmytableEntities Context = new bookmytableEntities()) { var result = Context.Sp_GetUserAndUserRoleDetails(userName, Password).ToList(); if (result != null) { foreach (var item in result) { userDetail.Success = true; userDetail.FirstName = item.FirstName; userDetail.LastName = item.LastName; } } else { userDetail.Success = false; } } return(userDetail); }
public OrderDetails AddTablesAndOrderBooking(OrderDetailsEntities od) { OrderDetails oredrDetails = new OrderDetails(); using (bookmytableEntities Context = new bookmytableEntities()) { // var result = Context.AddTableBookAndMenuOrder().ToList(); }; return(oredrDetails); }
/// <summary> /// /// </summary> /// <param name="OrderID"></param> /// <returns></returns> public List <OrderDetails> GetOrderDetails(int OrderID) { List <OrderDetails> OrderDetailsEntities = new List <OrderDetails>(); using (bookmytableEntities Context = new bookmytableEntities()) { var result = Context.Sp_GetOrderDetails(OrderID).ToList(); foreach (var item in result) { OrderDetailsEntities.Add(new OrderDetails { OrderID = item.OrderID, ApprovalName = item.ApprovalName, IsApproveStatus = Convert.ToInt32(item.IsApproveStatus) }); } }; return(OrderDetailsEntities); }
/// <summary> /// get Retaurants details fro this methods GetllRestaurantDetails /// </summary> /// <returns> RestaurantEntities </returns> public List <RestaurantEntities> GetllRestaurantDetails() { List <RestaurantEntities> restaurantEntities = new List <RestaurantEntities>(); try { using (bookmytableEntities Context = new bookmytableEntities()) { var result = Context.Sp_GetRestaurantsDetails(null).ToList(); foreach (var item in result) { restaurantEntities.Add(new RestaurantEntities { id = item.id, HotelName = item.HotelName, ContactPersoneName = item.ContactPersoneName, Address = item.Address, City = item.City, Country = item.Country, EmailID = item.EmailID, OpenintHours = item.OpenintHours, PhoneNumber = item.PhoneNumber, Rating = Convert.ToInt32(item.Rating), TotalTable = Convert.ToInt32(item.TotalTable), TableCapacity = Convert.ToInt32(item.TableCapacity), TableAvailable = Convert.ToInt32(item.TableAvailable), CreateDate = item.CreateDate }); } } } catch (Exception ex) { throw ex; } return(restaurantEntities); }
/// <summary> /// /// </summary> /// <param name="hotelId"></param> /// <returns></returns> public List <HotelTableEntities> GetHotelstables(int hotelId) { List <HotelTableEntities> hotelTableEntities = new List <HotelTableEntities>(); using (bookmytableEntities Context = new bookmytableEntities()) { var result = Context.pSp_GetHotelDiningDetails(hotelId).ToList(); foreach (var item in result) { hotelTableEntities.Add(new HotelTableEntities { Id = item.DineID, TotalTable = Convert.ToInt32(item.TotalTable), TableCapacity = Convert.ToInt32(item.TableCapacity), CreateDate = Convert.ToDateTime(item.CreateDate) }); } }; return(hotelTableEntities); }
/// <summary> /// /// </summary> /// <param name="employeeID"></param> /// <returns></returns> public List <OrderDetails> GetOrderDetailsForApproval(int employeeID) { List <OrderDetails> OrderDetailsEntities = new List <OrderDetails>(); List <OrderItemDetails> orderItemDetails = new List <OrderItemDetails>(); using (bookmytableEntities Context = new bookmytableEntities()) { var result = Context.Sp_GetOrderDetailsToEmployee(employeeID, null).ToList(); foreach (var item in result) { var orderItemdetils = Context.OrderMenuEntities.Where(p => p.OrderId == item.OrderID).Select(p => p); foreach (var orderItem in orderItemdetils) { orderItemDetails.Add(new OrderItemDetails { DishName = orderItem.DishName, DishAmount = Convert.ToDecimal(orderItem.DishAmount), OrderId = Convert.ToInt32(orderItem.OrderId), Quantity = Convert.ToInt32(orderItem.Quantity), DishId = Convert.ToInt32(orderItem.DishId) }); } OrderDetailsEntities.Add(new OrderDetails { OrderItemDetails = orderItemDetails, OrderID = item.OrderID, HotelId = Convert.ToInt32(item.HotelId), TotalAmount = Convert.ToDecimal(item.TotalAmount) }); } }; return(OrderDetailsEntities); }