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