public static List <TableRowViewModel> GetStockEntityPricesAroundDates_UI(int setID, int seID, DateTime startsOn, DateTime?endsOn, int daysBefore, int daysAfter)
{
var result = new List <TableRowViewModel>();
var isRange = endsOn != null;
var startsOnShortDateString = startsOn.ToShortDateString();
var endsOnShortDateString = isRange ? endsOn.Value.ToShortDateString() : "";
using (ArgaamAnalyticsDataContext aadc = new ArgaamAnalyticsDataContext())
{
var spResult = (aadc.SP_Q4_PricesAroundEventDate(startsOn, endsOn, daysBefore, daysAfter, seID, setID)).ToList();
var resultDates = (from r in spResult
group r by new { r.ForDate, r.DoW }
into grp
select new DateWithDoW
{
ForDate = grp.Key.ForDate.Value,
DoW = grp.Key.DoW
}).ToList();
var seName = FintechService.GetStockEntity(setID, seID).NameEn;
#region Compute EventDate Price or Last Valid price; Compute Fist and Last Valid Closing prices
bool eventDateClosingPriceWasZero = false;
decimal?eventDateClosingPrice = (from r in spResult
where r.seID == seID && r.setID == setID
select r.Close).Skip(daysBefore).Take(1).First();
DateTime closingPriceAltDate;
decimal? firstValidClosingPrice = 0.0M;
DateTime firstValidClosingPriceDate = DateTime.MinValue;
decimal? lastValidClosingPrice = 0.0M;
DateTime lastValidClosingPriceDate = DateTime.MinValue;
int firstValidPriceIndex = -1;
int lastValidPriceIndex = -1;
if (eventDateClosingPrice.Value == 0)
{
// Pick up the last closing value that was not 0
eventDateClosingPriceWasZero = true;
var a = (from r in spResult
where r.seID == seID && r.setID == setID &&
r.ForDate < startsOn &&
r.Close != 0
orderby r.ForDate descending
select new
{
r.ForDate,
r.Close
}).Take(1).First();
eventDateClosingPrice = a.Close;
closingPriceAltDate = a.ForDate.Value;
}
var b = (from r in spResult
where r.seID == seID && r.setID == setID &&
r.Close != 0
orderby r.ForDate
select new
{
r.ForDate,
r.Close
}).Take(1).First();
firstValidClosingPrice = b.Close;
firstValidClosingPriceDate = b.ForDate.Value;
var c = (from r in spResult
where r.seID == seID && r.setID == setID &&
r.Close != 0
orderby r.ForDate descending
select new
{
r.ForDate,
r.Close
}).Take(1).First();
lastValidClosingPrice = c.Close;
lastValidClosingPriceDate = c.ForDate.Value;
#endregion
#region Row 1 Header
TableRowViewModel row1 = new TableRowViewModel();
row1.TableCells.Add(new TableCellViewModel()
{
Text = "Dates / Entity"
});
int startsOnIndex = -1, endsOnIndex = -1;
int actualEventDatePriceIndex = -1;
for (int i = 0; i < resultDates.Count; i++)
{
var resultForDate = resultDates[i].ForDate;
var resultForDateShortDateString = resultForDate.ToShortDateString();
var cell = new TableCellViewModel()
{
Text = resultForDate.ToString("dd MM yyyy") + " " + resultDates[i].DoW
};
if (resultForDateShortDateString == startsOnShortDateString)
{
cell.BackgroundColor = "lightblue";
startsOnIndex = i;
}
else if (isRange)
{
if (resultForDate > startsOn && resultForDate < endsOn)
{
if (i == startsOnIndex + 1)
{
cell.Text = "...";
}
else
{
continue;
}
}
else if (resultForDateShortDateString == endsOnShortDateString)
{
cell.BackgroundColor = "lightblue";
endsOnIndex = i;
}
}
row1.TableCells.Add(cell);
}
result.Add(row1);
#endregion
List <StockEntityAndType> seArray = new List <StockEntityAndType>() /*
* {
* new StockEntityAndType() { StockEntityTypeID = 5, StockEntityID = 1 },
* new StockEntityAndType() { StockEntityTypeID = 5, StockEntityID = 3 }
* }*/;
seArray.Add(new StockEntityAndType()
{
StockEntityTypeID = setID, StockEntityID = seID
});
decimal beforeEventChange = 0.0M, afteEventChange = 0.0M;
#region Row 2 & 3 Brent & Crude
foreach (var se in seArray)
{
bool isCompany = false;
TableRowViewModel row = new TableRowViewModel();
if (se.StockEntityTypeID == 5 && se.StockEntityID == 1)
{
row.TableCells.Add(new TableCellViewModel()
{
Text = "BRENT"
});
}
else if (se.StockEntityTypeID == 5 && se.StockEntityID == 3)
{
row.TableCells.Add(new TableCellViewModel()
{
Text = "CRUDE"
});
}
else
{
row.TableCells.Add(new TableCellViewModel()
{
Text = seName
});
isCompany = true;
}
var filteredResults = spResult.Where(r => r.setID == se.StockEntityTypeID && r.seID == se.StockEntityID).ToList();
for (int i = 0; i < filteredResults.Count; i++)
{
var item = filteredResults[i];
var cell = new TableCellViewModel()
{
Text = item.Close == 0 ? "" : item.Close.ToString()
};
if (isCompany && firstValidPriceIndex == -1 && item.Close != 0)
{
firstValidPriceIndex = i;
}
if (isCompany && item.Close != 0)
{
lastValidPriceIndex = i;
}
if (i == startsOnIndex || i == endsOnIndex)
{
cell.BackgroundColor = "lightblue";
if (i == startsOnIndex && isCompany && eventDateClosingPriceWasZero)
{
int reverseIndex = i;
do
{
reverseIndex--;
if (filteredResults[reverseIndex].Close != 0)
{
break;
}
} while (true);
for (int j = reverseIndex; j < i; j++)
{
// J+1 cos the first cell is an info cell
row.TableCells[j + 1].BackgroundColor = "lightblue";
}
}
}
if (i > startsOnIndex && i < endsOnIndex)
{
if (i == startsOnIndex + 1)
{
cell.Text = "...";
}
else
{
continue;
}
}
row.TableCells.Add(cell);
}
result.Add(row);
}
#endregion
TableRowViewModel row4 = new TableRowViewModel();
row4.TableCells.Add(new TableCellViewModel());
//bool closingRange
for (int i = 0; i < resultDates.Count; i++)
{
TableCellViewModel cell = new TableCellViewModel();
if (i == firstValidPriceIndex)
{
var firstClosingPriceChangePercent = (((eventDateClosingPrice - firstValidClosingPrice) / firstValidClosingPrice) * 100);
cell.Text = firstClosingPriceChangePercent.Value.ToString("0.00") + "%";
cell.BackgroundColor = firstClosingPriceChangePercent >= 0 ? "lightgreen" : "red";
cell.FontColor = firstClosingPriceChangePercent >= 0 ? "" : "white";
cell.ColSpan = startsOnIndex - firstValidPriceIndex;
}
else if ((i > firstValidPriceIndex && i < startsOnIndex) ||
(((!isRange && i > startsOnIndex + 1) || (isRange && i > endsOnIndex + 1)) && i <= lastValidPriceIndex) ||
(isRange && i > startsOnIndex && i < endsOnIndex)
)
{
continue;
}
else if (i == startsOnIndex)
{
cell.BackgroundColor = "lightblue";
}
else if (isRange && i == endsOnIndex)
{
TableCellViewModel cellRange = new TableCellViewModel();
cellRange.Text = "...";
cell.BackgroundColor = cellRange.BackgroundColor = "lightblue";
row4.TableCells.Add(cellRange);
}
else if (((!isRange && i == startsOnIndex + 1) || (isRange && i == endsOnIndex + 1)) && i <= lastValidPriceIndex)
{
var lastClosingPriceChangePercent = (((lastValidClosingPrice - eventDateClosingPrice) / eventDateClosingPrice) * 100);
cell.Text = lastClosingPriceChangePercent.Value.ToString("0.00") + "%";
cell.BackgroundColor = lastClosingPriceChangePercent >= 0 ? "lightgreen" : "red";
cell.FontColor = lastClosingPriceChangePercent >= 0 ? "" : "white";
cell.ColSpan = lastValidPriceIndex - ((isRange) ? endsOnIndex : startsOnIndex);
}
row4.TableCells.Add(cell);
}
result.Add(row4);
}
return(result);
}
