internal bool Salveaza() { bool esteValid = BUtilizator.SuntInformatiileNecesareCoerente(this.txtNumePersonal.Text, getRol()); if (this.lUser == null) { if (esteValid) { BUtilizator.Add(this.txtNumePersonal.Text, this.txtPrenumePersonal.Text, this.txtCnpPersonal.Text, this.ctrlDataNasteriiPersonal.DataAfisata, getSexSelectat(), getTitulatura(), this.txtNumeDeFataPersonal.Text, this.txtSupranumePersonal.Text, getStareCivila(), this.cboNrCopiiPersonal.SelectedIndex, this.cboTipEducatiePersonal.SelectedIndex, this.txtScoalaPersonal.Text, 0, 0, 0, 0, getRol(), this.ctrlProfesiePersonal.IdObiectAfisajCorespunzator, this.txtObservatiiPersonal.Text, this.txtTelefonFixPersonal.Text, this.txtTelefonMobilPersonal.Text, string.Empty, this.txtSkypePersonal.Text, string.Empty, this.txtEmailPersonal.Text, string.Empty, string.Empty, 0, this.txtContStomaPersonal.Text, string.Empty, this.ctrlCuloarePersonal.CuloareARGB, this.cboTipActPersonal.SelectedIndex, this.txtSerieActPersonal.Text, this.txtNrActPersonal.Text, 0, 0, this.ctrlDataAngajarePersonal.DataAfisata, this.cboTipContract.SelectedIndex, this.ctrlDataContract.DataAfisata, this.ctrlDataIncetareContract.DataAfisata, CUtil.GetTextInt32(this.txtNrOreNorma.Text), CUtil.GetTextInt32(this.txtNrContract.Text), null, DateTime.Today, DateTime.Today, null, 0, 0, null); } else { seteazaAlerta(); } } else { lUser.Nume = this.txtNumePersonal.Text; lUser.Titulatura = getTitulatura();// this.cboTitulaturaPersonal.SelectedIndex; lUser.Prenume = this.txtPrenumePersonal.Text; lUser.Porecla = this.txtSupranumePersonal.Text; lUser.Sex = getSexSelectat(); lUser.NumeDeFata = this.txtNumeDeFataPersonal.Text; lUser.StareCivila = getStareCivila(); lUser.Educatie = (EnumNivelScolorizare)this.cboTipEducatiePersonal.GetSelectedValueAsInt32(); lUser.NumarCopii = this.cboNrCopiiPersonal.SelectedIndex; lUser.CNP = this.txtCnpPersonal.Text; lUser.TipActIdentitate = this.cboTipActPersonal.SelectedIndex; lUser.SerieActIdentitate = this.txtSerieActPersonal.Text; lUser.NumarActIdentitate = this.txtNrActPersonal.Text; lUser.Scoala = this.txtScoalaPersonal.Text; lUser.IdProfesie = this.ctrlProfesiePersonal.IdObiectAfisajCorespunzator; lUser.DataNastere = this.ctrlDataNasteriiPersonal.DataAfisata; lUser.TelefonMobil = this.txtTelefonMobilPersonal.Text; lUser.TelefonFix = this.txtTelefonFixPersonal.Text; lUser.AdresaMail = this.txtEmailPersonal.Text; lUser.ContSkype = this.txtSkypePersonal.Text; lUser.Culoare = this.ctrlCuloarePersonal.CuloareARGB; lUser.DataAngajare = this.ctrlDataAngajarePersonal.DataAfisata; lUser.ContStoma = this.txtContStomaPersonal.Text; lUser.Observatii = this.txtObservatiiPersonal.Text; lUser.Rol = getRol(); //this.cboRolPersonal.GetAs<BDefinitiiGenerale.StructRol>(BDefinitiiGenerale.StructRol.Empty).Id; lUser.TipContract = (BDefinitiiGenerale.EnumTipContract) this.cboTipContract.GetSelectedValueAsInt32(); lUser.DataContract = this.ctrlDataContract.DataAfisata; lUser.DataIncetareContract = this.ctrlDataIncetareContract.DataAfisata; lUser.OreNorma = CUtil.GetTextInt32(this.txtNrOreNorma.Text); lUser.NumarContract = CUtil.GetTextInt32(this.txtNrContract.Text); if (esteValid) { this.lUser.UpdateAll(); } else { seteazaAlerta(); } } return(esteValid); }
private void CtrlValidareAnulare_Validare(object sender, EventArgs e) { if (this.lSeIncarca) { return; } try { incepeIncarcarea(); BColectieUtilizator listaUtilizatoriExistenti = BUtilizator.GetListByParam(CDL.iStomaLab.CDefinitiiComune.EnumStare.Activa, CDefinitiiComune.EnumRol.Nedefinit, null); //List<string> listaNumePrenumeUtilizatoriExistenti = listaUtilizatoriExistenti.GetNumePrenumeUtilizatori(); foreach (DataGridViewRow row in this.dgvListaImportPersonal.Rows) { StructImportPersonal personal = (StructImportPersonal)row.Tag; BUtilizator userExistent = listaUtilizatoriExistenti.GetByIdentitate(string.Concat(personal.Nume, personal.Prenume).ToLower().Replace(" ", "")); if (userExistent == null) { BUtilizator.Add(personal.Nume, personal.Prenume, personal.DataNastere, personal.TelefonMobil, null); } } inchideEcranulOK(); } catch (Exception ex) { GestiuneErori.AfiseazaMesaj(this.GetFormParinte(), ex); } finally { finalizeazaIncarcarea(); } }
internal bool Salveaza() { bool esteValid = BUtilizator.SuntInformatiileNecesareCoerente(this.txtNume.Text, getRol()); if (esteValid) { string eroare = string.Empty; EnumSex sex = EnumSex.Nedefinit; DateTime dataNasterii = CConstante.DataNula; int codJudet = 0; int codLocalitate = 0; EnumTitulatura titulatura = EnumTitulatura.Nedefinit; bool nascutInRomania = false; CCL.iStomaLab.CUtil.ObtineInformatiiCNP(this.txtCnp.Text, ref eroare, ref sex, ref dataNasterii, ref codJudet, ref codLocalitate, ref titulatura, ref nascutInRomania); int id = BUtilizator.Add(this.txtNume.Text, this.txtPrenume.Text, this.txtCnp.Text, dataNasterii, sex, titulatura, string.Empty, string.Empty, 0, 0, 0, string.Empty, 0, 0, codJudet, codLocalitate, getRol(), 0, this.txtObservatii.Text, string.Empty, this.txtMobil.Text, string.Empty, string.Empty, string.Empty, this.txtEmail.Text, string.Empty, string.Empty, 0, this.txtContUtilizator.Text, this.txtParola.Text, getCuloareInitiala(), getTipAct(), this.txtSerie.Text, this.txtNr.Text, 0, CUtil.GetAsInt32(this.txtZileConcediu.Text), this.ctrlDataContract.DataAfisata, this.cboTipContract.SelectedIndex, this.ctrlDataContract.DataAfisata, CConstante.DataNula, CUtil.GetAsInt32(this.txtOreNorma.Text), CUtil.GetAsInt32(this.txtNrContract.Text), this.txtEmisDe.Text, this.ctrlValabilitateInceput.DataAfisata, this.ctrlValabilitateSfarsit.DataAfisata, this.txtIban.Text, this.ctrlCautareBanca.IdObiectAfisajCorespunzator, 0, null); BUtilizator utilizator = BUtilizator.GetById(id, null); utilizator.IdAdresa = getIdAdresa(utilizator.Id); utilizator.UpdateAll(); } return(esteValid); }
internal bool Salveaza() { bool esteValid = BUtilizator.SuntInformatiileNecesareCoerente(this.txtNumePersonal.Text, this.txtPrenumePersonal.Text, this.cboRolPersonal.SelectedIndex); if (this.lUser == null) { if (esteValid) { BUtilizator.Add(this.txtNumePersonal.Text, this.txtPrenumePersonal.Text, this.txtCnpPersonal.Text, this.ctrlDataNasteriiPersonal.DataAfisata, getSexSelectat(), this.cboTitulaturaPersonal.SelectedIndex, this.txtNumeDeFataPersonal.Text, this.txtSupranumePersonal.Text, this.cboStareCivilaPersonal.SelectedIndex, this.cboNrCopiiPersonal.SelectedIndex, this.cboTipEducatiePersonal.SelectedIndex, this.txtScoalaPersonal.Text, 0, 0, 0, 0, this.cboRolPersonal.SelectedIndex, this.ctrlProfesiePersonal.IdObiectAfisajCorespunzator, this.txtObservatiiPersonal.Text, this.txtTelefonFixPersonal.Text, this.txtTelefonMobilPersonal.Text, this.txtFaxPersonal.Text, this.txtSkypePersonal.Text, this.txtContYMPersonal.Text, this.txtEmailPersonal.Text, this.txtPaginaWebPersonal.Text, this.txtInfoContactPersonal.Text, 0, this.txtContStomaPersonal.Text, this.txtParolaPersonal.Text, this.ctrlCuloarePersonal.CuloareARGB, this.cboTipActPersonal.SelectedIndex, this.txtSerieActPersonal.Text, this.txtNrActPersonal.Text, 0, 0, this.ctrlDataAngajarePersonal.DataAfisata, this.cboTipContract.SelectedIndex, this.ctrlDataContract.DataAfisata, this.ctrlDataIncetareContract.DataAfisata, CUtil.GetTextInt32(this.txtNrOreNorma.Text), this.txtNrContract.Text, null); } else { seteazaAlerta(); } } else { lUser.Nume = this.txtNumePersonal.Text; lUser.Titulatura = this.cboTitulaturaPersonal.SelectedIndex; lUser.Prenume = this.txtPrenumePersonal.Text; lUser.Porecla = this.txtSupranumePersonal.Text; lUser.Sex = getSexSelectat(); lUser.NumeDeFata = this.txtNumeDeFataPersonal.Text; lUser.StareCivila = this.cboStareCivilaPersonal.SelectedIndex; lUser.Educatie = this.cboTipEducatiePersonal.SelectedIndex; lUser.NumarCopii = this.cboNrCopiiPersonal.SelectedIndex; lUser.CNP = this.txtCnpPersonal.Text; lUser.TipActIdentitate = this.cboTipActPersonal.SelectedIndex; lUser.SerieActIdentitate = this.txtSerieActPersonal.Text; lUser.NumarActIdentitate = this.txtNrActPersonal.Text; lUser.Scoala = this.txtScoalaPersonal.Text; lUser.IdProfesie = this.ctrlProfesiePersonal.IdObiectAfisajCorespunzator; lUser.DataNastere = this.ctrlDataNasteriiPersonal.DataAfisata; //this.cboNationalitatePersonal.DataSource=BDefinitiiGenerale.nat // lUser.IdImagineCurenta = this.ctrlImaginePersonal.IdPoza; // this.txtTaraPersonal.Goleste(); // this.txtJudetPersonal.Goleste(); // this.txtLocalitatePersonal.Text = lUser.IdLocalitateNastere.ToString(); lUser.TelefonMobil = this.txtTelefonMobilPersonal.Text; lUser.TelefonFix = this.txtTelefonFixPersonal.Text; lUser.Fax = this.txtFaxPersonal.Text; lUser.AdresaMail = this.txtEmailPersonal.Text; lUser.ContYM = this.txtContYMPersonal.Text; lUser.PaginaWeb = this.txtPaginaWebPersonal.Text; lUser.ContSkype = this.txtSkypePersonal.Text; lUser.InfoContact = this.txtInfoContactPersonal.Text; lUser.Culoare = this.ctrlCuloarePersonal.CuloareARGB; lUser.DataAngajare = this.ctrlDataAngajarePersonal.DataAfisata; lUser.ContStoma = this.txtContStomaPersonal.Text; lUser.ParolaStoma = this.txtParolaPersonal.Text; lUser.Observatii = this.txtObservatiiPersonal.Text; lUser.Rol = this.cboRolPersonal.SelectedIndex; lUser.TipContract = this.cboTipContract.SelectedIndex; lUser.DataContract = this.ctrlDataContract.DataAfisata; lUser.DataIncetareContract = this.ctrlDataIncetareContract.DataAfisata; lUser.OreNorma = CUtil.GetTextInt32(this.txtNrOreNorma.Text); lUser.NumarContract = this.txtNrContract.Text; if (esteValid) { this.lUser.UpdateAll(); } else { seteazaAlerta(); } } return(esteValid); }
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; } }