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