public CalculatedDataset GetCalculateddataset(int id)
{
CalculatedDataset calcSet;
using (DB2Entities db = new DB2Entities())
{
var tempSet = db.PythagorasValues.Where(p => p.DB1iD == id).FirstOrDefault();
if (tempSet != null)
{
calcSet = new CalculatedDataset()
{
Id = tempSet.Id,
DB1id = id,
Message = "Stored dataset fetched.",
ValueA = (float)tempSet.ValueA,
ValueB = (float)tempSet.ValueB,
ValueC = (float)tempSet.ValueC
};
return(calcSet);
}
else
{
return(null);
}
}
}
public void SaveCalculatedDataset(CalculatedDataset dataset)
{
using (DB2Entities db = new DB2Entities())
{
try
{
var pVal = new PythagorasValue()
{
DB1iD = dataset.DB1id,
ValueA = dataset.ValueA,
ValueB = dataset.ValueB,
ValueC = dataset.ValueC
};
db.PythagorasValues.Add(pVal);
db.SaveChanges();
// return true;
}
catch
{
var _error = new ErrorLog()
{
Timestamp = DateTime.UtcNow,
UserName = "******",
Email = "unKnown",
Action = "Saving dataset",
ErrorMessage = "Something went wrong with saving the dataset."
};
logError(_error);
//return false;
}
}
}
public static CalculatedDataset CalculateDataSet(int id)
{
var db1 = new DB1Repository();
var rawData = db1.GetDataSet(id);
if (rawData != null)
{
//var calculatedDataset = new WS2.CalculatedDataset();
var serviceClient = new WS2.Service2Client();
var calculatedDataset = serviceClient.GetCalculatedDataSet(rawData.Id, rawData.ValueA, rawData.ValueB, rawData.ValueC);
var returnSet = new CalculatedDataset()
{
Id = calculatedDataset.Id,
ValueA = calculatedDataset.ValueA,
ValueB = calculatedDataset.ValueB,
ValueC = calculatedDataset.ValueC,
Message = calculatedDataset.Message
};
return(returnSet);
}
else
{
throw new Exception("No row with that Id");
}
}
