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