public void Initializeaza()
{
base.InitializeazaVariabileleGenerale();
incepeIncarcarea();
this.lblGumaFindTehnician.FolosesteToString = true;
if (this.lEtapa.IdTehnician > 0)
{
this.lblGumaFindTehnician.ObiectCorespunzator = BUtilizator.GetById(this.lEtapa.IdTehnician, null);
}
else
{
this.lblGumaFindTehnician.Goleste();
}
this.ctrlDataOraInceput.Initializeaza(this.lEtapa.DataInceput, CCL.UI.ComboBoxOra.EnumPas.JumatateDeOra);
this.ctrlDataOraFinal.Initializeaza(this.lEtapa.DataFinal, CCL.UI.ComboBoxOra.EnumPas.JumatateDeOra);
this.cboStatus.DataSource = BClientiComenziEtape.StructStareEtapa.GetList();
this.cboStatus.SelectedIndex = Convert.ToInt32(this.lEtapa.Status);
this.cboStatus.DropDownStyle = ComboBoxStyle.DropDownList;
this.chkRefacere.Checked = this.lEtapa.Refacere;
this.txtObservatii.Text = this.lEtapa.Observatii;
finalizeazaIncarcarea();
}
private void incarcaRand(DataGridViewRow pRand, BClientiComenziEtape pElem)
{
pRand.Tag = pElem;
DataGridViewPersonalizat.InitCelulaEditare(pRand, this.lEcranInModificare);
if (pElem.IdEtapa != 0)
{
pRand.Cells[EnumColoaneDGV.colEtapa.ToString()].Value = BEtape.GetEtapaById(pElem.IdEtapa, CDefinitiiComune.EnumStare.Activa, null).Denumire;
}
pRand.Cells[EnumColoaneDGV.colDataInceput.ToString()].Value = pElem.DataInceput;
if (pElem.Refacere)
{
DataGridViewPersonalizat.SeteazaAlerta(pRand, EnumColoaneDGV.colEtapa.ToString());
pRand.Cells[EnumColoaneDGV.colEtapa.ToString()].ToolTipText = BMultiLingv.getElementById(BMultiLingv.EnumDictionar.Refacere);
}
else
{
DataGridViewPersonalizat.IndeparteazaAlerta(pRand, EnumColoaneDGV.colEtapa.ToString());
}
pRand.Cells[EnumColoaneDGV.colDataFinal.ToString()].Value = pElem.DataFinal;
if (pElem.IdTehnician != 0)
{
pRand.Cells[EnumColoaneDGV.colTehnician.ToString()].Value = BUtilizator.GetById(pElem.IdTehnician, null).GetNumeCompletUtilizator();
}
pRand.Cells[EnumColoaneDGV.colObservatii.ToString()].Value = pElem.Observatii;
pRand.Cells[EnumColoaneDGV.colStatus.ToString()].Value = BClientiComenziEtape.StructStareEtapa.GetStructById(pElem.Status).Denumire;
DataGridViewPersonalizat.InitCelulaStergere(pRand);
}
private void incarcaRand(DataGridViewRow pRand, BClientiComenziEtape pElem)
{
pRand.Tag = pElem;
pRand.Cells[EnumColoaneDGV.colDenumireEtapa.ToString()].Value = BEtape.GetEtapaById(pElem.IdEtapa, CDefinitiiComune.EnumStare.Activa, null).Denumire;
pRand.Cells[EnumColoaneDGV.colDenumireEtapa.ToString()].Tag = pElem;
if (pElem.DataInceput != CConstante.DataNula)
{
pRand.Cells[EnumColoaneDGV.colDataInceput.ToString()].Value = pElem.DataInceput;
pRand.Cells[EnumColoaneDGV.colDataInceput.ToString()].Tag = pElem.DataInceput;
}
if (pElem.DataFinal != CConstante.DataNula)
{
pRand.Cells[EnumColoaneDGV.colDataSfarsit.ToString()].Value = pElem.DataFinal;
pRand.Cells[EnumColoaneDGV.colDataSfarsit.ToString()].Tag = pElem.DataFinal;
}
if (pElem.IdTehnician != 0)
{
pRand.Cells[EnumColoaneDGV.colTehnician.ToString()].Value = BUtilizator.GetById(pElem.IdTehnician, null).GetNumeCompletUtilizator();
pRand.Cells[EnumColoaneDGV.colTehnician.ToString()].Tag = BUtilizator.GetById(pElem.IdTehnician, null).Id;
}
DataGridViewPersonalizat.InitCelulaStergere(pRand);
}
public void SelectieInteligenta(int pIdTehnician)
{
if (this.GetIdTehnician() == pIdTehnician)
{
this.Goleste();
}
else
{
this.lgfTehnician.ObiectAfisajCorespunzator = BUtilizator.GetById(pIdTehnician, null);
}
cereUpdate();
}
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);
}
public void Initializeaza(BClientiComenzi pComanda, BClienti pClient, BListaPreturiStandard pLucrare)
{
base.InitializeazaVariabileleGenerale();
incepeIncarcarea();
this.cboComandaReprezentant.Focus();
this.txtComandaPacientNume.CapitalizeazaPrimaLitera = true;
this.txtComandaPacientPrenume.CapitalizeazaPrimaLitera = true;
this.btnVeziToateEtapele.Visible = this.lComanda != null;
this.lgfTehnician.FolosesteToString = true;
this.lgfLucrare.FolosesteToString = true;
this.lgfClinica.AfiseazaButonGuma = false;
this.lgfClinica.AfiseazaButonCautare = false;
this.lgfLucrare.AfiseazaButonGuma = false;
this.lgfTehnician.AfiseazaButonGuma = false;
if (this.lComanda == null)
{
this.lgfClinica.Goleste();
this.lgfLucrare.Text = this.lLucrareSelectata.Denumire;
this.lgfTehnician.Goleste();
this.txtNrElemente.Text = BMultiLingv.getElementById(BMultiLingv.EnumDictionar.Unu);
this.lgfClinica.Text = this.lClient.Denumire;
this.ctrlComandaDataPrimire.DataAfisata = DateTime.Now;
if (this.lLucrareSelectata.TermenMediuZile != 0)
{
this.ctrlComandaDataLaGata.Initializeaza(this.ctrlComandaDataPrimire.DataAfisata.AddDays(this.lLucrareSelectata.TermenMediuZile), ComboBoxOra.EnumPas.JumatateDeOra);
}
else
{
this.ctrlComandaDataLaGata.Initializeaza(CConstante.DataNula, ComboBoxOra.EnumPas.JumatateDeOra);
}
this.ctrlDataOraTermen.Initializeaza(CConstante.DataNula, ComboBoxOra.EnumPas.JumatateDeOra);
this.txtComandaPacientNume.Goleste();
this.txtComandaPacientPrenume.Goleste();
this.txtVarsta.Goleste();
this.txtObservatiiComanda.Goleste();
this.txtCodComanda.Goleste();
////lore 03.09.2019
if (this.lLucrareSelectata.ValoareEUR != 0)
{
if (this.lpretnegociat == null)
{
this.lblPretUnitarInitial.Text = this.lLucrareSelectata.ValoareEUR.ToString();
this.txtpretunitarfin.ValoareDouble = this.lLucrareSelectata.ValoareEUR;
}
else
{
this.lblPretUnitarInitial.Text = this.lpretnegociat.ValoareEUR.ToString();
this.txtpretunitarfin.ValoareDouble = this.lpretnegociat.ValoareEUR;
}
this.lblmoneda.Text = "EUR";
this.lblValoareFinala.Text = string.Concat("TOTAL:", " ", this.txtpretunitarfin.ValoareDouble * this.txtNrElemente.ValoareDouble, " ", this.lblmoneda.Text);
}
else
{
if (this.lpretnegociat == null)
{
this.lblPretUnitarInitial.Text = this.lLucrareSelectata.ValoareRON.ToString();
this.txtpretunitarfin.ValoareDouble = this.lLucrareSelectata.ValoareRON;
}
else
{
this.lblPretUnitarInitial.Text = (this.lpretnegociat.ValoareRON).ToString();
this.txtpretunitarfin.ValoareDouble = this.lpretnegociat.ValoareRON;
}
this.lblmoneda.Text = "RON";
this.lblValoareFinala.Text = string.Concat("TOTAL:", " ", this.txtpretunitarfin.ValoareDouble * this.txtNrElemente.ValoareDouble, " ", this.lblmoneda.Text);
}
}
else
{
this.lLucrareSelectata = BListaPreturiStandard.getById(this.lComanda.IdLucrare, null);
if (this.lComanda.IdTehnician > 0)
{
this.lgfTehnician.ObiectCorespunzator = BUtilizator.GetById(this.lComanda.IdTehnician, null);
}
else
{
this.lgfTehnician.Goleste();
}
this.lgfClinica.Text = this.lClient.Denumire;
this.lgfLucrare.Text = this.lLucrareSelectata.Denumire;
this.cboComandaReprezentant.SelectedValue = lComanda.IdReprezentantClient;
this.cboCabinet.SelectedValue = lComanda.IdCabinet;
this.txtComandaPacientNume.Text = lComanda.NumePacient;
this.txtComandaPacientPrenume.Text = lComanda.PrenumePacient;
this.txtVarsta.ValoareIntreaga = lComanda.Varsta;
this.rbFeminin.Checked = this.lComanda.SexPacient == 1;
this.rbMasculin.Checked = this.lComanda.SexPacient == 2;
this.ctrlComandaDataPrimire.DataAfisata = lComanda.DataPrimire;
this.ctrlComandaDataLaGata.Initializeaza(lComanda.DataLaGata, ComboBoxOra.EnumPas.JumatateDeOra);
this.txtObservatiiComanda.Text = lComanda.Observatii;
this.txtObservatiiEtapaCurenta.Text = lComanda.ObservatiiEtapa;
this.chkUrgent.Checked = lComanda.Urgent;
this.txtNrElemente.Text = lComanda.NrElemente.ToString();
this.ctrlDataOraTermen.Initializeaza(this.lComanda.DataSfarsitEtapa, ComboBoxOra.EnumPas.JumatateDeOra);
this.chkRefacere.Checked = this.lComanda.Refacere;
this.txtCuloare.Text = this.lComanda.Culoare;
this.chkAcceptata.Checked = this.lComanda.Acceptata;
this.txtCodComanda.Text = this.lComanda.CodLucrare;
////lore 05.09.2019
this.lblPretUnitarInitial.Text = pComanda.PretUnitarInitial.ToString();
this.txtpretunitarfin.ValoareDouble = pComanda.PretUnitarFinal;
////lore 03.09.2019
if (this.lLucrareSelectata.ValoareEUR != 0)
{
this.lblmoneda.Text = "EUR";
this.lblValoareFinala.Text = string.Concat("TOTAL:", " ", this.txtpretunitarfin.ValoareDouble * this.txtNrElemente.ValoareDouble, " ", this.lblmoneda.Text);
}
else
{
this.lblmoneda.Text = "RON";
this.lblValoareFinala.Text = string.Concat("TOTAL:", " ", this.txtpretunitarfin.ValoareDouble * this.txtNrElemente.ValoareDouble, " ", this.lblmoneda.Text);
}
}
initListe();
if (this.lComanda != null && !this.lComanda.EsteActiv)
{
AllowModification(false);
}
else
{
AllowModification(true);
}
finalizeazaIncarcarea();
}
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;
}
}