/// <summary> /// Adds all selected businesses to favorites /// </summary> /// <param name="users">User</param> /// <param name="businesses">Selected businesses</param> public static void AddToFavorites(Users users, List <Business> businesses) { foreach (Business business in businesses) { Insert insertData = new Insert("favorite"); insertData.AddParameter("userid", users.Userid); insertData.AddParameter("businessid", business.Businessid); RunNonCommand(insertData); } }
/// <summary> /// Update user coordinates and name if wanted /// </summary> /// <param name="users">User</param> public static void UpdateUserInformation(Users users) { Insert data = new Insert("users"); data.AddParameter("userid", users.Userid); data.AddParameter("name", users.Name); data.AddParameter("latitude", users.Latitude); data.AddParameter("longitude", users.Longitude); RunNonCommand(data); }
/// <summary> /// Insert or update hours for a business /// </summary> /// <param name="business">business</param> /// <param name="day">which day</param> /// <param name="opentime">opening time</param> /// <param name="closetime">closing time</param> public static void UpdateHours(Business business, string day, TimeSpan opentime, TimeSpan closetime) { Insert data = new Insert("businesshours"); data.AddParameter("day", day); data.AddParameter("businessid", business.Businessid); data.AddParameter("opentime", opentime); data.AddParameter("closetime", closetime); RunNonCommand(data); }
/// <summary> /// Inserts a checkin for a business /// </summary> /// <param name="businessid">Business id to check into</param> public static void CheckIn(Business business) { Insert data = new Insert("businesscheckins"); data.AddParameter("businessid", business.Businessid); RunNonCommand(data); }
/// <summary> /// Inserts a written review into the database /// </summary> /// <param name="review">Review written</param> public static void SubmitReview(Review review) { string reviewid = GenerateId(); Select data = new Select("review"); data.AddColumns("reviewid"); data.AddFilter($"reviewid = '{reviewid}'"); bool duplicate = true; // Check to see (however unlikely) if our reviewid generated already exists while (duplicate) { if (RunQuery(data).Rows.Count == 0) { duplicate = false; } else { Reinitialize(); } } review.Reviewid = reviewid; // Reviewid is unique and not a duplicate, start the insert Insert insertData = new Insert("review"); insertData.AddParameter("reviewid", review.Reviewid); insertData.AddParameter("userid", review.Userid); insertData.AddParameter("businessid", review.Businessid); insertData.AddParameter("stars", review.Stars); insertData.AddParameter("reviewtext", review.Reviewtext); RunNonCommand(insertData); // Generate a new ID and clear the old one void Reinitialize() { reviewid = GenerateId(); data.ClearFilter(); data.AddFilter($"reviewid = '{reviewid}'"); } }
/// <summary> /// Update business name address city state and/or zip /// </summary> /// <param name="business">business</param> public static void UpdateBusinessInformationOwnerPage(Business business) { Insert data = new Insert("business"); data.AddParameter("businessid", business.Businessid); data.AddParameter("name", business.Name); data.AddParameter("address", business.Address); data.AddParameter("city", business.City); data.AddParameter("state", business.State); data.AddParameter("zipcode", business.Zipcode); RunNonCommand(data); }