//public DataTable showdata()
//{
// return cnn.executeShowQuery("SELECT MaL, TenL, NienKhoa FROM [Lop]");
//}
public DataTable selectdata()
{
string query = string.Format("SELECT HoTen, TaiKhoan, Pass_Word, Quyen, TrangThai, NgayTao, NgayCapNhat FROM [User]");
SqlParameter[] sqlPara = new SqlParameter[0];
return(cnn.executeSelectQuery(query, sqlPara));
}
//public DataTable showdata()
//{
// return cnn.executeShowQuery("SELECT MaGV, TenGV, NgaySinh, GioiTinh, NoiSinh, DiaChi1, DiaChi2, SoDT1, SoDT2, NgayNhanViec, TrangThai FROM [GiaoVien]");
//}
public DataTable selectdata()
{
string query = string.Format("SELECT MaGV, TenGV, NgaySinh, GioiTinh, NoiSinh, DiaChi1, DiaChi2, SoDT1, SoDT2, NgayNhanViec, TrangThai, NgayTao, NgayCapNhat FROM GiaoVien");
SqlParameter[] sqlPara = new SqlParameter[0];
return(cnn.executeSelectQuery(query, sqlPara));
}
//public DataTable showdata()
//{
// return cnn.executeShowQuery("SELECT MaL, TenL, NienKhoa, MaGV, TrangThai, NgayTao, NgayCapNhat FROM [Lop]");
//}
public DataTable selectdata()
{
string query = string.Format("SELECT MaMH, TenMH, SoTC, BieuPhi, DonVi, TrangThai, NgayTao, NgayCapNhat FROM MonHoc");
SqlParameter[] sqlPara = new SqlParameter[0];
return(cnn.executeSelectQuery(query, sqlPara));
}
public DataTable selectdata()
{
string query = string.Format("SELECT MaL, TenL, NienKhoa, MaGV, TrangThai, NgayTao, NgayCapNhat FROM Lop");
SqlParameter[] sqlPara = new SqlParameter[0];
return(cnn.executeSelectQuery(query, sqlPara));
}
public DataTable selectdata()
{
string query = string.Format("SELECT MaSV, HoSV, TenSV, GioiTinh, NgaySinh, NoiSinh, DiaChi1, DiaChi2, SoDT, TenPH1, TenPH2, SoDTPH1, SoDTPH2, GhiChu, MaL, TrangThai, NgayTao, NgayCapNhat FROM SinhVien");
SqlParameter[] sqlPara = new SqlParameter[0];
return(cnn.executeSelectQuery(query, sqlPara));
}
public DataTable selectdata(string req)
{
string query = string.Format("SELECT id, MaL, MaSV, MaMH, MaGV, MaLD, Diem, TrangThai, NgayTao, NgayCapNhat FROM Diem WHERE MaL=@MaL AND MaSV=@MaSV AND MaMH=@MaMH AND MaGV=@MaGV AND MaLD=@MaLD");
SqlParameter[] sqlPara = new SqlParameter[5];
sqlPara[0] = new SqlParameter("@MaL", req);
sqlPara[1] = new SqlParameter("@MaSV", req);
sqlPara[2] = new SqlParameter("@MaMH", req);
sqlPara[3] = new SqlParameter("@MaGV", req);
sqlPara[4] = new SqlParameter("@MaLD", req);
return(cnn.executeSelectQuery(query, sqlPara));
}
