static void Main(string[] args)
{
if (args.Length < 4)
{
Console.WriteLine("insufficient arguments");
}
var query = new ContractQuery(args[0], args[1], args[2], args[3]);
foreach (string s in query.ResultList)
{
Console.WriteLine(s);
}
}
public void TestMethod2()
{
const string Header = "Artist|Title|Usages|StartDate|EndDate";
const string L1 = "Monkey Claw|Motor Mouth|streaming|1st Mar 2011|";
const string L2 = "Tinie Tempah|Frisky (Live from SoHo)|streaming|1st Feb 2012|";
var query = new ContractQuery("YouTube", "1st", "April", "2012");
Assert.IsTrue(query.ResultList.Count == 3);
Assert.AreEqual(query.ResultList[0], Header);
Assert.AreEqual(query.ResultList[1], L1);
Assert.AreEqual(query.ResultList[2], L2);
}
public static async Task <IActionResult> Run(
[HttpTrigger(AuthorizationLevel.Function, "get", Route = "contract")] HttpRequest req,
ILogger log, ExecutionContext context)
{
var config = new ConfigurationBuilder()
.SetBasePath(context.FunctionAppDirectory)
.AddJsonFile("local.settings.json", optional: true, reloadOnChange: true)
.AddEnvironmentVariables()
.Build();
var connectionString = config.GetConnectionString("DevProcurementConnectionString");
var contractQuery = new ContractQuery(connectionString);
var result = await contractQuery.GetAggregationsAsync();
return(new OkObjectResult(result));
}
public void TestMethod3()
{
const string Header = "Artist|Title|Usages|StartDate|EndDate";
const string L1 = "Monkey Claw|Christmas Special|streaming|25st Dec 2012|31st Dec 2012";
const string L2 = "Monkey Claw|Iron Horse|streaming|1st June 2012|";
const string L3 = "Monkey Claw|Motor Mouth|streaming|1st Mar 2011|";
const string L4 = "Tinie Tempah|Frisky (Live from SoHo)|streaming|1st Feb 2012|";
var query = new ContractQuery("YouTube", "27th", "Dec ", "2012");
Assert.IsTrue(query.ResultList.Count == 5);
Assert.AreEqual(query.ResultList[0], Header);
Assert.AreEqual(query.ResultList[1], L1);
Assert.AreEqual(query.ResultList[2], L2);
Assert.AreEqual(query.ResultList[3], L3);
Assert.AreEqual(query.ResultList[4], L4);
}
public void TestMethod1()
{
const string Header = "Artist|Title|Usages|StartDate|EndDate";
const string L1 = "Monkey Claw|Black Mountain|digital download|1st Feb 2012|";
const string L2 = "Monkey Claw|Motor Mouth|digital download|1st Mar 2011|";
const string L3 = "Tinie Tempah|Frisky (Live from SoHo)|digital download|1st Feb 2012|";
const string L4 = "Tinie Tempah|Miami 2 Ibiza|digital download|1st Feb 2012|";
var query = new ContractQuery("ITunes", "1st", "March", "2012");
Assert.IsTrue(query.ResultList.Count == 5);
Assert.AreEqual(query.ResultList[0], Header);
Assert.AreEqual(query.ResultList[1], L1);
Assert.AreEqual(query.ResultList[2], L2);
Assert.AreEqual(query.ResultList[3], L3);
Assert.AreEqual(query.ResultList[4], L4);
}
private EWS.Domain.Model.QuoteCalculationItem[] GetQuoteCalculationItemsStructure(Domain.Data.DataModel.QuoteCalculation calc, short NoOfYears, DateTime?StartDate = null)
{
QuoteCalculationItem[] models = new QuoteCalculationItem[NoOfYears];
// new/old ROE and VAT values needed .........................................
decimal oldROE;
decimal newROE;
float VAT;
QuoteQuery quotequery = new QuoteQuery()
{
ID = calc.QuoteID
};
EWS.Domain.Data.DataModel.Quote quoteEntity = _queryProcessor.Execute(quotequery);
newROE = quoteEntity.ROE;
if (!string.IsNullOrEmpty(quoteEntity.QuoteRef))
{
SourceQuoteQuery query = new SourceQuoteQuery()
{
QuoteRef = quoteEntity.QuoteRef
};
SourceQuote entity = _queryProcessor.Execute(query);
oldROE = entity.ROE;
VAT = entity.VAT;
}
else
{
ContractQuery query = new ContractQuery()
{
ID = quoteEntity.BaseContractID.Value
};
EWS.Domain.Data.DataModel.Contract entity = _queryProcessor.Execute(query);
oldROE = entity.ROE;
VAT = entity.VAT;
}
// Currently Saved values ....................................................
QuoteCalculationItemsQuery qury = new QuoteCalculationItemsQuery()
{
QuoteCalculationID = calc.ID
};
IEnumerable <Domain.Data.DataModel.QuoteCalculationItem> calcs = _queryProcessor.Execute(qury);
// Setup the structure .......................................................
for (byte i = 0; i < NoOfYears; i++)
{
byte yearno = (byte)(i + 1);
models[i] = new QuoteCalculationItem()
{
YearNo = yearno,
NewROE = newROE, TOPSROE = oldROE, VAT = VAT,
UseNewROE = true,
Increment = (i == 0 ? 0 : EWS.Domain.Defaults.AnnualIncrement)
};
if (StartDate.HasValue)
{
models[i].StartDate = StartDate.Value.AddYears(i);
models[i].EndDate = StartDate.Value.AddYears(yearno).AddDays(-1);
}
Domain.Data.DataModel.QuoteCalculationItem item = calcs.FirstOrDefault(c => c.YearNo == yearno);
if (item != null)
{
models[i].ID = item.ID;
models[i].Increment = item.IncrPerc;
models[i].UseNewROE = (item.ROE == newROE);
}
}
return(models);
}
