/// <summary> /// Initializes a new instance of the MainViewModel class. /// </summary> public DetailVm() { CultureInfo.DefaultThreadCurrentCulture = new CultureInfo("de-DE"); CultureInfo.DefaultThreadCurrentUICulture = new CultureInfo("de-DE"); msg.Register <GenericMessage <OrderSummary> >(this, ChangeSelected); AllStatuses = new string[] { "Abgeschlossen", "Angenommen", "Nicht bestätigt", "Auftrag ablehnen" }; SelectedJob = new OrderSummary(); OS = new DetailedClass(); Dp = new Dataprovider(); BtnSyncWithBackend = new RelayCommand(() => StartSync()); MyClassInitialize(); BtnApplyChanges = new RelayCommand(() => ApplyChanges()); BtnCreateReport = new RelayCommand(() => CreateReport()); BtnAppendDocuments = new RelayCommand(() => AppendDocuments()); //CreateDemoData(); }
public DetailVm() { CultureInfo.DefaultThreadCurrentCulture = new CultureInfo("de-DE"); CultureInfo.DefaultThreadCurrentUICulture = new CultureInfo("de-DE"); msg.Register<GenericMessage<OrderSummary>>(this, ChangeSelected); AllStatuses = new string[] { "Abgeschlossen", "Angenommen", "Nicht bestätigt", "Auftrag ablehnen" }; SelectedJob = new OrderSummary(); OS = new DetailedClass(); Dp = new Dataprovider(); BtnApplyChanges = new RelayCommand(() => ApplyChanges()); BtnCreateReport = new RelayCommand(() => CreateReport()); BtnAppendDocuments = new RelayCommand(() => AppendDocuments()); BtnAddPicture = new RelayCommand<OrderItemReport_>( (p) => { OpenFileDialog openFileDialog = new OpenFileDialog { Title = "Select a picture", Filter = "Image files (*.jpg, *.jpeg, *.jpe, *.jfif, *.png) | *.jpg; *.jpeg; *.jpe; *.jfif; *.png" }; if ((bool)openFileDialog.ShowDialog()) { int i = 0; foreach (var item in SelectedDetailed.OrderItemReports) { item.Visibility = "Collapsed"; if (p == item) { SelectedDetailed.OrderItemReports[i].Appendix.Add(new OrderItemReportAppendix() { OrderItemReportId = item.Id , Picture = ImageConverter.ImageToByteArray(new BitmapImage(new Uri(openFileDialog.FileName, UriKind.Absolute))) }); item.Visibility = "Visible"; //TODO: Does it work? RaisePropertyChanged(nameof(SelectedDetailed)); } RaisePropertyChanged(nameof(item.Visibility)); i++; } } }); CreateDateTime("4:45"); //CreateDemoData(); }
//Updated Änderungen am Detailitem public bool UpdateOrderItemData(DetailedClass DetailToUpdate) { dbContext = new DbServiceProviderAppEntities(); //Auswerten des Order_item aus der DB order_item OriginalOrderItem = (from oi in dbContext.order_item where oi.Id == DetailToUpdate.OrderItemId select oi).FirstOrDefault(); //changed from first() to firstordefault() //order_item OriginalOrderItem = new order_item(); if (OriginalOrderItem != null) { //Änderungsfähige Daten übernehmen OriginalOrderItem.addittional_cost = DetailToUpdate.AddittionalCost; OriginalOrderItem.final_price = DetailToUpdate.Finalprice; OriginalOrderItem.is_all_inclusive = DetailToUpdate.IsAllInclusive; OriginalOrderItem.is_confirmed = DetailToUpdate.IsConfirmed; OriginalOrderItem.is_finished = DetailToUpdate.IsFinished; OriginalOrderItem.preferred_date_time = DetailToUpdate.PreferedDate; OriginalOrderItem.service_provider_comment = DetailToUpdate.ServiceProviderComment; OriginalOrderItem.final_price_without_tax = OriginalOrderItem.final_price / 1.2; //Falls der Final_Price geändert wurde OriginalOrderItem.final_price_with_tax = OriginalOrderItem.final_price; //Falls der Final_Price geändert wurde OriginalOrderItem.tax = OriginalOrderItem.final_price_with_tax - OriginalOrderItem.final_price_without_tax; OriginalOrderItem.per_item_tax = OriginalOrderItem.tax / OriginalOrderItem.quantity; OriginalOrderItem.createdAt = DateTime.Now; //schreiben der Änderung in die spa_changes Tabelle spa_changes chng = new spa_changes(); chng.order_id = OriginalOrderItem.Id; chng.change_date = DateTime.Now; dbContext.Set <spa_changes>().Add(chng); //Änderungen speichern dbContext.SaveChanges(); return(true); } else { return(false); } }
public DetailedClass QueryDetailView(long OrderItemId) { dbContext = new DbServiceProviderAppEntities(); var query = (from od in dbContext.order_detail join oi in dbContext.order_item on od.order_id equals oi.order_id join sv in dbContext.service on oi.service_id equals sv.Id join oh in dbContext.order_header on od.order_id equals oh.Id join cr in dbContext.sow_user on oh.sow_user_id equals cr.Id where oi.Id == OrderItemId select new { od, oi, sv, oh, cr }) .AsEnumerable() .Select(x => new DetailedClass() { CustomerId = x.cr.Id, Firstname = x.od.first_name, Lastname = x.od.last_name, Address = String.Format("{0} {1}", x.od.address_1, x.od.address_2), Zip = x.od.zip, City = x.od.city, Phone = x.od.phone_2, Email = x.cr.email, OrderItemId = x.oi.Id, PreferedDate = x.oi.preferred_date_time, Servicedescription = x.sv.name, BookedItems = x.oi.quantity, IsAllInclusive = x.oi.is_all_inclusive, Finalprice = x.oi.final_price, OrderedDateTime = x.oi.createdAt, CustomerNotice = x.oh.customer_note, IsFinished = x.oi.is_finished, OrderId = x.oi.order_id, IsConfirmed = x.oi.is_confirmed, AddittionalCost = x.oi.addittional_cost, ServiceProviderComment = x.oi.service_provider_comment, ServiceUnit = x.sv.service_unit }); DetailedClass RetVal = query.Single(); // Holen der Order_Item_Reports zum Order_Item var queryReport = from oim in dbContext.order_item_report where oim.order_item_id == OrderItemId select new OrderItemReport { Id = oim.Id, Comment = oim.comment, ReportDate = oim.report_date }; List <OrderItemReport> OIM = queryReport.ToList(); // Holen der Order_Item_Report_Appendix zu allen Order_Item_Reports for (int i = 0; i < OIM.Count; i++) { int OrderITemReportId = OIM[i].Id; var queryAppendix = from oima in dbContext.order_item_report_appendix where oima.order_item_report_id == OrderITemReportId select new OrderItemReportAppendix { Id = oima.Id, OrderItemReportId = oima.order_item_report_id, Picture = oima.appendix }; List <OrderItemReportAppendix> OIMA = queryAppendix.ToList(); OIM[i].Appendix = OIMA; } RetVal.OrderItemReports = OIM; return(RetVal); }