Ejemplo n.º 1
0
        private void DgvListaLocatii_StergereLinie(CCL.UI.DataGridViewPersonalizat pDGVSender, int pIndexRand)
        {
            if (this.lSeIncarca)
            {
                return;
            }
            try
            {
                incepeIncarcarea();

                BLocatii locatieDeSters = this.dgvListaLocatii.Rows[pIndexRand].Tag as BLocatii;

                if (locatieDeSters != null)
                {
                    if (Mesaj.Confirmare(this.GetFormParinte(), BMultiLingv.getElementById(BMultiLingv.EnumDictionar.ConfirmatiStergerea), locatieDeSters.Denumire))
                    {
                        locatieDeSters.Close(true, BMultiLingv.getElementById(BMultiLingv.EnumDictionar.Stergere), null);
                        ConstruiesteRanduriDGV();
                    }
                }
            }
            catch (Exception ex)
            {
                GestiuneErori.AfiseazaMesaj(this.GetFormParinte(), ex);
            }
            finally
            {
                finalizeazaIncarcarea();
            }
        }
Ejemplo n.º 2
0
        private void BtnFiscalizeaza_Click(object sender, EventArgs e)
        {
            if (this.lSeIncarca)
            {
                return;
            }
            try
            {
                incepeIncarcarea();

                BLocatii firma        = BLocatii.GetLocatieCurenta();
                string   serieFactura = firma.SerieFacturi;

                if (serieFactura == string.Empty)
                {
                    Mesaj.Informare(this.GetFormParinte(), string.Format("{0}: {1}", BMultiLingv.getElementById(BMultiLingv.EnumDictionar.NuExistaSerieFacturaAlocataPeLocatie), firma.Denumire), BMultiLingv.getElementById(BMultiLingv.EnumDictionar.Facturare));
                }
                else
                {
                    this.lFactura.Fiscalizeaza(null);

                    inchideEcranulOK();
                }
            }
            catch (Exception ex)
            {
                GestiuneErori.AfiseazaMesaj(this.GetFormParinte(), ex);
            }
            finally
            {
                finalizeazaIncarcarea();
            }
        }
Ejemplo n.º 3
0
        private void DgvListaLocatii_EditareLinie(CCL.UI.DataGridViewPersonalizat pDGVSender, int pIndexRand)
        {
            if (this.lSeIncarca)
            {
                return;
            }
            try
            {
                incepeIncarcarea();

                BLocatii locatieDeModificat = this.dgvListaLocatii.Rows[pIndexRand].Tag as BLocatii;

                if (locatieDeModificat != null)
                {
                    if (FormDetaliuLocatie.Afiseaza(this.GetFormParinte(), locatieDeModificat))
                    {
                        incarcaRand(this.dgvListaLocatii.Rows[pIndexRand], locatieDeModificat);
                    }
                }
            }
            catch (Exception ex)
            {
                GestiuneErori.AfiseazaMesaj(this.GetFormParinte(), ex);
            }
            finally
            {
                finalizeazaIncarcarea();
            }
        }
Ejemplo n.º 4
0
        public static void Imprima(Form pEcranParinte, BClientiFacturi pFactura)
        {
            if (pFactura == null)
            {
                return;
            }

            lFactura        = pFactura;
            lLocatieFiscala = BLocatii.GetLocatieCurenta();

            //Selectam imprimanta
            using (PrintDocument imprimanta = SetupThePrinting(pEcranParinte, pFactura.ToStringImprimare()))
            {
                if (imprimanta != null)
                {
                    lLiniiRegistru = pFactura.GetListaLucrari(null);

                    using (PrintPreviewDialog ppDialog = new PrintPreviewDialog())
                    {
                        ppDialog.ShowIcon = false;
                        ppDialog.Document = imprimanta;

                        CCL.UI.IHMUtile.DeschideEcran(pEcranParinte, ppDialog);
                    }
                }
            }
        }
Ejemplo n.º 5
0
 public static bool Afiseaza(Form pEcranPariente, BLocatii pLocatie)
 {
     using (FormDetaliuLocatie ecran = new FormDetaliuLocatie(pLocatie))
     {
         ecran.AplicaPreferinteleUtilizatorului();
         return(CCL.UI.IHMUtile.DeschideEcran(pEcranPariente, ecran));
     }
 }
Ejemplo n.º 6
0
        private void incarcaRand(DataGridViewRow pRand, BLocatii pElem)
        {
            pRand.Tag = pElem;

            DataGridViewPersonalizat.InitCelulaEditare(pRand, this.lEcranInModificare);
            pRand.Cells[EnumColoaneDGV.colDenumire.ToString()].Value        = pElem.Denumire;
            pRand.Cells[EnumColoaneDGV.colInitiala.ToString()].Value        = pElem.InitialaLocatie;
            pRand.Cells[EnumColoaneDGV.colDenumireFiscala.ToString()].Value = pElem.DenumireFiscala;
            pRand.Cells[EnumColoaneDGV.colInfoContact.ToString()].Value     = pElem.InfoContact;
            DataGridViewPersonalizat.InitCelulaStergere(pRand);
        }
