private PolSourceSiteEffect GetFilledRandomPolSourceSiteEffect(string OmitPropName)
{
PolSourceSiteEffect polSourceSiteEffect = new PolSourceSiteEffect();
if (OmitPropName != "PolSourceSiteOrInfrastructureTVItemID")
{
polSourceSiteEffect.PolSourceSiteOrInfrastructureTVItemID = 41;
}
if (OmitPropName != "MWQMSiteTVItemID")
{
polSourceSiteEffect.MWQMSiteTVItemID = 44;
}
if (OmitPropName != "PolSourceSiteEffectTermIDs")
{
polSourceSiteEffect.PolSourceSiteEffectTermIDs = GetRandomString("", 5);
}
if (OmitPropName != "Comments")
{
polSourceSiteEffect.Comments = GetRandomString("", 20);
}
if (OmitPropName != "AnalysisDocumentTVItemID")
{
polSourceSiteEffect.AnalysisDocumentTVItemID = 42;
}
if (OmitPropName != "LastUpdateDate_UTC")
{
polSourceSiteEffect.LastUpdateDate_UTC = new DateTime(2005, 3, 6);
}
if (OmitPropName != "LastUpdateContactTVItemID")
{
polSourceSiteEffect.LastUpdateContactTVItemID = 2;
}
return(polSourceSiteEffect);
}
public PolSourceSiteEffectModel PostDeletePolSourceSiteEffectDB(int PolSourceSiteEffectID)
{
ContactOK contactOK = IsContactOK();
if (!string.IsNullOrEmpty(contactOK.Error))
{
return(ReturnError(contactOK.Error));
}
PolSourceSiteEffect polSourceSiteEffectToDelete = GetPolSourceSiteEffectWithPolSourceSiteEffectIDDB(PolSourceSiteEffectID);
if (polSourceSiteEffectToDelete == null)
{
return(ReturnError(string.Format(ServiceRes.CouldNotFind_ToDelete, ServiceRes.PolSourceSiteEffect)));
}
using (TransactionScope ts = new TransactionScope())
{
db.PolSourceSiteEffects.Remove(polSourceSiteEffectToDelete);
string retStr = DoDeleteChanges();
if (!string.IsNullOrWhiteSpace(retStr))
{
return(ReturnError(retStr));
}
LogModel logModel = _LogService.PostAddLogForObj("PolSourceSiteEffects", polSourceSiteEffectToDelete.PolSourceSiteEffectID, LogCommandEnum.Delete, polSourceSiteEffectToDelete);
if (!string.IsNullOrWhiteSpace(logModel.Error))
{
return(ReturnError(logModel.Error));
}
ts.Complete();
}
return(ReturnError(""));
}
public PolSourceSiteEffect GetPolSourceSiteEffectWithPolSourceSiteEffectIDDB(int PolSourceSiteEffectID)
{
PolSourceSiteEffect polSourceSiteEffect = (from c in db.PolSourceSiteEffects
where c.PolSourceSiteEffectID == PolSourceSiteEffectID
select c).FirstOrDefault <PolSourceSiteEffect>();
return(polSourceSiteEffect);
}
public void PolSourceSiteEffect_Controller_Put_Test()
{
foreach (LanguageEnum LanguageRequest in AllowableLanguages)
{
foreach (int ContactID in new List <int>()
{
AdminContactID
}) //, TestEmailValidatedContactID, TestEmailNotValidatedContactID })
{
PolSourceSiteEffectController polSourceSiteEffectController = new PolSourceSiteEffectController(DatabaseTypeEnum.SqlServerTestDB);
Assert.IsNotNull(polSourceSiteEffectController);
Assert.AreEqual(DatabaseTypeEnum.SqlServerTestDB, polSourceSiteEffectController.DatabaseType);
PolSourceSiteEffect polSourceSiteEffectLast = new PolSourceSiteEffect();
using (CSSPDBContext db = new CSSPDBContext(DatabaseType))
{
Query query = new Query();
query.Language = LanguageRequest;
PolSourceSiteEffectService polSourceSiteEffectService = new PolSourceSiteEffectService(query, db, ContactID);
polSourceSiteEffectLast = (from c in db.PolSourceSiteEffects select c).FirstOrDefault();
}
// ok with PolSourceSiteEffect info
IHttpActionResult jsonRet = polSourceSiteEffectController.GetPolSourceSiteEffectWithID(polSourceSiteEffectLast.PolSourceSiteEffectID);
Assert.IsNotNull(jsonRet);
OkNegotiatedContentResult <PolSourceSiteEffect> Ret = jsonRet as OkNegotiatedContentResult <PolSourceSiteEffect>;
PolSourceSiteEffect polSourceSiteEffectRet = Ret.Content;
Assert.AreEqual(polSourceSiteEffectLast.PolSourceSiteEffectID, polSourceSiteEffectRet.PolSourceSiteEffectID);
BadRequestErrorMessageResult badRequest = jsonRet as BadRequestErrorMessageResult;
Assert.IsNull(badRequest);
// Put to return success
IHttpActionResult jsonRet2 = polSourceSiteEffectController.Put(polSourceSiteEffectRet, LanguageRequest.ToString());
Assert.IsNotNull(jsonRet2);
OkNegotiatedContentResult <PolSourceSiteEffect> polSourceSiteEffectRet2 = jsonRet2 as OkNegotiatedContentResult <PolSourceSiteEffect>;
Assert.IsNotNull(polSourceSiteEffectRet2);
BadRequestErrorMessageResult badRequest2 = jsonRet2 as BadRequestErrorMessageResult;
Assert.IsNull(badRequest2);
// Put to return CSSPError because PolSourceSiteEffectID of 0 does not exist
polSourceSiteEffectRet.PolSourceSiteEffectID = 0;
IHttpActionResult jsonRet3 = polSourceSiteEffectController.Put(polSourceSiteEffectRet, LanguageRequest.ToString());
Assert.IsNotNull(jsonRet3);
OkNegotiatedContentResult <PolSourceSiteEffect> polSourceSiteEffectRet3 = jsonRet3 as OkNegotiatedContentResult <PolSourceSiteEffect>;
Assert.IsNull(polSourceSiteEffectRet3);
BadRequestErrorMessageResult badRequest3 = jsonRet3 as BadRequestErrorMessageResult;
Assert.IsNotNull(badRequest3);
}
}
}
public void PolSourceSiteEffect_CRUD_Test()
{
foreach (CultureInfo culture in AllowableCulture)
{
ChangeCulture(culture);
using (CSSPDBContext dbTestDB = new CSSPDBContext(DatabaseTypeEnum.SqlServerTestDB))
{
PolSourceSiteEffectService polSourceSiteEffectService = new PolSourceSiteEffectService(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]
}
PolSourceSiteEffect polSourceSiteEffect = GetFilledRandomPolSourceSiteEffect("");
// -------------------------------
// -------------------------------
// CRUD testing
// -------------------------------
// -------------------------------
count = polSourceSiteEffectService.GetPolSourceSiteEffectList().Count();
Assert.AreEqual(count, (from c in dbTestDB.PolSourceSiteEffects select c).Count());
polSourceSiteEffectService.Add(polSourceSiteEffect);
if (polSourceSiteEffect.HasErrors)
{
Assert.AreEqual("", polSourceSiteEffect.ValidationResults.FirstOrDefault().ErrorMessage);
}
Assert.AreEqual(true, polSourceSiteEffectService.GetPolSourceSiteEffectList().Where(c => c == polSourceSiteEffect).Any());
polSourceSiteEffectService.Update(polSourceSiteEffect);
if (polSourceSiteEffect.HasErrors)
{
Assert.AreEqual("", polSourceSiteEffect.ValidationResults.FirstOrDefault().ErrorMessage);
}
Assert.AreEqual(count + 1, polSourceSiteEffectService.GetPolSourceSiteEffectList().Count());
polSourceSiteEffectService.Delete(polSourceSiteEffect);
if (polSourceSiteEffect.HasErrors)
{
Assert.AreEqual("", polSourceSiteEffect.ValidationResults.FirstOrDefault().ErrorMessage);
}
Assert.AreEqual(count, polSourceSiteEffectService.GetPolSourceSiteEffectList().Count());
}
}
}
private bool TryToSave(PolSourceSiteEffect polSourceSiteEffect)
{
try
{
db.SaveChanges();
}
catch (DbUpdateException ex)
{
polSourceSiteEffect.ValidationResults = new List <ValidationResult>()
{
new ValidationResult(ex.Message + (ex.InnerException != null ? " Inner: " + ex.InnerException.Message : ""))
}.AsEnumerable();
return(false);
}
return(true);
}
public bool Update(PolSourceSiteEffect polSourceSiteEffect)
{
polSourceSiteEffect.ValidationResults = Validate(new ValidationContext(polSourceSiteEffect), ActionDBTypeEnum.Update);
if (polSourceSiteEffect.ValidationResults.Count() > 0)
{
return(false);
}
db.PolSourceSiteEffects.Update(polSourceSiteEffect);
if (!TryToSave(polSourceSiteEffect))
{
return(false);
}
return(true);
}
public void PolSourceSiteEffect_Controller_GetPolSourceSiteEffectWithID_Test()
{
foreach (LanguageEnum LanguageRequest in AllowableLanguages)
{
foreach (int ContactID in new List <int>()
{
AdminContactID
}) //, TestEmailValidatedContactID, TestEmailNotValidatedContactID })
{
PolSourceSiteEffectController polSourceSiteEffectController = new PolSourceSiteEffectController(DatabaseTypeEnum.SqlServerTestDB);
Assert.IsNotNull(polSourceSiteEffectController);
Assert.AreEqual(DatabaseTypeEnum.SqlServerTestDB, polSourceSiteEffectController.DatabaseType);
PolSourceSiteEffect polSourceSiteEffectFirst = new PolSourceSiteEffect();
using (CSSPDBContext db = new CSSPDBContext(DatabaseType))
{
PolSourceSiteEffectService polSourceSiteEffectService = new PolSourceSiteEffectService(new Query(), db, ContactID);
polSourceSiteEffectFirst = (from c in db.PolSourceSiteEffects select c).FirstOrDefault();
}
// ok with PolSourceSiteEffect info
IHttpActionResult jsonRet = polSourceSiteEffectController.GetPolSourceSiteEffectWithID(polSourceSiteEffectFirst.PolSourceSiteEffectID);
Assert.IsNotNull(jsonRet);
OkNegotiatedContentResult <PolSourceSiteEffect> Ret = jsonRet as OkNegotiatedContentResult <PolSourceSiteEffect>;
PolSourceSiteEffect polSourceSiteEffectRet = Ret.Content;
Assert.AreEqual(polSourceSiteEffectFirst.PolSourceSiteEffectID, polSourceSiteEffectRet.PolSourceSiteEffectID);
BadRequestErrorMessageResult badRequest = jsonRet as BadRequestErrorMessageResult;
Assert.IsNull(badRequest);
// Not Found
IHttpActionResult jsonRet2 = polSourceSiteEffectController.GetPolSourceSiteEffectWithID(0);
Assert.IsNotNull(jsonRet2);
OkNegotiatedContentResult <PolSourceSiteEffect> polSourceSiteEffectRet2 = jsonRet2 as OkNegotiatedContentResult <PolSourceSiteEffect>;
Assert.IsNull(polSourceSiteEffectRet2);
NotFoundResult notFoundRequest = jsonRet2 as NotFoundResult;
Assert.IsNotNull(notFoundRequest);
}
}
}
// Fill
public string FillPolSourceSiteEffect(PolSourceSiteEffect polSourceSiteEffect, PolSourceSiteEffectModel polSourceSiteEffectModel, ContactOK contactOK)
{
polSourceSiteEffect.DBCommand = (int)polSourceSiteEffectModel.DBCommand;
polSourceSiteEffect.PolSourceSiteOrInfrastructureTVItemID = polSourceSiteEffectModel.PolSourceSiteOrInfrastructureTVItemID;
polSourceSiteEffect.MWQMSiteTVItemID = polSourceSiteEffectModel.MWQMSiteTVItemID;
polSourceSiteEffect.PolSourceSiteEffectTermIDs = polSourceSiteEffectModel.PolSourceSiteEffectTermIDs;
polSourceSiteEffect.Comments = polSourceSiteEffectModel.Comments;
polSourceSiteEffect.AnalysisDocumentTVItemID = polSourceSiteEffectModel.AnalysisDocumentTVItemID;
polSourceSiteEffect.LastUpdateDate_UTC = DateTime.UtcNow;
if (contactOK == null)
{
polSourceSiteEffect.LastUpdateContactTVItemID = 2;
}
else
{
polSourceSiteEffect.LastUpdateContactTVItemID = contactOK.ContactTVItemID;
}
return("");
}
public void GetPolSourceSiteEffectList_Test()
{
foreach (CultureInfo culture in AllowableCulture)
{
ChangeCulture(culture);
using (CSSPDBContext dbTestDB = new CSSPDBContext(DatabaseTypeEnum.SqlServerTestDB))
{
PolSourceSiteEffectService polSourceSiteEffectService = new PolSourceSiteEffectService(new Query()
{
Lang = culture.TwoLetterISOLanguageName
}, dbTestDB, ContactID);
PolSourceSiteEffect polSourceSiteEffect = (from c in dbTestDB.PolSourceSiteEffects select c).FirstOrDefault();
Assert.IsNotNull(polSourceSiteEffect);
List <PolSourceSiteEffect> polSourceSiteEffectDirectQueryList = new List <PolSourceSiteEffect>();
polSourceSiteEffectDirectQueryList = (from c in dbTestDB.PolSourceSiteEffects select c).Take(200).ToList();
foreach (string extra in new List <string>()
{
null, "A", "B", "C", "D", "E"
})
{
polSourceSiteEffectService.Query.Extra = extra;
if (string.IsNullOrWhiteSpace(extra))
{
List <PolSourceSiteEffect> polSourceSiteEffectList = new List <PolSourceSiteEffect>();
polSourceSiteEffectList = polSourceSiteEffectService.GetPolSourceSiteEffectList().ToList();
CheckPolSourceSiteEffectFields(polSourceSiteEffectList);
}
else
{
//Assert.AreEqual(true, false);
}
}
}
}
}
private IEnumerable <ValidationResult> Validate(ValidationContext validationContext, ActionDBTypeEnum actionDBType)
{
string retStr = "";
Enums enums = new Enums(LanguageRequest);
PolSourceSiteEffect polSourceSiteEffect = validationContext.ObjectInstance as PolSourceSiteEffect;
polSourceSiteEffect.HasErrors = false;
if (actionDBType == ActionDBTypeEnum.Update || actionDBType == ActionDBTypeEnum.Delete)
{
if (polSourceSiteEffect.PolSourceSiteEffectID == 0)
{
polSourceSiteEffect.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._IsRequired, "PolSourceSiteEffectID"), new[] { "PolSourceSiteEffectID" }));
}
if (!(from c in db.PolSourceSiteEffects select c).Where(c => c.PolSourceSiteEffectID == polSourceSiteEffect.PolSourceSiteEffectID).Any())
{
polSourceSiteEffect.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes.CouldNotFind_With_Equal_, "PolSourceSiteEffect", "PolSourceSiteEffectID", polSourceSiteEffect.PolSourceSiteEffectID.ToString()), new[] { "PolSourceSiteEffectID" }));
}
}
TVItem TVItemPolSourceSiteOrInfrastructureTVItemID = (from c in db.TVItems where c.TVItemID == polSourceSiteEffect.PolSourceSiteOrInfrastructureTVItemID select c).FirstOrDefault();
if (TVItemPolSourceSiteOrInfrastructureTVItemID == null)
{
polSourceSiteEffect.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes.CouldNotFind_With_Equal_, "TVItem", "PolSourceSiteOrInfrastructureTVItemID", polSourceSiteEffect.PolSourceSiteOrInfrastructureTVItemID.ToString()), new[] { "PolSourceSiteOrInfrastructureTVItemID" }));
}
else
{
List <TVTypeEnum> AllowableTVTypes = new List <TVTypeEnum>()
{
TVTypeEnum.Infrastructure,
TVTypeEnum.PolSourceSite,
};
if (!AllowableTVTypes.Contains(TVItemPolSourceSiteOrInfrastructureTVItemID.TVType))
{
polSourceSiteEffect.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._IsNotOfType_, "PolSourceSiteOrInfrastructureTVItemID", "Infrastructure,PolSourceSite"), new[] { "PolSourceSiteOrInfrastructureTVItemID" }));
}
}
TVItem TVItemMWQMSiteTVItemID = (from c in db.TVItems where c.TVItemID == polSourceSiteEffect.MWQMSiteTVItemID select c).FirstOrDefault();
if (TVItemMWQMSiteTVItemID == null)
{
polSourceSiteEffect.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes.CouldNotFind_With_Equal_, "TVItem", "MWQMSiteTVItemID", polSourceSiteEffect.MWQMSiteTVItemID.ToString()), new[] { "MWQMSiteTVItemID" }));
}
else
{
List <TVTypeEnum> AllowableTVTypes = new List <TVTypeEnum>()
{
TVTypeEnum.MWQMSite,
};
if (!AllowableTVTypes.Contains(TVItemMWQMSiteTVItemID.TVType))
{
polSourceSiteEffect.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._IsNotOfType_, "MWQMSiteTVItemID", "MWQMSite"), new[] { "MWQMSiteTVItemID" }));
}
}
if (!string.IsNullOrWhiteSpace(polSourceSiteEffect.PolSourceSiteEffectTermIDs) && polSourceSiteEffect.PolSourceSiteEffectTermIDs.Length > 250)
{
polSourceSiteEffect.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._MaxLengthIs_, "PolSourceSiteEffectTermIDs", "250"), new[] { "PolSourceSiteEffectTermIDs" }));
}
//Comments has no StringLength Attribute
if (polSourceSiteEffect.AnalysisDocumentTVItemID != null)
{
TVItem TVItemAnalysisDocumentTVItemID = (from c in db.TVItems where c.TVItemID == polSourceSiteEffect.AnalysisDocumentTVItemID select c).FirstOrDefault();
if (TVItemAnalysisDocumentTVItemID == null)
{
polSourceSiteEffect.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes.CouldNotFind_With_Equal_, "TVItem", "AnalysisDocumentTVItemID", (polSourceSiteEffect.AnalysisDocumentTVItemID == null ? "" : polSourceSiteEffect.AnalysisDocumentTVItemID.ToString())), new[] { "AnalysisDocumentTVItemID" }));
}
else
{
List <TVTypeEnum> AllowableTVTypes = new List <TVTypeEnum>()
{
TVTypeEnum.File,
};
if (!AllowableTVTypes.Contains(TVItemAnalysisDocumentTVItemID.TVType))
{
polSourceSiteEffect.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._IsNotOfType_, "AnalysisDocumentTVItemID", "File"), new[] { "AnalysisDocumentTVItemID" }));
}
}
}
if (polSourceSiteEffect.LastUpdateDate_UTC.Year == 1)
{
polSourceSiteEffect.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._IsRequired, "LastUpdateDate_UTC"), new[] { "LastUpdateDate_UTC" }));
}
else
{
if (polSourceSiteEffect.LastUpdateDate_UTC.Year < 1980)
{
polSourceSiteEffect.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 == polSourceSiteEffect.LastUpdateContactTVItemID select c).FirstOrDefault();
if (TVItemLastUpdateContactTVItemID == null)
{
polSourceSiteEffect.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes.CouldNotFind_With_Equal_, "TVItem", "LastUpdateContactTVItemID", polSourceSiteEffect.LastUpdateContactTVItemID.ToString()), new[] { "LastUpdateContactTVItemID" }));
}
else
{
List <TVTypeEnum> AllowableTVTypes = new List <TVTypeEnum>()
{
TVTypeEnum.Contact,
};
if (!AllowableTVTypes.Contains(TVItemLastUpdateContactTVItemID.TVType))
{
polSourceSiteEffect.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
{
polSourceSiteEffect.HasErrors = true;
yield return(new ValidationResult("AAA", new[] { "AAA" }));
}
}
public void PolSourceSiteEffect_Properties_Test()
{
foreach (CultureInfo culture in AllowableCulture)
{
ChangeCulture(culture);
using (CSSPDBContext dbTestDB = new CSSPDBContext(DatabaseTypeEnum.SqlServerTestDB))
{
PolSourceSiteEffectService polSourceSiteEffectService = new PolSourceSiteEffectService(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 = polSourceSiteEffectService.GetPolSourceSiteEffectList().Count();
PolSourceSiteEffect polSourceSiteEffect = GetFilledRandomPolSourceSiteEffect("");
// -------------------------------
// -------------------------------
// Properties testing
// -------------------------------
// -------------------------------
// -----------------------------------
// [Key]
// Is NOT Nullable
// polSourceSiteEffect.PolSourceSiteEffectID (Int32)
// -----------------------------------
polSourceSiteEffect = null;
polSourceSiteEffect = GetFilledRandomPolSourceSiteEffect("");
polSourceSiteEffect.PolSourceSiteEffectID = 0;
polSourceSiteEffectService.Update(polSourceSiteEffect);
Assert.AreEqual(string.Format(CSSPServicesRes._IsRequired, "PolSourceSiteEffectID"), polSourceSiteEffect.ValidationResults.FirstOrDefault().ErrorMessage);
polSourceSiteEffect = null;
polSourceSiteEffect = GetFilledRandomPolSourceSiteEffect("");
polSourceSiteEffect.PolSourceSiteEffectID = 10000000;
polSourceSiteEffectService.Update(polSourceSiteEffect);
Assert.AreEqual(string.Format(CSSPServicesRes.CouldNotFind_With_Equal_, "PolSourceSiteEffect", "PolSourceSiteEffectID", polSourceSiteEffect.PolSourceSiteEffectID.ToString()), polSourceSiteEffect.ValidationResults.FirstOrDefault().ErrorMessage);
// -----------------------------------
// Is NOT Nullable
// [CSSPExist(ExistTypeName = "TVItem", ExistPlurial = "s", ExistFieldID = "TVItemID", AllowableTVtypeList = Infrastructure,PolSourceSite)]
// polSourceSiteEffect.PolSourceSiteOrInfrastructureTVItemID (Int32)
// -----------------------------------
polSourceSiteEffect = null;
polSourceSiteEffect = GetFilledRandomPolSourceSiteEffect("");
polSourceSiteEffect.PolSourceSiteOrInfrastructureTVItemID = 0;
polSourceSiteEffectService.Add(polSourceSiteEffect);
Assert.AreEqual(string.Format(CSSPServicesRes.CouldNotFind_With_Equal_, "TVItem", "PolSourceSiteOrInfrastructureTVItemID", polSourceSiteEffect.PolSourceSiteOrInfrastructureTVItemID.ToString()), polSourceSiteEffect.ValidationResults.FirstOrDefault().ErrorMessage);
polSourceSiteEffect = null;
polSourceSiteEffect = GetFilledRandomPolSourceSiteEffect("");
polSourceSiteEffect.PolSourceSiteOrInfrastructureTVItemID = 1;
polSourceSiteEffectService.Add(polSourceSiteEffect);
Assert.AreEqual(string.Format(CSSPServicesRes._IsNotOfType_, "PolSourceSiteOrInfrastructureTVItemID", "Infrastructure,PolSourceSite"), polSourceSiteEffect.ValidationResults.FirstOrDefault().ErrorMessage);
// -----------------------------------
// Is NOT Nullable
// [CSSPExist(ExistTypeName = "TVItem", ExistPlurial = "s", ExistFieldID = "TVItemID", AllowableTVtypeList = MWQMSite)]
// polSourceSiteEffect.MWQMSiteTVItemID (Int32)
// -----------------------------------
polSourceSiteEffect = null;
polSourceSiteEffect = GetFilledRandomPolSourceSiteEffect("");
polSourceSiteEffect.MWQMSiteTVItemID = 0;
polSourceSiteEffectService.Add(polSourceSiteEffect);
Assert.AreEqual(string.Format(CSSPServicesRes.CouldNotFind_With_Equal_, "TVItem", "MWQMSiteTVItemID", polSourceSiteEffect.MWQMSiteTVItemID.ToString()), polSourceSiteEffect.ValidationResults.FirstOrDefault().ErrorMessage);
polSourceSiteEffect = null;
polSourceSiteEffect = GetFilledRandomPolSourceSiteEffect("");
polSourceSiteEffect.MWQMSiteTVItemID = 1;
polSourceSiteEffectService.Add(polSourceSiteEffect);
Assert.AreEqual(string.Format(CSSPServicesRes._IsNotOfType_, "MWQMSiteTVItemID", "MWQMSite"), polSourceSiteEffect.ValidationResults.FirstOrDefault().ErrorMessage);
// -----------------------------------
// Is Nullable
// [StringLength(250))]
// polSourceSiteEffect.PolSourceSiteEffectTermIDs (String)
// -----------------------------------
polSourceSiteEffect = null;
polSourceSiteEffect = GetFilledRandomPolSourceSiteEffect("");
polSourceSiteEffect.PolSourceSiteEffectTermIDs = GetRandomString("", 251);
Assert.AreEqual(false, polSourceSiteEffectService.Add(polSourceSiteEffect));
Assert.AreEqual(string.Format(CSSPServicesRes._MaxLengthIs_, "PolSourceSiteEffectTermIDs", "250"), polSourceSiteEffect.ValidationResults.FirstOrDefault().ErrorMessage);
Assert.AreEqual(count, polSourceSiteEffectService.GetPolSourceSiteEffectList().Count());
// -----------------------------------
// Is Nullable
// polSourceSiteEffect.Comments (String)
// -----------------------------------
// -----------------------------------
// Is Nullable
// [CSSPExist(ExistTypeName = "TVItem", ExistPlurial = "s", ExistFieldID = "TVItemID", AllowableTVtypeList = File)]
// polSourceSiteEffect.AnalysisDocumentTVItemID (Int32)
// -----------------------------------
polSourceSiteEffect = null;
polSourceSiteEffect = GetFilledRandomPolSourceSiteEffect("");
polSourceSiteEffect.AnalysisDocumentTVItemID = 0;
polSourceSiteEffectService.Add(polSourceSiteEffect);
Assert.AreEqual(string.Format(CSSPServicesRes.CouldNotFind_With_Equal_, "TVItem", "AnalysisDocumentTVItemID", polSourceSiteEffect.AnalysisDocumentTVItemID.ToString()), polSourceSiteEffect.ValidationResults.FirstOrDefault().ErrorMessage);
polSourceSiteEffect = null;
polSourceSiteEffect = GetFilledRandomPolSourceSiteEffect("");
polSourceSiteEffect.AnalysisDocumentTVItemID = 1;
polSourceSiteEffectService.Add(polSourceSiteEffect);
Assert.AreEqual(string.Format(CSSPServicesRes._IsNotOfType_, "AnalysisDocumentTVItemID", "File"), polSourceSiteEffect.ValidationResults.FirstOrDefault().ErrorMessage);
// -----------------------------------
// Is NOT Nullable
// [CSSPAfter(Year = 1980)]
// polSourceSiteEffect.LastUpdateDate_UTC (DateTime)
// -----------------------------------
polSourceSiteEffect = null;
polSourceSiteEffect = GetFilledRandomPolSourceSiteEffect("");
polSourceSiteEffect.LastUpdateDate_UTC = new DateTime();
polSourceSiteEffectService.Add(polSourceSiteEffect);
Assert.AreEqual(string.Format(CSSPServicesRes._IsRequired, "LastUpdateDate_UTC"), polSourceSiteEffect.ValidationResults.FirstOrDefault().ErrorMessage);
polSourceSiteEffect = null;
polSourceSiteEffect = GetFilledRandomPolSourceSiteEffect("");
polSourceSiteEffect.LastUpdateDate_UTC = new DateTime(1979, 1, 1);
polSourceSiteEffectService.Add(polSourceSiteEffect);
Assert.AreEqual(string.Format(CSSPServicesRes._YearShouldBeBiggerThan_, "LastUpdateDate_UTC", "1980"), polSourceSiteEffect.ValidationResults.FirstOrDefault().ErrorMessage);
// -----------------------------------
// Is NOT Nullable
// [CSSPExist(ExistTypeName = "TVItem", ExistPlurial = "s", ExistFieldID = "TVItemID", AllowableTVtypeList = Contact)]
// polSourceSiteEffect.LastUpdateContactTVItemID (Int32)
// -----------------------------------
polSourceSiteEffect = null;
polSourceSiteEffect = GetFilledRandomPolSourceSiteEffect("");
polSourceSiteEffect.LastUpdateContactTVItemID = 0;
polSourceSiteEffectService.Add(polSourceSiteEffect);
Assert.AreEqual(string.Format(CSSPServicesRes.CouldNotFind_With_Equal_, "TVItem", "LastUpdateContactTVItemID", polSourceSiteEffect.LastUpdateContactTVItemID.ToString()), polSourceSiteEffect.ValidationResults.FirstOrDefault().ErrorMessage);
polSourceSiteEffect = null;
polSourceSiteEffect = GetFilledRandomPolSourceSiteEffect("");
polSourceSiteEffect.LastUpdateContactTVItemID = 1;
polSourceSiteEffectService.Add(polSourceSiteEffect);
Assert.AreEqual(string.Format(CSSPServicesRes._IsNotOfType_, "LastUpdateContactTVItemID", "Contact"), polSourceSiteEffect.ValidationResults.FirstOrDefault().ErrorMessage);
// -----------------------------------
// Is NOT Nullable
// [NotMapped]
// polSourceSiteEffect.HasErrors (Boolean)
// -----------------------------------
// No testing requied
// -----------------------------------
// Is NOT Nullable
// [NotMapped]
// polSourceSiteEffect.ValidationResults (IEnumerable`1)
// -----------------------------------
// No testing requied
}
}
}
public PolSourceSiteEffectModel PostAddPolSourceSiteEffectDB(PolSourceSiteEffectModel polSourceSiteEffectModel)
{
string retStr = PolSourceSiteEffectModelOK(polSourceSiteEffectModel);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(ReturnError(retStr));
}
ContactOK contactOK = IsContactOK();
if (!string.IsNullOrEmpty(contactOK.Error))
{
return(ReturnError(contactOK.Error));
}
TVItemModel tvItemModelExist = _TVItemService.GetTVItemModelWithTVItemIDDB(polSourceSiteEffectModel.PolSourceSiteOrInfrastructureTVItemID);
if (!string.IsNullOrWhiteSpace(tvItemModelExist.Error))
{
return(ReturnError(tvItemModelExist.Error));
}
TVItemModel tvItemModelExist2 = _TVItemService.GetTVItemModelWithTVItemIDDB(polSourceSiteEffectModel.MWQMSiteTVItemID);
if (!string.IsNullOrWhiteSpace(tvItemModelExist2.Error))
{
return(ReturnError(tvItemModelExist2.Error));
}
if (polSourceSiteEffectModel.AnalysisDocumentTVItemID != null)
{
TVItemModel tvItemModelExist3 = _TVItemService.GetTVItemModelWithTVItemIDDB((int)polSourceSiteEffectModel.AnalysisDocumentTVItemID);
if (!string.IsNullOrWhiteSpace(tvItemModelExist3.Error))
{
return(ReturnError(tvItemModelExist3.Error));
}
}
PolSourceSiteEffect polSourceSiteEffectNew = new PolSourceSiteEffect();
retStr = FillPolSourceSiteEffect(polSourceSiteEffectNew, polSourceSiteEffectModel, contactOK);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(new PolSourceSiteEffectModel()
{
Error = retStr
});
}
using (TransactionScope ts = new TransactionScope())
{
db.PolSourceSiteEffects.Add(polSourceSiteEffectNew);
retStr = DoAddChanges();
if (!string.IsNullOrWhiteSpace(retStr))
{
return(ReturnError(retStr));
}
LogModel logModel = _LogService.PostAddLogForObj("PolSourceSiteEffects", polSourceSiteEffectNew.PolSourceSiteEffectID, LogCommandEnum.Add, polSourceSiteEffectNew);
if (!string.IsNullOrWhiteSpace(logModel.Error))
{
return(ReturnError(logModel.Error));
}
ts.Complete();
}
return(GetPolSourceSiteEffectModelWithPolSourceSiteEffectIDDB(polSourceSiteEffectNew.PolSourceSiteEffectID));
}
public void PolSourceSiteEffect_Controller_GetPolSourceSiteEffectList_Test()
{
foreach (LanguageEnum LanguageRequest in AllowableLanguages)
{
foreach (int ContactID in new List <int>()
{
AdminContactID
}) //, TestEmailValidatedContactID, TestEmailNotValidatedContactID })
{
PolSourceSiteEffectController polSourceSiteEffectController = new PolSourceSiteEffectController(DatabaseTypeEnum.SqlServerTestDB);
Assert.IsNotNull(polSourceSiteEffectController);
Assert.AreEqual(DatabaseTypeEnum.SqlServerTestDB, polSourceSiteEffectController.DatabaseType);
PolSourceSiteEffect polSourceSiteEffectFirst = new PolSourceSiteEffect();
int count = -1;
Query query = new Query();
using (CSSPDBContext db = new CSSPDBContext(DatabaseTypeEnum.SqlServerTestDB))
{
PolSourceSiteEffectService polSourceSiteEffectService = new PolSourceSiteEffectService(query, db, ContactID);
polSourceSiteEffectFirst = (from c in db.PolSourceSiteEffects select c).FirstOrDefault();
count = (from c in db.PolSourceSiteEffects select c).Count();
count = (query.Take > count ? count : query.Take);
}
// ok with PolSourceSiteEffect info
IHttpActionResult jsonRet = polSourceSiteEffectController.GetPolSourceSiteEffectList();
Assert.IsNotNull(jsonRet);
OkNegotiatedContentResult <List <PolSourceSiteEffect> > ret = jsonRet as OkNegotiatedContentResult <List <PolSourceSiteEffect> >;
Assert.AreEqual(polSourceSiteEffectFirst.PolSourceSiteEffectID, ret.Content[0].PolSourceSiteEffectID);
Assert.AreEqual((count > query.Take ? query.Take : count), ret.Content.Count);
List <PolSourceSiteEffect> polSourceSiteEffectList = new List <PolSourceSiteEffect>();
count = -1;
query = new Query();
using (CSSPDBContext db = new CSSPDBContext(DatabaseTypeEnum.SqlServerTestDB))
{
PolSourceSiteEffectService polSourceSiteEffectService = new PolSourceSiteEffectService(query, db, ContactID);
polSourceSiteEffectList = (from c in db.PolSourceSiteEffects select c).OrderBy(c => c.PolSourceSiteEffectID).Skip(0).Take(2).ToList();
count = (from c in db.PolSourceSiteEffects select c).Count();
}
if (count > 0)
{
query.Skip = 0;
query.Take = 5;
count = (query.Take > count ? query.Take : count);
// ok with PolSourceSiteEffect info
jsonRet = polSourceSiteEffectController.GetPolSourceSiteEffectList(query.Language.ToString(), query.Skip, query.Take);
Assert.IsNotNull(jsonRet);
ret = jsonRet as OkNegotiatedContentResult <List <PolSourceSiteEffect> >;
Assert.AreEqual(polSourceSiteEffectList[0].PolSourceSiteEffectID, ret.Content[0].PolSourceSiteEffectID);
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 PolSourceSiteEffect info
IHttpActionResult jsonRet2 = polSourceSiteEffectController.GetPolSourceSiteEffectList(query.Language.ToString(), query.Skip, query.Take);
Assert.IsNotNull(jsonRet2);
OkNegotiatedContentResult <List <PolSourceSiteEffect> > ret2 = jsonRet2 as OkNegotiatedContentResult <List <PolSourceSiteEffect> >;
Assert.AreEqual(polSourceSiteEffectList[1].PolSourceSiteEffectID, ret2.Content[0].PolSourceSiteEffectID);
Assert.AreEqual((count > query.Take ? query.Take : count), ret2.Content.Count);
}
}
}
}
}
public void PolSourceSiteEffect_Controller_Post_Test()
{
foreach (LanguageEnum LanguageRequest in AllowableLanguages)
{
foreach (int ContactID in new List <int>()
{
AdminContactID
}) //, TestEmailValidatedContactID, TestEmailNotValidatedContactID })
{
PolSourceSiteEffectController polSourceSiteEffectController = new PolSourceSiteEffectController(DatabaseTypeEnum.SqlServerTestDB);
Assert.IsNotNull(polSourceSiteEffectController);
Assert.AreEqual(DatabaseTypeEnum.SqlServerTestDB, polSourceSiteEffectController.DatabaseType);
PolSourceSiteEffect polSourceSiteEffectLast = new PolSourceSiteEffect();
using (CSSPDBContext db = new CSSPDBContext(DatabaseType))
{
Query query = new Query();
query.Language = LanguageRequest;
query.Asc = "";
query.Desc = "";
PolSourceSiteEffectService polSourceSiteEffectService = new PolSourceSiteEffectService(query, db, ContactID);
polSourceSiteEffectLast = (from c in db.PolSourceSiteEffects select c).FirstOrDefault();
}
// ok with PolSourceSiteEffect info
IHttpActionResult jsonRet = polSourceSiteEffectController.GetPolSourceSiteEffectWithID(polSourceSiteEffectLast.PolSourceSiteEffectID);
Assert.IsNotNull(jsonRet);
OkNegotiatedContentResult <PolSourceSiteEffect> Ret = jsonRet as OkNegotiatedContentResult <PolSourceSiteEffect>;
PolSourceSiteEffect polSourceSiteEffectRet = Ret.Content;
Assert.AreEqual(polSourceSiteEffectLast.PolSourceSiteEffectID, polSourceSiteEffectRet.PolSourceSiteEffectID);
BadRequestErrorMessageResult badRequest = jsonRet as BadRequestErrorMessageResult;
Assert.IsNull(badRequest);
// Post to return CSSPError because PolSourceSiteEffectID exist
IHttpActionResult jsonRet2 = polSourceSiteEffectController.Post(polSourceSiteEffectRet, LanguageRequest.ToString());
Assert.IsNotNull(jsonRet2);
OkNegotiatedContentResult <PolSourceSiteEffect> polSourceSiteEffectRet2 = jsonRet2 as OkNegotiatedContentResult <PolSourceSiteEffect>;
Assert.IsNull(polSourceSiteEffectRet2);
BadRequestErrorMessageResult badRequest2 = jsonRet2 as BadRequestErrorMessageResult;
Assert.IsNotNull(badRequest2);
// Post to return newly added PolSourceSiteEffect
polSourceSiteEffectRet.PolSourceSiteEffectID = 0;
polSourceSiteEffectController.Request = new System.Net.Http.HttpRequestMessage();
polSourceSiteEffectController.Request.RequestUri = new System.Uri("http://localhost:5000/api/polSourceSiteEffect");
IHttpActionResult jsonRet3 = polSourceSiteEffectController.Post(polSourceSiteEffectRet, LanguageRequest.ToString());
Assert.IsNotNull(jsonRet3);
CreatedNegotiatedContentResult <PolSourceSiteEffect> polSourceSiteEffectRet3 = jsonRet3 as CreatedNegotiatedContentResult <PolSourceSiteEffect>;
Assert.IsNotNull(polSourceSiteEffectRet3);
BadRequestErrorMessageResult badRequest3 = jsonRet3 as BadRequestErrorMessageResult;
Assert.IsNull(badRequest3);
IHttpActionResult jsonRet4 = polSourceSiteEffectController.Delete(polSourceSiteEffectRet, LanguageRequest.ToString());
Assert.IsNotNull(jsonRet4);
OkNegotiatedContentResult <PolSourceSiteEffect> polSourceSiteEffectRet4 = jsonRet4 as OkNegotiatedContentResult <PolSourceSiteEffect>;
Assert.IsNotNull(polSourceSiteEffectRet4);
BadRequestErrorMessageResult badRequest4 = jsonRet4 as BadRequestErrorMessageResult;
Assert.IsNull(badRequest4);
}
}
}
