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();
}
}
