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