/// <summary>
        /// Tari
        /// </summary>
        /// <returns></returns>
        private string GetSirTari()
        {
            string sirTari      = "";
            string sirTariText  = "[";
            string sirTariValue = "[";

            Salaries.Business.AdminTari tari = new Salaries.Business.AdminTari();
            DataSet ds = tari.LoadInfoTari();

            for (int i = 0; i < ds.Tables[0].Rows.Count - 1; i++)
            {
                DataRow dr = ds.Tables[0].Rows[i];
                sirTariText  += "'" + dr["NumeTara"].ToString() + "', ";
                sirTariValue += dr["TaraID"].ToString() + ", ";
            }
            if (ds.Tables[0].Rows.Count > 0)
            {
                sirTariText  += "'" + ds.Tables[0].Rows[ds.Tables[0].Rows.Count - 1]["NumeTara"].ToString() + "']";
                sirTariValue += ds.Tables[0].Rows[ds.Tables[0].Rows.Count - 1]["TaraID"].ToString() + "]";

                sirTari = "[" + sirTariText + "," + sirTariValue + "]";
            }
            else
            {
                sirTari = "[[],[]]";
            }

            return(sirTari);
        }
 /// <summary>
 /// Populeaza lista cu tari
 /// </summary>
 public void PopulareTabela()
 {
     Index = listDataGrid.CurrentPageIndex * 30 + 1;
     Salaries.Business.AdminTari tari = new Salaries.Business.AdminTari();
     listDataGrid.DataSource = tari.LoadInfoTari();
     listDataGrid.DataBind();
 }
        /// <summary>
        /// Se trece la urmatoarea pagina in lista
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        public void listDataGrid_PageIndexChanged(Object sender, DataGridPageChangedEventArgs e)
        {
            Salaries.Business.AdminTari tari = new Salaries.Business.AdminTari();
            DataSet dt = tari.LoadInfoTari();

            CompletareTitlu();

            listDataGrid.CurrentPageIndex = e.NewPageIndex;
            DataView dv = dt.Tables[0].DefaultView;

            listDataGrid.DataSource = dv;
            Index = (e.NewPageIndex * listDataGrid.PageSize) + 1;
            listDataGrid.DataBind();
        }
        /// <summary>
        /// Valorile judetelor
        /// </summary>
        /// <returns></returns>
        private string GetSirJudeteValue()
        {
            string sirJudVal      = "";
            string sirJudValFinal = "";

            Salaries.Business.AdminTari tari = new Salaries.Business.AdminTari();
            DataSet dsTari = tari.LoadInfoTari();

            foreach (DataRow drTari in dsTari.Tables[0].Rows)
            {
                Salaries.Business.AdminJudete judete = new Salaries.Business.AdminJudete();
                judete.TaraId = int.Parse(drTari["TaraID"].ToString());
                DataSet ds = judete.GetAllJudeteTara();
                if (ds.Tables[0].Rows.Count > 0)
                {
                    sirJudVal = "[";

                    for (int i = 0; i < ds.Tables[0].Rows.Count - 1; i++)
                    {
                        DataRow dr = ds.Tables[0].Rows[i];
                        sirJudVal += dr["JudetID"].ToString() + ", ";
                    }
                    sirJudVal += ds.Tables[0].Rows[ds.Tables[0].Rows.Count - 1]["JudetID"].ToString() + "]";
                }
                else
                {
                    sirJudVal = "[]";
                }
                sirJudValFinal += sirJudVal + ", ";
            }
            if (sirJudValFinal == "")
            {
                sirJudValFinal += "[[]]";
            }
            else
            {
                sirJudValFinal = sirJudValFinal.Substring(0, sirJudValFinal.Length - 2);
                sirJudValFinal = "[" + sirJudValFinal + "]";
            }

            return(sirJudValFinal);
        }
        /// <summary>
        /// Daca pagina de administrare a fost deschisa din AddAngajat cream functia care va face refresh la combo-ul cu titluri
        /// </summary>
        private void CreateRefreshFunctionForAddAngajat()
        {
            string outStr = "";

            //tb resetate sirurile cu tari si judete din AddAngajat din cauza actualizarii tarilor
            string sirTari        = GetSirTari();
            string sirJudeteText  = GetSirJudeteText();
            string sirJudeteValue = GetSirJudeteValue();

            Response.Write("<script>var tari1 = " + sirTari + ";</script>");
            Response.Write("<script>var judeteText1 = " + sirJudeteText + ";</script>");
            Response.Write("<script>var judeteValue1 = " + sirJudeteValue + ";</script>");

            //cream scriptul care va contine functia de refresh
            //ne bazam pe faptul ca se cunoaste numele selectului care contine titlurile
            //initial se sterg toate intrarile din combo
            outStr += "<script> \r\n function RefreshAddAngajatPage() \r\n" +
                      "{ \r\n" +

                      "window.opener.RecreateArray_TariJudete( 'tari', tari1.length); \r\n" +
                      "for(i=0;i<tari1.length;i++) \r\n" +
                      "	window.opener.RecreateLine_TariJudete( 'tari', i, tari1[i].length); \r\n" +
                      "for(i=0;i<tari1.length;i++) \r\n" +
                      "for(j=0;j<tari1[i].length;j++) \r\n" +
                      "window.opener.SetTari( i, j, tari1[i][j]); \r\n" +

                      "window.opener.RecreateArray_TariJudete('judeteText',judeteText1.length); \r\n" +
                      "for(i=0;i<judeteText1.length;i++) \r\n" +
                      "	window.opener.RecreateLine_TariJudete( 'judeteText' ,i, judeteText1[i].length); \r\n" +
                      "for(i=0;i<judeteText1.length;i++) \r\n" +
                      "{ \r\n" +
                      "	if ( judeteText1[i].length == 0)  \r\n" +
                      "		window.opener.SetJudeteText( i, 0, null); \r\n"+
                      "	else \r\n" +
                      "		for(j=0;j<judeteText1[i].length;j++) \r\n"+
                      "			window.opener.SetJudeteText( i, j, judeteText1[i][j]); \r\n"+
                      "} \r\n" +

                      "window.opener.RecreateArray_TariJudete('judeteValue',judeteValue1.length); \r\n" +
                      "for(i=0;i<judeteValue1.length;i++) \r\n" +
                      "	window.opener.RecreateLine_TariJudete( 'judeteValue' ,i, judeteValue1[i].length); \r\n" +
                      "for(i=0;i<judeteValue1.length;i++) \r\n" +
                      "for(j=0;j<judeteValue1[i].length;j++) \r\n" +
                      "window.opener.SetJudeteValue( i, j, judeteValue1[i][j]); \r\n" +

                      "window.opener.DeleteTariCombo(); \r\n" +
                      " FillTariCOmbo(); \r\n" +
                      "} \r\n";

            //acum se creeaza functie care adauga titlurile din recordset
            //se foloseste o functie din AddAngajat ... FillTaraCombo
            Salaries.Business.AdminTari tari = new Salaries.Business.AdminTari();
            outStr += " function FillTariCOmbo() \r\n" +
                      "{ \r\n";
            foreach (DataRow dataRow in tari.LoadInfoTari().Tables[0].Rows)
            {
                outStr += "window.opener.FillTaraCombo('" +
                          dataRow["NumeTara"].ToString() + "'," +
                          dataRow["TaraID"].ToString() + ");";
            }

            outStr += " window.opener.SyncronizeTaraJudete(); \r\n";

            outStr += "} \r\n" +
                      "</script>";

            Response.Write(outStr);
        }
        private void Page_Load(object sender, System.EventArgs e)

        {
            if (!IsPostBack)
            {
                //se obtine tipul de autentificare la aplicatie
                string authentication = Salaries.Configuration.CryptographyClass.getSettingsWithoutDecode("authentication");
                //daca utilizatorul nu are acces la aplicatie atunci este redirectat catre o pagina in care este afisat un mesaj de avertizare
                if (authentication == "0")
                {
                    ErrHandler.MyErrHandler.WriteError("Index.aspx - utilizatorul nu are acces la aplicatie");
                    Response.Redirect("Unauthorized.aspx");
                }

                //este sters tot din sesine
                Session.RemoveAll();
                try
                {
                    //se preia stringul de conexiune din web.config
                    settings = Salaries.Configuration.ModuleConfig.GetSettings();
                    UtilitiesDb utilDb = new UtilitiesDb(settings.ConnectionString);

                    //daca lipseste una din datele strinct necesare pentru conectare la baza,
                    //utilizatorul este redirectat catre pagina pentru introducerea acestor valori
                    string[] s = settings.ConnectionString.Split(';');
                    if ((s[2] == "data source=") || (s[4] == "initial catalog=") || (s[5] == "user id=") || (s[6] == "pwd="))
                    {
                        Response.Redirect("AdminSetari.aspx");
                    }

                    //se verifica daca se pot obtine date din baza de date
                    int angajatorId = 0;
                    try
                    {
                        //daca nu se pot atunci stringul de conexiune nu este corect si utilizatorul este redirectat pentru
                        //introducerea unui string de conexiune corect
                        Salaries.Business.AdminTari tari = new Salaries.Business.AdminTari();
                        int TaraID = int.Parse(tari.LoadInfoTari().Tables[0].Rows[0]["TaraID"].ToString());
                    }
                    catch (Exception e1)
                    {
                        Response.Redirect("AdminSetari.aspx");
                        string msg = e1.Message;
                    }

                    //se selecteaza un angajator
                    Salaries.Business.AdminAngajator angajator = new Salaries.Business.AdminAngajator();
                    try
                    {
                        //daca nu se poate face acest lucru atunci in baza nu exista angajatori si utilizatorul este
                        //redirectat catre pagina pentru introducerea primului angajator
                        angajatorId = int.Parse(angajator.LoadInfoAngajatori().Tables[0].Rows[0]["AngajatorID"].ToString());
                    }
                    catch
                    {
                        Response.Redirect("Administrare/AdminPrimulAngajator.aspx");
                    }

                    Session["AngajatorID"]       = angajatorId.ToString();
                    Session["AngajatorDenumire"] = angajator.LoadInfoAngajatori().Tables[0].Rows[0]["Denumire"].ToString();

                    //autentificarea este de tip windows prin Active Directory
                    if (authentication == "1")
                    {
                        //este preluat user-ul loginat
                        user = new WindowsPrincipal(WindowsIdentity.GetCurrent());

                        //daca utilizatorul face parte din grupul HR
                        if (Salaries.Business.Authentication.IsUserInHRgroup(user))
                        {
                            Session["administrare_departamente"] = "";
                            Response.Redirect("Home.aspx");
                        }
                        else
                        {
                            //daca user-ul faca parte din grupul de manageri
                            if (Salaries.Business.Authentication.IsUserInManagersGroup(user))
                            {
                                Response.Redirect("Managers/Managers.aspx");
                            }
                            else
                            {
                                //daca user-ul faca parte din grupul de recrutori
                                if (Salaries.Business.Authentication.IsUserInRecrutoriGroup(user))
                                {
                                    Response.Redirect("Recrutori/Recrutori.aspx");
                                }
                                else
                                {
                                    ErrHandler.MyErrHandler.WriteError("Index.aspx - autentificare windows fara drepturi - " + user.Identity.Name);
                                    Response.Redirect("Unauthorized.aspx");
                                }
                            }
                        }
                    }
                    //autentificarea este cu user si parola
                    else
                    {
                        Response.Redirect("AdminUserParola.aspx");
                    }
                }
                catch (Exception ex)
                {
                    string msg = ex.Message;
                }
            }
        }