private void addBtn_Click(object sender, EventArgs e)
{
var userName = userNameTxt.Text;
if (db.GetData($"select * from NHANVIEN where NHANVIEN.tenDN='{userName}'").Rows.Count == 1)
{
alertLable.Visible = true;
return;
}
var password = passTxt.Text;
var name = nameTxt.Text;
var phoneNum = phoneTxt.Text;
var ID = IDTxt.Text;
var sex = !maleRad.Checked && femaleRad.Checked ? 1 : 0;
var DOB = birthDate.Value.ToString();
var role = roleBox.Text;
var roleID = roleBox.SelectedIndex;
var query = $"insert into NHANVIEN values ('{userName}', '{password}', N'{name}', {sex}, '{DOB}', '{phoneNum}', '{ID}', N'{role}', {roleID})";
db.Execute(query);
alertLable.Visible = false;
loadData();
}
private void acceptBtn_Click(object sender, EventArgs e)
{
string oldPass = oldPassTxt.Text.ToString();
string newPass = newPassTxt.Text.ToString();
string newPass2 = newPassTxt2.Text.ToString();
var row = db.GetData($"select * from NHANVIEN where tenDN='{username}' and matKhau='{oldPass}'").Rows;
if (row.Count == 1 && newPass.Equals(newPass2))
{
db.Execute($"update NHANVIEN set matKhau='{newPass}' where tenDN='{username}'");
alertLabel.Visible = true;
alertLabel.ForeColor = System.Drawing.Color.Green;
alertLabel.Text = "Thành Công";
}
if (row.Count == 0)
{
alertLabel.Text = "Sai Mật Khẩu";
alertLabel.Visible = true;
return;
}
else if (!newPass.Equals(newPass2))
{
alertLabel.Text = "Nhập lại không khớp";
alertLabel.Visible = true;
return;
}
}
private void saveBtn_Click(object sender, EventArgs e)
{
string roomID = IDTxt.Text;
if (db.GetData($"select * from PHONG where PHONG.maPhong='{roomID}'").Rows.Count != 1)
{
alertLabel.Visible = true;
return;
}
string roomType = roomTypeTxt.Text;
string price = priceTxt.Text;
int stateID = -1;
string roomState = "";
if (emptyRad.Checked)
{
stateID = 0;
roomState = "Trống";
}
else if (usingRad.Checked)
{
stateID = 1;
roomState = "Đang Dùng";
}
else
{
stateID = 2;
roomState = "Đang Sửa Chữa";
}
db.Execute($"update PHONG set tinhTrang=N'{roomState}', maTinhTrang={stateID}, giaPhong={price}, loaiPhong=N'{roomType}' where maPHong='{roomID}'");
alertLabel.Visible = false;
loadRoomList();
}
private void checkinBtn_Click(object sender, EventArgs e)
{
string roomID = roomIDTxt.Text;
var room = db.GetData($"select maTinhTrang from PHONG where maPHONG='{roomID}'").Rows;
if (room.Count != 0)
{
if (Convert.ToInt32(room[0].ItemArray[0]) != 0)
{
successLabel.Visible = false;
alertLabel.Visible = true;
return;
}
}
string customerName = nameTxt.Text;
string phoneNumber = phoneTxt.Text;
string personalID = IDTxt.Text;
if (customerName == "" || phoneNumber == "" || personalID == "")
{
inforAlertLabel.Visible = true;
return;
}
DateTime datetime = DateTime.Now;
var ticket = db.GetData($"select * from PHIEUDAT ORDER BY maPD DESC").Rows;
int maxID = 0;
if (ticket.Count != 0)
{
maxID = Convert.ToInt32(ticket[0].ItemArray[5]) + 1;
}
db.Execute($"insert into PHIEUDAT values ('{roomID}', '{datetime}', N'{customerName}', '{phoneNumber}', {personalID}, {maxID})");
db.Execute($"update PHONG set maTinhTrang=1, tinhTrang=N'Đang Dùng' where maPhong='{roomID}'");
loadList(roomList, "PHONG");
successLabel.Visible = true;
inforAlertLabel.Visible = false;
alertLabel.Visible = false;
}
