public async Task <List <ShipLocationHistoryResult> > GetRawGeolocationsForShip(ShipToken ship)
{
var sw = System.Diagnostics.Stopwatch.StartNew();
var connection = new SQLite.Net.SQLiteConnection(
TinyIoC.TinyIoCContainer.Current.Resolve <ISQLitePlatform>(),
TinyIoC.TinyIoCContainer.Current.Resolve <IFolderProvider>().MapDatabasePath);
List <ShipLocationHistoryResult> mainShipLocationResults = new List <ShipLocationHistoryResult> ();
var query = connection.Table <shipLocationDate>().Where(r => r.shipID == ship.ID && r.shiplocationdatetype == "log"); //.OrderBy (r => r.startdate);
int locationIndex = 1;
foreach (var shipLocation in query)
{
var possibleLocation = connection.Table <locationJSON> ().Where(l => l.name == shipLocation.locationname).FirstOrDefault();
if (possibleLocation == null)
{
//We purposely skip some locations when processing. May want to re-think that!
continue;
}
DateTime startDate;
DateTime endDate;
var hasStartDate = string.IsNullOrEmpty(shipLocation.startdate) ? false : DateTime.TryParse(shipLocation.startdate, out startDate);
var hasEndDate = string.IsNullOrEmpty(shipLocation.enddate) ? false : DateTime.TryParse(shipLocation.enddate, out endDate);
mainShipLocationResults.Add(new ShipLocationHistoryResult()
{
Location = shipLocation.locationname,
PossibleEndDate = hasStartDate ? startDate : default(DateTime),
PossibleStartDate = hasEndDate ? endDate : default(DateTime),
ShipToken = ship,
LocationIndex = locationIndex++,
LocationGeocodeResult = possibleLocation != null ? JsonConvert.DeserializeObject <GeocodeResultMain> (possibleLocation.geocodeJSON) : null,
LocationGuid = shipLocation.locationguid
});
/*foreach (var location in locations) {
* List<GeocodeResultMain> results = new List<GeocodeResultMain> ();
* var query = connection.Table<locationJSON> ().Where (l => l.name == location);
* foreach (var locationJSONEntry in query) {
* mainGeocodeResults.Add(JsonConvert.DeserializeObject<GeocodeResultMain>(locationJSONEntry.geocodeJSON));
* }*/
}
sw.Stop();
System.Diagnostics.Debug.WriteLine($"Total geolocation query time: {sw.ElapsedMilliseconds} ms");
return(mainShipLocationResults);
}
public DatabaseContext()
{
var storage = ServiceLocator.Current.GetInstance<ISettings>().GetValue<bool>(ParamsLocalEnum.DbRoaming.ToString()) ? Windows.Storage.ApplicationData.Current.RoamingFolder : Windows.Storage.ApplicationData.Current.LocalFolder;
var path = Path.Combine(storage.Path, ServiceLocator.Current.GetInstance<ISettings>().GetValue<string>(ParamsLocalEnum.DbName.ToString()));
Context = new SQLite.Net.SQLiteConnection(new SQLitePlatformWinRT(), path);
}
protected override void OnCreate (Bundle bundle)
{
base.OnCreate (bundle);
Xamarin.Forms.Forms.Init (this, bundle);
var sqliteFilename = "TodoSQLite.db3";
string documentsPath = System.Environment.GetFolderPath (System.Environment.SpecialFolder.Personal); // Documents folder
var path = Path.Combine(documentsPath, sqliteFilename);
// This is where we copy in the prepopulated database
Console.WriteLine (path);
if (!File.Exists(path))
{
var s = Resources.OpenRawResource(Resource.Raw.TodoSQLite); // RESOURCE NAME ###
// create a write stream
FileStream writeStream = new FileStream(path, FileMode.OpenOrCreate, FileAccess.Write);
// write to the stream
ReadWriteStream(s, writeStream);
}
var plat = new SQLite.Net.Platform.XamarinAndroid.SQLitePlatformAndroid();
var conn = new SQLite.Net.SQLiteConnection(plat, path);
var a = new App ();
// Set the database connection string
App.SetDatabaseConnection (conn);
App.SetTextToSpeech (new Speech ());
LoadApplication (a);
}
public SQLite.Net.SQLiteConnection GetConnection()
{
var sqliteFilename = "quinieleros.db3";
string documentsPath = System.Environment.GetFolderPath(System.Environment.SpecialFolder.Personal); // Documents folder
var path = Path.Combine(documentsPath, sqliteFilename);
// This is where we copy in the prepopulated database
Console.WriteLine(path);
if (!File.Exists(path))
{
/*var s = Forms.Context.Resources.OpenRawResource(Resource.Raw.totalSQLite); // RESOURCE NAME ###*/
// create a write stream
/*using (StreamReader sr = new StreamReader (Resource.Raw.totalSQLite)) {
FileStream writeStream = new FileStream (path, FileMode.OpenOrCreate, FileAccess.Write);
// write to the stream
ReadWriteStream (sr, writeStream);
}*/
}
var plat = new SQLite.Net.Platform.XamarinAndroid.SQLitePlatformAndroid();
var conn = new SQLite.Net.SQLiteConnection(plat, path);
// Return the database connection
return conn;
}
public static void Startup()
{
#if __MOBILE__
SQLite.Net.SQLiteConnection connection = null;
SQLite.Net.Interop.ISQLitePlatform platform = null;
string dbLocation = "videoDB.db3";
#endif
#if XAMARIN_ANDROID
var library = Environment.GetFolderPath(Environment.SpecialFolder.Personal);
dbLocation = Path.Combine(library, dbLocation);
platform = new SQLite.Net.Platform.XamarinAndroid.SQLitePlatformAndroid();
#elif XAMARIN_IOS
var docsPath = Environment.GetFolderPath(Environment.SpecialFolder.Personal);
var library = Path.Combine(docsPath, "../Library/");
dbLocation = Path.Combine(library, dbLocation);
platform = new SQLite.Net.Platform.XamarinIOS.SQLitePlatformIOS();
#elif WINDOWS_PHONE
platform = new SQLite.Net.Platform.WindowsPhone8.SQLitePlatformWP8();
#elif NETFX_CORE
platform = new SQLite.Net.Platform.WinRT.SQLitePlatformWinRT();
#endif
ServiceContainer.Register<IMovieService>(() => new MovieService());
#if __MOBILE__
connection = new SQLite.Net.SQLiteConnection(platform, dbLocation);
ServiceContainer.Register<IStorageService>(() => new StorageService(connection));
ServiceContainer.Register<IMessageDialog>(() => new Video.PlatformSpecific.MessageDialog());
#endif
ServiceContainer.Register<MoviesViewModel>();
ServiceContainer.Register<MovieViewModel>();
}
public AcessoDados()
{
var config = DependencyService.Get<iConfig> ();
_conexao = new SQLite.Net.SQLiteConnection (config.Plataforma, System.IO.Path.Combine (config.DiretorioDB, "bancodados.db3"));
_conexao.CreateTable<User> ();
}
public int save()
{
var path = Path.Combine(Windows.Storage.ApplicationData.Current.LocalFolder.Path, "db.sqlite");
using (SQLite.Net.SQLiteConnection conn = new SQLite.Net.SQLiteConnection(new SQLite.Net.Platform.WinRT.SQLitePlatformWinRT(), path))
{
var infoTable = conn.GetTableInfo("User");
if (!infoTable.Any())
{
// conn.DropTable<User>();
conn.CreateTable<User>();
}
var info = conn.GetMapping(typeof(User));
if (this._user.UserID == 0)
{
//var i = conn.InsertOrReplace(this._user);
var i = conn.Insert(this._user);
conn.Commit();
// this._user.UserID = i;
return i;
}
else
{
var i = conn.Update(this._user);
return i;
}
}
}
protected override void OnCreate(Bundle bundle)
{
base.OnCreate (bundle);
SpeakingActivityContext = this; // HACK: for SpeakButtonRenderer to get an Activity/Context reference
Xamarin.Forms.Forms.Init (this, bundle);
var sqliteFilename = "TodoSQLite.db3";
string documentsPath = System.Environment.GetFolderPath (System.Environment.SpecialFolder.Personal); // Documents folder
var path = Path.Combine(documentsPath, sqliteFilename);
// This is where we copy in the prepopulated database
Console.WriteLine (path);
if (!File.Exists(path))
{
var s = Resources.OpenRawResource(Resource.Raw.TodoSQLite); // RESOURCE NAME ###
// create a write stream
FileStream writeStream = new FileStream(path, FileMode.OpenOrCreate, FileAccess.Write);
// write to the stream
ReadWriteStream(s, writeStream);
}
var plat = new SQLite.Net.Platform.XamarinAndroid.SQLitePlatformAndroid();
var conn = new SQLite.Net.SQLiteConnection(plat, path);
// Set the database connection string
App.SetDatabaseConnection (conn);
SetPage (App.GetMainPage ());
}
public override bool FinishedLaunching (UIApplication app, NSDictionary options)
{
// create a new window instance based on the screen size
window = new UIWindow (UIScreen.MainScreen.Bounds);
var sqliteFilename = "TodoSQLite.db3";
string documentsPath = Environment.GetFolderPath (Environment.SpecialFolder.Personal); // Documents folder
string libraryPath = Path.Combine (documentsPath, "..", "Library"); // Library folder
var path = Path.Combine(libraryPath, sqliteFilename);
// This is where we copy in the prepopulated database
Console.WriteLine (path);
if (!File.Exists (path)) {
File.Copy (sqliteFilename, path);
}
var plat = new SQLite.Net.Platform.XamarinIOS.SQLitePlatformIOS();
var conn = new SQLite.Net.SQLiteConnection(plat, path);
// Set the database connection string
App.SetDatabaseConnection (conn);
// window.RootViewController = new HybridRazorViewController ();
window.RootViewController = new UINavigationController(new NativeListViewController ());
// make the window visible
window.MakeKeyAndVisible ();
return true;
}
public CardViewModel()
{
try
{
currentModel = new CardCurrent();
firstStart = true;
previousCardModified = false;
goingBack = false;
goingBackNumberOfCards = 1;
imageNumber = 0;
id = 0;
//There was a problem with database initialization
using (SQLite.Net.SQLiteConnection db = new SQLite.Net.SQLiteConnection(new SQLite.Net.Platform.WinRT.SQLitePlatformWinRT(), App.path))
{
verbs = db.Table<Verbs>().ToList();
adjectives = db.Table<Adjectives>().ToList();
nouns = db.Table<Nouns>().ToList();
images = db.Table<Images>().ToList();
if (verbs.Count == 0 || adjectives.Count == 0 || nouns.Count == 0 || images.Count == 0)
{
Debug.WriteLine("Database not initialized");
App app = new App();
app.Initialize();
}
}
}
catch (Exception e)
{
Debug.WriteLine(e.Message);
Debug.WriteLine(e.StackTrace);
}
}
public void init()
{
var config = DependencyService.Get <IConfig>();
_conexao = new SQLite.Net.SQLiteConnection(config.Plataforma,
System.IO.Path.Combine(config.Diretorio, "banco1.db3"));
CreateAllTables();
}
// Retrieve the specific contact from the database.
public User ReadUser(string username, string password)
{
using (SQLite.Net.SQLiteConnection conn = new SQLite.Net.SQLiteConnection(new SQLite.Net.Platform.WinRT.SQLitePlatformWinRT(), App.DB_PATH))
{
var existingUser = conn.Query <User>("SELECT * FROM User WHERE Username = '******' AND Password = '******'").FirstOrDefault();
return(existingUser);
}
}
// Retrieve the specific contact from the database.
public Post GetPost(int post_id)
{
using (SQLite.Net.SQLiteConnection conn = new SQLite.Net.SQLiteConnection(new SQLite.Net.Platform.WinRT.SQLitePlatformWinRT(), App.DB_PATH))
{
var existingPost = (conn.Table <Post>().Where(c => c.Post_id == post_id)).Single();
return(existingPost);
}
}
public LedgerAccount()
{
this.InitializeComponent();
conn = new Connection().GetConnection();
viewModel = new AccountViewModel();
ledgers = viewModel.AccountLedgerList();
LoadListView();
}
public ViewModelBase()
{
var config = DependencyService.Get <IConfig>();
_conexao = new SQLite.Net.SQLiteConnection(config.Plataforma, System.IO.Path.Combine(config.DiretorioDB, "bancodados3.db3"));
_conexao.CreateTable <ProdutoCompra>();
_conexao.CreateTable <SettingsModel>();
}
public AcessoDados()
{
var config = DependencyService.Get <IConfig>();
_conexao = new SQLite.Net.SQLiteConnection(config.Plataforma, System.IO.Path.Combine(config.DiretorioDB, "bancodados2.db3"));
_conexao.CreateTable <ProdutoCompra>();
}
public SQLiteController()
{
//Create db and tables if they do not exist
path = Path.Combine(Windows.Storage.ApplicationData.Current.LocalFolder.Path, "db.sqlite");
conn = new SQLite.Net.SQLiteConnection(new SQLite.Net.Platform.WinRT.SQLitePlatformWinRT(), path);
conn.CreateTable <User>();
conn.CreateTable <Score>();
}
public MainPage()
{
this.InitializeComponent();
MyFrame.Navigate(typeof(HomeFrame));
HomeListBoxItem.IsSelected = true;
conn = new Connection().GetConnection();
}
public SQLite.Net.SQLiteConnection GetConnection(string filename)
{
string path = Path.Combine(ApplicationData.Current.LocalFolder.Path, filename);
var plat = new SQLite.Net.Platform.WindowsPhone8.SQLitePlatformWP8();
var conn = new SQLite.Net.SQLiteConnection(plat, path);
return(conn);
}
public TodayList()
{
this.InitializeComponent();
path = Path.Combine(Windows.Storage.ApplicationData.Current.LocalFolder.Path, "db.sqlite");
conn = new SQLite.Net.SQLiteConnection(new SQLite.Net.Platform.WinRT.SQLitePlatformWinRT(), path);
conn.CreateTable <Category>();
loadListView();
}
public AcessoDadosAmigos()
{
var config = DependencyService.Get <IConfig>(); //utiliza dependency para verificar qual plataforma esta sendo utilizada
_conexao = new SQLite.Net.SQLiteConnection(config.Plataforma, System.IO.Path.Combine(config.DiretorioDB, "bancodados.db3"));
_conexao.CreateTable <Amigos>();
}
public sign_up()
{
this.InitializeComponent();
this.NavigationCacheMode = Windows.UI.Xaml.Navigation.NavigationCacheMode.Enabled;
path = Path.Combine(Windows.Storage.ApplicationData.Current.LocalFolder.Path, "db.sqlite");
conn = new SQLite.Net.SQLiteConnection(new SQLite.Net.Platform.WinRT.SQLitePlatformWinRT(), path);
conn.CreateTable <irfan>();
}
public DataBaseAccess()
{
using (SQLite.Net.SQLiteConnection conn = new SQLite.Net.SQLiteConnection(new SQLite.Net.Platform.WinRT.SQLitePlatformWinRT(), path))
{
var hasCreated = conn.CreateTable <Registre>();
var query = conn.Table <Registre>();
}
}
public AllOrdersDetails()
{
this.InitializeComponent();
path = Path.Combine(Windows.Storage.ApplicationData.Current.LocalFolder.Path, "db.sqlite");
conn = new SQLite.Net.SQLiteConnection(new SQLite.Net.Platform.WinRT.SQLitePlatformWinRT(), path);
LoadDetails();
}
public EditUser()
{
this.InitializeComponent();
path = Path.Combine(Windows.Storage.ApplicationData.Current.LocalFolder.Path, "db.sqlite");
conn = new SQLite.Net.SQLiteConnection(new SQLite.Net.Platform.WinRT.SQLitePlatformWinRT(), path);
userName = UserManager.getUserName();
UserComboBox.ItemsSource = userName;
}
public EditCategory()
{
this.InitializeComponent();
categoryList = CategoryManager.comboCategory();
CategoryComboBox.ItemsSource = categoryList;
path = Path.Combine(Windows.Storage.ApplicationData.Current.LocalFolder.Path, "db.sqlite");
conn = new SQLite.Net.SQLiteConnection(new SQLite.Net.Platform.WinRT.SQLitePlatformWinRT(), path);
}
public ViewModelBase()
{
var config = DependencyService.Get <IConfig>();
_conexao = new SQLite.Net.SQLiteConnection(config.Plataforma, System.IO.Path.Combine(config.DiretorioDB, "bancodados1.db3"));
_conexao.CreateTable <Entidade>();
_conexao.CreateTable <Estabelecimento>();
_conexao.CreateTable <ePortaria.Model.Controle>();
}
public async void ThirdCase()
{
var path =await DataLoggerService.CreateDatabase("db.dat");
var connection = new SQLite.Net.SQLiteConnection(new SQLitePlatformWinRT(), path);
}
public SQLite.Net.SQLiteConnection GetConnection ()
{
string documentsPath = System.Environment.GetFolderPath (System.Environment.SpecialFolder.Personal);
var path = Path.Combine(documentsPath, sqliteFilename);
var plat = new SQLite.Net.Platform.XamarinAndroid.SQLitePlatformAndroid();
var conn = new SQLite.Net.SQLiteConnection(plat, path);
return conn;
}
public void AddRegister(Registre registre)
{
using (SQLite.Net.SQLiteConnection conn = new SQLite.Net.SQLiteConnection(new SQLite.Net.Platform.WinRT.SQLitePlatformWinRT(), path))
{
conn.Insert(new Registre {
RegistreDate = registre.RegistreDate
});
}
}
// Insert the new contact in the Contacts table.
public UniqueExpenseItem GetUniqueExpense(int _ItemID)
{
using (SQLite.Net.SQLiteConnection conn = new SQLite.Net.SQLiteConnection(new SQLite.Net.Platform.WinRT.SQLitePlatformWinRT(), App.DB_PATH))
{
UniqueExpenseItem regularItem = conn.Table <UniqueExpenseItem>().Where((v) => (v.Id == _ItemID)).FirstOrDefault();
return(regularItem);
}
}
public static ObservableCollection <SentinelsDataset> getNobOgrList(String filter = null)
{
string path = Settings.FullPathSQLite;
//\\192.168.18.182\C$\Data\Users\DefaultAccount\AppData\Local\Packages\06fb6d66-31b3-4beb-893c-2e0d9fe465f1_3asabdzxmrwg6\LocalState\Project1\settings.sqlite
var conn = new SQLite.Net.SQLiteConnection(new SQLite.Net.Platform.WinRT.SQLitePlatformWinRT(), path);
NobOgrList.Clear();
if (filter == null)
{
//List<Sentinels> rows = conn.Table<Sentinels>().ToList();
//var rows = conn.Query<Sentinels>("select *,(case NobetGunu WHEN 'PAZARTESİ' then 0 WHEN 'SALI' then 1 WHEN 'ÇARŞAMBA' then 2 WHEN 'PERŞEMBE' then 3 WHEN 'CUMA' then 4 END) as workdayno from Sentinels order by workdayno").ToList();
var Sentinels = conn.Query <SentinelsDataset>("select * from SentinelsDataset");
var rows = (from e in Sentinels
select new SentinelsDataset()
{
id = e.id,
SentinelFullName = e.SentinelFullName,
SentryLocation = e.SentryLocation,
SentryDate = e.SentryDate,
DayNO = (DayEnum)Enum.Parse(typeof(DayEnum), e.SentryDate)
}).OrderBy(e => e.DayNO);
// rows.ForEach(x => { NobOgrList.Add(x); });
foreach (var x in rows)
{
NobOgrList.Add(x);
}
}
else
{
string flt = $"%{filter}%";
var Sentinels = conn.Query <SentinelsDataset>("select * from SentinelsDataset where SentryLocation LIKE ? OR SentinelFullName LIKE ? OR SentryDate LIKE ?", flt, flt, flt).ToList();
var rows = (from e in Sentinels
select new SentinelsDataset()
{
id = e.id,
SentinelFullName = e.SentinelFullName,
SentryLocation = e.SentryLocation,
SentryDate = e.SentryDate,
DayNO = (DayEnum)Enum.Parse(typeof(DayEnum), e.SentryDate)
}).OrderBy(e => e.DayNO);
// rows.ForEach(x => { NobOgrList.Add(x); });
foreach (var x in rows)
{
NobOgrList.Add(x);
}
}
return(NobOgrList);
}
public Day(DateTime date)
{
Database = new SQLite.Net.SQLiteConnection(new SQLite.Net.Platform.WinRT.SQLitePlatformWinRT(), path);
this.date_time = date;
this.InfoByDay = GetWorkerListing();
this.ListOfAvailableService = GetServiceListing();
this.ListOfAvailableSchedule = GetScheduleListing();
OpenContentDialogBox = new RelayCommand(OpenContentDialogBoxExecute);
}
public SQLite.Net.SQLiteConnection GetConnection()
{
var filename = "Notes.db";
var path = Path.Combine(ApplicationData.Current.LocalFolder.Path, filename);
var platfrom = new SQLite.Net.Platform.WindowsPhone8.SQLitePlatformWP8();
var connection = new SQLite.Net.SQLiteConnection(platfrom, path);
return connection;
}
public SQLite.Net.SQLiteConnection GetConnection(string filename)
{
string documentsPath = System.Environment.GetFolderPath(System.Environment.SpecialFolder.Personal);
var path = Path.Combine(documentsPath, filename);
var plat = new SQLite.Net.Platform.XamarinIOS.SQLitePlatformIOS();
var conn = new SQLite.Net.SQLiteConnection(plat, path);
return(conn);
}
public SQLite.Net.SQLiteConnection GetConnection()
{
var path = DependencyService.Get <IDatabase> ().Path;
var plat = new SQLite.Net.Platform.XamarinAndroid.SQLitePlatformAndroid();
var conn = new SQLite.Net.SQLiteConnection(plat, path);
return(conn);
}
public DriverActivitiesPage()
{
this.InitializeComponent();
db = new Database();
path = Path.Combine(Windows.Storage.ApplicationData.Current.LocalFolder.Path, "MyDataBase.sqlite");
conn = new SQLite.Net.SQLiteConnection(new SQLite.Net.Platform.WinRT.SQLitePlatformWinRT(), path);
Debug.WriteLine(dristr);
}
private static ObservableCollection <Deputado> ListarDeputadosPorEstadoBanco(string uf)
{
using (SQLite.Net.SQLiteConnection conexao = new SQLite.Net.SQLiteConnection(new SQLite.Net.Platform.WinRT.SQLitePlatformWinRT(), App.DB_PATH))
{
var deputados = conexao.Query <Deputado>("select * from deputado where Uf = " + "\"" + uf + "\"").ToList <Deputado>();
ObservableCollection <Deputado> ListaDeputados = new ObservableCollection <Deputado>(deputados);
return(ListaDeputados);
}
}
public SQLite.Net.SQLiteConnection GetConnection()
{
var sqliteFilename = "CoinJar.db3";
string path = Path.Combine(ApplicationData.Current.LocalFolder.Path, sqliteFilename);
// Create the connection
var conn = new SQLite.Net.SQLiteConnection(new SQLite.Net.Platform.WinRT.SQLitePlatformWinRT(), path);
// Return the database connection
return conn;
}
public AccountSubtypeAdd()
{
this.InitializeComponent();
conn = new Connection().GetConnection();
conn.CreateTable <AccountSubtype>();
viewModel = new AccountSubtypeViewModel();
id = -1;
PageLoad();
}
public MainPage()
{
this.InitializeComponent();
path = Path.Combine(Windows.Storage.ApplicationData.Current.LocalFolder.Path,
"db.sqlite");
conn = new SQLite.Net.SQLiteConnection(new
SQLite.Net.Platform.WinRT.SQLitePlatformWinRT(), path);
conn.CreateTable <Logindata>();
}
protected override void OnCreate(Bundle bundle)
{
base.OnCreate(bundle);
#region Database setup
var sqliteFilename = "TodoSQLite.db3";
string documentsPath = System.Environment.GetFolderPath(System.Environment.SpecialFolder.Personal); // Documents folder
var path = Path.Combine(documentsPath, sqliteFilename);
// This is where we copy in the prepopulated database
Console.WriteLine(path);
if (!File.Exists(path))
{
var s = Resources.OpenRawResource(RazorTodo.Resource.Raw.TodoSQLite); // RESOURCE NAME ###
// create a write stream
FileStream writeStream = new FileStream(path, FileMode.OpenOrCreate, FileAccess.Write);
// write to the stream
ReadWriteStream(s, writeStream);
}
var plat = new SQLite.Net.Platform.XamarinAndroid.SQLitePlatformAndroid();
var conn = new SQLite.Net.SQLiteConnection(plat, path);
// Set the database connection string
App.SetDatabaseConnection(conn);
#endregion
// Set our view from the "main" layout resource
SetContentView(Resource.Layout.Main);
var webView = FindViewById <WebView> (Resource.Id.webView);
webView.Settings.JavaScriptEnabled = true;
// Use subclassed WebViewClient to intercept hybrid native calls
webView.SetWebViewClient(new RazorWebViewClient(this));
// Render the view from the type generated from RazorView.cshtml
var model = App.Database.GetItems().ToList();
List <List <Data> > lista = model
.GroupBy(u => u.Group)
.Select(grp => grp.ToList())
.ToList();
var template = new TodoList()
{
Model = lista
};
var page = template.GenerateString();
// Load the rendered HTML into the view with a base URL
// that points to the root of the bundled Assets folder
webView.LoadDataWithBaseURL("file:///android_asset/", page, "text/html", "UTF-8", null);
}
/// <summary>
/// Initializes The GUI by adding all history from the SQLite db
/// </summary>
private void InitializeGUI()
{
var sqlpath = System.IO.Path.Combine(Windows.Storage.ApplicationData.Current.LocalFolder.Path, "GameHistoryDB.sqlite");
SQLite.Net.SQLiteConnection conn = new SQLite.Net.SQLiteConnection(new SQLite.Net.Platform.WinRT.SQLitePlatformWinRT(), sqlpath);
var games = from g in conn.Table<GameHistory>()
select g;
ListGameHistory.ItemsSource = games.ToList();
}
//Delete all contactlist or delete Contacts table
public void DeleteAllContact()
{
using (SQLite.Net.SQLiteConnection conn = new SQLite.Net.SQLiteConnection(new SQLite.Net.Platform.WinRT.SQLitePlatformWinRT(), App.DB_PATH))
{
conn.DropTable <Contacts>();
conn.CreateTable <Contacts>();
conn.Dispose();
conn.Close();
}
}
public SQLite.Net.SQLiteConnection GetConnection()
{
var filename = "Student.db3";
var documentspath = Environment.GetFolderPath(Environment.SpecialFolder.Personal);
var path = Path.Combine(documentspath, filename);
var platform = new SQLite.Net.Platform.XamarinAndroid.SQLitePlatformAndroid();
var connection = new SQLite.Net.SQLiteConnection(platform, path);
return connection;
}
public SQLite.Net.SQLiteConnection GetConnection()
{
var sqliteFilename = "TodoSQLite.db3";
string path = Path.Combine(ApplicationData.Current.LocalFolder.Path, sqliteFilename);
var plat = new SQLite.Net.Platform.WindowsPhone8.SQLitePlatformWP8();
var conn = new SQLite.Net.SQLiteConnection(plat, path);
// Return the database connection
return conn;
}
/// <summary>
/// Deletes a individual card in a pack
/// </summary>
/// <param name="pack">A packnumber where you want the card to be removed</param>
/// <param name="card">Cardnumber the be removed</param>
public void DeleteSavedCard(int pack, int card)
{
using (SQLite.Net.SQLiteConnection db = new SQLite.Net.SQLiteConnection(new SQLite.Net.Platform.WinRT.SQLitePlatformWinRT(), App.path))
{
IEnumerable<SavedCards> entityQuery = db.Table<SavedCards>().Where(x => x.PackNumber == pack && x.CardNumber == card); // from savedCards in context.SavedCardPacks where savedCards.packNumber == pack && savedCards.packCard == card select savedCards;
foreach (SavedCards savedCard in entityQuery)
{
db.Delete(savedCard);
}
}
}
/// <summary>
/// Deletes all cards in a pack
/// </summary>
/// <param name="pack">Pack which you want to remove</param>
public void DeleteSavedPack(int pack)
{
using (SQLite.Net.SQLiteConnection db = new SQLite.Net.SQLiteConnection(new SQLite.Net.Platform.WinRT.SQLitePlatformWinRT(), App.path))
{
IEnumerable<SavedCards> packQuery = db.Table<SavedCards>().Where(card => card.PackNumber == pack);
foreach (SavedCards savedCard in packQuery)
{
db.Delete(savedCard);
}
}
}
public SQLite.Net.SQLiteConnection GetConnection()
{
var sqliteFilename = "MyDataBase.db3";
string documentsPath = System.Environment.GetFolderPath (System.Environment.SpecialFolder.Personal); // Documents folder
var path = Path.Combine(documentsPath, sqliteFilename);
// Create the connection
var plat = new SQLite.Net.Platform.XamarinAndroid.SQLitePlatformAndroid();
var conn = new SQLite.Net.SQLiteConnection(plat, path);
// Return the database connection
return conn;
}
public SQLite.Net.SQLiteConnection GetConnection()
{
var fileName = "Actu.db3";
var documentsPath = Environment.GetFolderPath (Environment.SpecialFolder.Personal);
var libraryPath = Path.Combine (documentsPath, "..", "Library");
var path = Path.Combine (libraryPath, fileName);
var platform = new SQLite.Net.Platform.XamarinIOS.SQLitePlatformIOS ();
var connection = new SQLite.Net.SQLiteConnection (platform, path);
return connection;
}
public SQLite.Net.SQLiteConnection GetConnection()
{
// Create the connection
var plat = new SQLite.Net.Platform.XamarinIOS.SQLitePlatformIOS ();
var conn = new SQLite.Net.SQLiteConnection (plat, FilePath);
// Return the database connection
var d = conn.GetTableInfo ("Person");
var m = conn.Table<Person> ().Table;
return conn;
}
public static void SetupDatabase()
{
var sqliteFilename = "codemania.db3";
string documentsPath = Environment.GetFolderPath(Environment.SpecialFolder.Personal); // Documents folder
var path = Path.Combine(documentsPath, sqliteFilename);
var plat = new SQLite.Net.Platform.XamarinIOS.SQLitePlatformIOS();
var conn = new SQLite.Net.SQLiteConnection(plat, path, true);
Console.WriteLine(path);
App.SetSqlConnection(conn);
}
public static User getByUserID(int userID)
{
var path = Path.Combine(Windows.Storage.ApplicationData.Current.LocalFolder.Path, "db.sqlite");
User user = new User();
using (SQLite.Net.SQLiteConnection conn = new SQLite.Net.SQLiteConnection(new SQLite.Net.Platform.WinRT.SQLitePlatformWinRT(), path))
{
user = (from u in conn.Table<User>()
where u.UserID == userID
select u
).ToList().FirstOrDefault();
}
return user;
}
public static Day getByDayID(int dayID)
{
var path = Path.Combine(Windows.Storage.ApplicationData.Current.LocalFolder.Path, "db.sqlite");
Day day = new Day();
using (SQLite.Net.SQLiteConnection conn = new SQLite.Net.SQLiteConnection(new SQLite.Net.Platform.WinRT.SQLitePlatformWinRT(), path))
{
day = (from d in conn.Table<Day>()
where d.DayID == dayID
select d
).ToList().FirstOrDefault();
}
return day;
}
public SQLite.Net.SQLiteConnection GetConnection()
{
var sqliteFilename = "TodoSQLite.db3";
string documentsPath = Environment.GetFolderPath(Environment.SpecialFolder.Personal);
// Documents folder
string libraryPath = Path.Combine(documentsPath, "..", "Library");
// Library folder
var path = Path.Combine(libraryPath, sqliteFilename);
// Create the connection
var plat = new SQLite.Net.Platform.XamarinIOS.SQLitePlatformIOS();
var conn = new SQLite.Net.SQLiteConnection(plat, path);
// Return the database connection
return conn;
}
/// <summary>
/// Reorders saved cards pivot page cards after delete.
/// </summary>
/// <param name="pack">The pack number where a card was removed</param>
/// <param name="cardPosition">Position number of the card where card was removed</param>
public void ReOrderSavedCards(int pack, int cardPosition)
{
int newCardPosition = cardPosition;
using (SQLite.Net.SQLiteConnection db = new SQLite.Net.SQLiteConnection(new SQLite.Net.Platform.WinRT.SQLitePlatformWinRT(), App.path))
{
IEnumerable<SavedCards> reOrderQuery = db.Table<SavedCards>()
.Where(card => card.PackNumber == pack && card.CardNumber > cardPosition);
foreach (SavedCards savedCard in reOrderQuery)
{
savedCard.CardNumber = newCardPosition;
db.Update(savedCard);
newCardPosition++;
}
}
}
public static List<Eat> getAll()
{
List<Eat> lm = new List<Eat> { };
var path = Path.Combine(Windows.Storage.ApplicationData.Current.LocalFolder.Path, "db.sqlite");
using (SQLite.Net.SQLiteConnection conn = new SQLite.Net.SQLiteConnection(new SQLite.Net.Platform.WinRT.SQLitePlatformWinRT(), path))
{
lm = (from m in conn.Table<Eat>()
select m).ToList();
}
return lm;
}
public SQLite.Net.SQLiteConnection GetConnection()
{
var sqliteFilename = "BetDatabase.db3";
string documentsPath = Environment.GetFolderPath (Environment.SpecialFolder.Personal);
string libraryPath = Path.Combine (documentsPath, "..", "Library");
var path = Path.Combine (libraryPath, sqliteFilename);
/* if (!File.Exists (path)) {
File.Copy (sqliteFilename, path);
} */
var plat = new SQLite.Net.Platform.XamarinIOS.SQLitePlatformIOS();
var conn = new SQLite.Net.SQLiteConnection (plat, path);
return conn;
}
protected override void OnCreate (Bundle bundle)
{
base.OnCreate (bundle);
#region Database setup
var sqliteFilename = "TodoSQLite.db3";
string documentsPath = System.Environment.GetFolderPath (System.Environment.SpecialFolder.Personal); // Documents folder
var path = Path.Combine(documentsPath, sqliteFilename);
// This is where we copy in the prepopulated database
Console.WriteLine (path);
if (!File.Exists(path))
{
var s = Resources.OpenRawResource(RazorTodo.Resource.Raw.TodoSQLite); // RESOURCE NAME ###
// create a write stream
FileStream writeStream = new FileStream(path, FileMode.OpenOrCreate, FileAccess.Write);
// write to the stream
ReadWriteStream(s, writeStream);
}
var plat = new SQLite.Net.Platform.XamarinAndroid.SQLitePlatformAndroid();
var conn = new SQLite.Net.SQLiteConnection(plat, path);
// Set the database connection string
App.SetDatabaseConnection (conn);
#endregion
// Set our view from the "main" layout resource
SetContentView (Resource.Layout.Main);
var webView = FindViewById<WebView> (Resource.Id.webView);
webView.Settings.JavaScriptEnabled = true;
// Use subclassed WebViewClient to intercept hybrid native calls
webView.SetWebViewClient (new RazorWebViewClient (this));
// Render the view from the type generated from RazorView.cshtml
var model = App.Database.GetItems ().ToList();
var template = new TodoList () { Model = model };
var page = template.GenerateString ();
// Load the rendered HTML into the view with a base URL
// that points to the root of the bundled Assets folder
webView.LoadDataWithBaseURL("file:///android_asset/", page, "text/html", "UTF-8", null);
}
public MainPage()
{
InitializeComponent();
Forms.Init();
var sqliteFilename = "TodoSQLite.db3";
string path = Path.Combine(ApplicationData.Current.LocalFolder.Path, sqliteFilename);
var plat = new SQLite.Net.Platform.WindowsPhone8.SQLitePlatformWP8();
var conn = new SQLite.Net.SQLiteConnection(plat, path);
// Set the database connection string
Todo.App.SetDatabaseConnection(conn);
Content = Todo.App.GetMainPage().ConvertPageToUIElement(this);
}
