public DataTable GetSchoolAdminTable(BCCityAdmin objCityAdmin)
{
_dt = DataAccessLayer.ExecuteStoredProcedureToRetDataTable(new SqlParameter[] { new SqlParameter("@SchoolAdminId", objCityAdmin.SchoolAdminId) },
"SP_GET_SCHOOLADMIN");
return(_dt);
}
public DataTable GetSchoolClassMaster(BCCityAdmin objCityAdmin)
{
_dt = DataAccessLayer.ExecuteStoredProcedureToRetDataTable(new SqlParameter[] { new SqlParameter("@CityAdminId", objCityAdmin.CityAdminId),
new SqlParameter("@CityId", objCityAdmin.CityId), new SqlParameter("@School", objCityAdmin.School) },
"sp_SchoolClassMaster");
return(_dt);
}
public DataTable GetClassParticipantsList(BCCityAdmin objCityAdmin)
{
_dt = DataAccessLayer.ExecuteStoredProcedureToRetDataTable(new SqlParameter[] { new SqlParameter("@ClassAdminId", objCityAdmin.ClassAdminId),
new SqlParameter("@classid", objCityAdmin.ClassId) },
"SP_GET_ClassParticipantsList");
return(_dt);
}
public DataTable GetSchoolMaster(BCCityAdmin objCityAdmin)
{
_dt = DataAccessLayer.ExecuteStoredProcedureToRetDataTable(new SqlParameter[] { new SqlParameter("@SchoolId", objCityAdmin.SchoolId),
new SqlParameter("@CityAdminId", objCityAdmin.CityAdminId), new SqlParameter("@CityId", objCityAdmin.CityId),
new SqlParameter("@SchoolName", objCityAdmin.School) },
"SP_GET_SCHOOL");
return(_dt);
}
public DataTable GetTestPlan(BCCityAdmin objCityAdmin)
{
_dt = DataAccessLayer.ExecuteStoredProcedureToRetDataTable(new SqlParameter[] {
new SqlParameter("@CityId", objCityAdmin.CityId),
new SqlParameter("@ClassId", objCityAdmin.ClassId)
},
"sp_TestReport");
return(_dt);
}
public DataTable GetSchoolMasterData(BCCityAdmin objCityAdmin)
{
try
{
_dt = DataAccessLayer.ExecuteStoredProcedureToRetDataTable(new SqlParameter[] {
new SqlParameter("@SchoolId", (objCityAdmin.SchoolId == 0 ? 0 : objCityAdmin.SchoolId)),
new SqlParameter("@CityAdminId", (objCityAdmin.CityAdminId == 0 ? 0 : objCityAdmin.CityAdminId)),
new SqlParameter("@CityId", (objCityAdmin.CityId == 0 ? 0 : objCityAdmin.CityId)),
new SqlParameter("@SchoolName", (objCityAdmin.School == null ? " " : objCityAdmin.School))
}
, "SP_GET_SCHOOL");
}
catch (Exception ex)
{
throw ex;
}
return(_dt);
}
public DataTable GetTestPlan(BCCityAdmin objCityAdmin)
{
_dt = DataAccessLayer.ExecuteStoredProcedureToRetDataTable(new SqlParameter[] {
new SqlParameter("@CityId", objCityAdmin.CityId),
new SqlParameter("@ClassId", objCityAdmin.ClassId)},
"sp_TestReport");
return _dt;
}
public DataTable GetSchoolMasterData(BCCityAdmin objCityAdmin)
{
try
{
_dt = DataAccessLayer.ExecuteStoredProcedureToRetDataTable(new SqlParameter[] {
new SqlParameter("@SchoolId", (objCityAdmin.SchoolId == 0 ? 0 : objCityAdmin.SchoolId)),
new SqlParameter("@CityAdminId", (objCityAdmin.CityAdminId == 0 ? 0 : objCityAdmin.CityAdminId)),
new SqlParameter("@CityId", (objCityAdmin.CityId == 0 ? 0 : objCityAdmin.CityId)),
new SqlParameter("@SchoolName", (objCityAdmin.School == null ? " " : objCityAdmin.School))
}
, "SP_GET_SCHOOL");
}
catch (Exception ex)
{
throw ex;
}
return _dt;
}
public DataTable GetSchoolMaster(BCCityAdmin objCityAdmin)
{
_dt = DataAccessLayer.ExecuteStoredProcedureToRetDataTable(new SqlParameter[] { new SqlParameter("@SchoolId", objCityAdmin.SchoolId),
new SqlParameter("@CityAdminId", objCityAdmin.CityAdminId),new SqlParameter("@CityId", objCityAdmin.CityId),
new SqlParameter("@SchoolName", objCityAdmin.School)},
"SP_GET_SCHOOL");
return _dt;
}
public DataTable GetSchoolClassMaster(BCCityAdmin objCityAdmin)
{
_dt = DataAccessLayer.ExecuteStoredProcedureToRetDataTable(new SqlParameter[] { new SqlParameter("@CityAdminId", objCityAdmin.CityAdminId),
new SqlParameter("@CityId", objCityAdmin.CityId),new SqlParameter("@School", objCityAdmin.School)},
"sp_SchoolClassMaster");
return _dt;
}
public DataTable GetSchoolAdminTable(BCCityAdmin objCityAdmin)
{
_dt = DataAccessLayer.ExecuteStoredProcedureToRetDataTable(new SqlParameter[] { new SqlParameter("@SchoolAdminId", objCityAdmin.SchoolAdminId) },
"SP_GET_SCHOOLADMIN");
return _dt;
}
public DataTable GetClassParticipantsList(BCCityAdmin objCityAdmin)
{
_dt = DataAccessLayer.ExecuteStoredProcedureToRetDataTable(new SqlParameter[] { new SqlParameter("@ClassAdminId", objCityAdmin.ClassAdminId),
new SqlParameter("@classid",objCityAdmin.ClassId) },
"SP_GET_ClassParticipantsList");
return _dt;
}