Ejemplo n.º 1
0
        public void SetareProprietatiTest()
        {
            var masina = new Masina(_masina, _magistrala);

            Assert.Equal(masina.CIV.ToString(), "5");
            Assert.Equal(StareMasina.InStoc, masina.stare);
        }
Ejemplo n.º 2
0
        public List <Masina> IncarcaListaMasini22222()
        {
            //  List<string> marca = new List<string>();
            List <Masina> masina     = new List <Masina>();
            List <string> idradacina = IncarcaIdRadacina();

            foreach (string id in idradacina)
            {
                using (var cn = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename" +
                                                  @"='C:\Users\Andrei\Documents\GitHub\pssc-proiect\IterfataUtilizator\App_Data\Users.mdf';Integrated Security=True"))
                {
                    string _sql = @"SELECT row_number() over (partition by IdRadacina order by IdRadacina) as number, DetaliiEveniment FROM [dbo].[ParcAuto] where IdRadacina=@idradacina order by number desc";
                    var    cmd  = new SqlCommand(_sql, cn);
                    cmd.Parameters
                    .Add(new SqlParameter("@idradacina", SqlDbType.VarChar))
                    .Value = id;
                    cn.Open();
                    using (SqlDataReader reader = cmd.ExecuteReader())
                    {
                        if (reader.Read())
                        {
                            string[] tokens = reader["DetaliiEveniment"].ToString().Split('"');
                            string   tip    = Regex.Match(tokens[8], @"\d+").Value;
                            Masina   m      = new Masina(new PlainText(tokens[5]), (TipMasina)Enum.Parse(typeof(TipMasina), tip), new PlainText(tokens[13]), new PlainText(tokens[67]), new PlainText(tokens[19]), new PlainText(tokens[61]), new PlainText(tokens[25]), new PlainText(tokens[37]), new PlainText(tokens[51]), new PlainText(tokens[49]), new PlainText(tokens[43]), new PlainText(tokens[31]));
                            string   stare  = Regex.Match(tokens[70], @"\d+").Value;
                            //object detalii = JsonConvert.DeserializeObject<MasinaDes.RootObject>(reader["DetaliiEveniment"].ToString());
                            // object detalii = JsonConvert.DeserializeObject<List<Eveniment>>(String.Format("{0}", reader["DetaliiEveniment"]));
                            m.stare = (StareMasina)Enum.Parse(typeof(StareMasina), stare);
                            masina.Add(m);
                        }
                    }
                }
            }
            return(masina);
        }
        public Masina GetMasina(string numeVanzator, string tip)
        {
            try
            {
                // instructiunea 'using' va apela sr.Close()
                using (StreamReader sr = new StreamReader(NumeFisier))
                {
                    string line;

                    //citeste cate o linie si creaza un obiect de tip Student pe baza datelor din linia citita
                    while ((line = sr.ReadLine()) != null)
                    {
                        Masina masina = new Masina(line);
                        if (masina.NumeVanzator.Equals(numeVanzator) && masina.Tip.Equals(tip))
                        {
                            return(masina);
                        }
                    }
                }
            }
            catch (IOException eIO)
            {
                throw new Exception("Eroare la deschiderea fisierului. Mesaj: " + eIO.Message);
            }
            catch (Exception eGen)
            {
                throw new Exception("Eroare generica. Mesaj: " + eGen.Message);
            }
            return(null);
        }
        public Masina GetMasina(string numeVanzator, string tip)
        {
            Masina s = null;

            try
            {
                BinaryFormatter b = new BinaryFormatter();
                //instructiunea 'using' va apela sBinFile.Close();
                using (Stream sBinFile = File.Open(NumeFisier, FileMode.Open))
                {
                    while (sBinFile.Position < sBinFile.Length)
                    {
                        s = (Masina)b.Deserialize(sBinFile);
                        if (s.NumeVanzator.Equals(numeVanzator) && s.Tip.Equals(tip))
                        {
                            break;
                        }
                    }
                }
            }
            catch (IOException eIO)
            {
                throw new Exception("Eroare la deschiderea fisierului. Mesaj: " + eIO.Message);
            }
            catch (Exception eGen)
            {
                throw new Exception("Eroare generica. Mesaj: " + eGen.Message);
            }
            return(s);
        }
        private void btnAdauga_Click(object sender, EventArgs e)
        {
            ResetCuloareEtichete();

            CodEroare codValidare = Validare(txtNumeVanzator.Text, txtNumeCumparator.Text, txtModel.Text, txtPret.Text, cmbMarca.Text, cmbAnFabricatie.Text);

            if (codValidare != CodEroare.CORECT)
            {
                MarcheazaControaleCuDateIncorecte(codValidare);
            }
            else
            {
                //Masina s = new Masina(txtNumeVanzator.Text, txtNumeCumparator.Text, txtModel.Text, Convert.ToDouble(txtPret.Text));
                Masina s = new Masina();
                s.Numevanzator   = txtNumeVanzator.Text;
                s.Numecumparator = txtNumeCumparator.Text;
                s.Model          = txtModel.Text;
                s.Pret           = Convert.ToDouble(txtPret.Text);
                s.Marca          = cmbMarca.Text;
                s.CuloareMasina  = GetCuloareSelectata();
                s.Dotari         = new List <string>();
                s.Dotari.AddRange(dotariSelectate);
                s.Anfabricatie    = Convert.ToInt32(cmbAnFabricatie.Text);
                s.DataActualizare = DateTime.Now;
                s.DataTranzactie  = dtpTranzactie.Value;
                adminMasina.AddMasina(s);
                MessageBox.Show("Tranzactia a fost adaugata");
                ResetareControale();
            }
        }
