public void updateMethodOK()
{
clsReviewsCollection AllReviews = new clsReviewsCollection();
clsReviews TestItem = new clsReviews();
Int32 PrimaryKey = 0;
TestItem.ReviewApproved = true;
TestItem.ReviewRating = 4;
TestItem.ReviewerName = "Dave";
TestItem.ReviewText = "Good Product";
TestItem.ReviewedProduct = "Spurs Shorts";
TestItem.DateAdded = DateTime.Now.Date;
AllReviews.ThisReviews = TestItem;
PrimaryKey = AllReviews.Add();
TestItem.ReviewsId = PrimaryKey;
//PrimaryKey = AllReviews = TestItem;
//AllReviews.ThisReviews.Add();
TestItem.ReviewApproved = false;
TestItem.ReviewRating = 2;
TestItem.ReviewerName = "Dom";
TestItem.ReviewText = "Ok Product";
TestItem.ReviewedProduct = " Shorts";
TestItem.DateAdded = DateTime.Now.Date;
AllReviews.ThisReviews = TestItem;
AllReviews.Update();
AllReviews.ThisReviews.Find(PrimaryKey);
Assert.AreEqual(AllReviews.ThisReviews, TestItem);
}
protected void Page_Load(object sender, EventArgs e)
{
clsReviews AnReviews = new clsReviews();
AnReviews = (clsReviews)Session["AnReviews"];
Response.Write(AnReviews.ReviewRating);
}
public void DeleteMethodOK()
{
//create an instance of the class we want to create
clsReviewsCollection AllReviews = new clsReviewsCollection("Fbloggs");
//create an instance of test data
clsReviews TestItem = new clsReviews();
//var to store primary key
Int32 PK = 0;
//set the properties
//TestItem.CustomerID = 3;
TestItem.Email = "*****@*****.**";
TestItem.Exp = "*****@*****.**";
TestItem.Improveexp = "*****@*****.**";
//set ThisCustomer to validate test data
AllReviews.ThisReview = TestItem;
//add the record
PK = AllReviews.Add();
//set primary key of test data
TestItem.ReviewId = PK;
//find the record
AllReviews.ThisReview.Find(PK);
//delete the record
AllReviews.Delete();
//now find the record
Boolean Found = AllReviews.ThisReview.Find(PK);
//test to see that it exists
Assert.IsFalse(Found);
}
public void UpdateMethodOK()
{
//create an instance of the class we want to create
clsReviewsCollection AllReviews = new clsReviewsCollection("Fbloggs");
//create an instance of test data
clsReviews TestItem = new clsReviews();
//var to store primary key
Int32 PK = 0;
//set the properties
TestItem.Email = "*****@*****.**";
TestItem.Exp = "*****@*****.**";
TestItem.Improveexp = "*****@*****.**";
//set ThisCustomer to validate test data
AllReviews.ThisReview = TestItem;
//add the record
PK = AllReviews.Add();
//set primary key of test data
TestItem.ReviewId = PK;
//modify the record
TestItem.Email = "*****@*****.**";
TestItem.Exp = "*****@*****.**";
TestItem.Improveexp = "*****@*****.**";
//set the record based on the new record
AllReviews.ThisReview = TestItem;
//update the record
AllReviews.Update();
//find the record
AllReviews.ThisReview.Find(PK);
//test to see that it exists
Assert.AreEqual(AllReviews.ThisReview, TestItem);
}
public void InstanceOK()
{
//create an instance of the class we want to create
clsReviews AnReviews = new clsReviews();
//test to see that it exists
Assert.IsNotNull(AnReviews);
}
public void AddMethodOK()
{
//create an instance of the class we want to create
clsReviewsCollection AllReviews = new clsReviewsCollection("Fbloggs");
//create an instance of test data
clsReviews TestItem = new clsReviews();
//var to store primary key
Int32 PK = 0;
//set the properties
//TestItem.CustomerID = 3;
TestItem.Email = "*****@*****.**";
TestItem.Exp = "*****@*****.**";
TestItem.Improveexp = "*****@*****.**";
//TestItem.UserName = "******";
//set ThisCustomer to validate test data
AllReviews.ThisReview = TestItem;
//add the record
PK = AllReviews.Add();
//set primary key of test data
TestItem.ReviewId = PK;
//find the record
AllReviews.ThisReview.Find(PK);
//test to see that it exists
Assert.AreEqual(AllReviews.ThisReview, TestItem);
}
public void ReviewsIdPropertyOK()
{
clsReviews AnReviews = new clsReviews();
Int32 TestData = 1;
AnReviews.ReviewsId = TestData;
Assert.AreEqual(AnReviews.ReviewsId, TestData);
}
public void InstanceOK()
{
//create a new instance of the class we want to create
clsReviews AReview = new clsReviews();
//test to see if it exists
Assert.IsNotNull(AReview);
}
public void ValidMethodOK()
{
clsReviews AnReviews = new clsReviews();
String Error = "";
Error = AnReviews.Valid(ReviewedProduct, ReviewText, DateAdded, ReviewerName);
Assert.AreEqual(Error, "");
}
public void ReviewApprovedOK()
{
clsReviews AnReviews = new clsReviews();
Boolean TestData = true;
AnReviews.ReviewApproved = TestData;
Assert.AreEqual(AnReviews.ReviewApproved, TestData);
}
public void DateAddedInvalidData()
{
clsReviews AnReviews = new clsReviews();
String Error = "";
string DateAdded = "This is not a date!";
Error = AnReviews.Valid(ReviewedProduct, ReviewText,
DateAdded, ReviewerName);
Assert.AreNotEqual(Error, "");
}
public void DateAddedOK()
{
clsReviews AnReviews = new clsReviews();
DateTime TestData = DateTime.Now.Date;
AnReviews.DateAdded = TestData;
Assert.AreEqual(AnReviews.DateAdded, TestData);
}
public void ReviewRatingOK()
{
clsReviews AnReviews = new clsReviews();
Int32 TestData = 2;
AnReviews.ReviewRating = TestData;
Assert.AreEqual(AnReviews.ReviewRating, TestData);
}
public void ReviewedProductOK()
{
clsReviews AnReviews = new clsReviews();
String TestData = "Man Utd socks";
AnReviews.ReviewedProduct = TestData;
Assert.AreEqual(AnReviews.ReviewedProduct, TestData);
}
public void FindMethodOK()
{
clsReviews AnReviews = new clsReviews();
Boolean Found = false;
Int32 ReviewsId = 2;
Found = AnReviews.Find(ReviewsId);
Assert.IsTrue(Found);
}
public void ReviewedProductMaxPlusOne()
{
clsReviews AnReviews = new clsReviews();
String Error = "";
string ReviewedProduct = "";
Error = AnReviews.Valid(ReviewedProduct, ReviewText,
DateAdded, ReviewerName);
Assert.AreNotEqual(Error, "");
}
public void ReviewTextOK()
{
clsReviews AnReviews = new clsReviews();
String TestData = "The product is bad";
AnReviews.ReviewText = TestData;
Assert.AreEqual(AnReviews.ReviewText, TestData);
}
public void ReviewerNameOK()
{
clsReviews AnReviews = new clsReviews();
String TestData = "Sophie";
AnReviews.ReviewerName = TestData;
Assert.AreEqual(AnReviews.ReviewerName, TestData);
}
public void ScoreProperty()
{
//create an instance of the class we want to create
clsReviews AnReviews = new clsReviews();
//create some test data to assign to the property
string TestData = "3.3";
//assign the data to the proerty
AnReviews.Score = TestData;
//test to see that the two values are the same
Assert.AreEqual(AnReviews.Score, TestData);
}
public void EmailExist()
{
//create a new instance of the class we want to create
clsReviews TestItem = new clsReviews();;
//create some test data
string Email = " [email protected]";
TestItem.Email = Email;
//test to see if it exists
Assert.AreEqual(TestItem.Email, Email);
}
public void ExpExist()
{
//create a new instance of the class we want to create
clsReviews TestItem = new clsReviews();;
//create some test data
string Exp = " loved it thanks ";
TestItem.Exp = Exp;
//test to see if it exists
Assert.AreEqual(TestItem.Exp, Exp);
}
public void ImproveexpExist()
{
//create a new instance of the class we want to create
clsReviews TestItem = new clsReviews();;
//create some test data
string Improveexp = " no mate loved it thanks ! ";
TestItem.Improveexp = Improveexp;
//test to see if it exists
Assert.AreEqual(TestItem.Improveexp, Improveexp);
}
public void ReviewedProductMid()
{
clsReviews AnReviews = new clsReviews();
String Error = "";
string ReviewedProduct = "";
ReviewedProduct = ReviewedProduct.PadRight(25, 'a');
Error = AnReviews.Valid(ReviewedProduct, ReviewText,
DateAdded, ReviewerName);
Assert.AreEqual(Error, "");
}
public void DateAddedMin()
{
clsReviews AnReviews = new clsReviews();
String Error = "";
DateTime TestDate;
TestDate = DateTime.Now.Date;
string DateAdded = TestDate.ToString();
Error = AnReviews.Valid(ReviewedProduct, ReviewText,
DateAdded, ReviewerName);
Assert.AreEqual(Error, "");
}
public void FilterbyEmailOK()
{
clsReviews TestItem = new clsReviews();
//create an instance of the class we want to create
clsReviewsCollection AllReviews = new clsReviewsCollection();
//create an instance of the filtered data
clsReviewsCollection FilteredReviews = new clsReviewsCollection("");
//apply a blank string (should return all records)
FilteredReviews.FilterbyEmail("");
//test to see the two values are the same
Assert.AreEqual(AllReviews.Count, FilteredReviews.Count);
}
public void TestReviewedProductFound()
{
clsReviews AnReviews = new clsReviews();
Boolean Found = false;
Boolean OK = true;
Int32 ReviewsId = 2;
Found = AnReviews.Find(ReviewsId);
if (AnReviews.ReviewedProduct != "Man Utd socks")
{
OK = false;
}
Assert.IsTrue(OK);
}
public void TestReviewRatingFound()
{
clsReviews AnReviews = new clsReviews();
Boolean Found = false;
Boolean OK = true;
Int32 ReviewsId = 2;
Found = AnReviews.Find(ReviewsId);
if (AnReviews.ReviewsId != 2)
{
OK = false;
}
Assert.IsTrue(OK);
}
public void DateAddedExtremeMax()
{
clsReviews AnReviews = new clsReviews();
String Error = "";
DateTime TestDate;
TestDate = DateTime.Now.Date;
TestDate = TestDate.AddYears(100);
string DateAdded = TestDate.ToString();
Error = AnReviews.Valid(ReviewedProduct, ReviewText,
DateAdded, ReviewerName);
Assert.AreNotEqual(Error, "");
}
public void TestReviewTextFound()
{
clsReviews AnReviews = new clsReviews();
Boolean Found = false;
Boolean OK = true;
Int32 ReviewsId = 2;
Found = AnReviews.Find(ReviewsId);
if (AnReviews.ReviewText != "The product is bad")
{
OK = false;
}
Assert.IsTrue(OK);
}
public void FindMethodOK()
{
//create an instance of the class we want to create
clsReviews TestItem = new clsReviews();
//boolean variable to store the result of the validisation
Boolean Found = false;
//create some test data to use the method
Int32 ReviewId = 2002;
//Invoke the method
Found = TestItem.Find(ReviewId);
//test to see if it exists
Assert.IsTrue(Found);
}
