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);
}
public void ReportByReviewRatingNoneFound()
{
clsReviewsCollection FilteredReviews = new clsReviewsCollection();
FilteredReviews.ReportByReviewRating("x");
// Assert.AreEqual(0, FilteredReviews.Count);
}
void DeleteReviews1()
{
clsReviewsCollection Reviews = new clsReviewsCollection();
Reviews.ThisReviews.Find(ReviewsId);
Reviews.Delete();
}
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 FilterbyeMailTestDataFound()
{
//create an instance of the filtered data
clsReviewsCollection FilteredReviews = new clsReviewsCollection("");
//var to store outcome
Boolean OK = true;
//apply a primary key value
FilteredReviews.FilterbyEmail("*****@*****.**");
//check the correct number of records are found
if (FilteredReviews.Count == 12)
{
//check the first record is ID 2
if (FilteredReviews.ReviewList[0].ReviewId != 2000)
{
OK = false;
}
// check that the first record is ID
if (FilteredReviews.ReviewList[11].ReviewId != 2016)
{
OK = false;
}
}
else
{
OK = false;
}
//test to see there are records
Assert.IsTrue(OK);
}
public void ReportByReviewRatingTestDataFound()
{
clsReviewsCollection FilteredReviews = new clsReviewsCollection();
Boolean OK = true;
FilteredReviews.ReportByReviewRating("y");
if (FilteredReviews.Count == 2)
{
if (FilteredReviews.ReviewsList[0].ReviewsId != 36)
{
OK = false;
}
if (FilteredReviews.ReviewsList[1].ReviewsId != 37)
{
OK = false;
}
}
else
{
OK = false;
}
// Assert.IsTrue(OK);
}
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 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);
}
void Update()
{
//create an instance of the booking list
clsReviewsCollection Review = new clsReviewsCollection(User.Identity.Name);
//validate the data on the web form
//string foreName, string surname, string dateOfBirth, string gender, string contactNumber, string eMail, string flatNo, string houseNo, string postCode
String Error = Review.ThisReview.Valid(txtEmail.Text, txtExp.Text, txtImproveexp.Text);
//if the data is OK then add it to the object
if (Error == "")
{
//find the record to update
Review.ThisReview.Find(ReviewId);
//get the data entered by the user
Review.ThisReview.Email = Convert.ToString(txtEmail.Text);
Review.ThisReview.Exp = Convert.ToString(txtExp.Text);
Review.ThisReview.Improveexp = Convert.ToString(txtImproveexp.Text);
//CList.ThisCustomer.UserName = User.Identity.Name;
//update the record
Review.Update();
//all done so redirect back to the main page
// Response.Redirect("AdminHomepage.aspx");
lblError.Text = "update";
}
else
{
//report an error
lblError.Text = "There were problems with the data entered " + Error;
}
}
public void ReportByReviewRatingMethodOK()
{
clsReviewsCollection AllReviews = new clsReviewsCollection();
clsReviewsCollection FilteredReviews = new clsReviewsCollection();
FilteredReviews.ReportByReviewRating("");
Assert.AreEqual(AllReviews.Count, FilteredReviews.Count);
}
public void InstanceOK()
{
//create a new instance of the class we want to create
clsReviewsCollection AllReviews = new clsReviewsCollection();
//test to see if it exists
Assert.IsNotNull(AllReviews);
}
public void FilterbyEmailNoneFound()
{
//create an instance of the filtered data
clsReviewsCollection FilteredReviews = new clsReviewsCollection(" ");
//apply a blank string (should return all records)
FilteredReviews.FilterbyEmail("xxx xxx");
//test to see the two values are the same
Assert.AreEqual(0, FilteredReviews.Count);
}
protected void btnApply_Click(object sender, EventArgs e)
{
clsReviewsCollection Reviews = new clsReviewsCollection();
Reviews.ReportByReviewRating(lstReviewsList.Text);
lstReviewsList.DataSource = Reviews.ReviewsList;
lstReviewsList.DataValueField = "ReviewsId";
lstReviewsList.DataTextField = "ReviewRating";
lstReviewsList.DataBind();
}
protected void btnYes_Click(object sender, EventArgs e)
{
clsReviewsCollection Reviews = new clsReviewsCollection();
Reviews.ThisReviews.Find(ReviewsId);
Reviews.Delete();
Response.Redirect("ReviewsList.aspx");
/* DeleteReviews1();
* Response.Redirect("Default.aspx");*/
}
void DisplayReviews()
{
//create an instance of the booking list
clsReviewsCollection Review = new clsReviewsCollection(User.Identity.Name);
//find the record to update
Review.ThisReview.Find(ReviewId);
//display the data for this record
txtEmail.Text = Review.ThisReview.Email;
txtExp.Text = Review.ThisReview.Exp;
txtImproveexp.Text = Review.ThisReview.Improveexp;
}
void DeleteReviews()
{
////function to delete the selected record
//create a new instance of the Customer collection
clsReviewsCollection ReviewList = new clsReviewsCollection(User.Identity.Name);
//find the record to delete
ReviewList.ThisReview.Find(ReviewId);
//delete the record
ReviewList.Delete();
}
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);
}
void DisplayReviews()
{
clsReviewsCollection Reviews = new clsReviewsCollection();
Reviews.ThisReviews.Find(ReviewsId);
rvwsId.Text = Reviews.ThisReviews.ReviewsId.ToString();
rvwTextOK.Text = Reviews.ThisReviews.ReviewText;
rvwNameOK.Text = Reviews.ThisReviews.ReviewerName;
rvwdProdOK.Text = Reviews.ThisReviews.ReviewedProduct;
rvwRatOK.Text = Reviews.ThisReviews.ReviewRating.ToString();
dateAddOK.Text = Reviews.ThisReviews.DateAdded.ToString();
rvwAppOK.Text = Reviews.ThisReviews.ReviewApproved.ToString();
}
void DisplayReviews()
{
//create an instancew of the Customer Collection
clsReviewsCollection Review = new clsReviewsCollection(User.Identity.Name);
// set the data source to the list of countries in the collection
lstReviews.DataSource = Review.ReviewList;
// set the name of the primary key
lstReviews.DataValueField = "ReviewId";
// set the data field to display
lstReviews.DataTextField = "AllDetails";
//bind the data to the list
lstReviews.DataBind();
}
void FilterEmail(string Email)
{
//create an instance of the booking collection
clsReviewsCollection Review = new clsReviewsCollection();
Review.FilterbyEmail(Email);
//set the data source to the list of bookings in the collection
lstReviews.DataSource = Review.ReviewList;
//set the name of the primary key
lstReviews.DataValueField = "ReviewId";
//set the data field to display
lstReviews.DataTextField = "Email";
//bind the data to the list
lstReviews.DataBind();
}
public void ThisReviewsPropertyOK()
{
clsReviewsCollection AllReviews = new clsReviewsCollection();
clsReviews TestReviews = new clsReviews();
TestReviews.ReviewsId = 1;
TestReviews.ReviewApproved = true;
TestReviews.ReviewRating = 4;
TestReviews.ReviewerName = "Dave";
TestReviews.ReviewText = "Good Product";
TestReviews.ReviewedProduct = "Spurs Shorts";
TestReviews.DateAdded = DateTime.Now.Date;
AllReviews.ThisReviews = TestReviews;
Assert.AreEqual(AllReviews.ThisReviews, TestReviews);
}
public void ThisReviewPropertyOK()
{
//create an instance of the class we want to create
clsReviewsCollection AllReviews = new clsReviewsCollection();
//create some test data to assign to the property
//add an item to the list
clsReviews TestItem = new clsReviews();
//set its properties
TestItem.ReviewId = 1;
TestItem.Email = "*****@*****.**";
TestItem.Exp = "*****@*****.**";
TestItem.Improveexp = "*****@*****.**";
//assign the data to the property
AllReviews.ThisReview = TestItem;//test to see that it exists
Assert.AreEqual(AllReviews.ThisReview, TestItem);
}
public void ListAndCountOK()
{
clsReviewsCollection AllReviews = new clsReviewsCollection();
List <clsReviews> TestList = new List <clsReviews>();
clsReviews TestItem = new clsReviews();
TestItem.ReviewsId = 1;
TestItem.ReviewApproved = true;
TestItem.ReviewRating = 4;
TestItem.ReviewerName = "Dave";
TestItem.ReviewText = "Good Product";
TestItem.ReviewedProduct = "Spurs Shorts";
TestItem.DateAdded = DateTime.Now.Date;
TestList.Add(TestItem);
AllReviews.ReviewsList = TestList;
Assert.AreEqual(AllReviews.Count, TestList.Count);
}
void Add()
{
clsReviewsCollection Reviews = new clsReviewsCollection();
String Error = Reviews.ThisReviews.Valid(rvwTextOK.Text, rvwNameOK.Text, rvwdProdOK.Text, dateAddOK.Text);
if (Error == "")
{
Reviews.ThisReviews.ReviewText = rvwTextOK.Text;
Reviews.ThisReviews.ReviewerName = rvwNameOK.Text;
Reviews.ThisReviews.ReviewedProduct = rvwdProdOK.Text;
Reviews.ThisReviews.DateAdded = Convert.ToDateTime(dateAddOK.Text);
Reviews.ThisReviews.ReviewApproved = Convert.ToBoolean(rvwAppOK.Text);
Reviews.Add();
Response.Redirect("Default.aspx");
}
else
{
lblError.Text = "There were problems with the data entered" + Error;
}
}
public void ListAndCountOK()
{
//create an instance of the class we want to create
clsReviewsCollection AllReviews = new clsReviewsCollection();
//create some test data to assign to the property
//in this sceanario it needs to be a lists of objects
List <clsReviews> TestList = new List <clsReviews>();
//add an item to the list
//create the item of test data
clsReviews TestItem = new clsReviews();
//set its properties
TestItem.Email = "*****@*****.**";
TestItem.Exp = "*****@*****.**";
TestItem.Improveexp = "*****@*****.**";
//add the item to the test list
TestList.Add(TestItem);
//assign the data to the property
AllReviews.ReviewList = TestList;
//test to see that it exists
Assert.AreEqual(AllReviews.Count, TestList.Count);
}
public void DeleteMethodOK()
{
clsReviewsCollection AllReviews = new clsReviewsCollection();
clsReviews TestItem = new clsReviews();
Int32 PrimaryKey = 0;
TestItem.ReviewsId = 1;
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;
Boolean Found = AllReviews.ThisReviews.Find(PrimaryKey);
AllReviews.Delete();
// Assert.IsFalse(Found);
}
public void InstanceOk()
{
clsReviewsCollection AllReviews = new clsReviewsCollection();
Assert.IsNotNull(AllReviews);
}
/* protected void btnSubmit_Click(object sender, EventArgs e)
* {
*
* if (ReviewsId == -1)
* {
* Add();
* }
* else
* {
* Update();
* }
* }*/
protected void btnSubmit_Click(object sender, EventArgs e)
{
/* Error = AnReviews.Valid(ReviewedProduct, ReviewText,
* DateAdded, ReviewerName);
*
*
* if (Error == "")
* {
* AnReviews.ReviewsId = ReviewsId;
* AnReviews.ReviewerName = ReviewerName;
* AnReviews.ReviewText = ReviewText;
* AnReviews.ReviewedProduct = ReviewedProduct;
* AnReviews.DateAdded = Convert.ToDateTime(DateAdded);
* AnReviews.ReviewApproved = chkReviewApproved.Checked;
* AnReviews.ReviewRating = ReviewRating.ToString();
*
* clsReviewsCollection ReviewsList new clsReviewsCollection();
*
* if (ReviewsId == -1)
* {
* ReviewsList.ThisReviews = AnReviews;
* ReviewsList.Add();
* }
*
* else
* {
* ReviewsList.ThisReviews.Find(ReviewsId);
* ReviewsList.ThisReviews = AnReviews;
* ReviewsList.Update();
*
* }
* Response.Redirect("ReviewsList.aspx");
*
* }
* else
* {
* lblError.Text = Error;
* }*/
clsReviews Reviews = new clsReviews();
string ReviewRating = rvwRatOK.Text;
string ReviewText = rvwTextOK.Text;
string ReviewerName = rvwNameOK.Text;
string ReviewedProduct = rvwdProdOK.Text;
string DateAdded = dateAddOK.Text;
string ReviewApproved = rvwAppOK.Text;
string Error = "";
Error = AnReviews.Valid(ReviewText, ReviewerName, DateAdded, ReviewedProduct)
if (Error == "")
{
AnReviews.ReviewText = ReviewText;
AnReviews.ReviewerName = ReviewerName;
AnReviews.ReviewedProduct = ReviewedProduct;
AnReviews.DateAdded = Convert.ToDateTime(DateAdded);
AnReviews.ReviewApproved = ReviewApproved;
AnReviews.ReviewRating = ReviewRating.ToString();
clsReviewsCollection ReviewsList = new clsReviewsCollection();
ReviewsList.ThisReviews = AnReviews;
ReviewsList.Add();
Response.Redirect("ReviewsList.aspx");
}
else
{
lblError.Text = Error;
}
}
