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