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; }