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;
}
