/// <summary>
        /// Sterge un training
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void btnStergeDate_Click(object sender, System.EventArgs e)
        {
            try
            {
                Salaries.Business.IstoricTraining istTraining = new Salaries.Business.IstoricTraining();
                istTraining.IstoricTrainingId = int.Parse(this.IstoricTrainingID.Value);
                istTraining.DeleteIstoricTraining();
            }
            catch (Exception ex)
            {
                litError.Text  = "The following error occurred: <br>";
                litError.Text += ex.Message;
            }

            LoadFormIstoricTraining();
        }
        /// <summary>
        /// Modifica un training
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void btnModificaDate_Click(object sender, System.EventArgs e)
        {
            try
            {
                bool tipTraining = this.tipTraining.SelectedValue == "1";
                Salaries.Business.IstoricTraining istTraining = new Salaries.Business.IstoricTraining();
                istTraining.IstoricTrainingId = int.Parse(this.IstoricTrainingID.Value);
                istTraining.AngajatId         = AngajatID;
                istTraining.TrainingId        = (tipTraining) ? Convert.ToInt32(lstTraining.SelectedValue):Convert.ToInt32(lstTraining2.SelectedValue);
                istTraining.DataStart         = Utilities.ConvertText2DateTime(txtDataStart.Text);
                istTraining.DataEnd           = Utilities.ConvertText2DateTime(txtDataEnd.Text);

                istTraining.UpdateIstoricTraining();
            }
            catch (Exception ex)
            {
                litError.Text  = "The following error occurred: <br>";
                litError.Text += ex.Message;
            }

            LoadFormIstoricTraining();
        }
        /// <summary>
        /// Adauga un training
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void btnAdaugaTraining_Click(object sender, System.EventArgs e)
        {
            try
            {
                int TrainingID = (this.tipTraining.SelectedValue == "1")? Convert.ToInt32(lstTraining.SelectedValue): Convert.ToInt32(lstTraining2.SelectedValue);

                Salaries.Business.IstoricTraining istTraining = new Salaries.Business.IstoricTraining();
                istTraining.IstoricTrainingId = 0;
                istTraining.AngajatId         = AngajatID;
                istTraining.TrainingId        = TrainingID;
                istTraining.DataStart         = Utilities.ConvertText2DateTime(txtDataStart.Text);
                istTraining.DataEnd           = Utilities.ConvertText2DateTime(txtDataEnd.Text);
                istTraining.InsertIstoricTraining();

                tipTraining.SelectedIndex = 0;
            }
            catch (Exception ex)
            {
                litError.Text  = "The following error occurred: <br>";
                litError.Text += ex.Message;
            }

            LoadFormIstoricTraining();
        }
        /// <summary>
        /// Listeaza training-urile unui angajat
        /// </summary>
        private void LoadFormIstoricTraining()
        {
            try
            {
                settings = Salaries.Configuration.ModuleConfig.GetSettings();
                UtilitiesDb utilDb = new UtilitiesDb(settings.ConnectionString);
                utilDb.CreateInternalTrainingSelectBox(this.lstTraining);
                if (this.lstTraining.Items.Count == 0)
                {
                    this.tipTraining.Items.RemoveAt(0);
                }
                utilDb.CreateExternalTrainingSelectBox(this.lstTraining2);
                if (this.lstTraining2.Items.Count == 0)
                {
                    this.tipTraining.Items.RemoveAt(1);
                }

                listTable.Rows.Clear();
                listTable2.Rows.Clear();

                listTable.Attributes.Add("width", "100%");
                listTable.Style.Add("border", "1px solid #20b2aa");
                listTable.Attributes.Add("cellpadding", "0");
                listTable.Attributes.Add("cellspacing", "1");

                listTable2.Attributes.Add("width", "100%");
                listTable2.Style.Add("border", "1px solid #20b2aa");
                listTable2.Attributes.Add("cellpadding", "0");
                listTable2.Attributes.Add("cellspacing", "1");


                Salaries.Business.IstoricTraining istTraining = new Salaries.Business.IstoricTraining();
                istTraining.AngajatId = AngajatID;

                string[] arHeader = { "Tip Training", "Descriere", "Diploma", "Data start", "Data end" };
                string[] arCols   = { "Nume", "Descriere", "Diploma", "DataStart", "DataEnd" };

                ListTable objListTable  = new ListTable(listTable, istTraining.LoadIstoricTraining(true), arHeader, arCols);
                ListTable objListTable2 = new ListTable(listTable2, istTraining.LoadIstoricTraining(false), arHeader, arCols);

                objListTable.textForEmptyDataSet  = "Nu exista nici un training intern asociat acestui angajat!";
                objListTable2.textForEmptyDataSet = "Nu exista nici un training extern  asociat acestui angajat!";

                string[] ar_OnClickParam     = { "IstoricTrainingID", "Intern", "TrainingID", "DataStart", "DataEnd", AngajatID.ToString() };
                string[] ar_OnClickParamType = { "dataset", "dataset", "dataset", "dataset", "dataset", "const" };

                objListTable.OnclickParams     = ar_OnClickParam;
                objListTable.OnclickParamsType = ar_OnClickParamType;
                objListTable.OnclickJSMethod   = "SelectTraining";

                objListTable2.OnclickParams     = ar_OnClickParam;
                objListTable2.OnclickParamsType = ar_OnClickParamType;
                objListTable2.OnclickJSMethod   = "SelectTraining";


                objListTable.DrawListTableWithoutDigits();
                objListTable2.DrawListTableWithoutDigits();
            }
            catch (Exception ex)
            {
                litError.Text  = "The following error occurred: <br>";
                litError.Text += ex.Message;
            }
        }