private void FillDetails()
{
string sql;
sql = "SELECT * FROM tbl_Skills";
dl_Skills.DataSource = c1.SelectDs(sql);
dl_Skills.DataBind();
}
private void FillNotification()
{
string str;
str = "select * from tbl_Notification ";
str = str + " WHERE EnableStatus =1 ";
dl_Notification.DataSource = c1.SelectDs(str);
dl_Notification.DataBind();
}
private void FillDateShow()
{
string sql;
sql = " select distinct ExamDate from tbl_Result";
ddl_Date.DataSource = c1.SelectDs(sql);
ddl_Date.DataTextField = "ExamDate";
ddl_Date.DataValueField = "ExamDate";
ddl_Date.DataBind();
ddl_Date.Items.Insert(0, new ListItem("--Select Date--", "0"));
}
protected void fill()
{
string sql;
sql = "SELECT *, '../'+PhotoUrl as PhotoUrl1 FROM tbl_Member WHERE ShortListed=1 ";
Repeater1.DataSource = c1.SelectDs(sql);
Repeater1.DataBind();
}
public void FillSubject()
{
string str;
str = "SELECT * FROM tbl_ContactUs ";
Repeater1.DataSource = c1.SelectDs(str);
Repeater1.DataBind();
}
public void FillSubject()
{
string str;
str = "SELECT '../'+PhotoUrl as PhotoUrl1 ,CASE EnableStatus WHEN 0 THEN 'Enable' ELSE 'Disable' END AS EnableStatus1, * FROM tbl_Member ";
Repeater1.DataSource = c1.SelectDs(str);
Repeater1.DataBind();
}
public void Filljobs()
{
string sql;
sql = "select CASE EnableStatus WHEN 0 THEN 'Enable' ELSE 'Disable' END AS EnableStatus1,* from tbl_JobPost";
sql = sql + " WHERE AdminId= " + Session["AdminId"].ToString();
Repeater1.DataSource = c1.SelectDs(sql);
Repeater1.DataBind();
}
private void FillCategory()
{
string sql;
sql = "select * from tbl_Category ";
//sql = sql + " WHERE EnableStatus =1 ";
ddl_CategoryAdd.DataSource = c1.SelectDs(sql);
ddl_CategoryAdd.DataTextField = "CategoryName";
ddl_CategoryAdd.DataValueField = "CategoryId";
ddl_CategoryAdd.DataBind();
ddl_CategoryAdd.Items.Insert(0, new ListItem("--Select Category--", "0"));
ddl_CategoryShow.DataSource = c1.SelectDs(sql);
ddl_CategoryShow.DataTextField = "CategoryName";
ddl_CategoryShow.DataValueField = "CategoryId";
ddl_CategoryShow.DataBind();
ddl_CategoryShow.Items.Insert(0, new ListItem("--Select Category--", "0"));
}
private void FillDetails()
{
string sql;
sql = "SELECT * FROM tbl_State";
ddl_State.DataSource = c1.SelectDs(sql);
ddl_State.DataTextField = "State_Name";
ddl_State.DataValueField = "State_Id";
ddl_State.DataBind();
ddl_State.Items.Insert(0, "Select State");
sql = "SELECT * FROM tbl_Industry";
ddl_Industry.DataSource = c1.SelectDs(sql);
ddl_Industry.DataTextField = "IndustryName";
ddl_Industry.DataValueField = "IndustryId";
ddl_Industry.DataBind();
ddl_Industry.Items.Insert(0, "Select Industry");
}
private void FillPaper()
{
string str;
str = "SELECT ResultId,Per, ExamDate, '10' as Questions, Correct, Wrong, NotAttempt, Marks ";
str = str + " FROM tbl_Result ";
str = str + " WHERE tbl_Result.EmailId='" + Session["EmailId"].ToString() + "'";
str = str + " ORDER BY ResultId DESC";
Repeater1.DataSource = c1.SelectDs(str);
Repeater1.DataBind();
}
public void FillCategory()
{
string str;
str = "SELECT CASE EnableStatus WHEN 0 THEN 'Enable' ELSE 'Disable' END AS EnableStatus1, SkillWeight, SkillId, SkillName FROM tbl_Skills ";
//if (Session["AdminId"].ToString() != "1")
// str = str + " and AdminId=" + Session["AdminId"].ToString();
Repeater1.DataSource = c1.SelectDs(str);
Repeater1.DataBind();
}
private void FillDetails()
{
string sql;
DataSet ds = new DataSet();
sql = "SELECT * FROM tbl_Privacy ";
ds = c1.SelectDs(sql);
if (ds.Tables[0].Rows.Count > 0)
{
lbl_AboutUs.Text = ds.Tables[0].Rows[0]["Privacy"].ToString();
}
}
public void FillPaper()
{
string str;
if (ddl_SubjectShow.SelectedIndex > -1)
{
str = "SELECT CASE EnableStatus WHEN 0 THEN 'Enable' ELSE 'Disable' END AS EnableStatus1, * FROM tbl_Paper WHERE SubjectId=" + ddl_SubjectShow.SelectedValue.ToString();
//if (Session["AdminId"].ToString() != "1")
// str = str + " and AdminId=" + Session["AdminId"].ToString();
Repeater1.DataSource = c1.SelectDs(str);
Repeater1.DataBind();
}
}
public void FillSubject()
{
string str;
str = "SELECT CASE EnableStatus WHEN 0 THEN 'Enable' ELSE 'Disable' END AS EnableStatus1, Url, Notification,NDate, Id1 FROM tbl_Notification where Id1 > 0 ";
if (Session["AdminId"].ToString() != "1")
{
str = str + " and AdminId=" + Session["AdminId"].ToString();
}
Repeater1.DataSource = c1.SelectDs(str);
Repeater1.DataBind();
}
public void FillPaper()
{
string str, sql;
int cnt;
str = "SELECT *,'../'+ PhotoUrl as PhotoUrl1 FROM tbl_TestInstruction where Id1 > 0 ";
if (Session["AdminId"].ToString() != "1")
{
str = str + " and AdminId=" + Session["AdminId"].ToString();
}
Repeater1.DataSource = c1.SelectDs(str);
Repeater1.DataBind();
}
public void FillQuestion()
{
string str, sql;
int cnt;
if (lbl_PaperId.Text != "")
{
str = " SELECT Question_Url AS Question_Url1, Explanation_Url AS Explanation_Url1 , tbl_Question.*, tbl_ResultDetails.Answer as GivenAnswer FROM tbl_Result, tbl_ResultDetails , tbl_Question ";
str = str + " WHERE tbl_Result.ResultId = tbl_ResultDetails.ResultId ";
str = str + " and tbl_ResultDetails.QuestionId = tbl_Question.QuestionId ";
str = str + " and EmailId='" + Session["EmailId"].ToString() + "' ";
str = str + " and tbl_Result.ResultId=" + lbl_PaperId.Text;
Repeater1.DataSource = c1.SelectDs(str);
Repeater1.DataBind();
}
}
public void FillQuestion()
{
string str = "";
int cnt;
if (ddl_PaperShow.SelectedIndex > 0)
{
str = " select *,'../'+Question_Url AS PhotoUrl from tbl_Question, tbl_PaperSet";
str = str + " where tbl_Question.QuestionId= tbl_PaperSet.QuestionId";
str = str + " and PaperId=" + ddl_PaperShow.SelectedValue.ToString();
if (ddl_CategoryShow.SelectedIndex > 0)
{
str = str + " and QuestionCategoryId=" + ddl_CategoryShow.SelectedValue.ToString();
}
if (ddl_DifficultyLevel_Show.SelectedIndex > 0)
{
str = str + " and DifficultyLevel=" + ddl_DifficultyLevel_Show.SelectedValue.ToString();
}
Repeater1.DataSource = c1.SelectDs(str);
Repeater1.DataBind();
}
}
private void FillDetails()
{
string str;
DataSet ds = new DataSet();
str = " SELECT *, Questions*QuestionMArks as MaxMarks FROM tbl_Paper ";
str = str + " WHERE PaperId=" + Session["PaperId"].ToString();
ds = c1.SelectDs(str);
if (ds.Tables[0].Rows.Count > 0)
{
lbl_PaperName.Text = ds.Tables[0].Rows[0]["PaperName"].ToString();
lbl_MaxMarks.Text = ds.Tables[0].Rows[0]["MaxMarks"].ToString();
//lbl_TotalTime.Text = rd["MinTime"].ToString();
lbl_Timer.Text = ds.Tables[0].Rows[0]["MinTime"].ToString();
//lbl_PaperType.Text = rd["TestTypeId"].ToString();
}
}
private void FillDetails()
{
string sql;
//FillBoard
sql = "SELECT * FROM tbl_Board";
ddl_Sec_Board.DataSource = c1.SelectDs(sql);
ddl_Sec_Board.DataTextField = "Board_Name";
ddl_Sec_Board.DataValueField = "Board_ID";
ddl_Sec_Board.DataBind();
ddl_Sec_Board.Items.Insert(0, "Select Board Name");
ddl_SrSec_Board.DataSource = c1.SelectDs(sql);
ddl_SrSec_Board.DataTextField = "Board_Name";
ddl_SrSec_Board.DataValueField = "Board_Id";
ddl_SrSec_Board.DataBind();
ddl_SrSec_Board.Items.Insert(0, "Select Board Name");
//Fill University
sql = "SELECT * FROM tbl_Uni";
ddl_Graduation_Uni.DataSource = c1.SelectDs(sql);
ddl_Graduation_Uni.DataTextField = "Uni_Name";
ddl_Graduation_Uni.DataValueField = "Uni_Id";
ddl_Graduation_Uni.DataBind();
ddl_Graduation_Uni.Items.Insert(0, "Select University");
ddl_PG_Uni.DataSource = c1.SelectDs(sql);
ddl_PG_Uni.DataTextField = "Uni_Name";
ddl_PG_Uni.DataValueField = "Uni_Id";
ddl_PG_Uni.DataBind();
ddl_PG_Uni.Items.Insert(0, "Select University");
ddl_Other_Uni.DataSource = c1.SelectDs(sql);
ddl_Other_Uni.DataTextField = "Uni_Name";
ddl_Other_Uni.DataValueField = "Uni_Id";
ddl_Other_Uni.DataBind();
ddl_Other_Uni.Items.Insert(0, "Select University");
//Fill State
sql = "SELECT * FROM tbl_State";
ddl_StatePersonal.DataSource = c1.SelectDs(sql);
ddl_StatePersonal.DataTextField = "State_Name";
ddl_StatePersonal.DataValueField = "State_Id";
ddl_StatePersonal.DataBind();
ddl_StatePersonal.Items.Insert(0, "Select State");
ddl_Desired_State.DataSource = c1.SelectDs(sql);
ddl_Desired_State.DataTextField = "State_Name";
ddl_Desired_State.DataValueField = "State_Id";
ddl_Desired_State.DataBind();
ddl_Desired_State.Items.Insert(0, "Select State");
//Fill Industry
sql = "SELECT * FROM tbl_Industry";
ddl_Industry.DataSource = c1.SelectDs(sql);
ddl_Industry.DataTextField = "IndustryName";
ddl_Industry.DataValueField = "IndustryId";
ddl_Industry.DataBind();
ddl_Industry.Items.Insert(0, "Select Industry");
}