public void LogIn(string userName) { FormsAuthentication.RedirectFromLoginPage(userName, false); var user = _dbContext.Users.Single(u => u.Email == userName); user.LastLogin = DateTime.Now; _dbContext.SaveChanges(); }
public bool editQuestion(Question question) { var local = databaseContext.question.FirstOrDefault(c => c.UserId == question.UserId); databaseContext.Entry(local).State = EntityState.Detached; databaseContext.Entry(question).State = EntityState.Modified; // tagsOperations.updateTags(tags); databaseContext.SaveChanges(); return(true); }
public void SaveHandWrittenNotes(HandWritingNoteDTO notes) { try { var note = new HandWrittenNotes(); note.Notes = notes.Notes; note.GroupKey = GroupKeyGenerator(); ctx.HandWrittenNotes.Add(note); ctx.SaveChanges(); } catch (Exception ex) { ; } }
public ActionResult Create([Bind(Include = "Id,ExamName,Skill,ContempararyLevel,Created,Modified,IsActive")] ExamViewModel examViewModel) { if (ModelState.IsValid) { var exam = new Exams(); exam.ExamName = examViewModel.ExamName; exam.ContempararyLevel = examViewModel.ContempararyLevel; exam.Skill = examViewModel.Skill; db.Exams.Add(exam); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(examViewModel)); }
public int addTags(Tags tags) { System.Diagnostics.Debug.WriteLine(tags); var output = databaseContext.tags.Where(x => x.TagName == tags.TagName).ToList().Count; if (output > 0) { return(databaseContext.tags.FirstOrDefault(x => x.TagName == tags.TagName).QuestionTagId); } tags.CreationDate = DateTime.Now; databaseContext.tags.Add(tags); databaseContext.SaveChanges(); return(databaseContext.tags.FirstOrDefault(x => x.TagName == tags.TagName).QuestionTagId); }
// For adding the User public bool addUser(User user) { System.Diagnostics.Debug.WriteLine(user.UserEmail); var userData = databaseContext.user.Where(x => x.UserEmail == user.UserEmail).Count(); System.Diagnostics.Debug.WriteLine(userData); if (userData == 0) { user.CreationDate = DateTime.Now; databaseContext.user.Add(user); databaseContext.SaveChanges(); return(true); } else { return(false); } }
public IHttpActionResult AskQusetion(QuestionFormDTO questionForm) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } Question question = new Question { Title = questionForm.Title, Body = questionForm.Body, CreateDate = DateTime.Now }; db.Questions.Add(question); db.SaveChanges(); return(CreatedAtRoute("DefaultApi", new { id = question.Id }, question)); }
// GET: Answer public ActionResult Index([Bind(Prefix = "id")] int questionId) { var question = db.Questions.Where(q => q.Id == questionId); db.SaveChanges(); if (question != null) { var model = db.Questions.Where(e => e.Id == questionId).Select(o => new QuestionViewModel { Answers = db.Answers.Where(l => l.QuestionId == questionId).ToList(), Id = o.Id, IsActove = o.IsActove, Question = o.Name }).FirstOrDefault(); return(View(model)); } return(HttpNotFound()); //return View(db.Answers.ToList()); }
public int AskQuestion(string title, string body) { var user = _dbContext.Users.Single(u => u.Email == HttpContext.Current.User.Identity.Name); var question = new Question() { Title = title, Body = body, CreateDate = DateTime.Now, User = user }; try { _dbContext.Questions.Add(question); _dbContext.SaveChanges(); return(question.Id); } catch (Exception) { return(-1); } }
public void ManageVote(VoteType userVote, int id) { var user = _dbContext.Users.Single(u => u.Email == HttpContext.Current.User.Identity.Name); var answer = _dbContext.Answers.Single(q => q.Id == id); var userOldVoteVote = answer.Votes.SingleOrDefault(v => v.User == user); // Check if user voted before if (userOldVoteVote != null) { if ((VoteType)userOldVoteVote.VoteValue == userVote) // user wants to delete his/her vote { userOldVoteVote.VoteValue = (short)VoteType.Non; } else // user wants to change his/her vote { userOldVoteVote.VoteValue = (short)userVote; } userOldVoteVote.CreateDate = DateTime.Now; } else // if user did not vote until now, so create vote { var vote = new Vote() { User = user, Answer = answer, VoteValue = (short)userVote, CreateDate = DateTime.Now }; answer.Votes.Add(vote); } _dbContext.SaveChanges(); }
public ApplicationUser UpdateUser([FromBody] RegisterUser userInfo) { ApplicationUser user = GetUser(); //logged in user is only editing own profile if (user.Email == userInfo.Email) { user.FirstName = userInfo.FirstName; user.LastName = userInfo.LastName; user.CurrentStack = (CurrentStack)userInfo.CurrentStack; user.LinkedInAccountURL = userInfo.LinkedInAccountURL; // user.PasswordHash = userInfo.Password; _context.SaveChanges(); } return(user); }
public bool addReaction(UserReaction userreaction) { var output = databaseContext.userreaction.Where(d => d.AnswerId == userreaction.AnswerId && d.UserId == userreaction.UserId).ToList().Count(); if (output > 0) { return(false); } userreaction.CreationDate = DateTime.Now; databaseContext.userreaction.Add(userreaction); databaseContext.SaveChanges(); return(true); }
public bool addQuestion([FromBody] QuestionFromClient question) { string userId = _caller.Claims.Single(c => c.Type == "id").Value; ApplicationUser user = _context.Users.SingleOrDefault(u => u.Id == userId); Question q = new Question(); q.AskedBy = user; q.QuestionTitle = question.QuestionTitle; q.QuestionText = question.QuestionText; // add tags to question model (relationships will be saved when question is saved) foreach (int id in question.Tags) { q.Tags.Add(new QuestionTag(id)); } try { _context.Questions.Add(q); _context.SaveChanges(); return(true); } catch { return(false); } }
public bool Details(QuestionViewModel questionViewModel) { if (ModelState.IsValid) { var qustionDB = db.Questions.Where(l => l.Id == questionViewModel.Id).FirstOrDefault(); qustionDB.Name = questionViewModel.Question; qustionDB.ExamId = questionViewModel.ExamId; qustionDB.Modified = DateTime.Now; db.Questions.Update(qustionDB); db.SaveChanges(); db.Answers.RemoveRange(db.Answers.Where(p => p.QuestionId == questionViewModel.Id)); questionViewModel.Answers.ForEach(p => p.QuestionId = qustionDB.Id); db.Answers.AddRange(questionViewModel.Answers); db.SaveChanges(); return(true); } else { return(false); } }
// for edit the answer public bool editAnswer(Answer answer) { databaseContext.Entry(answer).State = EntityState.Modified; databaseContext.SaveChanges(); return(true); }