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() { //Comment = "Kommentar kksksksksk", //Id = 59, OrderItemId = SelectedDetailed.OrderItemId, ReportDate = new DateTime(), Appendix = new List <OrderItemReportAppendix>() { new OrderItemReportAppendix() { //Id = 10, //OrderItemReportId = 50, Picture = ImageConverter.ImageToByteArray(new BitmapImage(new Uri(openFileDialog.FileName, UriKind.Absolute))) } } }; SelectedDetailed.OrderItemReports.Add(oir); Dp.AddOrderItemReport(oir); //if(Dp.AddOrderItemReport(oir)) // MessageBox.Show("Update erfolgreich!", "Info", MessageBoxButton.OK, MessageBoxImage.Information); //else // MessageBox.Show("Update fehlgeschlagen", "Fehler", MessageBoxButton.OK, MessageBoxImage.Error); 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); } } }
private int SendOrderItemReport() { DateTime FromDate = DateTime.Parse(GetFromDate); List<order_item_report> LocalOrderItemReports = QueryOrderItemReports(FromDate); OrderItemReport[] SendOrderItemReports = new OrderItemReport[LocalOrderItemReports.Count()]; for (int i = 0; i < SendOrderItemReports.Count(); i++) { OrderItemReport tmp = new OrderItemReport(); tmp.CreateDat = LocalOrderItemReports[i].createdat.ToString("dd.MM.yyyy HH:mm:ss", CultureInfo.InvariantCulture); tmp.Id = LocalOrderItemReports[i].Id.ToString(); tmp.OrderItemId = LocalOrderItemReports[i].order_item_id; tmp.ReportComment = LocalOrderItemReports[i].comment; SendOrderItemReports[i] = tmp; } return SyncClient.PutOrderItemReport(SendOrderItemReports, DateTimeNow, false); }
public void AddOrderItemReport(OrderItemReport NewReport) { dbContext = new DbServiceProviderAppEntities(); //Holen der maximalen Order_item_report_id: int NextId = (from oim in dbContext.order_item_report select oim.Id).Max() + 1; //Umwandeln des OrderItemReport in das DB-Objekt order_item_report DbNewReport = new order_item_report { report_date = NewReport.ReportDate, 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) { order_item_report_appendix DbOima = new order_item_report_appendix { order_item_report_id = DbNewReport.Id, appendix = oima.Picture }; dbContext.Set <order_item_report_appendix>().Add(DbOima); } //schreiben der Änderung in die spa_changes Tabelle dbContext.Set <spa_changes>().Add(new spa_changes { order_id = NewReport.OrderItemId, change_date = DateTime.Now }); UpdateDataBase(); }