private OracleObject LoadOracleObject(bool limitResults, string key, int companyId, DateTime startDate, DateTime endDate, IOracleRepository oRep, int runId)
{
//var todayYear = DateTime.Today.Year;
//var todayMonth = DateTime.Today.Month;
//var todayDay = DateTime.Today.Day;
//var yesterdayYear = GetYesterdayYear(todayYear, todayMonth, todayDay);
//var yesterdayDay = 0;
//var yesterdayMonth = GetYesterdayMonth(todayYear, todayMonth, todayDay, yesterdayYear, out yesterdayDay);
//var tomorrowYear = DateTime.Today.AddDays(1).Year;
//var tomorrowMonth = DateTime.Today.AddDays(1).Month;
////var tomorrowDay = GetTomorrowDay(tomorrowYear, tomorrowMonth, todayDay);
//var tomorrowDay = GetTomorrowDay(todayYear, todayMonth, todayDay);
//var yesterday = new DateTime(yesterdayYear, yesterdayMonth, yesterdayDay);
//var tomorrow = new DateTime(tomorrowYear, tomorrowMonth, tomorrowDay);
//if (!string.IsNullOrEmpty(date) && date.Length == 10) {
// todayMonth = int.Parse(date.Substring(0, 2));
// todayDay = int.Parse(date.Substring(3, 2));
// todayYear = int.Parse(date.Substring(6));
// var today = new DateTime(todayYear, todayMonth, todayDay);
// yesterdayYear = GetYesterdayYear(todayYear, todayMonth, todayDay);
// yesterdayDay = 0;
// yesterdayMonth = GetYesterdayMonth(todayYear, todayMonth, todayDay, yesterdayYear, out yesterdayDay);
// tomorrowYear = today.AddDays(1).Year;
// tomorrowMonth = today.AddDays(1).Month;
// tomorrowDay = GetTomorrowDay(todayYear, todayMonth, todayDay);
// yesterday = new DateTime(yesterdayYear, yesterdayMonth, yesterdayDay);
// tomorrow = new DateTime(tomorrowYear, tomorrowMonth, tomorrowDay);
//}
var oraObj = new OracleObject();
var dates = new List <object>();
//var obj = new {
// Yesterday = yesterday,
// Tomorrow = tomorrow,
// Key = key
//};
var obj = new {
StartDate = startDate,
EndDate = endDate,
Key = key
};
dates.Add(obj); //1
var company = oRep.GetCompanyInfo(companyId);
var ss = oRep.GetSourceSystem(company.SourceSystem);
var id = company.CompanyID;
oRep.CompanyId = id;
//0
oraObj.Dates = dates.ToArray();
//1
oraObj.DeletedItems = oRep.GetDeletedItems(id, startDate, endDate, runId);
//oraObj.DeletedItems = new object();
//2
oraObj.SourceSystem = ss;
//oraObj.SourceSystem = new object();
//3
oraObj.Roles = oRep.GetRoles(startDate, endDate, limitResults, runId);
//oraObj.Roles = new object();
//4
oraObj.Statuses = oRep.GetStatuses(startDate, endDate, limitResults, runId);
//oraObj.Statuses = new object();
//5
oraObj.QuoteStatuses = oRep.GetQuoteStatuses(startDate, endDate, limitResults, runId);
//oraObj.QuoteStatuses = new object();
//6
oraObj.QuoteSections = oRep.GetQuoteSections(startDate, endDate, limitResults, runId);
//oraObj.QuoteSections = new object();
//7
oraObj.ProjectChargeTypes = oRep.GetProjectChargeTypes(startDate, endDate, limitResults, runId);
//oraObj.ProjectChargeTypes = new object();
//8
oraObj.ProjectBidderStatuses = oRep.GetProjectBidderStatuses(startDate, endDate, limitResults, runId);
//oraObj.ProjectBidderStatuses = new object();
//9
oraObj.EventStatus = oRep.GetEventStatuses(startDate, endDate, limitResults, runId);
//oraObj.EventStatus = new object();
//10
oraObj.DeviationTypes = oRep.GetDeviationTypes(startDate, endDate, limitResults, runId);
//oraObj.DeviationTypes = new object();
//11
oraObj.Companies = oRep.GetCompanies(company, runId);
//oraObj.Companies = new object();
//12
oraObj.Unit_Of_Measure = oRep.GetUnitsOfMeasure(id, startDate, endDate, limitResults, runId);
//oraObj.Unit_Of_Measure = new object();
//13
oraObj.QuoteTypes = oRep.GetQuoteTypes(id, startDate, endDate, limitResults, runId);
//oraObj.QuoteTypes = new object();
//14
oraObj.CompanyOrderStatuses = oRep.GetCompanyOrderStatuses(id, startDate, endDate, limitResults, runId);
//oraObj.CompanyOrderStatuses = new object();
//15
oraObj.CompanyProjectProductStatuses = oRep.GetCompanyProjectProductStatuses(id, startDate, endDate, limitResults, runId);
//oraObj.CompanyProjectProductStatuses = new object();
//16
oraObj.CompanyProjectStatuses = oRep.GetCompanyProjectStatuses(id, startDate, endDate, limitResults, runId);
//oraObj.CompanyProjectStatuses = new object();
//17
oraObj.CompanyQuoteStatuses = oRep.GetCompanyQuoteStatuses(id, startDate, endDate, limitResults, runId);
//oraObj.CompanyQuoteStatuses = new object();
//18
oraObj.CreditStatuses = oRep.GetCreditStatuses(id, startDate, endDate, limitResults, runId);
//oraObj.CreditStatuses = new object();
//19
oraObj.CustomerEventTypes = oRep.GetCustomerEventTypes(id, startDate, endDate, limitResults, runId);
//oraObj.CustomerEventTypes = new object();
//20
oraObj.CustomerTypes = oRep.GetCustomerTypes(id, startDate, endDate, limitResults, runId);
//oraObj.CustomerTypes = new object();
//21
oraObj.Divisions = oRep.GetDivisions(id, startDate, endDate, limitResults, runId);
//oraObj.Divisions = new object();
//22
oraObj.EventFrequency = oRep.GetEventFrequency(id, startDate, endDate, limitResults, runId);
//oraObj.EventFrequency = new object();
//23
oraObj.LinesOfBusiness = oRep.GetLinesOfBusiness(id, startDate, endDate, limitResults, runId);
//oraObj.LinesOfBusiness = new object();
//24
oraObj.LostReasons = oRep.GetLostReasons(id, startDate, endDate, limitResults, runId);
//oraObj.LostReasons = new object();
//25
oraObj.PaymentTerms = oRep.GetPaymentTerms(id, startDate, endDate, limitResults, runId);
//oraObj.PaymentTerms = new object();
//26
oraObj.ProjectMapQtyRanges = oRep.GetProjectMapQtyRanges(id, startDate, endDate, limitResults, runId);
//oraObj.ProjectMapQtyRanges = new object();
//27
oraObj.ProjectTypes = oRep.GetProjectTypes(id, startDate, endDate, limitResults, runId);
//oraObj.ProjectTypes = new object();
//28
oraObj.Sources = oRep.GetSources(id, startDate, endDate, limitResults, runId);
//oraObj.Sources = new object();
//29
oraObj.Terms_Discount = oRep.GetTermsDiscount(id, startDate, endDate, limitResults, runId);
//oraObj.Terms_Discount = new object();
//30
oraObj.VehicleTypes = oRep.GetVehicleTypes(id, startDate, endDate, limitResults, runId);
//oraObj.VehicleTypes = new object();
//31
oraObj.ZoneCodes = oRep.GetZoneCodes(id, startDate, endDate, limitResults, runId);
//oraObj.ZoneCodes = new object();
//32
oraObj.CompanyBidStatuses = oRep.GetCompanyBidStatuses(id, startDate, endDate, limitResults, runId);
//oraObj.CompanyBidStatuses = new object();
//33
oraObj.Plant = oRep.GetPlants(id, startDate, endDate, limitResults, runId);
//oraObj.Plant = new object();
//34
oraObj.PlantLinesOfBusiness = oRep.GetPlantLinesOfBusiness(id, startDate, endDate, limitResults, runId);
//oraObj.PlantLinesOfBusiness = new object();
//35
oraObj.ProductLines = oRep.GetProductLines(id, startDate, endDate, limitResults, runId);
//oraObj.ProductLines = new object();
//36
oraObj.ProductTypes = oRep.GetProductTypes(id, startDate, endDate, limitResults, runId);
//oraObj.ProductTypes = new object();
//37
oraObj.ProductUsage = oRep.GetProductUsage(id, startDate, endDate, limitResults, runId);
//oraObj.ProductUsage = new object();
//38
oraObj.Surcharges = oRep.GetSurcharges(id, startDate, endDate, limitResults, runId);
//oraObj.Surcharges = new object();
//39
oraObj.Product = oRep.GetProducts(id, startDate, endDate, limitResults, runId);
//oraObj.Product = new object();
//40
oraObj.PlantProductPrices = oRep.GetPlantProductPrices(id, startDate, endDate, limitResults, runId);
//oraObj.PlantProductPrices = new object();
//41
oraObj.ProjectCharges = oRep.GetProjectCharges(id, startDate, endDate, limitResults, runId);
//oraObj.ProjectCharges = new object();
//42
oraObj.StandardClauses = oRep.GetStandardClauses(id, startDate, endDate, limitResults, runId);
//oraObj.StandardClauses = new object();
//43
oraObj.Users = oRep.GetUsers(id, startDate, endDate, limitResults, runId);
//oraObj.Users = new object();
//44
oraObj.UserRoles = oRep.GetUserRoles(id, startDate, endDate, limitResults, runId);
//oraObj.UserRoles = new object();
//45
oraObj.CompanyUsers = oRep.GetCompanyUsers(id, startDate, endDate, limitResults, runId);
//oraObj.CompanyUsers = new object();
//46
oraObj.Competitors = oRep.GetCompetitors(id, startDate, endDate, limitResults, runId);
//oraObj.Competitors = new object();
//47
oraObj.CompetitorPlants = oRep.GetCompetitorPlants(id, startDate, endDate, limitResults, runId);
//oraObj.CompetitorPlants = new object();
//48
oraObj.Logins = oRep.GetLogins(id, startDate, endDate, limitResults, runId);
//oraObj.Logins = new object();
//49
oraObj.ManagersSalesmen = oRep.GetManagersSalesmen(id, startDate, endDate, limitResults, runId);
//oraObj.ManagersSalesmen = new object();
//50
oraObj.ProductTemplates = oRep.GetProductTemplates(id, startDate, endDate, limitResults, runId);
//oraObj.ProductTemplates = new object();
//51
oraObj.TemplatedProducts = oRep.GetTemplatedProducts(id, startDate, endDate, limitResults, runId);
//oraObj.TemplatedProducts = new object();
//52
oraObj.Prospects = oRep.GetProspects(id, startDate, endDate, limitResults, runId);
//oraObj.Prospects = new object();
//53
oraObj.ProspectNotes = oRep.GetProspectNotes(id, startDate, endDate, limitResults, runId);
//oraObj.ProspectNotes = new object();
//54
oraObj.SalesPersonRegions = oRep.GetSalesPersonRegions(id, startDate, endDate, limitResults, runId);
//oraObj.SalesPersonRegions = new object();
//55
oraObj.Contact = oRep.GetContacts(id, startDate, endDate, limitResults, runId);
//oraObj.Contact = new object();
//56
oraObj.ContactNotes = oRep.GetContactNotes(id, startDate, endDate, limitResults, runId);
//oraObj.ContactNotes = new object();
//57
oraObj.Projects = oRep.GetProjects(id, startDate, endDate, limitResults, runId);
//oraObj.Projects = new object();
//58
oraObj.CustomerEvents = oRep.GetCustomerEvents(id, startDate, endDate, limitResults, runId);
//oraObj.CustomerEvents = new object();
//59
oraObj.ProjectProducts = oRep.GetProjectProducts(id, startDate, endDate, limitResults, runId);
//oraObj.ProjectProducts = new object();
//60
oraObj.Schedules = oRep.GetSchedules(id, startDate, endDate, limitResults, runId);
//oraObj.Schedules = new object();
//61
oraObj.ScheduleItems = oRep.GetScheduleItems(id, startDate, endDate, limitResults, runId);
//oraObj.ScheduleItems = new object();
//62
oraObj.SalespersonContacts = oRep.GetSalespersonContacts(id, startDate, endDate, limitResults, runId);
//oraObj.SalespersonContacts = new object();
//63
oraObj.ProjectNotes = oRep.GetProjectNotes(id, startDate, endDate, limitResults, runId);
//oraObj.ProjectNotes = new object();
//64
oraObj.ProjectBidders = oRep.GetProjectBidders(id, startDate, endDate, limitResults, runId);
//oraObj.ProjectBidders = new object();
//65
oraObj.ProjectBidderProducts = oRep.GetProjectBidderProducts(id, startDate, endDate, limitResults, runId);
//oraObj.ProjectBidderProducts = new object();
//66
oraObj.ProjectBidderNotes = oRep.GetProjectBidderNotes(id, startDate, endDate, limitResults, runId);
//oraObj.ProjectBidderNotes = new object();
//67
oraObj.ProjectBidderCharges = oRep.GetProjectBidderCharges(id, startDate, endDate, limitResults, runId);
//oraObj.ProjectBidderCharges = new object();
//68
//oraObj.Orders = oRep.GetOrders(id, startDate, endDate, limitResults);
oraObj.Orders = new object();
//69
//oraObj.OrderDetails = oRep.GetOrderDetails(id, startDate, endDate, limitResults);
oraObj.OrderDetails = new object();
//70
oraObj.Quotes = oRep.GetQuotes(id, startDate, endDate, limitResults, runId);
//oraObj.Quotes = new object();
//71
oraObj.QuoteDetails = oRep.GetQuoteDetails(id, startDate, endDate, limitResults, runId);
//oraObj.QuoteDetails = new object();
//72
oraObj.QuoteStandardClauses = oRep.GetQuoteStandardClauses(id, startDate, endDate, limitResults, runId);
//oraObj.QuoteStandardClauses = new object();
//73
oraObj.QuoteSurcharges = oRep.GetQuoteSurcharges(id, startDate, endDate, limitResults, runId);
//oraObj.QuoteSurcharges = new object();
//74
oraObj.ProjectDistances = oRep.GetProjectDistances(id, startDate, endDate, limitResults, runId);
//oraObj.ProjectDistances = new object();
return(oraObj);
}