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; } }