public DataTable GetAllsinhvien(khoa khoa)
{
string sqlSelectSinhVien = @"SELECT sv.id ,
Masv ,
sv.Tensv ,
k.Tenkhoa ,
lp.Tenlop ,
( CASE sv.Gioitinh
WHEN 1 THEN N'Nam'
ELSE N'Nữ'
END ) AS Gioitinh ,
sv.Diachi,sv.Image
FROM dbo.SinhVien sv ,
dbo.Lop lp ,
dbo.Khoa k
WHERE sv.Malop = lp.Malop
AND lp.Makhoa = k.Makhoa AND k.Makhoa='" + khoa.MAKHOA + "'";
SqlConnection con = dc.getConnection();
adt = new SqlDataAdapter(sqlSelectSinhVien, con);
DataTable dt = new DataTable();
adt.Fill(dt);
return(dt);
}
public DataTable getAmin()
{
string selectAdmin = " SELECT * FROM dbo.Admin WHERE Tendangnhap='" + admin.TENDANGNHAP + "'AND Password='******'";
SqlConnection con = dc.getConnection();
adt = new SqlDataAdapter(selectAdmin, con);
con.Open();
DataTable dt = new DataTable();
adt.Fill(dt);
con.Close();
return(dt);
}
public DataTable getAllKhoa()
{
string sqlGetAllKhoa = "SELECT Makhoa,Tenkhoa FROM Khoa";
SqlConnection con = dc.getConnection();
adt = new SqlDataAdapter(sqlGetAllKhoa, con);
con.Open();
DataTable dt = new DataTable();
adt.Fill(dt);
con.Close();
return(dt);
}
public DataTable getAllLoaiMH()
{
string sqlselect = "SELECT Tenloaimh FROM Loaimonhoc";
SqlConnection con = dc.getConnection();
adt = new SqlDataAdapter(sqlselect, con);
DataTable dt = new DataTable();
adt.Fill(dt);
return(dt);
}
public DataTable getAllLop()
{
string sqlGetAllLop = "SELECT lp.id,lp.Malop,lp.Tenlop ,k.Tenkhoa FROM dbo.Lop lp,dbo.Khoa k WHERE lp.Makhoa=k.Makhoa";
SqlConnection con = dc.getConnection();
adt = new SqlDataAdapter(sqlGetAllLop, con);
con.Open();
DataTable dt = new DataTable();
adt.Fill(dt);
con.Close();
return(dt);
}
public DataTable laytatcalop(string khoa)
{
string sqlLaytatcalop = "SELECT Malop ,Tenlop FROM Lop WHERE Makhoa ='" + khoa + "'";
SqlConnection con = dc.getConnection();
adt = new SqlDataAdapter(sqlLaytatcalop, con);
con.Open();
DataTable dt = new DataTable();
adt.Fill(dt);
con.Close();
return(dt);
}