public static STD_Question GetSTD_QuestionTypeByQuestionTypeID(int QuestionTypeID)
{
STD_Question sTD_Question = new STD_Question();
SqlSTD_QuestionProvider sqlSTD_QuestionProvider = new SqlSTD_QuestionProvider();
sTD_Question = sqlSTD_QuestionProvider.GetSTD_QuestionByQuestionTypeID(QuestionTypeID);
return sTD_Question;
}
public static DataSet GetDropDownListAllSTD_Question()
{
DataSet sTD_Questions = new DataSet();
SqlSTD_QuestionProvider sqlSTD_QuestionProvider = new SqlSTD_QuestionProvider();
sTD_Questions = sqlSTD_QuestionProvider.GetDropDownListAllSTD_Question();
return sTD_Questions;
}
public static DataSet GetAllSTD_QuestionsWithRelation()
{
DataSet sTD_Questions = new DataSet();
SqlSTD_QuestionProvider sqlSTD_QuestionProvider = new SqlSTD_QuestionProvider();
sTD_Questions = sqlSTD_QuestionProvider.GetAllSTD_Questions();
return sTD_Questions;
}
public static void LoadSTD_QuestionPage(System.Web.UI.WebControls.GridView gv, System.Web.UI.WebControls.Repeater rptPager, int pageIndex, DropDownList ddlPageSize)
{
int recordCount=0;
int PageSize = int.Parse(ddlPageSize.SelectedValue);
SqlSTD_QuestionProvider sqlSTD_QuestionProvider = new SqlSTD_QuestionProvider();
DataSet ds = sqlSTD_QuestionProvider.GetSTD_QuestionPageWise(pageIndex, PageSize, out recordCount);
gv.DataSource = ds;
gv.DataBind();
sTD_QuestionsPaggination(rptPager,recordCount, pageIndex, PageSize);
}
public static int InsertSTD_Question(STD_Question sTD_Question)
{
SqlSTD_QuestionProvider sqlSTD_QuestionProvider = new SqlSTD_QuestionProvider();
return sqlSTD_QuestionProvider.InsertSTD_Question(sTD_Question);
}
public static bool DeleteSTD_Question(int sTD_QuestionID)
{
SqlSTD_QuestionProvider sqlSTD_QuestionProvider = new SqlSTD_QuestionProvider();
return sqlSTD_QuestionProvider.DeleteSTD_Question(sTD_QuestionID);
}
public static bool UpdateSTD_Question(STD_Question sTD_Question)
{
SqlSTD_QuestionProvider sqlSTD_QuestionProvider = new SqlSTD_QuestionProvider();
return sqlSTD_QuestionProvider.UpdateSTD_Question(sTD_Question);
}