public void MWQMAnalysisReportParameter_Controller_Put_Test()
{
foreach (LanguageEnum LanguageRequest in AllowableLanguages)
{
foreach (int ContactID in new List <int>()
{
AdminContactID
}) //, TestEmailValidatedContactID, TestEmailNotValidatedContactID })
{
MWQMAnalysisReportParameterController mwqmAnalysisReportParameterController = new MWQMAnalysisReportParameterController(DatabaseTypeEnum.SqlServerTestDB);
Assert.IsNotNull(mwqmAnalysisReportParameterController);
Assert.AreEqual(DatabaseTypeEnum.SqlServerTestDB, mwqmAnalysisReportParameterController.DatabaseType);
MWQMAnalysisReportParameter mwqmAnalysisReportParameterLast = new MWQMAnalysisReportParameter();
using (CSSPDBContext db = new CSSPDBContext(DatabaseType))
{
Query query = new Query();
query.Language = LanguageRequest;
MWQMAnalysisReportParameterService mwqmAnalysisReportParameterService = new MWQMAnalysisReportParameterService(query, db, ContactID);
mwqmAnalysisReportParameterLast = (from c in db.MWQMAnalysisReportParameters select c).FirstOrDefault();
}
// ok with MWQMAnalysisReportParameter info
IHttpActionResult jsonRet = mwqmAnalysisReportParameterController.GetMWQMAnalysisReportParameterWithID(mwqmAnalysisReportParameterLast.MWQMAnalysisReportParameterID);
Assert.IsNotNull(jsonRet);
OkNegotiatedContentResult <MWQMAnalysisReportParameter> Ret = jsonRet as OkNegotiatedContentResult <MWQMAnalysisReportParameter>;
MWQMAnalysisReportParameter mwqmAnalysisReportParameterRet = Ret.Content;
Assert.AreEqual(mwqmAnalysisReportParameterLast.MWQMAnalysisReportParameterID, mwqmAnalysisReportParameterRet.MWQMAnalysisReportParameterID);
BadRequestErrorMessageResult badRequest = jsonRet as BadRequestErrorMessageResult;
Assert.IsNull(badRequest);
// Put to return success
IHttpActionResult jsonRet2 = mwqmAnalysisReportParameterController.Put(mwqmAnalysisReportParameterRet, LanguageRequest.ToString());
Assert.IsNotNull(jsonRet2);
OkNegotiatedContentResult <MWQMAnalysisReportParameter> mwqmAnalysisReportParameterRet2 = jsonRet2 as OkNegotiatedContentResult <MWQMAnalysisReportParameter>;
Assert.IsNotNull(mwqmAnalysisReportParameterRet2);
BadRequestErrorMessageResult badRequest2 = jsonRet2 as BadRequestErrorMessageResult;
Assert.IsNull(badRequest2);
// Put to return CSSPError because MWQMAnalysisReportParameterID of 0 does not exist
mwqmAnalysisReportParameterRet.MWQMAnalysisReportParameterID = 0;
IHttpActionResult jsonRet3 = mwqmAnalysisReportParameterController.Put(mwqmAnalysisReportParameterRet, LanguageRequest.ToString());
Assert.IsNotNull(jsonRet3);
OkNegotiatedContentResult <MWQMAnalysisReportParameter> mwqmAnalysisReportParameterRet3 = jsonRet3 as OkNegotiatedContentResult <MWQMAnalysisReportParameter>;
Assert.IsNull(mwqmAnalysisReportParameterRet3);
BadRequestErrorMessageResult badRequest3 = jsonRet3 as BadRequestErrorMessageResult;
Assert.IsNotNull(badRequest3);
}
}
}
public IHttpActionResult GetMWQMAnalysisReportParameterWithID([FromUri] int MWQMAnalysisReportParameterID, [FromUri] string lang = "en", [FromUri] string extra = "")
{
using (CSSPDBContext db = new CSSPDBContext(DatabaseType))
{
MWQMAnalysisReportParameterService mwqmAnalysisReportParameterService = new MWQMAnalysisReportParameterService(new Query()
{
Language = (lang == "fr" ? LanguageEnum.fr : LanguageEnum.en)
}, db, ContactID);
mwqmAnalysisReportParameterService.Query = mwqmAnalysisReportParameterService.FillQuery(typeof(MWQMAnalysisReportParameter), lang, 0, 1, "", "", extra);
if (mwqmAnalysisReportParameterService.Query.Extra == "A")
{
MWQMAnalysisReportParameterExtraA mwqmAnalysisReportParameterExtraA = new MWQMAnalysisReportParameterExtraA();
mwqmAnalysisReportParameterExtraA = mwqmAnalysisReportParameterService.GetMWQMAnalysisReportParameterExtraAWithMWQMAnalysisReportParameterID(MWQMAnalysisReportParameterID);
if (mwqmAnalysisReportParameterExtraA == null)
{
return(NotFound());
}
return(Ok(mwqmAnalysisReportParameterExtraA));
}
else if (mwqmAnalysisReportParameterService.Query.Extra == "B")
{
MWQMAnalysisReportParameterExtraB mwqmAnalysisReportParameterExtraB = new MWQMAnalysisReportParameterExtraB();
mwqmAnalysisReportParameterExtraB = mwqmAnalysisReportParameterService.GetMWQMAnalysisReportParameterExtraBWithMWQMAnalysisReportParameterID(MWQMAnalysisReportParameterID);
if (mwqmAnalysisReportParameterExtraB == null)
{
return(NotFound());
}
return(Ok(mwqmAnalysisReportParameterExtraB));
}
else
{
MWQMAnalysisReportParameter mwqmAnalysisReportParameter = new MWQMAnalysisReportParameter();
mwqmAnalysisReportParameter = mwqmAnalysisReportParameterService.GetMWQMAnalysisReportParameterWithMWQMAnalysisReportParameterID(MWQMAnalysisReportParameterID);
if (mwqmAnalysisReportParameter == null)
{
return(NotFound());
}
return(Ok(mwqmAnalysisReportParameter));
}
}
}
/// <summary>
/// Tries to execute the CSSPDB transaction (add/delete/update) on an [MWQMAnalysisReportParameter](CSSPModels.MWQMAnalysisReportParameter.html) item
/// </summary>
/// <param name="mwqmAnalysisReportParameter">Is the MWQMAnalysisReportParameter item the client want to add to CSSPDB. What's important here is the MWQMAnalysisReportParameterID</param>
/// <returns>true if MWQMAnalysisReportParameter item was updated to CSSPDB, false if an error happened during the DB requested transtaction</returns>
private bool TryToSave(MWQMAnalysisReportParameter mwqmAnalysisReportParameter)
{
try
{
db.SaveChanges();
}
catch (DbUpdateException ex)
{
mwqmAnalysisReportParameter.ValidationResults = new List <ValidationResult>()
{
new ValidationResult(ex.Message + (ex.InnerException != null ? " Inner: " + ex.InnerException.Message : ""))
}.AsEnumerable();
return(false);
}
return(true);
}
/// <summary>
/// Updates an [MWQMAnalysisReportParameter](CSSPModels.MWQMAnalysisReportParameter.html) item in CSSPDB
/// </summary>
/// <param name="mwqmAnalysisReportParameter">Is the MWQMAnalysisReportParameter item the client want to add to CSSPDB. What's important here is the MWQMAnalysisReportParameterID</param>
/// <returns>true if MWQMAnalysisReportParameter item was updated to CSSPDB, false if an error happened during the DB requested transtaction</returns>
public bool Update(MWQMAnalysisReportParameter mwqmAnalysisReportParameter)
{
mwqmAnalysisReportParameter.ValidationResults = Validate(new ValidationContext(mwqmAnalysisReportParameter), ActionDBTypeEnum.Update);
if (mwqmAnalysisReportParameter.ValidationResults.Count() > 0)
{
return(false);
}
db.MWQMAnalysisReportParameters.Update(mwqmAnalysisReportParameter);
if (!TryToSave(mwqmAnalysisReportParameter))
{
return(false);
}
return(true);
}
public void MWQMAnalysisReportParameter_Controller_GetMWQMAnalysisReportParameterWithID_Test()
{
foreach (LanguageEnum LanguageRequest in AllowableLanguages)
{
foreach (int ContactID in new List <int>()
{
AdminContactID
}) //, TestEmailValidatedContactID, TestEmailNotValidatedContactID })
{
MWQMAnalysisReportParameterController mwqmAnalysisReportParameterController = new MWQMAnalysisReportParameterController(DatabaseTypeEnum.SqlServerTestDB);
Assert.IsNotNull(mwqmAnalysisReportParameterController);
Assert.AreEqual(DatabaseTypeEnum.SqlServerTestDB, mwqmAnalysisReportParameterController.DatabaseType);
MWQMAnalysisReportParameter mwqmAnalysisReportParameterFirst = new MWQMAnalysisReportParameter();
using (CSSPDBContext db = new CSSPDBContext(DatabaseType))
{
MWQMAnalysisReportParameterService mwqmAnalysisReportParameterService = new MWQMAnalysisReportParameterService(new Query(), db, ContactID);
mwqmAnalysisReportParameterFirst = (from c in db.MWQMAnalysisReportParameters select c).FirstOrDefault();
}
// ok with MWQMAnalysisReportParameter info
IHttpActionResult jsonRet = mwqmAnalysisReportParameterController.GetMWQMAnalysisReportParameterWithID(mwqmAnalysisReportParameterFirst.MWQMAnalysisReportParameterID);
Assert.IsNotNull(jsonRet);
OkNegotiatedContentResult <MWQMAnalysisReportParameter> Ret = jsonRet as OkNegotiatedContentResult <MWQMAnalysisReportParameter>;
MWQMAnalysisReportParameter mwqmAnalysisReportParameterRet = Ret.Content;
Assert.AreEqual(mwqmAnalysisReportParameterFirst.MWQMAnalysisReportParameterID, mwqmAnalysisReportParameterRet.MWQMAnalysisReportParameterID);
BadRequestErrorMessageResult badRequest = jsonRet as BadRequestErrorMessageResult;
Assert.IsNull(badRequest);
// Not Found
IHttpActionResult jsonRet2 = mwqmAnalysisReportParameterController.GetMWQMAnalysisReportParameterWithID(0);
Assert.IsNotNull(jsonRet2);
OkNegotiatedContentResult <MWQMAnalysisReportParameter> mwqmAnalysisReportParameterRet2 = jsonRet2 as OkNegotiatedContentResult <MWQMAnalysisReportParameter>;
Assert.IsNull(mwqmAnalysisReportParameterRet2);
NotFoundResult notFoundRequest = jsonRet2 as NotFoundResult;
Assert.IsNotNull(notFoundRequest);
}
}
}
public IHttpActionResult Delete([FromBody] MWQMAnalysisReportParameter mwqmAnalysisReportParameter, [FromUri] string lang = "en")
{
using (CSSPDBContext db = new CSSPDBContext(DatabaseType))
{
MWQMAnalysisReportParameterService mwqmAnalysisReportParameterService = new MWQMAnalysisReportParameterService(new Query()
{
Language = (lang == "fr" ? LanguageEnum.fr : LanguageEnum.en)
}, db, ContactID);
if (!mwqmAnalysisReportParameterService.Delete(mwqmAnalysisReportParameter))
{
return(BadRequest(String.Join("|||", mwqmAnalysisReportParameter.ValidationResults)));
}
else
{
mwqmAnalysisReportParameter.ValidationResults = null;
return(Ok(mwqmAnalysisReportParameter));
}
}
}
public MWQMAnalysisReportParameterTest()
{
mWQMAnalysisReportParameter = new MWQMAnalysisReportParameter();
mWQMAnalysisReportParameterExtraA = new MWQMAnalysisReportParameterExtraA();
mWQMAnalysisReportParameterExtraB = new MWQMAnalysisReportParameterExtraB();
}
/// <summary>
/// Validate function for all MWQMAnalysisReportParameterService commands
/// </summary>
/// <param name="validationContext">System.ComponentModel.DataAnnotations.ValidationContext (Describes the context in which a validation check is performed.)</param>
/// <param name="actionDBType">[ActionDBTypeEnum] (CSSPEnums.ActionDBTypeEnum.html) action type to validate</param>
/// <returns>IEnumerable of ValidationResult (Where ValidationResult is a container for the results of a validation request.)</returns>
private IEnumerable <ValidationResult> Validate(ValidationContext validationContext, ActionDBTypeEnum actionDBType)
{
string retStr = "";
Enums enums = new Enums(LanguageRequest);
MWQMAnalysisReportParameter mwqmAnalysisReportParameter = validationContext.ObjectInstance as MWQMAnalysisReportParameter;
mwqmAnalysisReportParameter.HasErrors = false;
if (actionDBType == ActionDBTypeEnum.Update || actionDBType == ActionDBTypeEnum.Delete)
{
if (mwqmAnalysisReportParameter.MWQMAnalysisReportParameterID == 0)
{
mwqmAnalysisReportParameter.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._IsRequired, "MWQMAnalysisReportParameterID"), new[] { "MWQMAnalysisReportParameterID" }));
}
if (!(from c in db.MWQMAnalysisReportParameters select c).Where(c => c.MWQMAnalysisReportParameterID == mwqmAnalysisReportParameter.MWQMAnalysisReportParameterID).Any())
{
mwqmAnalysisReportParameter.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes.CouldNotFind_With_Equal_, "MWQMAnalysisReportParameter", "MWQMAnalysisReportParameterID", mwqmAnalysisReportParameter.MWQMAnalysisReportParameterID.ToString()), new[] { "MWQMAnalysisReportParameterID" }));
}
}
TVItem TVItemSubsectorTVItemID = (from c in db.TVItems where c.TVItemID == mwqmAnalysisReportParameter.SubsectorTVItemID select c).FirstOrDefault();
if (TVItemSubsectorTVItemID == null)
{
mwqmAnalysisReportParameter.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes.CouldNotFind_With_Equal_, "TVItem", "SubsectorTVItemID", mwqmAnalysisReportParameter.SubsectorTVItemID.ToString()), new[] { "SubsectorTVItemID" }));
}
else
{
List <TVTypeEnum> AllowableTVTypes = new List <TVTypeEnum>()
{
TVTypeEnum.Subsector,
};
if (!AllowableTVTypes.Contains(TVItemSubsectorTVItemID.TVType))
{
mwqmAnalysisReportParameter.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._IsNotOfType_, "SubsectorTVItemID", "Subsector"), new[] { "SubsectorTVItemID" }));
}
}
if (string.IsNullOrWhiteSpace(mwqmAnalysisReportParameter.AnalysisName))
{
mwqmAnalysisReportParameter.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._IsRequired, "AnalysisName"), new[] { "AnalysisName" }));
}
if (!string.IsNullOrWhiteSpace(mwqmAnalysisReportParameter.AnalysisName) && (mwqmAnalysisReportParameter.AnalysisName.Length < 5 || mwqmAnalysisReportParameter.AnalysisName.Length > 250))
{
mwqmAnalysisReportParameter.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._LengthShouldBeBetween_And_, "AnalysisName", "5", "250"), new[] { "AnalysisName" }));
}
if (mwqmAnalysisReportParameter.AnalysisReportYear != null)
{
if (mwqmAnalysisReportParameter.AnalysisReportYear < 1980 || mwqmAnalysisReportParameter.AnalysisReportYear > 2050)
{
mwqmAnalysisReportParameter.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._ValueShouldBeBetween_And_, "AnalysisReportYear", "1980", "2050"), new[] { "AnalysisReportYear" }));
}
}
if (mwqmAnalysisReportParameter.StartDate.Year == 1)
{
mwqmAnalysisReportParameter.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._IsRequired, "StartDate"), new[] { "StartDate" }));
}
else
{
if (mwqmAnalysisReportParameter.StartDate.Year < 1980)
{
mwqmAnalysisReportParameter.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._YearShouldBeBiggerThan_, "StartDate", "1980"), new[] { "StartDate" }));
}
}
if (mwqmAnalysisReportParameter.EndDate.Year == 1)
{
mwqmAnalysisReportParameter.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._IsRequired, "EndDate"), new[] { "EndDate" }));
}
else
{
if (mwqmAnalysisReportParameter.EndDate.Year < 1980)
{
mwqmAnalysisReportParameter.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._YearShouldBeBiggerThan_, "EndDate", "1980"), new[] { "EndDate" }));
}
}
if (mwqmAnalysisReportParameter.StartDate > mwqmAnalysisReportParameter.EndDate)
{
mwqmAnalysisReportParameter.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._DateIsBiggerThan_, "EndDate", "MWQMAnalysisReportParameterStartDate"), new[] { "EndDate" }));
}
retStr = enums.EnumTypeOK(typeof(AnalysisCalculationTypeEnum), (int?)mwqmAnalysisReportParameter.AnalysisCalculationType);
if (!string.IsNullOrWhiteSpace(retStr))
{
mwqmAnalysisReportParameter.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._IsRequired, "AnalysisCalculationType"), new[] { "AnalysisCalculationType" }));
}
if (mwqmAnalysisReportParameter.NumberOfRuns < 1 || mwqmAnalysisReportParameter.NumberOfRuns > 1000)
{
mwqmAnalysisReportParameter.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._ValueShouldBeBetween_And_, "NumberOfRuns", "1", "1000"), new[] { "NumberOfRuns" }));
}
if (mwqmAnalysisReportParameter.SalinityHighlightDeviationFromAverage < 1 || mwqmAnalysisReportParameter.SalinityHighlightDeviationFromAverage > 20)
{
mwqmAnalysisReportParameter.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._ValueShouldBeBetween_And_, "SalinityHighlightDeviationFromAverage", "1", "20"), new[] { "SalinityHighlightDeviationFromAverage" }));
}
if (mwqmAnalysisReportParameter.ShortRangeNumberOfDays < 0 || mwqmAnalysisReportParameter.ShortRangeNumberOfDays > 5)
{
mwqmAnalysisReportParameter.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._ValueShouldBeBetween_And_, "ShortRangeNumberOfDays", "0", "5"), new[] { "ShortRangeNumberOfDays" }));
}
if (mwqmAnalysisReportParameter.MidRangeNumberOfDays < 2 || mwqmAnalysisReportParameter.MidRangeNumberOfDays > 7)
{
mwqmAnalysisReportParameter.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._ValueShouldBeBetween_And_, "MidRangeNumberOfDays", "2", "7"), new[] { "MidRangeNumberOfDays" }));
}
if (mwqmAnalysisReportParameter.DryLimit24h < 1 || mwqmAnalysisReportParameter.DryLimit24h > 100)
{
mwqmAnalysisReportParameter.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._ValueShouldBeBetween_And_, "DryLimit24h", "1", "100"), new[] { "DryLimit24h" }));
}
if (mwqmAnalysisReportParameter.DryLimit48h < 1 || mwqmAnalysisReportParameter.DryLimit48h > 100)
{
mwqmAnalysisReportParameter.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._ValueShouldBeBetween_And_, "DryLimit48h", "1", "100"), new[] { "DryLimit48h" }));
}
if (mwqmAnalysisReportParameter.DryLimit72h < 1 || mwqmAnalysisReportParameter.DryLimit72h > 100)
{
mwqmAnalysisReportParameter.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._ValueShouldBeBetween_And_, "DryLimit72h", "1", "100"), new[] { "DryLimit72h" }));
}
if (mwqmAnalysisReportParameter.DryLimit96h < 1 || mwqmAnalysisReportParameter.DryLimit96h > 100)
{
mwqmAnalysisReportParameter.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._ValueShouldBeBetween_And_, "DryLimit96h", "1", "100"), new[] { "DryLimit96h" }));
}
if (mwqmAnalysisReportParameter.WetLimit24h < 1 || mwqmAnalysisReportParameter.WetLimit24h > 100)
{
mwqmAnalysisReportParameter.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._ValueShouldBeBetween_And_, "WetLimit24h", "1", "100"), new[] { "WetLimit24h" }));
}
if (mwqmAnalysisReportParameter.WetLimit48h < 1 || mwqmAnalysisReportParameter.WetLimit48h > 100)
{
mwqmAnalysisReportParameter.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._ValueShouldBeBetween_And_, "WetLimit48h", "1", "100"), new[] { "WetLimit48h" }));
}
if (mwqmAnalysisReportParameter.WetLimit72h < 1 || mwqmAnalysisReportParameter.WetLimit72h > 100)
{
mwqmAnalysisReportParameter.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._ValueShouldBeBetween_And_, "WetLimit72h", "1", "100"), new[] { "WetLimit72h" }));
}
if (mwqmAnalysisReportParameter.WetLimit96h < 1 || mwqmAnalysisReportParameter.WetLimit96h > 100)
{
mwqmAnalysisReportParameter.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._ValueShouldBeBetween_And_, "WetLimit96h", "1", "100"), new[] { "WetLimit96h" }));
}
if (string.IsNullOrWhiteSpace(mwqmAnalysisReportParameter.RunsToOmit))
{
mwqmAnalysisReportParameter.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._IsRequired, "RunsToOmit"), new[] { "RunsToOmit" }));
}
if (!string.IsNullOrWhiteSpace(mwqmAnalysisReportParameter.RunsToOmit) && mwqmAnalysisReportParameter.RunsToOmit.Length > 250)
{
mwqmAnalysisReportParameter.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._MaxLengthIs_, "RunsToOmit", "250"), new[] { "RunsToOmit" }));
}
if (!string.IsNullOrWhiteSpace(mwqmAnalysisReportParameter.ShowDataTypes) && mwqmAnalysisReportParameter.ShowDataTypes.Length > 20)
{
mwqmAnalysisReportParameter.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._MaxLengthIs_, "ShowDataTypes", "20"), new[] { "ShowDataTypes" }));
}
if (mwqmAnalysisReportParameter.ExcelTVFileTVItemID != null)
{
TVItem TVItemExcelTVFileTVItemID = (from c in db.TVItems where c.TVItemID == mwqmAnalysisReportParameter.ExcelTVFileTVItemID select c).FirstOrDefault();
if (TVItemExcelTVFileTVItemID == null)
{
mwqmAnalysisReportParameter.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes.CouldNotFind_With_Equal_, "TVItem", "ExcelTVFileTVItemID", (mwqmAnalysisReportParameter.ExcelTVFileTVItemID == null ? "" : mwqmAnalysisReportParameter.ExcelTVFileTVItemID.ToString())), new[] { "ExcelTVFileTVItemID" }));
}
else
{
List <TVTypeEnum> AllowableTVTypes = new List <TVTypeEnum>()
{
TVTypeEnum.File,
};
if (!AllowableTVTypes.Contains(TVItemExcelTVFileTVItemID.TVType))
{
mwqmAnalysisReportParameter.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._IsNotOfType_, "ExcelTVFileTVItemID", "File"), new[] { "ExcelTVFileTVItemID" }));
}
}
}
retStr = enums.EnumTypeOK(typeof(AnalysisReportExportCommandEnum), (int?)mwqmAnalysisReportParameter.Command);
if (!string.IsNullOrWhiteSpace(retStr))
{
mwqmAnalysisReportParameter.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._IsRequired, "Command"), new[] { "Command" }));
}
if (mwqmAnalysisReportParameter.LastUpdateDate_UTC.Year == 1)
{
mwqmAnalysisReportParameter.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._IsRequired, "LastUpdateDate_UTC"), new[] { "LastUpdateDate_UTC" }));
}
else
{
if (mwqmAnalysisReportParameter.LastUpdateDate_UTC.Year < 1980)
{
mwqmAnalysisReportParameter.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._YearShouldBeBiggerThan_, "LastUpdateDate_UTC", "1980"), new[] { "LastUpdateDate_UTC" }));
}
}
TVItem TVItemLastUpdateContactTVItemID = (from c in db.TVItems where c.TVItemID == mwqmAnalysisReportParameter.LastUpdateContactTVItemID select c).FirstOrDefault();
if (TVItemLastUpdateContactTVItemID == null)
{
mwqmAnalysisReportParameter.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes.CouldNotFind_With_Equal_, "TVItem", "LastUpdateContactTVItemID", mwqmAnalysisReportParameter.LastUpdateContactTVItemID.ToString()), new[] { "LastUpdateContactTVItemID" }));
}
else
{
List <TVTypeEnum> AllowableTVTypes = new List <TVTypeEnum>()
{
TVTypeEnum.Contact,
};
if (!AllowableTVTypes.Contains(TVItemLastUpdateContactTVItemID.TVType))
{
mwqmAnalysisReportParameter.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._IsNotOfType_, "LastUpdateContactTVItemID", "Contact"), new[] { "LastUpdateContactTVItemID" }));
}
}
retStr = ""; // added to stop compiling CSSPError
if (retStr != "") // will never be true
{
mwqmAnalysisReportParameter.HasErrors = true;
yield return(new ValidationResult("AAA", new[] { "AAA" }));
}
}
public void MWQMAnalysisReportParameter_Controller_GetMWQMAnalysisReportParameterList_Test()
{
foreach (LanguageEnum LanguageRequest in AllowableLanguages)
{
foreach (int ContactID in new List <int>()
{
AdminContactID
}) //, TestEmailValidatedContactID, TestEmailNotValidatedContactID })
{
MWQMAnalysisReportParameterController mwqmAnalysisReportParameterController = new MWQMAnalysisReportParameterController(DatabaseTypeEnum.SqlServerTestDB);
Assert.IsNotNull(mwqmAnalysisReportParameterController);
Assert.AreEqual(DatabaseTypeEnum.SqlServerTestDB, mwqmAnalysisReportParameterController.DatabaseType);
MWQMAnalysisReportParameter mwqmAnalysisReportParameterFirst = new MWQMAnalysisReportParameter();
int count = -1;
Query query = new Query();
using (CSSPDBContext db = new CSSPDBContext(DatabaseTypeEnum.SqlServerTestDB))
{
MWQMAnalysisReportParameterService mwqmAnalysisReportParameterService = new MWQMAnalysisReportParameterService(query, db, ContactID);
mwqmAnalysisReportParameterFirst = (from c in db.MWQMAnalysisReportParameters select c).FirstOrDefault();
count = (from c in db.MWQMAnalysisReportParameters select c).Count();
count = (query.Take > count ? count : query.Take);
}
// ok with MWQMAnalysisReportParameter info
IHttpActionResult jsonRet = mwqmAnalysisReportParameterController.GetMWQMAnalysisReportParameterList();
Assert.IsNotNull(jsonRet);
OkNegotiatedContentResult <List <MWQMAnalysisReportParameter> > ret = jsonRet as OkNegotiatedContentResult <List <MWQMAnalysisReportParameter> >;
Assert.AreEqual(mwqmAnalysisReportParameterFirst.MWQMAnalysisReportParameterID, ret.Content[0].MWQMAnalysisReportParameterID);
Assert.AreEqual((count > query.Take ? query.Take : count), ret.Content.Count);
List <MWQMAnalysisReportParameter> mwqmAnalysisReportParameterList = new List <MWQMAnalysisReportParameter>();
count = -1;
query = new Query();
using (CSSPDBContext db = new CSSPDBContext(DatabaseTypeEnum.SqlServerTestDB))
{
MWQMAnalysisReportParameterService mwqmAnalysisReportParameterService = new MWQMAnalysisReportParameterService(query, db, ContactID);
mwqmAnalysisReportParameterList = (from c in db.MWQMAnalysisReportParameters select c).OrderBy(c => c.MWQMAnalysisReportParameterID).Skip(0).Take(2).ToList();
count = (from c in db.MWQMAnalysisReportParameters select c).Count();
}
if (count > 0)
{
query.Skip = 0;
query.Take = 5;
count = (query.Take > count ? query.Take : count);
// ok with MWQMAnalysisReportParameter info
jsonRet = mwqmAnalysisReportParameterController.GetMWQMAnalysisReportParameterList(query.Language.ToString(), query.Skip, query.Take);
Assert.IsNotNull(jsonRet);
ret = jsonRet as OkNegotiatedContentResult <List <MWQMAnalysisReportParameter> >;
Assert.AreEqual(mwqmAnalysisReportParameterList[0].MWQMAnalysisReportParameterID, ret.Content[0].MWQMAnalysisReportParameterID);
Assert.AreEqual((count > query.Take ? query.Take : count), ret.Content.Count);
if (count > 1)
{
query.Skip = 1;
query.Take = 5;
count = (query.Take > count ? query.Take : count);
// ok with MWQMAnalysisReportParameter info
IHttpActionResult jsonRet2 = mwqmAnalysisReportParameterController.GetMWQMAnalysisReportParameterList(query.Language.ToString(), query.Skip, query.Take);
Assert.IsNotNull(jsonRet2);
OkNegotiatedContentResult <List <MWQMAnalysisReportParameter> > ret2 = jsonRet2 as OkNegotiatedContentResult <List <MWQMAnalysisReportParameter> >;
Assert.AreEqual(mwqmAnalysisReportParameterList[1].MWQMAnalysisReportParameterID, ret2.Content[0].MWQMAnalysisReportParameterID);
Assert.AreEqual((count > query.Take ? query.Take : count), ret2.Content.Count);
}
}
}
}
}
public void MWQMAnalysisReportParameter_Controller_Post_Test()
{
foreach (LanguageEnum LanguageRequest in AllowableLanguages)
{
foreach (int ContactID in new List <int>()
{
AdminContactID
}) //, TestEmailValidatedContactID, TestEmailNotValidatedContactID })
{
MWQMAnalysisReportParameterController mwqmAnalysisReportParameterController = new MWQMAnalysisReportParameterController(DatabaseTypeEnum.SqlServerTestDB);
Assert.IsNotNull(mwqmAnalysisReportParameterController);
Assert.AreEqual(DatabaseTypeEnum.SqlServerTestDB, mwqmAnalysisReportParameterController.DatabaseType);
MWQMAnalysisReportParameter mwqmAnalysisReportParameterLast = new MWQMAnalysisReportParameter();
using (CSSPDBContext db = new CSSPDBContext(DatabaseType))
{
Query query = new Query();
query.Language = LanguageRequest;
query.Asc = "";
query.Desc = "";
MWQMAnalysisReportParameterService mwqmAnalysisReportParameterService = new MWQMAnalysisReportParameterService(query, db, ContactID);
mwqmAnalysisReportParameterLast = (from c in db.MWQMAnalysisReportParameters select c).FirstOrDefault();
}
// ok with MWQMAnalysisReportParameter info
IHttpActionResult jsonRet = mwqmAnalysisReportParameterController.GetMWQMAnalysisReportParameterWithID(mwqmAnalysisReportParameterLast.MWQMAnalysisReportParameterID);
Assert.IsNotNull(jsonRet);
OkNegotiatedContentResult <MWQMAnalysisReportParameter> Ret = jsonRet as OkNegotiatedContentResult <MWQMAnalysisReportParameter>;
MWQMAnalysisReportParameter mwqmAnalysisReportParameterRet = Ret.Content;
Assert.AreEqual(mwqmAnalysisReportParameterLast.MWQMAnalysisReportParameterID, mwqmAnalysisReportParameterRet.MWQMAnalysisReportParameterID);
BadRequestErrorMessageResult badRequest = jsonRet as BadRequestErrorMessageResult;
Assert.IsNull(badRequest);
// Post to return CSSPError because MWQMAnalysisReportParameterID exist
IHttpActionResult jsonRet2 = mwqmAnalysisReportParameterController.Post(mwqmAnalysisReportParameterRet, LanguageRequest.ToString());
Assert.IsNotNull(jsonRet2);
OkNegotiatedContentResult <MWQMAnalysisReportParameter> mwqmAnalysisReportParameterRet2 = jsonRet2 as OkNegotiatedContentResult <MWQMAnalysisReportParameter>;
Assert.IsNull(mwqmAnalysisReportParameterRet2);
BadRequestErrorMessageResult badRequest2 = jsonRet2 as BadRequestErrorMessageResult;
Assert.IsNotNull(badRequest2);
// Post to return newly added MWQMAnalysisReportParameter
mwqmAnalysisReportParameterRet.MWQMAnalysisReportParameterID = 0;
mwqmAnalysisReportParameterController.Request = new System.Net.Http.HttpRequestMessage();
mwqmAnalysisReportParameterController.Request.RequestUri = new System.Uri("http://localhost:5000/api/mwqmAnalysisReportParameter");
IHttpActionResult jsonRet3 = mwqmAnalysisReportParameterController.Post(mwqmAnalysisReportParameterRet, LanguageRequest.ToString());
Assert.IsNotNull(jsonRet3);
CreatedNegotiatedContentResult <MWQMAnalysisReportParameter> mwqmAnalysisReportParameterRet3 = jsonRet3 as CreatedNegotiatedContentResult <MWQMAnalysisReportParameter>;
Assert.IsNotNull(mwqmAnalysisReportParameterRet3);
BadRequestErrorMessageResult badRequest3 = jsonRet3 as BadRequestErrorMessageResult;
Assert.IsNull(badRequest3);
IHttpActionResult jsonRet4 = mwqmAnalysisReportParameterController.Delete(mwqmAnalysisReportParameterRet, LanguageRequest.ToString());
Assert.IsNotNull(jsonRet4);
OkNegotiatedContentResult <MWQMAnalysisReportParameter> mwqmAnalysisReportParameterRet4 = jsonRet4 as OkNegotiatedContentResult <MWQMAnalysisReportParameter>;
Assert.IsNotNull(mwqmAnalysisReportParameterRet4);
BadRequestErrorMessageResult badRequest4 = jsonRet4 as BadRequestErrorMessageResult;
Assert.IsNull(badRequest4);
}
}
}
