public void fillgrid(SqlCommand command)
{
dataGridView1.ReadOnly = true;
dataGridView1.RowTemplate.Height = 20;
dataGridView1.DataSource = phong.getshowkh(command);
dataGridView1.AllowUserToAddRows = false;
}
private void BaoCaoThang_Load(object sender, EventArgs e)
{
Phong phong = new Phong();
SqlCommand command = new SqlCommand("Select * from BaoCaoLuong ");
dataGridView1.ReadOnly = true;
dataGridView1.DataSource = phong.getshowkh(command);
dataGridView1.AllowUserToAddRows = false;
}
private void QuanLyPhong_Load(object sender, EventArgs e)
{
Phong phong = new Phong();
SqlCommand command = new SqlCommand("Select TenPhong,TrangThai,MKPhong from TTPhong ");
dataGridView1.ReadOnly = true;
dataGridView1.DataSource = phong.getshowkh(command);
dataGridView1.AllowUserToAddRows = false;
}
private void BaoCao_Load(object sender, EventArgs e)
{
Phong phong = new Phong();
SqlCommand command = new SqlCommand("Select Id,HoTen,GioBD,GioKT,ChucVu,CaLamViec from BaoCaoNgay");
dataGridView1.ReadOnly = true;
dataGridView1.DataSource = phong.getshowkh(command);
dataGridView1.AllowUserToAddRows = false;
}
private void button1_Click(object sender, EventArgs e)
{
Phong phong = new Phong();
LuongNV nv = new LuongNV();
SqlCommand command = new SqlCommand("Select HoTen,ChucVu,sum(Luong) as Luong from BaoCaoLuong where convert(char(7), GioKT,21)='2019-" + textBox1.Text + "' group by HoTen,ChucVu");
nv.dataGridViewLuong.ReadOnly = true;
nv.dataGridViewLuong.DataSource = phong.getshowkh(command);
nv.dataGridViewLuong.AllowUserToAddRows = false;
this.Close();
nv.Show();
}
private void TrPhong_Load(object sender, EventArgs e)
{
Phong phong = new Phong();
SqlCommand command = new SqlCommand("Select * from TTKH ");
dataGridViewKH.ReadOnly = true;
dataGridViewKH.DataSource = phong.getshowkh(command);
dataGridViewKH.AllowUserToAddRows = false;
comboBox1.DataSource = phong.getAllTraPhong();;
comboBox1.DisplayMember = "MaKH";
comboBox1.ValueMember = "MaKH";
comboBox1.SelectedItem = null;
}
private void NhanVienLeTan_Load(object sender, EventArgs e)
{
Phong phong = new Phong();
string cv = "LeTan ";
SqlCommand command = new SqlCommand("SELECT * FROM TTNV as a,Login as b where b.ChucVu like '" + cv + "%' and a.IdNhanVien = b.Id ");
dataGridViewManagerStudent.ReadOnly = true;
dataGridViewManagerStudent.DataSource = phong.getshowkh(command);
dataGridViewManagerStudent.AllowUserToAddRows = false;
ComboBoxCaDK.DataSource = NhanVien.getAllCalam();
ComboBoxCaDK.DisplayMember = "CaLamViec";
ComboBoxCaDK.ValueMember = "CaLamViec";
ComboBoxCaDK.SelectedItem = null;
}
private void ThongTinPhong_Load(object sender, EventArgs e)
{
Phong phong = new Phong();
SqlCommand command = new SqlCommand("Select * from ChiTietPhong ");
dataGridView1.ReadOnly = true;
dataGridView1.DataSource = phong.getshowkh(command);
dataGridView1.AllowUserToAddRows = false;
comboBoxRoomName.DataSource = phong.getDatPhong();
comboBoxRoomName.DisplayMember = "TenPhong";
comboBoxRoomName.ValueMember = "MaPhong";
comboBoxRoomName.SelectedItem = null;
}
private void Button1_Click(object sender, EventArgs e)
{
if ((TextBoxMaKH.Text.Trim() == ""))
{
MessageBox.Show("NhapID", " Add ", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
else
{
string id = TextBoxMaKH.Text;
string name = TextBoxNameKH.Text;
DateTime datebd = DatetimeBD.Value;
string phone = TextBoxPhone.Text;
string adrs = TextBoxDC.Text;
string LBGT = "Male";
int mk;
string TPhong = ComboBoxPhong.SelectedValue.ToString();
if (radioButtonFemale.Checked)
{
LBGT = "Female";
}
MemoryStream pic = new MemoryStream();
SqlCommand command5 = new SqlCommand("Select MKPhong From TTPhong where MaPhong like'" + TPhong + "%'");
DataTable table5 = phong.getshowkh(command5);
mk = (int)table5.Rows[0]["MKPhong"];
if (verif())
{
pictureBox1.Image.Save(pic, pictureBox1.Image.RawFormat);
if (phong.insertPhong(id, name, LBGT, adrs, phone, TPhong, datebd, pic))
{
phong.updateTPhong(TPhong);
phong.insertKHForQL(id, name, LBGT, adrs, phone, TPhong, datebd, pic);
MessageBox.Show("Thành Công", "Thêm Khách Hàng", MessageBoxButtons.OK, MessageBoxIcon.Information);
MessageBox.Show("Mật Khẩu Phòng là: " + mk, "Thêm Khách Hàng", MessageBoxButtons.OK);
Close();
}
else
{
MessageBox.Show("Thất Bại", "Thêm Khách Hàng", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
MessageBox.Show("Thiếu gì đó", "Thêm Khách Hàng", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
}
private void buttonTraPhong_Click(object sender, EventArgs e)
{
int Coca = (int)numericUpDownCOCA.Value;
int Tiger = (int)numericUpDownTiger.Value;
int Ruou = (int)numericUpDownRuou.Value;
int Mi = (int)numericUpDownMi.Value;
int Snack = (int)numericUpDownSncack.Value;
DateTime NgayKT = DateTime.Now;
int day = NgayKT.Day;
int month = NgayKT.Month;
int year = NgayKT.Year;
string MAKhach = comboBox1.SelectedValue.ToString();
DateTime NgayBD;
string MaPhong;
int tonggio;
int tongngay;
int vp1;
int vp2;
int vp3;
int vp4;
int vp5;
string tenPhong;
string TenKhang;
string DC;
string DT;
string GT;
string TP;
Random rb = new Random();
int mk = rb.Next(1, 99);
//
SqlCommand command5 = new SqlCommand("Select TenKH From TTKH where MaKH like '" + MAKhach + "%'");
DataTable table5 = phong.getshowkh(command5);
TenKhang = (string)table5.Rows[0]["TenKH"];
SqlCommand command6 = new SqlCommand("Select GioiTinh From TTKH where MaKH like '" + MAKhach + "%'");
DataTable table6 = phong.getshowkh(command6);
GT = (string)table6.Rows[0]["GioiTinh"];
SqlCommand command7 = new SqlCommand("Select DiaChi From TTKH where MaKH like '" + MAKhach + "%'");
DataTable table7 = phong.getshowkh(command7);
DC = (string)table7.Rows[0]["DiaChi"];
SqlCommand command8 = new SqlCommand("Select DienThoai From TTKH where MaKH like '" + MAKhach + "%'");
DataTable table8 = phong.getshowkh(command8);
DT = (string)table8.Rows[0]["DienThoai"];
SqlCommand command9 = new SqlCommand("Select ThuePhong From TTKH where MaKH like '" + MAKhach + "%'");
DataTable table9 = phong.getshowkh(command9);
TP = (string)table9.Rows[0]["ThuePhong"];
//
SqlCommand command1 = new SqlCommand("Select NgayBatDau From TTKH where MaKH like '" + MAKhach + "%'");
DataTable table1 = phong.getshowkh(command1);
NgayBD = (DateTime)table1.Rows[0]["NgayBatDau"];
SqlCommand command2 = new SqlCommand("Select ThuePhong From TTKH ");
DataTable table2 = phong.getshowkh(command2);
MaPhong = table2.Rows[0]["ThuePhong"].ToString();
SqlCommand command4 = new SqlCommand("Select * From ChiTietPhong where MaPhong like '" + MaPhong + "%'");
DataTable table4 = phong.getshowkh(command4);
vp1 = (int)table4.Rows[0]["VatPham1"];
vp2 = (int)table4.Rows[0]["VatPham2"];
vp3 = (int)table4.Rows[0]["VatPham3"];
vp4 = (int)table4.Rows[0]["VatPham4"];
vp5 = (int)table4.Rows[0]["VatPham5"];
tenPhong = table4.Rows[0]["TenPhong"].ToString();
SqlDataAdapter adapter1 = new SqlDataAdapter();
DataTable table3 = new DataTable();
SqlCommand command3 = new SqlCommand("Select * From TTKH WHERE @MA = MaKH", mydb.GetConnection);
command3.Parameters.Add("@MA", SqlDbType.VarChar).Value = MAKhach;
adapter1.SelectCommand = command3;
adapter1.Fill(table3);
TimeSpan tn = NgayKT - NgayBD;
HoaDon hd = new HoaDon();
if (Coca <= vp1 && Tiger <= vp2 && Snack <= vp3 && Ruou <= vp4 && Mi <= vp5)
{
vp1 = vp1 - Coca;
vp2 = vp2 - Tiger;
vp3 = vp3 - Snack;
vp4 = vp4 - Ruou;
vp5 = vp5 - Mi;
labelgio.Text = Convert.ToString(tn.Hours) + " Gio";
labelNgay.Text = Convert.ToString(tn.Days) + " Ngay";
labelTien.Text = Convert.ToString((tn.Days * 1000000) + (tn.Hours * (1000000 / 24)) + (Coca * 15000 + Snack * 10000 + Ruou * 200000 + Tiger * 20000 + Mi * 10000)) + " VNĐ";
int ThuNhap = Convert.ToInt32((tn.Days * 1000000) + (tn.Hours * (1000000 / 24)) + (Coca * 15000 + Snack * 10000 + Ruou * 200000 + Tiger * 20000 + Mi * 10000));
if (table3.Rows.Count <= 0)
{
MessageBox.Show("MA KHACH HANG CHUA DUOC DAT PHONG", " nhap lai", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
else if (phong.updateTraPhong(MaPhong, mk))
{
SqlDataAdapter adapter = new SqlDataAdapter();
DataTable table = new DataTable();
SqlCommand command = new SqlCommand("Select * From TTKH WHERE @MA = MaKH", mydb.GetConnection);
command.Parameters.Add("@MA", SqlDbType.VarChar).Value = MAKhach;
adapter.SelectCommand = command;
adapter.Fill(table);
fillgrid(command);
if (phong.updateNGayKT(MAKhach, NgayKT))
{
Global.SetGlobalUserId2(MAKhach);
phong.insertThuNhap(NgayKT, ThuNhap);
phong.updateNGayKTForQL(MAKhach, NgayKT);
phong.updateChitietPhong(MaPhong, tenPhong, vp1, vp2, vp3, vp4, vp5);
hd.TextBoxMaKHHD.Text = MAKhach;
hd.TextBoxNameKHHD.Text = TenKhang;
hd.TextBoxPhoneHD.Text = DT;
if (GT == "Female")
{
hd.radioButtonFemaleHD.Checked = true;
}
else
{
hd.radioButtonMaleHD.Checked = true;
}
hd.TextBoxTPHD.Text = TP;
hd.TextBoxDCHD.Text = DC;
hd.DatetimeNPHD.Value = NgayBD;
hd.DatetimeTPHD.Value = NgayKT;
hd.labelcoca.Text = "CoCaCoLa(15k/1): " + Convert.ToString(Coca);
hd.labelTB.Text = "Tiger Beer(20k/1): " + Convert.ToString(Coca);
hd.labels.Text = "Snack (10k/1): " + Convert.ToString(Snack);
hd.labelVK.Text = "Vodka (200k/1): " + Convert.ToString(Ruou);
hd.labelN.Text = "Noodles(10k/1): " + Convert.ToString(Mi);
hd.labeltien.Text = Convert.ToString((tn.Days * 1000000) + (tn.Hours * (1000000 / 24)) + (Coca * 15000 + Snack * 10000 + Ruou * 200000 + Tiger * 20000 + Mi * 10000)) + " VNĐ";
hd.labelgio.Text = Convert.ToString(tn.Hours) + " Gio";
hd.labelngay.Text = Convert.ToString(tn.Days) + " Ngay";
this.Close();
hd.Show();
}
else
{
MessageBox.Show("Lỗi Update", "Trả Phong", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
MessageBox.Show("Emty fields", " Thue Phong ", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
else
{
MessageBox.Show("So Luonng Vat Pham Nhap Vao La Sai Lech So Voi Vat Pham Trong Phong", " Nhap Lai ", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}