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 dgvDepartDocs_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
string ColName = dgvDepartDocs.Columns[e.ColumnIndex].Name;
if (ColName == "btnDelete")
{
DialogResult dr = MessageBox.Show(
"Voulez Vous supprimer ce fichier",
"Confirmation de suppression",
MessageBoxButtons.YesNo, MessageBoxIcon.Warning
);
if (dr == DialogResult.Yes)
{
using (DBGCourriesContext db = new DBGCourriesContext())
{
int idDepDocs = Convert.ToInt32(dgvDepartDocs.Rows[e.RowIndex].Cells["idDocDepart"].Value);
DepartDocs depDocs = db.DepartDocs.FirstOrDefault(x => x.idDocDepart == idDepDocs);
db.DepartDocs.Remove(depDocs);
db.SaveChanges();
// charger les pièces jointes de ce courrier
loadDepartDocs();
}
}
}
if (ColName == "btnDowload")
{
int idDepDocs = Convert.ToInt32(dgvDepartDocs.Rows[e.RowIndex].Cells["idDocDepart"].Value);
using (DBGCourriesContext db = new DBGCourriesContext())
{
DepartDocs depDocs = db.DepartDocs.FirstOrDefault(x => x.idDocDepart == idDepDocs);
byte[] fileContent = depDocs.ContenuFileDepart;
string fileName = depDocs.FileName;
Stream strm;
SaveFileDialog saveFile = new SaveFileDialog();
saveFile.Filter = "All Files (*.*)|*.*";
saveFile.FileName = fileName;
if (saveFile.ShowDialog() == DialogResult.OK)
{
if ((strm = saveFile.OpenFile()) != null)
{
strm.Write(fileContent, 0, fileContent.Length);
strm.Close();
}
}
}
}
}
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();
}
}