public string SaveRestaurantDetails(RestaurantDetails restaurantDetails)
{
string message;
try
{
using (var context = new DBModels())
{
var restDetail = context.RestaurantDetails.FirstOrDefault(x => x.RestaurantId == restaurantDetails.RestaurantId);
if (restDetail == null)
{
message = RestaurantMessages.RestaurantDetailsNotSaved;
}
else
{
restDetail.RestaurantDescription = restaurantDetails.RestaurantDescription;
restDetail.RestaurantThumbnail = restaurantDetails.RestaurantThumbnail;
restDetail.RestaurantProgram = restaurantDetails.RestaurantProgram;
restDetail.RestaurantContact = restaurantDetails.RestaurantContact;
context.Entry(restDetail).State = EntityState.Modified;
context.SaveChanges();
message = RestaurantMessages.RestaurantDetailsSaved;;
}
}
}
catch (Exception ex)
{
_logger.Log("SaveRestaurantDetails_RestaurantOperations_Exception", ex.Message);
return(message = RestaurantMessages.RestaurantDetailsNotSaved);
}
return(message);
}
//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);
}
public string UpdateRestaurantEvent(RestaurantEvent restaurantEvent)
{
string message;
try
{
using (var context = new DBModels())
{
var eventRest = context.RestaurantEvent.FirstOrDefault(x => x.RestaurantEventID == restaurantEvent.RestaurantEventID);
if (eventRest == null)
{
message = RestaurantEventMessage.NokUpdate;
}
else
{
eventRest.EventTitle = restaurantEvent.EventTitle;
eventRest.EventDescription = restaurantEvent.EventDescription;
eventRest.EventStartDate = restaurantEvent.EventStartDate;
eventRest.EventEndDate = restaurantEvent.EventEndDate;
context.Entry(eventRest).State = EntityState.Modified;
context.SaveChanges();
message = RestaurantEventMessage.OkUpdate;
}
}
}
catch (Exception ex)
{
_logger.Log("UpdateRestaurantEvent_Exception", ex.Message);
return(message = RestaurantEventMessage.NokUpdate);
}
return(message);
}
public string UpdateRestaurantReview(RestaurantReview restaurantReview)
{
string message;
try
{
using (var context = new DBModels())
{
var reviewRest = context.RestaurantReview.FirstOrDefault(x => x.RestaurantReviewID == restaurantReview.RestaurantReviewID);
if (reviewRest == null)
{
message = RestaurantReviewMessages.NokUpdateMessage;
}
else
{
reviewRest.ReviewComment = restaurantReview.ReviewComment;
context.Entry(reviewRest).State = EntityState.Modified;
context.SaveChanges();
message = RestaurantReviewMessages.OKUpdateMessage;
}
}
}
catch (Exception ex)
{
_logger.Log("UpdateRestaurantReview_Exception", ex.Message);
return(message = RestaurantEventMessage.NokUpdate);
}
return(message);
}
public string ResetUserPassword(string username, string resetCode, string newPassword)
{
string message;
try
{
using (var context = new DBModels())
{
var user = context.UserTbl.FirstOrDefault(x => x.Username == username || x.Email == username);
if (user == null)
{
message = UserMessages.MissingUser;
return(message);
}
var userResetCode = context.UserResetPasswordCodes.FirstOrDefault(x => x.UserID == user.UserID);
if ((userResetCode == null) || ((userResetCode.CreationDate - DateTime.Now).Minutes < 10))
{
message = UserMessages.ResetCodeInvalid;
}
else
{
if (userResetCode.ResetCode == resetCode)
{
user.UserPassword = newPassword;
context.Entry(user).State = EntityState.Modified;
context.SaveChanges();
message = UserMessages.PasswordChanged;
}
else
{
message = UserMessages.ResetCodeInvalid;
}
}
}
}
catch (Exception ex)
{
_logger.Log("ResetUserPassword_UserOperations Exception: ", ex.Message);
message = UserMessages.UnexpectedError;
}
return(message);
}
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 RegisterUser(UserTbl userToRegister)
{
string registerMessage;
using (var context = new DBModels())
{
if (!UserAlreadyExist(userToRegister))
{
context.UserTbl.Add(userToRegister);
context.SaveChanges();
registerMessage = UserMessages.UserRegisteredSuccesfully;
}
else
{
registerMessage = UserMessages.DuplicateUser;
}
}
return(registerMessage);
}
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 string SaveRestaurantEvent(RestaurantEvent restaurantEvent)
{
string saveMessage;
try
{
using (var context = new DBModels())
{
context.RestaurantEvent.Add(restaurantEvent);
context.SaveChanges();
saveMessage = RestaurantEventMessage.OkMessage;
}
}
catch (Exception ex)
{
saveMessage = RestaurantEventMessage.NokMessage;
_logger.Log("SaveRestaurantEvent_Exception", ex.Message);
}
return(saveMessage);
}