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