public void Insert(K2DataObjects.CurveValue inCurveValue, bool allowUpdate)
{
try
{
using (K2DataObjects.DataContext db = new K2DataObjects.DataContext(_connectString))
{
var dbCurveVals =
(from cv in db.CurveValues
where cv.Mnemonic == inCurveValue.Mnemonic &&
cv.ItemType == inCurveValue.ItemType &&
cv.ItemSize == inCurveValue.ItemSize &&
cv.TimeStamp == inCurveValue.TimeStamp &&
cv.RequestID == inCurveValue.RequestID &&
cv.HeaderID == inCurveValue.HeaderID
select cv).SingleOrDefault();
if (dbCurveVals != null)
{
if (allowUpdate)
{
db.CurveValues.DeleteOnSubmit(dbCurveVals);
db.SubmitChanges();
}
else
{
throw new Exception("bar exists");
}
}
db.CurveValues.InsertOnSubmit(inCurveValue);
db.SubmitChanges();
}
}
catch (Exception myE)
{
m_Log.Error("Insert", myE);
}
}
public void Insert(K2DataObjects.PriceBar inBar, bool allowUpdate)
{
try
{
using (K2DataObjects.DataContext db = new K2DataObjects.DataContext(_connectString))
{
var dbPriceBars =
(from bar in db.PriceBars
where bar.Mnemonic == inBar.Mnemonic &&
bar.ItemType == inBar.ItemType &&
bar.ItemSize == inBar.ItemSize &&
bar.TimeStamp == inBar.TimeStamp &&
bar.RequestID == inBar.RequestID
select bar).SingleOrDefault();
if (dbPriceBars != null)
{
if (allowUpdate)
{
db.PriceBars.DeleteOnSubmit(dbPriceBars);
db.SubmitChanges();
}
else
{
throw new Exception("bar exists");
}
}
db.PriceBars.InsertOnSubmit(inBar);
db.SubmitChanges();
}
}
catch (Exception myE)
{
m_Log.Error("Insert", myE);
}
}