// try to get this on query setup
private void GetCurrentBusinessDetails()
{
if (searchDataGrid.SelectedIndex > -1)
{
Classes.Business currentBusiness = (Classes.Business)searchDataGrid.SelectedItem;
addressTextBox.Text = currentBusiness.address;
businessTextBox.Text = currentBusiness.name;
List <Object[]> newObject = query.GetCurrentBusinessCategories(currentBusiness.business_id);
StringBuilder sb = new StringBuilder();
foreach (Object[] item in newObject)
{
sb.Append(item[0] + "\n");
}
categoryTextBox.Text = sb.ToString();
sb = new StringBuilder();
newObject = query.GetCurrentBusinessAttributes(currentBusiness.business_id);
foreach (Object[] item in newObject)
{
if (!item[1].ToString().Equals("False"))
{
if (item[1].ToString().Equals("True"))
{
sb.AppendLine(item[0].ToString());
}
else
{
sb.AppendLine(item[0].ToString() + " : " + item[1].ToString());
}
}
//sb.Append(item[0] + " : " + item[1]+ "\n");
}
attributesTextBox.Text = sb.ToString();
sb = new StringBuilder();
DateTime today = DateTime.Now;
Classes.Hours newHours = query.GetCurrentBusinessHours(currentBusiness.business_id, today.ToString("dddd"));
if (newHours != null)
{
sb.Append("Today(" + newHours.hours_day + ")\n");
sb.Append("Opens: " + newHours.hours_open.ToString("hh:mm") + "\n");
sb.Append("Closed: " + newHours.hours_close.ToString("hh:mm"));
}
else
{
sb.Append("Today(" + today.ToString("dddd") + ")\n");
sb.Append("Opens: N/A \n");
sb.Append("Closed: N/A");
}
hoursTextBox.Text = sb.ToString();
AddPin(new Location(currentBusiness.latitute, currentBusiness.longtitude), currentBusiness.name, Colors.Green);
}
}
public void GetLoginBusinessHours(String currentDay)
{
if (businessLogInListBox.SelectedIndex > -1 && query.GetLoggedInBusiness() != null)
{
Classes.Business currLoginBusiness = query.GetLoggedInBusiness();
Classes.Hours newHour = query.GetCurrentBusinessHours(currLoginBusiness.business_id, currentDay);
StringBuilder sb = new StringBuilder();
if (newHour != null)
{
sb.Append("Opens: " + newHour.hours_open.ToString("hh:mm") + "\n");
sb.Append("Closed: " + newHour.hours_close.ToString("hh:mm"));
}
else
{
sb.Append("Opens: N/A \n");
sb.Append("Closed: N/A");
}
loggedInHours.Text = sb.ToString();
}
}