Ejemplo n.º 7
0
        internal bool Salveaza()
        {
            bool esteValid = BLocatii.SuntInformatiileNecesareCoerente(this.txtDenumireLocatie.Text, this.cboTipLocatie.SelectedIndex);

            if (this.lLocatie == null)
            {
                if (esteValid)
                {
                    BLocatii.Add(this.txtDenumireLocatie.Text, this.cboTipLocatie.SelectedIndex, 0, 0, 0, 0, 0, this.txtTelefonMobilLocatie.Text, this.txtFaxLocatie.Text, this.txtSkypeLocatie.Text, this.txtContYMLocatie.Text, this.txtMailLocatie.Text, this.txtPaginaWebLocatie.Text, this.txtInfoContactLocatie.Text, this.picLogoLocatie.ImageLocation, 0, this.txtDenumireFiscalaLocatie.Text, getTipFiscalitate(), this.txtCodFiscalLocatie.Text, this.txtNrInregistrareLocatie.Text, this.txtIbanLocatie.Text, this.txtBancaLocatie.Text, this.txtReprezentantLegalLocatie.Text, this.txtCalitateReprezentantLocatie.Text, this.txtSerieChitanteLocatie.Text, CUtil.GetAsInt32(this.txtNrInregistrareLocatie.Text), this.txtSerieFacturiLocatie.Text, 0, this.chkTvaLocatie.Checked, this.txtInitialaLocatie.Text, 0, this.ctrlGestiuneCuloareLocatie.CuloareARGB, null);
                }
                else
                {
                    seteazaAlerta();
                }
            }
            else
            {
                this.lLocatie.Denumire                  = this.txtDenumireLocatie.Text;
                this.lLocatie.InitialaLocatie           = this.txtInitialaLocatie.Text;
                this.lLocatie.TipLocatie                = this.cboTipLocatie.SelectedIndex;
                this.lLocatie.Culoare                   = this.ctrlGestiuneCuloareLocatie.CuloareARGB;
                this.lLocatie.InfoContact               = this.txtInfoContactLocatie.Text;
                this.lLocatie.AdresaMail                = this.txtMailLocatie.Text;
                this.lLocatie.ContSkype                 = this.txtSkypeLocatie.Text;
                this.lLocatie.Fax                       = this.txtFaxLocatie.Text;
                this.lLocatie.ContYM                    = this.txtContYMLocatie.Text;
                this.lLocatie.PaginaWeb                 = this.txtPaginaWebLocatie.Text;
                this.lLocatie.TelefonMobil              = this.txtTelefonMobilLocatie.Text;
                this.lLocatie.DenumireFiscala           = this.txtDenumireFiscalaLocatie.Text;
                this.lLocatie.Logo                      = this.picLogoLocatie.ImageLocation;
                this.lLocatie.TipFiscalitate            = getTipFiscalitate();
                this.lLocatie.PlatitorDeTVA             = this.chkTvaLocatie.Checked;
                this.lLocatie.CodFiscal                 = this.txtCodFiscalLocatie.Text;
                this.lLocatie.NumarInregistrare         = this.txtNrInregistrareLocatie.Text;
                this.lLocatie.ContIBAN                  = this.txtIbanLocatie.Text;
                this.lLocatie.DenumireBanca             = this.txtBancaLocatie.Text;
                this.lLocatie.ReprezentantLegal         = this.txtReprezentantLegalLocatie.Text;
                this.lLocatie.CalitateReprezentantLegal = this.txtCalitateReprezentantLocatie.Text;
                this.lLocatie.SerieChitante             = this.txtSerieChitanteLocatie.Text;
                this.lLocatie.NumarUltimaChitanta       = CUtil.GetAsInt32(this.txtNrUltimaChitantaLocatie.Text);
                this.lLocatie.SerieFacturi              = this.txtSerieFacturiLocatie.Text;
                this.lLocatie.NumarUltimaFactura        = CUtil.GetAsInt32(this.txtNrUltimaFacturaLocatie.Text);
                if (esteValid)
                {
                    this.lLocatie.UpdateAll();
                }
                else
                {
                    seteazaAlerta();
                }
            }
            return(esteValid);
        }
Ejemplo n.º 8
0
        private FormDetaliuLocatie(BLocatii pLocatie)
        {
            this.DoubleBuffered = true;
            InitializeComponent();

            this.lLocatie = pLocatie;

            if (!CCL.UI.IHMUtile.SuntemInDebug())
            {
                adaugaHandlere();
                initTextML();

                this.CentratCuDeplasare();
            }
        }
