コード例 #1
0
        public bool changeUserName(User u, string nUName)
        {
            DataTier.UsersDBDataContext NIData = new DataTier.UsersDBDataContext();

            var query = from user in NIData.Users
                        where (user.UserID == u.UserID)
                        select user;

            // now create business objects from the Station entities, and build a list
            // to return:
            foreach (var user in query)
            {
                user.UserName = nUName;
            }


            try
            {
                NIData.SubmitChanges();
                return(true);
            }
            catch (Exception ex)
            {
                return(false);
            }
        }
コード例 #2
0
        public bool changeAddr(Listing l, string newAddr)
        {
            newAddr = newAddr.Replace("'", "''");
            DataTier.UsersDBDataContext NIData = new DataTier.UsersDBDataContext();

            var query = from listing in NIData.Listings
                        where (listing.ListingID == l.ListingID)
                        select listing;

            foreach (var listing in query)
            {
                listing.StAddr = newAddr;
            }


            try
            {
                NIData.SubmitChanges();
                return(true);
            }
            catch (Exception ex)
            {
                return(false);
            }
        }
コード例 #3
0
        public bool postListing(User u, string stAddr, int zipCode, int sqFeet, float noBath, int noBed, string type, decimal price, string picture)
        {
            DataTier.Listing newListing = new DataTier.Listing();
            newListing.UserID  = u.UserID;
            newListing.StAddr  = stAddr.Replace("'", "''");
            newListing.ZipCode = zipCode;
            newListing.SqFeet  = sqFeet;
            newListing.NoBath  = noBath;
            newListing.NoBed   = noBed;
            newListing.Type    = type;
            newListing.Price   = price;
            newListing.Picture = picture;

            try
            {
                DataTier.UsersDBDataContext NIData = new DataTier.UsersDBDataContext();
                NIData.Listings.InsertOnSubmit(newListing);
                NIData.SubmitChanges();
            }
            catch (Exception ex)
            {
                return(false);
            }
            return(true);
        }
コード例 #4
0
        public bool sendMessage(string message, User sender, int reciever, int threadid)
        {
            DataTier.Message newMessage = new DataTier.Message();
            newMessage.SenderID    = sender.UserID;
            newMessage.ReceiverID  = reciever;
            newMessage.MessageBody = message;
            newMessage.ThreadID    = threadid;

            try
            {
                DataTier.UsersDBDataContext NIData = new DataTier.UsersDBDataContext();
                NIData.Messages.InsertOnSubmit(newMessage);
                NIData.SubmitChanges();
            }
            catch (Exception ex)
            {
                return(false);
            }
            return(true);
        }
コード例 #5
0
        public bool changePrice(Listing l, decimal newprice)
        {
            DataTier.UsersDBDataContext NIData = new DataTier.UsersDBDataContext();

            var query = from listing in NIData.Listings
                        where (listing.ListingID == l.ListingID)
                        select listing;

            foreach (var listing in query)
            {
                listing.Price = newprice;
            }

            try
            {
                NIData.SubmitChanges();
                return(true);
            }
            catch (Exception ex)
            {
                return(false);
            }
        }
コード例 #6
0
        public bool changeBeds(Listing l, int newbeds)
        {
            DataTier.UsersDBDataContext NIData = new DataTier.UsersDBDataContext();

            var query = from listing in NIData.Listings
                        where (listing.ListingID == l.ListingID)
                        select listing;

            foreach (var listing in query)
            {
                listing.NoBed = newbeds;
            }

            try
            {
                NIData.SubmitChanges();
                return(true);
            }
            catch (Exception ex)
            {
                return(false);
            }
        }
コード例 #7
0
        /**
         * Create a new user account in database, return true on success, false on failure
         **/
        public bool createAccount(string uName, string pass, string fName, string lName, string email, string phone, byte seller)
        {
            DataTier.User newUser = new DataTier.User();
            newUser.UserName  = uName.Replace("'", "''");
            newUser.Password  = pass.Replace("'", "''");
            newUser.FirstName = fName.Replace("'", "''");
            newUser.LastName  = lName.Replace("'", "''");
            newUser.Email     = email.Replace("'", "''");
            newUser.MobileNo  = phone.Replace("'", "''");
            newUser.Seller    = seller;

            try
            {
                DataTier.UsersDBDataContext NIData = new DataTier.UsersDBDataContext();
                NIData.Users.InsertOnSubmit(newUser);
                NIData.SubmitChanges();
            }
            catch (Exception ex)
            {
                return(false);
            }
            return(true);
        }
コード例 #8
0
        public bool deleteMessage(int mid)
        {
            DataTier.UsersDBDataContext NIData = new DataTier.UsersDBDataContext();
            var deleteMessages = from message in NIData.Messages
                                 where message.MessageID == mid
                                 select message;

            foreach (var message in deleteMessages)
            {
                NIData.Messages.DeleteOnSubmit(message);
            }

            try
            {
                NIData.SubmitChanges();
                return(true);
            }
            catch (Exception e)
            {
                Console.WriteLine(e);
                return(false);
                // Provide for exceptions.
            }
        }
コード例 #9
0
        public bool removeListing(string addr)
        {
            DataTier.UsersDBDataContext NIData = new DataTier.UsersDBDataContext();
            var deleteOrderDetails             = from listing in NIData.Listings
                                                 where listing.StAddr.Equals(addr)
                                                 select listing;

            foreach (var detail in deleteOrderDetails)
            {
                NIData.Listings.DeleteOnSubmit(detail);
            }

            try
            {
                NIData.SubmitChanges();
                return(true);
            }
            catch (Exception e)
            {
                Console.WriteLine(e);
                return(false);
                // Provide for exceptions.
            }
        }