// create a function to insert a new client
public bool insertClient(String fname, String lname, String phone, String country)
{
MySqlCommand command = new MySqlCommand();
String insertQuery = "INSERT INTO `clients`(`first_name`, `last_name`, `phone`, `country`) VALUES (@fnm,@lnm,@phn,@cnt)";
command.CommandText = insertQuery;
command.Connection = conn.getConnection();
// @fnm,@lnm,@phn,@cnt
command.Parameters.Add("@fnm", MySqlDbType.VarChar).Value = fname;
command.Parameters.Add("@lnm", MySqlDbType.VarChar).Value = lname;
command.Parameters.Add("@phn", MySqlDbType.VarChar).Value = phone;
command.Parameters.Add("@cnt", MySqlDbType.VarChar).Value = country;
conn.openConnection();
if (command.ExecuteNonQuery() == 1)
{
conn.closeConnection();
return(true);
}
else
{
conn.closeConnection();
return(false);
}
}
//create a function to instert a new client
public bool insertClient(String fname, String lname, String phone, String country)
{
MySqlCommand command = new MySqlCommand();
String insertQuery = "INSERT INTO `client`(`first_name`, `last_name`, `phone`, `country`) VALUES (@fnm,@lnm,@phn,@cnt)";
command.CommandText = insertQuery;
command.Connection = conn.getConnection();
//@fnm,@lnm,@phn,@cnt
command.Parameters.Add("@fnm", MySqlDbType.VarChar).Value = fname;
command.Parameters.Add("@lnm", MySqlDbType.VarChar).Value = lname;
command.Parameters.Add("@phn", MySqlDbType.VarChar).Value = phone;
command.Parameters.Add("@cnt", MySqlDbType.VarChar).Value = country;
conn.openConnection();
//Phương thức ExecuteNonQuery nó chỉ trả về kết quả là số dòng dữ liệu bị ảnh hưởng
//Thường dùng khi insert,removed,edit,...
if (command.ExecuteNonQuery() == 1)
{
conn.closeConnection();
return(true);
}
else
{
conn.closeConnection();
return(false);
}
}
// create a function to get a list of room's type
public DataTable roomTypeList()
{
//Tạo đối tượng SqlCommand trong C# để truy vấn và cập nhật tới CSDL SQL Server
MySqlCommand command = new MySqlCommand("SELECT * FROM `rooms_category`", conn.getConnection());
//DataAdapter chính là cầu nối giữa Dataset và Datasource
MySqlDataAdapter adapter = new MySqlDataAdapter();
DataTable table = new DataTable();
//SelectCommand: Cho phép lấy thông tin từ nguồn dữ liệu về
adapter.SelectCommand = command;
adapter.Fill(table);
return(table);
}
private void buttonLogin_Click(object sender, EventArgs e)
{
CONNECT conn = new CONNECT();
DataTable table = new DataTable();
MySqlDataAdapter adapter = new MySqlDataAdapter();
MySqlCommand command = new MySqlCommand();
String query = "SELECT * FROM `users` WHERE `username`=@usn AND `password`=@pass";
command.CommandText = query;
command.Connection = conn.getConnection();
command.Parameters.Add("@usn", MySqlDbType.VarChar).Value = textBoxUsername.Text;
command.Parameters.Add("@pass", MySqlDbType.VarChar).Value = textBoxPassword.Text;
adapter.SelectCommand = command;
adapter.Fill(table);
//if the username and the password exists
if (table.Rows.Count > 0)
{
//show the main form
this.Hide();
Main_Form mform = new Main_Form();
mform.Show();
}
else
{
if (textBoxUsername.Text.Trim().Equals(""))
{
MessageBox.Show("Enter Your Username to Login", "Empty Username", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else if (textBoxPassword.Text.Trim().Equals(""))
{
MessageBox.Show("Enter Your Password to Login", "Empty PassWord", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
MessageBox.Show("This Username Or Password doesn't Exists", "Wrong Data", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
