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);
}