void RetrieveData()
{
string element = ckElement.Checked == true ? cbElement1.Text : null;
var query =
(from m in new CElement_wavelengthFactory().GetAll()
from n in new CElementFactory().GetAll().Where(x => x.Idelement == m.Idelement)
where (element == null || n.Cod_element == element)
select new
{
m.Idelement,
n.Cod_element,
m.Idelement_wavelength,
m.Element_wavelength,
m.Wavelength,
m.Idl_axial,
m.Idl_radial,
m.Lineality_axial,
m.Lineality_radial
});
DataTable queryIcp = new ModIcp().GetElements(element);
var queryIcpElement =
(from p in queryIcp.AsEnumerable()
join q in new CElementFactory().GetAll() on p.Field <string>("elementSymbol") equals q.Cod_element
select new
{
Wavelength = p.Field <string>("wavelength"),
elementSymbol = q.Cod_element,
Idelement = q.Idelement,
Element_wavelength = p.Field <string>("ElementName"),
Idl_radial = SetValueView(p.Field <int>("Radial")),
Idl_axial = SetValueView(p.Field <int>("Axial")),
Lineality_radial = SetValueView(p.Field <int>("Radial")),
Lineality_axial = SetValueView(p.Field <int>("Axial"))
}).ToList();
List <CElement_wavelength> lst =
(from t in queryIcpElement
join p in query on t.Wavelength equals p.Wavelength into tp
from q in tp.DefaultIfEmpty()
select new CElement_wavelength
{
Idelement_wavelength = q == null ? 0 : q.Idelement_wavelength,
Idelement = t.Idelement,
Wavelength = t.Wavelength,
Element_wavelength = t.Element_wavelength,
Idl_radial = q == null ? t.Idl_radial : q.Idl_radial,
Idl_axial = q == null ? t.Idl_axial : q.Idl_axial,
Lineality_radial = q == null ? t.Lineality_radial : q.Lineality_radial,
Lineality_axial = q == null ? t.Lineality_axial : q.Lineality_axial
}).ToList();
gcElemWavelength.DataSource = new BindingList <CElement_wavelength>(lst);
SaveData();
}
private void cbElement1_EditValueChanged(object sender, EventArgs e)
{
if (cbElement1.EditValue != null)
{
//conectar con icp según filtro de elemento
ModIcp modIcp = new ModIcp();
DataTable dtElements = modIcp.GetElements(cbElement1.Text);
RetrieveData();
}
}
private void cbElement1_EditValueChanged(object sender, EventArgs e)
{
if (cbElement1.EditValue != null)
{
//conectar con icp según filtro de elemento
ModIcp modIcp = new ModIcp();
DataTable dtElements = modIcp.GetElements(cbElement1.Text);
RetrieveData();
}
}
void RetrieveData()
{
string element = ckElement.Checked == true ? cbElement1.Text : null;
var query =
(from m in new CElement_wavelengthFactory().GetAll()
from n in new CElementFactory().GetAll().Where(x => x.Idelement == m.Idelement)
where (element == null || n.Cod_element == element)
select new
{
m.Idelement,
n.Cod_element,
m.Idelement_wavelength,
m.Element_wavelength,
m.Wavelength,
m.Idl_axial,
m.Idl_radial,
m.Lineality_axial,
m.Lineality_radial
});
DataTable queryIcp = new ModIcp().GetElements(element);
var queryIcpElement =
(from p in queryIcp.AsEnumerable()
join q in new CElementFactory().GetAll() on p.Field<string>("elementSymbol") equals q.Cod_element
select new
{
Wavelength = p.Field<string>("wavelength"),
elementSymbol = q.Cod_element,
Idelement = q.Idelement,
Element_wavelength = p.Field<string>("ElementName"),
Idl_radial = SetValueView(p.Field<int>("Radial")),
Idl_axial = SetValueView(p.Field<int>("Axial")),
Lineality_radial = SetValueView(p.Field<int>("Radial")),
Lineality_axial = SetValueView(p.Field<int>("Axial"))
}).ToList();
List<CElement_wavelength> lst =
(from t in queryIcpElement
join p in query on t.Wavelength equals p.Wavelength into tp
from q in tp.DefaultIfEmpty()
select new CElement_wavelength
{
Idelement_wavelength = q == null ? 0 : q.Idelement_wavelength,
Idelement = t.Idelement,
Wavelength = t.Wavelength,
Element_wavelength = t.Element_wavelength,
Idl_radial = q == null ? t.Idl_radial : q.Idl_radial,
Idl_axial = q == null ? t.Idl_axial : q.Idl_axial,
Lineality_radial = q == null ? t.Lineality_radial : q.Lineality_radial,
Lineality_axial = q == null ? t.Lineality_axial : q.Lineality_axial
}).ToList();
gcElemWavelength.DataSource = new BindingList<CElement_wavelength>(lst);
SaveData();
}
