public viewMolecularMass(string symbol)
: this()
{
this.Symbol = symbol;
using (dcFertilizer dc = new dcFertilizer(connectionString))
{
//dc.InstallDataBase();
Molecule mol = dc.GetMolecule(this.Symbol);
foreach (ElementMolecule e in mol.ElementMolecules)
{
this.Elements.Add(new mmElement
{
Quantity = e.Quantity ?? 0,
MolecularMass = e.MolecularMass ?? 0,
Symbol = e.Element.Symbol ?? "",
PercentWeight = mol.MolecularPercentage(e.Element.Symbol)
});
}
}
}
private static void ImportData(dcFertilizer dc)
{
LINQtoCSV.CsvContext con = new LINQtoCSV.CsvContext();
List<csvElemet> csvElems = con.Read<csvElemet>(@"C:\LittleApps\Fertilizer\Fertilizer\Data\Elements.csv").ToList();
List<Element> elements = csvElems.Select(e => new Element
{
AtomicMass = e.Atomic_Weight,
AtomicNumber = e.AtomicNumber,
Symbol = e.Symbol
}).ToList();
dc.Elements.InsertAllOnSubmit(elements);
dc.SubmitChanges();
}
