private void RemplirDgvPrestations() { int joursRestants; DtPrestations = new DataTable(); DtPrestations.Columns.Add(new DataColumn("IdPresta", Type.GetType("System.Int32") ?? throw new InvalidOperationException())); DtPrestations.Columns.Add("Interimaire"); DtPrestations.Columns.Add("Entreprise"); DtPrestations.Columns.Add("Travail"); DtPrestations.Columns.Add("DateDebut"); DtPrestations.Columns.Add("DateFin"); DtPrestations.Columns.Add("JourRestant"); DtPrestations.Columns.Add("Facture"); DtPrestations.Columns.Add("Status"); foreach (var prestation in Prestations) { C_t_facture facture = Factures.Find(x => x.id_fact == prestation.id_fact); C_t_categorie travail = Travails.Find(x => x.id_categ == prestation.id_categ); C_t_interimeur interimaire = Interimaires.Find(x => x.id_inte == facture.id_inte); C_t_entreprise entreprise = Entreprises.Find(x => x.id_entre == facture.id_entre); //MessageBox.Show(entreprise.nom_entre); joursRestants = Convert.ToInt32((prestation.date_fin - DateTime.Today).TotalDays); if (joursRestants < 0) { joursRestants = 0; } DtPrestations.Rows.Add(prestation.Id_travail, interimaire.nom_inte, entreprise.nom_entre, travail.nom_categ, prestation.date_debut.ToString("dd-MM-yyyy"), prestation.date_fin.ToString("dd-MM-yyyy"), joursRestants, facture.date_fact, (prestation.date_fin > DateTime.Today) ? "En Cours" : "Terminer"); } BsPrestations = new BindingSource { DataSource = DtPrestations }; dgvPrestations.DataSource = BsPrestations; }
private void btnConfirmer_Click_1(object sender, EventArgs e) { if (string.IsNullOrEmpty(tbId.Text)) { if (string.IsNullOrEmpty(tbNomPresta.Text) || string.IsNullOrEmpty(tbSalPresta.Text)) { MessageBox.Show(@"Please fill all require information"); } else // ajouter dans la base de donnees { //try //{ //MessageBox.Show(cbCategorie.SelectedItem.ToString()+" - "+cbFacture.SelectedItem.ToString() ); //foreach (var f in Factures) // MessageBox.Show(f.id_fact.ToString()+" "+f.date_fact.ToString()); C_t_categorie categorie = Categories.Find(x => x.nom_categ == cbCategorie.SelectedItem.ToString()); C_t_facture facture = Factures.Find(x => x.date_fact.ToString("dd/MM/yyyy") == cbFacture.SelectedItem.ToString()); //MessageBox.Show(facture.id_fact.ToString() + " - " + categorie.id_categ.ToString()); //MessageBox.Show(facture.id_fact.ToString()); new G_t_travail(SChonn).Ajouter(tbNomPresta.Text, double.Parse(tbSalPresta.Text), dtpStart.Value, dtpEnd.Value, categorie.id_categ, facture.id_fact); //} //catch (Exception ex){ MessageBox.Show(ex.Message);} //finally { RemplireDgv(); } } } else // modification de la base de donnees { var nId = int.Parse(tbId.Text); //foreach (var f in Factures) // MessageBox.Show(f.date_fact.ToString("dd/MM/yyyy") +"->"+ cbFacture.Text); C_t_categorie categorie = Categories.Find(x => x.nom_categ == cbCategorie.Text); C_t_facture facture = Factures.Find(x => x.date_fact.ToString("dd/MM/yyyy") == cbFacture.Text); MessageBox.Show(categorie.nom_categ + " " + facture.date_fact.ToString("dd/MM/yyyy")); new G_t_travail(SChonn).Modifier(nId, tbNomPresta.Text, Convert.ToDouble(tbSalPresta.Text), dtpStart.Value, dtpEnd.Value, categorie.id_categ, facture.id_fact); dgvPrestation.SelectedRows[0].Cells["NomTravail"].Value = tbNomPresta.Text; dgvPrestation.SelectedRows[0].Cells["DtDebut"].Value = dtpStart.Text; dgvPrestation.SelectedRows[0].Cells["DtFin"].Value = dtpEnd.Text; dgvPrestation.SelectedRows[0].Cells["SalTravail"].Value = tbSalPresta.Text; dgvPrestation.SelectedRows[0].Cells["IdCateg"].Value = cbCategorie.SelectedItem; dgvPrestation.SelectedRows[0].Cells["IdFact"].Value = cbFacture.Text; dgvPrestation.EndEdit(); Activer(true); } RefreshDgv(); ClearTb(); }
public C_t_facture Lire_ID(int id_fact) { CreerCommande("Selectionnert_facture_ID"); Commande.Parameters.AddWithValue("@id_fact", id_fact); Commande.Connection.Open(); SqlDataReader dr = Commande.ExecuteReader(); C_t_facture res = new C_t_facture(); while (dr.Read()) { res.id_fact = int.Parse(dr["id_fact"].ToString()); res.date_fact = DateTime.Parse(dr["date_fact"].ToString()); res.id_inte = int.Parse(dr["id_inte"].ToString()); res.id_entre = int.Parse(dr["id_entre"].ToString()); } dr.Close(); Commande.Connection.Close(); return(res); }
public List <C_t_facture> Lire(string Index) { CreerCommande("Selectionnert_facture"); Commande.Parameters.AddWithValue("@Index", Index); Commande.Connection.Open(); SqlDataReader dr = Commande.ExecuteReader(); List <C_t_facture> res = new List <C_t_facture>(); while (dr.Read()) { C_t_facture tmp = new C_t_facture(); tmp.id_fact = int.Parse(dr["id_fact"].ToString()); tmp.date_fact = DateTime.Parse(dr["date_fact"].ToString()); tmp.id_inte = int.Parse(dr["id_inte"].ToString()); tmp.id_entre = int.Parse(dr["id_entre"].ToString()); res.Add(tmp); } dr.Close(); Commande.Connection.Close(); return(res); }
private void btnEditer_Click_1(object sender, EventArgs e) { if (dgvPrestation.SelectedRows.Count > 0) { Activer(false); tbId.Text = dgvPrestation.SelectedRows[0].Cells["IdPresta"].Value.ToString(); var travail = new G_t_travail(SChonn).Lire_ID(int.Parse(tbId.Text)); tbNomPresta.Text = travail.nom_travail; tbSalPresta.Text = Convert.ToString(travail.prix_travail, CultureInfo.InvariantCulture); dtpStart.Text = Convert.ToString(travail.date_debut, CultureInfo.CurrentCulture); dtpEnd.Text = Convert.ToString(travail.date_fin, CultureInfo.CurrentCulture); C_t_categorie categorie = Categories.Find(x => x.id_categ == travail.id_categ); C_t_facture facture = Factures.Find(x => x.id_fact == travail.id_fact); cbCategorie.Text = categorie.nom_categ; cbFacture.Text = facture.date_fact.ToString("dd/MM/yyyy"); } else { MessageBox.Show(@"There is no row selected!"); } }
private void RemplireDgv() { _info.CurrencySymbol = " € "; DtPrestation = new DataTable(); DtPrestation.Columns.Add(new DataColumn("IdPresta", Type.GetType("System.Int32") ?? throw new InvalidOperationException())); DtPrestation.Columns.Add("NomTravail"); DtPrestation.Columns.Add("DtDebut"); DtPrestation.Columns.Add("DtFin"); DtPrestation.Columns.Add("SalTravail"); DtPrestation.Columns.Add("IdCateg"); DtPrestation.Columns.Add("IdFact"); foreach (var prestation in Prestations) { C_t_categorie categorie = Categories.Find(x => x.id_categ == prestation.id_categ); C_t_facture facture = Factures.Find(x => x.id_fact == prestation.id_fact); //MessageBox.Show(facture.id_fact.ToString() + "->" + prestation.Id_travail); DtPrestation.Rows.Add(prestation.Id_travail, prestation.nom_travail, string.Format("{0:dd/MM/yyyy}", prestation.date_debut), string.Format("{0:dd/MM/yyyy}", prestation.date_fin), string.Format(_info, "{0:C}", prestation.prix_travail), categorie.nom_categ, string.Format("{0:dd/MM/yyyy}", facture.date_fact)); } BsPrestation = new BindingSource { DataSource = DtPrestation }; dgvPrestation.DataSource = BsPrestation; }
private void btnCA_Click(object sender, EventArgs e) { float total = 0f; float amount = 0f; if (dgvFacture.Rows.Count > 0) { Document doc = new Document(PageSize.LETTER, 40, 40, 30, 25); PdfWriter pw = PdfWriter.GetInstance(doc, new FileStream(@"E:\C#\InterimDesktopApp\Doc\CAM12mois.pdf", FileMode.Create)); doc.Open();// opening the pdf to write in Image logo = Image.GetInstance(@"E:\C#\InterimDesktopApp\Images\circle.png"); Paragraph logo_name = new Paragraph("Circle", small_font); Paragraph date = new Paragraph("Le" + " " + DateTime.Today.ToString("dd/MM/yyyy"), date_font); Paragraph title = new Paragraph("Chiffres d'affaire mensuel", header_font); Paragraph newLine = new Paragraph("\n"); logo.ScalePercent(10.0f); logo.Alignment = 0;// 0 = left; 1=center ; 2=right logo.Alignment = 0; date.Alignment = 2; title.Alignment = 1; doc.Add(logo); doc.Add(logo_name); doc.Add(date); doc.Add(title); doc.Add(newLine); PdfPTable table_prestation = new PdfPTable(2); PdfPCell title_table = new PdfPCell(new Phrase("Chiffres d'affaires", normal_font)); title_table.Colspan = 2; title_table.BackgroundColor = BaseColor.ORANGE; title_table.HorizontalAlignment = 1; PdfPCell col_prestation = new PdfPCell(new Phrase("Nom Prestation", normal_font)); PdfPCell col_Amount = new PdfPCell(new Phrase("Prix", normal_font)); PdfPCell description_total = new PdfPCell(new Phrase("Total")); col_prestation.HorizontalAlignment = 1; col_Amount.HorizontalAlignment = 1; table_prestation.AddCell(title_table); table_prestation.AddCell(col_prestation); table_prestation.AddCell(col_Amount); for (int i = 0; i < dgvFacture.RowCount - 1; i++) { var nId = Convert.ToInt32(dgvFacture.Rows[i].Cells[0].Value); C_t_facture facture = Factures.Find(x => x.id_fact == (int)nId); C_t_travail prestation = Prestations.Find(x => x.id_fact == facture.id_fact); C_t_categorie categorie = Categories.Find(x => x.id_categ == prestation.id_categ); C_t_interimeur interimeur = Interimeurs.Find(x => x.specialisation == categorie.nom_categ); MessageBox.Show(categorie.nom_categ + "=>" + interimeur.nom_inte); amount = (float)prestation.prix_travail + (float)((prestation.prix_travail * interimeur.bonus_sal) / 100); total += amount; PdfPCell cell_prestation = new PdfPCell(new Phrase(prestation.nom_travail, normal_font)); table_prestation.AddCell(cell_prestation); table_prestation.AddCell(amount + "€"); } doc.Add(newLine); table_prestation.AddCell(description_total); table_prestation.AddCell(total.ToString() + "€"); doc.Add(table_prestation); total = 0f; doc.Close(); //closing the pdf } else { MessageBox.Show("Vous n'avez pas de facture dans votre base de données"); } }