private void Window_Loaded(object sender, RoutedEventArgs e)
{
if (ActionData != Actions.Edit)
{
newPanelData = new Data.QuotationsData.Panel()
{
Source = QuotationData.PowerVoltage,
Frequency = QuotationData.Frequency,
Busbar = QuotationData.TinPlating,
NeutralSize = QuotationData.NeutralSize,
EarthSize = QuotationData.EarthSize,
EarthingSystem = QuotationData.EarthingSystem,
QuotationId = QuotationData.Id,
};
}
else
{
newPanelData = new Data.QuotationsData.Panel();
newPanelData.Update(PanelData);
}
using (SqlConnection connection = new SqlConnection(Database.ConnectionString))
{
EnclosureType.ItemsSource = connection.Query("Select EnclosureType From [Quotation].[_Panels] Where EnclosureType Is Not Null Group By EnclosureType");
EnclosureMetalType.ItemsSource = connection.Query("Select EnclosureMetalType From [Quotation].[_Panels] Where EnclosureMetalType Is Not Null Group By EnclosureMetalType ");
EnclosureColor.ItemsSource = connection.Query("Select EnclosureColor From [Quotation].[_Panels] Where EnclosureColor Is Not Null Group By EnclosureColor");
EnclosureIP.ItemsSource = connection.Query("Select EnclosureIP From [Quotation].[_Panels] Where EnclosureIP Is Not Null Group By EnclosureIP");
EnclosureForm.ItemsSource = connection.Query("Select EnclosureForm From [Quotation].[_Panels] Where EnclosureForm Is Not Null Group By EnclosureForm ");
EnclosureFunctional.ItemsSource = connection.Query("Select EnclosureFunctional From [Quotation].[_Panels] Where EnclosureFunctional Is Not Null Group By EnclosureFunctional");
EnclosureDoor.ItemsSource = connection.Query("Select EnclosureDoor From [Quotation].[_Panels] Where EnclosureDoor Is Not Null Group By EnclosureDoor");
Source.ItemsSource = connection.Query("Select Source From [Quotation].[_Panels] Where Source Is Not Null Group By Source");
}
DataContext = new { newPanelData };
}
public PanelsInformation(Data.QuotationsData.Panel panel)
{
InitializeComponent();
PanelData = panel;
DataContext = PanelData;
}
