private void butQuery_Click(object sender, System.EventArgs e) { titles t = new titles(); t.title = "A"; ArrayList alBooks = PersistDAL.Query(typeof(titles), new SQLLike(t.title)); }
private void cmdTestDelete_Click(object sender, System.EventArgs e) { titles objTestBook = new titles(); objTestBook.title_id = txtTitleID.Text; PersistDAL.Delete(objTestBook); }
private void cmdTestInsert_Click(object sender, System.EventArgs e) { titles objTestBook = GetNewBookFromDisplayedData(); PersistDAL.Insert(objTestBook); ResetDisplayedData(objTestBook); // au cas ou certain valeur serait généré automatiquement ( style compteur ) }
private void cmdNouveau_Click(object sender, System.EventArgs e) { titles b = new titles(); // reset l'affichage pour pouvoir créer un nouveau Book. b.pub_id = "9999"; b.pubdate = DateTime.Now; ResetDisplayedData(b); }
private void button1_Click(object sender, System.EventArgs e) { titles b = new titles(); b.title_id = "PC8888"; PersistDAL.Read(b); //MessageBox.Show("<" + b.Editeur.pub_name +">",b.Editeur.pub_id); }
private void cmdTest_Click(object sender, System.EventArgs e) { titles b=new titles(); b.pub_id="1000"; ArrayList alBook=PersistDAL.ReadMultiple(b,null,"[pub_id]<1000",null,null); dataGrid1.DataSource=alBook; }
private void cmdTest_Click(object sender, System.EventArgs e) { titles b = new titles(); b.pub_id = "1000"; ArrayList alBook = PersistDAL.ReadMultiple(b, null, "[pub_id]<1000", null, null); dataGrid1.DataSource = alBook; }
private void cmdRead_Click(object sender, System.EventArgs e) { // Creation d'un object book titles objTestBook = new titles(); objTestBook.title_id = txtTitleID.Text; // j'initialise la 'clé primaire' // Persistance de l'obj PersistDAL.Read(objTestBook); // j'utilise la méthode statis Read pour le lire dans la base ResetDisplayedData(objTestBook); // je reactulise l'affichage }
private void cmdUpdateBench_Click(object sender, System.EventArgs e) { int nb = 50; int repeat = 50; this.Cursor = Cursors.WaitCursor; titles[] at = new titles[nb]; // initialisation des enreg for (int n = 0; n < nb; n++) { at[n] = new titles(); at[n].pubdate = DateTime.Now; at[n].type = ""; at[n].title = "BENCH " + n.ToString(); at[n].title_id = "B" + n.ToString(); try { PersistDAL.Delete(at[n]); } catch {} } DateTime timeStart = DateTime.Now; // insert initial for (int n = 0; n < nb; n++) { PersistDAL.Insert(at[n]); } // sequence Read/Update sur les NB enreg, repété REPEAT fois for (int r = 0; r < repeat; r++) { for (int n = 0; n < nb; n++) { PersistDAL.Read(at[n]); PersistDAL.Update(at[n]); } } // delete final for (int n = 0; n < nb; n++) { PersistDAL.Delete(at[n]); } DateTime timeStop = DateTime.Now; TimeSpan temps = timeStop - timeStart; this.Cursor = Cursors.Default; MessageBox.Show("Bench pour " + nb.ToString() + " enregistrements\r\nlu/updaté " + repeat.ToString() + " fois = \r\n\r\n" + temps.TotalMilliseconds.ToString() + " ms"); }
private void cmdTestTransaction_Click(object sender, System.EventArgs e) { titles a = new titles(); titles b = new titles(); a.title_id = "A"; //PersistDAL.Read(a); b.title_id = "B"; //PersistDAL.Read(b); a.title = "livre A - " + DateTime.Now.ToLongTimeString(); b.title = "libre B - " + DateTime.Now.ToLongTimeString(); /* PersistDAL.Update(new object[] { a,b} ); * PersistDAL.Delete(new object[] { a,b } ); * */ a.pubdate = DateTime.Now; b.pubdate = DateTime.Now; PersistDAL.Insert(new object[] { a, b }); }
private void butQuery_Click(object sender, System.EventArgs e) { titles t=new titles(); t.title="A"; ArrayList alBooks=PersistDAL.Query(typeof(titles),new SQLLike(t.title)); }
private void cmdNouveau_Click(object sender, System.EventArgs e) { titles b=new titles(); // reset l'affichage pour pouvoir créer un nouveau Book. b.pub_id="9999"; b.pubdate=DateTime.Now; ResetDisplayedData(b); }
private void cmdRead_Click(object sender, System.EventArgs e) { // Creation d'un object book titles objTestBook=new titles(); objTestBook.title_id=txtTitleID.Text; // j'initialise la 'clé primaire' // Persistance de l'obj PersistDAL.Read(objTestBook); // j'utilise la méthode statis Read pour le lire dans la base ResetDisplayedData(objTestBook); // je reactulise l'affichage }
private void cmdTestDelete_Click(object sender, System.EventArgs e) { titles objTestBook = new titles(); objTestBook.title_id=txtTitleID.Text; PersistDAL.Delete(objTestBook); }
private void ResetDisplayedData(titles b) { txtTitleID.Text = b.title_id; txtTitle.Text = b.title; txtAdvance.Text = b.advance.ToString(); txtNotes.Text = b.notes; txtPrice.Text = b.price.ToString(); txtPubDate.Text = b.pubdate.ToShortDateString(); txtPubID.Text = b.pub_id; txtRoyalty.Text = b.royalty.ToString(); txtType.Text = b.type; txtYtdSales.Text = b.ytd_sales.ToString(); if (b.advanceISNULL) { txtAdvance.BackColor = Color.Red; } else { txtAdvance.BackColor = Color.White; } if (b.notesISNULL) { txtNotes.BackColor = Color.Red; } else { txtNotes.BackColor = Color.White; }; if (b.priceISNULL) { txtPrice.BackColor = Color.Red; } else { txtPrice.BackColor = Color.White; }; if (b.pub_idISNULL) { txtPubID.BackColor = Color.Red; } else { txtPubID.BackColor = Color.White; }; if (b.royaltyISNULL) { txtRoyalty.BackColor = Color.Red; } else { txtRoyalty.BackColor = Color.White; }; if (b.ytd_salesISNULL) { txtYtdSales.BackColor = Color.Red; } else { txtYtdSales.BackColor = Color.White; }; /* * if (b.Editeur!=null) * { * txtPubNom.Text=b.Editeur.pub_name; * txtPubVille.Text=b.Editeur.city; * txtPubEtat.Text=b.Editeur.state; * txtPubPays.Text=b.Editeur.country; * } */ }
private titles GetNewBookFromDisplayedData() { titles b = new titles(); if (txtAdvance.BackColor == Color.Red) { b.advanceISNULL = true; } else { b.advance = decimal.Parse(txtAdvance.Text); } b.title_id = txtTitleID.Text; if (txtNotes.BackColor == Color.Red) { b.notesISNULL = true; } else { b.notes = txtNotes.Text; } if (txtPrice.BackColor == Color.Red) { b.priceISNULL = true; } else { b.price = decimal.Parse(txtPrice.Text); } b.pubdate = DateTime.Parse(txtPubDate.Text); if (txtPubID.BackColor == Color.Red) { b.pub_idISNULL = true; } else { b.pub_id = txtPubID.Text; } if (txtRoyalty.BackColor == Color.Red) { b.royaltyISNULL = true; } else { b.royalty = int.Parse(txtRoyalty.Text); } b.title = txtTitle.Text; b.type = txtType.Text; if (txtYtdSales.BackColor == Color.Red) { b.ytd_salesISNULL = true; } else { b.ytd_sales = int.Parse(txtYtdSales.Text); } /* * b.Editeur=new Publisher(); * b.Editeur.pub_id=b.pub_id; * b.Editeur.pub_name=txtPubNom.Text; * b.Editeur.city=txtPubVille.Text; * b.Editeur.state=txtPubEtat.Text; * b.Editeur.country=txtPubPays.Text; */ return(b); }
private void cmdTestTransaction_Click(object sender, System.EventArgs e) { titles a=new titles(); titles b=new titles(); a.title_id="A"; //PersistDAL.Read(a); b.title_id="B"; //PersistDAL.Read(b); a.title="livre A - " + DateTime.Now.ToLongTimeString(); b.title="libre B - " + DateTime.Now.ToLongTimeString(); /* PersistDAL.Update(new object[] { a,b} ); PersistDAL.Delete(new object[] { a,b } ); */ a.pubdate=DateTime.Now; b.pubdate=DateTime.Now; PersistDAL.Insert(new object[] { a,b }); }
private void cmdUpdateBench_Click(object sender, System.EventArgs e) { int nb=50; int repeat=50; this.Cursor=Cursors.WaitCursor; titles[] at=new titles[nb]; // initialisation des enreg for(int n=0;n<nb;n++) { at[n]=new titles(); at[n].pubdate=DateTime.Now; at[n].type=""; at[n].title="BENCH "+n.ToString(); at[n].title_id="B"+n.ToString(); try { PersistDAL.Delete(at[n]); } catch{} } DateTime timeStart=DateTime.Now; // insert initial for(int n=0;n<nb;n++) { PersistDAL.Insert(at[n]); } // sequence Read/Update sur les NB enreg, repété REPEAT fois for(int r=0;r<repeat;r++) { for(int n=0;n<nb;n++) { PersistDAL.Read(at[n]); PersistDAL.Update(at[n]); } } // delete final for(int n=0;n<nb;n++) { PersistDAL.Delete(at[n]); } DateTime timeStop=DateTime.Now; TimeSpan temps=timeStop-timeStart; this.Cursor=Cursors.Default; MessageBox.Show("Bench pour " + nb.ToString() + " enregistrements\r\nlu/updaté " + repeat.ToString() +" fois = \r\n\r\n" + temps.TotalMilliseconds.ToString() + " ms"); }
private void button1_Click(object sender, System.EventArgs e) { titles b=new titles(); b.title_id="PC8888"; PersistDAL.Read(b); //MessageBox.Show("<" + b.Editeur.pub_name +">",b.Editeur.pub_id); }
private void cmdUpdate_Click(object sender, System.EventArgs e) { titles objTestBook = GetNewBookFromDisplayedData(); // je crée un objet a partir de l'affichage PersistDAL.Update(objTestBook); // on persist l'objet dans la base de données via la méthode static update }
private void ResetDisplayedData(titles b) { txtTitleID.Text=b.title_id; txtTitle.Text=b.title; txtAdvance.Text=b.advance.ToString(); txtNotes.Text=b.notes; txtPrice.Text=b.price.ToString(); txtPubDate.Text=b.pubdate.ToShortDateString(); txtPubID.Text=b.pub_id; txtRoyalty.Text=b.royalty.ToString(); txtType.Text=b.type; txtYtdSales.Text=b.ytd_sales.ToString(); if (b.advanceISNULL) txtAdvance.BackColor=Color.Red; else txtAdvance.BackColor=Color.White; if (b.notesISNULL) txtNotes.BackColor=Color.Red; else txtNotes.BackColor=Color.White;; if (b.priceISNULL) txtPrice.BackColor=Color.Red; else txtPrice.BackColor=Color.White;; if (b.pub_idISNULL) txtPubID.BackColor=Color.Red; else txtPubID.BackColor=Color.White;; if (b.royaltyISNULL) txtRoyalty.BackColor=Color.Red; else txtRoyalty.BackColor=Color.White;; if (b.ytd_salesISNULL) txtYtdSales.BackColor=Color.Red; else txtYtdSales.BackColor=Color.White;; /* if (b.Editeur!=null) { txtPubNom.Text=b.Editeur.pub_name; txtPubVille.Text=b.Editeur.city; txtPubEtat.Text=b.Editeur.state; txtPubPays.Text=b.Editeur.country; } */ }
private titles GetNewBookFromDisplayedData() { titles b=new titles(); if (txtAdvance.BackColor==Color.Red) b.advanceISNULL=true; else b.advance=decimal.Parse(txtAdvance.Text); b.title_id=txtTitleID.Text; if (txtNotes.BackColor==Color.Red) b.notesISNULL=true; else b.notes=txtNotes.Text; if (txtPrice.BackColor==Color.Red) b.priceISNULL=true; else b.price=decimal.Parse(txtPrice.Text); b.pubdate=DateTime.Parse(txtPubDate.Text); if (txtPubID.BackColor==Color.Red) b.pub_idISNULL=true; else b.pub_id=txtPubID.Text; if (txtRoyalty.BackColor==Color.Red) b.royaltyISNULL=true; else b.royalty=int.Parse(txtRoyalty.Text); b.title=txtTitle.Text; b.type=txtType.Text; if (txtYtdSales.BackColor==Color.Red) b.ytd_salesISNULL=true; else b.ytd_sales=int.Parse(txtYtdSales.Text); /* b.Editeur=new Publisher(); b.Editeur.pub_id=b.pub_id; b.Editeur.pub_name=txtPubNom.Text; b.Editeur.city=txtPubVille.Text; b.Editeur.state=txtPubEtat.Text; b.Editeur.country=txtPubPays.Text; */ return b; }