Ejemplo n.º 9
0
        private void ConstruiesteRanduriDGV()
        {
            this.dgvListaLocatii.IncepeContructieRanduri();

            var listaElem = BLocatii.GetListByParam(CDL.iStomaLab.CDefinitiiComune.EnumStare.Activa, null);

            //Incarcam lista
            foreach (var elem in listaElem)
            {
                incarcaRand(this.dgvListaLocatii.Rows[this.dgvListaLocatii.Rows.Add()], elem);
            }

            this.dgvListaLocatii.FinalizeazaContructieRanduri();

            this.lblTotalLocatii.Text = BMultiLingv.getElementById(BMultiLingv.EnumDictionar.Total) + this.dgvListaLocatii.RowCount.ToString();
        }
Ejemplo n.º 10
0
        private FormDetaliuLocatie(BLocatii pLocatie)
        {
            this.DoubleBuffered = true;
            InitializeComponent();

            this.picLogoLocatie.SizeMode = System.Windows.Forms.PictureBoxSizeMode.Zoom;

            this.lLocatie = pLocatie;

            if (!CCL.UI.IHMUtile.SuntemInDebug())
            {
                adaugaHandlere();
                initTextML();

                this.CentratCuDeplasare();
            }
        }
Ejemplo n.º 11
0
        private void incarcaRand(DataGridViewRow pRand, BLocatii pElem)
        {
            pRand.Tag = pElem;

            DataGridViewPersonalizat.InitCelulaEditare(pRand, this.lEcranInModificare);
            pRand.Cells[EnumColoaneDGV.colDenumire.ToString()].Value = pElem.Denumire;
            //pRand.Cells[EnumColoaneDGV.colInitiala.ToString()].Value = pElem.InitialaLocatie;
            pRand.Cells[EnumColoaneDGV.colDenumireFiscala.ToString()].Value = pElem.DenumireFiscala;
            pRand.Cells[EnumColoaneDGV.colInfoContact.ToString()].Value     = pElem.InfoContact;

            pRand.Cells[EnumColoaneDGV.colSerieFacturi.ToString()].Value          = pElem.SerieFacturi;
            pRand.Cells[EnumColoaneDGV.colNumarulUltimeiFacturi.ToString()].Value = pElem.NumarUltimaFactura;

            pRand.Cells[EnumColoaneDGV.colSerieChitante.ToString()].Value          = pElem.SerieChitante;
            pRand.Cells[EnumColoaneDGV.colNumarulUltimeiChitante.ToString()].Value = pElem.NumarUltimaChitanta;

            DataGridViewPersonalizat.InitCelulaStergere(pRand);
        }
Ejemplo n.º 12
0
        public void Fiscalizeaza(IDbTransaction pTranzactie)
        {
            IDbTransaction Tranzactie = null;

            try
            {
                if (pTranzactie == null)
                {
                    Tranzactie = CCL.DAL.CCerereSQL.GetTransactionOnConnection();
                }
                else
                {
                    Tranzactie = pTranzactie;
                }

                BLocatii firma = BLocatii.GetLocatieCurenta();

                this.SerieFactura = firma.SerieFacturi;
                this.NumarFactura = firma.NumarUltimaFactura + 1;
                this.UpdateAll(Tranzactie);

                firma.NumarUltimaFactura = this.NumarFactura;
                firma.UpdateAll(Tranzactie);

                if (pTranzactie == null)
                {
                    //Facem Comit tranzactiei doar daca aceasta nu a fost transmisa in parametru. Altfel comitul va fi gestionat de functia apelanta
                    CCL.DAL.CCerereSQL.CloseTransactionOnConnection(Tranzactie, true);
                }
            }
            catch (Exception)
            {
                if ((pTranzactie == null) && (Tranzactie != null))
                {
                    CCL.DAL.CCerereSQL.CloseTransactionOnConnection(Tranzactie, false);
                }
                throw;
            }
        }
Ejemplo n.º 13
0
        public static bool Afiseaza(Form pEcranPariente, BLocatii pLocatie)
        {
            if (pLocatie == null)
            {
                string denumire = CCL.UI.IHMUtile.GetTextSimpluUtilizator(pEcranPariente, BMultiLingv.getElementById(BMultiLingv.EnumDictionar.Denumire), BLocatii.StructCampuriTabela.DenumireMaxLength);

                if (string.IsNullOrEmpty(denumire))
                {
                    return(false);
                }
                else
                {
                    int idLocatieAdaugata = BLocatii.Add(denumire, null);

                    pLocatie = new BLocatii(idLocatieAdaugata, null);
                }
            }

            using (FormDetaliuLocatie ecran = new FormDetaliuLocatie(pLocatie))
            {
                ecran.AplicaPreferinteleUtilizatorului();
                return(CCL.UI.IHMUtile.DeschideEcran(pEcranPariente, ecran));
            }
        }
