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