public List <WorkerReview> SelectWorkerReviews(int workerID)
{
List <WorkerReview> list = null;
using (var context = new dconfianzaEntities())
{
List <spWorkeReviewSelectByID_Result> result = context.spWorkeReviewSelectByID(workerID).ToList();
if (result != null)
{
list = new List <WorkerReview>();
foreach (spWorkeReviewSelectByID_Result item in result)
{
WorkerReview workerReview = new WorkerReview();
workerReview.ID = item.WorkerReviewID;
workerReview.WorkerID = item.WorkerID;
workerReview.FirstName = item.FirstName;
workerReview.LastName = item.LastName;
workerReview.Review = item.Review;
workerReview.Rating = item.Rating;
workerReview.CreatedDate = item.CreatedDate;
workerReview.CreatedByFirstName = item.CreatedByFirstName;
workerReview.CreatedByLastName = item.CreatedByLastName;
list.Add(workerReview);
}
}
}
return(list);
}
public void ReviewContent_GetAndSetShould_WorkProperly(string randomString)
{
var obj = new WorkerReview();
obj.ReviewContent = randomString;
Assert.AreEqual(randomString, obj.ReviewContent);
}
public void IsDeleted_GetAndSetShould_WorkProperly(bool value)
{
var obj = new WorkerReview();
obj.IsDeleted = value;
Assert.AreEqual(value, obj.IsDeleted);
}
public void ClientId_GetAndSetShould_WorkProperly(int randomNumber)
{
var obj = new WorkerReview();
obj.ClientId = randomNumber;
Assert.AreEqual(randomNumber, obj.ClientId);
}
public void Score_GetAndSetShould_WorkProperly(int randomNumber)
{
var obj = new WorkerReview();
obj.Score = randomNumber;
Assert.AreEqual(randomNumber, obj.Score);
}
public HttpResponseMessage WorkerReviewInsert(WorkerReview review)
{
int workerReviewID = repository.WorkerReviewInsert(review.CreatedByID, review.WorkerID, review.Review, review.Rating);
var response = Request.CreateResponse <int>(HttpStatusCode.Created, workerReviewID);
//TODO: locatoin variable is wrong
response.Headers.Location = new Uri(Request.RequestUri, string.Format("/api/main/review/{0}", workerReviewID.ToString()));
return(response);
}
public void Client_GetAndSetShould_WorkProperly()
{
var mockedWorker = new Mock <Client>();
var obj = new WorkerReview();
obj.Client = mockedWorker.Object;
Assert.AreSame(mockedWorker.Object, obj.Client);
}
public void WorkerReview_VerifyNumberOfProperties()
{
var obj = new WorkerReview();
var result = obj.GetType()
.GetProperties()
.Count();
Assert.AreEqual(8, result);
}
public void Client_ShouldBe_Virtual()
{
var obj = new WorkerReview();
var result = obj.GetType()
.GetProperty("Client")
.GetAccessors()
.Any(x => x.IsVirtual);
Assert.IsTrue(result);
}
public void WorkerReviewClass_ShouldImplement_IDbModelInterface()
{
var obj = new WorkerReview();
var result = obj.GetType()
.GetInterfaces()
.Where(x => x == typeof(IDbModel))
.Any();
Assert.IsTrue(result);
}
public void Score_ShouldHave_RangeAttribute()
{
var obj = new WorkerReview();
var result = obj.GetType()
.GetProperty("Score")
.GetCustomAttributes(false)
.Where(x => x.GetType() == typeof(System.ComponentModel.DataAnnotations.RangeAttribute))
.Any();
Assert.IsTrue(result);
}
public void ReviewContent_ShouldHave_MaxLengthAttribute()
{
var obj = new WorkerReview();
var result = obj.GetType()
.GetProperty("ReviewContent")
.GetCustomAttributes(false)
.Where(x => x.GetType() == typeof(MaxLengthAttribute))
.Any();
Assert.IsTrue(result);
}
public void Id_ShouldHave_KeyAttribute()
{
var obj = new WorkerReview();
var result = obj.GetType()
.GetProperty("Id")
.GetCustomAttributes(false)
.Where(x => x.GetType() == typeof(KeyAttribute))
.Any();
Assert.IsTrue(result);
}
public void Score_shouldHave_RightMaxValueFor_RangeAttribute()
{
var obj = new WorkerReview();
var result = obj.GetType()
.GetProperty("Score")
.GetCustomAttributes(false)
.Where(x => x.GetType() == typeof(System.ComponentModel.DataAnnotations.RangeAttribute))
.Select(x => (System.ComponentModel.DataAnnotations.RangeAttribute)x)
.SingleOrDefault();
Assert.IsNotNull(result);
Assert.AreEqual(ValidationConstants.ScoreMaxValue, result.Maximum);
}
public void ReviewContent_ShouldHave_RightValueFor_MaxLengthAttribute()
{
var obj = new WorkerReview();
var result = obj.GetType()
.GetProperty("ReviewContent")
.GetCustomAttributes(false)
.Where(x => x.GetType() == typeof(MaxLengthAttribute))
.Select(x => (MaxLengthAttribute)x)
.SingleOrDefault();
Assert.IsNotNull(result);
Assert.AreEqual(ValidationConstants.ReviewContentMaxLength, result.Length);
}
public void WorkerReview_VerifyNumberOfConstructors()
{
var obj = new WorkerReview();
var methodsCount = obj.GetType()
.GetMethods()
.Count();
var propertiesCount = obj.GetType()
.GetProperties()
.Count();
var result = obj.GetType()
.GetMembers()
.Count();
result = result - propertiesCount - methodsCount;
Assert.AreEqual(1, result);
}
public void WorkerReview_VerifyNumberOfMethods()
{
var methodsFromFramework = 4;
var expectedMethodsCount = 0;
var totalMethodsCount = methodsFromFramework + expectedMethodsCount;
var obj = new WorkerReview();
var numberOfMethodsComeFromProperties = obj.GetType()
.GetProperties()
.Select(x => 2)
.Sum();
var result = obj.GetType()
.GetMethods()
.Count();
result = result - numberOfMethodsComeFromProperties;
Assert.AreEqual(totalMethodsCount, result);
}
public void WorkerReview_ShouldHave_ParameterlessConstructor()
{
var obj = new WorkerReview();
Assert.IsInstanceOf <WorkerReview>(obj);
}
public void Constructor_ShouldNotSet_IsDeletedProperty()
{
var obj = new WorkerReview();
Assert.IsFalse(obj.IsDeleted);
}
public void Constructor_ShouldNotSet_WorkerProperty()
{
var obj = new WorkerReview();
Assert.AreEqual(null, obj.Client);
}
public void Constuctor_ShouldNotSet_WorkerIdProperty()
{
var obj = new WorkerReview();
Assert.AreEqual(0, obj.ClientId);
}
public void Constructor_ShouldNotSet_ScoreProperty()
{
var obj = new WorkerReview();
Assert.AreEqual(0, obj.Score);
}
public void Constructor_ShouldNotSet_IdParameter()
{
var obj = new WorkerReview();
Assert.AreEqual(0, obj.Id);
}
