public List <RestaurantEvent> GetRestaurantEvents(int userId)
{
List <RestaurantEvent> events = new List <RestaurantEvent>();
try
{
using (var context = new DBModels())
{
if (context.Database.Connection.State == System.Data.ConnectionState.Closed || context.Database.Connection.State == System.Data.ConnectionState.Broken)
{
context.Database.Connection.Open();
}
events = (from resEvent in context.RestaurantEvent
join restAdmin in context.RestaurantAdministrators
on resEvent.RestaurantId equals restAdmin.RestaurantId
where restAdmin.UserID == userId
select resEvent).ToList();
}
}
catch (Exception ex)
{
_logger.Log("GetRestaurantEvents_Exception", ex.Message);
}
return(events);
}
public void GenerateResetCode(string userOrEmail, out string message, out bool responseFlag)
{
try
{
message = string.Empty;
using (var context = new DBModels())
{
var userDetails = context.UserTbl.FirstOrDefault(x => x.Username == userOrEmail || x.Email == userOrEmail);
UserResetPasswordCodes resetPassword = new UserResetPasswordCodes();
if (userDetails != null)
{
var userResetCode = context.UserResetPasswordCodes.FirstOrDefault(x => x.UserID == userDetails.UserID);
if (userResetCode != null)
{
resetPassword.CreationDate = DateTime.Now;
resetPassword.UserID = userDetails.UserID;
resetPassword.ResetCode = Guid.NewGuid().ToString().Substring(0, 5).ToUpper();
context.UserResetPasswordCodes.Add(resetPassword);
context.SaveChanges();
SendEmailResetCode(resetPassword.ResetCode, userDetails);
responseFlag = true;
}
else
{
message = UserMessages.ResetCodeAlreadyGenerated;
responseFlag = false;
}
}
else
{
message = UserMessages.MissingUser;
responseFlag = false;
}
}
}
catch (Exception ex)
{
message = UserMessages.UnexpectedError;
responseFlag = false;
_logger.Log("GenerateResetCode_UserOperations Exception: ", ex.Message);
}
}
public string CreateRestaurantReview(RestaurantReview restaurantReview)
{
string saveMessage;
try
{
using (var context = new DBModels())
{
context.RestaurantReview.Add(restaurantReview);
context.SaveChanges();
saveMessage = RestaurantReviewMessages.OkCreatMessage;
}
}
catch (Exception ex)
{
saveMessage = RestaurantReviewMessages.NokCreatMessage;
_logger.Log("SaveRestaurantReview_Exception", ex.Message);
}
return(saveMessage);
}
//public List<Restaurants> GetRestaurantsByLocation(string location)
//{
// return _databaseEntities.RestaurantLocations.Where(x => x.RestaurantCity.ToUpper() == location.ToUpper()).Select(x => x.Restaurants).ToList();
//}
public string AddRestaurant(ref Restaurants restaurant)
{
string message = RestaurantMessages.RestaurantSaved;
try
{
_databaseEntities.Restaurants.Add(restaurant);
_databaseEntities.SaveChanges();
}
catch (Exception ex)
{
_logger.Log("AddRestaurant_RestaurantOperations_Exception", ex.Message);
message = RestaurantMessages.RestaurantNotSaved;
}
return(message);
}
