private IEnumerable <ValidationResult> Validate(ValidationContext validationContext, ActionDBTypeEnum actionDBType)
{
string retStr = "";
Enums enums = new Enums(LanguageRequest);
SubsectorMWQMSampleYear subsectorMWQMSampleYear = validationContext.ObjectInstance as SubsectorMWQMSampleYear;
subsectorMWQMSampleYear.HasErrors = false;
if (subsectorMWQMSampleYear.SubsectorTVItemID < 1)
{
subsectorMWQMSampleYear.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._MinValueIs_, "SubsectorTVItemID", "1"), new[] { "SubsectorTVItemID" }));
}
//Year has no Range Attribute
if (subsectorMWQMSampleYear.EarliestDate.Year == 1)
{
subsectorMWQMSampleYear.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._IsRequired, "EarliestDate"), new[] { "EarliestDate" }));
}
else
{
if (subsectorMWQMSampleYear.EarliestDate.Year < 1980)
{
subsectorMWQMSampleYear.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._YearShouldBeBiggerThan_, "EarliestDate", "1980"), new[] { "EarliestDate" }));
}
}
if (subsectorMWQMSampleYear.LatestDate.Year == 1)
{
subsectorMWQMSampleYear.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._IsRequired, "LatestDate"), new[] { "LatestDate" }));
}
else
{
if (subsectorMWQMSampleYear.LatestDate.Year < 1980)
{
subsectorMWQMSampleYear.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._YearShouldBeBiggerThan_, "LatestDate", "1980"), new[] { "LatestDate" }));
}
}
if (subsectorMWQMSampleYear.EarliestDate > subsectorMWQMSampleYear.LatestDate)
{
subsectorMWQMSampleYear.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._DateIsBiggerThan_, "LatestDate", "SubsectorMWQMSampleYearEarliestDate"), new[] { "LatestDate" }));
}
retStr = ""; // added to stop compiling CSSPError
if (retStr != "") // will never be true
{
subsectorMWQMSampleYear.HasErrors = true;
yield return(new ValidationResult("AAA", new[] { "AAA" }));
}
}
private SubsectorMWQMSampleYear GetFilledRandomSubsectorMWQMSampleYear(string OmitPropName)
{
SubsectorMWQMSampleYear subsectorMWQMSampleYear = new SubsectorMWQMSampleYear();
if (OmitPropName != "SubsectorTVItemID")
{
subsectorMWQMSampleYear.SubsectorTVItemID = GetRandomInt(1, 11);
}
// should implement a Range for the property Year and type SubsectorMWQMSampleYear
if (OmitPropName != "EarliestDate")
{
subsectorMWQMSampleYear.EarliestDate = new DateTime(2005, 3, 6);
}
if (OmitPropName != "LatestDate")
{
subsectorMWQMSampleYear.LatestDate = new DateTime(2005, 3, 6);
}
return(subsectorMWQMSampleYear);
}
public List <SubsectorMWQMSampleYear> GetMWQMSampleYearWithSubsectorTVItemIDDB(int SubsectorTVItemID)
{
List <SubsectorMWQMSampleYear> subsectorClimateSiteList = new List <SubsectorMWQMSampleYear>();
List <DateTime> DateWhereSampleExist = (from t in db.TVItems
from s in db.MWQMSites
from msa in db.MWQMSamples
where t.TVItemID == s.MWQMSiteTVItemID &&
s.MWQMSiteTVItemID == msa.MWQMSiteTVItemID &&
t.ParentID == SubsectorTVItemID
select msa.SampleDateTime_Local).ToList();
List <int> YearList = (from c in DateWhereSampleExist
select c.Year).Distinct().ToList();
foreach (int Year in YearList)
{
DateTime EarliestDate = (from d in DateWhereSampleExist
where d.Year == Year
select d).FirstOrDefault();
DateTime LatestDate = (from d in DateWhereSampleExist
where d.Year == Year
select d).LastOrDefault();
SubsectorMWQMSampleYear subsectorClimateSite = new SubsectorMWQMSampleYear()
{
SubsectorTVItemID = SubsectorTVItemID,
Year = Year,
EarliestDate = EarliestDate,
LatestDate = LatestDate,
};
subsectorClimateSiteList.Add(subsectorClimateSite);
}
return(subsectorClimateSiteList);
}
public SubsectorMWQMSampleYearTest()
{
subsectorMWQMSampleYear = new SubsectorMWQMSampleYear();
}
