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