public List <MenuItemDTO> GetMenuItemsByRestaurantID(int RestaurantID, int?page, int pageSize) { List <MenuItemDTO> MenuItems = default(List <MenuItemDTO>); try { using (IEateryDbContext context = _unitOfWork.GetEateryDbContext()) { var MenuItemList = this._MenuItemRepository.GetAllQuery(context) .OrderByDescending(x => x.ID) .Where(x => x.RestaurantID == RestaurantID) .Skip((page ?? 0) * pageSize) .Take(pageSize) .ToList(); if (MenuItemList != null && MenuItemList.Any()) { MenuItems = ObjectTypeConverter.ConvertList <MenuItem, MenuItemDTO>(MenuItemList).ToList(); } } } catch (Exception) { throw; } return(MenuItems); }
public RestaurantContactDetailDTO GetRestaurantContactDetailById(int RestaurantID) { RestaurantContactDetailDTO RestaurantContactDetailDto = default(RestaurantContactDetailDTO); using (IEateryDbContext context = _unitOfWork.GetEateryDbContext()) { try { RestaurantContactDetailDto = (from sp in this._RestaurantRepository.GetAllQuery(context) join u in this._userRepository.GetAllQuery(context) on sp.UserID equals u.ID where sp.ID == RestaurantID select new RestaurantContactDetailDTO() { ID = sp.ID, //UserID = u.ID, FirstName = u.FirstName, Address = sp.Address, PhoneNumber = u.PhoneNumber, Email = u.Email }).FirstOrDefault(); } catch (Exception ex) { //AppLogManager.LogError(ex); throw ex; } } return(RestaurantContactDetailDto); }
public bool AddRestaurantMenuItems(RestaurantMenuItemsDTO RestaurantMenuItemsDTO, int userID) { if (RestaurantMenuItemsDTO != null) { using (IEateryDbContext context = _unitOfWork.GetEateryDbContext()) { using (var dbContextTransaction = ((IDbContext)context).GetDataBase().BeginTransaction()) { try { if (userID > 0 && RestaurantMenuItemsDTO.RestaurantID > 0) { foreach (var MenuItemDTO in RestaurantMenuItemsDTO.MenuItemList) { this.Add(MenuItemDTO, userID); } dbContextTransaction.Commit(); return(true); } else { dbContextTransaction.Rollback(); } } catch (Exception) { dbContextTransaction.Rollback(); } } } } return(false); }
public int Count() { int MenuItemsCount = default(int); using (IEateryDbContext context = _unitOfWork.GetEateryDbContext()) { MenuItemsCount = this._MenuItemRepository.GetAllQuery(context).Count(); } return(MenuItemsCount); }
public RestaurantDTO Register(RestaurantDTO restaurantDTO, int userID) { if (restaurantDTO != null) { using (IEateryDbContext context = _unitOfWork.GetEateryDbContext()) { using (var dbContextTransaction = ((IDbContext)context).GetDataBase().BeginTransaction()) { try { if (userID > 0) { Restaurant restaurant = ObjectTypeConverter.Convert <RestaurantDTO, Restaurant>(restaurantDTO); restaurant.UserID = userID; restaurant.CreatedBy = userID; restaurant.CreatedDate = DateTime.Now; this._RestaurantRepository.Add(context, restaurant); _unitOfWork.Commit(context); if (restaurant.ID > 0) { foreach (var operationTimingsDTO in restaurantDTO.OperationTimings) { OperationTiming operationTiming = ObjectTypeConverter.Convert <OperationTimingDTO, OperationTiming>(operationTimingsDTO); operationTiming.RestaurantID = restaurant.ID; operationTiming.CreatedBy = userID; operationTiming.CreatedDate = DateTime.Now; this._OperationTimingRepository.Add(context, operationTiming); _unitOfWork.Commit(context); } dbContextTransaction.Commit(); restaurantDTO = ObjectTypeConverter.Convert <Restaurant, RestaurantDTO>(restaurant); } else { dbContextTransaction.Rollback(); } } else { dbContextTransaction.Rollback(); } } catch (Exception ex) { dbContextTransaction.Rollback(); } } } } return(restaurantDTO); }
public RegisterOwnerWithRestaurantDTO RegisterOwnerWithRestaurant(RegisterOwnerWithRestaurantDTO RestaurantRegistrationDTO) { if (RestaurantRegistrationDTO != null) { using (IEateryDbContext context = _unitOfWork.GetEateryDbContext()) { using (var dbContextTransaction = ((IDbContext)context).GetDataBase().BeginTransaction()) { try { User user = ObjectTypeConverter.Convert <UserDTO, User>(RestaurantRegistrationDTO.UserDTO); this._userRepository.Add(context, user); _unitOfWork.Commit(context); if (user.ID > 0) { Restaurant Restaurant = ObjectTypeConverter.Convert <RestaurantDTO, Restaurant>(RestaurantRegistrationDTO.RestaurantDTO); Restaurant.UserID = user.ID; this._RestaurantRepository.Add(context, Restaurant); _unitOfWork.Commit(context); if (Restaurant.ID > 0) { foreach (var MenuItemDTO in RestaurantRegistrationDTO.RestaurantDTO.MenuItemList) { MenuItem MenuItem = ObjectTypeConverter.Convert <MenuItemDTO, MenuItem>(MenuItemDTO); this._MenuItemRepository.Add(context, MenuItem); _unitOfWork.Commit(context); } dbContextTransaction.Commit(); } else { dbContextTransaction.Rollback(); } } else { dbContextTransaction.Rollback(); } } catch (Exception) { dbContextTransaction.Rollback(); } } } } return(RestaurantRegistrationDTO); }
public UserDTO CreateNewUser(UserDTO userDTO) { if (userDTO != null && userDTO.ID == 0) { using (IEateryDbContext context = _unitOfWork.GetEateryDbContext()) { User user = ObjectTypeConverter.Convert <UserDTO, User>(userDTO); this._userRepository.Add(context, user); _unitOfWork.Commit(context); return(ObjectTypeConverter.Convert <User, UserDTO>(user)); } } return(default(UserDTO)); }
public bool Remove(MenuItemRatingDTO ratingDTO) { if (ratingDTO != null) { using (IEateryDbContext context = _unitOfWork.GetEateryDbContext()) { MenuItemRating rating = ObjectTypeConverter.Convert <MenuItemRatingDTO, MenuItemRating>(ratingDTO); this._menuItemRatingRepository.Delete(context, rating); _unitOfWork.Commit(context); return(true); } } return(false); }
public UserDTO Update(UserDTO userDTO, int userID) { using (IEateryDbContext context = _unitOfWork.GetEateryDbContext()) { User user = ObjectTypeConverter.Convert <UserDTO, User>(userDTO); user.UpdatedDate = DateTime.Now; user.UpdatedBy = userID; user = this._userRepository.Update(context, user); _unitOfWork.Commit(context); if (user != null) { return(ObjectTypeConverter.Convert <User, UserDTO>(user)); } } return(default(UserDTO)); }
public List <RestaurantDTO> SearchRestaurants(SearchCriteriaDTO searchCriteria) { List <RestaurantDTO> Restaurants = default(List <RestaurantDTO>); if (searchCriteria != null) { using (IEateryDbContext context = _unitOfWork.GetEateryDbContext()) { List <Restaurant> RestaurantList = this._RestaurantRepository.GetAllQuery(context).ToList(); if (RestaurantList != null && RestaurantList.Any()) { Restaurants = ObjectTypeConverter.ConvertList <Restaurant, RestaurantDTO>(RestaurantList).ToList(); } } } return(Restaurants); }
public bool Add(MenuItemRatingDTO ratingDTO) { if (ratingDTO != null) { using (IEateryDbContext context = _unitOfWork.GetEateryDbContext()) { MenuItemRating rating = ObjectTypeConverter.Convert <MenuItemRatingDTO, MenuItemRating>(ratingDTO); //rating.CreatedBy = ratingDTO.userID; //rating.CreatedDate = DateTime.Now; this._menuItemRatingRepository.Add(context, rating); _unitOfWork.Commit(context); return(true); } } return(false); }
public bool Add(MenuItemDTO MenuItemDTO, int userID) { if (MenuItemDTO != null) { using (IEateryDbContext context = _unitOfWork.GetEateryDbContext()) { MenuItem MenuItem = ObjectTypeConverter.Convert <MenuItemDTO, MenuItem>(MenuItemDTO); MenuItem.CreatedBy = userID; MenuItem.CreatedDate = DateTime.Now; this._MenuItemRepository.Add(context, MenuItem); _unitOfWork.Commit(context); return(true); } } return(false); }
public bool CheckEmailExist(string email) { bool rtnVal = false; using (IEateryDbContext context = _unitOfWork.GetEateryDbContext()) { try { rtnVal = this._userRepository.GetAllQuery(context).Any(x => x.Email == email); } catch (Exception ex) { //AppLogManager.LogError(ex); throw ex; } } return(rtnVal); }
public bool Add(OperationTimingDTO operationTimingDTO, int userID) { if (operationTimingDTO != null) { using (IEateryDbContext context = _unitOfWork.GetEateryDbContext()) { OperationTiming operationTiming = ObjectTypeConverter.Convert <OperationTimingDTO, OperationTiming>(operationTimingDTO); operationTiming.CreatedBy = userID; operationTiming.CreatedDate = DateTime.Now; this._operationTimingRepository.Add(context, operationTiming); _unitOfWork.Commit(context); return(true); } } return(false); }
public MenuItemDTO Update(MenuItemDTO menuItemDTO, int?userID) { using (IEateryDbContext context = _unitOfWork.GetEateryDbContext()) { MenuItem menuItem = this._MenuItemRepository.GetById(context, menuItemDTO.ID); if (menuItem != null) { menuItem.IsPublished = menuItemDTO.IsPublished; menuItem.UpdatedDate = DateTime.Now; menuItem.UpdatedBy = userID; menuItem = this._MenuItemRepository.Update(context, menuItem); _unitOfWork.Commit(context); if (menuItem != null) { return(ObjectTypeConverter.Convert <MenuItem, MenuItemDTO>(menuItem)); } } } return(default(MenuItemDTO)); }
public string GetUsernameById(int userID) { string username = string.Empty; using (IEateryDbContext context = _unitOfWork.GetEateryDbContext()) { try { User user = this._userRepository.GetAllQuery(context).FirstOrDefault(x => x.ID == userID); if (user != null) { username = user.Username; } } catch (Exception ex) { //AppLogManager.LogError(ex); throw ex; } } return(username); }
public int GetUserIdByUserName(string username) { int userID = default(int); using (IEateryDbContext context = _unitOfWork.GetEateryDbContext()) { try { User user = this._userRepository.GetAllQuery(context).FirstOrDefault(x => x.Username == username); if (user != null) { userID = user.ID; } } catch (Exception ex) { //AppLogManager.LogError(ex); throw ex; } } return(userID); }
public MenuItemDTO GetMenuItemById(int MenuItemID) { MenuItemDTO MenuItemDto = default(MenuItemDTO); using (IEateryDbContext context = _unitOfWork.GetEateryDbContext()) { try { MenuItem MenuItem = this._MenuItemRepository.GetAllQuery(context).FirstOrDefault(x => x.ID == MenuItemID); if (MenuItem != null) { MenuItemDto = ObjectTypeConverter.Convert <MenuItem, MenuItemDTO>(MenuItem); return(MenuItemDto); } } catch (Exception ex) { //AppLogManager.LogError(ex); throw ex; } } return(MenuItemDto); }
public RestaurantDTO GetRestaurantById(int RestaurantID) { RestaurantDTO RestaurantDto = default(RestaurantDTO); using (IEateryDbContext context = _unitOfWork.GetEateryDbContext()) { try { var Restaurant = this._RestaurantRepository.GetAllQuery(context).FirstOrDefault(x => x.ID == RestaurantID); if (Restaurant != null) { RestaurantDto = ObjectTypeConverter.Convert <Restaurant, RestaurantDTO>(Restaurant); return(RestaurantDto); } } catch (Exception ex) { //AppLogManager.LogError(ex); throw ex; } } return(RestaurantDto); }
public UserDTO GetUserById(int userID) { UserDTO userDto = default(UserDTO); using (IEateryDbContext context = _unitOfWork.GetEateryDbContext()) { try { User user = this._userRepository.GetAllQuery(context).FirstOrDefault(x => x.ID == userID); if (user != null) { userDto = ObjectTypeConverter.Convert <User, UserDTO>(user); return(userDto); } } catch (Exception ex) { //AppLogManager.LogError(ex); throw ex; } } return(userDto); }
public UserDTO GetUserByEmailPassword(string email, string password) { UserDTO userDto = default(UserDTO); using (IEateryDbContext context = _unitOfWork.GetEateryDbContext()) { try { User user = this._userRepository.GetAllQuery(context).FirstOrDefault(x => x.Email == email && x.Password == password); if (user != null) { userDto = ObjectTypeConverter.Convert <User, UserDTO>(user); return(userDto); } } catch (Exception ex) { //AppLogManager.LogError(ex); throw ex; } } return(userDto); }
public RestaurantDTO GetRestaurantByUserID(int userID) { RestaurantDTO RestaurantDTO = default(RestaurantDTO); try { using (IEateryDbContext context = _unitOfWork.GetEateryDbContext()) { var Restaurant = (from Restaurants in this._RestaurantRepository.GetAllQuery(context) join users in this._userRepository.GetAllQuery(context) on Restaurants.UserID equals users.ID where users.ID == userID select Restaurants).FirstOrDefault(); if (Restaurant != null) { RestaurantDTO = ObjectTypeConverter.Convert <Restaurant, RestaurantDTO>(Restaurant); } } } catch (Exception) { throw; } return(RestaurantDTO); }