Ejemplo n.º 1
0
        private void Testing6_Click(object sender, RoutedEventArgs e)
        {
            SQLFunctions      sqlFunctions   = new SQLFunctions(SQLConnection.DatabaseContext);
            List <MultiModel> multiModelList = sqlFunctions.GetFullResults(0, 100); // Should get it all.

            sqlFunctions.DeleteData(multiModelList[0]);
            showRecords("Delete");
        }
Ejemplo n.º 2
0
        private void Testing4_Click(object sender, RoutedEventArgs e)
        {
            SQLFunctions      sqlFunctions   = new SQLFunctions(SQLConnection.DatabaseContext);
            List <MultiModel> multiModelList = sqlFunctions.GetFullResults(0, 100); // Should get it all.

            multiModelList[0].Firstname = "Test Firstname";
            multiModelList[0].City      = "Test City";
            multiModelList[0].Age       = "99";

            sqlFunctions.UpdateData(multiModelList[0]);
            showRecords("Update");
        }
Ejemplo n.º 3
0
        private void Testing5_Click(object sender, RoutedEventArgs e)
        {
            SQLFunctions sqlFunctions = new SQLFunctions(SQLConnection.DatabaseContext);
            MultiModel   multiModel   = new MultiModel()
            {
                PersonDataTable  = new PersonData(),
                AddressDataTable = new AddressData(),
                DetailsDataTable = new DetailsData(),
            };

            multiModel.Firstname = "Test Add";
            multiModel.Lastname  = "Last";
            multiModel.City      = "Some Test City";
            multiModel.Age       = "100";

            sqlFunctions.AddData(multiModel);
            showRecords("Add");
        }
Ejemplo n.º 4
0
        private void showRecords(string message)
        {
            SQLFunctions      sqlFunctions   = new SQLFunctions(SQLConnection.DatabaseContext);
            List <MultiModel> multiModelList = sqlFunctions.GetFullResults(0, SQLConnection.ReadPersonTableCount(true)); // Should get it all.
            int maxIndex = multiModelList.Count - 1;

            output.Text =
                output.Text + message +
                Environment.NewLine +
                "First:" + multiModelList[0].Firstname + " | " +
                "Last:" + multiModelList[0].Lastname + " | " +
                "First:" + multiModelList[0].City + " | " +
                "First:" + multiModelList[0].Age + " | " +
                Environment.NewLine +
                "First:" + multiModelList[maxIndex].Firstname + " | " +
                "Last:" + multiModelList[maxIndex].Lastname + " | " +
                "First:" + multiModelList[maxIndex].City + " | " +
                "First:" + multiModelList[maxIndex].Age + " | " +
                Environment.NewLine + Environment.NewLine;
        }