public IHttpActionResult GetClimateDataValueList([FromUri] string lang = "en", [FromUri] int skip = 0, [FromUri] int take = 200,
[FromUri] string asc = "", [FromUri] string desc = "", [FromUri] string where = "", [FromUri] string extra = "")
{
using (CSSPDBContext db = new CSSPDBContext(DatabaseType))
{
ClimateDataValueService climateDataValueService = new ClimateDataValueService(new Query()
{
Lang = lang
}, db, ContactID);
public void ClimateDataValue_Controller_Put_Test()
{
foreach (LanguageEnum LanguageRequest in AllowableLanguages)
{
foreach (int ContactID in new List <int>()
{
AdminContactID
}) //, TestEmailValidatedContactID, TestEmailNotValidatedContactID })
{
ClimateDataValueController climateDataValueController = new ClimateDataValueController(DatabaseTypeEnum.SqlServerTestDB);
Assert.IsNotNull(climateDataValueController);
Assert.AreEqual(DatabaseTypeEnum.SqlServerTestDB, climateDataValueController.DatabaseType);
ClimateDataValue climateDataValueLast = new ClimateDataValue();
using (CSSPDBContext db = new CSSPDBContext(DatabaseType))
{
Query query = new Query();
query.Language = LanguageRequest;
ClimateDataValueService climateDataValueService = new ClimateDataValueService(query, db, ContactID);
climateDataValueLast = (from c in db.ClimateDataValues select c).FirstOrDefault();
}
// ok with ClimateDataValue info
IHttpActionResult jsonRet = climateDataValueController.GetClimateDataValueWithID(climateDataValueLast.ClimateDataValueID);
Assert.IsNotNull(jsonRet);
OkNegotiatedContentResult <ClimateDataValue> Ret = jsonRet as OkNegotiatedContentResult <ClimateDataValue>;
ClimateDataValue climateDataValueRet = Ret.Content;
Assert.AreEqual(climateDataValueLast.ClimateDataValueID, climateDataValueRet.ClimateDataValueID);
BadRequestErrorMessageResult badRequest = jsonRet as BadRequestErrorMessageResult;
Assert.IsNull(badRequest);
// Put to return success
IHttpActionResult jsonRet2 = climateDataValueController.Put(climateDataValueRet, LanguageRequest.ToString());
Assert.IsNotNull(jsonRet2);
OkNegotiatedContentResult <ClimateDataValue> climateDataValueRet2 = jsonRet2 as OkNegotiatedContentResult <ClimateDataValue>;
Assert.IsNotNull(climateDataValueRet2);
BadRequestErrorMessageResult badRequest2 = jsonRet2 as BadRequestErrorMessageResult;
Assert.IsNull(badRequest2);
// Put to return CSSPError because ClimateDataValueID of 0 does not exist
climateDataValueRet.ClimateDataValueID = 0;
IHttpActionResult jsonRet3 = climateDataValueController.Put(climateDataValueRet, LanguageRequest.ToString());
Assert.IsNotNull(jsonRet3);
OkNegotiatedContentResult <ClimateDataValue> climateDataValueRet3 = jsonRet3 as OkNegotiatedContentResult <ClimateDataValue>;
Assert.IsNull(climateDataValueRet3);
BadRequestErrorMessageResult badRequest3 = jsonRet3 as BadRequestErrorMessageResult;
Assert.IsNotNull(badRequest3);
}
}
}
public IHttpActionResult GetClimateDataValueWithID([FromUri] int ClimateDataValueID, [FromUri] string lang = "en", [FromUri] string extra = "")
{
using (CSSPDBContext db = new CSSPDBContext(DatabaseType))
{
ClimateDataValueService climateDataValueService = new ClimateDataValueService(new Query()
{
Language = (lang == "fr" ? LanguageEnum.fr : LanguageEnum.en)
}, db, ContactID);
climateDataValueService.Query = climateDataValueService.FillQuery(typeof(ClimateDataValue), lang, 0, 1, "", "", extra);
if (climateDataValueService.Query.Extra == "A")
{
ClimateDataValueExtraA climateDataValueExtraA = new ClimateDataValueExtraA();
climateDataValueExtraA = climateDataValueService.GetClimateDataValueExtraAWithClimateDataValueID(ClimateDataValueID);
if (climateDataValueExtraA == null)
{
return(NotFound());
}
return(Ok(climateDataValueExtraA));
}
else if (climateDataValueService.Query.Extra == "B")
{
ClimateDataValueExtraB climateDataValueExtraB = new ClimateDataValueExtraB();
climateDataValueExtraB = climateDataValueService.GetClimateDataValueExtraBWithClimateDataValueID(ClimateDataValueID);
if (climateDataValueExtraB == null)
{
return(NotFound());
}
return(Ok(climateDataValueExtraB));
}
else
{
ClimateDataValue climateDataValue = new ClimateDataValue();
climateDataValue = climateDataValueService.GetClimateDataValueWithClimateDataValueID(ClimateDataValueID);
if (climateDataValue == null)
{
return(NotFound());
}
return(Ok(climateDataValue));
}
}
}
public void ClimateDataValue_Controller_GetClimateDataValueWithID_Test()
{
foreach (LanguageEnum LanguageRequest in AllowableLanguages)
{
foreach (int ContactID in new List <int>()
{
AdminContactID
}) //, TestEmailValidatedContactID, TestEmailNotValidatedContactID })
{
ClimateDataValueController climateDataValueController = new ClimateDataValueController(DatabaseTypeEnum.SqlServerTestDB);
Assert.IsNotNull(climateDataValueController);
Assert.AreEqual(DatabaseTypeEnum.SqlServerTestDB, climateDataValueController.DatabaseType);
ClimateDataValue climateDataValueFirst = new ClimateDataValue();
using (CSSPDBContext db = new CSSPDBContext(DatabaseType))
{
ClimateDataValueService climateDataValueService = new ClimateDataValueService(new Query(), db, ContactID);
climateDataValueFirst = (from c in db.ClimateDataValues select c).FirstOrDefault();
}
// ok with ClimateDataValue info
IHttpActionResult jsonRet = climateDataValueController.GetClimateDataValueWithID(climateDataValueFirst.ClimateDataValueID);
Assert.IsNotNull(jsonRet);
OkNegotiatedContentResult <ClimateDataValue> Ret = jsonRet as OkNegotiatedContentResult <ClimateDataValue>;
ClimateDataValue climateDataValueRet = Ret.Content;
Assert.AreEqual(climateDataValueFirst.ClimateDataValueID, climateDataValueRet.ClimateDataValueID);
BadRequestErrorMessageResult badRequest = jsonRet as BadRequestErrorMessageResult;
Assert.IsNull(badRequest);
// Not Found
IHttpActionResult jsonRet2 = climateDataValueController.GetClimateDataValueWithID(0);
Assert.IsNotNull(jsonRet2);
OkNegotiatedContentResult <ClimateDataValue> climateDataValueRet2 = jsonRet2 as OkNegotiatedContentResult <ClimateDataValue>;
Assert.IsNull(climateDataValueRet2);
NotFoundResult notFoundRequest = jsonRet2 as NotFoundResult;
Assert.IsNotNull(notFoundRequest);
}
}
}
public IHttpActionResult Delete([FromBody] ClimateDataValue climateDataValue, [FromUri] string lang = "en")
{
using (CSSPDBContext db = new CSSPDBContext(DatabaseType))
{
ClimateDataValueService climateDataValueService = new ClimateDataValueService(new Query()
{
Language = (lang == "fr" ? LanguageEnum.fr : LanguageEnum.en)
}, db, ContactID);
if (!climateDataValueService.Delete(climateDataValue))
{
return(BadRequest(String.Join("|||", climateDataValue.ValidationResults)));
}
else
{
climateDataValue.ValidationResults = null;
return(Ok(climateDataValue));
}
}
}
public void ClimateDataValue_Controller_GetClimateDataValueList_Test()
{
foreach (LanguageEnum LanguageRequest in AllowableLanguages)
{
foreach (int ContactID in new List <int>()
{
AdminContactID
}) //, TestEmailValidatedContactID, TestEmailNotValidatedContactID })
{
ClimateDataValueController climateDataValueController = new ClimateDataValueController(DatabaseTypeEnum.SqlServerTestDB);
Assert.IsNotNull(climateDataValueController);
Assert.AreEqual(DatabaseTypeEnum.SqlServerTestDB, climateDataValueController.DatabaseType);
ClimateDataValue climateDataValueFirst = new ClimateDataValue();
int count = -1;
Query query = new Query();
using (CSSPDBContext db = new CSSPDBContext(DatabaseTypeEnum.SqlServerTestDB))
{
ClimateDataValueService climateDataValueService = new ClimateDataValueService(query, db, ContactID);
climateDataValueFirst = (from c in db.ClimateDataValues select c).FirstOrDefault();
count = (from c in db.ClimateDataValues select c).Count();
count = (query.Take > count ? count : query.Take);
}
// ok with ClimateDataValue info
IHttpActionResult jsonRet = climateDataValueController.GetClimateDataValueList();
Assert.IsNotNull(jsonRet);
OkNegotiatedContentResult <List <ClimateDataValue> > ret = jsonRet as OkNegotiatedContentResult <List <ClimateDataValue> >;
Assert.AreEqual(climateDataValueFirst.ClimateDataValueID, ret.Content[0].ClimateDataValueID);
Assert.AreEqual((count > query.Take ? query.Take : count), ret.Content.Count);
List <ClimateDataValue> climateDataValueList = new List <ClimateDataValue>();
count = -1;
query = new Query();
using (CSSPDBContext db = new CSSPDBContext(DatabaseTypeEnum.SqlServerTestDB))
{
ClimateDataValueService climateDataValueService = new ClimateDataValueService(query, db, ContactID);
climateDataValueList = (from c in db.ClimateDataValues select c).OrderBy(c => c.ClimateDataValueID).Skip(0).Take(2).ToList();
count = (from c in db.ClimateDataValues select c).Count();
}
if (count > 0)
{
query.Skip = 0;
query.Take = 5;
count = (query.Take > count ? query.Take : count);
// ok with ClimateDataValue info
jsonRet = climateDataValueController.GetClimateDataValueList(query.Language.ToString(), query.Skip, query.Take);
Assert.IsNotNull(jsonRet);
ret = jsonRet as OkNegotiatedContentResult <List <ClimateDataValue> >;
Assert.AreEqual(climateDataValueList[0].ClimateDataValueID, ret.Content[0].ClimateDataValueID);
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 ClimateDataValue info
IHttpActionResult jsonRet2 = climateDataValueController.GetClimateDataValueList(query.Language.ToString(), query.Skip, query.Take);
Assert.IsNotNull(jsonRet2);
OkNegotiatedContentResult <List <ClimateDataValue> > ret2 = jsonRet2 as OkNegotiatedContentResult <List <ClimateDataValue> >;
Assert.AreEqual(climateDataValueList[1].ClimateDataValueID, ret2.Content[0].ClimateDataValueID);
Assert.AreEqual((count > query.Take ? query.Take : count), ret2.Content.Count);
}
}
}
}
}
public void ClimateDataValue_Controller_Post_Test()
{
foreach (LanguageEnum LanguageRequest in AllowableLanguages)
{
foreach (int ContactID in new List <int>()
{
AdminContactID
}) //, TestEmailValidatedContactID, TestEmailNotValidatedContactID })
{
ClimateDataValueController climateDataValueController = new ClimateDataValueController(DatabaseTypeEnum.SqlServerTestDB);
Assert.IsNotNull(climateDataValueController);
Assert.AreEqual(DatabaseTypeEnum.SqlServerTestDB, climateDataValueController.DatabaseType);
ClimateDataValue climateDataValueLast = new ClimateDataValue();
using (CSSPDBContext db = new CSSPDBContext(DatabaseType))
{
Query query = new Query();
query.Language = LanguageRequest;
query.Asc = "";
query.Desc = "";
ClimateDataValueService climateDataValueService = new ClimateDataValueService(query, db, ContactID);
climateDataValueLast = (from c in db.ClimateDataValues select c).FirstOrDefault();
}
// ok with ClimateDataValue info
IHttpActionResult jsonRet = climateDataValueController.GetClimateDataValueWithID(climateDataValueLast.ClimateDataValueID);
Assert.IsNotNull(jsonRet);
OkNegotiatedContentResult <ClimateDataValue> Ret = jsonRet as OkNegotiatedContentResult <ClimateDataValue>;
ClimateDataValue climateDataValueRet = Ret.Content;
Assert.AreEqual(climateDataValueLast.ClimateDataValueID, climateDataValueRet.ClimateDataValueID);
BadRequestErrorMessageResult badRequest = jsonRet as BadRequestErrorMessageResult;
Assert.IsNull(badRequest);
// Post to return CSSPError because ClimateDataValueID exist
IHttpActionResult jsonRet2 = climateDataValueController.Post(climateDataValueRet, LanguageRequest.ToString());
Assert.IsNotNull(jsonRet2);
OkNegotiatedContentResult <ClimateDataValue> climateDataValueRet2 = jsonRet2 as OkNegotiatedContentResult <ClimateDataValue>;
Assert.IsNull(climateDataValueRet2);
BadRequestErrorMessageResult badRequest2 = jsonRet2 as BadRequestErrorMessageResult;
Assert.IsNotNull(badRequest2);
// Post to return newly added ClimateDataValue
climateDataValueRet.ClimateDataValueID = 0;
climateDataValueController.Request = new System.Net.Http.HttpRequestMessage();
climateDataValueController.Request.RequestUri = new System.Uri("http://localhost:5000/api/climateDataValue");
IHttpActionResult jsonRet3 = climateDataValueController.Post(climateDataValueRet, LanguageRequest.ToString());
Assert.IsNotNull(jsonRet3);
CreatedNegotiatedContentResult <ClimateDataValue> climateDataValueRet3 = jsonRet3 as CreatedNegotiatedContentResult <ClimateDataValue>;
Assert.IsNotNull(climateDataValueRet3);
BadRequestErrorMessageResult badRequest3 = jsonRet3 as BadRequestErrorMessageResult;
Assert.IsNull(badRequest3);
IHttpActionResult jsonRet4 = climateDataValueController.Delete(climateDataValueRet, LanguageRequest.ToString());
Assert.IsNotNull(jsonRet4);
OkNegotiatedContentResult <ClimateDataValue> climateDataValueRet4 = jsonRet4 as OkNegotiatedContentResult <ClimateDataValue>;
Assert.IsNotNull(climateDataValueRet4);
BadRequestErrorMessageResult badRequest4 = jsonRet4 as BadRequestErrorMessageResult;
Assert.IsNull(badRequest4);
}
}
}
public IHttpActionResult GetClimateDataValueList([FromUri] string lang = "en", [FromUri] int skip = 0, [FromUri] int take = 200,
[FromUri] string asc = "", [FromUri] string desc = "", [FromUri] string where = "", [FromUri] string extra = "")
{
using (CSSPDBContext db = new CSSPDBContext(DatabaseType))
{
ClimateDataValueService climateDataValueService = new ClimateDataValueService(new Query()
{
Lang = lang
}, db, ContactID);
if (extra == "A") // QueryString contains [extra=A]
{
climateDataValueService.Query = climateDataValueService.FillQuery(typeof(ClimateDataValueExtraA), lang, skip, take, asc, desc, where, extra);
if (climateDataValueService.Query.HasErrors)
{
return(Ok(new List <ClimateDataValueExtraA>()
{
new ClimateDataValueExtraA()
{
HasErrors = climateDataValueService.Query.HasErrors,
ValidationResults = climateDataValueService.Query.ValidationResults,
},
}.ToList()));
}
else
{
return(Ok(climateDataValueService.GetClimateDataValueExtraAList().ToList()));
}
}
else if (extra == "B") // QueryString contains [extra=B]
{
climateDataValueService.Query = climateDataValueService.FillQuery(typeof(ClimateDataValueExtraB), lang, skip, take, asc, desc, where, extra);
if (climateDataValueService.Query.HasErrors)
{
return(Ok(new List <ClimateDataValueExtraB>()
{
new ClimateDataValueExtraB()
{
HasErrors = climateDataValueService.Query.HasErrors,
ValidationResults = climateDataValueService.Query.ValidationResults,
},
}.ToList()));
}
else
{
return(Ok(climateDataValueService.GetClimateDataValueExtraBList().ToList()));
}
}
else // QueryString has no parameter [extra] or extra is empty
{
climateDataValueService.Query = climateDataValueService.FillQuery(typeof(ClimateDataValue), lang, skip, take, asc, desc, where, extra);
if (climateDataValueService.Query.HasErrors)
{
return(Ok(new List <ClimateDataValue>()
{
new ClimateDataValue()
{
HasErrors = climateDataValueService.Query.HasErrors,
ValidationResults = climateDataValueService.Query.ValidationResults,
},
}.ToList()));
}
else
{
return(Ok(climateDataValueService.GetClimateDataValueList().ToList()));
}
}
}
}
