private void CreateReport() { int CurrentMaxOrderItemReportId = 0; foreach (var item in SelectedDetailed.OrderItemReports) { if (item.OrderItemId > CurrentMaxOrderItemReportId) CurrentMaxOrderItemReportId = item.OrderItemId; } CreateReportDialog reportDialog = new CreateReportDialog(CurrentMaxOrderItemReportId + 1, OrderItemId); if (reportDialog.ShowDialog() == true) { OrderItemReport_ CreatedReport = reportDialog.Answer; OrderItemReports.Add(CreatedReport); Dp.AddOrderItemReport(CreatedReport); RaisePropertyChanged(nameof(SelectedDetailed.OrderItemReports)); } }
public void AddOrderItemReport(OrderItemReport_ NewReport) { dbContext = new DbServiceProviderAppEntities(); //Holen der maximalen Order_item_report_id: Guid NextId = Guid.NewGuid(); //Umwandeln des OrderItemReport in das DB-Objekt order_item_report DbNewReport = new order_item_report { createdat = DateTime.Now, order_item_id = NewReport.OrderItemId, comment = NewReport.Comment, Id = NextId }; dbContext.Set <order_item_report>().Add(DbNewReport); dbContext.SaveChanges(); //Umwandeln der OrderItemReportAppendix in die DB-Objekte foreach (OrderItemReportAppendix oima in NewReport.Appendix) { Guid AppendixId = Guid.NewGuid(); order_item_report_appendix DbOima = new order_item_report_appendix { Id = AppendixId, createdat = DateTime.Now, order_item_report_id = DbNewReport.Id, appendix = oima.Picture }; dbContext.Set <order_item_report_appendix>().Add(DbOima); } UpdateDataBase(); StartSynchronisation(); }
private void AppendDocuments() { OpenFileDialog openFileDialog = new OpenFileDialog { Title = "Select a picture", Filter = "Image files (*.jpg, *.jpeg, *.jpe, *.jfif, *.png) | *.jpg; *.jpeg; *.jpe; *.jfif; *.png" }; ; if (openFileDialog.ShowDialog() == true) { try { OrderItemReport_ oir = new OrderItemReport_() { OrderItemId = SelectedDetailed.OrderItemId, ReportDate = new DateTime(), Appendix = new List<OrderItemReportAppendix>() { new OrderItemReportAppendix() { Picture = ImageConverter.ImageToByteArray(new BitmapImage(new Uri(openFileDialog.FileName, UriKind.Absolute))) } } }; SelectedDetailed.OrderItemReports.Add(oir); Dp.AddOrderItemReport(oir); if (Dp.UpdateOrderItemData(SelectedDetailed)) MessageBox.Show("Update erfolgreich!", "Info", MessageBoxButton.OK, MessageBoxImage.Information); else MessageBox.Show("Update fehlgeschlagen", "Fehler", MessageBoxButton.OK, MessageBoxImage.Error); } catch (Exception e) { MessageBox.Show("Laden des Bildes fehlgeschlagen!\n" + e.Message, "Fehler", MessageBoxButton.OK, MessageBoxImage.Error); } } }