private void RejectOffer() { //sends an email to the person making the offer and delete the offer from the database // //var to store the email address of the person making the offer string OfferEMail; //var to store the user name of the person making the offer string OfferUserName; //var to store the title of the offer string OfferTitle; //declare an instance of my email object clsEMail AnEMail = new clsEMail(); //var to store successful sending of the email Boolean Success; //get the email address of the person making the offer OfferEMail = GetOfferEMail(OfferNo); //get the user name of the person making the offer OfferUserName = GetOfferUserName(OfferNo); //get the title of the item on offer OfferTitle = GetOfferTitle(OfferNo); //send a rejection email to the person who made the offer Success = AnEMail.SendEMail("dvd.mdb", OfferEMail, "Your swap shop offer", ThisSite.SiteOwner + " has declined your offer of " + OfferTitle); //find the record for this offer in the database clsDataConnection AnOffer = new clsDataConnection("select * from offer where offerno=" + OfferNo); //if the record is found if (AnOffer.Count == 1) { //delete it AnOffer.RemoveRecord(0); //save the changes AnOffer.SaveChanges(); } }
private void RemoveWishListItem(int WishListID) { //this sub removes a wish list item identified by wish list id (primary key) // //open a connection to the wish list table clsDataConnection WishList = new clsDataConnection("select * from wishlist where wishlistno=" + WishListID); //if the record is found if (WishList.Count == 1) { //remove the record WishList.RemoveRecord(0); //save the changes WishList.SaveChanges(); } }
private void DeleteSwap() { //this sub deletes the swap identified by swapno // //find the record in the database clsDataConnection ASwap = new clsDataConnection("select * from swap where swapno=" + SwapNo); //if the record is found if (ASwap.Count == 1) { //remove the record ASwap.RemoveRecord(0); //save the changes ASwap.SaveChanges(); } }