public void ItShouldFindSchemes()
{
var service = new ForecastDataAccessService();
List <Scheme <decimal> > schemes = service.GetSchemes(6, null, null, null, null, null, null);
Assert.IsTrue(schemes.Count > 0);
}
public void ItShouldCreatePlanWithProperPositions()
{
var userName = "******";
var service = new ForecastDataAccessService();
service.CreateForecastPlan("TestCreatePlan", "Plan description", 1, userName, 1, 12);
}
public static IGlobal <decimal> ToModel(this Parameter parameter)
{
var context = new DisneyHCMLatamPlanningEntities();
var global = new Global <decimal>
{
Name = parameter.Name,
Description = parameter.Description,
Id = parameter.ParameterId,
IsModifiable = parameter.IsModifiable,
IsAccumulator = parameter.IsAccumulator,
IsConstant = parameter.IsConstant,
ParameterType = (FromDisney.ParameterType)parameter.ParameterTypeId,
Company = (context.Companies.FirstOrDefault(p => p.CompanyID == parameter.CompanyId).ToModel()),
Value = ForecastDataAccessService.SetDictionaryFromValue(0),
TableName = parameter.TableName,
ColumnName = parameter.ColumnName,
FixedValue = parameter.FixedValue,
};
if (parameter.ParameterDataTypeID.HasValue)
{
global.ParameterDataTypeId = parameter.ParameterDataTypeID.Value;
}
if (global.ParameterType == FromDisney.ParameterType.Constant)
{
global.MonthlyParameter = new List <MonthlyParameter <decimal> >();
var monthlyValues = context.ParameterValues
.Include("ParameterMonthValues.ParameterValue.FiscalYear")
.Where(p => p.ParameterId == parameter.ParameterId)
.ToList();
monthlyValues.ForEach(x =>
{
var monthlyParameter = new MonthlyParameter <decimal>
{
FiscalYearId = x.FiscalYear.FiscalYearID,
FiscalYearCode = x.FiscalYear.Code,
Value = new Dictionary <Month, decimal>()
};
for (int i = 1; i <= 12; i++)
{
decimal value = 0;
var result = x.ParameterMonthValues.FirstOrDefault(y => y.Month == i);
//try
//{
// value = x.ParameterMonthValues.ToList()[i - 1].Value;
//}
//catch (Exception)
//{
// value = 0;
//}
monthlyParameter.Value.Add((Month)i, result == null ? 0: result.Value);
}
global.MonthlyParameter.Add(monthlyParameter);
});
}
return(global);
}
public void ItshouldDeleteResults()
{
var service = new ForecastDataAccessService();
service.DeleteResults(14);
}
public void ItShouldRetrieveAnSchemeAndItsConcepts()
{
var service = new ForecastDataAccessService();
var scheme = service.GetScheme(1, 2012, null, null, 1, null, "FTE", "4001");
}
