Esempio n. 1
0
 public void addRoom(Phong p)
 {
     ketnoi();
     cmd = new SqlCommand("INSERT INTO tblPhong VALUES(@SoPhong,@LoaiPhong,0)", conn);
     cmd.Parameters.AddWithValue("SoPhong", p.SoPhong);
     cmd.Parameters.AddWithValue("LoaiPhong", p.LoaiPhong);
     cmd.ExecuteNonQuery();
     dongketnoi();
 }
Esempio n. 2
0
 public void editRoom(string SoPhong, Phong p)
 {
     ketnoi();
     cmd = new SqlCommand("UPDATE tblPhong SET SoPhong=@SoPhong,LoaiPhong=@LoaiPhong WHERE SoPhong = @n", conn);
     cmd.Parameters.AddWithValue("SoPhong", p.SoPhong);
     cmd.Parameters.AddWithValue("LoaiPhong", p.LoaiPhong);
     cmd.Parameters.AddWithValue("n", SoPhong);
     cmd.ExecuteNonQuery();
     dongketnoi();
 }