public int checkmaKhoiHoc_ID(int makhoihoc)
{
SqlParameter[] parm = new SqlParameter[]
{
new SqlParameter(PARM_MAKHOIHOC, SqlDbType.Int)
};
parm[0].Value = makhoihoc;
return((int)DataAccessHelper.ExecuteScalar(DataAccessHelper.ConnectionString, CommandType.StoredProcedure, "tbl_KhoiHoc_Check", parm));
}
public int checkmaLoaiDiem_ID(int maloaidiem)
{
SqlParameter[] parm = new SqlParameter[]
{
new SqlParameter(PARM_MALOAIDIEM, SqlDbType.Int)
};
parm[0].Value = maloaidiem;
return((int)DataAccessHelper.ExecuteScalar(DataAccessHelper.ConnectionString, CommandType.StoredProcedure, "tbl_LoaiDiem_Check", parm));
}
public int checkmaGiaoVien_ID(int magiaovien)
{
SqlParameter[] parm = new SqlParameter[]
{
new SqlParameter(PARM_MAGIAOVIEN, SqlDbType.Int)
};
parm[0].Value = magiaovien;
return((int)DataAccessHelper.ExecuteScalar(DataAccessHelper.ConnectionString, CommandType.StoredProcedure, "tbl_GiaoVien_Check", parm));
}
public int checkmaDiem_ID(int mahocsinh)
{
SqlParameter[] parm = new SqlParameter[]
{
new SqlParameter(PARM_MAHOCSINH, SqlDbType.Int)
};
parm[0].Value = mahocsinh;
return((int)DataAccessHelper.ExecuteScalar(DataAccessHelper.ConnectionString, CommandType.StoredProcedure, "tbl_HocSinh_Check", parm));
}
public int getmaGiaoVien_Last()
{
return((int)DataAccessHelper.ExecuteScalar(DataAccessHelper.ConnectionString, CommandType.Text, "select top 1 magiaovien from tbl_GiaoVien order by magiaovien desc", null));
}
public int getmaLoaiDiem_Last()
{
return((int)DataAccessHelper.ExecuteScalar(DataAccessHelper.ConnectionString, CommandType.Text, "select top 1 maloaidiem from tbl_LoaiDiem order by maloaidiem desc", null));
}
public int getmaMonHoc_Last()
{
return((int)DataAccessHelper.ExecuteScalar(DataAccessHelper.ConnectionString, CommandType.Text, "select top 1 mamonhoc from tbl_MonHoc order by mamonhoc desc", null));
}
public int getmaDiem_Last()
{
return((int)DataAccessHelper.ExecuteScalar(DataAccessHelper.ConnectionString, CommandType.Text, "select top 1 Mahocsinh from tbl_HocSinh order by Mahocsinh desc", null));
}