public UserInterest AddUserInterest(int userid, int interestid) { var connection = new SqlConnection(ConnectionString); connection.Open(); var addUserInterests = connection.CreateCommand(); addUserInterests.CommandText = $@"Insert into [userinterests](userid, interestid) Output inserted.* Values(@userid, @interestid)"; addUserInterests.Parameters.AddWithValue("userid", userid); addUserInterests.Parameters.AddWithValue("interestid", interestid); var reader = addUserInterests.ExecuteReader(); if (reader.Read()) { var insertedId = (int)reader["Id"]; var newUserInterest = new UserInterest(userid, interestid) { Id = insertedId }; connection.Close(); return(newUserInterest); } throw new System.Exception("No interest added"); }
public IActionResult DeleteField(string ContentTypeID) { if (_user == null) { _user = _userManager.GetUserAsync(User).Result; } var interest = _db.ContentTypes.Where(c => c.Name == ContentTypeID).FirstOrDefault(); _db.Entry(_user) .Collection(x => x.Interests) .Load(); UserInterest userInterest = null; if (_user != null && interest != null) { userInterest = _user.Interests.Where(ui => ui.User == _user && ui.ContentType == interest).FirstOrDefault(); } if (userInterest != null) { _user.Interests.Remove(userInterest); _db.SaveChanges(); } return(RedirectToAction(nameof(MyContent))); }
public bool CheckIfSport(Sports[] sports, UserInterest userInterest, User foundUser) { for (int i = 0; i < sports.Length; i++) { if (sports[i].name == userInterest.Name) { if (ModelState.IsValid) { try { userInterest.UserId = foundUser.UserId; _repo.UserInterest.Create(userInterest); _repo.Save(); } catch (DbUpdateConcurrencyException) { if (!UserExists(foundUser.UserId)) { return(false); } else { throw; } } return(true); } } } return(false); }
public ActionResult Wall([Bind(Include = "UserName,Interest")] UserInterest @urinterest) { db.UserInterests.Add(@urinterest); //var user = await UserManager.FindAsync(model.UserName, model.Password); db.SaveChanges(); return(RedirectToAction("FindFriends", @urinterest)); }
// Add User Interest // public UserInterest AddUserInterest(int userId, int interestId) { using (var connection = new SqlConnection(ConnectionString)) { connection.Open(); var insertUserInterestCommand = connection.CreateCommand(); insertUserInterestCommand.CommandText = $@"Insert into userinterests (userId, interestId) Output inserted.* Values(@userId, @interestId)"; insertUserInterestCommand.Parameters.AddWithValue("userId", userId); insertUserInterestCommand.Parameters.AddWithValue("interestId", interestId); var reader = insertUserInterestCommand.ExecuteReader(); if (reader.Read()) { var insertedUserId = (int)reader["userId"]; var insertedInterestId = (int)reader["interestId"]; var insertedId = (int)reader["Id"]; var newUserInterest = new UserInterest(insertedUserId, insertedInterestId) { Id = insertedId }; return(newUserInterest); } } throw new Exception("Cannot Find Any User Interests"); }
public void TestTeaching() { string userName = "******"; List <BagOfWords> bags = feedService.GetAllBags(); UserInterest interest = userService.GetUser(userName); if (interest == null) { interest = userService.AddUser(userName); FeedItem document = feedService.GetDocument("tag:blogger.com,1999:blog-19732346.post-6636802898282623833"); userService.LikeDocument(interest, document); document = feedService.GetDocument("tag:blogger.com,1999:blog-19732346.post-1441194024531049182"); userService.LikeDocument(interest, document); } BagOfWords userBag = new BagOfWords(interest.Id, interest); interest.Ratings = userBag.CalculateRatings(bags).Where(rating => rating.Rating > 0).ToList(); userService.UpdateUser(interest); //userService.RemoveUser(userName); }
public async Task <Unit> Handle(AddUserInterestsCommand request, CancellationToken cancellationToken) { var user = await _context.Users.SingleOrDefaultAsync(x => x.Email == _userAccessor.GetEmail(), cancellationToken : cancellationToken); if (_context.UserInterests.Any(x => x.AppUser.Id == user.Id)) { _context.UserInterests.RemoveRange(_context.UserInterests.Where(x => x.AppUser == user)); } foreach (var interest in request.Ids) { if (!_context.Categories.Any(x => x.Id == interest)) { throw new RestException(HttpStatusCode.NotFound, new { Interest = "Not found" }); } var interestToAdd = new UserInterest { AppUser = user, CategoryId = interest }; await _context.UserInterests.AddAsync(interestToAdd, cancellationToken); } var success = await _context.SaveChangesAsync(cancellationToken) > 0; if (success) { return(Unit.Value); } throw new Exception("problem saving new post."); }
public EmailSendApplicationModel(UserInterest lead) { LandlordEmail = lead.Building.User.Email; LandlordFirstName = lead.Building.User.FirstName; LeadName = string.Format("{0} {1}", lead.User.FirstName, lead.User.LastName); BuildingId = lead.BuildingId; }
public void LikeDocument(string name, FeedItem document) { UserInterestRepository uiRep = new UserInterestRepository(); UserInterest interest = uiRep.Get(name); LikeDocument(interest, document); }
public void LikeDocument(UserInterest interest, FeedItem document) { UserInterestRepository uiRep = new UserInterestRepository(); interest.AddDocument(document); uiRep.Update(interest); }
public List <UserInterest> GetAllUserInterests() { var userInterests = new List <UserInterest>(); var connection = new SqlConnection("Server=localhost;Database=ClinkedIn;Trusted_Connection=True;"); connection.Open(); var getAllUserInterestsCommand = connection.CreateCommand(); getAllUserInterestsCommand.CommandText = @"select u.Name, i.Name Interest from UserInterestJoin ui left join Users u on u.Id = ui.UserId left join Interests i on i.Id = ui.InterestId order by u.Name"; var reader = getAllUserInterestsCommand.ExecuteReader(); while (reader.Read()) { var name = (string)reader["Name"]; var interest = (string)reader["Interest"]; var userInterest = new UserInterest(name, interest); userInterests.Add(userInterest); } connection.Close(); return(userInterests); }
public async Task <bool> Handle( Command request, CancellationToken cancellationToken ) { Guid id = request.UserInterestId; UserInterest existingUserInterest = _interestsDbContext.UserInterests.Find(id); if (existingUserInterest != null) { Guid interestId = existingUserInterest.IdInterest; _interestsDbContext.UserInterests.Remove(existingUserInterest); Interest existingInterest = _interestsDbContext.Interests.Find(interestId); if (existingInterest != null) { existingInterest.PeopleCount = existingInterest.PeopleCount - 1; _interestsDbContext.Interests.Update(existingInterest); return(await _interestsDbContext.SaveChangesAsync() > 0); } else { throw new AppException($"The interest {interestId} already as not been found"); } } else { throw new AppException($"The user interest {id} already as not been found"); } }
// GET: Admin/Delete/5 public ActionResult DeleteInterest(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } String user = User.Identity.GetUserId(); var AdminCheck = (from p in db.CppUsers where p.AspNetUserId == user select new { p.Id, p.PermissionLevel }).FirstOrDefault(); if (AdminCheck.PermissionLevel == 1) { UserInterest userInterest = db.UserInterests.Find(id); if (userInterest == null) { return(HttpNotFound()); } return(View(userInterest)); } else { return(HttpNotFound()); } }
// Get All User Interests // public List <UserInterest> GetAll() { var userInterests = new List <UserInterest>(); var connection = new SqlConnection(ConnectionString); connection.Open(); var getAllUserInterestsCommand = connection.CreateCommand(); getAllUserInterestsCommand.CommandText = @"select userId, interestId, id from userinterests"; var reader = getAllUserInterestsCommand.ExecuteReader(); while (reader.Read()) { var id = (int)reader["Id"]; var userId = (int)reader["userId"]; var interestId = (int)reader["interestId"]; var userinterest = new UserInterest(userId, interestId) { Id = id }; userInterests.Add(userinterest); } connection.Close(); return(userInterests); }
public ActionResult DeleteInterestConfirmed(int id) { UserInterest userInterest = db.UserInterests.Find(id); db.UserInterests.Remove(userInterest); db.SaveChanges(); return(RedirectToAction("Admin")); }
public IActionResult RemoveInterest(int id, UserInterest userInterest) { var foundUserInterest = _repo.UserInterest.FindByCondition(a => a.UserInterestId == id).SingleOrDefault(); _repo.UserInterest.Delete(foundUserInterest); _repo.Save(); return(RedirectToAction(nameof(ViewInterests))); }
/// <summary>Snippet for GetUserInterest</summary> /// <remarks> /// This snippet has been automatically generated for illustrative purposes only. /// It may require modifications to work in your environment. /// </remarks> public void GetUserInterest() { // Create client UserInterestServiceClient userInterestServiceClient = UserInterestServiceClient.Create(); // Initialize request argument(s) string resourceName = "customers/[CUSTOMER_ID]/userInterests/[USER_INTEREST_ID]"; // Make the request UserInterest response = userInterestServiceClient.GetUserInterest(resourceName); }
/// <summary>Snippet for GetUserInterest</summary> /// <remarks> /// This snippet has been automatically generated for illustrative purposes only. /// It may require modifications to work in your environment. /// </remarks> public void GetUserInterestResourceNames() { // Create client UserInterestServiceClient userInterestServiceClient = UserInterestServiceClient.Create(); // Initialize request argument(s) UserInterestName resourceName = UserInterestName.FromCustomerUserInterest("[CUSTOMER_ID]", "[USER_INTEREST_ID]"); // Make the request UserInterest response = userInterestServiceClient.GetUserInterest(resourceName); }
public ActionResult FindFriends([Bind(Include = "UserName,Interest")] UserInterest @urinterest) { String a = @urinterest.Interest; var query = from c in db.UserInterests where c.Interest == a select c; return(View(query.ToList())); }
/// <summary>Snippet for GetUserInterestAsync</summary> /// <remarks> /// This snippet has been automatically generated for illustrative purposes only. /// It may require modifications to work in your environment. /// </remarks> public async Task GetUserInterestAsync() { // Create client UserInterestServiceClient userInterestServiceClient = await UserInterestServiceClient.CreateAsync(); // Initialize request argument(s) string resourceName = "customers/[CUSTOMER_ID]/userInterests/[USER_INTEREST_ID]"; // Make the request UserInterest response = await userInterestServiceClient.GetUserInterestAsync(resourceName); }
public int DeleteSkills([FromBody] UserInterest interest) { FRDBEntities db = new FRDBEntities(); using (db) { return(db.DeleteUserInterest(interest.user, interest.id)); } }
public ActionResult EditInterest([Bind(Include = "Id,Interest")] UserInterest userInterest) { if (ModelState.IsValid) { db.Entry(userInterest).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Admin")); } return(View(userInterest)); }
/// <summary>Snippet for GetUserInterestAsync</summary> /// <remarks> /// This snippet has been automatically generated for illustrative purposes only. /// It may require modifications to work in your environment. /// </remarks> public async Task GetUserInterestResourceNamesAsync() { // Create client UserInterestServiceClient userInterestServiceClient = await UserInterestServiceClient.CreateAsync(); // Initialize request argument(s) UserInterestName resourceName = UserInterestName.FromCustomerUserInterest("[CUSTOMER_ID]", "[USER_INTEREST_ID]"); // Make the request UserInterest response = await userInterestServiceClient.GetUserInterestAsync(resourceName); }
/// <summary>Snippet for GetUserInterest</summary> public void GetUserInterest() { // Snippet: GetUserInterest(string, CallSettings) // Create client UserInterestServiceClient userInterestServiceClient = UserInterestServiceClient.Create(); // Initialize request argument(s) string resourceName = "customers/[CUSTOMER]/userInterests/[USER_INTEREST]"; // Make the request UserInterest response = userInterestServiceClient.GetUserInterest(resourceName); // End snippet }
/// <summary> /// Creates the interest in building from the user to the current /// listing. /// </summary> /// <param name="username">The username.</param> /// <param name="listingId">The listing id.</param> /// <returns> /// A status of whether or not the interest was created. /// </returns> public Status <UserInterest> CreateInterestInBuilding(string username, long listingId, string message) { if (listingId == 0) { return(Status.ValidationError <UserInterest>(null, "listingId", "listingId is required")); } if (string.IsNullOrWhiteSpace(username)) { return(Status.ValidationError <UserInterest>(null, "username", "username is required")); } using (var context = new RentlerContext()) { try { User user = (from u in context.Users where u.Username == username select u).SingleOrDefault(); if (user == null) { return(Status.NotFound <UserInterest>()); } UserInterest newInterest = new UserInterest() { BuildingId = listingId, UserId = user.UserId, Message = message }; context.UserInterests.Add(newInterest); context.SaveChanges(); // loads the building, which generated this interest, into newInterest context.Entry(newInterest).Reference(e => e.Building).Load(); // notify landlord of interest // TODO: if we are unable to send this email we need a way to allow the user // to re-notify the Landlord without requiring them to continue to create // interests EmailListingInterestedModel model = new EmailListingInterestedModel(newInterest); mailer.Interested(model); return(Status.OK <UserInterest>(newInterest)); } catch (Exception ex) { // log exception return(Status.Error <UserInterest>("System was unable to create interest", null)); } } }
/// <summary>Snippet for GetUserInterest</summary> public void GetUserInterestResourceNames() { // Snippet: GetUserInterest(UserInterestName, CallSettings) // Create client UserInterestServiceClient userInterestServiceClient = UserInterestServiceClient.Create(); // Initialize request argument(s) UserInterestName resourceName = UserInterestName.FromCustomerUserInterest("[CUSTOMER]", "[USER_INTEREST]"); // Make the request UserInterest response = userInterestServiceClient.GetUserInterest(resourceName); // End snippet }
public ActionResult AddInterest([Bind(Include = "Interest")] UserInterest userInterest) { if (ModelState.IsValid) { db.UserInterests.Add(userInterest); db.SaveChanges(); return(RedirectToAction("Admin")); } return(View(userInterest)); }
public AccountSendAppModel(UserInterest lead) { this.Lead = lead; if (lead.User == null || lead.User.UserApplication == null) { this.Input = new AccountSendAppInputModel(); } this.Input = new AccountSendAppInputModel(lead.User.UserApplication); }
public async Task <IHttpActionResult> AddInterest(UserInterest Interest) { try { adminusermanagerlogic.AddInterest(Interest); return(Ok()); } catch (Exception ex) { return(ResponseMessage(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, "Error Occured Internally"))); } }
public BagOfWords(string name, UserInterest interest) : this() { Name = name; Interest = interest; foreach (Label label in interest.Labels) { Labels.Add(label.Name, new WordFrequency() { Count = label.Count, Frequency = label.Frequency }); } }
public EmailRequestApplicationModel(UserInterest interest) { this.Address1 = interest.Building.Address1; this.Address2 = interest.Building.Address2; this.City = interest.Building.City; this.State = interest.Building.State; this.Zip = interest.Building.Zip; this.LandlordEmail = interest.Building.User.Email; this.LeadEmail = interest.User.Email; this.LeadFirstName = interest.User.FirstName; this.LeadId = interest.UserInterestId; this.Text = interest.ResponseMessage; }
public EmailListingInterestedModel(UserInterest interest) { this.Address1 = interest.Building.Address1; this.Address2 = interest.Building.Address2; this.City = interest.Building.City; this.State = interest.Building.State; this.Zip = interest.Building.Zip; this.LandlordEmail = interest.Building.User.Email; this.LandlordName = string.Format("{0} {1}", interest.Building.User.FirstName, interest.Building.User.LastName); this.LeadEmail = interest.User.Email; this.LeadName = string.Format("{0} {1}", interest.User.FirstName, interest.User.LastName); this.LeadId = interest.UserInterestId; this.Text = interest.Message; }
public PropertyViewLeadModel(UserInterest lead) { this.Lead = lead; }
public PropertyRequestAppModel(UserInterest userInterest) { this.Lead = userInterest; this.Input = new PropertyRequestAppInputModel(); }
public AccountSendAppModel(UserInterest lead, UserApplication application) { this.Lead = lead; this.Input = new AccountSendAppInputModel(application); }
public AccountSendAppModel(UserInterest lead) { this.Lead = lead; if (lead.User == null || lead.User.UserApplication == null) this.Input = new AccountSendAppInputModel(); this.Input = new AccountSendAppInputModel(lead.User.UserApplication); }