private void dgv_liste_CellContentClick(object sender, DataGridViewCellEventArgs e) { try { if (dgv_liste.CurrentRow.Cells["id_"].Value != null) { Int32 id = Convert.ToInt32(dgv_liste.CurrentRow.Cells["id_"].Value); if (id > 0) { DocStock f = DocStockBLL.One(id); if (e.ColumnIndex == 5) { if (DialogResult.Yes == Messages.Confirmation(Mots.Supprimer.ToLower())) { if (DocStockBLL.Delete(f)) { DeleteRow(f); Reset(); Messages.Succes(); } } } else { Populate(f); } } } } catch (Exception ex) { Messages.Exception(ex); } }
public static List <DocStock> listDocStock(string query) { NpgsqlConnection con = Connexion.Connection(); try { NpgsqlCommand Lcmd = new NpgsqlCommand(query, con); NpgsqlDataReader lect = Lcmd.ExecuteReader(); List <DocStock> l = new List <DocStock>(); if (lect.HasRows) { while (lect.Read()) { DocStock y = oneDocStock((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_save_Click(object sender, EventArgs e) { Recopie(); if (current.Control()) { if (!current.Update) { DocStock f = DocStockBLL.Save(current); if (f != null ? f.Id > 0 : false) { current.Id = f.Id; current.Update = true; rbtn_entree.Enabled = false; rbtn_sortie.Enabled = false; AddRow(f); Messages.Succes(); } } else { if (DocStockBLL.Update(current)) { UpdateRow(current); Messages.Succes(); } } Reset(); } }
public static Int32 currentDocStock(DocStock f) { NpgsqlConnection con = Connexion.Connection(); try { String search = "select * from doc_stocks where reference = '" + f.Reference + "' and date_doc = '" + f.Date + "'"; 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); } }
public static DocStock oneDocStock(Int32 id) { NpgsqlConnection con = Connexion.Connection(); try { String search = "select * from doc_stocks where id = " + id; NpgsqlCommand Lcmd = new NpgsqlCommand(search, con); NpgsqlDataReader lect = Lcmd.ExecuteReader(); DocStock y = new DocStock(); if (lect.HasRows) { while (lect.Read()) { y.Id = id; y.Reference = lect["reference"].ToString(); y.Type = lect["type_doc"].ToString(); y.Date = (DateTime)((lect["date_doc"] != null) ? (!lect["date_doc"].ToString().Trim().Equals("") ? lect["date_doc"] : DateTime.Now) : DateTime.Now); y.Contenus = BLL.ContenuStockBLL.List("select * from contenu_stock where stock = " + id); y.Update = true; } } return(y); } catch (NpgsqlException e) { Messages.Exception(e); return(null); } finally { Connexion.Deconnection(con); } }
private void UpdateRow(DocStock f) { int i = Utils.GetRowData(dgv_liste, f.Id); if (i < 0) { dgv_liste.Rows.RemoveAt(i); AddRow(f); } }
private void Populate(DocStock d) { rbtn_entree.Checked = d.Type.Trim().Equals(Constantes.MOUV_ENTREE); rbtn_sortie.Checked = d.Type.Trim().Equals(Constantes.MOUV_SORTIE); rbtn_entree.Enabled = false; rbtn_sortie.Enabled = false; txt_reference.Text = d.Reference; date_save.Value = d.Date; current = d; LoadGrilleContenu(d); }
public static bool Delete(DocStock y) { try { return(DocStockDAO.deleteDocStock(y)); } catch (Exception ex) { throw new Exception("Suppression Impossible", ex); } }
public static bool Update(DocStock y) { try { return(DocStockDAO.updateDocStock(y)); } catch (Exception ex) { throw new Exception("Modification Impossible", ex); } }
public static DocStock Save(DocStock y) { try { return(DocStockDAO.saveDocStock(y)); } catch (Exception ex) { throw new Exception("Insertion Impossible", ex); } }
public static Int32 Current(DocStock y) { try { return(DocStockDAO.currentDocStock(y)); } catch (Exception ex) { throw new Exception("Retour Impossible", ex); } }
private void LoadGrilleContenu(DocStock d) { dgv_contenu.Rows.Clear(); string query = "select * from contenu_stock where stock = " + d.Id + " order by id"; current.Contenus = ContenuStockBLL.List(query); foreach (ContenuStock c in current.Contenus) { AddRowContenu(c); } ResetContenu(); }
private void Reset() { txt_reference.Text = Utils.ReferenceElement(Constantes.MOUV_ENTREE); rbtn_entree.Checked = true; date_save.Value = DateTime.Now; rbtn_entree.Enabled = true; rbtn_sortie.Enabled = true; current = new DocStock(); date_save.Focus(); dgv_contenu.Rows.Clear(); ResetContenu(); }
public static bool deleteDocStock(DocStock f) { NpgsqlConnection con = Connexion.Connection(); try { string delete = "delete from doc_stocks 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); } }
public static bool updateDocStock(DocStock f) { NpgsqlConnection con = Connexion.Connection(); try { string update = "update doc_stocks set reference ='" + f.Reference + "' , type_doc = '" + f.Type + "' , date_doc = '" + f.Date + "' 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); } }
private void dgv_liste_SelectionChanged(object sender, EventArgs e) { try { if (dgv_liste.Rows.Count > 0) { if (dgv_liste.CurrentRow.Cells["id_"].Value != null) { Int32 id = (Int32)dgv_liste.CurrentRow.Cells["id_"].Value; if (id > 0) { DocStock f = DocStockBLL.One(id); Populate(f); } } } } catch (Exception ex) { Messages.Exception(ex); } }
public static DocStock saveDocStock(DocStock f) { NpgsqlConnection con = Connexion.Connection(); try { string insert = "insert into doc_stocks (reference, type_doc, date_doc) values ('" + f.Reference + "','" + f.Type + "','" + f.Date + "')"; NpgsqlCommand cmd = new NpgsqlCommand(insert, con); cmd.ExecuteNonQuery(); f.Id = currentDocStock(f); return(f); } catch (NpgsqlException e) { Messages.Exception(e); return(null); } finally { Connexion.Deconnection(con); } }
private void DeleteRow(DocStock f) { dgv_liste.Rows.RemoveAt(Utils.GetRowData(dgv_liste, f.Id)); }
public static string ReferenceElement(string type) { if (!(type == null || type.Trim().Equals(""))) { String reference = ""; String apercu = type + "/"; if ((int)DateTime.Now.Day > 9) { apercu += (int)DateTime.Now.Day; } if ((int)DateTime.Now.Day < 10) { apercu += ("0" + (int)DateTime.Now.Day); } if ((int)DateTime.Now.Month > 9) { apercu += (int)DateTime.Now.Month; } if ((int)DateTime.Now.Month < 10) { apercu += ("0" + (int)DateTime.Now.Month); } apercu += DateTime.Now.Year.ToString().Substring(2); apercu += "/"; DocStock f = DocStockBLL.One(apercu + "%"); if ((f != null) ? !(f.Reference == null || f.Reference.Trim().Equals("")) : false) { reference = f.Reference; } else { reference = ""; } if (!reference.Trim().Equals("")) { String partieNum = reference.Replace(apercu, ""); if (apercu.Equals(reference.Substring(0, (reference.Length - partieNum.Length)))) { int num = Convert.ToInt16(partieNum); if (Convert.ToString(num + 1).Length > 4) { Messages.ShowErreur("Vous ne pouvez plus ajouter ce type de document"); return(""); } else { for (int i = 0; i < (4 - Convert.ToString(num + 1).Length); i++) { apercu += "0"; } } apercu += Convert.ToString(Convert.ToInt16(partieNum) + 1); } else { for (int i = 0; i < 4 - 1; i++) { apercu += "0"; } apercu += "1"; } } else { for (int i = 0; i < 4 - 1; i++) { apercu += "0"; } apercu += "1"; } return(apercu); } else { Messages.ShowErreur("Le type du document est incorrect!"); } return(null); }
private void AddRow(DocStock f) { dgv_liste.Rows.Add(new object[] { f.Id, f.Icon, f.Reference, f.Date, f.Type.Equals(Constantes.MOUV_ENTREE) ? Constantes.MOUV_ENTREE_NAME : Constantes.MOUV_SORTIE_NAME, null }); }