private void btnPrintListArrivee_Click(object sender, EventArgs e)
{
using (DBGCourriesContext db = new DBGCourriesContext())
{
List <ArriveeViewModel> list = new List <ArriveeViewModel>();
list = db.Arrivee.Select(
p => new ArriveeViewModel
{
idArrivee = p.idArrivee,
Categ = p.Categorie.LibCateg,
Entite = p.Entites.LibEntite,
Annee = p.Annee,
NumCourrier = p.NumCourrier,
DateOrdre = p.DateOrdre,
NumOrdre = p.NumOrdre,
DateCourrier = (DateTime)p.DateCourrier,
Sujet = p.Sujet,
Remarques = p.Remarques
}
).ToList();
if (!String.IsNullOrEmpty(this.txtCritere.Text))
{
list = list.Where(x => x.Sujet.ToLower().Contains(this.txtCritere.Text.ToLower())).ToList();
}
if (useDate.Checked)
{
list = list.Where(x => x.DateOrdre >= this.txtDateDeb.Value.Date && x.DateOrdre <= this.txtDateFin.Value.Date).ToList();
}
RptListeArrivee rpt = new RptListeArrivee();
rpt.SetDataSource(list);
frmPrintReport frmPrint = new frmPrintReport();
frmPrint.linkReport(rpt);
frmPrint.ShowDialog();
}
}
private void btnEnregistrer_Click(object sender, EventArgs e)
{
using (DBGCourriesContext db = new DBGCourriesContext())
{
int nextNumOrdre = db.Arrivee.Any() ? db.Arrivee.Max(x => x.NumOrdre) + 1 : 1;
Arrivee ar = new Arrivee();
ar.NumOrdre = nextNumOrdre;
ar.NumCourrier = txtNumCourrier.Text;
ar.Sujet = txtSujet.Text;
ar.Remarques = txtRemarque.Text;
ar.DateCourrier = txtDateCourrier.Value.Date;
ar.DateOrdre = txtDateOrdre.Value.Date;
ar.Annee = txtDateOrdre.Value.Date.Year;
ar.idCateg = Convert.ToInt32(txtCateg.SelectedValue);
ar.idEntite = Convert.ToInt32(txtEntite.SelectedValue);
ar.idUser = 1;
db.Arrivee.Add(ar);
db.SaveChanges();
ArriveeDocs arDocs = new ArriveeDocs();
arDocs.idArrivee = ar.idArrivee;
foreach (ListViewItem item in txtPJointes.Items)
{
FileInfo f = new FileInfo(item.SubItems[0].Text);//non du fichier
arDocs.TypeDocArrivee = f.Extension;
arDocs.FileName = item.SubItems[0].Text;
arDocs.ContenuFileArrivee = GetBinaryFromFile(item.SubItems[1].Text);
db.ArriveeDocs.Add(arDocs);
db.SaveChanges();
}
this.Close();
frmList.loadData();
}
}
public void loadData()
{
using (DBGCourriesContext db = new DBGCourriesContext())
{
var list = db.Arrivee.Select(
p => new
{
ID = p.idArrivee,
p.Annee,
p.NumOrdre,
Entite = p.Entites.LibEntite,
Categorie = p.Categorie.LibCateg,
p.DateOrdre,
p.DateCourrier,
p.NumCourrier,
p.Sujet
}).ToList();
if (!String.IsNullOrEmpty(txtCritere.Text))
{
list = list.Where(x => x.Sujet.ToLower().Contains(txtCritere.Text.ToLower())).ToList();
}
if (useDate.Checked)
{
list = list.Where
(x => x.DateOrdre >= txtDateDeb.Value.Date && x.DateOrdre <= txtDateFin.Value.Date).ToList();
}
dataGridArrivee.DataSource = list;
}
dataGridArrivee.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells;
dataGridArrivee.AllowUserToResizeColumns = true;
dataGridArrivee.AllowUserToOrderColumns = true;
dataGridArrivee.Columns["ID"].Visible = false;
}
private void dgvDeparts_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
string colName = dgvDeparts.Columns[e.ColumnIndex].Name;
int idDepart = Convert.ToInt32(dgvDeparts.Rows[e.RowIndex].Cells["ID"].Value);
if (colName == "btnDel")
{
DialogResult dr = MessageBox.Show("Voulez vous vraiment supprimer ce courrier ?",
"Confirmation de Suppression",
MessageBoxButtons.YesNo,
MessageBoxIcon.Warning
);
if (dr == DialogResult.Yes)
{
using (DBGCourriesContext db = new DBGCourriesContext())
{
Depart depart = db.Depart.FirstOrDefault(d => d.idDepart == idDepart);
depart.Entites.Clear();// supprimer toutes les entités liées au courrier depart (table destiner)
List <DepartDocs> docsToDelete = db.DepartDocs.Where(d => d.idDepart == idDepart).ToList();
db.DepartDocs.RemoveRange(docsToDelete);
db.Depart.Remove(depart);
db.SaveChanges();
LoadListDepart();
}
}
}
if (colName == "btnEdit")
{
EditDepart frmEdit = new EditDepart(idDepart, this);
frmEdit.ShowDialog();
}
}
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 EditDepart_Load(object sender, EventArgs e)
{
if (this.idDepart != 0)
{
txtTitre.Text = "Edition Courrier Départ N° :" + this.idDepart;
using (DBGCourriesContext db = new DBGCourriesContext())
{
txtCateg.DataSource = db.Categorie.ToList();
txtCateg.DisplayMember = "LibCateg";
txtCateg.ValueMember = "idCateg";
txtEntite.DataSource = db.Entites.ToList();
txtEntite.DisplayMember = "LibEntite";
txtEntite.ValueMember = "idEntite";
Depart dep = db.Depart.FirstOrDefault(x => x.idDepart == this.idDepart);
txtDateOrdre.Value = dep.DateOrdre.Date;
txtSujet.Text = dep.Sujet;
txtRemarque.Text = dep.Remarques;
txtCateg.SelectedItem = dep.Categorie;
foreach (Entites entite in dep.Entites)
{
for (int i = 0; i < txtEntite.Items.Count; i++)
{
if (entite.idEntite == ((Entites)txtEntite.Items[i]).idEntite)
{
txtEntite.SetItemChecked(i, true);
}
}
}
// charger les fichiers de ce courrier départ
loadDepartDocs();
dgvDepartDocs.Columns["idDepart"].Visible = false;
dgvDepartDocs.Columns["idDocDepart"].Visible = false;
dgvDepartDocs.ColumnHeadersVisible = false;
dgvDepartDocs.RowHeadersVisible = false;
DataGridViewImageColumn btnDowload = new DataGridViewImageColumn();
btnDowload.Name = "btnDowload";
btnDowload.HeaderText = "";
btnDowload.Image = Properties.Resources.download3;
dgvDepartDocs.Columns.Add(btnDowload);
DataGridViewImageColumn btnDelete = new DataGridViewImageColumn();
btnDelete.Name = "btnDelete";
btnDelete.HeaderText = "";
btnDelete.Image = Properties.Resources.delete1;
dgvDepartDocs.Columns.Add(btnDelete);
dgvDepartDocs.Columns["btnDowload"].DefaultCellStyle.Padding = new Padding(5, 5, 5, 5);
dgvDepartDocs.Columns["btnDelete"].DefaultCellStyle.Padding = new Padding(5, 5, 5, 5);
dgvDepartDocs.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells;
}
}
}
private void frmArriveeAdd_Load(object sender, EventArgs e)
{
using (DBGCourriesContext db = new DBGCourriesContext()) {
txtCateg.DataSource = db.Categorie.ToList();
txtCateg.ValueMember = "idCateg";
txtCateg.DisplayMember = "LibCateg";
txtEntite.DataSource = db.Entites.ToList();
txtEntite.ValueMember = "idEntite";
txtEntite.DisplayMember = "LibEntite";
}
}
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 loadDepartDocs()
{
using (DBGCourriesContext db = new DBGCourriesContext())
{
dgvDepartDocs.DataSource = db.Depart.FirstOrDefault(x => x.idDepart == this.idDepart).DepartDocs.Select(
p => new
{
p.idDepart,
p.idDocDepart,
p.TypeDocDepart,
p.FileName,
size = Math.Round(((p.ContenuFileDepart.Length) / 1024f), 2) + " KB"
}).ToList();
}
}
private void loadDataArriveesDocs()
{
using (DBGCourriesContext db = new DBGCourriesContext())
{
dgvArriveeDocs.DataSource = db.Arrivee.FirstOrDefault(x => x.idArrivee == this.idArrivee).ArriveeDocs.Select(
p => new
{
p.idArrivee,
p.idArriveeDocs,
p.TypeDocArrivee,
p.FileName,
size = Math.Round(((p.ContenuFileArrivee.Length) / 1024f), 2) + " KB"
}).ToList();
}
}
private void frmArriveeEdit_Load(object sender, EventArgs e)
{
using (DBGCourriesContext db = new DBGCourriesContext())
{
txtCateg.DataSource = db.Categorie.ToList();
txtCateg.ValueMember = "idCateg";
txtCateg.DisplayMember = "LibCateg";
txtEntite.DataSource = db.Entites.ToList();
txtEntite.ValueMember = "idEntite";
txtEntite.DisplayMember = "LibEntite";
if (this.idArrivee != 0)
{
Arrivee arr = db.Arrivee.FirstOrDefault(x => x.idArrivee == this.idArrivee);
txtDateOrdre.Value = arr.DateOrdre.Date;
txtNumCourrier.Text = arr.NumCourrier;
txtDateCourrier.Value = arr.DateCourrier.Value.Date;
txtSujet.Text = arr.Sujet;
txtRemarque.Text = arr.Remarques;
txtCateg.SelectedItem = arr.Categorie;
txtEntite.SelectedItem = arr.Entites;
txtTitre.Text = "Edtion Courrier N° : " + arr.NumOrdre;
// charger les pièces jointes de ce courrier
loadDataArriveesDocs();
dgvArriveeDocs.Columns["idArrivee"].Visible = false;
dgvArriveeDocs.Columns["idArriveeDocs"].Visible = false;
dgvArriveeDocs.ColumnHeadersVisible = false;
dgvArriveeDocs.RowHeadersVisible = false;
DataGridViewImageColumn btnDowload = new DataGridViewImageColumn();
btnDowload.Name = "btnDowload";
btnDowload.HeaderText = "";
btnDowload.Image = Properties.Resources.download3;
dgvArriveeDocs.Columns.Add(btnDowload);
DataGridViewImageColumn btnDelete = new DataGridViewImageColumn();
btnDelete.Name = "btnDelete";
btnDelete.HeaderText = "";
btnDelete.Image = Properties.Resources.delete1;
dgvArriveeDocs.Columns.Add(btnDelete);
dgvArriveeDocs.Columns["btnDowload"].DefaultCellStyle.Padding = new Padding(5, 5, 5, 5);
dgvArriveeDocs.Columns["btnDelete"].DefaultCellStyle.Padding = new Padding(5, 5, 5, 5);
dgvArriveeDocs.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells;
}
}
}
public static List <DepartViewModel> getListDeparts()
{
List <DepartViewModel> list = new List <DepartViewModel>();
using (DBGCourriesContext db = new DBGCourriesContext())
{
list = db.Depart.Select(
p => new DepartViewModel
{
ID = p.idDepart,
Categorie = p.Categorie.LibCateg,
Annee = p.Annee,
NumOrdre = p.NumOrdre,
DateOrdre = p.DateOrdre,
Sujet = p.Sujet,
Remarques = p.Remarques
}
).ToList();
}
return(list);
}
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();
}
}
private void btnEnregistrer_Click(object sender, EventArgs e)
{
using (DBGCourriesContext db = new DBGCourriesContext())
{
if (this.idArrivee != 0)
{
Arrivee ar = db.Arrivee.FirstOrDefault(x => x.idArrivee == this.idArrivee);
ar.NumCourrier = txtNumCourrier.Text;
ar.Sujet = txtSujet.Text;
ar.Remarques = txtRemarque.Text;
ar.DateCourrier = txtDateCourrier.Value.Date;
ar.DateOrdre = txtDateOrdre.Value.Date;
ar.Annee = txtDateOrdre.Value.Date.Year;
ar.idCateg = Convert.ToInt32(txtCateg.SelectedValue);
ar.idEntite = Convert.ToInt32(txtEntite.SelectedValue);
ar.idUser = 1;
db.SaveChanges();
this.Close();
frmList.loadData();
}
}
}
public static List <ArriveeViewModel> getListCourriesArrivees()
{
List <ArriveeViewModel> list = new List <ArriveeViewModel>();
using (DBGCourriesContext db = new DBGCourriesContext())
{
list = db.Arrivee.Select(
p => new ArriveeViewModel
{
idArrivee = p.idArrivee,
Categ = p.Categorie.LibCateg,
Entite = p.Entites.LibEntite,
Annee = p.Annee,
NumCourrier = p.NumCourrier,
DateOrdre = p.DateOrdre,
NumOrdre = p.NumOrdre,
DateCourrier = (DateTime)p.DateCourrier,
Sujet = p.Sujet,
Remarques = p.Remarques
}
).ToList();
}
return(list);
}
private void dataGridArrivee_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
string ColName = dataGridArrivee.Columns[e.ColumnIndex].Name;
DataGridViewRow row = dataGridArrivee.Rows[e.RowIndex];
row.Selected = true;
int idArriveeCur = Convert.ToInt32(row.Cells["ID"].Value);
string sujet = row.Cells["Sujet"].Value.ToString();
if (ColName == "btnPrint")
{
using (DBGCourriesContext db = new DBGCourriesContext())
{
List <ArriveeViewModel> lst = new List <ArriveeViewModel>();
lst = db.Arrivee.Select(
p => new ArriveeViewModel
{
idArrivee = p.idArrivee,
Categ = p.Categorie.LibCateg,
Entite = p.Entites.LibEntite,
Annee = p.Annee,
NumCourrier = p.NumCourrier,
DateOrdre = p.DateOrdre,
NumOrdre = p.NumOrdre,
DateCourrier = (DateTime)p.DateCourrier,
Sujet = p.Sujet,
Remarques = p.Remarques
}
).Where(x => x.idArrivee == idArriveeCur).ToList();
List <ArriveeDetailViewModel> listSupReport = new List <ArriveeDetailViewModel>();
listSupReport = db.Arrivee.FirstOrDefault(a => a.idArrivee == idArriveeCur).ArriveeDocs.Select(
p => new ArriveeDetailViewModel
{
idArrivee = p.idArrivee,
idArriveeDocs = p.idArriveeDocs,
typeDoc = p.TypeDocArrivee,
filename = p.FileName,
sizeFile = Math.Round((p.ContenuFileArrivee.Length / 1024f), 2) + " KB"
}
).ToList();
rptFicheCourrier fiche = new rptFicheCourrier();
fiche.SetDataSource(lst);
fiche.Subreports["FicheCourrierDetails.rpt"].SetDataSource(listSupReport);
frmPrintReport frm = new frmPrintReport();
frm.linkReport(fiche);
frm.ShowDialog();
}
}
if (ColName == "btnEdit")
{
dataGridArrivee_CellContentDoubleClick(sender, e);
}
if (ColName == "btnDelete")
{
DialogResult dr = MessageBox.Show("Voulez Vous vraiment supprimer ce courrier " + sujet,
"Confirmation de suppression ",
MessageBoxButtons.YesNo,
MessageBoxIcon.Warning
);
if (dr == DialogResult.Yes)
{
using (DBGCourriesContext db = new DBGCourriesContext())
{
Arrivee ar = db.Arrivee.FirstOrDefault(x => x.idArrivee == idArriveeCur);
db.Arrivee.Remove(ar);
db.SaveChanges();
loadData();
}
}
}
}
