static public void InsertTradeLog(Trade TradeObject) { try { AlsiDBDataContext dc = new AlsiDBDataContext(); dc.Connection.ConnectionString = AlsiUtils.Data_Objects.GlobalObjects.CustomConnectionString; TradeLog l = new TradeLog { Time = TradeObject.TimeStamp, BuySell = TradeObject.BuyorSell.ToString(), Reason = TradeObject.Reason.ToString(), Notes = TradeObject.IndicatorNotes.ToString(), Price = (int)TradeObject.TradedPrice, Volume = TradeObject.TradeVolume, ForeColor = TradeObject.ForeColor.ToKnownColor().ToString(), BackColor = TradeObject.BackColor.ToKnownColor().ToString() }; dc.TradeLogs.InsertOnSubmit(l); dc.SubmitChanges(); } catch (Exception ex) { Debug.WriteLine("Cannot write Log"); Debug.WriteLine(ex.Message); } }
partial void UpdateTradeLog(TradeLog instance);
partial void DeleteTradeLog(TradeLog instance);
partial void InsertTradeLog(TradeLog instance);