public string AddMoleculesFromExcel(List <MoleculeData> molecules)
{
string result = "";
try
{
foreach (var item in molecules)
{
if (!string.IsNullOrEmpty(item.Name))
{
try
{
DbAccess.AddLocation(item.Location);
DbAccess.AddMoleculeStatic(item.Name, item.CAS, item.Mvalue, item.dvalue, item.mpvalue, item.bpvalue, item.purity);
DbAccess.ConnectLocationMoleculestatic(item.CAS, item.Location, item.mvalue, item.Vvalue);
}
catch (Exception e)
{
_logger.Write(this, e.InnerException.InnerException.Message, "fatal");
throw new Exception(item.Name);
}
}
}
result = "Done";
}
catch (Exception e)
{
result = e.Message;
}
return(result);
}
public async Task <string> AddMolecule(SelectedMolecule molecule)
{
string result = "";
try
{
await Task.Run(() =>
{
DbAccess.AddLocation(molecule.Location);
DbAccess.AddMoleculeStatic(molecule.Name, molecule.CAS, molecule.MW, molecule.Den, molecule.mpValue, molecule.bpValue, molecule.Purity);
DbAccess.ConnectLocationMoleculestatic(molecule.CAS, molecule.Location, molecule.mAvailable, molecule.VAvailable);
result = "Done";
});
} catch (Exception e)
{
throw e;
}
return(result);
}