Ejemplo n.º 14
0
        private void ConstruiesteRanduriDGV()
        {
            var listaElem = BLocatii.GetListByParam(CDL.iStomaLab.CDefinitiiComune.EnumStare.Toate, null);

            if (listaElem.ContineElementeDeactivate())
            {
                this.btnActiviInactivi.Visible = true;
            }
            else
            {
                this.btnActiviInactivi.Visible  = false;
                this.btnActiviInactivi.Selectat = false;
            }


            if (!this.btnActiviInactivi.Selectat)
            {
                ConstruiesteRanduriDGV(listaElem.GetListaActive());
            }
            else
            {
                ConstruiesteRanduriDGV(listaElem.GetListaInactive());
            }
        }
Ejemplo n.º 15
0
        public void Initializeaza(BLocatii pLocatie)
        {
            base.InitializeazaVariabileleGenerale();

            incepeIncarcarea();

            this.lLocatie = pLocatie;
            initListe();

            if (this.lLocatie == null)
            {
                this.txtDenumireLocatie.Goleste();
                this.txtInitialaLocatie.Goleste();
                this.txtLocatie.Goleste();
                this.ctrlGestiuneCuloareLocatie.Goleste();
                this.txtInfoContactLocatie.Goleste();
                this.txtMailLocatie.Goleste();
                this.txtSkypeLocatie.Goleste();
                this.txtFaxLocatie.Goleste();
                this.txtTelefonMobilLocatie.Goleste();
                this.txtContYMLocatie.Goleste();
                this.txtPaginaWebLocatie.Goleste();
                this.txtDenumireFiscalaLocatie.Goleste();
                this.chkTvaLocatie.Checked = false;
                this.rbCmiLocatie.Checked  = false;
                this.rbSrlLocatie.Checked  = false;
                this.txtCodFiscalLocatie.Goleste();
                this.txtNrInregistrareLocatie.Goleste();
                this.txtIbanLocatie.Goleste();
                this.txtIbanLocatie.CapitalizeazaPrimaLitera = true;
                this.txtCalitateReprezentantLocatie.CapitalizeazaPrimaLitera = true;
                this.txtBancaLocatie.Goleste();
                this.txtReprezentantLegalLocatie.Goleste();
                this.txtCalitateReprezentantLocatie.Goleste();
                this.txtSerieChitanteLocatie.Goleste();
                this.txtNrUltimaChitantaLocatie.Goleste();
                this.txtSerieFacturiLocatie.Goleste();
                this.txtNrUltimaFacturaLocatie.Goleste();
            }
            else
            {
                this.txtDenumireLocatie.Text     = pLocatie.Denumire;
                this.txtInitialaLocatie.Text     = pLocatie.InitialaLocatie;
                this.cboTipLocatie.SelectedIndex = pLocatie.TipLocatie;
                this.ctrlGestiuneCuloareLocatie.Initializeaza(pLocatie.Culoare);
                this.txtInfoContactLocatie.Text  = pLocatie.InfoContact;
                this.txtMailLocatie.Text         = pLocatie.AdresaMail;
                this.txtSkypeLocatie.Text        = pLocatie.ContSkype;
                this.txtFaxLocatie.Text          = pLocatie.Fax;
                this.txtTelefonMobilLocatie.Text = pLocatie.TelefonMobil;
                this.txtContYMLocatie.Text       = pLocatie.ContYM;
                this.txtPaginaWebLocatie.Text    = pLocatie.PaginaWeb;
                if (!string.IsNullOrEmpty(this.lLocatie.Logo))
                {
                    this.picLogoLocatie.Image = CCL.UI.Imagini.GetThumbnailImage(CCL.UI.IHMUtile.getImagineDinFisier(lLocatie.Logo), 90, 90, true);
                }
                this.txtDenumireFiscalaLocatie.Text      = pLocatie.DenumireFiscala;
                this.chkTvaLocatie.Checked               = pLocatie.PlatitorDeTVA;
                this.rbCmiLocatie.Checked                = pLocatie.TipFiscalitate == 1 ? true : false;
                this.rbSrlLocatie.Checked                = pLocatie.TipFiscalitate == 2 ? true : false;
                this.txtCodFiscalLocatie.Text            = pLocatie.CodFiscal;
                this.txtNrInregistrareLocatie.Text       = pLocatie.NumarInregistrare;
                this.txtIbanLocatie.Text                 = pLocatie.ContIBAN;
                this.txtBancaLocatie.Text                = pLocatie.DenumireBanca;
                this.txtReprezentantLegalLocatie.Text    = pLocatie.ReprezentantLegal;
                this.txtCalitateReprezentantLocatie.Text = pLocatie.CalitateReprezentantLegal;
                this.txtSerieChitanteLocatie.Text        = pLocatie.SerieChitante;
                this.txtNrUltimaChitantaLocatie.Text     = pLocatie.NumarUltimaChitanta.ToString();
                this.txtSerieFacturiLocatie.Text         = pLocatie.SerieFacturi;
                this.txtNrUltimaFacturaLocatie.Text      = pLocatie.NumarUltimaFactura.ToString();
            }

            finalizeazaIncarcarea();
        }
