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