public void HydrometricDataValue_CRUD_Test()
{
foreach (CultureInfo culture in AllowableCulture)
{
ChangeCulture(culture);
using (CSSPDBContext dbTestDB = new CSSPDBContext(DatabaseTypeEnum.SqlServerTestDB))
{
HydrometricDataValueService hydrometricDataValueService = new HydrometricDataValueService(new Query()
{
Lang = culture.TwoLetterISOLanguageName
}, dbTestDB, ContactID);
int count = 0;
if (count == 1)
{
// just so we don't get a warning during compile [The variable 'count' is assigned but its value is never used]
}
HydrometricDataValue hydrometricDataValue = GetFilledRandomHydrometricDataValue("");
// -------------------------------
// -------------------------------
// CRUD testing
// -------------------------------
// -------------------------------
count = hydrometricDataValueService.GetHydrometricDataValueList().Count();
Assert.AreEqual(count, (from c in dbTestDB.HydrometricDataValues select c).Count());
hydrometricDataValueService.Add(hydrometricDataValue);
if (hydrometricDataValue.HasErrors)
{
Assert.AreEqual("", hydrometricDataValue.ValidationResults.FirstOrDefault().ErrorMessage);
}
Assert.AreEqual(true, hydrometricDataValueService.GetHydrometricDataValueList().Where(c => c == hydrometricDataValue).Any());
hydrometricDataValueService.Update(hydrometricDataValue);
if (hydrometricDataValue.HasErrors)
{
Assert.AreEqual("", hydrometricDataValue.ValidationResults.FirstOrDefault().ErrorMessage);
}
Assert.AreEqual(count + 1, hydrometricDataValueService.GetHydrometricDataValueList().Count());
hydrometricDataValueService.Delete(hydrometricDataValue);
if (hydrometricDataValue.HasErrors)
{
Assert.AreEqual("", hydrometricDataValue.ValidationResults.FirstOrDefault().ErrorMessage);
}
Assert.AreEqual(count, hydrometricDataValueService.GetHydrometricDataValueList().Count());
}
}
}
public IHttpActionResult Put([FromBody] HydrometricDataValue hydrometricDataValue, [FromUri] string lang = "en")
{
using (CSSPDBContext db = new CSSPDBContext(DatabaseType))
{
HydrometricDataValueService hydrometricDataValueService = new HydrometricDataValueService(new Query()
{
Language = (lang == "fr" ? LanguageEnum.fr : LanguageEnum.en)
}, db, ContactID);
if (!hydrometricDataValueService.Update(hydrometricDataValue))
{
return(BadRequest(String.Join("|||", hydrometricDataValue.ValidationResults)));
}
else
{
hydrometricDataValue.ValidationResults = null;
return(Ok(hydrometricDataValue));
}
}
}
public void HydrometricDataValue_Properties_Test()
{
foreach (CultureInfo culture in AllowableCulture)
{
ChangeCulture(culture);
using (CSSPDBContext dbTestDB = new CSSPDBContext(DatabaseTypeEnum.SqlServerTestDB))
{
HydrometricDataValueService hydrometricDataValueService = new HydrometricDataValueService(new Query()
{
Lang = culture.TwoLetterISOLanguageName
}, dbTestDB, ContactID);
int count = 0;
if (count == 1)
{
// just so we don't get a warning during compile [The variable 'count' is assigned but its value is never used]
}
count = hydrometricDataValueService.GetHydrometricDataValueList().Count();
HydrometricDataValue hydrometricDataValue = GetFilledRandomHydrometricDataValue("");
// -------------------------------
// -------------------------------
// Properties testing
// -------------------------------
// -------------------------------
// -----------------------------------
// [Key]
// Is NOT Nullable
// hydrometricDataValue.HydrometricDataValueID (Int32)
// -----------------------------------
hydrometricDataValue = null;
hydrometricDataValue = GetFilledRandomHydrometricDataValue("");
hydrometricDataValue.HydrometricDataValueID = 0;
hydrometricDataValueService.Update(hydrometricDataValue);
Assert.AreEqual(string.Format(CSSPServicesRes._IsRequired, "HydrometricDataValueID"), hydrometricDataValue.ValidationResults.FirstOrDefault().ErrorMessage);
hydrometricDataValue = null;
hydrometricDataValue = GetFilledRandomHydrometricDataValue("");
hydrometricDataValue.HydrometricDataValueID = 10000000;
hydrometricDataValueService.Update(hydrometricDataValue);
Assert.AreEqual(string.Format(CSSPServicesRes.CouldNotFind_With_Equal_, "HydrometricDataValue", "HydrometricDataValueID", hydrometricDataValue.HydrometricDataValueID.ToString()), hydrometricDataValue.ValidationResults.FirstOrDefault().ErrorMessage);
// -----------------------------------
// Is NOT Nullable
// [CSSPExist(ExistTypeName = "HydrometricSite", ExistPlurial = "s", ExistFieldID = "HydrometricSiteID", AllowableTVtypeList = )]
// hydrometricDataValue.HydrometricSiteID (Int32)
// -----------------------------------
hydrometricDataValue = null;
hydrometricDataValue = GetFilledRandomHydrometricDataValue("");
hydrometricDataValue.HydrometricSiteID = 0;
hydrometricDataValueService.Add(hydrometricDataValue);
Assert.AreEqual(string.Format(CSSPServicesRes.CouldNotFind_With_Equal_, "HydrometricSite", "HydrometricSiteID", hydrometricDataValue.HydrometricSiteID.ToString()), hydrometricDataValue.ValidationResults.FirstOrDefault().ErrorMessage);
// -----------------------------------
// Is NOT Nullable
// [CSSPAfter(Year = 1980)]
// hydrometricDataValue.DateTime_Local (DateTime)
// -----------------------------------
hydrometricDataValue = null;
hydrometricDataValue = GetFilledRandomHydrometricDataValue("");
hydrometricDataValue.DateTime_Local = new DateTime();
hydrometricDataValueService.Add(hydrometricDataValue);
Assert.AreEqual(string.Format(CSSPServicesRes._IsRequired, "DateTime_Local"), hydrometricDataValue.ValidationResults.FirstOrDefault().ErrorMessage);
hydrometricDataValue = null;
hydrometricDataValue = GetFilledRandomHydrometricDataValue("");
hydrometricDataValue.DateTime_Local = new DateTime(1979, 1, 1);
hydrometricDataValueService.Add(hydrometricDataValue);
Assert.AreEqual(string.Format(CSSPServicesRes._YearShouldBeBiggerThan_, "DateTime_Local", "1980"), hydrometricDataValue.ValidationResults.FirstOrDefault().ErrorMessage);
// -----------------------------------
// Is NOT Nullable
// hydrometricDataValue.Keep (Boolean)
// -----------------------------------
// -----------------------------------
// Is NOT Nullable
// [CSSPEnumType]
// hydrometricDataValue.StorageDataType (StorageDataTypeEnum)
// -----------------------------------
hydrometricDataValue = null;
hydrometricDataValue = GetFilledRandomHydrometricDataValue("");
hydrometricDataValue.StorageDataType = (StorageDataTypeEnum)1000000;
hydrometricDataValueService.Add(hydrometricDataValue);
Assert.AreEqual(string.Format(CSSPServicesRes._IsRequired, "StorageDataType"), hydrometricDataValue.ValidationResults.FirstOrDefault().ErrorMessage);
// -----------------------------------
// Is NOT Nullable
// hydrometricDataValue.HasBeenRead (Boolean)
// -----------------------------------
// -----------------------------------
// Is Nullable
// [Range(0, 100000)]
// hydrometricDataValue.Discharge_m3_s (Double)
// -----------------------------------
//CSSPError: Type not implemented [Discharge_m3_s]
//CSSPError: Type not implemented [Discharge_m3_s]
hydrometricDataValue = null;
hydrometricDataValue = GetFilledRandomHydrometricDataValue("");
hydrometricDataValue.Discharge_m3_s = -1.0D;
Assert.AreEqual(false, hydrometricDataValueService.Add(hydrometricDataValue));
Assert.AreEqual(string.Format(CSSPServicesRes._ValueShouldBeBetween_And_, "Discharge_m3_s", "0", "100000"), hydrometricDataValue.ValidationResults.FirstOrDefault().ErrorMessage);
Assert.AreEqual(count, hydrometricDataValueService.GetHydrometricDataValueList().Count());
hydrometricDataValue = null;
hydrometricDataValue = GetFilledRandomHydrometricDataValue("");
hydrometricDataValue.Discharge_m3_s = 100001.0D;
Assert.AreEqual(false, hydrometricDataValueService.Add(hydrometricDataValue));
Assert.AreEqual(string.Format(CSSPServicesRes._ValueShouldBeBetween_And_, "Discharge_m3_s", "0", "100000"), hydrometricDataValue.ValidationResults.FirstOrDefault().ErrorMessage);
Assert.AreEqual(count, hydrometricDataValueService.GetHydrometricDataValueList().Count());
// -----------------------------------
// Is Nullable
// [Range(0, 100000)]
// hydrometricDataValue.DischargeEntered_m3_s (Double)
// -----------------------------------
//CSSPError: Type not implemented [DischargeEntered_m3_s]
//CSSPError: Type not implemented [DischargeEntered_m3_s]
hydrometricDataValue = null;
hydrometricDataValue = GetFilledRandomHydrometricDataValue("");
hydrometricDataValue.DischargeEntered_m3_s = -1.0D;
Assert.AreEqual(false, hydrometricDataValueService.Add(hydrometricDataValue));
Assert.AreEqual(string.Format(CSSPServicesRes._ValueShouldBeBetween_And_, "DischargeEntered_m3_s", "0", "100000"), hydrometricDataValue.ValidationResults.FirstOrDefault().ErrorMessage);
Assert.AreEqual(count, hydrometricDataValueService.GetHydrometricDataValueList().Count());
hydrometricDataValue = null;
hydrometricDataValue = GetFilledRandomHydrometricDataValue("");
hydrometricDataValue.DischargeEntered_m3_s = 100001.0D;
Assert.AreEqual(false, hydrometricDataValueService.Add(hydrometricDataValue));
Assert.AreEqual(string.Format(CSSPServicesRes._ValueShouldBeBetween_And_, "DischargeEntered_m3_s", "0", "100000"), hydrometricDataValue.ValidationResults.FirstOrDefault().ErrorMessage);
Assert.AreEqual(count, hydrometricDataValueService.GetHydrometricDataValueList().Count());
// -----------------------------------
// Is Nullable
// [Range(0, 10000)]
// hydrometricDataValue.Level_m (Double)
// -----------------------------------
//CSSPError: Type not implemented [Level_m]
//CSSPError: Type not implemented [Level_m]
hydrometricDataValue = null;
hydrometricDataValue = GetFilledRandomHydrometricDataValue("");
hydrometricDataValue.Level_m = -1.0D;
Assert.AreEqual(false, hydrometricDataValueService.Add(hydrometricDataValue));
Assert.AreEqual(string.Format(CSSPServicesRes._ValueShouldBeBetween_And_, "Level_m", "0", "10000"), hydrometricDataValue.ValidationResults.FirstOrDefault().ErrorMessage);
Assert.AreEqual(count, hydrometricDataValueService.GetHydrometricDataValueList().Count());
hydrometricDataValue = null;
hydrometricDataValue = GetFilledRandomHydrometricDataValue("");
hydrometricDataValue.Level_m = 10001.0D;
Assert.AreEqual(false, hydrometricDataValueService.Add(hydrometricDataValue));
Assert.AreEqual(string.Format(CSSPServicesRes._ValueShouldBeBetween_And_, "Level_m", "0", "10000"), hydrometricDataValue.ValidationResults.FirstOrDefault().ErrorMessage);
Assert.AreEqual(count, hydrometricDataValueService.GetHydrometricDataValueList().Count());
// -----------------------------------
// Is Nullable
// hydrometricDataValue.HourlyValues (String)
// -----------------------------------
// -----------------------------------
// Is NOT Nullable
// [CSSPAfter(Year = 1980)]
// hydrometricDataValue.LastUpdateDate_UTC (DateTime)
// -----------------------------------
hydrometricDataValue = null;
hydrometricDataValue = GetFilledRandomHydrometricDataValue("");
hydrometricDataValue.LastUpdateDate_UTC = new DateTime();
hydrometricDataValueService.Add(hydrometricDataValue);
Assert.AreEqual(string.Format(CSSPServicesRes._IsRequired, "LastUpdateDate_UTC"), hydrometricDataValue.ValidationResults.FirstOrDefault().ErrorMessage);
hydrometricDataValue = null;
hydrometricDataValue = GetFilledRandomHydrometricDataValue("");
hydrometricDataValue.LastUpdateDate_UTC = new DateTime(1979, 1, 1);
hydrometricDataValueService.Add(hydrometricDataValue);
Assert.AreEqual(string.Format(CSSPServicesRes._YearShouldBeBiggerThan_, "LastUpdateDate_UTC", "1980"), hydrometricDataValue.ValidationResults.FirstOrDefault().ErrorMessage);
// -----------------------------------
// Is NOT Nullable
// [CSSPExist(ExistTypeName = "TVItem", ExistPlurial = "s", ExistFieldID = "TVItemID", AllowableTVtypeList = Contact)]
// hydrometricDataValue.LastUpdateContactTVItemID (Int32)
// -----------------------------------
hydrometricDataValue = null;
hydrometricDataValue = GetFilledRandomHydrometricDataValue("");
hydrometricDataValue.LastUpdateContactTVItemID = 0;
hydrometricDataValueService.Add(hydrometricDataValue);
Assert.AreEqual(string.Format(CSSPServicesRes.CouldNotFind_With_Equal_, "TVItem", "LastUpdateContactTVItemID", hydrometricDataValue.LastUpdateContactTVItemID.ToString()), hydrometricDataValue.ValidationResults.FirstOrDefault().ErrorMessage);
hydrometricDataValue = null;
hydrometricDataValue = GetFilledRandomHydrometricDataValue("");
hydrometricDataValue.LastUpdateContactTVItemID = 1;
hydrometricDataValueService.Add(hydrometricDataValue);
Assert.AreEqual(string.Format(CSSPServicesRes._IsNotOfType_, "LastUpdateContactTVItemID", "Contact"), hydrometricDataValue.ValidationResults.FirstOrDefault().ErrorMessage);
// -----------------------------------
// Is NOT Nullable
// [NotMapped]
// hydrometricDataValue.HasErrors (Boolean)
// -----------------------------------
// No testing requied
// -----------------------------------
// Is NOT Nullable
// [NotMapped]
// hydrometricDataValue.ValidationResults (IEnumerable`1)
// -----------------------------------
// No testing requied
}
}
}
