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;
}
}