Ejemplo n.º 6
0
        public IActionResult EditMasina(Masina masina)
        {
            var masinaRepository = new MasinaRepository();

            masinaRepository.EditMasina(masina);
            return(RedirectToAction("ListareMasini"));
        }
Ejemplo n.º 7
0
        public static Masina GetCarByID(int id)
        {
            Masina newcar = new Masina();

            using (SqlConnection connection = new SqlConnection(SqlConnectionDB.ConnectionString))
            {
                string oString = @"Select Masina.numar,Masina.model 
                                  FROM Programmasini 
                                  INNER JOIN Masina ON Masina.id = Programmasini.masinaid 
                                  WHERE Programmasini.curierid = @cid";

                SqlCommand oCmd = new SqlCommand(oString, connection);
                oCmd.Parameters.AddWithValue("@cid", id);
                connection.Open();
                using (SqlDataReader oReader = oCmd.ExecuteReader())
                {
                    if (oReader != null)
                    {
                        while (oReader.Read())
                        {
                            newcar.Numar = oReader["numar"].ToString();
                            newcar.Model = oReader["model"].ToString();
                        }
                    }
                    connection.Close();
                }
            }

            return(newcar);
        }
Ejemplo n.º 8
0
 private void AzurirajListu(long odgovor)
 {
     if (this.id == 0)
     {
         Masine.Add(new Masina()
         {
             ID      = (int)odgovor,
             Naziv   = this.Naziv,
             Opis    = this.Opis,
             Slika   = this.Slika,
             Aktivan = this.Aktivan,
         });
     }
     else
     {
         Masina masina = this.Masine.First((p) => p.ID == this.id);
         if (masina != null)
         {
             masina.Naziv   = this.Naziv;
             masina.Opis    = this.Opis;
             masina.Slika   = this.Slika;
             masina.Aktivan = this.Aktivan;
         }
     }
 }
        public Masina[] GetMasini(Masina[] elev, out int nrStudenti, int nrstd)
        {
            try
            {
                // instructiunea 'using' va apela sr.Close()
                using (StreamReader sr = new StreamReader(NumeFisier))
                {
                    string line;
                    nrStudenti = nrstd;

                    //citeste cate o linie si creaza un obiect de tip Student pe baza datelor din linia citita
                    while ((line = sr.ReadLine()) != null)
                    {
                        elev[nrStudenti++] = new Masina(line);
                    }
                }
            }
            catch (IOException eIO)
            {
                throw new Exception("Eroare la deschiderea fisierului. Mesaj: " + eIO.Message);
            }
            catch (Exception eGen)
            {
                throw new Exception("Eroare generica. Mesaj: " + eGen.Message);
            }


            return(null);
        }
        public OptiuneDetaliiMasinaForm(Masina masina)
        {
            IStocareDataMasini adminMasini = StocareFactoryMasini.GetAdministratorStocare();
            List <Masina>      msn         = adminMasini.GetMasiniIndex(masina.IdMasina - 1);
            Masina             m           = msn.Last();

            InitializeComponent();

            lblFirma.Text               = "Firma: " + m.NumeFirma;
            lblModel.Text               = "Model: " + m.Model;
            lblPretCurent.Text          = "Pret: " + m.Pret + "$";
            pictureMasina.ImageLocation = m.ImageLocation;
            foreach (string proprietar in m.istoricProprietari)
            {
                lblProprietar.Text += "Nume Proprietar: " + proprietar + "\n";
                flowLayoutAfisare.Controls.Add(lblProprietar);
            }


            chartPreturi.Series = new SeriesCollection
            {
                new LineSeries
                {
                    Values = m.istoricPreturi
                }
            };


            radioGraficPret.Checked = true;
        }
