public DataTable GetMcqList()
{
try
{
return(DBOperate.GetDataTable("usp_GetAllMcq"));
}
catch
{
throw;
}
}
public DataTable GetDiscountList()
{
try
{
return(DBOperate.GetDataTable("usp_GetAllDiscount"));
}
catch
{
throw;
}
}
public DataTable GetSubCourseList()
{
try
{
return(DBOperate.GetDataTable("usp_GetAllSubCourse"));
}
catch
{
throw;
}
}
public DataTable GetTestimonialList()
{
try
{
return(DBOperate.GetDataTable("usp_GetAllTestimonial"));
}
catch
{
throw;
}
}
public DataTable GetPaperList()
{
try
{
return(DBOperate.GetDataTable("usp_GetAllPaper"));
}
catch
{
throw;
}
}
public DataTable GetTopicList()
{
try
{
return(DBOperate.GetDataTable("usp_GetAllTopic"));
}
catch
{
throw;
}
}
public DataTable GetProductTypeList()
{
try
{
return(DBOperate.GetDataTable("usp_GetAllProductType"));
}
catch
{
throw;
}
}
public DataTable GetCurrencyList()
{
try
{
return(DBOperate.GetDataTable("usp_GetAllCurrency"));
}
catch
{
throw;
}
}
public DataTable GetGradeList()
{
try
{
return(DBOperate.GetDataTable("usp_GetAllGrade"));
}
catch
{
throw;
}
}
public DataTable GetSubCourseListWithCourseID(int ID)
{
try
{
SqlParameter[] parameter = new SqlParameter[]
{
new SqlParameter("@CourseID", ID)
};
return(DBOperate.GetDataTable("usp_GetSubCourseByCourseId", parameter));
}
catch
{
throw;
}
}
public DataTable GetTestimonialListWithID(int ID)
{
try
{
SqlParameter[] parameter = new SqlParameter[]
{
new SqlParameter("@TestimonialID", ID)
};
return(DBOperate.GetDataTable("usp_GetTestimonialById", parameter));
}
catch
{
throw;
}
}
public DataTable CheckAccess(string session)
{
try
{
SqlParameter[] parameter = new SqlParameter[]
{
new SqlParameter("@Session", session)
};
return(DBOperate.GetDataTable("usp_CheckAccess", parameter));
}
catch
{
throw;
}
}
public DataTable GetSubjectListWithTopicID(int ID)
{
try
{
SqlParameter[] parameter = new SqlParameter[]
{
new SqlParameter("@TopicID", ID)
};
return(DBOperate.GetDataTable("usp_GetSubjectByTopicId", parameter));
}
catch
{
throw;
}
}
public DataTable GetProductTypeListWithID(int ID)
{
try
{
SqlParameter[] parameter = new SqlParameter[]
{
new SqlParameter("@ProductTypeID", ID)
};
return(DBOperate.GetDataTable("usp_GetProductTypeById", parameter));
}
catch
{
throw;
}
}
public DataTable GetDiscountListWithID(int ID)
{
try
{
SqlParameter[] parameter = new SqlParameter[]
{
new SqlParameter("@DiscountID", ID)
};
return(DBOperate.GetDataTable("usp_GetDiscountById", parameter));
}
catch
{
throw;
}
}
public DataTable GetAnswerListWithMcqID(int ID)
{
try
{
SqlParameter[] parameter = new SqlParameter[]
{
new SqlParameter("@McqID", ID)
};
return(DBOperate.GetDataTable("usp_GetMcqAnwerByMcqId", parameter));
}
catch
{
throw;
}
}
public DataTable GetMcqListwithPaperID(int ID)
{
try
{
SqlParameter[] parameter = new SqlParameter[]
{
new SqlParameter("@PaperID", ID)
};
return(DBOperate.GetDataTable("usp_GetMcqByPaperId", parameter));
}
catch
{
throw;
}
}
public DataTable GetPaperListWithSubjectID(int ID)
{
try
{
SqlParameter[] parameter = new SqlParameter[]
{
new SqlParameter("@SubjectID", ID)
};
return(DBOperate.GetDataTable("usp_GetPaperBySubjectId", parameter));
}
catch
{
throw;
}
}
public DataTable GetCountryCode(int country)
{
try
{
SqlParameter[] parameter = new SqlParameter[]
{
new SqlParameter("@countryId", country)
};
return(DBOperate.GetDataTable("usp_GetCountryCode", parameter));
}
catch
{
throw;
}
}