public List <Dataset> GetDataSets()
{
var pInfo = new List <Dataset>();
try
{
using (DB1Entities1 db = new DB1Entities1())
{
var values = db.PythagorasValues.ToList();
foreach (var val in values)
{
pInfo.Add(new Dataset()
{
Id = val.Id,
ValueA = val.ValueA,
ValueB = val.ValueB,
ValueC = val.ValueC
});
}
}
return(pInfo);
}
catch (Exception ex)
{
throw new FaultException(ex.Message, new FaultCode("02 Data-fault"));
}
}
public bool SavedataSet(Models.PythagorasValue pythagorasValue)
{
using (DB1Entities1 db = new DB1Entities1())
{
db.PythagorasValues.Add(pythagorasValue);
db.SaveChanges();
}
return(true);
}
public void logError(ErrorLog message)
{
try
{
using (DB1Entities1 db = new DB1Entities1())
{
db.ErrorLogs.Add(message);
db.SaveChanges();
}
}
catch (Exception ex)
{
throw new FaultException(ex.Message, new FaultCode("02 Data-fault"));
}
}
public Models.PythagorasValue GetDataSet(int id)
{
var pInfo = new Models.PythagorasValue();
try
{
using (DB1Entities1 db = new DB1Entities1())
{
pInfo = db.PythagorasValues.Where(p => p.Id == id).FirstOrDefault();
}
return(pInfo);
}
catch (Exception ex)
{
throw new FaultException(ex.Message, new FaultCode("02 Data-fault"));
}
}
public CompanyInfo GetCompanyInfo(int cvrNumber)
{
var cInfo = new CompanyInfo();
try
{
using (DB1Entities1 db = new DB1Entities1())
{
cInfo = db.CvrValues.Where(ci => ci.CvrNumber == cvrNumber).Select(ci => new CompanyInfo()
{
CvrNumber = ci.CvrNumber, Name = ci.OrganizationName
}).First();
}
return(cInfo);
}
catch (Exception ex)
{
throw new FaultException(ex.Message, new FaultCode("01 CVR-fault"));
}
}
