private void AddBook_Load(object sender, EventArgs e) { c = new Connexion(); b = new Books(); SelectfromTable("SELECT * FROM Autor", "autor_name", cb_Writer); SelectfromTable("SELECT * FROM EDITOR", "EDITOR_name", cb_Publisher); SelectfromTable("SELECT * FROM Category", "nom", cb_cate); SelectfromTable("SELECT * FROM Zon", "nom", cb_zon); if (b.ID != null) { dataTable = c.showDataTable(String.Format(@"SELECT * FROM dbo.book WHERE book_id = '{0}'", b.ID)); using (MemoryStream ms = new MemoryStream(c.getImage(int.Parse(dataTable.Rows[0]["image_id"].ToString())))) { image = Image.FromStream(ms); pic_book.Image = image; } tb_Title.Text = dataTable.Rows[0]["title"].ToString(); tb_ISBN.Text = dataTable.Rows[0]["book_isbn"].ToString(); tb_Pnum.Text = dataTable.Rows[0]["page_number"].ToString(); tb_Amount.Text = dataTable.Rows[0]["quantity"].ToString(); mtb_datePub.Text = DateTime.Parse(dataTable.Rows[0]["date_created"].ToString()).ToString("dd:mm:yyyy"); cb_Writer.Text = c.executer_valeur(string.Format(@"SELECT autor_name FROM Autor WHERE [aut_id] = '{0}'", dataTable.Rows[0]["aut_id"].ToString())); cb_Publisher.Text = c.executer_valeur(string.Format(@"SELECT EDITOR_name FROM EDITOR WHERE [EDITOR_id] = '{0}'", dataTable.Rows[0]["id_editor"].ToString())); cb_cate.Text = c.executer_valeur(string.Format(@"SELECT nom FROM category WHERE [id] = '{0}'", dataTable.Rows[0]["category"].ToString())); cb_zon.Text = c.executer_valeur(string.Format(@"SELECT nom FROM Zon WHERE [id] = '{0}'", dataTable.Rows[0]["zon_id"].ToString())); But_Ok.Text = "Update"; } }
int ZonID() { c = new Connexion(); int i = int.Parse(c.executer_valeur(string.Format(@"SELECT [id] FROM [dbo].[Zon] WHERE [nom] = '{0}'", zon))); return(i); }
int CategoryID() { c = new Connexion(); int i = int.Parse(c.executer_valeur(string.Format(@"Select [id] from [dbo].[Category] WHERE [nom] = '{0}'", category))); return(i); }
int PublisherId() { c = new Connexion(); int i = int.Parse(c.executer_valeur(string.Format(@"SELECT [EDITOR_id] FROM editor WHERE [EDITOR_name] = '{0}'", book_editor))); return(i); }
int autorId() { c = new Connexion(); int i = int.Parse(c.executer_valeur(string.Format(@"SELECT aut_id FROM Autor WHERE autor_name = '{0}'", book_autor))); return(i); }
public Boolean existence_Codebibl() //existence de la clé primaire si le count renvoie 0 alors le code n’existe pas { if (con.executer_valeur("select count(*) from Bibliothecaire where CodeBibl='" + CodeBibl + "'") == "0") { return(false); } else { return(true); } }
int getZonNumber(string zonId) { c = new Connexion(); return(int.Parse(c.executer_valeur(string.Format(@"SELECT * FROM dbo.Zon WHERE [id] = '{0}'", zonId)))); }
string getAutorName(string autorId) { c = new Connexion(); return(c.executer_valeur(string.Format(@"SELECT [autor_name] FROM Autor WHERE [aut_id] = '{0}'", autorId))); }