Ejemplo n.º 16
0
        private void bwBDD_DoWork(object sender, DoWorkEventArgs e)
        {
            try
            {
                this.bwBDD.ReportProgress(1, (int)EnumScripturi.CreareBDD);

                //Recuperam informatiile de pe iStoma doar daca reusim sa cream baza de date
                CGestiuneIO.creazaBDD(this.lNumeServer, this.lNumeInstanta, this.lNumeUser, this.lParolaSQL, this.lNumeBDD, this.chkServerulEstePeAcestCalculator.Checked);

                string parolaHash = CSecuritate.GetMd5Hash(this.lParolaISTOMA);

                //recuperam scripturile de creare
                Dictionary <EnumScripturi, byte[]> dictScripturi = new Dictionary <EnumScripturi, byte[]>();
                //0 = nume
                //1 = prenume
                //2 = cnp
                //3 = versiune BDD
                //4 = denumire cabinet
                //5 = nr tel
                //6 = mail
                //7 = site
                //8 = data de nastere zzLLaaaa
                //9 = limba vorbita
                //10 = tara clientului
                List <string> detaliiUser = null;

                this.bwBDD.ReportProgress(5, (int)EnumScripturi.RecuperareInformatii);

                //ne legam la serviciu
                iStoma.VerificareSoapClient servVerif = new iStoma.VerificareSoapClient();

                dictScripturi.Add(EnumScripturi.Tabele, servVerif.IncarcaTabele(this.lCodClient, parolaHash));
                dictScripturi.Add(EnumScripturi.View, servVerif.IncarcaView(this.lCodClient, parolaHash));
                dictScripturi.Add(EnumScripturi.PS, servVerif.IncarcaPS(this.lCodClient, parolaHash));
                dictScripturi.Add(EnumScripturi.Tari, servVerif.IncarcaTari(this.lCodClient, parolaHash));
                dictScripturi.Add(EnumScripturi.Regiuni, servVerif.IncarcaRegiuni(this.lCodClient, parolaHash));
                dictScripturi.Add(EnumScripturi.Localitati, servVerif.IncarcaLocalitati(this.lCodClient, parolaHash));
                //dictScripturi.Add(EnumScripturi.CP, servVerif.IncarcaCP(this.lCodClient, parolaHash));
                //dictScripturi.Add(EnumScripturi.COR, servVerif.IncarcaCOR(this.lCodClient, parolaHash));
                //dictScripturi.Add(EnumScripturi.CAEN, servVerif.IncarcaCAEN(this.lCodClient, parolaHash));
                dictScripturi.Add(EnumScripturi.SMTP, servVerif.IncarcaSMTP(this.lCodClient, parolaHash));
                //dictScripturi.Add(EnumScripturi.Drepturi, servVerif.IncarcaDrepturi(this.lCodClient, parolaHash));
                //dictScripturi.Add(EnumScripturi.Meniu, servVerif.IncarcaMeniu(this.lCodClient, parolaHash));
                //dictScripturi.Add(EnumScripturi.Citate, servVerif.IncarcaCitate(this.lCodClient, parolaHash));
                //dictScripturi.Add(EnumScripturi.MultiLingv, servVerif.IncarcaMultiLingv(this.lCodClient, parolaHash));
                //dictScripturi.Add(EnumScripturi.Afectiuni, servVerif.IncarcaAfectiuni(this.lCodClient, parolaHash));
                //dictScripturi.Add(EnumScripturi.OrganeArtificiale, servVerif.IncarcaOrganeArtificiale(this.lCodClient, parolaHash));
                //dictScripturi.Add(EnumScripturi.ProduseGestiune, servVerif.IncarcaProduseGestiune(this.lCodClient, parolaHash));
                //dictScripturi.Add(EnumScripturi.Interventii, servVerif.IncarcaInterventii(this.lCodClient, parolaHash));
                //dictScripturi.Add(EnumScripturi.TratamenteAdministrative, servVerif.IncarcaTratamenteAdministrative(this.lCodClient, parolaHash));
                //dictScripturi.Add(EnumScripturi.EvenimenteCalendaristice, servVerif.IncarcaEvenimenteCalendaristice(this.lCodClient, parolaHash));

                detaliiUser = servVerif.GetInformatiiClient(this.lCodClient, parolaHash);

                BMultiLingv.EnumLimba limbaUtilizator = BMultiLingv.EnumLimba.Romana;
                int idTaraClient = BTari.ConstIDRomania;

                //LIMBA
                try
                {
                    if (detaliiUser.Count > 9)
                    {
                        limbaUtilizator = (BMultiLingv.EnumLimba)Convert.ToInt32(detaliiUser[9]);
                    }
                }
                catch (Exception)
                {
                }

                //TARA
                try
                {
                    if (detaliiUser.Count > 9)
                    {
                        idTaraClient = Convert.ToInt32(detaliiUser[10]);
                    }
                }
                catch (Exception)
                {
                }

                //List<string> listaRecomandari = servVerif.IncarcaRecomandari(this.lCodClient, parolaHash);

                servVerif.Close();

                string continutFisierSQL = string.Empty;

                this.bwBDD.ReportProgress(10, (int)EnumScripturi.Tabele);

                //Tabele
                continutFisierSQL = CGestiuneIO.DeCompreseazaText(dictScripturi[EnumScripturi.Tabele]);
                CGestiuneIO.executaFisierSQL(this.lNumeServer, this.lNumeInstanta, this.lNumeUser, this.lParolaSQL, this.chkServerulEstePeAcestCalculator.Checked, this.lNumeBDD, continutFisierSQL);

                this.bwBDD.ReportProgress(13, (int)EnumScripturi.View);

                //View
                continutFisierSQL = CGestiuneIO.DeCompreseazaText(dictScripturi[EnumScripturi.View]);
                CGestiuneIO.executaFisierSQL(this.lNumeServer, this.lNumeInstanta, this.lNumeUser, this.lParolaSQL, this.chkServerulEstePeAcestCalculator.Checked, this.lNumeBDD, continutFisierSQL, "-$$$-");

                this.bwBDD.ReportProgress(16, (int)EnumScripturi.PS);

                //PS
                continutFisierSQL = CGestiuneIO.DeCompreseazaText(dictScripturi[EnumScripturi.PS]);
                CGestiuneIO.executaFisierSQL(this.lNumeServer, this.lNumeInstanta, this.lNumeUser, this.lParolaSQL, this.chkServerulEstePeAcestCalculator.Checked, this.lNumeBDD, continutFisierSQL, "-$$$-");

                this.bwBDD.ReportProgress(20, (int)EnumScripturi.Tari);

                //Populam tabelele nou create
                //TARI
                continutFisierSQL = CGestiuneIO.DeCompreseazaText(dictScripturi[EnumScripturi.Tari]);
                CGestiuneIO.executaFisierSQL(this.lNumeServer, this.lNumeInstanta, this.lNumeUser, this.lParolaSQL, this.chkServerulEstePeAcestCalculator.Checked, this.lNumeBDD, continutFisierSQL);

                this.bwBDD.ReportProgress(23, (int)EnumScripturi.Regiuni);

                //REGIUNI
                continutFisierSQL = CGestiuneIO.DeCompreseazaText(dictScripturi[EnumScripturi.Regiuni]);
                CGestiuneIO.executaFisierSQL(this.lNumeServer, this.lNumeInstanta, this.lNumeUser, this.lParolaSQL, this.chkServerulEstePeAcestCalculator.Checked, this.lNumeBDD, continutFisierSQL);

                this.bwBDD.ReportProgress(28, (int)EnumScripturi.Localitati);

                //LOCALITATI
                continutFisierSQL = CGestiuneIO.DeCompreseazaText(dictScripturi[EnumScripturi.Localitati]);
                CGestiuneIO.executaFisierSQL(this.lNumeServer, this.lNumeInstanta, this.lNumeUser, this.lParolaSQL, this.chkServerulEstePeAcestCalculator.Checked, this.lNumeBDD, continutFisierSQL, "-$$$-");

                //this.bwBDD.ReportProgress(35, (int)EnumScripturi.CP);

                ////CODURI POSTALE
                //continutFisierSQL = CGestiuneIO.DeCompreseazaText(dictScripturi[EnumScripturi.CP]);
                //CGestiuneIO.executaFisierSQL(this.lNumeServer, this.lNumeInstanta, this.lNumeUser, this.lParolaSQL, this.chkServerulEstePeAcestCalculator.Checked, this.lNumeBDD, continutFisierSQL, "-$$$-");

                //this.bwBDD.ReportProgress(45, (int)EnumScripturi.COR);

                ////CODURI COR
                //continutFisierSQL = CGestiuneIO.DeCompreseazaText(dictScripturi[EnumScripturi.COR]);
                //CGestiuneIO.executaFisierSQL(this.lNumeServer, this.lNumeInstanta, this.lNumeUser, this.lParolaSQL, this.chkServerulEstePeAcestCalculator.Checked, this.lNumeBDD, continutFisierSQL, "-$$$-");

                //this.bwBDD.ReportProgress(55, (int)EnumScripturi.CAEN);

                ////CODURI CAEN
                //continutFisierSQL = CGestiuneIO.DeCompreseazaText(dictScripturi[EnumScripturi.CAEN]);
                //CGestiuneIO.executaFisierSQL(this.lNumeServer, this.lNumeInstanta, this.lNumeUser, this.lParolaSQL, this.chkServerulEstePeAcestCalculator.Checked, this.lNumeBDD, continutFisierSQL, "-$$$-");

                //this.bwBDD.ReportProgress(65, (int)EnumScripturi.Drepturi);

                ////DREPTURI
                //continutFisierSQL = CGestiuneIO.DeCompreseazaText(dictScripturi[EnumScripturi.Drepturi]);
                //CGestiuneIO.executaFisierSQL(this.lNumeServer, this.lNumeInstanta, this.lNumeUser, this.lParolaSQL, this.chkServerulEstePeAcestCalculator.Checked, this.lNumeBDD, continutFisierSQL);

                this.bwBDD.ReportProgress(67, (int)EnumScripturi.SMTP);

                //SMTP
                continutFisierSQL = CGestiuneIO.DeCompreseazaText(dictScripturi[EnumScripturi.SMTP]);
                CGestiuneIO.executaFisierSQL(this.lNumeServer, this.lNumeInstanta, this.lNumeUser, this.lParolaSQL, this.chkServerulEstePeAcestCalculator.Checked, this.lNumeBDD, continutFisierSQL);

                this.bwBDD.ReportProgress(70, (int)EnumScripturi.Citate);

                ////CITATE
                //continutFisierSQL = CGestiuneIO.DeCompreseazaText(dictScripturi[EnumScripturi.Citate]);
                //CGestiuneIO.executaFisierSQL(this.lNumeServer, this.lNumeInstanta, this.lNumeUser, this.lParolaSQL, this.chkServerulEstePeAcestCalculator.Checked, this.lNumeBDD, continutFisierSQL);

                //this.bwBDD.ReportProgress(73, (int)EnumScripturi.MultiLingv);

                ////MULTI LINGV
                //continutFisierSQL = CGestiuneIO.DeCompreseazaText(dictScripturi[EnumScripturi.MultiLingv]);
                //CGestiuneIO.executaFisierSQL(this.lNumeServer, this.lNumeInstanta, this.lNumeUser, this.lParolaSQL, this.chkServerulEstePeAcestCalculator.Checked, this.lNumeBDD, continutFisierSQL, "-$$$-");

                //this.bwBDD.ReportProgress(78, (int)EnumScripturi.Meniu);

                ////MENIU
                //continutFisierSQL = CGestiuneIO.DeCompreseazaText(dictScripturi[EnumScripturi.Meniu]);
                //CGestiuneIO.executaFisierSQL(this.lNumeServer, this.lNumeInstanta, this.lNumeUser, this.lParolaSQL, this.chkServerulEstePeAcestCalculator.Checked, this.lNumeBDD, continutFisierSQL);

                //this.bwBDD.ReportProgress(80, (int)EnumScripturi.Afectiuni);

                //Activam conexiunea la noua BDD
                seteazaConexiuneBDD();

                ////Adaugam specialitatea Medicina dentara "Medicină dentară"
                //int idSpecialitateStomatologica = BLL.General.Comune.BSpecialitati.Add(BLL.General.BMultiLingvPC.getElementById(BLL.General.BMultiLingv.EnumDictionar.MedicinaDentara), false, true, false, false, true, true, null);

                ////ADAUGAM AFECTIUNILE SPECIFICE ACESTEI SPECIALITATI
                //continutFisierSQL = CGestiuneIO.DeCompreseazaText(dictScripturi[EnumScripturi.Afectiuni]);
                //CGestiuneIO.executaFisierSQL(this.lNumeServer, this.lNumeInstanta, this.lNumeUser, this.lParolaSQL, this.chkServerulEstePeAcestCalculator.Checked, this.lNumeBDD, continutFisierSQL);

                //this.bwBDD.ReportProgress(82, (int)EnumScripturi.OrganeArtificiale);

                ////ADAUGAM ORGANELE ARTIFICIALE
                //continutFisierSQL = CGestiuneIO.DeCompreseazaText(dictScripturi[EnumScripturi.OrganeArtificiale]);
                //CGestiuneIO.executaFisierSQL(this.lNumeServer, this.lNumeInstanta, this.lNumeUser, this.lParolaSQL, this.chkServerulEstePeAcestCalculator.Checked, this.lNumeBDD, continutFisierSQL);

                //this.bwBDD.ReportProgress(85, (int)EnumScripturi.ProduseGestiune);

                ////ADAUGAM PRODUSELE DE GESTIUNE
                //continutFisierSQL = CGestiuneIO.DeCompreseazaText(dictScripturi[EnumScripturi.ProduseGestiune]);
                //CGestiuneIO.executaFisierSQL(this.lNumeServer, this.lNumeInstanta, this.lNumeUser, this.lParolaSQL, this.chkServerulEstePeAcestCalculator.Checked, this.lNumeBDD, continutFisierSQL);

                //this.bwBDD.ReportProgress(87, (int)EnumScripturi.Interventii);

                ////ADAUGAM INTERVENTIILE
                //continutFisierSQL = CGestiuneIO.DeCompreseazaText(dictScripturi[EnumScripturi.Interventii]);
                //CGestiuneIO.executaFisierSQL(this.lNumeServer, this.lNumeInstanta, this.lNumeUser, this.lParolaSQL, this.chkServerulEstePeAcestCalculator.Checked, this.lNumeBDD, continutFisierSQL);

                //Setam versiunea BDD
                CGestiuneIO.executaFisierSQL(this.lNumeServer, this.lNumeInstanta, this.lNumeUser, this.lParolaSQL, this.chkServerulEstePeAcestCalculator.Checked, this.lNumeBDD,
                                             string.Format("INSERT INTO VersiuniBDD_TD(tVersiune) VALUES ('{0}')", detaliiUser[3]));

                //Adaugam utilizatorul cu specialitatea stomatolog
                int idUser = BUtilizator.Add(this.lCodClient, this.lParolaISTOMA, detaliiUser[0], detaliiUser[1], detaliiUser[2]);

                //Actualizam informatiile clientului cu cele pe care ni le-a furnizat
                BUtilizator userCreat = BUtilizator.GetById(idUser, null);
                userCreat.TelefonMobil = detaliiUser[5];
                userCreat.AdresaMail   = detaliiUser[6];
                userCreat.PaginaWeb    = detaliiUser[7];
                userCreat.Titulatura   = CDefinitiiComune.EnumTitulatura.Doctor;
                userCreat.DataNastere  = CUtil.getDateFromString(detaliiUser[8]);
                //userCreat.Rol = BUtilizator.EnumRolUtilizator.Medic;
                userCreat.NumarOrdine = 1;
                //userCreat.UltimaOptiuneAccesata = BLL.General.BMeniu.EnumOptiune.SetariInitiale;
                userCreat.UpdateAll(null);

                //this.bwBDD.ReportProgress(95, (int)EnumScripturi.TratamenteAdministrative);

                ////ADAUGAM TRATAMENTELE ADMINISTRATIVE
                //continutFisierSQL = CGestiuneIO.DeCompreseazaText(dictScripturi[EnumScripturi.TratamenteAdministrative]);
                //CGestiuneIO.executaFisierSQL(this.lNumeServer, this.lNumeInstanta, this.lNumeUser, this.lParolaSQL, this.chkServerulEstePeAcestCalculator.Checked, this.lNumeBDD, continutFisierSQL, "-$$$-");

                //this.bwBDD.ReportProgress(96, (int)EnumScripturi.EvenimenteCalendaristice);

                ////EVENIMENTE CALENDARISTICE - Avem nevoie de utilizator
                //continutFisierSQL = CGestiuneIO.DeCompreseazaText(dictScripturi[EnumScripturi.EvenimenteCalendaristice]);
                //CGestiuneIO.executaFisierSQL(this.lNumeServer, this.lNumeInstanta, this.lNumeUser, this.lParolaSQL, this.chkServerulEstePeAcestCalculator.Checked, this.lNumeBDD, continutFisierSQL);

                //string numeRadacinaDefault = "Clinica de stomatologie";
                //string numeGrupDefault = "Grup";
                string numeSediuDefault = "Stoma";
                //string numeSectieDefault = "Medicină dentară";
                //string numeCabinet1Default = "Cabinet 1";

                //Adaugam locatia medicala (Asociatie + grup + sediu + uf)
                //string numeRadacina = detaliiUser[4];
                string numeSediu = detaliiUser[4];

                //if (string.IsNullOrEmpty(numeRadacina))
                //    numeRadacina = numeRadacinaDefault;

                if (string.IsNullOrEmpty(numeSediu))
                {
                    numeSediu = numeSediuDefault;
                }

                int idSediu = BLocatii.Add(numeSediu, null);

                //Adaugam adresa sediului
                BAdrese.Add(BAdrese.EnumTipAdresa.Principala, string.Empty, string.Empty, string.Empty, string.Empty,
                            string.Empty, string.Empty, string.Empty, idTaraClient, -1, -1, string.Empty, string.Empty, CDefinitiiComune.EnumTipObiect.Locatie, idSediu, null);

                //Vom considera ca radacina este locatia fiscala
                BLocatii sediu = new BLocatii(idSediu, null);

                //Setam tel si email pt sediu
                sediu.TelefonMobil = detaliiUser[5];
                sediu.AdresaMail   = detaliiUser[6];
                sediu.PaginaWeb    = detaliiUser[7];

                sediu.UpdateAll();
            }
            catch (Exception ex)
            {
                this.lExceptie = ex.Message;
            }
        }