private void btnUploadMoreFiles_Click(object sender, EventArgs e) { OpenFileDialog ofd = new OpenFileDialog(); ofd.Filter = " Documents Files |*.docx;*.xlsx;*.pdf|" + "Images |*.png;*.jpg;*.gif|" + "All files |*.*"; ofd.Multiselect = true; ofd.Title = "Sélectionner les fichiers à importer ...."; if (ofd.ShowDialog() == DialogResult.OK) { using (DBGCourriesContext db = new DBGCourriesContext()) { FileInfo finfo; DepartDocs DepDocs; foreach (string file in ofd.FileNames) { finfo = new FileInfo(file); DepDocs = new DepartDocs(); DepDocs.idDepart = this.idDepart; DepDocs.TypeDocDepart = finfo.Extension; DepDocs.FileName = finfo.Name; DepDocs.ContenuFileDepart = SharedData.GetBinaryFromFile(finfo.FullName); db.DepartDocs.Add(DepDocs); db.SaveChanges(); } // charger les pièces jointes de ce courrier loadDepartDocs(); } } }
private void btnEnregistrer_Click(object sender, EventArgs e) { using (DBGCourriesContext db = new DBGCourriesContext()) { Depart dep = new Depart(); int nextNumOrdreDepart = db.Depart.Any() ? db.Depart.Max(x => x.NumOrdre) + 1 : 1; dep.NumOrdre = nextNumOrdreDepart; dep.Sujet = txtSujet.Text; dep.Remarques = txtRemarque.Text; dep.DateOrdre = txtDateOrdre.Value.Date; dep.Annee = txtDateOrdre.Value.Date.Year; dep.idCateg = Convert.ToInt32(txtCateg.SelectedValue); dep.idUser = 1; db.Depart.Add(dep); foreach (Entites entite in txtEntite.CheckedItems) { //attach instance to context db.Entites.Attach(entite); dep.Entites.Add(entite); } db.SaveChanges(); DepartDocs depDocs = new DepartDocs(); depDocs.idDepart = dep.idDepart; foreach (ListViewItem item in txtPJointes.Items) { FileInfo f = new FileInfo(item.SubItems[0].Text);//non du fichier depDocs.TypeDocDepart = f.Extension; depDocs.FileName = item.SubItems[0].Text; depDocs.ContenuFileDepart = SharedData.GetBinaryFromFile(item.SubItems[1].Text); db.DepartDocs.Add(depDocs); db.SaveChanges(); } this.Close(); frmListDeparts.LoadListDepart(); } }