public List <FXCommodityData> RetrieveCommoditySelectionData()
{
// use cache if available
var fromCache = (List <FXCommodityData>) new DefaultCacheProvider().Get(CacheKeyNames.FXCommodityDataCache);
if (fromCache != null)
{
return(fromCache);
}
// otherwise fetch the data and cache it
List <FXCommodityData> result = new List <FXCommodityData>();
ResearchEntities research = new ResearchEntities();
List <COMMODITY_FORECASTS> commodityData = new List <COMMODITY_FORECASTS>();
commodityData = research.COMMODITY_FORECASTS.ToList();
for (int i = 0; i < commodityData.Count; i++)
{
FXCommodityData data = new FXCommodityData();
data.CommodityId = commodityData[i].COMMODITY_ID;
result.Add(data);
}
result.Add(new FXCommodityData {
CommodityId = GreenfieldConstants.COMMODITY_ALL
});
new DefaultCacheProvider().Set(CacheKeyNames.FXCommodityDataCache, result, Int32.Parse(ConfigurationManager.AppSettings["CacheTime"]));
return(result);
}
/// <summary>
/// To perform calculations on commodity data
/// </summary>
/// <param name="commodityData"></param>
/// <returns></returns>
public static FXCommodityData CalculateCommodityData(List <FXCommodityData> commodityData, DateTime Date1DayBack, DateTime DateLastYearEnd, DateTime Date12MonthsAgo, DateTime Date36MonthsAgo)
{
decimal?GPToday = null;
decimal?GPLastYearEnd = null;
decimal?GP12MonthsAgo = null;
decimal?GP36MonthsAgo = null;
//DateTime CurrentDate = System.DateTime.Now;
//DateTime Date1DayBack = GetPreviousDate(CurrentDate);
//DateTime DateLastYearEnd = CurrentDate.AddYears(-1).AddMonths(-(CurrentDate.Month) + 12).AddDays(-(CurrentDate.Day) + 31);
//DateLastYearEnd = CheckBusinessDay(DateLastYearEnd);
//DateTime Date12MonthsAgo = CurrentDate.AddYears(-1);
//Date12MonthsAgo = CheckBusinessDay(Date12MonthsAgo);
//DateTime Date36MonthsAgo = CurrentDate.AddYears(-3);
//Date36MonthsAgo = CheckBusinessDay(Date36MonthsAgo);
FXCommodityData result = new FXCommodityData();
foreach (FXCommodityData item in commodityData)
{
if (item.FromDate == Date1DayBack)
{
GPToday = item.DailyClosingPrice;
}
if (item.FromDate == DateLastYearEnd)
{
GPLastYearEnd = item.DailyClosingPrice;
}
if (item.FromDate == Date12MonthsAgo)
{
GP12MonthsAgo = item.DailyClosingPrice;
}
if (item.FromDate == Date36MonthsAgo)
{
GP36MonthsAgo = item.DailyClosingPrice;
}
result.CommodityId = item.CommodityId;
}
if (GPToday != null && GPLastYearEnd != null)
{
result.YTD = (GPToday - GPLastYearEnd) / GPLastYearEnd * 100;
}
if (GPToday != null && GP12MonthsAgo != null)
{
result.Year1 = (GPToday - GP12MonthsAgo) / GP12MonthsAgo * 100;
}
if (GPToday != null && GP36MonthsAgo != null)
{
result.Year3 = (GPToday - GP36MonthsAgo) / GP36MonthsAgo * 100;
}
return(result);
}
public List <FXCommodityData> RetrieveCommodityData(string selectedCommodityID)
{
try
{
/* bool isServiceUp;
* isServiceUp = CheckServiceAvailability.ServiceAvailability();
*
* if (!isServiceUp)
* throw new Exception();*/
List <CommodityResult> resultDB = new List <CommodityResult>();
List <FXCommodityData> calculatedViewResult = new List <FXCommodityData>();
List <FXCommodityData> result = new List <FXCommodityData>();
ResearchEntities research = new ResearchEntities();
DimensionEntities entity = DimensionEntity;
List <GreenField.DAL.GF_PRICING_BASEVIEW> dimSvcPricingViewData = null;
List <GreenField.DAL.GF_SELECTION_BASEVIEW> dimSvcSelectionViewData = null;
if (entity.GF_SELECTION_BASEVIEW == null && entity.GF_SELECTION_BASEVIEW.Count() == 0)
{
return(null);
}
if (entity.GF_PRICING_BASEVIEW == null && entity.GF_PRICING_BASEVIEW.Count() == 0)
{
return(null);
}
//Retrieving data from database
if (String.IsNullOrEmpty(selectedCommodityID))
{
selectedCommodityID = GreenfieldConstants.COMMODITY_ALL;
resultDB = research.ExecuteStoreQuery <CommodityResult>("exec GetCOMMODITY_FORECASTS @commodityID={0}", selectedCommodityID).ToList();
}
else
{
resultDB = research.ExecuteStoreQuery <CommodityResult>("exec GetCOMMODITY_FORECASTS @commodityID={0}", selectedCommodityID).ToList();
}
//Retrieving Data from Views
DateTime CurrentDate = System.DateTime.Now;
DateTime Date1DayBack = Convert.ToDateTime(FXCommodityCalculations.GetPreviousDate(CurrentDate));
DateTime DateLastYearEnd = CurrentDate.AddYears(-1).AddMonths(-(CurrentDate.Month) + 12).AddDays(-(CurrentDate.Day) + 31);
DateLastYearEnd = Convert.ToDateTime(FXCommodityCalculations.CheckBusinessDay(DateLastYearEnd));
DateTime Date12MonthsAgo = CurrentDate.AddYears(-1);
Date12MonthsAgo = Convert.ToDateTime(FXCommodityCalculations.CheckBusinessDay(Date12MonthsAgo));
DateTime Date36MonthsAgo = CurrentDate.AddYears(-3);
Date36MonthsAgo = Convert.ToDateTime(FXCommodityCalculations.CheckBusinessDay(Date36MonthsAgo));
if (selectedCommodityID != null && selectedCommodityID != string.Empty)
{
if (selectedCommodityID.ToUpper() != GreenfieldConstants.COMMODITY_ALL)
{
dimSvcSelectionViewData = entity.GF_SELECTION_BASEVIEW
.Where(g => (g.AIMS_COMMODITY_ID != null) && (g.AIMS_COMMODITY_ID.ToUpper() == selectedCommodityID.ToUpper()))
.ToList();
}
else
{
dimSvcSelectionViewData = entity.GF_SELECTION_BASEVIEW
.Where(g => g.AIMS_COMMODITY_ID != null)
.ToList();
}
}
if (dimSvcSelectionViewData != null && dimSvcSelectionViewData.Count > 0)
{
List <GreenField.DAL.GF_PRICING_BASEVIEW> queryResultSet = new List <GreenField.DAL.GF_PRICING_BASEVIEW>();
Expression <Func <GreenField.DAL.GF_PRICING_BASEVIEW, bool> > searchPredicate1 = p => p.FROMDATE == Convert.ToDateTime(Date1DayBack.ToString()).Date;
searchPredicate1 = Utility.Or <GreenField.DAL.GF_PRICING_BASEVIEW>(searchPredicate1, g => g.FROMDATE == Convert.ToDateTime(DateLastYearEnd.ToString()).Date);
searchPredicate1 = Utility.Or <GreenField.DAL.GF_PRICING_BASEVIEW>(searchPredicate1, g => g.FROMDATE == Convert.ToDateTime(Date12MonthsAgo.ToString()).Date);
searchPredicate1 = Utility.Or <GreenField.DAL.GF_PRICING_BASEVIEW>(searchPredicate1, g => g.FROMDATE == Convert.ToDateTime(Date36MonthsAgo.ToString()).Date);
int recursionLimit = 10;
for (int j = 0; j < dimSvcSelectionViewData.Count(); j = j + recursionLimit)
{
Expression <Func <GreenField.DAL.GF_PRICING_BASEVIEW, bool> > searchPredicate2 = p => p.INSTRUMENT_ID.ToUpper() == dimSvcSelectionViewData[j].INSTRUMENT_ID.ToUpper();
for (int i = j + 1; i < j + recursionLimit && i < dimSvcSelectionViewData.Count(); i++)
{
if (dimSvcSelectionViewData[i].INSTRUMENT_ID == null)
{
continue;
}
string comparisonInstrumentId = dimSvcSelectionViewData[i].INSTRUMENT_ID.ToUpper();
searchPredicate2 = Utility.Or <GreenField.DAL.GF_PRICING_BASEVIEW>(searchPredicate2, p => p.INSTRUMENT_ID.ToUpper() == comparisonInstrumentId);
}
Expression <Func <GreenField.DAL.GF_PRICING_BASEVIEW, bool> > searchPredicate = Utility.And <GreenField.DAL.GF_PRICING_BASEVIEW>(searchPredicate1, searchPredicate2);
queryResultSet.AddRange(entity.GF_PRICING_BASEVIEW.Where(searchPredicate));
}
foreach (GreenField.DAL.GF_SELECTION_BASEVIEW item in dimSvcSelectionViewData)
{
if (item.INSTRUMENT_ID != null && item.INSTRUMENT_ID != string.Empty)
{
dimSvcPricingViewData = queryResultSet.Where(g => (g.INSTRUMENT_ID.ToUpper() == item.INSTRUMENT_ID.ToUpper())).ToList();
if (dimSvcPricingViewData != null && dimSvcPricingViewData.Count > 0)
{
List <FXCommodityData> resultView = new List <FXCommodityData>();
foreach (GreenField.DAL.GF_PRICING_BASEVIEW itemPricing in dimSvcPricingViewData)
{
FXCommodityData data = new FXCommodityData();
// Assigning Commodity ID from above list
data.CommodityId = item.AIMS_COMMODITY_ID;
data.FromDate = itemPricing.FROMDATE;
data.DailyClosingPrice = itemPricing.DAILY_CLOSING_PRICE;
//Assigning Instrument Id from above list
data.InstrumentId = item.INSTRUMENT_ID;
resultView.Add(data);
}
FXCommodityData calculatedData = new FXCommodityData();
//calling method to perform calculations
FXCommodityData calculatedDataForCommodity = FXCommodityCalculations.CalculateCommodityData(resultView, Date1DayBack.Date, DateLastYearEnd.Date, Date12MonthsAgo.Date, Date36MonthsAgo.Date);
calculatedData.CommodityId = calculatedDataForCommodity.CommodityId;
calculatedData.InstrumentId = calculatedDataForCommodity.InstrumentId;
calculatedData.YTD = calculatedDataForCommodity.YTD;
calculatedData.Year1 = calculatedDataForCommodity.Year1;
calculatedData.Year3 = calculatedDataForCommodity.Year3;
calculatedViewResult.Add(calculatedData);
}
}
}
}
for (int _index = 0; _index < resultDB.Count; _index++)
{
foreach (FXCommodityData item in calculatedViewResult)
{
if (resultDB[_index].COMMODITY_ID == item.CommodityId)
{
FXCommodityData commodityData = new FXCommodityData();
commodityData.CommodityId = resultDB[_index].COMMODITY_ID;
//Columns coming from Commodity table
commodityData.CurrentYearEnd = Convert.ToDecimal(resultDB[_index].CURRENT_YEAR_END);
commodityData.LongTerm = Convert.ToDecimal(resultDB[_index].LONG_TERM);
commodityData.NextYearEnd = Convert.ToDecimal(resultDB[_index].NEXT_YEAR_END);
//Columns coming from Pricing View
commodityData.YTD = item.YTD;
commodityData.Year1 = item.Year1;
commodityData.Year3 = item.Year3;
result.Add(commodityData);
}
}
}
return(result);
}
catch (Exception ex)
{
ExceptionTrace.LogException(ex);
string networkFaultMessage = ServiceFaultResourceManager.GetString("NetworkFault").ToString();
throw new FaultException <ServiceFault>(new ServiceFault(networkFaultMessage), new FaultReason(ex.Message));
}
}