Ejemplo n.º 11
0
        public void RezervaMasinaTest()
        {
            var masina = new Masina(_masina, _magistrala);

            masina.RezevaMasina(masina);
            Assert.Equal(masina.stare, StareMasina.Rezervata);
        }
        private int GetId()
        {
            int IDMASINA = ID_PRIMA_MASINA;

            try
            {
                //instructiunea 'using' va apela sBinFile.Close();
                using (Stream sBinFile = File.Open(NumeFisier, FileMode.Open))
                {
                    BinaryFormatter b = new BinaryFormatter();

                    //citeste cate o linie si creaza un obiect de tip Student pe baza datelor din linia citita
                    while (sBinFile.Position < sBinFile.Length)
                    {
                        //Observati conversia!!!
                        Masina s = (Masina)b.Deserialize(sBinFile);
                        IDMASINA = s.IdMasina + INCREMENT;
                    }
                }
            }
            catch (IOException eIO)
            {
                throw new Exception("Eroare la deschiderea fisierului. Mesaj: " + eIO.Message);
            }
            catch (Exception eGen)
            {
                throw new Exception("Eroare generica. Mesaj: " + eGen.Message);
            }
            return(IDMASINA);
        }
Ejemplo n.º 13
0
        public List <Eveniment> IncarcaListaDeEvenimente()
        {
            // List<string> marca = new List<string>();
            List <Eveniment> e      = new List <Eveniment>();
            List <Masina>    masina = new List <Masina>();

            using (var cn = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename" +
                                              @"='C:\Users\Andrei\Documents\GitHub\pssc-proiect\IterfataUtilizator\App_Data\Users.mdf';Integrated Security=True"))
            {
                string _sql = @"SELECT * FROM [dbo].[ParcAuto] ";
                var    cmd  = new SqlCommand(_sql, cn);
                cn.Open();
                using (SqlDataReader reader = cmd.ExecuteReader())
                {
                    while (reader.Read())
                    {
                        string[] tokens = reader["DetaliiEveniment"].ToString().Split('"');
                        //  marca.Add(tokens[13]);
                        string tip   = Regex.Match(tokens[8], @"\d+").Value;
                        Masina m     = new Masina(new PlainText(tokens[5]), (TipMasina)Enum.Parse(typeof(TipMasina), tip), new PlainText(tokens[13]), new PlainText(tokens[67]), new PlainText(tokens[19]), new PlainText(tokens[61]), new PlainText(tokens[25]), new PlainText(tokens[37]), new PlainText(tokens[51]), new PlainText(tokens[49]), new PlainText(tokens[43]), new PlainText(tokens[31]));
                        string stare = Regex.Match(tokens[70], @"\d+").Value;
                        //object detalii = JsonConvert.DeserializeObject<MasinaDes.RootObject>(reader["DetaliiEveniment"].ToString());
                        // object detalii = JsonConvert.DeserializeObject<List<Eveniment>>(String.Format("{0}", reader["DetaliiEveniment"]));
                        m.stare = (StareMasina)Enum.Parse(typeof(StareMasina), stare);
                        Eveniment ev = new Eveniment(new PlainText(reader["IdRadacina"].ToString()), (TipEveniment)Enum.Parse(typeof(TipEveniment), reader["TipEveniment"].ToString()), m);
                        e.Add(ev);
                    }
                }
            }
            return(e);
        }
