private void materialRaisedButton1_Click(object sender, EventArgs e) { if (comboBoxCMND.Text.Equals("") || comboBoxRoomId.Text.Equals("")) { MaterialMessageBox.Show("Bận cần điền đủ thông tin", "Thông báo"); } else { SqlConnection conn = new SqlConnection(Program.getConnectionString()); // exec stored proc SqlCommand cmd = conn.CreateCommand(); cmd.CommandText = "EXEC SP_ADDHOADON @CMND, @MAPT"; cmd.Parameters.Add("@CMND", SqlDbType.Char, 12).Value = comboBoxCMND.Text.ToString(); cmd.Parameters.Add("@MAPT", SqlDbType.NVarChar, 50).Value = comboBoxRoomId.Text.ToString(); conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); MaterialMessageBox.Show("Thêm hóa đơn thành công ♥", "Thông báo"); this.Close(); } }
private void getNameByCMND() { try { SqlConnection conn = new SqlConnection(Program.getConnectionString()); StringBuilder query = new StringBuilder(); // create query to get number of people in phong tro query.Clear(); query.Append("SELECT HOTEN FROM KHACHHANG WHERE CMND LIKE '"); query.Append(comboBoxCMND.Text); query.Append("'"); SqlCommand cmd = conn.CreateCommand(); cmd.CommandText = query.ToString(); //open connection conn.Open(); String name = Convert.ToString(cmd.ExecuteScalar()); conn.Close(); materialLabel3.Text = name; } catch (NullReferenceException e) { MaterialMessageBox.Show(e.Message, "Thông báo"); } }
private void materialRaisedButtonAddCustomer_Click(object sender, EventArgs e) { if (count >= max) { MaterialMessageBox.Show("Số người trong phòng đã đủ ", "Thông báo"); } else { AddKH kh = new AddKH(this); kh.ShowDialog(); } }
private void materialRaisedButtonLogin_Click(object sender, EventArgs e) { if (checkUsername(materialSingleLineTextFieldUserName.Text) == false || checkPassword(materialSingleLineTextFieldPassword.Text) == false) { MaterialMessageBox.Show("Wrong Structure", "Error"); } else { try { SqlConnection conn = new SqlConnection(Program.getConnectionString()); conn.Open(); StringBuilder query = new StringBuilder(); query.Append("SELECT ID FROM TAIKHOAN WHERE USERNAME = '******' AND PWD = '"); query.Append(materialSingleLineTextFieldPassword.Text.Trim()); query.Append("'"); SqlDataAdapter sda = new SqlDataAdapter(query.ToString(), conn); DataTable tbl = new DataTable(); sda.Fill(tbl); conn.Close(); if (tbl.Rows.Count == 1) { // get username for change password form userName = materialSingleLineTextFieldUserName.Text; NV nv = new NV(); this.Hide(); nv.ShowDialog(); this.Close(); } else { MaterialMessageBox.Show("Check your Username and Password", "ERROR"); } } catch (Exception ex) { MessageBox.Show(ex.Message); } } }
private void btnAdd_Click(object sender, EventArgs e) { if (price.Text.Equals("") || numberOfPeople.Text.Equals("") || description.Text.Equals("")) { MaterialMessageBox.Show("Bạn phải điền đầy đủ thông tin", "Thông báo"); } else { if (isUpdate == false) { SqlConnection conn = new SqlConnection(Program.getConnectionString()); SqlCommand cmd = conn.CreateCommand(); cmd.CommandText = "EXEC SP_ADDPHONGTRO @GIATHUE, @SONGUOI, @MOTA"; cmd.Parameters.Add("@GIATHUE", SqlDbType.Float).Value = price.Text.ToString(); cmd.Parameters.Add("@SONGUOI", SqlDbType.Int).Value = numberOfPeople.Text.ToString(); cmd.Parameters.Add("@MOTA", SqlDbType.NVarChar, 100).Value = description.Text.ToString(); conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); nv.RefeshListRoom(); MaterialMessageBox.Show("Thêm phòng thành công", "Thông báo"); this.Close(); } else { SqlConnection conn = new SqlConnection(Program.getConnectionString()); SqlCommand cmd = conn.CreateCommand(); cmd.CommandText = "EXEC SP_UPDATEPHONGTRO @GIATHUE, @SONGUOI, @MOTA, @MAPT"; cmd.Parameters.Add("@GIATHUE", SqlDbType.Float).Value = price.Text.ToString(); cmd.Parameters.Add("@SONGUOI", SqlDbType.Int).Value = numberOfPeople.Text.ToString(); cmd.Parameters.Add("@MOTA", SqlDbType.NVarChar, 100).Value = description.Text.ToString(); cmd.Parameters.Add("@MAPT", SqlDbType.Char, 5).Value = roomDAO.Id.ToString(); MessageBox.Show(cmd.CommandText); conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); nv.RefeshListRoom(); MaterialMessageBox.Show("Cập nhật phòng thành công", "Thông báo"); this.Close(); } } }
private void btnUpdate_Click(object sender, EventArgs e) { if (roomId.Text.Equals("") || name.Text.Equals("") || cmndOld.Text.Equals("") || phone.Text.Equals("")) { MaterialMessageBox.Show("Bạn phải điền đủ thông tin", "Thông báo"); } else { try { SqlConnection conn = new SqlConnection(Program.getConnectionString()); SqlCommand cmd = conn.CreateCommand(); cmd.CommandText = "EXEC SP_UPDATEKHACHHANG @OLDCMND, @NEWCMND, @HOTEN, @DIENTHOAI, @MAPT"; cmd.Parameters.Add("@OLDCMND", SqlDbType.Char, 12).Value = cmndOld.Text.ToString(); cmd.Parameters.Add("@NEWCMND", SqlDbType.Char, 12).Value = cmndNew.Text.ToString(); cmd.Parameters.Add("@HOTEN", SqlDbType.NVarChar, 50).Value = name.Text.ToString(); cmd.Parameters.Add("@DIENTHOAI", SqlDbType.VarChar, 15).Value = phone.Text.ToString(); cmd.Parameters.Add("@MAPT", SqlDbType.Char, 12).Value = roomId.Text.ToString(); //open connectin conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); // clear field roomId.Text = ""; name.Text = ""; cmndOld.Text = ""; cmndNew.Text = ""; phone.Text = ""; // render data materialListViewCustomer.Items.Clear(); customers.Clear(); RenderDataQLKH(); MaterialMessageBox.Show("Cập nhật thành công", "Thông báo"); } catch (SqlException se) { MaterialMessageBox.Show(se.Message, "Database error"); } } }
private void save_Click(object sender, EventArgs e) { // check valid data if (name.Text.Equals("") || phone.Text.Equals("") || cmnd.Text.Equals("")) { MessageBox.Show("Bạn cần điền đủ dữ liệu"); checkFocus(name); checkFocus(phone); checkFocus(cmnd); } else { try { SqlConnection conn = new SqlConnection(Program.getConnectionString()); // exec stored proc SqlCommand cmd = conn.CreateCommand(); cmd.CommandText = "EXEC SP_ADDKHACHHANG @CMND, @HOTEN, @DIENTHOAI, @MAPT"; cmd.Parameters.Add("@CMND", SqlDbType.Char, 12).Value = cmnd.Text.ToString(); cmd.Parameters.Add("@HOTEN", SqlDbType.NVarChar, 50).Value = name.Text.ToString(); cmd.Parameters.Add("@DIENTHOAI", SqlDbType.VarChar).Value = phone.Text.ToString(); cmd.Parameters.Add("@MAPT", SqlDbType.Char, 5).Value = cbRoomId.Text.ToString(); conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); MaterialMessageBox.Show("Thêm khách hàng thành công ♥", "Thông báo"); this.Close(); } catch (SqlException se) { MaterialMessageBox.Show(se.Message, "Database"); } } //refesh form room room.Reload(sender, e); }
private void materialRaisedButton1_Click(object sender, EventArgs e) { if (roomId.Text.Equals("") || name.Text.Equals("") || cmndOld.Text.Equals("") || phone.Text.Equals("")) { MaterialMessageBox.Show("Bạn chọn người xóa", "Thông báo"); } else { try { SqlConnection conn = new SqlConnection(Program.getConnectionString()); SqlCommand cmd = conn.CreateCommand(); cmd.CommandText = "EXEC SP_DELETEKHACHHANG @CMND"; cmd.Parameters.Add("@CMND", SqlDbType.Char, 12).Value = cmndOld.Text.ToString(); //open connectin conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); // clear field roomId.Text = ""; name.Text = ""; cmndOld.Text = ""; cmndNew.Text = ""; phone.Text = ""; // render data materialListViewCustomer.Items.Clear(); customers.Clear(); RenderDataQLKH(); MaterialMessageBox.Show("Xóa thành công", "Thông báo"); } catch (SqlException se) { MaterialMessageBox.Show(se.Message, "Database error"); } } }
private void submit_Click(object sender, EventArgs e) { if (userName.Text.Equals("") || email.Text.Equals("")) { CheckValid(userName); CheckValid(email); } else { // build query to check if user exists StringBuilder queryId = new StringBuilder(); queryId.Append("SELECT COUNT(*) FROM TAIKHOAN WHERE USERNAME LIKE '"); queryId.Append(userName.Text); queryId.Append("'"); // create connection SqlConnection conn = new SqlConnection(Program.getConnectionString()); SqlCommand cmd = conn.CreateCommand(); cmd.CommandText = queryId.ToString(); // execute command conn.Open(); String count = Convert.ToString(cmd.ExecuteScalar()); conn.Close(); if (count.Equals("0")) { MaterialMessageBox.Show("Không tìm thấy username hãy thử lại", "Thông báo"); userName.Focus(); } else { // build a random password StringBuilder passBuilder = new StringBuilder(); passBuilder.Append(RandomString(4, true)); passBuilder.Append(new Random().Next(1000, 9999)); passBuilder.Append(RandomString(2, false)); // build query to set new password StringBuilder query = new StringBuilder(); query.Append("UPDATE TAIKHOAN SET PWD = '"); query.Append(passBuilder); query.Append("'"); query.Append("WHERE USERNAME LIKE '"); query.Append(userName.Text); query.Append("'"); // create new query for command cmd.CommandText = query.ToString(); // open connection conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); // create mail message MailMessage msg = new MailMessage(); msg.From = new MailAddress("*****@*****.**"); msg.To.Add(email.Text); msg.Subject = "[RECOVER PASSWORD]"; msg.Body = ("userName : "******"<br>" + "Recovery password: "******"smtp.gmail.com"; // create Network Credential NetworkCredential ntwd = new NetworkCredential(); ntwd.UserName = "******"; ntwd.Password = "******"; // set specification for smtp client smt.UseDefaultCredentials = true; smt.Credentials = ntwd; smt.Port = 587; smt.EnableSsl = true; smt.Send(msg); MaterialMessageBox.Show("Mật khẩu khôi phục đã được gửi", "Thông báo"); this.Close(); } } }
private void submit_Click(object sender, EventArgs e) { if (oldPassword.Text.Equals("") || newPassword.Text.Equals("") || newPasswordConfirm.Text.Equals("")) { MessageBox.Show("Bạn chưa điền đủ thông tin vui lòng kiểm tra!"); checkFocus(oldPassword); checkFocus(newPassword); checkFocus(newPasswordConfirm); } else { StringBuilder query = new StringBuilder(); query.Append("SELECT COUNT(*) FROM TAIKHOAN WHERE USERNAME LIKE '"); query.Append(userName); query.Append("'"); query.Append("AND PWD LIKE '"); query.Append(oldPassword.Text); query.Append("'"); SqlConnection conn = new SqlConnection(Program.getConnectionString()); SqlCommand cmd = conn.CreateCommand(); cmd.CommandText = query.ToString(); conn.Open(); String count = Convert.ToString(cmd.ExecuteScalar()); conn.Close(); if (count.Equals("0")) { MaterialMessageBox.Show("Sai mật khẩu ☻", "Thông báo"); } else { if (oldPassword.Text.Equals(newPassword.Text)) { MaterialMessageBox.Show("Bạn nhập 2 mật khẩu trùng nhau", "Thông báo"); } else { if (newPassword.Text.Equals(newPasswordConfirm.Text)) { cmd.CommandText = "EXEC SP_CHANGEPASSWORD @OLDPASSWORD , @NEWPASSWORD , @USERNAME "; cmd.Parameters.Add("@OLDPASSWORD", SqlDbType.VarChar, 100).Value = oldPassword.Text.ToString(); cmd.Parameters.Add("@NEWPASSWORD", SqlDbType.VarChar, 100).Value = newPassword.Text.ToString(); cmd.Parameters.Add("@USERNAME", SqlDbType.VarChar, 100).Value = userName; conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); // clear field oldPassword.Text = ""; newPassword.Text = ""; newPasswordConfirm.Text = ""; this.Close(); MaterialMessageBox.Show("Mật khẩu đã được đổi", "Thông báo"); } } } } }