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