//step 6 public override void OnCreate(SQLiteDatabase db) { db.ExecSQL(CreateRegistrationTableQuery); db.ExecSQL(CreateFavouritesTableQuery); }
public override void OnUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) { db.ExecSQL("DROP TABLE IF EXISTS history"); OnCreate(db); }
public override void OnCreate(SQLiteDatabase db) { db.ExecSQL(MapMarkerContract.SQL_CREATE_MARKERTABLE); }
public override void OnCreate(SQLiteDatabase db) { System.Console.WriteLine("My Create Table STM \n \n" + admin_creatTable); db.ExecSQL(admin_creatTable); db.ExecSQL(sales_person_creatTable); db.ExecSQL(category_creatTable); db.ExecSQL(product_creatTable); db.ExecSQL(vendor_creatTable); db.ExecSQL(purchase_creatTable); db.ExecSQL(customer_creatTable); db.ExecSQL(fav_creatTable); db.ExecSQL(product_purchase_creatTable); db.ExecSQL(order_creatTable); db.ExecSQL(product_order_creatTable); //insertAdmin("admin","abc"); string insertStm = "Insert into " + admin_tablename + " values('admin', 'abc');"; Console.WriteLine(insertStm); db.ExecSQL(insertStm); }
// Default function to create the database. public override void OnCreate(SQLiteDatabase db) { db.ExecSQL(CreateQuery); db.ExecSQL(Createscore); }
public override void OnCreate(SQLiteDatabase db) { db.ExecSQL("CREATE TABLE " + Table + " (Id TEXT PRIMARY KEY, Nombre TEXT, PrecioC DECIMAL(5,2), " + " PrecioV DECIMAL(5,2), Fecha TEXT, Categoria TEXT )"); }
public override void onCreate(SQLiteDatabase db) { mDatabase = db; mDatabase.ExecSQL(FTS_TABLE_CREATE); loadDictionary(); }
public override void OnUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) { db.ExecSQL(Constants.DROP_TB); OnCreate(db); }
private void subirNotificacionAceptada() { List <int> listaCodigoNotificacion = new List <int>(); List <string> listaCodigoNotificador = new List <string>(); //List<string> motivo = new List<string>(); List <string> listaCodigoReferencia = new List <string>(); if (coneccionInternet.verificaConeccion(ApplicationContext)) { Log.Debug(TAG, "Revisando si existen notificaciones con estado PendienteDeDistribucion at {0}.", DateTime.UtcNow); db = SQLiteDatabase.OpenDatabase(dbPath, null, DatabaseOpenFlags.OpenReadwrite); string consulta = ""; // Se guardan los diferentes codigos de notificadores con estado notificandose pendiente de subir consulta = "Select CodNotificador from Notificaciones WHERE PendienteSubir='S' AND Estado='PendienteDeDistribucion'"; ICursor cursor = db.RawQuery(consulta, null); if (cursor.MoveToFirst()) { do { listaCodigoNotificador.Add(cursor.GetString(0)); }while (cursor.MoveToNext()); } cursor.Close(); db.Close(); if (listaCodigoNotificador.Count > 0) { consulta = ""; foreach (var codigoNotificador in listaCodigoNotificador) { //tengo por notificador la lista de notificaciones en estado ResultadoEnCorreccion db = SQLiteDatabase.OpenDatabase(dbPath, null, DatabaseOpenFlags.OpenReadwrite); consulta = "Select CodigoNotificacion,CodReferencia from Notificaciones WHERE PendienteSubir='S' AND Estado='PendienteDeDistribucion' AND CodNotificador='" + codigoNotificador + "'"; cursor = db.RawQuery(consulta, null); if (cursor.MoveToFirst()) { Log.Debug(TAG, "Subiendo notificacion ACEPTADA at {0}.", DateTime.UtcNow); do { //agrego los diferentes codigos de notificaciones pendientes de subir para un notificador en especifico listaCodigoNotificacion.Add(Convert.ToInt32(cursor.GetString(0))); //motivo.Add(cursor.GetString(1)); listaCodigoReferencia.Add(cursor.GetString(1)); }while (cursor.MoveToNext()); } cursor.Close(); db.Close(); // int counter = 0; //Por cada codigo de notificacion creo un webRequest con su respectivo cuerpo de Json foreach (var codigoNotificacion in listaCodigoNotificacion) { try { AprobarActa aprobarActa = new AprobarActa() { Notificaciones = new List <ClassNotificaciones>() { new ClassNotificaciones() { CodNotificacion = codigoNotificacion, CodReferencia = Convert.ToInt32(listaCodigoReferencia[counter]), } } }; string request = @"https://pjgestionnotificacionmovilservicios.azurewebsites.net/api/ActaNotificacion/AprobarActasNotificacion"; string json = Newtonsoft.Json.JsonConvert.SerializeObject(aprobarActa); Console.WriteLine("Json: " + json); var httpWebRequest = (HttpWebRequest)WebRequest.Create(request); httpWebRequest.ContentType = "application/json"; httpWebRequest.Method = "POST"; using (var streamWriter = new StreamWriter(httpWebRequest.GetRequestStream())) { streamWriter.Write(json); streamWriter.Flush(); streamWriter.Close(); } var httpResponse = (HttpWebResponse)httpWebRequest.GetResponse(); using (var streamReader = new StreamReader(httpResponse.GetResponseStream())) { var result = streamReader.ReadToEnd(); Console.WriteLine("RESULTADO POST: " + result); if (result.Equals("true", StringComparison.Ordinal) || result.Equals("True", StringComparison.Ordinal)) { db = SQLiteDatabase.OpenDatabase(dbPath, null, DatabaseOpenFlags.OpenReadwrite); db.ExecSQL(@"UPDATE Notificaciones SET PendienteSubir='N' WHERE CodigoNotificacion=" + codigoNotificacion + " "); db.Close(); } } counter = counter + 1; } catch (Exception ex) { Console.WriteLine("Error subiendo datos para ResultadoEnCorreccion: " + ex.ToString()); } } listaCodigoNotificacion.Clear(); listaCodigoReferencia.Clear(); } } } }
public override void OnUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) { db.ExecSQL("DROP TABLE IF EXIST" + TableName); this.OnCreate(db); }
//========================SQLiteOpenHelper====================// public override void OnCreate(SQLiteDatabase db) { db.ExecSQL(SQL_CREATE_TABLE_IMAGES_INFO); db.ExecSQL(SQL_CREATE_TABLE_IMAGES_COORDINATES); db.ExecSQL(SQL_CREATE_TABLE_COMMENTS); }
public override void OnCreate(SQLiteDatabase db) { db.ExecSQL(tableCreate); db.ExecSQL(tableCreate1); }
public override void OnUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) { db.ExecSQL("DROP TABLE IF EXISTS " + TaskContract.TaskEntry.TABLE_NAME); OnCreate(db); }
public override void OnUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) { db.ExecSQL(MapMarkerContract.SQL_CREATE_MARKERTABLE); }
//step 7 public override void OnUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) { db.ExecSQL(DeleteQuery); db.ExecSQL(FavoritesDeleteQuery); }
protected override void OnCreate(Bundle bundle) { base.OnCreate(bundle); RequestWindowFeature(WindowFeatures.NoTitle); SetContentView(Resource.Layout.LayoutConfiguracaoSistema); SetResult(Result.Canceled); //==========================================================// // CRIAR BANCO DE DADOS // //==========================================================// mdTemp = new BancoDados("PRINCIPAL"); mdTemp.CreateDatabases("PRINCIPAL"); //==========================================================// var toolbar = FindViewById <Toolbar>(Resource.Id.toolbar); SetSupportActionBar(toolbar); SupportActionBar.Title = "CONFIGURAÇÃO SISTEMA"; SupportActionBar.SetDisplayHomeAsUpEnabled(true); SupportActionBar.SetHomeButtonEnabled(true); var relogioDigital = FindViewById <DigitalClock>(Resource.Id.digitalClock1); relogioDigital.Visibility = Android.Views.ViewStates.Visible; Validacoes.NrSegundosPeso = 1; Android.Support.V7.Widget.AppCompatImageButton BtnSair = FindViewById <Android.Support.V7.Widget.AppCompatImageButton>(Resource.Id.BtnSairComunicacao); Android.Support.V7.Widget.AppCompatImageButton BtnSalvar = FindViewById <Android.Support.V7.Widget.AppCompatImageButton>(Resource.Id.BtnSalvarComunicacao); Android.Support.V7.Widget.AppCompatButton BtnliberaCalibracao = FindViewById <Android.Support.V7.Widget.AppCompatButton>(Resource.Id.btnLiberarCalibracao); BtnliberaCalibracao.Click += (sender, e) => { StartActivity(typeof(ActSenhaCalibracao)); // Finish(); }; spinner = FindViewById <Spinner>(Resource.Id.spinnernrplataformas); selecao = new string[10]; selecao[0] = "01"; selecao[1] = "02"; selecao[2] = "03"; selecao[3] = "04"; selecao[4] = "05"; selecao[5] = "06"; selecao[6] = "07"; selecao[7] = "08"; selecao[8] = "09"; selecao[9] = "10"; adapter = new ArrayAdapter(this, Android.Resource.Layout.SimpleSpinnerDropDownItem, selecao); spinner.Adapter = adapter; //================================================================================// // VALOR CADASTRADOS // //================================================================================// string sLocation = System.Environment.GetFolderPath(System.Environment.SpecialFolder.Personal); string sDB = Path.Combine(sLocation, "PRINCIPAL"); sqldTemp = SQLiteDatabase.OpenOrCreateDatabase(sDB, null); bool bIsExists = File.Exists(sDB); string sSQLQuery = ""; Android.Database.ICursor icursorTemp = null; sSQLQuery = "SELECT NR_SEGUNDOS_PESO " + " FROM CONFIGURACAO_SISTEMA WHERE _id=1"; icursorTemp = sqldTemp.RawQuery(sSQLQuery, null); int ValorCursor = icursorTemp.Count; int nrParcelas = 0; if (ValorCursor > 0) { icursorTemp.MoveToNext(); string TotalSegundos = icursorTemp.GetString(0); Validacoes.NrSegundosPeso = int.Parse(TotalSegundos); } Window.SetSoftInputMode(SoftInput.StateHidden); //==============================================// // BLUETOOTH // //==============================================// if (Validacoes.NrSegundosPeso > 0) { spinner.SetSelection(Validacoes.NrSegundosPeso); } spinner.ItemSelected += (s, e) => { firstItem = spinner.SelectedItem.ToString(); if (firstItem.Equals(spinner.SelectedItem.ToString())) { Validacoes.NrSegundosPeso = int.Parse(spinner.SelectedItem.ToString()); } else { Toast.MakeText(this, "You have selected: " + e.Parent.GetItemIdAtPosition(e.Position).ToString(), ToastLength.Short).Show(); } }; // Register for broadcasts when a device is discovered BtnSair.Click += delegate { Finish(); }; BtnSalvar.Click += delegate { string DescricaoComunicao = ""; //==============================================================================================// // VERIFICA SE JÁ EXISTE UM ENDEREÇO GRAVADO // //==============================================================================================// sSQLQuery = ""; sSQLQuery = "SELECT NR_SEGUNDOS_PESO " + " FROM CONFIGURACAO_SISTEMA "; icursorTemp = sqldTemp.RawQuery(sSQLQuery, null); ValorCursor = icursorTemp.Count; string Data = System.DateTime.Today.ToShortDateString(); string Hora = System.DateTime.Today.ToShortTimeString(); if (ValorCursor == 0) { string Valores = int.Parse(spinner.SelectedItem.ToString()) - 1 + ",'" + Data + "','" + Hora + "'"; string Campos = "NR_SEGUNDOS_PESO," + "DATA_CADASTRO," + "HORA_CADASTRO"; sSQLQuery = "INSERT INTO " + "CONFIGURACAO_SISTEMA " + "(" + Campos + ") " + "VALUES(" + Valores + ");"; sqldTemp.ExecSQL(sSQLQuery); sMessage = "Record is saved."; Toast.MakeText(this, "REGISTRO GRAVADO COM SUCESSO", ToastLength.Long).Show(); } else { string ComandoSql = "update CONFIGURACAO_SISTEMA set " + $" NR_SEGUNDOS_PESO={int.Parse(spinner.SelectedItem.ToString()) - 1}," + $" DATA_CADASTRO='{Data}', " + $" HORA_CADASTRO='{Hora}' " + $" where _id=1 "; sqldTemp.ExecSQL(ComandoSql); Toast.MakeText(this, "Atualização realizada com sucesso", ToastLength.Long).Show(); } Validacoes.TempoCapturaPeso = int.Parse(spinner.SelectedItem.ToString()) - 1; }; }
public override void OnCreate(SQLiteDatabase db) { db.ExecSQL(sql: qry_create_table); }
public override void OnCreate(SQLiteDatabase db) { string query = $"CREATE TABLE {DbHelper.DB_TABLE} (ID INTEGER PRIMARY KEY AUTOINCREMENT, {DbHelper.DB_COLUMN} TEXT NOT NULL);"; db.ExecSQL(query); }
public override void OnUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) { db.ExecSQL("DROP TABLE IF EXISTS " + NoteDatabaseConstants.TableName); OnCreate(db); }
public override void OnCreate(SQLiteDatabase db) { System.Console.WriteLine("My Create Table STM \n \n" + creatTable); db.ExecSQL(creatTable); }
public void updateOrderStatus(string o_id) { String updateStm = "update " + order_tablename + " set " + order_status + " = 'complete' where " + order_id + " = " + o_id + ";"; connectionObj.ExecSQL(updateStm); Console.WriteLine(updateStm); }
private void findposition(int position, string locationname, string inventorytype, string id) { if (i > 0) { dialog.Dismiss(); ISharedPreferences prefs; // context.StartActivity(typeof(Main)); prefs = PreferenceManager.GetDefaultSharedPreferences(context); ISharedPreferencesEditor editor = prefs.Edit(); Dialog locationeditdialog = new Dialog(context); dialog = new Dialog(context); dialog.RequestWindowFeature((int)WindowFeatures.NoTitle); dialog.SetContentView(Resource.Layout.LocationEditPopUp); ImageView imgCloseLocationEditPopUp = dialog.FindViewById <ImageView>(Resource.Id.imgCloseLocationEditPopUp); RelativeLayout rlAddLocation = dialog.FindViewById <RelativeLayout>(Resource.Id.rlAddLocation); RelativeLayout rlRenameLocation = dialog.FindViewById <RelativeLayout>(Resource.Id.rlRenameLocation); RelativeLayout rlDeleteLocation = dialog.FindViewById <RelativeLayout>(Resource.Id.rlDeleteLocation); RelativeLayout rlDetailsLocation = dialog.FindViewById <RelativeLayout>(Resource.Id.rlDetailsLocation); RelativeLayout rlListLocationItem = dialog.FindViewById <RelativeLayout>(Resource.Id.rlListLocationItem); if (inventorytype.Trim() == "Manual" || inventorytype.Trim() == "Barcode") { rlListLocationItem.Visibility = ViewStates.Visible; } else { rlListLocationItem.Visibility = ViewStates.Gone; } imgCloseLocationEditPopUp.Click += delegate { dialog.Dismiss(); }; rlAddLocation.Click += delegate { try { if (inventorytype.Trim() == "Manual") { editor.PutLong("InventoryType", 1); editor.PutString("LocationName", locationname); context.StartActivity(typeof(EntryTab)); } if (inventorytype.Trim() == "Barcode") { editor.PutLong("InventoryType", 3); editor.PutString("LocationName", locationname); context.StartActivity(typeof(EntryTab)); } if (inventorytype.Trim() == "Voice") { editor.PutLong("InventoryType", 2); editor.PutString("LocationName", locationname); editor.PutInt("FromVoiceEdit", 1); context.StartActivity(typeof(EntryTab)); } editor.Commit(); // applies changes synchronously on older APIs editor.Apply(); dialog.Dismiss(); } catch (Exception ex) { Toast.MakeText(context, "Something went wrong. Please try back in few minutes.", ToastLength.Short).Show(); } }; rlListLocationItem.Click += delegate { try { editor.PutString("LocationNameFromLocationList", locationname); if (inventorytype.Trim() == "Manual") { editor.PutString("InventoryTypeFromLocationList", "1"); } if (inventorytype.Trim() == "Barcode") { editor.PutString("InventoryTypeFromLocationList", "3"); } editor.Commit(); // applies changes synchronously on older APIs editor.Apply(); try { context.Finish(); } catch { } context.StartActivity(typeof(LocationListItem)); } catch (Exception ex) { Toast.MakeText(context, "Something went wrong. Please try back in few minutes.", ToastLength.Short).Show(); } }; rlDeleteLocation.Click += delegate { try { db = context.OpenOrCreateDatabase("ImInventory", FileCreationMode.Private, null); AlertDialog.Builder builder = new AlertDialog.Builder(context); builder.SetMessage("Are you sure want to delete this location?"); builder.SetCancelable(false); //builder .SetIcon (Resource.Drawable.Icon); builder.SetPositiveButton("Yes", (object sender, DialogClickEventArgs e) => { string locationnamefromsession = prefs.GetString("LocationName", ""); if (locationname.Trim() == locationnamefromsession.Trim()) { editor.PutString("LocationName", ""); editor.Commit(); editor.Apply(); } if (inventorytype.Trim() == "Manual") { try { db.ExecSQL("delete from " + "tbl_Inventory where ID='" + id + "'"); context.Finish(); context.StartActivity(typeof(LocationList)); Toast.MakeText(context, "Location deleted successfully", ToastLength.Long).Show(); } catch { // Toast.MakeText(context, "An error occured. Pls try again later", ToastLength.Long).Show(); } } if (inventorytype.Trim() == "Barcode") { try { db.ExecSQL("delete from " + "tbl_Inventory where ID='" + id + "'"); context.Finish(); context.StartActivity(typeof(LocationList)); Toast.MakeText(context, "Location deleted successfully", ToastLength.Long).Show(); } catch { // Toast.MakeText(context, "An error occured. Pls try again later", ToastLength.Long).Show(); } } if (inventorytype.Trim() == "Voice") { try { db.ExecSQL("delete from " + "tbl_Inventory where ID='" + id + "'"); context.Finish(); context.StartActivity(typeof(LocationList)); Toast.MakeText(context, "Location deleted successfully", ToastLength.Long).Show(); } catch { //Toast.MakeText(context, "An error occured. Pls try again later", ToastLength.Long).Show(); } } }); builder.SetNegativeButton("No", (object sender, DialogClickEventArgs e) => { }); AlertDialog alertdialog = builder.Create(); alertdialog.Show(); } catch (Exception ex) { Toast.MakeText(context, "Something went wrong. Please try back in few minutes.", ToastLength.Short).Show(); } }; rlRenameLocation.Click += delegate { try { locationeditdialog = new Dialog(context); locationeditdialog.RequestWindowFeature((int)WindowFeatures.NoTitle); locationeditdialog.SetContentView(Resource.Layout.EditLocationFromPopUp); ImageView btnEditLocationFromPopUp = locationeditdialog.FindViewById <ImageView>(Resource.Id.btnEditLocationFromPopUp); EditText txtEditPopUpLocationName = locationeditdialog.FindViewById <EditText>(Resource.Id.txtEditPopUpLocationName); ImageView btnCancelEditLocationFromPopUp = locationeditdialog.FindViewById <ImageView>(Resource.Id.btnCancelEditLocationFromPopUp); Typeface tf = Typeface.CreateFromAsset(context.Assets, "Fonts/ROBOTO-LIGHT.TTF"); txtEditPopUpLocationName.Typeface = tf; txtEditPopUpLocationName.Invalidate(); txtEditPopUpLocationName.Text = locationname; locationeditdialog.SetCanceledOnTouchOutside(false); locationeditdialog.Show(); btnCancelEditLocationFromPopUp.Click += delegate { locationeditdialog.Dismiss(); }; btnEditLocationFromPopUp.Click += delegate { try { string updatequery = ""; ContentValues values = new ContentValues(); values.Put("Location", txtEditPopUpLocationName.Text); db = context.OpenOrCreateDatabase("ImInventory", FileCreationMode.Private, null); if (inventorytype.Trim() == "Manual") { updatequery = "update" + " tbl_Inventory set Location='" + txtEditPopUpLocationName.Text + "' where Location='" + locationname + "'"; db.Update("tbl_Inventory", values, "ID = " + id, null); //db.ExecSQL ("update" + " tbl_Inventory set Location='" + txtEditPopUpLocationName.Text + "' where ID = " + id); } if (inventorytype.Trim() == "Barcode") { //updatequery = "update" + " tbl_Inventory set Location='" + txtEditPopUpLocationName.Text + "' where Location='" + locationname + "'"; db.Update("tbl_Inventory", values, "ID = " + id, null); //db.ExecSQL ("update" + " tbl_Inventory set Location='" + txtEditPopUpLocationName.Text + "' where ID = " + id); } if (inventorytype.Trim() == "Voice") { //db.Update("tbl_Inventory",values,"ID = " + id,null); //db.ExecSQL ("update" + " tbl_Inventory set Location='" + txtEditPopUpLocationName.Text + "' where ID = " + id); } context.Finish(); context.StartActivity(typeof(LocationList)); Toast.MakeText(context, "Location updated successfully", ToastLength.Long).Show(); } catch (Exception ex) { Toast.MakeText(context, "Location updation failed", ToastLength.Long).Show(); } }; } catch (Exception ex) { Toast.MakeText(context, "Something went wrong. Please try back in few minutes.", ToastLength.Short).Show(); } }; rlDetailsLocation.Click += delegate { try { db = context.OpenOrCreateDatabase("ImInventory", FileCreationMode.Private, null); int manualcount = 0; int voicecount = 0; int barcodecount = 0; ICursor c1 = db.RawQuery("SELECT * FROM " + "tbl_Inventory Where InventoryType=1 AND Location='" + locationname + "'", null); manualcount = c1.Count; c1 = db.RawQuery("SELECT * FROM " + "tbl_Inventory Where InventoryType=3 AND Location='" + locationname + "'", null); barcodecount = c1.Count; c1 = db.RawQuery("SELECT * FROM " + "tbl_Inventory Where InventoryType=2 AND Location='" + locationname + "'", null); voicecount = c1.Count; Dialog locationdetailsdialog = new Dialog(context); locationdetailsdialog.RequestWindowFeature((int)WindowFeatures.NoTitle); locationdetailsdialog.SetContentView(Resource.Layout.LocationDetails); TextView txtManualEntryCount = locationdetailsdialog.FindViewById <TextView>(Resource.Id.txtManualEntryCount); TextView txtVoiceLength = locationdetailsdialog.FindViewById <TextView>(Resource.Id.txtVoiceLength); TextView txtBarcodeEntryCount = locationdetailsdialog.FindViewById <TextView>(Resource.Id.txtBarcodeEntryCount); TextView txtManualEntryCountText = locationdetailsdialog.FindViewById <TextView>(Resource.Id.txtManualEntryCountText); TextView txtVoiceLengthText = locationdetailsdialog.FindViewById <TextView>(Resource.Id.txtVoiceLengthText); TextView txtBarcodeEntryCountText = locationdetailsdialog.FindViewById <TextView>(Resource.Id.txtBarcodeEntryCountText); ImageView imgCloseLocationCountPopUp = locationdetailsdialog.FindViewById <ImageView>(Resource.Id.imgCloseLocationCountPopUp); imgCloseLocationCountPopUp.Click += delegate { locationdetailsdialog.Dismiss(); }; string audiopath = CreateDirectoryForAudio(); String duration = ""; Int32 totalduration = 0; string timeduration = ""; int hourcount = 0; int mincount = 0; int seccount = 0; string hour = ""; string min = ""; string sec = ""; c1.MoveToFirst(); if (voicecount > 0) { //locationnamecolumn = c1.GetColumnIndex("Location"); //addeddate = c1.GetColumnIndex("Addeddate"); int voicecolumn = c1.GetColumnIndex("AudioFileName"); do { String AudioFileName = c1.GetString(voicecolumn); if (AudioFileName != "") { if (AudioFileName.Contains("|")) { string[] ArrAudioFileName = AudioFileName.Split('|'); foreach (var item in ArrAudioFileName) { if (item.ToString() != "") { string AudioFilePath = ""; AudioFilePath = audiopath + "/" + item.ToString(); MediaMetadataRetriever mmr = new MediaMetadataRetriever(); mmr.SetDataSource(AudioFilePath); duration = mmr.ExtractMetadata(MetadataKey.Duration); totalduration = totalduration + Convert.ToInt32(duration); TimeSpan ts = new TimeSpan(0, 0, 0, 0, Convert.ToInt32(duration)); ts = TimeSpan.FromMilliseconds(Convert.ToDouble(totalduration)); hourcount = hourcount + ts.Hours; mincount = mincount + ts.Minutes; seccount = seccount + ts.Seconds; } } } else { MediaMetadataRetriever mmr = new MediaMetadataRetriever(); mmr.SetDataSource(audiopath + "/" + AudioFileName); duration = mmr.ExtractMetadata(MetadataKey.Duration); totalduration = totalduration + Convert.ToInt32(duration); TimeSpan ts = new TimeSpan(0, 0, 0, 0, Convert.ToInt32(duration)); ts = TimeSpan.FromMilliseconds(Convert.ToDouble(totalduration)); hourcount = hourcount + ts.Hours; mincount = mincount + ts.Minutes; seccount = seccount + ts.Seconds; } } //mmr.SetDataSource( }while (c1.MoveToNext()); } if (hourcount < 10) { hour = "0" + hourcount.ToString(); } else { hour = hourcount.ToString(); } if (mincount < 10) { min = "0" + mincount.ToString(); } else { min = mincount.ToString(); } if (seccount < 10) { sec = "0" + seccount.ToString(); } else { sec = seccount.ToString(); } timeduration = string.Format("{0}:{1}:{2}", hour, min, sec); Typeface tf = Typeface.CreateFromAsset(context.Assets, "Fonts/ROBOTO-LIGHT.TTF"); txtBarcodeEntryCount.Typeface = tf; txtBarcodeEntryCount.Invalidate(); txtManualEntryCount.Text = manualcount.ToString();; txtVoiceLength.Typeface = tf; txtVoiceLength.Invalidate(); txtVoiceLength.Text = timeduration; txtBarcodeEntryCount.Typeface = tf; txtBarcodeEntryCount.Invalidate(); txtBarcodeEntryCount.Text = barcodecount.ToString(); txtManualEntryCountText.Typeface = tf; txtManualEntryCountText.Invalidate(); txtVoiceLengthText.Typeface = tf; txtVoiceLengthText.Invalidate(); txtBarcodeEntryCountText.Typeface = tf; txtBarcodeEntryCountText.Invalidate(); locationdetailsdialog.SetCanceledOnTouchOutside(false); locationdetailsdialog.Show(); } catch (Exception ex) { Toast.MakeText(context, "Something went wrong. Please try back in few minutes.", ToastLength.Short).Show(); } }; dialog.SetCanceledOnTouchOutside(false); dialog.Show(); i = i + 1; } else { ISharedPreferences prefs; // context.StartActivity(typeof(Main)); prefs = PreferenceManager.GetDefaultSharedPreferences(context); ISharedPreferencesEditor editor = prefs.Edit(); Dialog locationeditdialog = new Dialog(context); dialog = new Dialog(context); dialog.RequestWindowFeature((int)WindowFeatures.NoTitle); dialog.SetContentView(Resource.Layout.LocationEditPopUp); ImageView imgCloseLocationEditPopUp = dialog.FindViewById <ImageView>(Resource.Id.imgCloseLocationEditPopUp); RelativeLayout rlAddLocation = dialog.FindViewById <RelativeLayout>(Resource.Id.rlAddLocation); RelativeLayout rlRenameLocation = dialog.FindViewById <RelativeLayout>(Resource.Id.rlRenameLocation); RelativeLayout rlDeleteLocation = dialog.FindViewById <RelativeLayout>(Resource.Id.rlDeleteLocation); RelativeLayout rlDetailsLocation = dialog.FindViewById <RelativeLayout>(Resource.Id.rlDetailsLocation); RelativeLayout rlListLocationItem = dialog.FindViewById <RelativeLayout>(Resource.Id.rlListLocationItem); if (inventorytype.Trim() == "Manual" || inventorytype.Trim() == "Barcode") { rlListLocationItem.Visibility = ViewStates.Visible; } else { rlListLocationItem.Visibility = ViewStates.Gone; } imgCloseLocationEditPopUp.Click += delegate { dialog.Dismiss(); }; rlListLocationItem.Click += delegate { try { editor.PutString("LocationNameFromLocationList", locationname); if (inventorytype.Trim() == "Manual") { editor.PutString("InventoryTypeFromLocationList", "1"); } if (inventorytype.Trim() == "Barcode") { editor.PutString("InventoryTypeFromLocationList", "3"); } editor.Commit(); // applies changes synchronously on older APIs editor.Apply(); try { context.Finish(); } catch { } context.StartActivity(typeof(LocationListItem)); } catch (Exception ex) { Toast.MakeText(context, "Something went wrong. Please try back in few minutes.", ToastLength.Short).Show(); } }; rlAddLocation.Click += delegate { try { if (inventorytype.Trim() == "Manual") { editor.PutLong("InventoryType", 1); editor.PutString("LocationName", locationname); context.StartActivity(typeof(EntryTab)); } if (inventorytype.Trim() == "Barcode") { editor.PutLong("InventoryType", 3); editor.PutString("LocationName", locationname); context.StartActivity(typeof(EntryTab)); } if (inventorytype.Trim() == "Voice") { editor.PutLong("InventoryType", 2); editor.PutString("LocationName", locationname); editor.PutInt("FromVoiceEdit", 1); context.StartActivity(typeof(EntryTab)); } editor.Commit(); // applies changes synchronously on older APIs editor.Apply(); dialog.Dismiss(); } catch (Exception ex) { Toast.MakeText(context, "Something went wrong. Please try back in few minutes.", ToastLength.Short).Show(); } }; rlDeleteLocation.Click += delegate { try { db = context.OpenOrCreateDatabase("ImInventory", FileCreationMode.Private, null); AlertDialog.Builder builder = new AlertDialog.Builder(context); builder.SetMessage("Are you sure want to delete this location?"); builder.SetCancelable(false); //builder .SetIcon (Resource.Drawable.Icon); builder.SetPositiveButton("Yes", (object sender, DialogClickEventArgs e) => { if (inventorytype.Trim() == "Manual") { try { db.ExecSQL("delete from " + "tbl_Inventory where ID='" + id + "'"); context.Finish(); context.StartActivity(typeof(LocationList)); Toast.MakeText(context, "Location deleted successfully", ToastLength.Long).Show(); } catch { // Toast.MakeText(context, "An error occured. Pls try again later", ToastLength.Long).Show(); } } if (inventorytype.Trim() == "Barcode") { try { db.ExecSQL("delete from " + "tbl_Inventory where ID='" + id + "'"); context.Finish(); context.StartActivity(typeof(LocationList)); Toast.MakeText(context, "Location deleted successfully", ToastLength.Long).Show(); } catch { // Toast.MakeText(context, "An error occured. Pls try again later", ToastLength.Long).Show(); } } if (inventorytype.Trim() == "Voice") { try { db.ExecSQL("delete from " + "tbl_Inventory where ID='" + id + "'"); context.Finish(); context.StartActivity(typeof(LocationList)); Toast.MakeText(context, "Location deleted successfully", ToastLength.Long).Show(); } catch { //Toast.MakeText(context, "An error occured. Pls try again later", ToastLength.Long).Show(); } } }); builder.SetNegativeButton("No", (object sender, DialogClickEventArgs e) => { }); AlertDialog alertdialog = builder.Create(); alertdialog.Show(); } catch (Exception ex) { Toast.MakeText(context, "Something went wrong. Please try back in few minutes.", ToastLength.Short).Show(); } }; rlRenameLocation.Click += delegate { try { locationeditdialog = new Dialog(context); locationeditdialog.RequestWindowFeature((int)WindowFeatures.NoTitle); locationeditdialog.SetContentView(Resource.Layout.EditLocationFromPopUp); ImageView btnEditLocationFromPopUp = locationeditdialog.FindViewById <ImageView>(Resource.Id.btnEditLocationFromPopUp); EditText txtEditPopUpLocationName = locationeditdialog.FindViewById <EditText>(Resource.Id.txtEditPopUpLocationName); ImageView btnCancelEditLocationFromPopUp = locationeditdialog.FindViewById <ImageView>(Resource.Id.btnCancelEditLocationFromPopUp); Typeface tf = Typeface.CreateFromAsset(context.Assets, "Fonts/ROBOTO-LIGHT.TTF"); txtEditPopUpLocationName.Typeface = tf; txtEditPopUpLocationName.Invalidate(); txtEditPopUpLocationName.Text = locationname; locationeditdialog.Show(); btnCancelEditLocationFromPopUp.Click += delegate { locationeditdialog.Dismiss(); }; btnEditLocationFromPopUp.Click += delegate { try { string updatequery = ""; ContentValues values = new ContentValues(); values.Put("Location", locationname); db = context.OpenOrCreateDatabase("ImInventory", FileCreationMode.Private, null); if (inventorytype.Trim() == "Manual") { updatequery = "update" + " tbl_Inventory set Location='" + txtEditPopUpLocationName.Text + "' where Location='" + locationname + "'"; db.ExecSQL("update" + " tbl_Inventory set Location='" + txtEditPopUpLocationName.Text + "' where ID = " + id); } if (inventorytype.Trim() == "Barcode") { updatequery = "update" + " tbl_Inventory set Location='" + txtEditPopUpLocationName.Text + "' where Location='" + locationname + "'"; db.ExecSQL("update" + " tbl_Inventory set Location='" + txtEditPopUpLocationName.Text + "' where ID = " + id); } if (inventorytype.Trim() == "Voice") { db.ExecSQL("update" + " tbl_Inventory set Location='" + txtEditPopUpLocationName.Text + "' where ID = " + id); } context.Finish(); context.StartActivity(typeof(LocationList)); Toast.MakeText(context, "Location updated successfully", ToastLength.Long).Show(); } catch (Exception ex) { Toast.MakeText(context, "Location updation failed", ToastLength.Long).Show(); } }; } catch (Exception ex) { Toast.MakeText(context, "Something went wrong. Please try back in few minutes.", ToastLength.Short).Show(); } }; rlDetailsLocation.Click += delegate { try { db = context.OpenOrCreateDatabase("ImInventory", FileCreationMode.Private, null); int manualcount = 0; int voicecount = 0; int barcodecount = 0; ICursor c1 = db.RawQuery("SELECT * FROM " + "tbl_Inventory Where InventoryType=1 AND Location='" + locationname + "'", null); manualcount = c1.Count; c1 = db.RawQuery("SELECT * FROM " + "tbl_Inventory Where InventoryType=3 AND Location='" + locationname + "'", null); barcodecount = c1.Count; c1 = db.RawQuery("SELECT * FROM " + "tbl_Inventory Where InventoryType=2 AND Location='" + locationname + "'", null); voicecount = c1.Count; Dialog locationdetailsdialog = new Dialog(context); locationdetailsdialog.RequestWindowFeature((int)WindowFeatures.NoTitle); locationdetailsdialog.SetContentView(Resource.Layout.LocationDetails); TextView txtManualEntryCount = locationdetailsdialog.FindViewById <TextView>(Resource.Id.txtManualEntryCount); TextView txtVoiceLength = locationdetailsdialog.FindViewById <TextView>(Resource.Id.txtVoiceLength); TextView txtBarcodeEntryCount = locationdetailsdialog.FindViewById <TextView>(Resource.Id.txtBarcodeEntryCount); TextView txtManualEntryCountText = locationdetailsdialog.FindViewById <TextView>(Resource.Id.txtManualEntryCountText); TextView txtVoiceLengthText = locationdetailsdialog.FindViewById <TextView>(Resource.Id.txtVoiceLengthText); TextView txtBarcodeEntryCountText = locationdetailsdialog.FindViewById <TextView>(Resource.Id.txtBarcodeEntryCountText); ImageView imgCloseLocationCountPopUp = locationdetailsdialog.FindViewById <ImageView>(Resource.Id.imgCloseLocationCountPopUp); imgCloseLocationCountPopUp.Click += delegate { locationdetailsdialog.Dismiss(); }; string audiopath = CreateDirectoryForAudio(); String duration = ""; Int32 totalduration = 0; string timeduration = ""; int hourcount = 0; int mincount = 0; int seccount = 0; string hour = ""; string min = ""; string sec = ""; c1.MoveToFirst(); if (voicecount > 0) { //locationnamecolumn = c1.GetColumnIndex("Location"); //addeddate = c1.GetColumnIndex("Addeddate"); int voicecolumn = c1.GetColumnIndex("AudioFileName"); do { String AudioFileName = c1.GetString(voicecolumn); if (AudioFileName != "") { if (AudioFileName.Contains("|")) { string[] ArrAudioFileName = AudioFileName.Split('|'); foreach (var item in ArrAudioFileName) { if (item.ToString() != "") { string AudioFilePath = ""; AudioFilePath = audiopath + "/" + item.ToString(); MediaMetadataRetriever mmr = new MediaMetadataRetriever(); mmr.SetDataSource(AudioFilePath); duration = mmr.ExtractMetadata(MetadataKey.Duration); totalduration = totalduration + Convert.ToInt32(duration); TimeSpan ts = new TimeSpan(0, 0, 0, 0, Convert.ToInt32(duration)); ts = TimeSpan.FromMilliseconds(Convert.ToDouble(totalduration)); hourcount = hourcount + ts.Hours; mincount = mincount + ts.Minutes; seccount = seccount + ts.Seconds; } } } else { MediaMetadataRetriever mmr = new MediaMetadataRetriever(); mmr.SetDataSource(audiopath + "/" + AudioFileName); duration = mmr.ExtractMetadata(MetadataKey.Duration); totalduration = totalduration + Convert.ToInt32(duration); TimeSpan ts = new TimeSpan(0, 0, 0, 0, Convert.ToInt32(duration)); ts = TimeSpan.FromMilliseconds(Convert.ToDouble(totalduration)); hourcount = hourcount + ts.Hours; mincount = mincount + ts.Minutes; seccount = seccount + ts.Seconds; } } //mmr.SetDataSource( }while (c1.MoveToNext()); } if (hourcount < 10) { hour = "0" + hourcount.ToString(); } else { hour = hourcount.ToString(); } if (mincount < 10) { min = "0" + mincount.ToString(); } else { min = mincount.ToString(); } if (seccount < 10) { sec = "0" + seccount.ToString(); } else { sec = seccount.ToString(); } timeduration = string.Format("{0}:{1}:{2}", hour, min, sec); Typeface tf = Typeface.CreateFromAsset(context.Assets, "Fonts/ROBOTO-LIGHT.TTF"); txtBarcodeEntryCount.Typeface = tf; txtBarcodeEntryCount.Invalidate(); txtManualEntryCount.Text = manualcount.ToString();; txtVoiceLength.Typeface = tf; txtVoiceLength.Invalidate(); txtVoiceLength.Text = timeduration; txtBarcodeEntryCount.Typeface = tf; txtBarcodeEntryCount.Invalidate(); txtBarcodeEntryCount.Text = barcodecount.ToString(); txtManualEntryCountText.Typeface = tf; txtManualEntryCountText.Invalidate(); txtVoiceLengthText.Typeface = tf; txtVoiceLengthText.Invalidate(); txtBarcodeEntryCountText.Typeface = tf; txtBarcodeEntryCountText.Invalidate(); locationdetailsdialog.SetCanceledOnTouchOutside(false); locationdetailsdialog.Show(); } catch (Exception ex) { Toast.MakeText(context, "Something went wrong. Please try back in few minutes.", ToastLength.Short).Show(); } }; dialog.SetCanceledOnTouchOutside(false); dialog.Show(); i = i + 1; } }
//Cria um novo banco de dados cujo nome é dado pelo parâmetro public void CriarDatabase(string sqldb_nome) { try { sqldb_mensagem = ""; string sqldb_location = System.Environment.GetFolderPath(System.Environment.SpecialFolder.Personal); string sqldb_path = Path.Combine(sqldb_location, sqldb_nome); bool sqldb_exists = File.Exists(sqldb_path); if (!sqldb_exists) { sqldb = SQLiteDatabase.OpenOrCreateDatabase(sqldb_path, null); sqldb_query = "CREATE TABLE IF NOT EXISTS Users (Username VARCHAR PRIMARY KEY, Password VARCHAR, FullName VARCHAR);"; sqldb.ExecSQL(sqldb_query); sqldb_mensagem = "Banco de dados '" + sqldb_nome + "' criado com sucesso!"; } else { sqldb = SQLiteDatabase.OpenDatabase(sqldb_path, null, DatabaseOpenFlags.OpenReadwrite); sqldb_mensagem = "Banco de dados '" + sqldb_nome + "' carregado com sucesso!"; } sqldb_dispoTalhao = true; } catch (SQLiteException ex) { sqldb_mensagem = ex.Message; } if (sqldb_nome == "perfil") { try { sqldb_mensagem = ""; string sqldb_location = System.Environment.GetFolderPath(System.Environment.SpecialFolder.Personal); string sqldb_path = Path.Combine(sqldb_location, sqldb_nome); bool sqldb_exists = File.Exists(sqldb_path); if (true) { sqldb = SQLiteDatabase.OpenOrCreateDatabase(sqldb_path, null); sqldb_query = "CREATE TABLE IF NOT EXISTS perfil (_ID INTEGER PRIMARY KEY AUTOINCREMENT, paciente VARCHAR, responsavel VARCHAR);"; sqldb.ExecSQL(sqldb_query); sqldb_mensagem = "Banco de dados '" + sqldb_nome + "' criado com sucesso!"; //sqldb_query = "INSERT INTO perfil (paciente,responsavel) VALUES('POC','POC')"; //sqldb.ExecSQL(sqldb_query); } else { sqldb = SQLiteDatabase.OpenDatabase(sqldb_path, null, DatabaseOpenFlags.OpenReadwrite); sqldb_mensagem = "Banco de dados '" + sqldb_nome + "' carregado com sucesso!"; sqldb_query = "SELECT * FROM dual where 1 = 0"; sqldb.ExecSQL(sqldb_query); } sqldb_dispoTalhao = true; } catch (SQLiteException ex) { sqldb_mensagem = ex.Message; } } else if (sqldb_nome == "remedio") { try { sqldb_mensagem = ""; string sqldb_location = System.Environment.GetFolderPath(System.Environment.SpecialFolder.Personal); string sqldb_path = Path.Combine(sqldb_location, sqldb_nome); bool sqldb_exists = File.Exists(sqldb_path); if (true) { sqldb = SQLiteDatabase.OpenOrCreateDatabase(sqldb_path, null); sqldb_query = "CREATE TABLE IF NOT EXISTS remedio (_ID INTEGER PRIMARY KEY AUTOINCREMENT, data VARCHAR);"; sqldb.ExecSQL(sqldb_query); sqldb_mensagem = "Banco de dados '" + sqldb_nome + "' criado com sucesso!"; //sqldb_query = "INSERT INTO remedio (data) VALUES('POC')"; //sqldb.ExecSQL(sqldb_query); } else { sqldb = SQLiteDatabase.OpenDatabase(sqldb_path, null, DatabaseOpenFlags.OpenReadwrite); sqldb_mensagem = "Banco de dados '" + sqldb_nome + "' carregado com sucesso!"; sqldb_query = "SELECT * FROM dual where 1 = 0"; sqldb.ExecSQL(sqldb_query); } sqldb_dispoTalhao = true; } catch (SQLiteException ex) { sqldb_mensagem = ex.Message; } } }
protected override void OnCreate(Bundle bundle) { base.OnCreate(bundle); RequestWindowFeature(WindowFeatures.NoTitle); SetContentView(Resource.Layout.layoutConfiguraComunicacao); SetResult(Result.Canceled); //==========================================================// // CRIAR BANCO DE DADOS // //==========================================================// mdTemp = new BancoDados("PRINCIPAL"); mdTemp.CreateDatabases("PRINCIPAL"); //==========================================================// var toolbar = FindViewById <Toolbar>(Resource.Id.toolbar); SetSupportActionBar(toolbar); SupportActionBar.Title = "CONFIGURAÇÃO COMUNICAÇÃO PLATAFORMAS"; SupportActionBar.SetDisplayHomeAsUpEnabled(true); SupportActionBar.SetHomeButtonEnabled(true); var relogioDigital = FindViewById <DigitalClock>(Resource.Id.digitalClock1); relogioDigital.Visibility = Android.Views.ViewStates.Visible; TextView textIpHeard = FindViewById <TextView>(Resource.Id.textIpHeard); EditText TextIp = FindViewById <EditText>(Resource.Id.TextIpConfigura); TextView textPortaHeard = FindViewById <TextView>(Resource.Id.textPortaHeard); EditText TextPorta = FindViewById <EditText>(Resource.Id.TextPortaComunicacao); EditText TextSenha = FindViewById <EditText>(Resource.Id.TextSenhaComunicacao); TextView TextHeadBlutooth = FindViewById <TextView>(Resource.Id.textHeaderBluetooth); TextBluetooth = FindViewById <EditText>(Resource.Id.BluetoothConfigura); TextBluetooth.Text = Intent.GetStringExtra("nome"); RadioButton RdnWifi = FindViewById <RadioButton>(Resource.Id.RdnWifi); RadioButton RdnBluetooth = FindViewById <RadioButton>(Resource.Id.RdnBluetooth); Android.Support.V7.Widget.AppCompatImageButton BtnSair = FindViewById <Android.Support.V7.Widget.AppCompatImageButton>(Resource.Id.BtnSairComunicacao); Android.Support.V7.Widget.AppCompatImageButton BtnSalvar = FindViewById <Android.Support.V7.Widget.AppCompatImageButton>(Resource.Id.BtnSalvarComunicacao); Android.Support.V7.Widget.AppCompatButton BtnTestarBluetooth = FindViewById <Android.Support.V7.Widget.AppCompatButton>(Resource.Id.btnTestarBluetooth); Android.Support.V7.Widget.AppCompatButton BtnPesquisar = FindViewById <Android.Support.V7.Widget.AppCompatButton>(Resource.Id.btnPequisaBluetooth); StringBuilder outStringBuffer; BluetoothAdapter bluetoothAdapter = null; BluetoothChatService ServiceConnection = null; spinner = FindViewById <Spinner>(Resource.Id.spinnernrplataformas); selecao = new string[6]; selecao[0] = "01"; selecao[1] = "02"; selecao[2] = "03"; selecao[3] = "04"; selecao[4] = "05"; selecao[5] = "06"; adapter = new ArrayAdapter(this, Android.Resource.Layout.SimpleSpinnerDropDownItem, selecao); spinner.Adapter = adapter; //================================================================================// // VALOR CADASTRADOS // //================================================================================// string sLocation = System.Environment.GetFolderPath(System.Environment.SpecialFolder.Personal); string sDB = Path.Combine(sLocation, "PRINCIPAL"); sqldTemp = SQLiteDatabase.OpenOrCreateDatabase(sDB, null); bool bIsExists = File.Exists(sDB); string sSQLQuery = ""; Android.Database.ICursor icursorTemp = null; sSQLQuery = "SELECT NR_PLATAFORMAS," + " DESCRICAO_TIPO_CONEXAO, " + " ENDERECO_IP, " + " PORTA, " + " BLUETOOTH " + " FROM CONEXAO_PLATAFORMA WHERE _id=1"; icursorTemp = sqldTemp.RawQuery(sSQLQuery, null); int ValorCursor = icursorTemp.Count; int nrParcelas = 0; if (ValorCursor > 0) { icursorTemp.MoveToNext(); if (icursorTemp.GetString(1) == "WIFI") { RdnWifi.Checked = true; } else { RdnBluetooth.Checked = true; } TextIp.Text = icursorTemp.GetString(2); TextPorta.Text = icursorTemp.GetString(3); if (TextBluetooth.Text == "") { TextBluetooth.Text = icursorTemp.GetString(4); } Validacoes.NrPlataformas = int.Parse(icursorTemp.GetString(0)); } else { RdnBluetooth.Checked = true; } if (RdnWifi.Checked == true && Validacoes.ConexaoWifiBluetooth != true) { TextHeadBlutooth.Visibility = ViewStates.Invisible; TextBluetooth.Visibility = ViewStates.Invisible; BtnPesquisar.Visibility = ViewStates.Invisible; } if (RdnBluetooth.Checked == true || Validacoes.ConexaoWifiBluetooth == true) { textIpHeard.Visibility = ViewStates.Invisible; TextIp.Visibility = ViewStates.Invisible; textPortaHeard.Visibility = ViewStates.Invisible; TextPorta.Visibility = ViewStates.Invisible; RdnBluetooth.Checked = true; } TextBluetooth.InputType = 0; RdnWifi.Click += RadioButtonBluetooth; RdnBluetooth.Click += RadioButtonWifi; Window.SetSoftInputMode(SoftInput.StateHidden); //==============================================// // BLUETOOTH // //==============================================// var scanButton = FindViewById <Button>(Resource.Id.btnPequisaBluetooth); if (Validacoes.NrPlataformas > 0) { spinner.SetSelection(Validacoes.NrPlataformas); } spinner.ItemSelected += (s, e) => { firstItem = spinner.SelectedItem.ToString(); if (firstItem.Equals(spinner.SelectedItem.ToString())) { Validacoes.NrPlataformas = int.Parse(spinner.SelectedItem.ToString()) - 1; } else { Toast.MakeText(this, "You have selected: " + e.Parent.GetItemIdAtPosition(e.Position).ToString(), ToastLength.Short).Show(); } }; scanButton.Click += (sender, e) => { StartActivity(typeof(DeviceListActivity)); RdnBluetooth.Checked = true; textIpHeard.Visibility = ViewStates.Invisible; TextIp.Visibility = ViewStates.Invisible; textPortaHeard.Visibility = ViewStates.Invisible; TextPorta.Visibility = ViewStates.Invisible; Validacoes.DeviceListPrinter = false; Finish(); }; // Register for broadcasts when a device is discovered BtnSair.Click += delegate { Finish(); }; BtnTestarBluetooth.Click += delegate { BluetoothAdapter adaptador = BluetoothAdapter.DefaultAdapter; // procura o adap. bluetooth ICollection <BluetoothDevice> aparelhos = adaptador.BondedDevices; BluetoothDevice[] apa = new BluetoothDevice[aparelhos.Count]; ParcelUuid[] chaves; BluetoothSocket[] socket = new BluetoothSocket[1]; int i = 0; string Conectado = "nao"; foreach (BluetoothDevice aparelho in aparelhos) { apa[i] = aparelho; if (aparelho.Name == TextBluetooth.Text) { Conectado = "sim"; chaves = aparelho.GetUuids(); socket[0] = aparelho.CreateInsecureRfcommSocketToServiceRecord(chaves[0].Uuid); break; } i++; } if (adaptador?.IsEnabled == false) { var enableBtIntent = "ok"; } if (Conectado == "sim") { var address = apa[i].Address; conectar(socket[0]); } }; BtnSalvar.Click += delegate { if (RdnWifi.Checked == true) { if (TextIp.Text == "") { Toast.MakeText(this, "Deve ser digitado um Endereço de nº IP", ToastLength.Short).Show(); return; } if (TextPorta.Text == "") { Toast.MakeText(this, "Deve ser digitado uma Porta de comunicação", ToastLength.Short).Show(); return; } } if (RdnBluetooth.Checked == true) { if (TextBluetooth.Text == "") { Toast.MakeText(this, "Deve ser digitado um pareamento BlueTooth", ToastLength.Short).Show(); return; } } //if (TextSenha.Text == "") //{ // Toast.MakeText(this, "Deve ser digitada uma Senha", ToastLength.Short).Show(); // return; //} string DescricaoComunicao = ""; //==============================================================================================// // VERIFICA SE JÁ EXISTE UM ENDEREÇO GRAVADO // //==============================================================================================// sSQLQuery = ""; sSQLQuery = "SELECT _id,NR_PLATAFORMAS,DESCRICAO_TIPO_CONEXAO " + " FROM CONEXAO_PLATAFORMA "; icursorTemp = sqldTemp.RawQuery(sSQLQuery, null); ValorCursor = icursorTemp.Count; if (RdnWifi.Checked == true) { DescricaoComunicao = "WIFI"; } if (RdnBluetooth.Checked == true) { DescricaoComunicao = "BLUETOOTH"; } string Data = System.DateTime.Today.ToShortDateString(); string Hora = System.DateTime.Today.ToShortTimeString(); if (ValorCursor == 0) { string Valores = int.Parse(spinner.SelectedItem.ToString()) - 1 + ",'" + DescricaoComunicao + "','" + TextIp.Text + "','" + TextPorta.Text + "','" + TextBluetooth.Text + "','" + TextSenha.Text + "','" + Data + "','" + Hora + "'"; string Campos = "NR_PLATAFORMAS," + "DESCRICAO_TIPO_CONEXAO," + "ENDERECO_IP," + "PORTA," + "BLUETOOTH," + "SENHA," + "DATA_CADASTRO," + "HORA_CADASTRO"; sSQLQuery = "INSERT INTO " + "CONEXAO_PLATAFORMA " + "(" + Campos + ") " + "VALUES(" + Valores + ");"; sqldTemp.ExecSQL(sSQLQuery); sMessage = "Record is saved."; Toast.MakeText(this, "REGISTRO GRAVADO COM SUCESSO", ToastLength.Long).Show(); } else { string ComandoSql = "update CONEXAO_PLATAFORMA set " + $" NR_PLATAFORMAS={int.Parse(spinner.SelectedItem.ToString())-1}," + $" DESCRICAO_TIPO_CONEXAO='{DescricaoComunicao}'," + $" ENDERECO_IP='{TextIp.Text}'," + $" PORTA='{TextPorta.Text}', " + $" BLUETOOTH='{TextBluetooth.Text}', " + $" SENHA='{TextSenha.Text}', " + $" DATA_CADASTRO='{Data}', " + $" HORA_CADASTRO='{Hora}' " + $" where _id=1 "; sqldTemp.ExecSQL(ComandoSql); Toast.MakeText(this, "Atualização realizada com sucesso", ToastLength.Long).Show(); } }; void RadioButtonWifi(object sender, EventArgs e) { RadioButton rb = (RadioButton)sender; TextHeadBlutooth.Visibility = ViewStates.Visible; TextBluetooth.Visibility = ViewStates.Visible; textIpHeard.Visibility = ViewStates.Invisible; TextIp.Visibility = ViewStates.Invisible; textPortaHeard.Visibility = ViewStates.Invisible; TextPorta.Visibility = ViewStates.Invisible; BtnPesquisar.Visibility = ViewStates.Visible; Validacoes.ConexaoWifiBluetooth = true; } void RadioButtonBluetooth(object sender, EventArgs e) { RadioButton rb = (RadioButton)sender; TextHeadBlutooth.Visibility = ViewStates.Invisible; TextBluetooth.Visibility = ViewStates.Invisible; textIpHeard.Visibility = ViewStates.Visible; TextIp.Visibility = ViewStates.Visible; textPortaHeard.Visibility = ViewStates.Visible; TextPorta.Visibility = ViewStates.Visible; BtnPesquisar.Visibility = ViewStates.Invisible; Validacoes.ConexaoWifiBluetooth = false; } }
// Default function to upgrade the database. public override void OnUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) { db.ExecSQL(DeleteQuery); OnCreate(db); }
protected override void OnCreate(Bundle bundle) { base.OnCreate(bundle); string sSQLQuery = ""; SetContentView(Resource.Layout.layoutProdutos); SetResult(Result.Canceled); //==========================================================// // CRIAR BANCO DE DADOS // //==========================================================// mdTemp = new BancoDados("PRINCIPAL"); mdTemp.CreateDatabases("PRINCIPAL"); //==========================================================// var toolbar = FindViewById <Toolbar>(Resource.Id.toolbar); SetSupportActionBar(toolbar); SupportActionBar.Title = "CADASTRO DE PRODUTOS"; SupportActionBar.SetDisplayHomeAsUpEnabled(true); SupportActionBar.SetHomeButtonEnabled(true); var relogioDigital = FindViewById <DigitalClock>(Resource.Id.digitalClock2); relogioDigital.Visibility = Android.Views.ViewStates.Visible; Android.Support.V7.Widget.AppCompatImageButton BtnSair = FindViewById <Android.Support.V7.Widget.AppCompatImageButton>(Resource.Id.BtnVoltarProduto); Android.Support.V7.Widget.AppCompatImageButton BtnSalvar = FindViewById <Android.Support.V7.Widget.AppCompatImageButton>(Resource.Id.BtnSalvarProduto); EditText produto = FindViewById <EditText>(Resource.Id.TxtDescicaoProduto); EditText valor = FindViewById <EditText>(Resource.Id.TextValorProduto); TextView codigo = FindViewById <TextView>(Resource.Id.TxtCodigoProduto); sSQLQuery = ""; string sLocation = System.Environment.GetFolderPath(System.Environment.SpecialFolder.Personal); string sDB = Path.Combine(sLocation, "PRINCIPAL"); sqldTemp = SQLiteDatabase.OpenOrCreateDatabase(sDB, null); bool bIsExists = File.Exists(sDB); valor.AfterTextChanged += EditTextValor_AfterTextChanged; nomes = new string[1]; for (int i = 0; i < 1; i++) { nomes[i] = " ".ToString(); } CarregaListaProdutos(); Window.SetSoftInputMode(SoftInput.StateHidden); BtnSair.Click += delegate { Finish(); }; BtnSalvar.Click += delegate { if (produto.Text == "") { Toast.MakeText(this, "Deve ser digitada uma PRODUTO!", ToastLength.Short).Show(); return; } if (valor.Text == "") { Toast.MakeText(this, "Deve ser selecionado um valor de PRODUTO!", ToastLength.Short).Show(); return; } //==============================================================================================// // VERIFICA SE JÁ EXISTE UM ENDEREÇO GRAVADO // //==============================================================================================// sLocation = System.Environment.GetFolderPath(System.Environment.SpecialFolder.Personal); sDB = Path.Combine(sLocation, "PRINCIPAL"); sqldTemp = SQLiteDatabase.OpenOrCreateDatabase(sDB, null); bIsExists = File.Exists(sDB); Android.Database.ICursor icursorTemp = null; sSQLQuery = ""; sSQLQuery = $"SELECT _id FROM PRODUTOS WHERE _id='{codigo.Text}'"; icursorTemp = sqldTemp.RawQuery(sSQLQuery, null); int ValorCursor = icursorTemp.Count; string Data = System.DateTime.Today.ToShortDateString(); string Hora = System.DateTime.Today.ToShortTimeString(); if (ValorCursor == 0) { // string ValorProduto = System.String.Format(valor.Text,"C2"); string Valores = "'" + produto.Text + "','" + valor.Text + "','" + Data + "','" + Hora + "'"; string Campos = "PRODUTO," + "VALOR," + "DATA_CADASTRO," + "HORA_CADASTRO"; sSQLQuery = "INSERT INTO " + "PRODUTOS " + "(" + Campos + ") " + "VALUES(" + Valores + ");"; sqldTemp.ExecSQL(sSQLQuery); sMessage = "Record is saved."; Toast.MakeText(this, "REGISTRO GRAVADO COM SUCESSO", ToastLength.Long).Show(); } else { string ComandoSql = "update PRODUTOS set " + $" PRODUTO='{produto.Text}'," + $" VALOR='{valor.Text}'," + $" DATA_CADASTRO='{Data}', " + $" HORA_CADASTRO='{Hora}' " + $" where _id={codigo.Text}"; sqldTemp.ExecSQL(ComandoSql); Toast.MakeText(this, "Atualização realizada com sucesso", ToastLength.Long).Show(); } produto.Text = ""; valor.Text = ""; codigo.Text = ""; CarregaListaProdutos(); }; void EditTextValor_AfterTextChanged(object sender, AfterTextChangedEventArgs e) { var text = e.Editable.ToString(); valor.AfterTextChanged -= EditTextValor_AfterTextChanged; var formatedText = FormatarCampos.ValorValueConverter(text); valor.Text = formatedText; valor.SetSelection(formatedText.Length); valor.AfterTextChanged += EditTextValor_AfterTextChanged; } void CarregaListaProdutos() { Android.Database.ICursor icursorTemp = null; sSQLQuery = "SELECT _id," + " PRODUTO, " + " VALOR " + " FROM PRODUTOS "; icursorTemp = sqldTemp.RawQuery(sSQLQuery, null); int ValorCursor = icursorTemp.Count; if (ValorCursor > 0) { nomes = new string[icursorTemp.Count]; for (int i = 0; i < icursorTemp.Count; i++) { icursorTemp.MoveToNext(); item = new CarreDadosProdutos(); item.Id = icursorTemp.GetString(0); item.Produto = icursorTemp.GetString(1); item.Valor = icursorTemp.GetString(2); // item.Produto = FormatarCampos.RetornaTextoLista(item.Produto.PadRight(35, '0')); string Linha = ""; Linha = item.Id.PadLeft(5, '0') + " " + item.Produto.PadRight(15, '_') + item.Valor.PadLeft(20, '_'); nomes[i] = Linha; } ArrayAdapter <System.String> itemsAdapter = new ArrayAdapter <System.String>(this, Android.Resource.Layout.SimpleSpinnerDropDownItem, nomes); Android.Widget.ListView listview = FindViewById <Android.Widget.ListView>(Resource.Id.ListaProdutos); listview = FindViewById <Android.Widget.ListView>(Resource.Id.ListaProdutos); listview.Adapter = itemsAdapter; listview.ItemClick += ListView_ItemClick; } void ListView_ItemClick(object sender, AdapterView.ItemClickEventArgs e) { Validacoes.ValorItem = nomes[e.Id]; sSQLQuery = "SELECT _id," + " PRODUTO, " + " VALOR " + " FROM PRODUTOS " + $" WHERE _id={Convert.ToInt16(Validacoes.ValorItem.Substring(0, 6))}"; icursorTemp = sqldTemp.RawQuery(sSQLQuery, null); ValorCursor = icursorTemp.Count; if (ValorCursor > 0) { icursorTemp.MoveToNext(); codigo.Text = icursorTemp.GetString(0); produto.Text = icursorTemp.GetString(1); valor.Text = icursorTemp.GetString(2); } } } }
public override void OnCreate(SQLiteDatabase db) // Step: 1 - 2:1 { db.ExecSQL(CreateUserTableQuery); // Step: 4 }
public override void OnCreate(SQLiteDatabase db) { db.ExecSQL("CREATE TABLE motion_activity(Id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, Confidence FLOAT NOT NULL, Event INTEGER NOT NULL, Timestamp INTEGER NOT NULL)"); db.ExecSQL("CREATE INDEX idx_timestamp ON motion_activity(Timestamp);"); }