private void btnThem_Click(object sender, EventArgs e)
{
PHONG p = new PHONG();
p.ma_phong = txtID.Text;
p.ten_phong = txtTenPhong.Text;
p.sdt = txtSDT.Text;
p.nguoi_quan_ly = txtQuanLy.Text;
string query = "INSERT into PHONG values ('" + p.ma_phong + "' , N'" +
p.ten_phong + "' , '" + p.sdt + "' , N'" + p.nguoi_quan_ly + "')";
sqlCnn.Open();
try
{
SqlCommand command = new SqlCommand(query, sqlCnn);
command.ExecuteNonQuery();
}
catch
{
MessageBox.Show("Không thể thêm phòng mời nhập lại", "Thông báo");
}
sqlCnn.Close();
showList();
}
private void loadCbbPhongBan()
{
string query = "SELECT * FROM phong";
sqlCnn.Open();
SqlCommand command = new SqlCommand(query, sqlCnn);
List <PHONG> lstP = new List <PHONG>();
DataTable data = new DataTable();
SqlDataAdapter adapter = new SqlDataAdapter(command);
adapter.Fill(data);
foreach (DataRow item in data.Rows)
{
PHONG p = new PHONG(item);
lstP.Add(p);
}
cbbPhongBan.DataSource = lstP;
cbbPhongBan.DisplayMember = "ten_phong";
sqlCnn.Close();
//sqlCnn.Open();
//string query1 = "SELECT * FROM PHONG WHERE ten_phong = N'" + cbbPhongBan.ValueMember + "'";
//MessageBox.Show(query1);
//SqlCommand command1 = new SqlCommand(query1, sqlCnn);
//try
//{
// SqlDataReader sqlDataReader = command1.ExecuteReader();
// txtMa_Phong.Text = sqlDataReader.GetString(1);
//}
//catch { }
//sqlCnn.Close();
}
private void cbbSearchPhong_SelectedIndexChanged(object sender, EventArgs e)
{
ComboBox cb = sender as ComboBox;
if (cb.SelectedValue != null)
{
try
{
PHONG p = cb.SelectedItem as PHONG;
string query = "SELECT thuc_tap.ma_tts,thuc_tap.ho_ten,thuc_tap.email,thuc_tap.DOB,thuc_tap.bat_dau_thuc_tap,thuc_tap.ket_thuc_thuc_tap,PHONG.ten_phong,thuc_tap.gioi_tinh FROM thuc_tap LEFT JOIN PHONG ON thuc_tap.ma_phong_thuc_tap = PHONG.ma_phong WHERE ma_phong = '" + p.ma_phong + "'";
sqlCnn.Open();
SqlCommand command = new SqlCommand(query, sqlCnn);
DataTable data = new DataTable();
SqlDataAdapter adapter = new SqlDataAdapter(command);
adapter.Fill(data);
sqlCnn.Close();
dgvThucTap.DataSource = data;
}
catch { }
}
}
private void cbbPhongBan_SelectedIndexChanged(object sender, EventArgs e)
{
ComboBox cb = sender as ComboBox;
if (cb.SelectedValue != null)
{
try
{
PHONG p = cb.SelectedItem as PHONG;
maphong = p.ma_phong;
}
catch { }
}
}
private void btnSua_Click(object sender, EventArgs e)
{
PHONG p = new PHONG();
p.ma_phong = txtID.Text;
p.ten_phong = txtTenPhong.Text;
p.sdt = txtSDT.Text;
p.nguoi_quan_ly = txtQuanLy.Text;
sqlCnn.Open();
string query = "UPDATE PHONG SET " +
"ten_phong = N'" + p.ten_phong + "' , " +
"sdt = '" + p.sdt + "' , " +
"nguoi_quan_ly = N'" + p.nguoi_quan_ly + "' " +
"WHERE ma_phong = '" + p.ma_phong + "'";
SqlCommand command = new SqlCommand(query, sqlCnn);
command.ExecuteNonQuery();
sqlCnn.Close();
showList();
}
private void loadCbbSearchPhong()
{
string query = "SELECT * FROM phong";
sqlCnn.Open();
SqlCommand command = new SqlCommand(query, sqlCnn);
List <PHONG> lstP = new List <PHONG>();
DataTable data = new DataTable();
SqlDataAdapter adapter = new SqlDataAdapter(command);
adapter.Fill(data);
foreach (DataRow item in data.Rows)
{
PHONG p = new PHONG(item);
lstP.Add(p);
}
cbbSearchPhong.DataSource = lstP;
cbbSearchPhong.DisplayMember = "ten_phong";
sqlCnn.Close();
}
