/// <summary>
 /// Bind repeater to technical skills details
 /// </summary>
 private void BindRepeaterTechnicalSkills()
 {
     try
     {
         DataSet dsTechnicalSkills = new DataSet();
         CurrentDesiredJobBAL currentDesiredJobBAL = new CurrentDesiredJobBAL();
         dsTechnicalSkills = currentDesiredJobBAL.ViewTechnicalSkillDetailsBAL(candidateId);
         // Check dataset is not null
         if (dsTechnicalSkills != null)
         {
             rptrTechnicalSkills.DataSource = dsTechnicalSkills;
             rptrTechnicalSkills.DataBind();
         }
     }
     catch (Exception)
     {
         // throw;
     }
 }
        /// <summary>
        /// Handles ItemDataBound event of rptrTechnicalSkills 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 rptrTechnicalSkills_ItemDataBound(object sender, RepeaterItemEventArgs e)
        {
            try
            {
                string fromDate, tillDate;
                int count = 0, count1 = 0;
                DataSet dsViewTechnicalSkills = new DataSet();
                CurrentDesiredJobBAL currentDesiredJobBAL = new CurrentDesiredJobBAL();
                dsViewTechnicalSkills = currentDesiredJobBAL.ViewTechnicalSkillDetailsBAL(candidateId);

                fromDate = Convert.ToString(dsViewTechnicalSkills.Tables[0].Rows[0]["FromDate"]); ;
                string[] Words = fromDate.Split(new char[] { '/' });

                tillDate = Convert.ToString(dsViewTechnicalSkills.Tables[0].Rows[0]["TillDate"]); ;
                string[] Words1 = tillDate.Split(new char[] { '/' });

                DropDownList ddlTechnicalSkill = (DropDownList)e.Item.FindControl("ddlTechnicalSkill");
                if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
                {
                    DataSet dsTechnicalSkills = new DataSet();
                    dsTechnicalSkills = currentDesiredJobBAL.GetTechnicalSkillsDetailsBAL();
                    // Check dataset is not null
                    if (dsTechnicalSkills != null)
                    {
                        ddlTechnicalSkill.DataSource = dsTechnicalSkills;
                        ddlTechnicalSkill.DataTextField = "TechnicalSkillName";
                        ddlTechnicalSkill.DataValueField = "TechnicalSkillTypeId";
                        ddlTechnicalSkill.DataBind();
                        ddlTechnicalSkill.SelectedValue = Convert.ToString(DataBinder.Eval(e.Item.DataItem, "TechnicalSkills"));
                    }
                }
                DropDownList ddlFromYear = (DropDownList)e.Item.FindControl("ddlFromYear");
                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();

                    List<string> yearList = CommonUtil.Utility.GetYears();
                    ddlFromYear.DataSource = yearList;
                    ddlFromYear.DataBind();

                    foreach (string Word in Words)
                    {
                        count += 1;
                        if (count == 1)
                        { ddlFromMonth.SelectedValue = Word; }
                        if (count == 2)
                        {
                            ddlFromYear.SelectedValue = Word;
                        }
                    }
                }
                DropDownList ddlTillYear = (DropDownList)e.Item.FindControl("ddlTillYear");
                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();
                    List<string> yearList = CommonUtil.Utility.GetYears();
                    ddlTillYear.DataSource = yearList;
                    ddlTillYear.DataBind();

                    foreach (string Word in Words1)
                    {
                        count1 += 1;
                        if (count1 == 1)
                        {
                            ddlTillMonth.SelectedValue = Word;
                        }
                        if (count1 == 2)
                        {
                            ddlTillYear.SelectedValue = Word;
                        }
                    }
                }

                DropDownList ddlProficiency = (DropDownList)e.Item.FindControl("ddlProficiency");
                if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
                {
                    ddlProficiency.SelectedValue = Convert.ToString(DataBinder.Eval(e.Item.DataItem, "Proficiency"));
                }
            }
            catch (Exception)
            {
                //  throw;
            }
        }