-
Notifications
You must be signed in to change notification settings - Fork 0
/
Stats.cs
46 lines (41 loc) · 1.51 KB
/
Stats.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
using System;
using System.Data.SqlClient;
using System.IO;
using System.Windows.Forms;
namespace VeggieHotel
{
public partial class Stats : Form
{
#region Variaveis
string cs = @"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=" + Path.GetFullPath(@"../..") + "\\BD_Hotel.mdf;Integrated Security=True;Connect Timeout=30";
SqlConnection sqlcon;
SqlCommand cmd;
#endregion
public Stats()
{
InitializeComponent();
}
private void Stats_Load(object sender, EventArgs e)
{
sqlcon = new SqlConnection(cs);
cmd = new SqlCommand("SELECT COUNT (*) FROM tbl_Reservas", sqlcon);
sqlcon.Open();
lbl_totalReservas.Text += cmd.ExecuteScalar();
sqlcon.Close();
sqlcon = new SqlConnection(cs);
cmd = new SqlCommand("SELECT COUNT (*) FROM tbl_Hospedes WHERE Status = '" + "Hospedado" + "'", sqlcon);
sqlcon.Open();
lbl_totalHospedes.Text += cmd.ExecuteScalar();
sqlcon.Close();
sqlcon = new SqlConnection(cs);
cmd = new SqlCommand("SELECT COUNT (*) FROM tbl_Hospedes WHERE Status = '" + "Checked-Out" + "'", sqlcon);
sqlcon.Open();
lbl_totalCheckOuts.Text += cmd.ExecuteScalar();
sqlcon.Close();
}
private void btn_OK_Click(object sender, EventArgs e)
{
this.Close();
}
}
}