public static void QuarterLookupTemplate(ref AggregateCaseHeader obj)
{
if (_QuarterLookupTemplate == null)
{
_QuarterLookupTemplate = new BaseReferenceList("rftSampleStatus");
using (DbManagerProxy manager = DbManagerFactory.Factory.Create(ModelUserContext.Instance))
{
_QuarterLookupTemplate.Add(BaseReference.Accessor.Instance(null).CreateDummy(manager, null, 1L, "1"));
_QuarterLookupTemplate.Add(BaseReference.Accessor.Instance(null).CreateDummy(manager, null, 2L, "2"));
_QuarterLookupTemplate.Add(BaseReference.Accessor.Instance(null).CreateDummy(manager, null, 3L, "3"));
_QuarterLookupTemplate.Add(BaseReference.Accessor.Instance(null).CreateDummy(manager, null, 4L, "4"));
}
}
long thisYear = (long)System.DateTime.Now.Year;
obj.QuarterAggrLookup.RemoveAll(m => (long)m.Key > 0L);
if (obj.YearForAggr == thisYear)
{
obj.QuarterAggrLookup.AddRange(_QuarterLookupTemplate.Where(m => (m.idfsBaseReference - 1) * 3 < (long)DateTime.Now.Month));
}
else
{
obj.QuarterAggrLookup.AddRange(_QuarterLookupTemplate);
}
long?val = obj.QuarterForAggr;
obj.QuarterAggr = obj.QuarterAggrLookup
.Where(c => c.idfsBaseReference == val)
.SingleOrDefault();
}
/// <summary>
///
/// </summary>
/// <param name="manager"></param>
/// <param name="obj"></param>
private void CreateFF(DbManagerProxy manager, AggregateCaseHeader obj)
{
long?idFormTemplate;
switch (obj.idfsAggrCaseType)
{
case (long)AggregateCaseType.HumanAggregateCase:
obj.FFPresenterCase = SetFFModel(FFTypeEnum.HumanAggregateCase, obj.idfCaseObservation, manager, obj.idfVersion, obj.idfAggrCase, out idFormTemplate);
obj.idfsCaseObservationFormTemplate = idFormTemplate;
break;
case (long)AggregateCaseType.VetAggregateCase:
obj.FFPresenterCase = SetFFModel(FFTypeEnum.VetAggregateCase, obj.idfCaseObservation, manager, obj.idfVersion, obj.idfAggrCase, out idFormTemplate);
obj.idfsCaseObservationFormTemplate = idFormTemplate;
break;
case (long)AggregateCaseType.VetAggregateAction:
obj.FFPresenterDiagnostic = SetFFModel(FFTypeEnum.VetEpizooticActionDiagnosisInv, obj.idfDiagnosticObservation, manager, obj.idfDiagnosticVersion, obj.idfAggrCase, out idFormTemplate);
obj.idfsDiagnosticObservationFormTemplate = idFormTemplate;
obj.FFPresenterProphylactic = SetFFModel(FFTypeEnum.VetEpizooticActionTreatment, obj.idfProphylacticObservation, manager, obj.idfProphylacticVersion, obj.idfAggrCase, out idFormTemplate);
obj.idfsProphylacticObservationFormTemplate = idFormTemplate;
obj.FFPresenterSanitary = SetFFModel(FFTypeEnum.VetEpizooticAction, obj.idfSanitaryObservation, manager, obj.idfSanitaryVersion, obj.idfAggrCase, out idFormTemplate);
obj.idfsSanitaryObservationFormTemplate = idFormTemplate;
break;
}
}
protected static void CustomValidations(AggregateCaseHeader obj)
{
var acc = FFPresenterModel.Accessor.Instance(null);
using (var manager = DbManagerFactory.Factory.Create(ModelUserContext.Instance))
{
acc.Validate(manager, obj.FFPresenterCase, true, false, true);
acc.Validate(manager, obj.FFPresenterDiagnostic, true, false, true);
acc.Validate(manager, obj.FFPresenterProphylactic, true, false, true);
acc.Validate(manager, obj.FFPresenterSanitary, true, false, true);
}
}
protected void CheckDuplicates(DbManagerProxy manager, AggregateCaseHeader h)
{
int ret = manager.SetSpCommand("dbo.spAggregateCaseExists",
manager.Parameter("@StartDate", h.datStartDateCalc),
manager.Parameter("@FinishDate", h.datFinishDateCalc),
manager.Parameter("@AdminUnit", h.idfsAdministrativeUnitCalc),
manager.Parameter("@AggrCaseType", h.idfsAggrCaseType),
manager.Parameter("@CaseID", h.idfAggrCase)
).ExecuteScalar <int>(ScalarSourceType.ReturnValue);
if (ret == 1)
{
throw new ValidationModelException("Agg_Case_already_exists", "", "", null, null, ValidationEventType.Error, h);
}
}
public static void MonthLookupTemplate(ref AggregateCaseHeader obj)
{
lock (_MonthLookupTemplate)
{
if (!_MonthLookupTemplate.ContainsKey(ModelUserContext.CurrentLanguage))
{
_MonthLookupTemplate.Add(ModelUserContext.CurrentLanguage, new BaseReferenceList("rftSampleStatus"));
using (DbManagerProxy manager = DbManagerFactory.Factory.Create(ModelUserContext.Instance))
{
_MonthLookupTemplate[ModelUserContext.CurrentLanguage].Add(BaseReference.Accessor.Instance(null).CreateDummy(manager, null, 1L, EidssMessages.Instance.GetString("January")));
_MonthLookupTemplate[ModelUserContext.CurrentLanguage].Add(BaseReference.Accessor.Instance(null).CreateDummy(manager, null, 2L, EidssMessages.Instance.GetString("February")));
_MonthLookupTemplate[ModelUserContext.CurrentLanguage].Add(BaseReference.Accessor.Instance(null).CreateDummy(manager, null, 3L, EidssMessages.Instance.GetString("March")));
_MonthLookupTemplate[ModelUserContext.CurrentLanguage].Add(BaseReference.Accessor.Instance(null).CreateDummy(manager, null, 4L, EidssMessages.Instance.GetString("April")));
_MonthLookupTemplate[ModelUserContext.CurrentLanguage].Add(BaseReference.Accessor.Instance(null).CreateDummy(manager, null, 5L, EidssMessages.Instance.GetString("May")));
_MonthLookupTemplate[ModelUserContext.CurrentLanguage].Add(BaseReference.Accessor.Instance(null).CreateDummy(manager, null, 6L, EidssMessages.Instance.GetString("June")));
_MonthLookupTemplate[ModelUserContext.CurrentLanguage].Add(BaseReference.Accessor.Instance(null).CreateDummy(manager, null, 7L, EidssMessages.Instance.GetString("July")));
_MonthLookupTemplate[ModelUserContext.CurrentLanguage].Add(BaseReference.Accessor.Instance(null).CreateDummy(manager, null, 8L, EidssMessages.Instance.GetString("August")));
_MonthLookupTemplate[ModelUserContext.CurrentLanguage].Add(BaseReference.Accessor.Instance(null).CreateDummy(manager, null, 9L, EidssMessages.Instance.GetString("September")));
_MonthLookupTemplate[ModelUserContext.CurrentLanguage].Add(BaseReference.Accessor.Instance(null).CreateDummy(manager, null, 10L, EidssMessages.Instance.GetString("October")));
_MonthLookupTemplate[ModelUserContext.CurrentLanguage].Add(BaseReference.Accessor.Instance(null).CreateDummy(manager, null, 11L, EidssMessages.Instance.GetString("November")));
_MonthLookupTemplate[ModelUserContext.CurrentLanguage].Add(BaseReference.Accessor.Instance(null).CreateDummy(manager, null, 12L, EidssMessages.Instance.GetString("December")));
}
}
}
long thisYear = (long)System.DateTime.Now.Year;
obj.MonthAggrLookup.RemoveAll(m => (long)m.Key > 0L);
if (obj.YearForAggr == thisYear)
{
obj.MonthAggrLookup.AddRange(_MonthLookupTemplate[ModelUserContext.CurrentLanguage].Where(m => m.idfsBaseReference <= (long)System.DateTime.Now.Month));
}
else
{
obj.MonthAggrLookup.AddRange(_MonthLookupTemplate[ModelUserContext.CurrentLanguage]);
}
long?val = obj.MonthForAggr;
obj.MonthAggr = obj.MonthAggrLookup
.Where(c => c.idfsBaseReference == val)
.SingleOrDefault();
}
public static void WeekLookupTemplate(ref AggregateCaseHeader obj)
{
if (_WeekLookupTemplate == null)
{
_WeekLookupTemplate = new BaseReferenceList("rftSampleStatus");
}
_WeekLookupTemplate.Clear();
if (obj.YearForAggr != null)
{
using (DbManagerProxy manager = DbManagerFactory.Factory.Create(ModelUserContext.Instance))
{
foreach (WeekPeriod wp in DatePeriodHelper.GetWeeksList((int)obj.YearForAggr))
{
_WeekLookupTemplate.Add(BaseReference.Accessor.Instance(null).CreateDummy(manager, null, (long)wp.WeekNumber, String.Format("{0:d}-{1:d}", wp.WeekStartDate, wp.WeekStartDate.AddDays(6))));
}
}
}
long thisYear = (long)DateTime.Now.Year;
obj.WeekAggrLookup.RemoveAll(m => (long)m.Key > 0L);
if (obj.YearForAggr == thisYear)
{
obj.WeekAggrLookup.AddRange(_WeekLookupTemplate.Where(m => m.idfsBaseReference <= (long)DatePeriodHelper.GetWeekOfYear(DateTime.Now)));
}
else
{
obj.WeekAggrLookup.AddRange(_WeekLookupTemplate);
}
long?val = obj.WeekForAggr;
obj.WeekAggr = obj.WeekAggrLookup
.Where(c => c.idfsBaseReference == val)
.SingleOrDefault();
}
