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 <NotifyModel> > GetDataSchool()
{
ValueDTO <NotifyModel> val = new ValueDTO <NotifyModel>();
DataTableSQL dtSql = await ExecuteQuery("SelectListThongBaoTruong");
if (dtSql.Error == 0)
{
foreach (DataRow dr in dtSql.Data.Rows)
{
val.ListT.Add(new NotifyModel(dr));
}
}
else
{
val.Error = dtSql.Error;
}
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 <ModelListStudent> > GetData(int IDClass)
{
ValueDTO <ModelListStudent> val = new ValueDTO <ModelListStudent>();
DataTableSQL dtSQL = await ExecuteQuery("SelectHocSinhTrongLop",
new SqlParameter("@IDLop", SqlDbType.Int) { Value = IDClass });
if (dtSQL.Error == 0)
{
foreach (DataRow dr in dtSQL.Data.Rows)
{
val.ListT.Add(new ModelListStudent(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 <NotifyModel> > GetDataStudent(int IDHocSinh)
{
ValueDTO <NotifyModel> val = new ValueDTO <NotifyModel>();
DataTableSQL dtSql = await ExecuteQuery("SelectListThongBaoHS",
new SqlParameter("@IDHocSinh", SqlDbType.Int) { Value = IDHocSinh });
if (dtSql.Error == 0)
{
foreach (DataRow dr in dtSql.Data.Rows)
{
val.ListT.Add(new NotifyModel(dr));
}
}
else
{
val.Error = dtSql.Error;
}
return(val);
}
public async Task <ValueDTO <ModelListTeacher> > GetData(int IDLop)
{
ValueDTO <ModelListTeacher> val = new ValueDTO <ModelListTeacher>();
DataTableSQL dtSQL = await ExecuteQuery("SelectThongTinGV",
new SqlParameter("@IDLop", SqlDbType.Int) { Value = IDLop });
if (dtSQL.Error == 0)
{
foreach (DataRow dr in dtSQL.Data.Rows)
{
val.ListT.Add(new ModelListTeacher(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 <TaiKhoan> > PostUserToDatabase(string NameUser, string PasswordUser)
{
ValueDTO <TaiKhoan> val = new ValueDTO <TaiKhoan>();
DataTableSQL dtSql = await ExecuteQuery("DangNhapPH",
new SqlParameter("@TaiKhoan", SqlDbType.VarChar) { Value = NameUser },
new SqlParameter("@MatKhau", SqlDbType.VarChar) { Value = PasswordUser });
if (dtSql.Error == 0)
{
foreach (DataRow dr in dtSql.Data.Rows)
{
val.ListT.Add(new TaiKhoan(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);
}
