public List <MacroDatabaseKeyAnnualReportData> RetrieveMacroDatabaseKeyAnnualReportDataEMSummary(String countryNameVal, List <String> countryValues)
{
try
{
/*bool isServiceUp;
* isServiceUp = CheckServiceAvailability.ServiceAvailability();
* if (!isServiceUp)
* {
* throw new Exception();
* }*/
List <MacroDatabaseKeyAnnualReportData> result = new List <MacroDatabaseKeyAnnualReportData>();
List <MacroDatabaseKeyAnnualReportData> finalResult = new List <MacroDatabaseKeyAnnualReportData>();
DimensionEntities entity = DimensionEntity;
ResearchEntities research = new ResearchEntities();
foreach (String c in countryValues)
{
result = research.ExecuteStoreQuery <MacroDatabaseKeyAnnualReportData>
("exec RetrieveEMSummaryDataReportPerCountry @country={0}", c).ToList();
if (result != null && result.Count != 0)
{
foreach (MacroDatabaseKeyAnnualReportData r in result)
{
finalResult.Add(r);
}
}
}
if (finalResult.Count == 0 || finalResult == null)
{
return(finalResult);
}
return(finalResult);
}
catch (Exception ex)
{
ExceptionTrace.LogException(ex);
string networkFaultMessage = ServiceFaultResourceManager.GetString("NetworkFault").ToString();
throw new FaultException <ServiceFault>(new ServiceFault(networkFaultMessage), new FaultReason(ex.Message));
}
}
public List <MacroDatabaseKeyAnnualReportData> RetrieveMacroDatabaseKeyAnnualReportData(String countryNameVal)
{
try
{
/* bool isServiceUp;
* isServiceUp = CheckServiceAvailability.ServiceAvailability();
* if (!isServiceUp)
* {
* throw new Exception();
* }*/
List <MacroDatabaseKeyAnnualReportData> result = new List <MacroDatabaseKeyAnnualReportData>();
DimensionEntities entity = DimensionEntity;
ResearchEntities research = new ResearchEntities();
result = research.ExecuteStoreQuery <MacroDatabaseKeyAnnualReportData>
("exec RetrieveCTYSUMMARYDataReportPerCountry @country={0}", countryNameVal).ToList();
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));
}
}
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));
}
}