private List <CalculationDto> MapData(DataTable table)
{
var calculations = new List <CalculationDto>();
foreach (DataRow row in table.Rows)
{
var organisatie = new CalculationDto()
{
Id = row[0] as int? ?? default(int),
A = row[1] as int? ?? default(int),
B = row[2] as int? ?? default(int),
Sum = row[3] as int?,
DateCreated = row[4] as DateTime? ?? default(DateTime),
DateProcessed = row[5] as DateTime? ?? null
};
calculations.Add(organisatie);
}
return(calculations);
}
public ActionResult Calculation(CalculationDto data)
{
data.HolidaysDate = new List <DateTime>();
var holidayList = _context.Holiday.Where(x => x.CountryId == data.CountryId).AsNoTracking().ToList();
foreach (var i in holidayList)
{
data.HolidaysDate.Add(Convert.ToDateTime(i.Date));
}
var enums = new List <string>();
foreach (var i in _context.WorkDay.Where(x => x.CountryId == data.CountryId).AsNoTracking().ToList())
{
enums.Add(i.Day);
}
var ofDay1 = enums[0];
var ofDay2 = enums[1];
var getDays = DaysCalculation.GetDays(data.DeliveryDate, data.ReturnedDate, data.HolidaysDate, data.CountryId, ofDay1, ofDay2);
return(Json(new { data = getDays }, JsonRequestBehavior.AllowGet));
}
public void Start()
{
const string queryString = "SELECT [ID],[Name],[WKN],[Multiplier],[StrikePrice],[Underlying],[InitialSL],[InitialTP],[PricePerUnit],[OrderCosts],[Description],[Units],[IsLong] FROM [dbo].[Calculations] ORDER BY [ID] ASC";
const string countString = "SELECT COUNT([ID]) AS COUNT FROM [dbo].[Calculations]";
const string connectionString = "Server=.;Database=TransactionManagement;User Id=stocktrading;Password=stocktrading;";
//Load from db
using (var connection = new SqlConnection(connectionString))
{
connection.Open();
using (var command = new SqlCommand(countString, connection))
{
var count = (int)command.ExecuteScalar();
LoggingService.Info($" ({count})");
}
using (var command = new SqlCommand(queryString, connection))
{
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
var item = new CalculationDto();
item.OldId = int.Parse(reader["ID"].ToString());
item.Name = reader["Name"].ToString();
item.Wkn = reader["WKN"].ToString();
item.Multiplier = decimal.Parse(reader["Multiplier"].ToString());
item.StrikePrice = decimal.Parse(reader["StrikePrice"].ToString());
item.Underlying = reader["Underlying"].ToString();
item.InitialSl = decimal.Parse(reader["InitialSL"].ToString());
item.InitialTp = decimal.Parse(reader["InitialTP"].ToString());
item.PricePerUnit = decimal.Parse(reader["PricePerUnit"].ToString());
item.OrderCosts = decimal.Parse(reader["OrderCosts"].ToString());
item.Description = reader["Description"].ToString();
item.Units = decimal.Parse(reader["Units"].ToString());
item.IsLong = bool.Parse(reader["IsLong"].ToString());
Items.Add(item.OldId, item);
}
}
}
}
//Import
foreach (var item in Items)
{
var cmd = new CalculationAddCommand(
item.Value.Id,
-1,
item.Value.Name,
item.Value.Wkn,
item.Value.Multiplier,
item.Value.StrikePrice,
item.Value.Underlying,
item.Value.InitialSl,
item.Value.InitialTp,
item.Value.PricePerUnit,
item.Value.OrderCosts,
item.Value.Description,
item.Value.Units,
item.Value.IsLong);
CommandDispatcher.Execute(cmd);
LoggingService.Info($"Calculation {item.Value.Name} ({item.Value.OldId})");
}
}