Ejemplo n.º 14
0
        private void btnAdauga_Click(object sender, EventArgs e)
        {
            ResetCuloareEtichete();

            CodEroare codValidare = Validare(txtNumeVanzator.Text, txtNumeCumparator.Text, txtTip.Text, txtAnFabricare.Text, txtDataTranzactie.Text, txtPret.Text);

            if (codValidare != CodEroare.CORECT)
            {
                MarcheazaControaleCuDateIncorecte(codValidare);
            }
            else
            {
                Masina s = new Masina(txtNumeVanzator.Text, txtNumeCumparator.Text, txtTip.Text, txtAnFabricare.Text, txtDataTranzactie.Text, txtPret.Text);


                s.ProgramCulori = GetCuloareSelectata();

                s.ProgramOptiuni = new List <string>();
                s.ProgramOptiuni.AddRange(optiuniSelectate);
                s.PriceRange      = cmbGamaPreturi.Text;
                s.Uzura           = cmbUzura.Text;
                s.DataActualizare = DateTime.Now;
                s.DataAdaugare    = dtpMasina.Value;
                adminMasini.AddMasina(s);
                lblMesaj.Text = "Masina a fost adaugata";


                ResetareControale();
            }
        }
        private int GetId()
        {
            int IdMasina = ID_PRIMA_MASINA;

            try
            {
                // instructiunea 'using' va apela sr.Close()
                using (StreamReader sr = new StreamReader(NumeFisier))
                {
                    string line;

                    //citeste cate o linie si creaza un obiect de tip Student pe baza datelor din linia citita
                    while ((line = sr.ReadLine()) != null)
                    {
                        Masina s = new Masina(line);
                        IdMasina = s.IdMasina + INCREMENT;
                    }
                }
            }
            catch (IOException eIO)
            {
                throw new Exception("Eroare la deschiderea fisierului. Mesaj: " + eIO.Message);
            }
            catch (Exception eGen)
            {
                throw new Exception("Eroare generica. Mesaj: " + eGen.Message);
            }
            return(IdMasina);
        }
        public List <Masina> GetMasini()
        {
            List <Masina> masini = new List <Masina>();

            try
            {
                using (StreamReader sr = new StreamReader(NumeFisier))
                {
                    string line;
                    while ((line = sr.ReadLine()) != null)
                    {
                        Masina s = new Masina(line);
                        masini.Add(s);
                    }
                }
            }
            catch (IOException eIO)
            {
                throw new Exception("Eroare la deschiderea fisierului. Mesaj: " + eIO.Message);
            }
            catch (Exception eGen)
            {
                throw new Exception("Eroare generica. Mesaj: " + eGen.Message);
            }
            return(masini);
        }
