protected override void OnCreate(Bundle savedInstanceState)
        {
            string dpPath = Path.Combine(System.Environment.GetFolderPath(System.Environment.SpecialFolder.Personal), "ScoutingApp.db3");
            var    db     = new SQLiteConnection(dpPath);

            db.CreateTable <ISTable>();
            ISTable tbl = new ISTable();

            db.CreateTable <PitsTable>();
            PitsTable pits = new PitsTable();

            base.OnCreate(savedInstanceState);

            SetContentView(Resource.Layout.scores_layout);
            listviewI = FindViewById <ListView>(Resource.Id.listViewIS);
            listis    = db.Table <ISTable>().OrderBy(item => item.Team).ToList();
            ImageViewAdapter adapterI = new ImageViewAdapter(this, listis);

            listviewI.Adapter = adapterI;
        }
        private void Create_Click(object sender, EventArgs e)
        {
            try
            {
                string dpPath = Path.Combine(System.Environment.GetFolderPath(System.Environment.SpecialFolder.Personal), "ScoutingApp.db3");
                var    db     = new SQLiteConnection(dpPath);
                db.CreateTable <PitsTable>();
                PitsTable tbl = new PitsTable();
                db.CreateTable <ISTable>();
                ISTable     ist = new ISTable();
                ScoresTable st  = new ScoresTable();
                int         finalScore;
                int         firstScore;
                int         secondScore;
                secondScore = 0;
                finalScore  = 0;
                firstScore  = 0;

                int number = Int32.Parse(teamNumber.Text);
                tbl.Team = number;
                st.Team  = number;
                ist.Team = number;

                //interesting issue-- it's not storing anything for the ints

                tbl.RobotWeight = weight.Text;
                if (mech.Checked)
                {
                    tbl.Drivetrain = "Mechanum";
                    firstScore     = 1;
                }
                if (holo.Checked)
                {
                    tbl.Drivetrain = "Holonomic";
                    firstScore     = 2;
                }
                if (tank.Checked)
                {
                    tbl.Drivetrain = "Tank";
                    firstScore     = 3;
                }
                if (swerve.Checked)
                {
                    tbl.Drivetrain = "Swerve";
                    firstScore     = 4;
                }
                if (slide.Checked)
                {
                    tbl.Drivetrain = "Slide";
                    firstScore     = 0;
                }

                tbl.Notes = notes.Text;
                db.Insert(tbl);
                Toast.MakeText(this, "Record Added Successfully", ToastLength.Short).Show();

                items = db.Table <PitsTable>().OrderBy(item => item.Team).ToList();


                PitsViewAdapter adapterP = new PitsViewAdapter(this, items);

                listviewP.Adapter = adapterP;

                int numberW = Int32.Parse(weight.Text);

                if (numberW < 50)
                {
                    secondScore = 1;
                }
                if (numberW >= 50)
                {
                    secondScore = 3;
                }

                finalScore    = firstScore + secondScore;
                ist.Score     = finalScore;
                st.TotalScore = finalScore;
                System.Diagnostics.Debug.WriteLine(finalScore);


                db.Insert(tbl);
                db.Insert(ist);
                db.Insert(st);
            }
            catch (Exception ex)
            {
                Toast.MakeText(this, ex.ToString(), ToastLength.Long).Show();
            }
        }