public async Task <ValueDTO <HocPhi> > GetData(int Thang, int IDLoaiHocSinh, int IDKhoi, int NgayNghi)
{
ValueDTO <HocPhi> val = new ValueDTO <HocPhi>();
DataTableSQL dtSql = await ExecuteQuery("SelectChiTietTienHoc",
new SqlParameter("@Thang", SqlDbType.Int) { Value = Thang },
new SqlParameter("@IDLoaiHocSinh", SqlDbType.Int) { Value = IDLoaiHocSinh },
new SqlParameter("@IDKhoi", SqlDbType.Int) { Value = IDKhoi });
if (dtSql.Error == 0)
{
foreach (DataRow dr in dtSql.Data.Rows)
{
val.ListT.Add(new HocPhi(dr, NgayNghi));
}
}
return(val);
}
public async Task <ValueDTO <BangDiem> > GetData(int IDHocSinh)
{
ValueDTO <BangDiem> val = new ValueDTO <BangDiem>();
DataTableSQL dtSql = await ExecuteQuery("SelectBangDiemv2",
new SqlParameter("@IDHocSinh", SqlDbType.Int) { Value = IDHocSinh });
if (dtSql.Error == 0)
{
foreach (DataRow dr in dtSql.Data.Rows)
{
val.ListT.Add(new BangDiem(dr));
}
}
else
{
val.Error = dtSql.Error;
}
return(val);
}
public async Task <ValueDTO <XinPhep> > GetData(int IDStudent)
{
ValueDTO <XinPhep> val = new ValueDTO <XinPhep>();
DataTableSQL dtSql = await ExecuteQuery("SelectXinPhepTheoIDHS",
new SqlParameter("@IDHocSinh", SqlDbType.Int) { Value = IDStudent });
if (dtSql.Error == 0)
{
foreach (DataRow dr in dtSql.Data.Rows)
{
val.ListT.Add(new XinPhep(dr));
}
}
else
{
val.Error = dtSql.Error;
}
return(val);
}
public async Task <ValueDTO <ThongBaoTruong> > GetContent(int ID)
{
ValueDTO <ThongBaoTruong> val = new ValueDTO <ThongBaoTruong>();
DataTableSQL dtSql = await ExecuteQuery("SelectNoiDungThongBaoTruong",
new SqlParameter("@ID", SqlDbType.Int) { Value = ID });
if (dtSql.Error == 0)
{
foreach (DataRow dr in dtSql.Data.Rows)
{
val.ListT.Add(new ThongBaoTruong(dr));
}
}
else
{
val.Error = dtSql.Error;
}
return(val);
}
public async Task <ValueDTO <ThongBaoLop> > GetData()
{
ValueDTO <ThongBaoLop> val = new ValueDTO <ThongBaoLop>();
DataTableSQL dtSql = await ExecuteQuery("SelectThongBaoLop",
new SqlParameter("@ID", SqlDbType.Int) { Value = -1 });
if (dtSql.Error != 0)
{
foreach (DataRow dr in dtSql.Data.Rows)
{
val.ListT.Add(new ThongBaoLop(dr));
}
}
else
{
val.Error = dtSql.Error;
}
return(val);
}
public async Task <ValueDTO <LienKetPHvsHS> > GetData(int IDTaiKhoan)
{
ValueDTO <LienKetPHvsHS> val = new ValueDTO <LienKetPHvsHS>();
DataTableSQL dtSql = await ExecuteQuery("SelectLayHSQuanLy",
new SqlParameter("@IDTaiKhoan", SqlDbType.Int) { Value = IDTaiKhoan });
if (dtSql.Error == 0)
{
foreach (DataRow dr in dtSql.Data.Rows)
{
val.ListT.Add(new LienKetPHvsHS(dr));
}
}
else
{
val.Error = dtSql.Error;
}
return(val);
}
public async Task <ValueDTO <FunctionOrder> > GetData()
{
DataTableSQL dtSql = await ExecuteQuery("SelectFunctionOrder");
ValueDTO <FunctionOrder> val = new ValueDTO <FunctionOrder>();
if (dtSql.Error == 0)
{
foreach (DataRow dr in dtSql.Data.Rows)
{
val.ListT.Add(new FunctionOrder(dr));
}
}
else
{
val.Error = dtSql.Error;
}
return(val);
}
public async Task <ValueDTO <MonHoc> > GetData()
{
DataTableSQL dtSql = await ExecuteQuery("SelectMonhocv2");
ValueDTO <MonHoc> val = new ValueDTO <MonHoc>();
if (dtSql.Error == 0)
{
foreach (DataRow dr in dtSql.Data.Rows)
{
val.ListT.Add(new MonHoc(dr));
}
}
else
{
val.Error = dtSql.Error;
}
return(val);
}
public async Task <ValueDTO <ThoiKhoaBieu> > GetData(int IDLop)
{
DataTableSQL dtSql = await ExecuteQuery("m_SelectThoiKhoaBieu",
new SqlParameter("@IDLop", SqlDbType.Int) { Value = IDLop });
ValueDTO <ThoiKhoaBieu> val = new ValueDTO <ThoiKhoaBieu>();
if (dtSql.Error == 0)
{
foreach (DataRow dr in dtSql.Data.Rows)
{
val.ListT.Add(new ThoiKhoaBieu(dr));
}
}
else
{
val.Error = dtSql.Error;
}
return(val);
}
public async Task <ValueDTO <DTBTong> > GetData(int IDStudent, int IDClass)
{
ValueDTO <DTBTong> val = new ValueDTO <DTBTong>();
DataTableSQL dtSql = await ExecuteQuery("M_LayDTB",
new SqlParameter("@IDHocSinh", SqlDbType.Int) { Value = IDStudent },
new SqlParameter("@IDLop", SqlDbType.Int) { Value = IDClass });
if (dtSql.Error == 0)
{
foreach (DataRow dr in dtSql.Data.Rows)
{
val.ListT.Add(new DTBTong(dr));
}
}
else
{
val.Error = dtSql.Error;
}
return(val);
}