Ejemplo n.º 17
0
        private void btnCauta_Click(object sender, EventArgs e)
        {
            Masina s = adminMasina.GetMasina(txtNumeVanzator.Text, txtNumeCumparator.Text, cmbMarca.Text);

            ResetCuloareEtichete();
            CodEroare codValidare = Validare_Cauta(txtNumeVanzator.Text, txtNumeCumparator.Text, cmbMarca.Text);

            if (codValidare == CodEroare.CORECT)
            {
                if (s != null)
                {
                    if (txtNumeVanzator.Text == s.Numevanzator && txtNumeCumparator.Text == s.Numecumparator && cmbMarca.Text == s.Marca)
                    {
                        MessageBox.Show("Tranzactia a fost gasita");
                        var bindingThing = new BindingSource();
                        bindingThing.Add(s);
                        dataGridCauta.DataSource = bindingThing;
                    }
                    else
                    {
                        MessageBox.Show("Tranzactia nu exista");
                    }
                }
                else
                {
                    MessageBox.Show("Tranzactia nu exista");
                }
            }
            else
            {
                MarcheazaControaleCuDateIncorecte_Cauta(codValidare);
                MessageBox.Show("Datele nu sunt corecte");
            }
        }
 public Masina GetMasinaByIndex(int index)
 {
     try
     {
         // instructiunea 'using' va apela sr.Close()
         using (StreamReader sr = new StreamReader(NumeFisier))
         {
             string line;
             int    contor = 0;
             //citeste cate o linie si creaza un obiect de tip Student pe baza datelor din linia citita
             while ((line = sr.ReadLine()) != null)
             {
                 Masina masina = new Masina(line);
                 if (contor == index)
                 {
                     return(masina);
                 }
                 contor++;
             }
         }
     }
     catch (IOException eIO)
     {
         throw new Exception("Eroare la deschiderea fisierului. Mesaj: " + eIO.Message);
     }
     catch (Exception eGen)
     {
         throw new Exception("Eroare generica. Mesaj: " + eGen.Message);
     }
     return(null);
 }
Ejemplo n.º 19
0
        public ArrayList GetMasina()
        {
            ArrayList masini = new ArrayList();

            try
            {
                // instructiunea 'using' va apela sr.Close()
                using (StreamReader sr = new StreamReader(NumeFisier))
                {
                    string line;

                    //citeste cate o linie si creaza un obiect de tip Student pe baza datelor din linia citita
                    while ((line = sr.ReadLine()) != null)
                    {
                        Masina s = new Masina(line);
                        masini.Add(s);
                    }
                }
            }
            catch (IOException eIO)
            {
                throw new Exception("Eroare la deschiderea fisierului. Mesaj: " + eIO.Message);
            }
            catch (Exception eGen)
            {
                throw new Exception("Eroare generica. Mesaj: " + eGen.Message);
            }

            return(masini);
        }
        private void btnModifica_Click(object sender, EventArgs e)
        {
            ResetCuloareEtichete();

            CodEroare codValidare = Validare(txtNumeVanzator.Text, txtNumeCumparator.Text, txtModel.Text, txtPret.Text);

            if (codValidare != CodEroare.CORECT)
            {
                MarcheazaControaleCuDateIncorecte(codValidare);
            }
            else
            {
                Masina s = new Masina(txtNumeVanzator.Text, txtNumeCumparator.Text, txtModel.Text, Convert.ToDouble(txtPret.Text));
                s.Marca         = cmbMarca.Text;
                s.CuloareMasina = GetCuloareSelectata();
                s.Dotari        = new List <string>();
                s.Dotari.AddRange(dotariSelectate);
                s.Anfabricatie = Int32.Parse(cmbAnFabricatie.Text);

                adminMasina.UpdateMasina(s);
                lblMesaj.Text = "Studentul a fost actualizat";

                //resetarea controalelor pentru a introduce datele unui student nou
                ResetareControale();
            }
        }
Ejemplo n.º 21
0
        static void Main(string[] args)
        {
            MagistralaCommands.Instance.Value.InregistreazaProcesatoareStandard();
            MagistralaEvenimente.Instanta.Value.InregistreazaProcesatoareStandard();
            MagistralaEvenimente.Instanta.Value.InchideInregistrarea();
            List <Eveniment> eve = new List <Eveniment>();

            var writeRepo = new WriteRepository();
            var readRepo  = new ReadRepository();

            var masina  = new Masina(new PlainText("WV Passat"), 2005, new CIV("EI309MNN"), new SerieSasiu("ALABALAPR"));
            var mecanic = new Mecanic(new PlainText("Nelutu"), 1);
            var client  = new Client(new PlainText("Orlando"), 1);

            var comanda = new Comanda(mecanic, client, new IDComanada(5), masina, "reparatie turbina");

            var commandPlasareComanda = new CommandPlasareComanda();

            commandPlasareComanda.Comanda = comanda;
            MagistralaCommands.Instance.Value.Trimite(commandPlasareComanda);
            //AtlierAuto.Evenimente.ProcesatorPlasareComanda procesatorPlasareComanda = new ProcesatorPlasareComanda()

            //AtelierAuto.Evenimente.ProcesatorPlasareComanda procesatorPlasareComanda = new AtelierAuto.Evenimente.ProcesatorPlasareComanda();

            // SalvareEvenimente(comanda);
            //readRepo.CautaComanda(new Guid());
            //readRepo.IncarcaDinListaDeEvenimente();

            Console.ReadLine();
            Console.ReadKey();
        }
