private void FillQuestion1()
{
int i, n;
string str;
str = " SELECT top 10 QuestionId, ROW_NUMBER() OVER(ORDER BY (SELECT 1)) AS RowNo, '0' As SelectedAnswer, '9' As Result, '0' as Review, ";
str = str + " Answer, Question_Url, Question_Type, Question_Text, Explanation_Text, ";
str = str + " Explanation_Url, Explanation_Type, ";
str = str + " 'Test ' as PaperName, '10' as Questions ,'20' as MaxMarks, '10' as MinTime, '2' as QuestionMarks, '.25' as NegativeMarks ";
str = str + " FROM tbl_Question ";
str = str + " ORDER BY newid() ASC ";
DataTable dt;
DataTable dt1;
dt1 = c1.SelectDT(str);
dt = dt1.AsEnumerable().OrderRandomly().CopyToDataTable();
//dt.DefaultView.Sort = "QuestionCategoryId ASC";
dt = dt.DefaultView.ToTable();
n = dt.Rows.Count;
for (i = 0; i < n; i++)
{
dt.Rows[i]["RowNo"] = (i + 1).ToString();
}
DataColumn[] keyColumns = new DataColumn[1];
keyColumns[0] = dt.Columns["QuestionId"];
dt.PrimaryKey = keyColumns;
Session["AllQuestion"] = dt;
//DataTable dt = Session["AllQuestion"] as DataTable;
if (dt.Rows.Count > 0)
{
lbl_PaperName.Text = dt.Rows[0]["PaperName"].ToString();
lbl_MaxMarks.Text = dt.Rows[0]["MaxMarks"].ToString();
lbl_Timer.Text = dt.Rows[0]["MinTime"].ToString();
lbl_MarksPerQuestion.Text = dt.Rows[0]["QuestionMarks"].ToString();
lbl_NegativeMarks.Text = dt.Rows[0]["NegativeMarks"].ToString();
lbl_TotalQuestions.Text = dt.Rows.Count.ToString();
lbl_Attempted.Text = "0";
lbl_NotAttempted.Text = dt.Rows.Count.ToString();
fillQuestionFromCategory();
}
}
private void Filldata()
{
string sql;
DataTable dr;
sql = "Select * From tbl_Member Where MemberId='" + Session["MemberId"].ToString() + "'";
dr = c1.SelectDT(sql);
if (dr.Rows.Count > 0)
{
img_Member.Src = dr.Rows[0]["PhotoUrl"].ToString();
txt_ContactNo.Text = dr.Rows[0]["ContactNo"].ToString();
txt_Email.Text = dr.Rows[0]["EmailId"].ToString();
txt_Name.Text = dr.Rows[0]["MemberName"].ToString();
}
c1.SetLoginDetails(txt_Email.Text);
}
protected void Repeater1_ItemCommand(object source, RepeaterCommandEventArgs e)
{
string str;
lbl_Id.Text = ((Label)Repeater1.Items[e.Item.ItemIndex].FindControl("lbl_Id")).Text;
if (e.CommandName == "Delete")
{
str = "DELETE from tbl_JobPost where JobId=" + lbl_Id.Text;
c1.ExecuteQry(str);
Filljobs();
}
else if (e.CommandName == "Edit")
{
lbl_Opr.Text = "Edit";
String sql;
DataTable tb;
sql = "SELECT * FROM tbl_JobPost where JobId=" + lbl_Id.Text;
tb = c1.SelectDT(sql);
txt_Title.Text = tb.Rows[0]["Title"].ToString();
txt_Skills.Text = tb.Rows[0]["Skills"].ToString();
txt_Sallery.Text = tb.Rows[0]["Salary"].ToString();
txt_Qualification.Text = tb.Rows[0]["Qualification"].ToString();
txt_Experience.Text = tb.Rows[0]["Experience"].ToString();
txt_Description.Text = tb.Rows[0]["Description"].ToString();
txt_PostDate.Text = tb.Rows[0]["PostDate"].ToString();
txt_LastDate.Text = tb.Rows[0]["LastDate"].ToString();
MultiView1.ActiveViewIndex = 1;
}
else if (e.CommandName == "EnableStatus")
{
if (((LinkButton)Repeater1.Items[e.Item.ItemIndex].FindControl("lnk_Status")).Text == "Enable")
{
str = "update tbl_JobPost set EnableStatus=1";
str = str + " WHERE JobId=" + lbl_Id.Text;
}
else
{
str = "update tbl_JobPost set EnableStatus=0";
str = str + " WHERE JobId=" + lbl_Id.Text;
}
c1.ExecuteQry(str);
Filljobs();
}
}
protected void Repeater1_ItemCommand(object source, RepeaterCommandEventArgs e)
{
string str, id;
lbl_Id.Text = ((Label)Repeater1.Items[e.Item.ItemIndex].FindControl("lbl_Id")).Text;
if (e.CommandName == "Delete")
{
str = "delete from tbl_Member where MemberId=" + lbl_Id.Text;
c1.ExecuteQry(str);
FillSubject();
}
else if (e.CommandName == "Edit")
{
lbl_Opr.Text = "Edit";
//ddl_MemberTypeReg.Visible = false;
String sql;
DataTable tb;
sql = "SELECT * FROM tbl_Member where MemberId=" + lbl_Id.Text;
tb = c1.SelectDT(sql);
txt_ContactNo.Text = tb.Rows[0]["ContactNo"].ToString();
txt_EmailID.Text = tb.Rows[0]["EmailId"].ToString();
txt_MemberName.Text = tb.Rows[0]["MemberName"].ToString();
txt_Password.Text = tb.Rows[0]["Password"].ToString();
MultiView1.ActiveViewIndex = 1;
}
else if (e.CommandName == "EnableStatus")
{
if (((LinkButton)Repeater1.Items[e.Item.ItemIndex].FindControl("lnk_Status")).Text == "Enable")
{
str = "update tbl_Member set EnableStatus=1";
str = str + " WHERE MemberId=" + lbl_Id.Text;
}
else
{
str = "update tbl_Member set EnableStatus=0";
str = str + " WHERE MemberId=" + lbl_Id.Text;
}
c1.ExecuteQry(str);
FillSubject();
}
}
protected void lnk_ForgetPassword_Click(object sender, EventArgs e)
{
String sql, cnt, Msg;
DataTable dr;
sql = " SELECT * FROM tbl_Member WHERE EmailId='" + txt_MailForgetPass.Text + "'";
dr = c1.SelectDT(sql);
if (dr.Rows.Count == 0)
{
lbl_Msg.Text = "This EmailId is Not Registered.";
}
else
{
Msg = "Your Password is " + dr.Rows[0]["Password"].ToString();
c1.SendMailHTMLGmail(txt_MailForgetPass.Text, "Your Password ", Msg);
lbl_Msg.Text = "Your Password is sent";
}
}
protected void Repeater1_ItemCommand(object source, RepeaterCommandEventArgs e)
{
ListItem itm = new ListItem();
ListItem pprType = new ListItem();
string str, id, InstructionId, PaperType;
lbl_Id.Text = ((Label)Repeater1.Items[e.Item.ItemIndex].FindControl("lbl_Id")).Text;
if (e.CommandName == "Delete")
{
str = "delete from tbl_paper where CategoryId=" + lbl_Id.Text;
c1.ExecuteQry(str);
FillPaper();
}
else if (e.CommandName == "Edit")
{
txt_PaperName.Text = ((Label)Repeater1.Items[e.Item.ItemIndex].FindControl("lbl_CategoryName")).Text;
txt_Description.Text = ((Label)Repeater1.Items[e.Item.ItemIndex].FindControl("lbl_Description")).Text;
txt_PaperTime.Text = ((Label)Repeater1.Items[e.Item.ItemIndex].FindControl("lbl_PaperTime")).Text;
txt_QuestionMarks.Text = ((Label)Repeater1.Items[e.Item.ItemIndex].FindControl("lbl_QuestionMarks")).Text;
txt_NegativeMarks.Text = ((Label)Repeater1.Items[e.Item.ItemIndex].FindControl("lbl_NegativeMarks")).Text;
txt_PaperTime.Text = ((Label)Repeater1.Items[e.Item.ItemIndex].FindControl("lbl_PaperTime")).Text;
InstructionId = ((Label)Repeater1.Items[e.Item.ItemIndex].FindControl("lbl_InstructionId")).Text;
PaperType = ((Label)Repeater1.Items[e.Item.ItemIndex].FindControl("lbl_PaperType")).Text;
ddl_StreamAdd.SelectedIndex = ddl_StreamShow.SelectedIndex;
FillSubjectAdd();
ddl_SubjectAdd.SelectedIndex = ddl_SubjectShow.SelectedIndex;
itm = ddl_InstructionAdd.Items.FindByValue(InstructionId);
if (itm != null)
{
ddl_InstructionAdd.SelectedValue = InstructionId;
}
pprType = dl_PaperType.Items.FindByValue(PaperType);
if (pprType != null)
{
dl_PaperType.SelectedValue = PaperType;
}
FillCategoryAdd();
string Sql = "SELECT tbl_Category.CategoryId, CategoryName, EasyQuestion ,ModQuestion,DifQuestion, (tbl_PaperQuestionCategory.EasyQuestion +tbl_PaperQuestionCategory.ModQuestion+tbl_PaperQuestionCategory.DifQuestion) as TotalQuestion ,tbl_Category.CategoryName as CategoryName FROM tbl_PaperQuestionCategory,tbl_Category";
Sql = Sql + " WHERE tbl_Category.CategoryId= tbl_PaperQuestionCategory.CategoryId And tbl_PaperQuestionCategory.PaperId=" + lbl_Id.Text;
grd_Category.DataSource = c1.SelectDs(Sql);
grd_Category.DataBind();
DataTable dtItem = (DataTable)Session["Category"];
dtItem = c1.SelectDT(Sql);
Session["Category"] = dtItem;
lbl_Opr.Text = "Edit";
MultiView1.ActiveViewIndex = 1;
}
else if (e.CommandName == "EnableStatus")
{
if (((LinkButton)Repeater1.Items[e.Item.ItemIndex].FindControl("lnk_Status")).Text == "Enable")
{
str = "update tbl_paper set EnableStatus=1";
str = str + " WHERE PaperId=" + lbl_Id.Text;
}
else
{
str = "update tbl_paper set EnableStatus=0";
str = str + " WHERE PaperId=" + lbl_Id.Text;
}
c1.ExecuteQry(str);
FillPaper();
}
}
protected void Repeater1_ItemCommand(object source, RepeaterCommandEventArgs e)
{
string sql, id;
id = ((Label)Repeater1.Items[e.Item.ItemIndex].FindControl("lbl_Id")).Text;
DataTable tb;
if (e.CommandName == "Shortlist")
{
//if (((LinkButton)Repeater1.Items[e.Item.ItemIndex].FindControl("lnk_Shorted")).Text == "Selected")
//{
// sql = "update tbl_Member set ShortListed=0";
// sql = sql + " WHERE MemberId=" + id;
//}
//else
//{
// sql = "update tbl_Member set ShortListed=1";
// sql = sql + " WHERE MemberId=" + id;
//}
sql = "update tbl_Member set ShortListed=1";
sql = sql + " WHERE MemberId=" + id;
c1.ExecuteQry(sql);
fill();
}
else if (e.CommandName == "ViewCV")
{
string url = "~/" + ((Label)Repeater1.Items[e.Item.ItemIndex].FindControl("lbl_CVUrl")).Text;
string embed = "<object data=\"{0}\" type=\"application/pdf\" width=\"100%\" height=\"700px\">";
embed += "If you are unable to view file, you can download from <a href = \"{0}\">here</a>";
embed += " or download <a target = \"_blank\" href = \"http://get.adobe.com/reader/\">Adobe PDF Reader</a> to view the file.";
embed += "</object>";
ltEmbed.Text = string.Format(embed, ResolveUrl(url));
MultiView1.ActiveViewIndex = 2;
}
else if (e.CommandName == "View")
{
sql = "SELECT * FROM tbl_Member where MemberId=" + id;
tb = c1.SelectDT(sql);
lbl_Candidate_Address.Text = tb.Rows[0]["Candidate_Address"].ToString();
lbl_MemberName.Text = tb.Rows[0]["MemberName"].ToString();
lbl_ContactNo.Text = tb.Rows[0]["ContactNo"].ToString();
lbl_Gender.Text = tb.Rows[0]["Gender"].ToString();
lbl_Password.Text = tb.Rows[0]["Password"].ToString();
lbl_DOB.Text = tb.Rows[0]["DOB"].ToString();
lbl_EmailId.Text = tb.Rows[0]["EmailId"].ToString();
lbl_Desired_City.Text = tb.Rows[0]["Desired_City"].ToString();
lbl_Desired_State.Text = tb.Rows[0]["Desired_State"].ToString();
lbl_PhotoUrl.Text = tb.Rows[0]["PhotoUrl"].ToString();
lbl_Pin_Code.Text = tb.Rows[0]["Pin_Code"].ToString();
lbl_RegDate.Text = tb.Rows[0]["RegDate"].ToString();
lbl_Resume_Url.Text = tb.Rows[0]["Resume_Url"].ToString();
if ("1" == tb.Rows[0]["EnableStatus"].ToString())
{
lbl_EnableStatus.Text = "Active";
}
else
{
lbl_EnableStatus.Text = "Not-Active";
}
lbl_Experience_Month.Text = tb.Rows[0]["Experience_Month"].ToString();
lbl_Experience_Type.Text = tb.Rows[0]["Experience_Type"].ToString();
lbl_Experience_Year.Text = tb.Rows[0]["Experience_Year"].ToString();
lbl_Job_Duration_Month.Text = tb.Rows[0]["Job_Duration_Month"].ToString();
lbl_Job_Duration_Year.Text = tb.Rows[0]["Job_Duration_Year"].ToString();
lbl_Job_Functional_Area.Text = tb.Rows[0]["Job_Functional_Area"].ToString();
lbl_Job_Title.Text = tb.Rows[0]["Job_Title"].ToString();
lbl_Key_Skills.Text = tb.Rows[0]["Key_Skills"].ToString();
lbl_Company_Name.Text = tb.Rows[0]["Company_Name"].ToString();
lbl_Company_Industry.Text = tb.Rows[0]["Company_Industry"].ToString();
lbl_Current_Salary.Text = tb.Rows[0]["Current_Salary"].ToString();
lbl_OldSallery.Text = tb.Rows[0]["OldSallery"].ToString();
lbl_Reson.Text = tb.Rows[0]["Reson"].ToString();
lbl_Sec_Board.Text = tb.Rows[0]["Sec_Board"].ToString();
lbl_Sec_Per.Text = tb.Rows[0]["Sec_Per"].ToString();
lbl_Sec_Type.Text = tb.Rows[0]["Sec_Type"].ToString();
lbl_Sec_Year.Text = tb.Rows[0]["Sec_Year"].ToString();
lbl_SrSec_Board.Text = tb.Rows[0]["SrSec_Board"].ToString();
lbl_SrSec_Per.Text = tb.Rows[0]["SrSec_Per"].ToString();
lbl_SrSec_Subject.Text = tb.Rows[0]["SrSec_Subject"].ToString();
lbl_SrSec_Type.Text = tb.Rows[0]["SrSec_Type"].ToString();
lbl_SrSec_Year.Text = tb.Rows[0]["SrSec_Year"].ToString();
lbl_Graduation_Degree.Text = tb.Rows[0]["Graduation_Degree"].ToString();
lbl_Graduation_Per.Text = tb.Rows[0]["Graduation_Per"].ToString();
lbl_Graduation_Subject.Text = tb.Rows[0]["Graduation_Subject"].ToString();
lbl_Graduation_Type.Text = tb.Rows[0]["Graduation_Type"].ToString();
lbl_Graduation_Univ.Text = tb.Rows[0]["Graduation_Univ"].ToString();
lbl_Graduation_Year.Text = tb.Rows[0]["Graduation_Year"].ToString();
lbl_PG_Degree.Text = tb.Rows[0]["PG_Degree"].ToString();
lbl_PG_Per.Text = tb.Rows[0]["PG_Per"].ToString();
lbl_PG_Subject.Text = tb.Rows[0]["PG_Subject"].ToString();
lbl_PG_Type.Text = tb.Rows[0]["PG_Type"].ToString();
lbl_PG_Univ.Text = tb.Rows[0]["PG_Univ"].ToString();
lbl_PG_Year.Text = tb.Rows[0]["PG_Year"].ToString();
lbl_Other_Degree.Text = tb.Rows[0]["Other_Degree"].ToString();
lbl_Other_Per.Text = tb.Rows[0]["Other_Per"].ToString();
lbl_Other_Subject.Text = tb.Rows[0]["Other_Subject"].ToString();
lbl_Other_Type.Text = tb.Rows[0]["Other_Type"].ToString();
lbl_Other_Univ.Text = tb.Rows[0]["Other_Univ"].ToString();
lbl_Other_Year.Text = tb.Rows[0]["Other_Year"].ToString();
MultiView1.ActiveViewIndex = 1;
}
}
protected void Repeater1_ItemCommand(object source, RepeaterCommandEventArgs e)
{
string sql, id;
id = ((Label)Repeater1.Items[e.Item.ItemIndex].FindControl("lbl_Id")).Text;
DataTable tb;
if (e.CommandName == "Remove")
{
sql = "update tbl_Member set ShortListed=0 WHERE MemberId=" + id;
c1.ExecuteQry(sql);
fill();
}
else
if (e.CommandName == "View")
{
sql = "SELECT * FROM tbl_Member where MemberId=" + id;
tb = c1.SelectDT(sql);
lbl_Candidate_Address.Text = tb.Rows[0]["Candidate_Address"].ToString();
lbl_MemberName.Text = tb.Rows[0]["MemberName"].ToString();
lbl_ContactNo.Text = tb.Rows[0]["ContactNo"].ToString();
lbl_Gender.Text = tb.Rows[0]["Gender"].ToString();
lbl_Password.Text = tb.Rows[0]["Password"].ToString();
lbl_DOB.Text = tb.Rows[0]["DOB"].ToString();
lbl_EmailId.Text = tb.Rows[0]["EmailId"].ToString();
lbl_Desired_City.Text = tb.Rows[0]["Desired_City"].ToString();
lbl_Desired_State.Text = tb.Rows[0]["Desired_State"].ToString();
lbl_PhotoUrl.Text = tb.Rows[0]["PhotoUrl"].ToString();
lbl_Pin_Code.Text = tb.Rows[0]["Pin_Code"].ToString();
lbl_RegDate.Text = tb.Rows[0]["RegDate"].ToString();
lbl_Resume_Url.Text = tb.Rows[0]["Resume_Url"].ToString();
if ("1" == tb.Rows[0]["EnableStatus"].ToString())
{
lbl_EnableStatus.Text = "Active";
}
else
{
lbl_EnableStatus.Text = "Not-Active";
}
lbl_Experience_Month.Text = tb.Rows[0]["Experience_Month"].ToString();
lbl_Experience_Type.Text = tb.Rows[0]["Experience_Type"].ToString();
lbl_Experience_Year.Text = tb.Rows[0]["Experience_Year"].ToString();
lbl_Job_Duration_Month.Text = tb.Rows[0]["Job_Duration_Month"].ToString();
lbl_Job_Duration_Year.Text = tb.Rows[0]["Job_Duration_Year"].ToString();
lbl_Job_Functional_Area.Text = tb.Rows[0]["Job_Functional_Area"].ToString();
lbl_Job_Title.Text = tb.Rows[0]["Job_Title"].ToString();
lbl_Key_Skills.Text = tb.Rows[0]["Key_Skills"].ToString();
lbl_Company_Name.Text = tb.Rows[0]["Company_Name"].ToString();
lbl_Company_Industry.Text = tb.Rows[0]["Company_Industry"].ToString();
lbl_Current_Salary.Text = tb.Rows[0]["Current_Salary"].ToString();
lbl_OldSallery.Text = tb.Rows[0]["OldSallery"].ToString();
lbl_Reson.Text = tb.Rows[0]["Reson"].ToString();
lbl_Sec_Board.Text = tb.Rows[0]["Sec_Board"].ToString();
lbl_Sec_Per.Text = tb.Rows[0]["Sec_Per"].ToString();
lbl_Sec_Type.Text = tb.Rows[0]["Sec_Type"].ToString();
lbl_Sec_Year.Text = tb.Rows[0]["Sec_Year"].ToString();
lbl_SrSec_Board.Text = tb.Rows[0]["SrSec_Board"].ToString();
lbl_SrSec_Per.Text = tb.Rows[0]["SrSec_Per"].ToString();
lbl_SrSec_Subject.Text = tb.Rows[0]["SrSec_Subject"].ToString();
lbl_SrSec_Type.Text = tb.Rows[0]["SrSec_Type"].ToString();
lbl_SrSec_Year.Text = tb.Rows[0]["SrSec_Year"].ToString();
lbl_Graduation_Degree.Text = tb.Rows[0]["Graduation_Degree"].ToString();
lbl_Graduation_Per.Text = tb.Rows[0]["Graduation_Per"].ToString();
lbl_Graduation_Subject.Text = tb.Rows[0]["Graduation_Subject"].ToString();
lbl_Graduation_Type.Text = tb.Rows[0]["Graduation_Type"].ToString();
lbl_Graduation_Univ.Text = tb.Rows[0]["Graduation_Univ"].ToString();
lbl_Graduation_Year.Text = tb.Rows[0]["Graduation_Year"].ToString();
lbl_PG_Degree.Text = tb.Rows[0]["PG_Degree"].ToString();
lbl_PG_Per.Text = tb.Rows[0]["PG_Per"].ToString();
lbl_PG_Subject.Text = tb.Rows[0]["PG_Subject"].ToString();
lbl_PG_Type.Text = tb.Rows[0]["PG_Type"].ToString();
lbl_PG_Univ.Text = tb.Rows[0]["PG_Univ"].ToString();
lbl_PG_Year.Text = tb.Rows[0]["PG_Year"].ToString();
lbl_Other_Degree.Text = tb.Rows[0]["Other_Degree"].ToString();
lbl_Other_Per.Text = tb.Rows[0]["Other_Per"].ToString();
lbl_Other_Subject.Text = tb.Rows[0]["Other_Subject"].ToString();
lbl_Other_Type.Text = tb.Rows[0]["Other_Type"].ToString();
lbl_Other_Univ.Text = tb.Rows[0]["Other_Univ"].ToString();
lbl_Other_Year.Text = tb.Rows[0]["Other_Year"].ToString();
MultiView1.ActiveViewIndex = 1;
}
}
protected void btn_Submit_Click(object sender, EventArgs e)
{
string sql, cnt;
int TotalRows = 0, i, j, TotalCols = 0, k, TotalQuestionRequired, QNo;
DataTable ds = new DataTable();
TotalRows = grd_Category.Rows.Count;
TotalCols = 3;
sql = "Select Count(PaperId) from tbl_PaperSet where PaperId=" + ddl_PaperAdd.SelectedValue.ToString();
cnt = c1.SelectScalar(sql);
if (Convert.ToInt32(cnt) > 0)
{
lbl_Msg.Text = "Paper Already Created";
}
else
{
for (i = 0; i < TotalRows; i++)
{
for (j = 1; j <= 3; j++)
{
TotalQuestionRequired = Convert.ToInt32(grd_Category.Rows[i].Cells[j].Text);
lstAllQuestion.Items.Clear();
//1=Easy 2=Medium 3=diff
sql = " select QuestionId from tbl_Question where SubjectId=" + ddl_SubjectAdd.SelectedValue.ToString();
sql = sql + " and QuestionCategoryId=" + grd_Category.DataKeys[i].Value.ToString();
sql = sql + " and DifficultyLevel=" + j.ToString();
ds = c1.SelectDT(sql);
lstAllQuestion.DataSource = ds;
lstAllQuestion.DataTextField = "QuestionId";
lstAllQuestion.DataValueField = "QuestionId";
lstAllQuestion.DataBind();
if (ds.Rows.Count < TotalQuestionRequired)
{
lbl_Msg.Text = "Less Questions can not create paper";
break;
}
else
{
Random r = new Random();
for (k = 0; k < TotalQuestionRequired; k++)
{
QNo = r.Next(0, lstAllQuestion.Items.Count);
lstSelectedQuestion.Items.Add(lstAllQuestion.Items[QNo].Text);
lstAllQuestion.Items.RemoveAt(QNo);
}
}
}
}
int lstcnt = Convert.ToInt32(lstSelectedQuestion.Items.Count);
for (i = 0; i < lstcnt; i++)
{
sql = " INSERT INTO tbl_PaperSet (PaperId,QuestionId) VALUES (";
sql = sql + " '" + ddl_PaperAdd.SelectedValue.ToString() + "','" + lstSelectedQuestion.Items[i] + "')";
c1.ExecuteQry(sql);
}
lstAllQuestion.Items.Clear();
lstSelectedQuestion.Items.Clear();
ddl_StreamAdd.SelectedIndex = -1;
ddl_SubjectAdd.Items.Clear();
ddl_PaperAdd.Items.Clear();
grd_Category.DataSource = "";
grd_Category.DataBind();
}
}
private void FillResume()
{
string str;
DataTable dt;
int i, n;
str = " SELECT * FROM tbl_Member ";
str = str + " WHERE MemberId=" + Session["MemberId"].ToString();
dt = c1.SelectDT(str);
n = dt.Rows.Count;
if (n > 0)
{
if (dt.Rows[0]["Gender"].ToString() == "Male")
{
Opt_Male.Checked = true;
}
else
{
Opt_FeMale.Checked = true;
}
txt_DOB.Text = dt.Rows[0]["DOB"].ToString();
txt_Address.Text = dt.Rows[0]["Candidate_Address"].ToString();
ddl_StatePersonal.SelectedValue = dt.Rows[0]["State_Id"].ToString();
fillCityPersonal();
ddl_CityPersonal.SelectedValue = dt.Rows[0]["City_Id"].ToString();
txt_PinCode.Text = dt.Rows[0]["Pin_Code"].ToString();
//txt_Address.Text = dt.Rows[0]["RegDate"].ToString();
if (dt.Rows[0]["Experience_Type"].ToString() == "Fresher")
{
opt_Fresher.Checked = true;
}
else
{
opt_Experience.Checked = true;
}
ddl_Desired_State.SelectedValue = dt.Rows[0]["Desired_State"].ToString();
fillCityDesire();
ddl_Desired_City.SelectedValue = dt.Rows[0]["Desired_City"].ToString();
ddl_Sec_Board.SelectedValue = dt.Rows[0]["Sec_Board"].ToString();
ddl_Sec_Course_Type.SelectedValue = dt.Rows[0]["Sec_Type"].ToString();
txt_Sec_Pecentage.Text = dt.Rows[0]["Sec_Per"].ToString();
txt_Sec_Year.Text = dt.Rows[0]["Sec_Year"].ToString();
ddl_SrSec_Board.SelectedValue = dt.Rows[0]["SrSec_Board"].ToString();
txt_SrSec_Pecentage.Text = dt.Rows[0]["SrSec_Per"].ToString();
txt_SrSec_Year.Text = dt.Rows[0]["SrSec_Year"].ToString();
txt_SrSec_Subject.Text = dt.Rows[0]["SrSec_Subject"].ToString();
ddl_SrSec_CourseType.SelectedValue = dt.Rows[0]["SrSec_Type"].ToString();
ddl_Exp_Years.SelectedValue = dt.Rows[0]["Experience_Year"].ToString();
ddl_Exp_Months.SelectedValue = dt.Rows[0]["Experience_Month"].ToString();
txt_Sallery.Text = dt.Rows[0]["OldSallery"].ToString();
txt_reson.Text = dt.Rows[0]["Reson"].ToString();
txt_KeySkills.Text = dt.Rows[0]["Key_Skills"].ToString();
txt_Job_Title.Text = dt.Rows[0]["Job_Title"].ToString();
txt_Cmpny_Name.Text = dt.Rows[0]["Company_Name"].ToString();
ddl_Industry.SelectedValue = dt.Rows[0]["Company_Industry"].ToString();
fillFunctionalArea();
ddl_FunctionalArea.SelectedValue = dt.Rows[0]["Job_Functional_Area"].ToString();
ddl_JobDur_Years.SelectedValue = dt.Rows[0]["Job_Duration_Year"].ToString();
ddl_JobDur_Months.SelectedValue = dt.Rows[0]["Job_Duration_Month"].ToString();
txt_CSallery.Text = dt.Rows[0]["Current_Salary"].ToString();
ddl_Graduation_Uni.SelectedValue = dt.Rows[0]["Graduation_Univ"].ToString();
txt_Graduation_Degree.Text = dt.Rows[0]["Graduation_Degree"].ToString();
txt_Graduation_Uni_Subject.Text = dt.Rows[0]["Graduation_Subject"].ToString();
txt_Graduation_Uni_Pecentage.Text = dt.Rows[0]["Graduation_Per"].ToString();
txt_Graduation_Uni_Year.Text = dt.Rows[0]["Graduation_Year"].ToString();
ddl_Graduation_Uni_Coursetype.SelectedValue = dt.Rows[0]["Graduation_Type"].ToString();
ddl_PG_Uni.SelectedValue = dt.Rows[0]["PG_Univ"].ToString();
txt_PG_Degree.Text = dt.Rows[0]["PG_Degree"].ToString();
txt_PG_Subject.Text = dt.Rows[0]["PG_Subject"].ToString();
txt_PG_Percentage.Text = dt.Rows[0]["PG_Per"].ToString();
txt_PG_Year.Text = dt.Rows[0]["PG_Year"].ToString();
ddl_PG_CourseType.SelectedValue = dt.Rows[0]["PG_Type"].ToString();
ddl_Other_Uni.SelectedValue = dt.Rows[0]["Other_Univ"].ToString();
txt_Other_Degree.Text = dt.Rows[0]["Other_Degree"].ToString();
txt_Other_Uni_Subject.Text = dt.Rows[0]["Other_Subject"].ToString();
txt_other_Uni_Pecentage.Text = dt.Rows[0]["Other_Per"].ToString();
txt_other_Uni_Year.Text = dt.Rows[0]["Other_Year"].ToString();
ddl_Other_Uni_CourseType.Text = dt.Rows[0]["Other_Type"].ToString();
}
}
