private void btnAdaugareInterventie_Click(object sender, RoutedEventArgs e) { try { Interventie interventie = new Interventie(); interventie = _construireInterventie(interventie); if (interventie.data_primire > interventie.data_finalizare) { throw new System.ArgumentException("Data de finalizare trebuie sa fie mai mare decat data de primire", "original"); } db.Interventie.Add(interventie); db.SaveChanges(); var servicii = db.Interventie_Serviciu.Where(x => x.id_interventie == null).ToList(); foreach (var serviciu in servicii) { Interventie_Serviciu serviciudb = db.Interventie_Serviciu.Where(x => x.id_int_serv == serviciu.id_int_serv).FirstOrDefault(); serviciudb.id_interventie = interventie.id_interventie; db.Interventie_Serviciu.AddOrUpdate(); db.SaveChanges(); } this.NavigationService.Navigate(new ListaInterventii()); } catch { MessageBox.Show("Intervenția nu a putut fi adăugată în baza de date."); } }
private void btnModifica_Click(object sender, RoutedEventArgs e) { interventieSelectat = lvInterventii.SelectedItem as Interventie; if (interventieSelectat != null) { this.NavigationService.Navigate(new FormularInterventie(interventieSelectat)); } }
private void _afisareInterventie(Interventie interventie) { cbClient.SelectedValue = interventie.id_client; cbMasina.SelectedValue = interventie.id_masina; dpDataPrimire.SelectedDate = interventie.data_primire; dpDataFinalizare.SelectedDate = interventie.data_finalizare; cbStatus.SelectedValue = interventie.status; lvServicii.ItemsSource = db.Interventie_Serviciu.Where(x => x.id_interventie == interventie.id_interventie).ToList(); }
private Interventie _construireInterventie(Interventie interventie) { interventie.id_client = int.Parse(cbClient.SelectedValue.ToString()); interventie.id_masina = int.Parse(cbMasina.SelectedValue.ToString()); interventie.data_primire = dpDataPrimire.SelectedDate; interventie.data_finalizare = dpDataFinalizare.SelectedDate; interventie.status = int.Parse(cbStatus.SelectedValue.ToString()); return(interventie); }
public Interventie GetInterventie(int id) { this.conn.Open(); SqlCommand cmd = new SqlCommand("SELECT * FROM Interventii WHERE ID = @id", conn); cmd.Parameters.AddWithValue("@id", id); using (SqlDataReader reader = cmd.ExecuteReader()) { reader.Read(); var interventie = new Interventie(reader, conn); return(interventie); } }
public IActionResult UpdateInterventie(int id, [FromBody] Interventie interventie) { SqlCommand cmd = new SqlCommand("UPDATE Interventii SET Descriere = @descriere, Data = @data, Nume=@nume, Pret = @pret, ConsultatieID = @consultatieID WHERE ID = @id ", conn); cmd.Parameters.AddWithValue("@id", id); cmd.Parameters.AddWithValue("@nume", interventie.Nume); cmd.Parameters.AddWithValue("@descriere", interventie.Descriere); cmd.Parameters.AddWithValue("@data", interventie.Data); cmd.Parameters.AddWithValue("@pret", interventie.Pret); cmd.Parameters.AddWithValue("@consultatieID", interventie.ConsultatieID); conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); return(Ok()); }
public List <Interventie> GetInterventii() { this.conn.Open(); SqlCommand cmd = new SqlCommand("SELECT * FROM Interventii", conn); using (SqlDataReader reader = cmd.ExecuteReader()) { List <Interventie> interventii = new List <Interventie>(); while (reader.Read()) { Interventie p = new Interventie(reader, conn); interventii.Add(p); } return(interventii); } }
private void btnModificareInterventie_Click(object sender, RoutedEventArgs e) { try { Interventie interventie = db.Interventie.Where(x => x.id_interventie == interventieSelectat.id_interventie).FirstOrDefault(); interventie = _construireInterventie(interventie); if (interventie.data_primire > interventie.data_finalizare) { throw new System.ArgumentException("Data de finalizare trebuie sa fie mai mare decat data de primire", "original"); } db.Interventie.AddOrUpdate(interventie); db.SaveChanges(); this.NavigationService.Navigate(new ListaInterventii()); } catch { MessageBox.Show("Intervenția nu a putut fi modificată din baza de date."); } }
public FormularInterventie(Interventie interventieSelectat = null) { InitializeComponent(); cbClient.ItemsSource = db.Client.ToList(); cbServiciu.ItemsSource = db.Serviciu.ToList(); cbAngajat.ItemsSource = db.Angajat.ToList(); if (interventieSelectat != null) { this.interventieSelectat = interventieSelectat; _afisareInterventie(interventieSelectat); btnAdaugareInterventie.Visibility = Visibility.Collapsed; } else { btnModificareInterventie.Visibility = Visibility.Collapsed; } }
public IActionResult CreateInterventie([FromBody] Interventie interventie) { if (!ModelState.IsValid) { return(BadRequest()); } SqlCommand cmd = new SqlCommand("INSERT INTO Interventii VALUES (@nume, @descriere, @data, @pret, @consultatieID)", conn); cmd.Parameters.AddWithValue("@nume", interventie.Nume); cmd.Parameters.AddWithValue("@descriere", interventie.Descriere); cmd.Parameters.AddWithValue("@data", interventie.Data); cmd.Parameters.AddWithValue("@pret", interventie.Pret); cmd.Parameters.AddWithValue("@consultatieID", interventie.ConsultatieID); this.conn.Open(); cmd.ExecuteNonQuery(); this.conn.Close(); return(Ok()); }
private void btnFactura_Click(object sender, RoutedEventArgs e) { _interventieSlectata = lvInterventii.SelectedItem as Interventie; if (_interventieSlectata != null) { try { var adresa = "Aleea Magnoliei, Nr 2"; var email = "*****@*****.**"; double?total = 0; var data = DateTime.UtcNow; var listaServicii = _interventieSlectata.Interventie_Serviciu.ToList(); var numarFactura = _interventieSlectata.id_interventie; string docName = "factura-" + numarFactura.ToString() + ".pdf"; //Create Doc Document doc = new Document(iTextSharp.text.PageSize.LETTER, 10, 10, 42, 35); PdfWriter wri = PdfWriter.GetInstance(doc, new FileStream(docName, FileMode.Create)); doc.Open(); //Title iTextSharp.text.Paragraph paragraph = new iTextSharp.text.Paragraph("Service Auto SRL"); paragraph.Alignment = Element.ALIGN_CENTER; doc.Add(paragraph); doc.Add(new iTextSharp.text.Paragraph("\n")); LineSeparator line1 = new LineSeparator(1f, 100f, BaseColor.BLACK, Element.ALIGN_LEFT, 1); doc.Add(line1); iTextSharp.text.Paragraph paragraph2 = new iTextSharp.text.Paragraph("Factura Nr: " + numarFactura.ToString()); paragraph2.Alignment = Element.ALIGN_CENTER; doc.Add(paragraph2); doc.Add(new iTextSharp.text.Paragraph("\n")); doc.Add(line1); //Date Firma doc.Add(new iTextSharp.text.Paragraph("\n")); doc.Add(new iTextSharp.text.Paragraph(" Interventie: " + _interventieSlectata.id_interventie + "\n Client: " + _interventieSlectata.Client.nume + "\n Adresa: " + adresa + "\n Email: " + email + "\n Data: " + data)); //Creare Tabel Servicii doc.Add(new iTextSharp.text.Paragraph("\n \n")); PdfPTable table = new PdfPTable(4); table.AddCell("Serviciu"); table.AddCell("Descriere"); table.AddCell("Durata Medie"); table.AddCell("Pret"); PdfPCell cell = new PdfPCell(new Phrase("Cell Text", new Font(Font.FontFamily.HELVETICA, 8f, Font.BOLD, BaseColor.BLACK))); cell.BackgroundColor = new BaseColor(0, 150, 0); foreach (var s in listaServicii) { table.AddCell(s.Serviciu.denumire); table.AddCell(s.Serviciu.descriere); table.AddCell(s.Serviciu.durata_medie.ToString()); table.AddCell(s.pret.ToString() + " lei"); total = total + s.pret; } table.AddCell(""); table.AddCell(""); table.AddCell("Total: "); table.AddCell(total.ToString() + " lei"); doc.Add(table); doc.Close(); System.Diagnostics.Process.Start(docName); //Modificare in baza de date _interventieSlectata.status = 1; _interventieSlectata.data_finalizare = DateTime.UtcNow; db.Interventie.AddOrUpdate(_interventieSlectata); db.SaveChanges(); //Refres this.NavigationService.Navigate(new ListaInterventii()); } catch { MessageBox.Show("A intervenit o problema in generarea facturii"); } } else { MessageBox.Show("Mai intai va rog sa selectati o interventie activa"); } }