public static FlightDataTable InsertFlight(FlightContent item, List <InputData> dataList)
{
using (var conn = new SQLiteConnection(new SQLitePlatformIOS(), GetPath()))
{
CreateFlightTables(conn);
var flightData = conn.GetAllWithChildren <FlightDataTable>().
FirstOrDefault(x => x.Key == item.Key);
var data = new FlightDataTable();
data.Add(item);
if (dataList != null)
{
List <InputDataTable> inputTable = new List <InputDataTable>();
foreach (var inputItem in dataList)
{
var value = new InputDataTable();
value.Add(inputItem);
inputTable.Add(value);
}
data.InputDataList = inputTable;
}
if (flightData == null)
{
conn.InsertWithChildren(data, true);
return(data);
}
else
{
conn.UpdateWithChildren(data);
return(data);
}
}
//return false;
}
public void Add(Station station, FlightContent flight)
{
FlightStatusList.Add(new StationFlightInfo()
{
Name = station.Name,
Date = $"{flight.EpochTime.FromUnixTime():dd.MM.yyyy HH:mm}",
Status = GetImageName(flight.EpochTime.FromUnixTime(), flight.IsRealTimeFlight),
Station = station
});
public void Add(FlightContent item)
{
Key = item.Key;
Date = item.Date;
Time = item.Time;
FileName = item.FileName;
Url = item.Url;
Url100 = item.Url100;
UrlEnd = item.UrlEnd;
IsRealTimeFlight = item.IsRealTimeFlight;
}
void UpdateTableData(FlightContent data)
{
InvokeOnMainThread(() =>
{
TableSource.FlightList.Add(data);
tableView.ReloadData();
View.SetNeedsDisplay();
ActivityIndicator.StopAnimating();
Console.WriteLine("Flight added");
});
}
void DeleteFlight(FlightContent flight, UITableView tableView)
{
if (DatabaseHelper.DeleteFlight(flight))
{
Console.WriteLine($"Flight with key: {flight.Key} was deleted");
FirebaseHelper.FireBaseHelper.DeleteFlightFromCloud(flight, ViewController.ActiveStation.Key);
FlightList.RemoveAt(DeleteIndexPath.Row);
tableView.BeginUpdates();
tableView.DeleteRows(new NSIndexPath[] { DeleteIndexPath }, UITableViewRowAnimation.Automatic);
tableView.ReloadData();
tableView.EndUpdates();
}
}
public static bool DeleteFlight(FlightContent data)
{
using (var conn = new SQLiteConnection(new SQLitePlatformIOS(), GetPath()))
{
var flightData = conn.GetAllWithChildren <FlightDataTable>().
FirstOrDefault(x => x.Key == data.Key);
if (flightData != null)
{
conn.Delete(flightData);
return(true);
}
}
return(false);
}
void DeleteTableDate(FlightContent data)
{
var index = TableSource.FlightList.FindIndex(x => x.Key == data.Key);
InvokeOnMainThread(() =>
{
//TableSource.FlightList.RemoveAt(index);
//tableView.BeginUpdates();
tableView.ReloadData();
View.SetNeedsDisplay();
//tableView.EndUpdates();
ActivityIndicator.StopAnimating();
Console.WriteLine("Flight deleted");
});
}
private FlightContent GetFlightDataFromSnapshot(DataSnapshot snapshot)
{
var data = snapshot.GetValue <NSDictionary>();
Console.WriteLine(snapshot.Key);
FlightContent flightData = new FlightContent();
flightData.Key = snapshot.Key;
flightData.Date = GetStringValue(data["Date"]);
flightData.Time = GetStringValue(data["Time"]);
flightData.FileName = GetStringValue(data["FileName"]);
flightData.Url = GetStringValue(data["Url"]);
flightData.Url100 = GetStringValue(data["Url100"]);
flightData.UrlEnd = GetStringValue(data["UrlEnd"]);
flightData.IsRealTimeFlight = GetBoolValue(data["IsRealTimeDataAvailable"]).GetValueOrDefault();
flightData.EpochTime = GetDoubleValue(data["EpochTime"]).GetValueOrDefault();
return(flightData);
}
void ConfirmDelete(FlightContent flight, UITableView tableView)
{
var confirmationString = "FLIGHT_DELETE_CONFIRMATION".GetLocalString().Replace("###REPLACE###", $"{flight.Date}/{flight.Time}");
var okCancelAlertController = UIAlertController.Create("Delete flight".GetLocalString(),
confirmationString,
UIAlertControllerStyle.Alert);
//Add Actions
okCancelAlertController.AddAction(UIAlertAction.Create("OK".GetLocalString(),
UIAlertActionStyle.Default,
alert => {
Console.WriteLine("Okay was clicked");
DeleteFlight(flight, tableView);
}));
okCancelAlertController.AddAction(UIAlertAction.Create("Cancel".GetLocalString(),
UIAlertActionStyle.Cancel,
alert => Console.WriteLine("Cancel was clicked")));
//Present Alert
ViewController.PresentViewController(okCancelAlertController, true, null);
}
public MessageBaseViewController(IntPtr handle) : base(handle)
{
var appDelegate = UIApplication.SharedApplication.Delegate as AppDelegate;
Flight = appDelegate.CurrentFlight;
}
public static void DeleteFlightFromCloud(FlightContent data, string stationKey)
{
var storage = Storage.DefaultInstance;
if (!string.IsNullOrEmpty(data.Url))
{
var urlDeleted = storage.GetReferenceFromUrl(data.Url);
urlDeleted.Delete((error) =>
{
if (error != null)
{
// Uh-oh, an error occurred!
Console.WriteLine($"Delete file :{data.Url} failed");
}
else
{
// File deleted successfully
Console.WriteLine($"Delete file :{data.Url} was successfully");
}
});
}
if (!string.IsNullOrEmpty(data.Url100))
{
var url100Deleted = storage.GetReferenceFromUrl(data.Url100);
url100Deleted.Delete((error) =>
{
if (error != null)
{
// Uh-oh, an error occurred!
Console.WriteLine($"Delete file :{data.Url100} failed");
}
else
{
// File deleted successfully
Console.WriteLine($"Delete file :{data.Url100} was successfully");
}
});
}
if (!string.IsNullOrEmpty(data.UrlEnd))
{
var urlEndDeleted = storage.GetReferenceFromUrl(data.UrlEnd);
urlEndDeleted.Delete((error) =>
{
if (error != null)
{
// Uh-oh, an error occurred!
Console.WriteLine($"Delete file :{data.UrlEnd} failed");
}
else
{
// File deleted successfully
Console.WriteLine($"Delete file :{data.UrlEnd} was successfully");
}
});
}
var rootNode = Firebase.Database.Database.DefaultInstance.GetRootReference();
rootNode.GetChild("station").GetChild(stationKey)
.GetChild("flights").GetChild(data.Key).RemoveValue((error, reference) =>
{
if (error != null)
{
//do something
Console.WriteLine($"Delete flight with key:{data.Key} failed");
}
else
{
Console.WriteLine($"Delete flight with key:{data.Key} was successfully");
}
});
}
