public DataTable GetDataLP_TenLP()
{
SqlConnection conn = ConnectDB.ConnectData();
ConnectDB.Open(conn);
try
{
string sql = "SELECT DISTINCT TenLP FROM LoaiPhong";
SqlCommand cmd = new SqlCommand(sql, conn);
SqlDataAdapter da = new SqlDataAdapter(cmd);
cmd.Dispose();
DataTable dt = new DataTable();
da.Fill(dt);
return(dt);
}
catch (Exception)
{
return(null);
}
finally
{
ConnectDB.Close(conn);
conn.Dispose();
}
}
public DataTable GetDataCSVC()
{
SqlConnection conn = ConnectDB.ConnectData();
ConnectDB.Open(conn);
try
{
string sql = "SELECT * FROM CoSoVatChat";
SqlCommand cmd = new SqlCommand(sql, conn);
SqlDataAdapter da = new SqlDataAdapter(cmd);
cmd.Dispose();
DataTable dt = new DataTable();
da.Fill(dt);
return(dt);
}
catch (Exception)
{
return(null);
}
finally
{
ConnectDB.Close(conn);
conn.Dispose();
}
}
public DataTable GetDataLP_fromIDPhong(string idPhong)
{
SqlConnection conn = ConnectDB.ConnectData();
ConnectDB.Open(conn);
try
{
string sql = "SELECT * FROM LoaiPhong WHERE IDLoaiPhong IN(SELECT MaLP FROM Phong WHERE IDPhong = N'" + idPhong + "')";
SqlCommand cmd = new SqlCommand(sql, conn);
SqlDataAdapter da = new SqlDataAdapter(cmd);
cmd.Dispose();
DataTable dt = new DataTable();
da.Fill(dt);
return(dt);
}
catch (Exception)
{
return(null);
}
finally
{
ConnectDB.Close(conn);
conn.Dispose();
}
}
public DataTable GetDataDP_fromMaKH(string maKH)
{
SqlConnection conn = ConnectDB.ConnectData();
ConnectDB.Open(conn);
try
{
string sql = "SELECT * FROM DatPhong WHERE MaKH = N'" + maKH + "' AND TinhTrang = 0";
SqlCommand cmd = new SqlCommand(sql, conn);
SqlDataAdapter da = new SqlDataAdapter(cmd);
cmd.Dispose();
DataTable dt = new DataTable();
da.Fill(dt);
return(dt);
}
catch (Exception)
{
return(null);
}
finally
{
ConnectDB.Close(conn);
conn.Dispose();
}
}
public string getChucVuNhanVien(string maNV)
{
string cv = "";
SqlConnection conn = ConnectDB.ConnectData();
ConnectDB.Open(conn);
try
{
string sql = "SELECT * FROM NhanVien where IDNhanVien = '" + maNV + "'";
SqlCommand cmd = new SqlCommand(sql, conn);
IDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
cv = dr["ChucVu"].ToString();
}
}
catch (Exception)
{
return(null);
}
finally
{
ConnectDB.Close(conn);
conn.Dispose();
}
return(cv);
}
public DataTable GetDataPhong_fromTenLP(string tenLP)
{
SqlConnection conn = ConnectDB.ConnectData();
ConnectDB.Open(conn);
try
{
string sql = "SELECT * FROM Phong WHERE MaLP IN (SELECT IDLoaiPhong FROM LoaiPhong WHERE TenLP = N'" + tenLP + "')";
SqlCommand cmd = new SqlCommand(sql, conn);
SqlDataAdapter da = new SqlDataAdapter(cmd);
cmd.Dispose();
DataTable dt = new DataTable();
da.Fill(dt);
return(dt);
}
catch (Exception)
{
return(null);
}
finally
{
ConnectDB.Close(conn);
conn.Dispose();
}
}
public object ExecuteScalar(string sql)
{
SqlConnection conn = ConnectDB.ConnectData();
ConnectDB.Open(conn);
try
{
SqlCommand cmd = new SqlCommand(sql, conn);
object value = cmd.ExecuteScalar();
cmd.Dispose();
return(value);
}
catch (Exception)
{
return(null);
}
finally
{
ConnectDB.Close(conn);
conn.Dispose();
}
}
public Boolean ExecuteData(string sql)
{
SqlConnection conn = ConnectDB.ConnectData();
ConnectDB.Open(conn);
try
{
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.ExecuteNonQuery();
cmd.Dispose();
return(true);
}
catch (Exception)
{
return(false);
}
finally
{
ConnectDB.Close(conn);
conn.Dispose();
}
}
public DataTable GetDataXe()
{
ConnectDB.Open(cnn);
try
{
string sql = "SELECT * FROM Xe";
SqlCommand cmd = new SqlCommand(sql, cnn);
SqlDataAdapter da = new SqlDataAdapter(cmd);
cmd.Dispose();
DataTable dt = new DataTable();
da.Fill(dt);
return(dt);
}
catch (Exception)
{
return(null);
}
finally
{
ConnectDB.Close(cnn);
}
}
public DataTable GetDataTP(string idThucPham)
{
SqlConnection conn = ConnectDB.ConnectData();
ConnectDB.Open(conn);
try
{
string sql = "SELECT * FROM ThucPham WHERE IDThucPham = N'" + idThucPham + "'";
SqlCommand cmd = new SqlCommand(sql, conn);
SqlDataAdapter da = new SqlDataAdapter(cmd);
cmd.Dispose();
DataTable dt = new DataTable();
da.Fill(dt);
return(dt);
}
catch (Exception)
{
return(null);
}
finally
{
ConnectDB.Close(conn);
}
}
