-
Notifications
You must be signed in to change notification settings - Fork 0
/
Bookingscs.cs
160 lines (143 loc) · 5.3 KB
/
Bookingscs.cs
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
using System;
using System.Data;
using System.Data.SqlClient;
using System.Windows.Forms;
namespace SteppingIntoHistoryFinal
{
public partial class Bookingscs : Form
{
public Bookingscs()
{
InitializeComponent();
GetService();
GetCustomer();
ResetData();
ShowBookings();
}
SqlConnection Con = new SqlConnection(@"Data Source = (LocalDB)\MSSQLLocalDB; AttachDbFilename=C:\Users\jqgas\OneDrive\Documents\SteppingIntoHistoryDataBase.mdf;Integrated Security = True; Connect Timeout = 30");
private void GetService()
{
Con.Open();
SqlCommand cmd = new SqlCommand("Select CategoryID from CategoryTable", Con);
SqlDataReader Rdr;
Rdr = cmd.ExecuteReader();
System.Data.DataTable dt = new DataTable();
dt.Columns.Add("CategoryID", typeof(int));
dt.Load(Rdr);
typeservice_comboBox1.DataSource = dt;
typeservice_comboBox1.ValueMember = "CategoryID";
typeservice_comboBox1.DisplayMember = "CategoryID";
Con.Close();
}
private void ShowBookings()
{
Con.Open();
string Query = "Select * from BookingsTable";
SqlDataAdapter sda = new SqlDataAdapter(Query, Con);
SqlCommandBuilder Builder = new SqlCommandBuilder(sda);
var ds = new System.Data.DataSet();
sda.Fill(ds);
booking_datagrid.DataSource = ds.Tables[0];
Con.Close();
}
private void GetCost()
{
Con.Open();
String Query = "Select * from CategoryTable where CategoryID =" + typeservice_comboBox1.SelectedValue.ToString() + "";
SqlCommand cmd = new SqlCommand(Query, Con);
DataTable dt = new DataTable();
SqlDataAdapter sda = new SqlDataAdapter(cmd);
sda.Fill(dt);
foreach (DataRow dr in dt.Rows)
{
Cost_textBox.Text = dr["CategoryCost"].ToString();
}
Con.Close();
}
private void GetCustomer()
{
Con.Open();
SqlCommand cmd = new SqlCommand("Select CustomerID from CustomerTable", Con);
SqlDataReader Rdr;
Rdr = cmd.ExecuteReader();
System.Data.DataTable dt = new DataTable();
dt.Columns.Add("CustomerID", typeof(int));
dt.Load(Rdr);
customer_comboBox2.DataSource = dt;
customer_comboBox2.ValueMember = "CustomerID";
customer_comboBox2.DisplayMember = "CustomerID";
Con.Close();
}
private void ResetData()
{
Cost_textBox.Text = "";
}
// Insert statement to allow user to insert new rows of data
private void book_bunifuThinButton27_Click(object sender, System.EventArgs e)
{
if (Cost_textBox.Text == "" || typeservice_comboBox1.SelectedIndex == -1 || customer_comboBox2.SelectedIndex == -1)
{
MessageBox.Show("Missing Information!");
}
else
{
try
{
string Period = bookingdate_picker.Value.Date.Month + "-" + bookingdate_picker.Value.Date.Year;
Con.Open();
SqlCommand cmd = new SqlCommand("Insert Into BookingsTable(ServiceType,Customer,BookingDate,Cost) values (@BS,@BC,@BD,@BCST)", Con);
cmd.Parameters.AddWithValue("@BS", typeservice_comboBox1.SelectedValue.ToString());
cmd.Parameters.AddWithValue("@BC", customer_comboBox2.SelectedValue.ToString());
cmd.Parameters.AddWithValue("@BD", Period);
cmd.Parameters.AddWithValue("@BCST", Cost_textBox.Text);
cmd.ExecuteNonQuery();
MessageBox.Show("Booking Added Successfully!");
Con.Close();
ResetData();
ShowBookings();
}
catch (Exception Ex)
{
MessageBox.Show(Ex.Message);
}
}
}
private void typeservice_comboBox1_SelectionChangeCommitted(object sender, EventArgs e)
{
GetCost();
}
private void bunifuThinButton24_Click(object sender, EventArgs e)
{
Types Obj = new Types();
Obj.Show();
this.Hide();
}
private void bunifuThinButton23_Click(object sender, EventArgs e)
{
Customer Obj = new Customer();
Obj.Show();
this.Hide();
}
private void Users_hinButton21_Click(object sender, EventArgs e)
{
Users Obj = new Users();
Obj.Show();
this.Hide();
}
private void bunifuThinButton26_Click(object sender, EventArgs e)
{
Services Obj = new Services();
Obj.Show();
this.Hide();
}
private void bunifuThinButton22_Click(object sender, EventArgs e)
{
LoginPage Obj = new LoginPage();
Obj.Show();
this.Hide();
}
}
internal class DataTable : System.Data.DataTable
{
}
}