void ChangeDimension(object obj) { ((dimensions.ViewModel.SurfaceDimensionsViewModel)surfaceDimensionsView.DataContext).CurDimension = RefDimensions.refDimension.Where(x => x.id == refDimensions).SingleOrDefault(); dll.resdictionary.View.DialogView window = new dll.resdictionary.View.DialogView(surfaceDimensionsView); if (window.ShowDialog() == true) { using (SqlConnection con = new SqlConnection(GValues.connString)) { con.Open(); using (SqlCommand command = new SqlCommand()) { command.Connection = con; command.CommandText = " UPDATE item SET" + " ref_dimensions = @ref_dimensions " + " WHERE id = @id; "; command.Parameters.Add("id", SqlDbType.Int).Value = id; command.Parameters.Add("ref_dimensions", SqlDbType.Int).Value = ((dimensions.ViewModel.SurfaceDimensionsViewModel)surfaceDimensionsView.DataContext).CurDimension.id; command.ExecuteNonQuery(); } } refDimensions = ((dimensions.ViewModel.SurfaceDimensionsViewModel)surfaceDimensionsView.DataContext).CurDimension.id; dll.utilites.OReferences.RefItem.GetInstance.reload(); } }
void SetRecipientOnClick(object obj) { dialogView = new dll.resdictionary.View.DialogView(unitExternalView); if (dialogView.ShowDialog() == true) { foreach (dll.utilites.OReferences.RefRecipient.Recipient items in ((references.orgmodel.ViewModel.UnitExternalViewModel)(unitExternalView.DataContext)).GetSelectedItems()) { Document.recipient = items; OnPropertyChanged("RecipientName"); } } }
void SetCountertypeOnClick(object obj) { dialogView = new dll.resdictionary.View.DialogView(counterpartyExternalView); if (dialogView.ShowDialog() == true) { foreach (dll.utilites.OReferences.RefCounterParty.Counterparty items in ((references.counterparty.ViewModel.CounterpartyExternalViewModel)(counterpartyExternalView.DataContext)).GetSelectedItems()) { //Document.counterpaty = items; OnPropertyChanged("CounterpartyName"); } } }
void SetCountertypeOnClick(object obj) { List <decimal> selectedCounterparty = new List <decimal>(); selectedCounterparty.Add(Doc.counterpaty.id); (counterpartyExternalView.DataContext as references.counterparty.ViewModel.CounterpartyExternalViewModel) .PresetData(selectedCounterparty, false); dialogView = new dll.resdictionary.View.DialogView(counterpartyExternalView); dialogView.Owner = Application.Current.MainWindow; dialogView.Header = "Поставщик"; if (dialogView.ShowDialog() == true) { dll.utilites.OReferences.RefCounterParty.Counterparty counterparty = ((references.counterparty.ViewModel.CounterpartyExternalViewModel)(counterpartyExternalView.DataContext)).CurCounterparty.Item; using (SqlConnection con = new SqlConnection(GValues.connString)) { con.Open(); using (SqlCommand command = new SqlCommand()) { command.Connection = con; command.CommandText = " UPDATE document SET xfrom = @xfrom" + " WHERE id = @id"; command.Parameters.Add("xfrom", SqlDbType.Decimal).Value = counterparty.id; command.Parameters.Add("id", SqlDbType.Decimal).Value = Doc.id; command.ExecuteNonQuery(); } } Doc.counterpaty = counterparty; counterparty = null; OnPropertyChanged("CounterpartyName"); } }
void SetRecipientOnClick(object obj) { List <decimal> selectedRecipient = new List <decimal>(); selectedRecipient.Add(Doc.recipient.id); (unitExternalView.DataContext as references.orgmodel.ViewModel.UnitExternalViewModel) .PresetData(selectedRecipient, false); dialogView = new dll.resdictionary.View.DialogView(unitExternalView); dialogView.Owner = Application.Current.MainWindow; dialogView.Header = "Получатель"; if (dialogView.ShowDialog() == true) { dll.utilites.OReferences.RefRecipient.Recipient recipient = ((references.orgmodel.ViewModel.UnitExternalViewModel)(unitExternalView.DataContext)).CurRecipient.Item; using (SqlConnection con = new SqlConnection(GValues.connString)) { con.Open(); using (SqlCommand command = new SqlCommand()) { command.Connection = con; command.CommandText = " UPDATE document SET xto = @xto" + " WHERE id = @id"; command.Parameters.Add("xto", SqlDbType.Decimal).Value = recipient.id; command.Parameters.Add("id", SqlDbType.Decimal).Value = Doc.id; command.ExecuteNonQuery(); } } Doc.recipient = recipient; recipient = null; OnPropertyChanged("RecipientName"); } }