Ejemplo n.º 22
0
 public Masina[] GetMasina(out int nrMasini)
 {
     Masina[] masini = new Masina[PAS_ALOCARE];
     nrMasini = 0;
     try
     {
         // instructiunea 'using' va apela sr.Close()
         using (StreamReader sr = new StreamReader(NumeFisier))
         {
             string line;
             int    numarLinie = 0;
             //citeste cate o linie si creaza un obiect de tip Student pe baza datelor din linia citita
             while ((line = sr.ReadLine()) != null)
             {
                 masini[numarLinie++] = new Masina(line, 1);
                 if (numarLinie == PAS_ALOCARE)
                 {
                     Array.Resize(ref masini, numarLinie + PAS_ALOCARE);
                 }
             }
             nrMasini = numarLinie;
         }
     }
     catch (IOException eIO)
     {
         throw new Exception("Eroare la deschiderea fisierului. Mesaj: " +
                             eIO.Message);
     }
     catch (Exception eGen)
     {
         throw new Exception("Eroare generica. Mesaj: " + eGen.Message);
     }
     return(masini);
 }
Ejemplo n.º 23
0
        public void UpdateMasina(Masina m)
        {
            List <Masina> masini = GetMasini();

            try
            {
                using (StreamWriter swFisierText = new StreamWriter(NumeFisier, false))
                {
                    foreach (Masina msn in masini)
                    {
                        if (msn.IdMasina == m.IdMasina)
                        {
                            swFisierText.WriteLine(m.ConversieLaSir_PentruFisiere());
                        }
                        else
                        {
                            swFisierText.WriteLine(msn.ConversieLaSir_PentruFisiere());
                        }
                    }
                }
            }
            catch (IOException eIO)
            {
                throw new Exception("Eroare la deschiderea fisierului. Mesaj: " + eIO.Message);
            }
            catch (Exception eGen)
            {
                throw new Exception("Eroare generica. Mesaj: " + eGen.Message);
            }
        }
Ejemplo n.º 24
0
        private void btnAdauga_Click(object sender, EventArgs e)
        {
            ResetCuloareEtichete();

            CodEroare codValidare = Validare(txtNumeVanzator.Text, txtNumeCumparator.Text, txtTip.Text, txtAnFabricare.Text, txtDataTranzactie.Text, txtPret.Text);

            if (codValidare != CodEroare.CORECT)
            {
                MarcheazaControaleCuDateIncorecte(codValidare);
            }
            else
            {
                Masina s = new Masina(txtNumeVanzator.Text, txtNumeCumparator.Text, txtTip.Text, txtAnFabricare.Text, txtDataTranzactie.Text, txtPret.Text);


                s.ProgramCulori = GetCuloareSelectata();
                //set Discipline
                s.ProgramOptiuni = new List <string>();
                s.ProgramOptiuni.AddRange(optiuniSelectate);
                s.PriceRange = cmbGamaPreturi.Text;
                s.Uzura      = cmbUzura.Text;
                adminMasini.AddMasina(s);
                lblMesaj.Text = "Masina a fost adaugata";

                //resetarea controalelor pentru a introduce datele unui student nou
                ResetareControale();
            }
        }
Ejemplo n.º 25
0
        private int GetId()
        {
            int IdMasina = ID_PRIMA_MASINA;

            try
            {
                using (StreamReader sr = new StreamReader(NumeFisier))
                {
                    string line;

                    while ((line = sr.ReadLine()) != null)
                    {
                        Masina m = new Masina(line);
                        IdMasina = m.IdMasina + INCREMENT;
                    }
                }
            }
            catch (IOException eIO)
            {
                throw new Exception("Eroare la deschiderea fisierului. Mesaj: " + eIO.Message);
            }
            catch (Exception eGen)
            {
                throw new Exception("Eroare generica. Mesaj: " + eGen.Message);
            }
            return(IdMasina);
        }
