/// <summary>
        /// Handles ItemDataBound event of rptrJobPostLookinFor control
        /// </summary>
        /// <param name="sender">The source of the event.</param>
        /// <param name="e">The <see cref="EventArgs"/> instance containing the event data.</param>
        protected void rptrJobPostLookinFor_ItemDataBound(object sender, RepeaterItemEventArgs e)
        {
            CurrentDesiredJobBAL currentDesiredJobBAL = new CurrentDesiredJobBAL();
            DropDownList ddlIndustry123 = (DropDownList)e.Item.FindControl("ddlIndustry123");
            if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
            {
                //DataSet ds1 = new DataSet();

                //ds1 = currentDesiredJobBAL.ViewCurrentJobDetailsBAL(candidateId);
                //bindState();

                DataSet ds = new DataSet();
                ds = currentDesiredJobBAL.GetIndustry();
                if (ds != null)
                {
                    ddlIndustry123.DataSource = ds;
                    ddlIndustry123.DataTextField = "IndustryName";
                    ddlIndustry123.DataValueField = "IndustryId";
                    ddlIndustry123.DataBind();
                    ddlIndustry123.SelectedValue = Convert.ToString(DataBinder.Eval(e.Item.DataItem, "Industry"));
                }
            }
            DropDownList ddlDepartment123 = (DropDownList)e.Item.FindControl("ddlDepartment123");
            if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
            {
                DataSet ds1 = new DataSet();
                ds1 = currentDesiredJobBAL.GetDepartment();
                if (ds1 != null)
                {
                    ddlDepartment123.DataSource = ds1;
                    ddlDepartment123.DataTextField = "DepartmentName";
                    ddlDepartment123.DataValueField = "DepartmentId";
                    ddlDepartment123.DataBind();
                    ddlDepartment123.SelectedValue = Convert.ToString(DataBinder.Eval(e.Item.DataItem, "Department"));
                }
            }
            DropDownList ddlFunctionalRole = (DropDownList)e.Item.FindControl("ddlFunctionalRole");
            if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
            {
                DataSet ds2 = new DataSet();

                ds2 = currentDesiredJobBAL.GetFunctionalArea();
                if (ds2 != null)
                {
                    ddlFunctionalRole.DataSource = ds2;
                    ddlFunctionalRole.DataTextField = "FunctionalArea";
                    ddlFunctionalRole.DataValueField = "FunctionalAreaId";
                    ddlFunctionalRole.DataBind();
                    ddlFunctionalRole.SelectedValue = Convert.ToString(DataBinder.Eval(e.Item.DataItem, "FunctionalRole"));
                }
            }
        }
        /// <summary>
        /// Handles ItemDataBound event of rptrPastCurrentJobDetails control
        /// </summary>
        /// <param name="sender">The source of the event.</param>
        /// <param name="e">The <see cref="EventArgs"/> instance containing the event data.</param>
        protected void rptrPastCurrentJobDetails_ItemDataBound(object sender, RepeaterItemEventArgs e)
        {
            CurrentDesiredJobBAL currentDesiredJobBAL = new CurrentDesiredJobBAL();
            DropDownList ddlIndustry = (DropDownList)e.Item.FindControl("ddlIndustry");
            if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
            {
                //DataSet ds1 = new DataSet();

                //ds1 = currentDesiredJobBAL.ViewCurrentJobDetailsBAL(candidateId);
                //bindState();

                DataSet ds = new DataSet();
                ds = currentDesiredJobBAL.GetIndustry();
                if (ds != null)
                {
                    ddlIndustry.DataSource = ds;
                    ddlIndustry.DataTextField = "IndustryName";
                    ddlIndustry.DataValueField = "IndustryId";
                    ddlIndustry.DataBind();
                    ddlIndustry.SelectedValue = Convert.ToString(DataBinder.Eval(e.Item.DataItem, "Industry"));
                }
            }
            DropDownList ddlDepartment = (DropDownList)e.Item.FindControl("ddlDepartment");
            if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
            {
                DataSet ds1 = new DataSet();
                ds1 = currentDesiredJobBAL.GetDepartment();
                if (ds1 != null)
                {
                    ddlDepartment.DataSource = ds1;
                    ddlDepartment.DataTextField = "DepartmentName";
                    ddlDepartment.DataValueField = "DepartmentId";
                    ddlDepartment.DataBind();
                    ddlDepartment.SelectedValue = Convert.ToString(DataBinder.Eval(e.Item.DataItem, "Department"));
                }
            }

            DropDownList ddlFromMonth = (DropDownList)e.Item.FindControl("ddlFromMonth");
            if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
            {
                List<string> monthList = CommonUtil.Utility.GetMonths();
                ddlFromMonth.DataSource = monthList;

                ddlFromMonth.DataBind();

                ddlFromMonth.SelectedValue = Convert.ToString(DataBinder.Eval(e.Item.DataItem, "FromMonth"));
            }

            DropDownList ddlTillMonth = (DropDownList)e.Item.FindControl("ddlTillMonth");
            if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
            {
                List<string> monthList = CommonUtil.Utility.GetMonths();
                ddlTillMonth.DataSource = monthList;

                ddlTillMonth.DataBind();

                ddlTillMonth.SelectedValue = Convert.ToString(DataBinder.Eval(e.Item.DataItem, "TillMonth"));
            }

            DropDownList ddlFromYear = (DropDownList)e.Item.FindControl("ddlFromYear");
            if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
            {
                List<string> yearList = CommonUtil.Utility.GetYears();
                ddlFromYear.DataSource = yearList;
                ddlFromYear.DataBind();

                ddlFromYear.SelectedValue = Convert.ToString(DataBinder.Eval(e.Item.DataItem, "FromYear"));
            }

            DropDownList ddlTillYear = (DropDownList)e.Item.FindControl("ddlTillYear");
            if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
            {
                List<string> yearList = CommonUtil.Utility.GetYears();
                ddlTillYear.DataSource = yearList;
                ddlTillYear.DataBind();

                ddlTillYear.SelectedValue = Convert.ToString(DataBinder.Eval(e.Item.DataItem, "TillYear"));
            }

            RadioButtonList rbtlEmployementStatus = (RadioButtonList)e.Item.FindControl("rbtlEmployementStatus");
            if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
            {
                rbtlEmployementStatus.SelectedValue = Convert.ToString(DataBinder.Eval(e.Item.DataItem, "EmploymentStatus"));
            }

            RadioButtonList rblCompanyType = (RadioButtonList)e.Item.FindControl("rblCompanyType");
            if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
            {
                rblCompanyType.SelectedValue = Convert.ToString(DataBinder.Eval(e.Item.DataItem, "CompanyType"));
            }

            RadioButtonList rblJobType = (RadioButtonList)e.Item.FindControl("rblJobType");
            if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
            {
                rblJobType.SelectedValue = Convert.ToString(DataBinder.Eval(e.Item.DataItem, "JobType"));
            }
        }
 /// <summary>
 /// Method to Bind department ddlDepartment & ddlDepartment123 control
 /// </summary>
 private void BindDepartment()
 {
     CurrentDesiredJobBAL currentjobBAL = new CurrentDesiredJobBAL();
     try
     {
         DataSet ds = new DataSet();
         ds = currentjobBAL.GetDepartment();
         if (ds != null)
         {
             ddlDepartment.DataSource = ds;
             ddlDepartment123.DataSource = ds;
             ddlDepartment.DataTextField = "DepartmentName";
             ddlDepartment.DataValueField = "DepartmentId";
             ddlDepartment123.DataTextField = "DepartmentName";
             ddlDepartment123.DataValueField = "DepartmentId";
             ddlDepartment.DataBind();
             ddlDepartment123.DataBind();
             ddlDepartment123.Items.Insert(0, new ListItem("--Select--", "0"));
             ddlDepartment.Items.Insert(0, new ListItem("--Select--", "0"));
         }
     }
     catch (Exception)
     {
         // throw;
     }
 }