public static List <ContenuStock> listContenuStock(string query) { NpgsqlConnection con = Connexion.Connection(); try { NpgsqlCommand Lcmd = new NpgsqlCommand(query, con); NpgsqlDataReader lect = Lcmd.ExecuteReader(); List <ContenuStock> l = new List <ContenuStock>(); if (lect.HasRows) { while (lect.Read()) { ContenuStock y = oneContenuStock((Int32)((lect["id"] != null) ? (!lect["id"].ToString().Trim().Equals("") ? lect["id"] : 0) : 0)); l.Add(y); } } return(l); } catch (NpgsqlException e) { Messages.Exception(e); return(null); } finally { Connexion.Deconnection(con); } }
private void btn_add_Click(object sender, EventArgs e) { RecopieContenu(); if (current_contenu.Control()) { if (!current_contenu.Update) { ContenuStock f = ContenuStockBLL.Save(current_contenu); if (f != null ? f.Id > 0 : false) { current_contenu.Id = f.Id; current_contenu.Update = true; AddRowContenu(f); Messages.Succes(); ResetContenu(); } } else { if (ContenuStockBLL.Update(current_contenu)) { UpdateRowContenu(current_contenu); Messages.Succes(); ResetContenu(); } } } }
private void dgv_contenu_CellContentClick(object sender, DataGridViewCellEventArgs e) { try { if (dgv_contenu.CurrentRow.Cells["_id_"].Value != null) { Int32 id = Convert.ToInt32(dgv_contenu.CurrentRow.Cells["_id_"].Value); if (id > 0) { ContenuStock f = ContenuStockBLL.One(id); if (e.ColumnIndex == 4) { if (DialogResult.Yes == Messages.Confirmation(Mots.Supprimer.ToLower())) { if (ContenuStockBLL.Delete(f)) { DeleteRowContenu(f); ResetContenu(); Messages.Succes(); } } } else { PopulateContenu(f); } } } } catch (Exception ex) { Messages.Exception(ex); } }
public static ContenuStock oneContenuStock(Int32 id) { NpgsqlConnection con = Connexion.Connection(); try { String search = "select * from contenu_stock where id = " + id; NpgsqlCommand Lcmd = new NpgsqlCommand(search, con); NpgsqlDataReader lect = Lcmd.ExecuteReader(); ContenuStock y = new ContenuStock(); if (lect.HasRows) { while (lect.Read()) { y.Id = id; y.Prix = (Double)((lect["prix"] != null) ? (!lect["prix"].ToString().Trim().Equals("") ? lect["prix"] : 0) : 0); y.Quantite = (Double)((lect["quantite"] != null) ? (!lect["quantite"].ToString().Trim().Equals("") ? lect["quantite"] : 0) : 0); y.Article = BLL.ArticlesBLL.One((Int32)((lect["article"] != null) ? (!lect["article"].ToString().Trim().Equals("") ? lect["article"] : 0) : 0)); y.Update = true; } } return(y); } catch (NpgsqlException e) { Messages.Exception(e); return(null); } finally { Connexion.Deconnection(con); } }
public static Int32 currentContenuStock(ContenuStock f) { NpgsqlConnection con = Connexion.Connection(); try { String search = "select * from contenu_stock where stock = " + f.Stock.Id + " order by id desc limit 1"; NpgsqlCommand Lcmd = new NpgsqlCommand(search, con); NpgsqlDataReader lect = Lcmd.ExecuteReader(); Int32 id = new Int32(); if (lect.HasRows) { while (lect.Read()) { id = (Int32)((lect["id"] != null) ? (!lect["id"].ToString().Trim().Equals("") ? lect["id"] : 0) : 0); } } return(id); } catch (NpgsqlException e) { Messages.Exception(e); return(0); } finally { Connexion.Deconnection(con); } }
private void ResetContenu() { com_article.Text = null; txt_prix.Value = 0; txt_qte.Value = 1; com_article.Enabled = true; current_contenu = new ContenuStock(); }
private void PopulateContenu(ContenuStock c) { com_article.Text = c.Article.Designation; txt_prix.Value = Convert.ToDecimal(c.Prix); txt_qte.Value = Convert.ToDecimal(c.Quantite); com_article.Enabled = false; current_contenu = c; }
private void UpdateRowContenu(ContenuStock f) { int i = Utils.GetRowData(dgv_contenu, f.Id); if (i < 0) { dgv_contenu.Rows.RemoveAt(Utils.GetRowData(dgv_contenu, f.Id)); AddRowContenu(f); } }
public static bool Update(ContenuStock y) { try { return(ContenuStockDAO.updateContenuStock(y)); } catch (Exception ex) { throw new Exception("Modification Impossible", ex); } }
public static ContenuStock Save(ContenuStock y) { try { return(ContenuStockDAO.saveContenuStock(y)); } catch (Exception ex) { throw new Exception("Insertion Impossible", ex); } }
public static Int32 Current(ContenuStock y) { try { return(ContenuStockDAO.currentContenuStock(y)); } catch (Exception ex) { throw new Exception("Retour Impossible", ex); } }
public static bool Delete(ContenuStock y) { try { return(ContenuStockDAO.deleteContenuStock(y)); } catch (Exception ex) { throw new Exception("Suppression Impossible", ex); } }
public static bool updateContenuStock(ContenuStock f) { NpgsqlConnection con = Connexion.Connection(); try { string update = "update contenu_stock set prix =" + f.Prix + " , quantite =" + f.Quantite + " where id = " + f.Id; NpgsqlCommand cmd = new NpgsqlCommand(update, con); cmd.ExecuteNonQuery(); return(true); } catch (NpgsqlException e) { Messages.Exception(e); return(false); } finally { Connexion.Deconnection(con); } }
public static bool deleteContenuStock(ContenuStock f) { NpgsqlConnection con = Connexion.Connection(); try { string delete = "delete from contenu_stock where id = " + f.Id; NpgsqlCommand cmd = new NpgsqlCommand(delete, con); cmd.ExecuteNonQuery(); return(true); } catch (NpgsqlException e) { Messages.Exception(e); return(false); } finally { Connexion.Deconnection(con); } }
private void dgv_contenu_SelectionChanged(object sender, EventArgs e) { try { if (dgv_contenu.Rows.Count > 0) { if (dgv_contenu.CurrentRow.Cells["_id_"].Value != null) { Int32 id = (Int32)dgv_contenu.CurrentRow.Cells["_id_"].Value; if (id > 0) { ContenuStock f = ContenuStockBLL.One(id); PopulateContenu(f); } } } } catch (Exception ex) { Messages.Exception(ex); } }
public static ContenuStock saveContenuStock(ContenuStock f) { NpgsqlConnection con = Connexion.Connection(); try { string insert = "insert into contenu_stock (prix, quantite, article, stock) values (" + f.Prix + "," + f.Quantite + "," + f.Article.Id + "," + f.Stock.Id + ")"; NpgsqlCommand cmd = new NpgsqlCommand(insert, con); cmd.ExecuteNonQuery(); f.Id = currentContenuStock(f); return(f); } catch (NpgsqlException e) { Messages.Exception(e); return(null); } finally { Connexion.Deconnection(con); } }
private void AddRowContenu(ContenuStock f) { dgv_contenu.Rows.Add(new object[] { f.Id, f.Article.Designation, f.Quantite, f.Prix, null }); }
private void DeleteRowContenu(ContenuStock f) { dgv_contenu.Rows.RemoveAt(Utils.GetRowData(dgv_contenu, f.Id)); }