mgpk-politex-zadania

1
using Microsoft.Toolkit.Uwp.UI.Controls;
2
using System;
3
using System.Collections.Generic;
4
using System.Collections.ObjectModel;
5
using System.Configuration;
6
using System.Data;
7
using System.Data.SqlClient;
8
using System.IO;
9
using System.Linq;
10
using System.Runtime.InteropServices.WindowsRuntime;
11
using Windows.ApplicationModel.Core;
12
using Windows.Foundation;
13
using Windows.Foundation.Collections;
14
using Windows.UI;
15
using Windows.UI.Popups;
16
using Windows.UI.ViewManagement;
17
using Windows.UI.Xaml;
18
using Windows.UI.Xaml.Controls;
19
using Windows.UI.Xaml.Controls.Primitives;
20
using Windows.UI.Xaml.Data;
21
using Windows.UI.Xaml.Input;
22
using Windows.UI.Xaml.Media;
23
using Windows.UI.Xaml.Navigation;
24

25
// The Blank Page item template is documented at https://go.microsoft.com/fwlink/?LinkId=234238
26

27
namespace UWPKursovayaAvtobus
28
{
29
    /// <summary>
30
    /// An empty page that can be used on its own or navigated to within a Frame.
31
    /// </summary>
32
    public sealed partial class Nav_deleters : Page
33
    {
34
        public Nav_deleters()
35
        {
36
            this.InitializeComponent();
37
        }
38

39
        private async void deleterbutton_Click(object sender, RoutedEventArgs e)
40
        {
41
            if (TableName.Text == "Prodazhi")
42
            {
43
                SqlConnection cnn;
44
                string conStr = ConnectionString.Constring;
45

46
                cnn = new SqlConnection(conStr);
47
                cnn.Open();
48
                Console.Write("OPENING DB CONNECTION!!! \n");
49
                var select = "DELETE FROM Prodazhi WHERE Num=@a2";
50
                var commandBuilder = new SqlCommand(select, cnn);
51
                commandBuilder.Parameters.AddWithValue("a2", keybox.Text);
52
                try
53
                {
54
                    commandBuilder.ExecuteNonQuery();
55
                    Console.WriteLine("Delete operation successful!");
56
                }
57
                catch (SqlException ex)
58
                {
59
                    var dialog = new ContentDialog()
60
                    {
61
                        Title = "An Exception has occured!",
62
                        Content = ex.Message,
63
                        CloseButtonText = "Ok"
64
                    };
65
                    await dialog.ShowAsync();
66
                }
67

68
            }
69
            else if (TableName.Text == "Marshuti")
70
            {
71
                SqlConnection cnn;
72
                string conStr = ConnectionString.Constring;
73

74
                cnn = new SqlConnection(conStr);
75
                cnn.Open();
76
                Console.Write("OPENING DB CONNECTION!!! \n");
77
                var select = "DELETE FROM Marshuti WHERE Nomer_Marshuta=@a2";
78
                var commandBuilder = new SqlCommand(select, cnn);
79
                commandBuilder.Parameters.AddWithValue("a2", keybox.Text);
80
                try
81
                {
82
                    commandBuilder.ExecuteNonQuery();
83
                    Console.WriteLine("Delete operation successful!");
84
                }
85
                catch (SqlException ex)
86
                {
87
                    var dialog = new ContentDialog()
88
                    {
89
                        Title = "An Exception has occured!",
90
                        Content = ex.Message,
91
                        CloseButtonText = "Ok"
92
                    };
93
                    await dialog.ShowAsync();
94
                }
95
            }
96
            else if (TableName.Text == "Maintenance")
97
            {
98
                SqlConnection cnn;
99
                string conStr = ConnectionString.Constring;
100

101
                cnn = new SqlConnection(conStr);
102
                cnn.Open();
103
                Console.Write("OPENING DB CONNECTION!!! \n");
104
                var select = "DELETE FROM Maintenance WHERE Num=@a2";
105
                var commandBuilder = new SqlCommand(select, cnn);
106
                commandBuilder.Parameters.AddWithValue("a2", keybox.Text);
107
                try
108
                {
109
                    commandBuilder.ExecuteNonQuery();
110
                    Console.WriteLine("Delete operation successful!");
111
                }
112
                catch (SqlException ex)
113
                {
114
                    var dialog = new ContentDialog()
115
                    {
116
                        Title = "An Exception has occured!",
117
                        Content = ex.Message,
118
                        CloseButtonText = "Ok"
119
                    };
120
                    await dialog.ShowAsync();
121
                }
122
            }
123
            else if (TableName.Text == "Employees")
124
            {
125
                SqlConnection cnn;
126
                string conStr = ConnectionString.Constring;
127

128
                cnn = new SqlConnection(conStr);
129
                cnn.Open();
130
                Console.Write("OPENING DB CONNECTION!!! \n");
131
                var select = "DELETE FROM Employees WHERE Num=@a2";
132
                var commandBuilder = new SqlCommand(select, cnn);
133
                commandBuilder.Parameters.AddWithValue("a2", keybox.Text);
134
                try
135
                {
136
                    commandBuilder.ExecuteNonQuery();
137
                    Console.WriteLine("Delete operation successful!");
138
                }
139
                catch (SqlException ex)
140
                {
141
                    var dialog = new ContentDialog()
142
                    {
143
                        Title = "An Exception has occured!",
144
                        Content = ex.Message,
145
                        CloseButtonText = "Ok"
146
                    };
147
                    await dialog.ShowAsync();
148
                }
149
            }
150
            else
151
            {
152
                
153
                var dialog = new ContentDialog()
154
                {
155
                    Title = "Введено не подходящее значение",
156
                    Content = "Введено неправильное имя таблицы!",
157
                    CloseButtonText = "Ok"
158
                };
159
                
160
                await dialog.ShowAsync();
161
            }
162
        }
163
    }
164
}
165