Ejemplo n.º 26
0
        public Masina CautaMasina(string idRadacina)
        {
            Masina m = new Masina();

            using (var cn = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename" +
                                              @"='C:\Users\Andrei\Documents\GitHub\pssc-proiect\IterfataUtilizator\App_Data\Users.mdf';Integrated Security=True"))
            {
                string _sql = @"SELECT * FROM [dbo].[ParcAuto] WHERE [IdRadacina]=@idRadacina";


                var cmd = new SqlCommand(_sql, cn);
                cmd.Parameters
                .Add(new SqlParameter("@idRadacina", SqlDbType.NVarChar))
                .Value = idRadacina;

                cn.Open();
                using (SqlDataReader reader = cmd.ExecuteReader())
                {
                    while (reader.Read())
                    {
                        string[] tokens = reader["DetaliiEveniment"].ToString().Split('"');
                        //     marca.Add(tokens[13]);
                        string tip = Regex.Match(tokens[8], @"\d+").Value;
                        m = new Masina(new PlainText(tokens[5]), (TipMasina)Enum.Parse(typeof(TipMasina), tip), new PlainText(tokens[13]), new PlainText(tokens[67]), new PlainText(tokens[19]), new PlainText(tokens[61]), new PlainText(tokens[25]), new PlainText(tokens[37]), new PlainText(tokens[51]), new PlainText(tokens[45]), new PlainText(tokens[43]), new PlainText(tokens[31]));
                        string stare = Regex.Match(tokens[70], @"\d+").Value;
                        //object detalii = JsonConvert.DeserializeObject<MasinaDes.RootObject>(reader["DetaliiEveniment"].ToString());
                        // object detalii = JsonConvert.DeserializeObject<List<Eveniment>>(String.Format("{0}", reader["DetaliiEveniment"]));
                        m.stare = (StareMasina)Enum.Parse(typeof(StareMasina), stare);
                    }
                }
            }
            return(m);
        }
Ejemplo n.º 27
0
        public void SetareProprietatiException()
        {
            _masina = new Masina(null, TipMasina.Berlina, new PlainText("Opel"), new PlainText("Vectra"), new PlainText("2031"), new PlainText("2300"), new PlainText("200k+"), new PlainText("1.9tdi"),
                                 new PlainText("1986"), new PlainText("300cp"), new PlainText("rosu"), new PlainText("nu bate nu trocane"));


            Assert.Throws <NullReferenceException>(() => new Masina(_masina, _magistrala));
        }
Ejemplo n.º 28
0
        public void PublicaEvenimentTest()
        {
            // var meciDto = new MeciDto() { Id = meciId };
            var masina = new Masina(_masina, _magistrala);

            _mockProcesatorAdaugaMasina.Verify(_ =>
                                               _.Proceseaza(It.Is <Eveniment>(e => e.IdRadacina == masina.CIV)), Times.Once);
        }
Ejemplo n.º 29
0
        // Functie care efectueaza operatia de UPDATE pe o masina din baza de date dupa ID

        public void EditMasina(Masina masina)
        {
            var query = $"UPDATE Masini SET Pret = {masina.Pret}, Motorizare='{masina.Motorizare}', Combustibil='{masina.Combustibil}', " +
                        $"Culoare='{masina.Culoare}', AnFabricatie='{masina.AnFabricatie}', KM={masina.KM}, Descriere='{masina.Descriere}'" +
                        $" WHERE MasinaID={masina.MasinaID}";

            this.ExecuteQuery(query);
        }
Ejemplo n.º 30
0
        public void AdaugaMasina(Masina masina)
        {
            ListaDeMasini.Add(masina);
            var e = new EvenimentGeneric <Masina>(masina.Id, TipEveniment.AdaugareMasina, masina);

            //  Aplica(e);
            PublicaEveniment(e);
        }