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