public ActionResult Login(LoginVM model) { if (ModelState.IsValid) { using (ContentSharingEntities1 db = new ContentSharingEntities1()) { bool control = db.UserTable.Any(x => x.EmailAddress == model.EmailAddress && x.Password == model.Password && x.IsEnabled == true); if (control == true) { //oturum aç FormsAuthentication.SetAuthCookie(model.EmailAddress, true); return(Redirect("/Account/Hot")); } } JsonMessageResult j = new JsonMessageResult(); j.IsSuccess = true; j.Message = "Kullanıcı adı veya parola hatalı!"; j.RedirectUrl = "/Home/Main"; return(Json(j)); } return(Json("Böyle bir Kullanıcı veya parola bulunamadı!")); }
public ActionResult Trending() { ContentSharingEntities1 db = new ContentSharingEntities1(); var model2 = db.ImgDB.ToList(); List <ImageDBList> model = new List <ImageDBList>(model2.Count); for (int i = 0; i < model2.Count; i++) { ImageDBList List = new ImageDBList() { ImgID = model2[i].ImgID, UserID = model2[i].UserID, Route = model2[i].Route, Description = model2[i].Description, CommentNumber = model2[i].Comment.Count(), VoteNumber = model2[i].ImgVote.Count }; if (List.VoteNumber > 5) { model.Add(List); } } return(View(model)); }
public JsonResult UpVote(string id) { var newid = Int32.Parse(id); ContentSharingEntities1 DB = new ContentSharingEntities1(); ImgVote Img = new ImgVote(); var userid = (from a in DB.UserTable where a.EmailAddress == HttpContext.User.Identity.Name select a.Id).First(); bool exist = (from b in DB.ImgVote where b.UserID == userid && b.ImgID == newid select b).Any(); if (!exist) { Img.ImgID = newid; Img.UserID = userid; DB.ImgVote.Add(Img); DB.SaveChanges(); return(Json("1", JsonRequestBehavior.AllowGet)); } return(Json("0", JsonRequestBehavior.AllowGet)); }
public JsonResult DownVote(string id) { var newid = Int32.Parse(id); ContentSharingEntities1 DB = new ContentSharingEntities1(); var userid = (from a in DB.UserTable where a.EmailAddress == HttpContext.User.Identity.Name select a.Id).First(); bool exist = (from b in DB.ImgVote where b.UserID == userid && b.ImgID == newid select b).Any(); if (exist) { var imgid = (from c in DB.ImgVote where c.UserID == userid && c.ImgID == newid select c.ImgVoteID).First(); int newID = Convert.ToInt32(imgid); ImgVote Img = DB.ImgVote.Find(newID); DB.ImgVote.Remove(Img); DB.SaveChanges(); return(Json("1", JsonRequestBehavior.AllowGet)); } return(Json("0", JsonRequestBehavior.AllowGet)); }
public ActionResult Register(RegisterVM model) { if (ModelState.IsValid) { UserTable t = new UserTable(); t.EmailAddress = model.EmailAddress; t.UserName = model.UserName; t.Password = model.Password; t.IsEnabled = false; t.ActivationCode = Guid.NewGuid().ToString().Replace("-", "").Substring(0, 10); using (ContentSharingEntities1 db = new ContentSharingEntities1()) { var a = (from k in db.UserTable where t.EmailAddress == k.EmailAddress select k).Any(); if (a == false) { db.UserTable.Add(t); db.SaveChanges(); JsonMessageResult j1 = new JsonMessageResult(); j1.IsSuccess = true; j1.Message = "Kullanıcı Kaydınız Yapıldı.E-Mail Adresinize Doğrulama Linki Gönderildi!"; j1.RedirectUrl = "/account/login"; var url = Path.Combine("http://localhost:62423/Home/activate/", t.ActivationCode); MailService s = new MailService(); s.SendMessage(new MailTemplate { Subject = "Üyelik", To = model.EmailAddress, Message = "<a href=" + url + ">Üyeliği Aktif Et</a>" }); return(Json(j1)); } else { JsonMessageResult j2 = new JsonMessageResult(); j2.IsSuccess = false; j2.Message = "Email Adresi zaten mevcut"; j2.RedirectUrl = null; return(Json(j2)); } } } JsonMessageResult j = new JsonMessageResult(); j.IsSuccess = false; j.Message = "Kullanıcı Kaydınız Yapılamadı.Lütfen tekrar Deneyiniz"; j.RedirectUrl = null; return(Json(j)); }
public ActionResult Settings() { using (ContentSharingEntities1 DB = new ContentSharingEntities1()) { var user = DB.UserTable.FirstOrDefault(x => x.EmailAddress == HttpContext.User.Identity.Name); ViewBag.EmailAdress = user.EmailAddress; ViewBag.UserName = user.UserName; } return(View()); }
public ActionResult ResetPassword(string code) { ContentSharingEntities1 db = new ContentSharingEntities1(); var usr = db.UserTable.FirstOrDefault(x => x.ActivationCode == code); if (usr != null) { ViewBag.Code = usr.ActivationCode; return(View()); } return(Redirect("/account/login")); }
// GET: Account public ActionResult Upload() { if (HttpContext.User.Identity.IsAuthenticated) { //cookie deki bilgiyi name ile çektik ViewBag.Email = HttpContext.User.Identity.Name; } ContentSharingEntities1 ImgDB = new ContentSharingEntities1(); var model = ImgDB.ImgDB.ToList(); return(View(model)); }
public ActionResult Upload(HttpPostedFileBase file, string description) { using (ContentSharingEntities1 DB = new ContentSharingEntities1()) { var ID = (from a in DB.UserTable where a.EmailAddress == HttpContext.User.Identity.Name select a.Id).First(); var allowedExtensions = new[] { ".jpg", ".gif", ".mp4", ".png" }; var checkextension = Path.GetExtension(file.FileName).ToLower(); bool extension = false; foreach (var item in allowedExtensions) { if (item.Contains(checkextension)) { extension = true; } } if (extension) { try { file.SaveAs(Server.MapPath("~/Images/" + file.FileName)); string Route = "/Images/" + file.FileName; ImgDB r = new ImgDB(); r.UserID = ID; r.Description = description; r.Route = Route; ContentSharingEntities1 db = new ContentSharingEntities1(); db.ImgDB.Add(r); db.SaveChanges(); } catch (Exception) { throw; } } } return(Redirect("/Account/Hot")); }
public ActionResult Settings(SettingsRe Setting) { using (ContentSharingEntities1 DB = new ContentSharingEntities1()) { var user = DB.UserTable.FirstOrDefault(x => x.EmailAddress == HttpContext.User.Identity.Name); user.UserName = Setting.UserName; user.EmailAddress = Setting.EmailAddress; DB.SaveChanges(); return(Redirect("/Account/Settings")); } }
public ActionResult Activate(string code) { using (ContentSharingEntities1 db = new ContentSharingEntities1()) { var user = db.UserTable.FirstOrDefault(x => x.ActivationCode == code); if (user != null) { user.IsEnabled = true; db.SaveChanges(); return(Redirect("/Home/Main")); } } return(Redirect("/Home/Register")); }
public ActionResult PostComment(string Comment, int ImageID) { ContentSharingEntities1 DB = new ContentSharingEntities1(); var UserID = (from a in DB.UserTable where a.EmailAddress == HttpContext.User.Identity.Name select a.Id).First(); Comment comment = new Comment(); comment.CommentText = Comment; comment.ImageID = ImageID; comment.UserID = UserID; comment.VoteComment = 0; DB.Comment.Add(comment); DB.SaveChanges(); return(Redirect("/Account/Comment?id=" + ImageID)); }
public ActionResult Password(PasswordRe PW) { using (ContentSharingEntities1 DB = new ContentSharingEntities1()) { bool Pass = DB.UserTable.Any(x => x.Password == PW.OldPassword); var user = DB.UserTable.FirstOrDefault(x => x.EmailAddress == HttpContext.User.Identity.Name); //var Pass = (from a in DB.UserTable where a.EmailAddress == HttpContext.User.Identity.Name select a.Password).Single<string>(); if (Pass) { user.Password = PW.NewPassword; DB.SaveChanges(); } } return(View()); }
public ActionResult PasswordReset(string Email) { ContentSharingEntities1 db = new ContentSharingEntities1(); var usr = db.UserTable.FirstOrDefault(x => x.EmailAddress == Email && x.IsEnabled == true); var url = Path.Combine("http://localhost:62423/Home/resetpassword/", usr.ActivationCode); MailTemplate t = new MailTemplate(); t.To = Email; t.Message = "<a href=" + url + ">Parola Resetle</a>"; t.Subject = "Parola Değişikliği"; MailService service = new MailService(); service.SendMessage(t); ViewBag.Message = "Lütfen eposta hesabınızı kontrol ediniz"; return(View()); }
public ActionResult Comment(string id) { int newid = Convert.ToInt32(id); ContentSharingEntities1 DB = new ContentSharingEntities1(); List <Comments> Comment = new List <Comments>(); var data = (from d in DB.ImgDB where d.ImgID == newid select d).First(); ViewBag.ID = data.ImgID; ViewBag.Route = data.Route; ViewBag.Description = data.Description; ViewBag.Point = data.ImgVote.Count; ViewBag.Comment = data.Comment.Count; var model = (from a in DB.Comment where a.ImageID == newid select a).ToList(); for (int i = 0; i < model.Count; i++) { Comments CList = new Comments() { CommentText = model[i].CommentText, VoteComment = model[i].VoteComment, ImgID = model[i].ImageID, CommentUsrID = model[i].UserID, UserName = model[i].UserTable.UserName }; Comment.Add(CList); } return(View(Comment)); }
public ActionResult ResetPassword(PasswordResetVM model) { var response = Request["g-recaptcha-response"]; const string secret = "6LcjsTQUAAAAALUtX2jw6R8y7oEkK8zHtBolrLli"; //Kendi Secret keyinizle değiştirin. //webclient recaptcha test var client = new WebClient(); var reply = client.DownloadString( string.Format("https://www.google.com/recaptcha/api/siteverify?secret={0}&response={1}", secret, response)); var captchaResponse = JsonConvert.DeserializeObject <CaptchaResponse>(reply); if (ModelState.IsValid) { ContentSharingEntities1 db = new ContentSharingEntities1(); var usr = db.UserTable.FirstOrDefault(x => x.ActivationCode == model.ActivationCode); if (usr != null) { if (!captchaResponse.Success) { ViewBag.Message = "Lütfen güvenliği doğrulayınız."; } else { ViewBag.Message = "Güvenlik başarıyla doğrulanmıştır."; usr.Password = model.Password; db.SaveChanges(); } } } return(View()); }
public ActionResult Hot() { ContentSharingEntities1 db = new ContentSharingEntities1(); var model2 = db.ImgDB.ToList(); List <ImageDBList> model = new List <ImageDBList>(model2.Count); for (int i = 0; i < model2.Count; i++) { ImageDBList List = new ImageDBList() { ImgID = model2[i].ImgID, UserID = model2[i].UserID, Route = model2[i].Route, Description = model2[i].Description, CommentNumber = model2[i].Comment.Count(), VoteNumber = model2[i].ImgVote.Count }; if (List.VoteNumber > 7) { model.Add(List); } } return(View(model)); //var model2 = (from I in db.ImgDB // join C in db.Comment // on I.ImgID equals C.ImageID // into groupofleft // group I by I.ImgID into grup // select new // { // ImgID = grup.Key, // Count = grup.Count() // }).ToList(); //var model3 = (from I in db.ImgDB // join C in db.Comment on I.ImgID equals C.ImageID into j1 // from j2 in j1.DefaultIfEmpty() // group j2 by // new // { // I.ImgID, // I.Route, // I.UserID, // I.Description // } // into grouped // select new // { // ParentId = grouped.Key, // Count = grouped.Count(x => x.ImageID != null) // }).ToList(); //var model4 = (from C in db.Comment // join I in db.ImgDB on C.ImageID equals I.ImgID into j1 // from j2 in j1.DefaultIfEmpty() // group j2 by C.ImageID into grouped // select new // { // ParentId = grouped.Key, // Route = grouped.Select(x=> x.Route), // Count = grouped.Count(x => x.ImgID != null) // }).ToList(); //var model = from I in db.ImgDB group I by I.ImgID; //var model = sql("Select ImgDB.ImgID,ImgDB.ImgVote,ImgDB.Route,ImgDB.UserID,ImgDB.Description,Count(Comment.ImageID) as Sum_Comment from ImgDB left JOIN Comment on(ImgDB.ImgID = Comment.ImageID) group by ImgDB.ImgID,ImgDB.ImgVote,ImgDB.Route,ImgDB.UserID,ImgDB.Description").ToList(); }