public List <Notification> SendNotificationToApp(string notification)
{
//_databaseEngine.Get_Access_Token_Via_FirebaseToken
//_databaseEngine.Get_All_Notifications_Of_User(notification);
//var result = sQL_DatabaseService.Get_All_Notifications_Of_User(notification.ToString());
var notifications = _databaseEngine.Get_All_Notifications_Of_User(notification);
return(notifications);
}
public string ReturnUserData(string token)
{
string[] columnUser =
{
"FirstName",
"UserSurname",
"Email",
"carrierStatus",
"totalIncidents",
"ProfilePicture"
};
var builder = new StringBuilder();
builder.AppendJoin(",", columnUser);
builder.AppendLine();
var user = DatabaseEngine.Get_Single_User(token);
string[] values = { user.FirstName, user.UserSurname, user.Email, user.carrierStatus.ToString(), user.totalIncidents.ToString(), user.ProfilePicture };
builder.AppendJoin(",", values);
builder.AppendLine();
string[] columnNotification =
{
"Title",
"Body",
"Created",
"Risk"
};
builder.AppendJoin(",", columnNotification);
builder.AppendLine();
var notifications = DatabaseEngine.Get_All_Notifications_Of_User(token);
if (notifications != null)
{
notifications.ForEach(notification =>
{
string[] row = { notification.Title, notification.Body, notification.Created.ToString(), notification.Risk.ToString() };
builder.AppendJoin(",", row);
builder.AppendLine();
});
}
string[] columnLocation =
{
"Latitude",
"Longitude",
"Carrier_Data_Point",
"Created",
"Country",
"Province",
"City",
"Suburb"
};
builder.AppendJoin(",", columnLocation);
builder.AppendLine();
var locations = DatabaseEngine.Select_List_Locations().Where(loc => loc.AccessToken == token) as List <Location>;
if (locations != null)
{
locations.ForEach(location =>
{
if (location != null)
{
if (location.Region != null)
{
string[] row = { location.Latitude.ToString(), location.Longitude.ToString(), location.Carrier_Data_Point.ToString(), location.Created.ToString(), location.Region.Country, location.Region.Province, location.Region.City, location.Region.Suburb };
builder.AppendJoin(",", row);
builder.AppendLine();
}
}
});
}
string[] columnItinerary =
{
"Created",
"TotalItineraryRisk"
};
string[] itineraryLocation =
{
"Latitude",
"Longitude",
"Carrier_Data_Point",
"Created",
"Country",
"Province",
"City",
"Suburb",
"Risk"
};
var itineraries = DatabaseEngine.Get_Itinerary_Risks_By_Token(token);
if (itineraries != null)
{
itineraries.ForEach(itinerary =>
{
builder.AppendJoin(",", columnItinerary);
builder.AppendLine();
string[] row = { itinerary.Created.ToString(), itinerary.TotalItineraryRisk.ToString() };
builder.AppendJoin(",", row);
builder.AppendLine();
builder.AppendJoin(",", itineraryLocation);
builder.AppendLine();
var keys = itinerary.LocationItineraryRisks.Keys;
var values = itinerary.LocationItineraryRisks.Values;
for (int i = 0; i < itinerary.LocationItineraryRisks.Count; i++)
{
string[] row2 = { keys.ElementAt(i).Latitude.ToString(), keys.ElementAt(i).Longitude.ToString(), keys.ElementAt(i).Carrier_Data_Point.ToString(), keys.ElementAt(i).Created.ToString(), keys.ElementAt(i).Region.Country, keys.ElementAt(i).Region.Province, keys.ElementAt(i).Region.City, keys.ElementAt(i).Region.Suburb, values.ElementAt(i).ToString() };
builder.AppendJoin(",", row2);
builder.AppendLine();
}
});
}
return(builder.ToString());
}
