private void AddExtremum(ExtremumDto extremum) { if (extremum == null) return; string sqlInsert = string.Format(extremum.InsertSql(), ExtremaEvaluationTable); using (var context = new EFDbContext()) { context.Database.ExecuteSqlCommand(sqlInsert); context.SaveChanges(); } }
public ExtremumDto ToDto() { var dto = new ExtremumDto { ExtremumId = this.ExtremumId, Symbol = this.Symbol, Type = (int)this.Type, PriceDate = this.PriceDate, EarlierCounter = this.EarlierCounter, EarlierAmplitude = this.EarlierAmplitude, EarlierChange1 = this.EarlierChange1, EarlierChange2 = this.EarlierChange2, EarlierChange3 = this.EarlierChange3, EarlierChange5 = this.EarlierChange5, EarlierChange10 = this.EarlierChange10, LaterCounter = this.LaterCounter, LaterAmplitude = this.LaterAmplitude, LaterChange1 = this.LaterChange1, LaterChange2 = this.LaterChange2, LaterChange3 = this.LaterChange3, LaterChange5 = this.LaterChange5, LaterChange10 = this.LaterChange10, Volatility = this.Volatility, IsOpen = this.IsOpen, Cancelled = this.Cancelled }; return dto; }
public void UpdateExtremum(ExtremumDto extremum) { if (extremum == null) return; string sql = string.Format(extremum.Cancelled ? extremum.RemoveSql() : extremum.UpdateSql(), ExtremaEvaluationTable); using (var context = new EFDbContext()) { context.Database.ExecuteSqlCommand(sql); context.SaveChanges(); } }
public static Extremum FromDto(ExtremumDto dto) { var extremum = new Extremum(); extremum.ExtremumId = dto.ExtremumId; extremum.Symbol = dto.Symbol; extremum.Type = (ExtremumType)dto.Type; extremum.PriceDate = dto.PriceDate; extremum.EarlierCounter = dto.EarlierCounter; extremum.EarlierAmplitude = dto.EarlierAmplitude; extremum.EarlierChange1 = dto.EarlierChange1; extremum.EarlierChange2 = dto.EarlierChange2; extremum.EarlierChange3 = dto.EarlierChange3; extremum.EarlierChange5 = dto.EarlierChange5; extremum.EarlierChange10 = dto.EarlierChange10; extremum.LaterCounter = dto.LaterCounter; extremum.LaterAmplitude = dto.LaterAmplitude; extremum.LaterChange1 = dto.LaterChange1; extremum.LaterChange2 = dto.LaterChange2; extremum.LaterChange3 = dto.LaterChange3; extremum.LaterChange5 = dto.LaterChange5; extremum.LaterChange10 = dto.LaterChange10; extremum.Volatility = dto.Volatility; extremum.IsOpen = dto.IsOpen; extremum.Cancelled = dto.Cancelled; return extremum; }