public ActionResult SatisfiedQuestion()
{
CommunityDbContext context = new CommunityDbContext();
var question = context.UserQuestions.Take(50).OrderByDescending(i => i.QuestionDate).Where(i => i.IsSatisfied == 1);
return(View(question));
}
public ActionResult TopUnliked()
{
CommunityDbContext context = new CommunityDbContext();
var question = context.UserQuestions.Take(20).OrderByDescending(i => i.Unlike);
return(View(question));
}
/// <summary>
/// Gets information from the data source for a user. Provides an option to update the last-activity date/time stamp for the user.
/// </summary>
/// <returns>
/// A <see cref="T:System.Web.Security.MembershipUser"/> object populated with the specified user's information from the data source.
/// </returns>
/// <param name="username">The name of the user to get information for. </param><param name="userIsOnline">true to update the last-activity date/time stamp for the user; false to return user information without updating the last-activity date/time stamp for the user. </param>
public override MembershipUser GetUser(string username, bool userIsOnline)
{
var cacheKey = string.Format("UserData_{0}", username);
if (HttpRuntime.Cache[cacheKey] != null)
{
return((CustomMembershipUser)HttpRuntime.Cache[cacheKey]);
}
using (var context = new CommunityDbContext())
{
var user = (from u in context.UserModels
where String.Compare(u.UserName, username, StringComparison.OrdinalIgnoreCase) == 0
select u).FirstOrDefault();
if (user == null)
{
return(null);
}
var membershipUser = new CustomMembershipUser(user);
//Store in cache
HttpRuntime.Cache.Insert(cacheKey, membershipUser, null, DateTime.Now.AddMinutes(_cacheTimeoutInMinutes), Cache.NoSlidingExpiration);
return(membershipUser);
}
}
public ActionResult AddCategory(Category cat)
{
CommunityDbContext context = new CommunityDbContext();
context.Categories.Add(cat);
context.SaveChanges();
return(Redirect("Index"));
}
public ActionResult AskQuestion()
{
CommunityDbContext context = new CommunityDbContext();
ViewBag.Categories = context.Categories.ToList();
//ViewBag.Categories=
return(View());
}
// GET: Action
public ActionResult Index()
{
CommunityDbContext context = new CommunityDbContext();
UserModel model = new UserModel();
ViewBag.Categories = context.Categories.Take(10).ToList();
ViewBag.User = context.UserModels.Take(5).OrderByDescending(id => id.UserRating).ToList();;
return(View(context.UserQuestions.Take(20).OrderByDescending(id => id.QuestionRating).ToList()));
}
public PartialViewResult MatchAny(string message)
{
CommunityDbContext context = new CommunityDbContext();
List <UserQuestion> model = context.UserQuestions
.Where(s => s.QuestionHeader.Contains(message))
.Select(s => s).ToList();
return(PartialView("_Search", model));
}
// GET: ViewAsCategory
public ActionResult view(int id)
{
CommunityDbContext context = new CommunityDbContext();
Category category = new Category();
ViewBag.CategoryName = context.Categories.Where(a => a.CategoryId == id).ToList();
//= c_name;
return(View(context.UserQuestions.Where(i => i.CategoryId == id)));
}
public ActionResult UnLike(int id)
{
CommunityDbContext context = new CommunityDbContext();
var question = context.UserQuestions.SingleOrDefault(item => item.QuestionId == id);
int value = (Convert.ToInt32(question.Unlike)) + 1;
question.Unlike = value;
context.SaveChanges();
return(Redirect(Request.UrlReferrer.AbsolutePath));
}
public ActionResult UnansweredQuestion()
{
CommunityDbContext context = new CommunityDbContext();
var answer = context.Answers.Select(i => i.QuestionId).Distinct().ToList();
var question = from c in context.UserQuestions
where !(from a in context.Answers select a.QuestionNo).Contains(c.QuestionId)
select c;
return(View(question));
}
public ActionResult ViewQuestion(int id)
{
this.id = id;
CommunityDbContext context = new CommunityDbContext();
ViewBag.Answers = context.Answers.ToList();
UserQuestion question = context.UserQuestions.SingleOrDefault(d => d.QuestionId == id);
return(View(question));
}
public ActionResult AskQuestion(UserQuestion question)
{
question.CategoryId = Convert.ToInt32(Request["Category"]);
CommunityDbContext context = new CommunityDbContext();
question.QuestionDate = DateTime.Now;
// question.Users = Identity.Name;
context.UserQuestions.Add(question);
context.SaveChanges();
return(Redirect("Index"));
}
public ActionResult Satisfy(int?value)
{
CommunityDbContext context = new CommunityDbContext();
var question = (from u in context.UserQuestions where u.QuestionId == value select u).FirstOrDefault();
//Problem
question.IsSatisfied = 1;
context.SaveChanges();
//return RedirectToAction("ViewQuestion", id);
return(RedirectToAction("ViewQuestion", value));
}
public ActionResult Answer(Answer ans, int id)
{
CommunityDbContext context = new CommunityDbContext();
ans.AnswerDate = DateTime.Now;
//Question iD
//User Id
ans.QuestionNo = id;
context.Answers.Add(ans);
context.SaveChanges();
return(RedirectToAction("Index", "Action"));
}
public ActionResult Register(UserModel user)
{
CommunityDbContext context = new CommunityDbContext();
user.RememberMe = false;
user.UserRating = 0;
user.UserType = "user";
context.UserModels.Add(user);
context.SaveChanges();
return(RedirectToAction("Index", "Action"));
}
public ActionResult Like(int id)
{
//Problem
if (ModelState.IsValid)
{
CommunityDbContext context = new CommunityDbContext();
//UserQuestion question = new UserQuestion();
var question = context.UserQuestions.SingleOrDefault(item => item.QuestionId == id);
int value = Convert.ToInt32(question.QuestionRating) + 1;
question.QuestionRating = value;
//context.Entry(question).State = EntityState.Modified;
context.SaveChanges();
//onclick="location.href='@Url.Action("Like","Action", new { id=item.QuestionId})'"> @Html.DisplayFor(model => item.QuestionRating)
return(Redirect(Request.UrlReferrer.AbsolutePath));
}
return(Redirect(Request.UrlReferrer.AbsolutePath));
}
/// <summary>
/// Verifies that the specified user name and password exist in the data source.
/// </summary>
/// <returns>
/// true if the specified username and password are valid; otherwise, false.
/// </returns>
/// <param name="username">The name of the user to validate. </param><param name="password">The password for the specified user. </param>
public override bool ValidateUser(string username, string password)
{
if (string.IsNullOrEmpty(username) || string.IsNullOrEmpty(password))
{
return(false);
}
using (var context = new CommunityDbContext())
{
var user = (from u in context.UserModels
where String.Compare(u.UserName, username, StringComparison.OrdinalIgnoreCase) == 0 &&
String.Compare(u.Password, password, StringComparison.OrdinalIgnoreCase) == 0
select u).FirstOrDefault();
return(user != null);
}
}
protected BaseReadModelRepository(CommunityDbContext dbContext)
{
_dbContext = dbContext;
}
public DefaultLanguagesBuilder(CommunityDbContext context)
{
_context = context;
}
public FoodRepository(CommunityDbContext dbContext)
{
_dbContext = dbContext;
}
public MeasureReadModelRepository(CommunityDbContext dbContext)
: base(dbContext)
{
}
public CommunityBusinessRepository(CommunityDbContext context) : base(context)
{
}
public DefaultTenantRoleAndUserBuilder(CommunityDbContext context)
{
_context = context;
}
public CommunityInfoRepository(CommunityDbContext context) : base(context)
{
}
public CommunityTaskRepository(CommunityDbContext context) : base(context)
{
}
public ActionResult ViewProfile(int id)
{
CommunityDbContext context = new CommunityDbContext();
return(View(context.UserModels.Where(i => i.UserId == id).ToList()));
}
public InitialDataBuilder(CommunityDbContext context)
{
_context = context;
}
public DietRepository(CommunityDbContext dbContext)
: base(dbContext)
{
}
public DefaultTenantRoleAndUserBuilder(CommunityDbContext context)
{
_context = context;
}
public ProfileRepository(CommunityDbContext dbContext)
{
_dbContext = dbContext;
}
public FriendshipRequestReadModelRepository(CommunityDbContext dbContext)
: base(dbContext)
{
}
public FriendshipRequestRepository(CommunityDbContext dbContext)
{
_dbContext = dbContext;
}
