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