/** * return User object correspondin to the uName and password parameters, null if such a user does not exist in the database **/ public User login(string uName, string pass) { uName = uName.Replace("'", "''"); pass = pass.Replace("'", "''"); User loggedIn = null; try { DataTier.UsersDBDataContext NIData = new DataTier.UsersDBDataContext(); var query = from user in NIData.Users where (user.UserName.Equals(uName) && user.Password.Equals(pass)) select user; // now create business objects from the Station entities, and build a list // to return: foreach (var user in query) { var test = user.Seller; loggedIn = new User(user.UserID, user.UserName, user.Password, user.FirstName, user.LastName, user.Email, (user.Seller == 1)); } } catch (Exception ex) { string msg = string.Format("Error: '{0}'", ex.Message); throw new ApplicationException(msg); } return(loggedIn); }
/** * return all listings posted by the User given **/ public DataTable listingsFromUser(User u) { DataTable listings = new DataTable(); listings.Columns.Add("ListingID"); listings.Columns.Add("StAddr"); listings.Columns.Add("ZipCode"); listings.Columns.Add("SqFeet"); listings.Columns.Add("NoBath"); listings.Columns.Add("NoBed"); listings.Columns.Add("Type"); listings.Columns.Add("Price"); try { DataTier.UsersDBDataContext NIData = new DataTier.UsersDBDataContext(); var query = from listing in NIData.Listings where listing.UserID.Equals(u.UserID) select listing; foreach (var listing in query) { listings.Rows.Add(listing.ListingID, listing.StAddr, listing.ZipCode, listing.SqFeet, listing.NoBath, listing.NoBed, listing.Type, listing.Price); } } catch (Exception ex) { string msg = string.Format("Error: '{0}'", ex.Message); throw new ApplicationException(msg); } return(listings); }
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); } }
/** * retun the user with given userID **/ public User getUser(int userID) { User retval = null; try { DataTier.UsersDBDataContext NIData = new DataTier.UsersDBDataContext(); var query = from user in NIData.Users where (user.UserID == userID) select user; // now create business objects from the Station entities, and build a list // to return: foreach (var user in query) { var test = user.Seller; retval = new User(user.UserID, user.UserName, user.Password, user.FirstName, user.LastName, user.Email, (user.Seller == 1)); } } catch (Exception ex) { string msg = string.Format("Error: '{0}'", ex.Message); throw new ApplicationException(msg); } return(retval); }
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); } }
public Message getMessage(int messageID) { Message retval = null; try { DataTier.UsersDBDataContext NIData = new DataTier.UsersDBDataContext(); var query = from message in NIData.Messages where (message.MessageID == messageID) select message; // now create business objects from the Station entities, and build a list // to return: foreach (var message in query) { retval = new Message(message.MessageID, message.SenderID, message.ReceiverID, message.ThreadID, message.MessageBody); } } catch (Exception ex) { string msg = string.Format("Error: '{0}'", ex.Message); throw new ApplicationException(msg); } return(retval); }
/** * return all listings in database as a list of Listing objects **/ public IReadOnlyList <Listing> search(int zipCode, string type, decimal min, decimal max, int minBeds, int maxBeds, int minSq, int maxSq, double minBaths, double maxBaths) { List <Listing> listings = new List <Listing>(); try { DataTier.UsersDBDataContext NIData = new DataTier.UsersDBDataContext(); var query = from listing in NIData.Listings select listing; if (zipCode == 0) // no zip code { if (type == null || type.Equals("")) // no type { query = from listing in NIData.Listings where ((listing.Price >= min) && (listing.Price <= max) && (listing.SqFeet >= minSq) && (listing.SqFeet <= maxSq) && (listing.NoBed >= minBeds) && (listing.NoBed <= maxBeds) && (listing.NoBath >= minBaths) && (listing.NoBath <= maxBaths)) select listing; } else // has type { query = from listing in NIData.Listings where ((listing.Price >= min) && (listing.Price <= max) && (listing.SqFeet >= minSq) && (listing.SqFeet <= maxSq) && (listing.NoBed >= minBeds) && (listing.NoBed <= maxBeds) && (listing.NoBath >= minBaths) && (listing.NoBath <= maxBaths) && (listing.Type.Equals(type))) select listing; } } else // has zip code { if (type == null || type.Equals("")) // no type { query = from listing in NIData.Listings where ((listing.Price >= min) && (listing.Price <= max) && (listing.SqFeet >= minSq) && (listing.SqFeet <= maxSq) && (listing.NoBed >= minBeds) && (listing.NoBed <= maxBeds) && (listing.NoBath >= minBaths) && (listing.NoBath <= maxBaths) && (listing.ZipCode == zipCode)) select listing; } else // has type { query = from listing in NIData.Listings where ((listing.Price >= min) && (listing.Price <= max) && (listing.SqFeet >= minSq) && (listing.SqFeet <= maxSq) && (listing.NoBed >= minBeds) && (listing.NoBed <= maxBeds) && (listing.NoBath >= minBaths) && (listing.NoBath <= maxBaths) && (listing.ZipCode == zipCode) && (listing.Type.Equals(type))) select listing; } } foreach (var listing in query) { Listing s = new Listing(listing.ListingID, listing.UserID, listing.StAddr, listing.ZipCode, listing.SqFeet, listing.NoBath, listing.NoBed, listing.Type, listing.Price, listing.Picture); listings.Add(s); } } catch (Exception ex) { string msg = string.Format("Error: '{0}'", ex.Message); throw new ApplicationException(msg); } return(listings); }
public IReadOnlyList <Message> getMessages(User u) { List <Message> messages = new List <Message>(); try { DataTier.UsersDBDataContext NIData = new DataTier.UsersDBDataContext(); var query = from message in NIData.Messages where message.ReceiverID == u.UserID select message; foreach (var message in query) { Message s = new Message(message.MessageID, message.SenderID, message.ReceiverID, message.ThreadID, message.MessageBody); messages.Add(s); } } catch (Exception ex) { string msg = string.Format("Error: '{0}'", ex.Message); throw new ApplicationException(msg); } return(messages); }
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); }
public Listing getListing(int listid) { Listing selected = null; try { DataTier.UsersDBDataContext NIData = new DataTier.UsersDBDataContext(); var query = from listing in NIData.Listings where listing.ListingID == listid select listing; // now create business objects from the Station entities, and build a list // to return: foreach (var listing in query) { selected = new Listing(listing.ListingID, listing.UserID, listing.StAddr, listing.ZipCode, listing.SqFeet, listing.NoBath, listing.NoBed, listing.Type, listing.Price, listing.Picture); } } catch (Exception ex) { string msg = string.Format("Error: '{0}'", ex.Message); throw new ApplicationException(msg); } return(selected); }
public double getCrimeRate(int zip) { try { DataTier.UsersDBDataContext NIData = new DataTier.UsersDBDataContext(); var query = from rate in NIData.NEIGHBORHOOD_CRIMERATEs where rate.CrimeZipCodes == zip select rate.CrimeRate; return(query.Average()); } catch (Exception ex) { return(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); }
public IReadOnlyList <String> getHospitals(int zip) { List <String> hospitals = new List <String>(); try { DataTier.UsersDBDataContext NIData = new DataTier.UsersDBDataContext(); var query = (from hospital in NIData.NEIGHBORHOOD_HOSPITALs where hospital.HospitalZipCode == zip select hospital).Take(5); foreach (var hospital in query) { hospitals.Add(hospital.HospitalName); } } catch (Exception ex) { string msg = string.Format("Error: '{0}'", ex.Message); throw new ApplicationException(msg); } return(hospitals); }
public IReadOnlyList <String> getSchools(int zip) { List <String> schools = new List <String>(); try { DataTier.UsersDBDataContext NIData = new DataTier.UsersDBDataContext(); var query = (from school in NIData.NEIGHBORHOOD_SCHOOLs where school.SchoolZipCode == zip select school).Take(5); foreach (var school in query) { schools.Add(school.SchoolName); } } catch (Exception ex) { string msg = string.Format("Error: '{0}'", ex.Message); throw new ApplicationException(msg); } return(schools); }
public IReadOnlyList <String> getPoliceStations(int zip) { List <String> policeStations = new List <String>(); try { DataTier.UsersDBDataContext NIData = new DataTier.UsersDBDataContext(); var query = (from policeStation in NIData.NEIGHBORHOOD_POLICESTATIONs where policeStation.StationZipCode == zip select policeStation).Take(5); foreach (var policeStation in query) { policeStations.Add(policeStation.StationAdress); } } catch (Exception ex) { string msg = string.Format("Error: '{0}'", ex.Message); throw new ApplicationException(msg); } return(policeStations); }
/** * 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); }
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); } }
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); } }
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. } }
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. } }