public void SetareProprietatiTest() { var masina = new Masina(_masina, _magistrala); Assert.Equal(masina.CIV.ToString(), "5"); Assert.Equal(StareMasina.InStoc, masina.stare); }
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(); } }
public IActionResult EditMasina(Masina masina) { var masinaRepository = new MasinaRepository(); masinaRepository.EditMasina(masina); return(RedirectToAction("ListareMasini")); }
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); }
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; }
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); }
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); }
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); }
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); }
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(); } }
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(); }
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); }
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); } }
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(); } }
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); }
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); }
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)); }
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); }
// 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); }
public void AdaugaMasina(Masina masina) { ListaDeMasini.Add(masina); var e = new EvenimentGeneric <Masina>(masina.Id, TipEveniment.AdaugareMasina, masina); // Aplica(e); PublicaEveniment(e); }