public FormMain() { this.Text = Properties.Resources.PROGRAM_NAME; string foo = Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.UserProfile), "Car-shop"); if (!Directory.Exists(foo)) { Directory.CreateDirectory(foo); File.Create(Path.Combine(foo, Properties.Resources.ACCESS_DB_NAME)); } else { foo = Path.Combine(foo, Properties.Resources.ACCESS_DB_NAME); if (!File.Exists(foo)) { Catalog c = new Catalog(); c.Create($"Provider=Microsoft.Ace.Oledb.12.0;Data Source={foo};"); c = null; } } connString = $"Provider=Microsoft.Ace.Oledb.12.0;Data Source={foo};"; vc = new VeicoliCommands(); listaVeicoliEliminati = new SerializableBindingList <Veicolo>(); listaVeicoliAggiunti = new SerializableBindingList <Veicolo>(); listaVeicoli = new SerializableBindingList <Veicolo>(); this.InitializeComponent(); } //COSTRUTTORE FORM: INIZIALIZZA TUTTE LE STRUTTURE DATI NECESSARIE
/// <summary> /// Take the item from the database in a list /// </summary> /// <param name="list"> Empty vehicles list </param> /// <param name="con"> Connection to database </param> private void InsertItemInList(SerializableBindingList <Vehicles> list, OleDbConnection con, string tableName) { OleDbCommand command = new OleDbCommand($"SELECT * FROM {tableName}", con); OleDbDataReader rdr = command.ExecuteReader(); if (rdr.HasRows) { while (rdr.Read()) { bool used = rdr.GetString(7) == "Si" ? true : false; bool km0 = rdr.GetString(8) == "Si" ? true : false; if (tableName == "Auto") { list.Add(new Cars(rdr.GetString(1), rdr.GetString(2), rdr.GetString(3), rdr.GetInt32(4), rdr.GetInt32(5), rdr.GetDateTime(6), used, km0, rdr.GetInt32(9), Convert.ToDouble(rdr.GetDecimal(10)), rdr.GetString(12), rdr.GetInt32(11))); } else { list.Add(new Motorbikes(rdr.GetString(1), rdr.GetString(2), rdr.GetString(3), rdr.GetInt32(4), rdr.GetInt32(5), rdr.GetDateTime(6), used, km0, rdr.GetInt32(9), Convert.ToDouble(rdr.GetDecimal(10)), rdr.GetString(12), rdr.GetString(11))); } } } else { MessageBox.Show("Non è stato trovato alcun dato", "ATTENZIONE", MessageBoxButtons.OK, MessageBoxIcon.Warning); } rdr.Close(); }
} //COSTRUTTORE FORM: INIZIALIZZA TUTTE LE STRUTTURE DATI NECESSARIE public void FormMain_Load(object sender, EventArgs e) { //RESET SCHERMATA this.pnlMain.Controls.Clear(); this.tMain.Select(); string logoPath = File.ReadAllText(Path.Combine(Properties.Resources.FILES_PATH, "LogoPath.txt")); if (logoPath != "") { this.logoToolStripLabel.BackgroundImage = Image.FromFile(logoPath); } this.logoToolStripLabel.BackgroundImageLayout = ImageLayout.Zoom; listaVeicoliEliminati.Clear(); listaVeicoliAggiunti.Clear(); listaVeicoli.Clear(); try { listaVeicoli = vc.GetVeicoliList(vc.GetRows(connString)); } catch (OleDbException) { MessageBox.Show("Il database deve essere ancora creato, chiedi all'amministratore di inizializzare il db!", Properties.Resources.PROGRAM_NAME, MessageBoxButtons.OK, MessageBoxIcon.Error); this.Close(); } foreach (var item in listaVeicoli) {//CREO LE CARTE GRAFICHE var c = new Card(item); this.pnlMain.Controls.Add(c); c.CardDeleted += Handler_CardDeleted; c.CardShowed += Handler_CardShowed; c.ImmagineCambiata += Handler_ImageUpdate; } }//FORM LOAD
private SerializableBindingList <Veicolo> openDb(string constr, string sql) { var l = new SerializableBindingList <Veicolo>(); DataTable t = new DataTable(); using (OleDbConnection connection = new OleDbConnection(constr)) //data reader: oggetto per recuperare dati { connection.Open(); OleDbCommand command = new OleDbCommand(sql, connection); OleDbDataAdapter da = new OleDbDataAdapter(command); da.Fill(t); foreach (DataRow r in t.Rows) { if (r["Carburante"].ToString() == "|") { Moto m = new Moto(r["Targa"].ToString(), r["Marca"].ToString(), r["Modello"].ToString(), r["Versione"].ToString(), Convert.ToInt32(r["Cilindrata"]), r["TipoVeicolo"].ToString(), r["Tipologia"].ToString(), Convert.ToInt32(r["Km"]), Convert.ToDateTime(r["Immatricolazione"]), Convert.ToDouble(r["Prezzo"])); l.Add(m); } else { Auto a = new Auto(r["Targa"].ToString(), r["Marca"].ToString(), r["Modello"].ToString(), r["Versione"].ToString(), Convert.ToInt32(r["Cilindrata"]), r["TipoVeicolo"].ToString(), r["Tipologia"].ToString(), Convert.ToInt32(r["Km"]), Convert.ToDateTime(r["Immatricolazione"]), r["Carburante"].ToString(), Convert.ToDouble(r["Prezzo"])); l.Add(a); } } } return(l); }
public FormMain() { InitializeComponent(); ListaVeicoli = new SerializableBindingList <Veicolo>(); ListBoxV.DataSource = ListaVeicoli; Start(); }
//Serve per prendere i dati dal database, e caricarli su SerializeBindingList. Lo uso all'inizio di form_load, quando su dgv bisogna caricare i // dati presi dal database. public static SerializableBindingList <Veicolo> OpenDataBaseToList(SerializableBindingList <Veicolo> listaVeicoli) { if (connstr != null) { OleDbConnection connection = new OleDbConnection(connstr); using (connection) { connection.Open(); OleDbCommand cmd = new OleDbCommand(); try { OleDbDataReader rd = cmd.ExecuteReader(); while (rd.Read()) //finchè ci sono le righe { if (rd.GetString(1) == "AUTO") { listaVeicoli.Add(new Auto(rd.GetString(1), rd.GetString(2), rd.GetString(3), rd.GetInt32(4), rd.GetDouble(5), rd.GetDateTime(6), rd.GetBoolean(7), rd.GetBoolean(8), rd.GetInt32(9), rd.GetInt32(10), rd.GetInt32(11))); } else if (rd.GetString(1) == "MOTO") { listaVeicoli.Add(new Moto(rd.GetString(1), rd.GetString(2), rd.GetString(3), rd.GetInt32(4), rd.GetDouble(5), rd.GetDateTime(6), rd.GetBoolean(7), rd.GetBoolean(8), rd.GetInt32(9), rd.GetString(10), rd.GetInt32(11))); } } rd.Close(); } catch (OleDbException exc) { }; } } return(listaVeicoli); }
public frmDettagli(int id, int[] iDs, SerializableBindingList <veicolo> lstVeicoli) { InitializeComponent(); this.id = id; this.l = lstVeicoli; this.iDs = iDs; }
private void CreateBody(ref string mainContent, SerializableBindingList <Veicolo> list, int i) { string usato = string.Empty; string km0 = string.Empty; if (list[i].Km0) { km0 = "Chilometro zero,"; } if (list[i].Usato) { usato = "Usato"; } else { usato = "Nuovo"; } mainContent += "<div class = \"veicolo\">"; mainContent += $"<img src = \"../img/{list[i].Img}\">"; mainContent += $"<div class = \"titolo\">{list[i].Marca} {list[i].Modello}"; mainContent += $"<div class = \"didascalia\"> Colore: {list[i].Colore}<br> Cilindrata: {list[i].Cilindrata}<br> Immatricolazione: {list[i].Matricolazione.ToString("dd/MM/yyyy")}<br> {km0} {usato} <br> Chilometri percorsi: {list[i].KmFatti}<br> Potenza: {list[i].Potenza} <br> Prezzo: {list[i].Prezzo} € </div>"; mainContent += "</div>"; mainContent += "</div>"; }
public static void SerializeToXml <T>(SerializableBindingList <T> objectlist, string pathName) { XmlSerializer x = new XmlSerializer(typeof(SerializableBindingList <T>)); TextWriter w = new StreamWriter(pathName); x.Serialize(w, objectlist); }
public static void WordDocumentCreation(SerializableBindingList <veicolo> objList) { string filepath = "veicoli.docx"; using (WordprocessingDocument doc = WordprocessingDocument.Create(filepath, DocumentFormat.OpenXml.WordprocessingDocumentType.Document)) { // Add a main document part. MainDocumentPart mainPart = doc.AddMainDocumentPart(); // Create the document structure and add some text. mainPart.Document = new Document(); Body body = mainPart.Document.AppendChild(new Body()); // Add heading Paragraph headingPar = createHeading("VEICOLI DISPONIBILI"); body.AppendChild(headingPar); foreach (var item in objList) { string type = null; if (item is auto) { type = "AUTO"; } else { type = "MOTO"; } Paragraph newPar = createParagaph(type, item.Marca, item.Modello, item.Cilindrata.ToString(), item.PotenzaKw.ToString(), item.Prezzo); body.AppendChild(newPar); } } }
private static void createBody(ref string aus, SerializableBindingList <Veicolo> lista, int i) { string veicoloImg = string.Empty; string tipo = string.Empty; string num = ""; if (lista[i] is Auto) { veicoloImg = selectImage("auto"); tipo = "Numero airbag"; num = (lista[i] as Auto).NumAirbag.ToString(); } else { veicoloImg = selectImage("moto"); tipo = "Marca sella"; num = (lista[i] as Moto).MarcaSella; } aus += "<div class = \"veicolo\">"; aus += $"<img src = \"img/{veicoloImg}\">"; aus += $"<div class = \"titolo\">{lista[i].Marca} {lista[i].Modello}"; aus += $"<div class = \"didascalia\"> Cilindrata: {lista[i].Cilindrata}<br> Potenza(KW): {lista[i].PotenzaKw}<br> {tipo}: {num} </div>"; aus += "</div>"; aus += "</div>"; }
/// <summary> /// Create body for the html file /// </summary> /// <param name="mainContent"> Content to add </param> /// <param name="list"> List with datas </param> /// <param name="i"> List data position </param> private void CreateBody(ref string mainContent, SerializableBindingList <Vehicles> list, int i) { string used = string.Empty; string km0 = string.Empty; if (list[i].IsKm0) { km0 = "Chilometro zero,"; } if (list[i].IsUsed) { used = "Usato"; } else { used = "Nuovo"; } mainContent += "<div class = \"veicolo\">"; mainContent += $"<img src = \"../img/{list[i].Img}\">"; mainContent += $"<div class = \"titolo\">{list[i].Brand} {list[i].Model}"; mainContent += $"<div class = \"didascalia\"> Colore: {list[i].Color}<br> Cilindrata: {list[i].Displacement}<br> Immatricolazione: {list[i].Matriculation.ToString("dd/MM/yyyy")}<br> {km0} {used} <br> Chilometri percorsi: {list[i].KmDone}<br> Potenza: {list[i].PowerKw} <br> Prezzo: {list[i].Price} € </div>"; mainContent += "</div>"; mainContent += "</div>"; }
public SerializableBindingList <Vehicles> VehicleList; // The BindingList hears the changes during the code public FormMain() { InitializeComponent(); VehicleList = new SerializableBindingList <Vehicles>(); listBoxVehicles.DataSource = VehicleList; Start(); }
private void CaricaDati() { ///prendo i dati dal database e li carico su bindinglistveicoli BindingListVeicoli = UtilsDatabase.OpenDataBaseToList(BindingListVeicoli); ///Carico su dgv dgvVeicoli.DataSource = BindingListVeicoli; }
public FormMain() { InitializeComponent(); BindingListVeicoli = new SerializableBindingList<Veicolo>(); dgvVeicoli.AutoResizeColumns(); dgvVeicoli.AutoResizeRows(); dgvVeicoli.ClearSelection(); dgvVeicoli.RowHeadersVisible = false; pd.PrintPage += new PrintPageEventHandler(this.printDoc_PrintPage); }
private void apriToolStripButton_Click(object sender, EventArgs e) { StreamReader sr = new StreamReader(@"Veicoli.json"); string jsonString = sr.ReadToEnd(); var items = JsonConvert.DeserializeObject <object>(jsonString); SerializableBindingList <object> lst = JsonConvert.DeserializeObject <SerializableBindingList <object> >(jsonString); SerializableBindingList <Veicolo> lsti = Utils.deserializeObject(lst); MessageBox.Show(items.ToString()); }
public static SerializableBindingList <Veicolo> deserializeObject(IEnumerable <object> objectlist) { SerializableBindingList <Veicolo> list = new SerializableBindingList <Veicolo>(); foreach (var item in objectlist) { //list.Add(item); } return(list); }
public static string datapass(string connectionStr, SerializableBindingList <veicolo> listveicolo, int[] iDs) { try { if (connectionStr != null) { OleDbConnection connection = new OleDbConnection(connectionStr); using (connection) { connection.Open(); OleDbCommand command = new OleDbCommand("SELECT * FROM veicoli", connection); OleDbDataReader reader = command.ExecuteReader(); listveicolo.Clear(); Array.Clear(iDs, 0, iDs.Length); if (reader.HasRows) { int i = 0; while (reader.Read()) { if (reader.GetString(1) == "auto") { iDs[i] = reader.GetInt32(0); listveicolo.Add(new auto(reader.GetString(2), reader.GetString(3), reader.GetInt32(4), reader.GetDouble(5), reader.GetDateTime(6), reader.GetInt32(7), reader.GetString(8), reader.GetString(9) == "SI" ? true : false, reader.GetString(10) == "SI" ? true : false, reader.GetInt32(12), reader.GetString(11))); } else { iDs[i] = reader.GetInt32(0); listveicolo.Add(new moto(reader.GetString(2), reader.GetString(3), reader.GetInt32(4), reader.GetDouble(5), reader.GetDateTime(6), reader.GetInt32(7), reader.GetString(8), reader.GetString(9) == "SI" ? true : false, reader.GetString(10) == "SI" ? true : false, reader.GetInt32(12), reader.GetString(11))); } i++; // Marca: {reader.GetString(2)}; // Modello: {reader.GetString(3)}; // Cilindrata: {reader.GetInt32(4)}; // Potenza(KW): {reader.GetDouble(5)}; // Data Immatricolazione: {reader.GetDateTime(6).ToShortDateString()}; // Chilometri percorsi: {reader.GetInt32(7)}; // Colore: {reader.GetString(8)}; // Usato: {reader.GetString(9)}; // Km0: {reader.GetString(10)}; // Informazioni: {reader.GetString(11)}; // Prezzo: {reader.GetInt32(12)}; } } reader.Close(); } } return("DONE"); } catch (Exception ex) { return("\n!!ERROR!! " + ex.Message); } }
private void FormMain_Load(object sender, EventArgs e) { constr = "Provider=Microsoft.Ace.Oledb.12.0;Data Source=Veicoli.accdb;"; try { CreateTable(constr); } catch (OleDbException) { } bindingListVeicoli = openDb(constr, "select * from Veicoli"); listBoxVeicoli.DataSource = bindingListVeicoli; this.listBoxVeicoli.SelectedIndexChanged += new System.EventHandler(this.listBoxVeicoli_SelectedIndexChanged); }
private void button1_Click(object sender, EventArgs e) { Team t = new Team(999, "Test", "Test di test", new Country("IT", "Italy"), "Ferrari", "Giaison", "Test chassis", null, null); teams.Add(t); teamsRes = new SerializableBindingList <Team>(); // probabilmente errore nella trasmissione dei dati teams = teamsRes; DbTools.SerializeToCsv(teamsRes, @".\Teams.csv"); /***** NON VA *****/ }
private SheetData GenerateSheetdataForDetails(SerializableBindingList <Veicolo> data) { SheetData sheetData1 = new SheetData(); sheetData1.Append(CreateHeaderRowForExcel()); foreach (Veicolo testmodel in data) { Row partsRows = GenerateRowForChildPartDetail(testmodel); sheetData1.Append(partsRows); } return(sheetData1); }
/// <summary> /// Fill the list with db datas /// </summary> /// <param name="list"> List to fill </param> /// <param name="connStr"> String of connection </param> public void OpenDBInList(SerializableBindingList <Vehicles> list, string connStr) { if (connStr != null) { OleDbConnection con = new OleDbConnection(connStr); using (con) { con.Open(); InsertItemInList(list, con, "Auto"); InsertItemInList(list, con, "Moto"); } } }
}//CREAZIONE LISTINO private void SearchButton_Click(object sender, EventArgs e) { string s = Interaction.InputBox("Inserisci ricerca: ", "Cerca"); search = s.Split(' '); results = Veicolo.Search(s, listaVeicoli.ToList()); if (results.Count == 0)//NESSUN RISULTATO { MessageBox.Show($"Nessun risultato trovato per {s}"); } else { if (this.tRicerca == null)//SE LA TAB E' GIA' APERTA LA RESETTA { //CREO LA GRAFICA DINAMICAMENTE (CODICE PRESO DA UNA FORM RIMOSSA) #region Inizializzazione this.tRicerca = new TabPage();//CREO LA PAGINA this.tlpResults = new System.Windows.Forms.FlowLayoutPanel(); this.tRicerca.Controls.Add(this.tlpResults); this.Tb.TabPages.Add(this.tRicerca); this.tRicerca.Text = "Ricerca"; this.Tb.SelectTab(this.tRicerca); // // tlpResults // this.tlpResults.AutoScroll = true; this.tlpResults.Dock = System.Windows.Forms.DockStyle.Fill; this.tlpResults.BackColor = System.Drawing.Color.FromArgb(45, 45, 45); this.tlpResults.Location = new System.Drawing.Point(0, 0); this.tlpResults.Name = "tlpResults"; this.tlpResults.Size = new System.Drawing.Size(585, 324); this.tlpResults.TabIndex = 0; this.tlpResults.Padding = new Padding(0); #endregion// } else { this.tlpResults.Controls.Clear(); } this.Tb.SelectTab(this.tRicerca); foreach (Veicolo Mezzo in results) {//CREO LE CARTE GRAFICHE DEI RISULTATI var c = new Card(Mezzo); c.btnDelete.Visible = false; c.CardDeleted += Handler_CardDeleted; c.CardShowed += Handler_CardShowed; this.tlpResults.Controls.Add(c); } } }//RICERCA DATI
public bool listaTabella(string nomeTabella, SerializableBindingList <Veicolo> bindingVeicolo) { if (conStr != null) { OleDbConnection con = new OleDbConnection(conStr); using (con) { con.Open(); OleDbCommand cmd; try { cmd = new OleDbCommand($"SELECT * FROM {nomeTabella}", con); } catch (Exception ex) { throw new Exception(ex.Message); } OleDbDataReader reader = cmd.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { if (nomeTabella == "Auto") { Auto a = new Auto(reader.GetString(1), reader.GetString(2), reader.GetString(3), reader.GetInt32(4), reader.GetInt32(5), reader.GetDateTime(6), reader.GetString(7) == "Si" ? true:false, reader.GetString(8) == "Si" ? true:false, reader.GetInt32(9), reader.GetInt32(10), reader.GetInt32(11), reader.GetInt32(0)); bindingVeicolo.Add(a); } else { Moto m = new Moto(reader.GetString(1), reader.GetString(2), reader.GetString(3), reader.GetInt32(4), reader.GetInt32(5), reader.GetDateTime(6), reader.GetString(7) == "Si" ? true : false, reader.GetString(8) == "Si" ? true : false, reader.GetInt32(9), reader.GetInt32(10), reader.GetString(11), reader.GetInt32(0)); bindingVeicolo.Add(m); } } reader.Close(); return(true); } else { reader.Close(); return(false); } } } return(false); }
public void CreatePartsForExcel(SpreadsheetDocument document, SerializableBindingList <Veicolo> data) { SheetData partSheetData = GenerateSheetdataForDetails(data); WorkbookPart workbookPart1 = document.AddWorkbookPart(); GenerateWorkbookPartContent(workbookPart1); WorkbookStylesPart workbookStylesPart1 = workbookPart1.AddNewPart <WorkbookStylesPart>("rId3"); GenerateWorkbookStylesPartContent(workbookStylesPart1); WorksheetPart worksheetPart1 = workbookPart1.AddNewPart <WorksheetPart>("rId1"); GenerateWorksheetPartContent(worksheetPart1, partSheetData); }
public static void createHtml(SerializableBindingList <Veicolo> lista, string pathName) { string html = File.ReadAllText($"{Directory.GetParent(Directory.GetCurrentDirectory()).Parent.Parent.FullName}\\storage/www/index-skeleton.html"); html = html.Replace("{{head-title}}", "ALBUM VEICOLI"); html = html.Replace("{{body-title}}", "VENDITA VEICOLI"); string aus = "<h3> </h3>"; for (int i = 0; i < lista.Count; i++) { createBody(ref aus, lista, i); } html = html.Replace("{{main-content}}", aus); File.WriteAllText(pathName, html); }
public static void createHtml(SerializableBindingList <Veicolo> lista, string pathName, string skeletonPathName = @".\www\index-skeleton.html") { string html = File.ReadAllText(skeletonPathName); html = html.Replace("{{head-title}}", "ALBUM VEICOLI"); html = html.Replace("{{body-title}}", "SALONE VEICOLI NUOVI E USATI"); string aus = "<h3> </h3>"; for (int i = 0; i < lista.Count; i++) { createBody(ref aus, lista, i); } html = html.Replace("{{main-content}}", aus); File.WriteAllText(pathName, html); }
//HTML public static void CreateHtml(SerializableBindingList <Veicolo> lista, string pathName, string skeletonPathName = @".\www\index - skeleton.html") { string html = File.ReadAllText(skeletonPathName); html = html.Replace("{{head-title}}", "AUTOVALLAURI"); html = html.Replace("{{body-title}}", "SALONE AUTOVALLAURI - VEICOLI NUOVI E USATI"); html = html.Replace("{{body-subtitle}}", "Le migliori occasioni al miglior prezzo!"); string aus = "<h3> LISTA DEI VEICOLI DISPONIBILI: </h3>"; foreach (var item in lista) { creaCorpo(item, ref aus); } html = html.Replace("{{main-content}}", aus); //File.Delete(skeletonPathName); non lo togliamo qui(ma quando faremo la pubblicazione) perchè se voglio riaprire il sito un'altra volta non lo trova più File.WriteAllText(pathName, html); }
/// <summary> /// Create the html /// </summary> /// <param name="list"> List with datas </param> /// <param name="pathName"> index.html path </param> /// <param name="skeletonPathName"> Auxiliary index.html </param> public void CreateHtml(SerializableBindingList <Vehicles> list, string pathName, string skeletonPathName = @".\www\index-skeleton.html") { string html = File.ReadAllText(skeletonPathName); html = html.Replace("{{head-title}}", "AUTOVALLAURI"); html = html.Replace("{{body-title}}", "AUTOPALU - VEICOLI NUOVI E USATI"); html = html.Replace("{{body-subtitle}}", "Le migliori occasioni al miglior prezzo!"); string mainContent = "<h3> LISTA DEI VEICOLI DISPONIBILI </h3>"; for (int i = 0; i < list.Count; i++) { CreateBody(ref mainContent, list, i); } html = html.Replace("{{main-content}}", mainContent); File.WriteAllText(pathName, html); }
public void CreateHtml(SerializableBindingList <Veicolo> list, string pathName, string skeletonPathName = @".\www\index-skeleton.html") { string html = File.ReadAllText(skeletonPathName); html = html.Replace("{{head-title}}", "Autosalone da Stefirca"); html = html.Replace("{{body-title}}", "Veicoli nuovi e usati"); html = html.Replace("{{body-subtitle}}", "prezzi scontati ogni giorno!"); string mainContent = "<h3> Veicoli disponibili </h3>"; for (int i = 0; i < list.Count; i++) { CreateBody(ref mainContent, list, i); } html = html.Replace("{{main-content}}", mainContent); File.WriteAllText(pathName, html); }