public int GetLoginPageTag(ActionExecutingContext context) { int result = 0; string IP = context.HttpContext.Request.UserHostAddress; LoginPageTrail tmpLPT = db.LoginPageTrails.FirstOrDefault(r => r.ClientIP.CompareTo(IP) == 0); if (tmpLPT != null) { if (tmpLPT.ErrorCount > LOGINLOCK) { result = -2; DateTime tmpDT = DateTime.Parse(tmpLPT.LogDate); tmpDT = tmpDT.AddSeconds(LOCKTIME); TimeSpan tmpTS = tmpDT - DateTime.Now; if (tmpTS.TotalSeconds < 0) { tmpLPT.ErrorCount = 0; db.SaveChanges(); result = 0; waitSeconds = 0; } else { waitSeconds = (int)tmpTS.TotalSeconds; } } else if (tmpLPT.ErrorCount > CHECKCODESHOW) { result = -1; } } return(result); }
public void WriteTrail(HttpRequest request) { ClientTrail tmpCT = new ClientTrail(); tmpCT.URL = request.Url.ToString(); if (request.RequestContext.RouteData.Route != null) { object tmpObj = request.RequestContext.RouteData.Route.GetRouteData(request.RequestContext.HttpContext).Values["controller"]; tmpCT.ControllerName = tmpObj != null?tmpObj.ToString() : ""; tmpObj = request.RequestContext.RouteData.Route.GetRouteData(request.RequestContext.HttpContext).Values["action"]; tmpCT.ActionName = tmpObj != null?tmpObj.ToString() : ""; } else { tmpCT.ControllerName = ""; tmpCT.ActionName = ""; } tmpCT.ClientIP = request.UserHostAddress; tmpCT.LogDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); if (request.RequestContext.HttpContext.User.Identity.IsAuthenticated) { MyUser tmpUser = request.RequestContext.HttpContext.User as MyUser; if (tmpUser != null) { tmpCT.UID = tmpUser.UID; } } db.ClientTrails.Add(tmpCT); db.SaveChanges(); }
private async void izbrisiFilm(object parametar) { int kolekcijaID = OdabraniFilm.KolekcijaId; if (OdabraniFilm != null) { using (var db = new FilmDbContext()) { db.Filmovi.Remove(db.Filmovi.Where(x => x.FilmId == OdabraniFilm.FilmId).FirstOrDefault()); db.SaveChanges(); } using (var db = new FilmDbContext()) { MojiFilmoviIzKolekcije.Clear(); foreach (Film k in db.Filmovi) { if (k.KolekcijaId == kolekcijaID) { MojiFilmoviIzKolekcije.Add(k); } } } } else { var dialog = new MessageDialog("Niste odabrali film."); await dialog.ShowAsync(); } }
private async void dodajFilm(object parametar) { if (OdabraniFilm != null && OdabranaKolekcija != null) { using (var db = new FilmDbContext()) { int max = -1; foreach (Film k in db.Filmovi) { if (k.FilmId > max) { max = k.FilmId; } } max++; Film novi = new Film(max); novi = OdabraniFilm; novi.FilmId = max; novi.KolekcijaId = OdabranaKolekcija.KolekcijaId; novi.KorisnikId = Korisnik.KorisnikId; db.Filmovi.Add(novi); db.SaveChanges(); } var dialog = new MessageDialog("Film uspjesno sacuvan"); await dialog.ShowAsync(); } else { var dialog = new MessageDialog("Oznacite film ili kolekciju."); await dialog.ShowAsync(); } }
private void NewActor() { using (var db = new FilmDbContext(_connectionName)) { var actor = _view.GetNewActor(); db.Actors.Add(actor); db.SaveChanges(); } }
private void NewFilm() { var newFilm = _view.GetNewFilmInfo(); using (var db = new FilmDbContext(_connectionName)) { db.Films.Add(newFilm); db.SaveChanges(); _view.WriteFilmList(db.Films.ToList()); } }
public ActionResult SearchResource(string searchText, int pageIndex) { if (pageIndex <= 1) { try { SearchLog tmpLog = new SearchLog(); tmpLog.IPAddress = Request.UserHostAddress; tmpLog.LogDateTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); tmpLog.SearchStr = searchText; db.SearchLogs.Add(tmpLog); db.SaveChanges(); } catch { } } SearchResult result = new SearchResult(); result.PageIndex = pageIndex; string htmlStr = HtmlReader.OpenSync(string.Format(SEARCHHTMLFORMAT, searchText, pageIndex)); if (!string.IsNullOrEmpty(htmlStr)) { HtmlAnalyser analyser = new HtmlAnalyser(htmlStr); HtmlAnalyser.MagnetResult[] tmpMC = analyser.GetResult(); result.Items = new List <ResourceItem>(); foreach (HtmlAnalyser.MagnetResult item in tmpMC) { ResourceItem resourceItem = new ResourceItem(); resourceItem.ResourceName = item.Description; resourceItem.MagnetLink = item.MargnetLink; resourceItem.Date = item.Date; resourceItem.Size = item.Size; resourceItem.SeedLink = item.SeedLink; resourceItem.DetailUrl = HOMEPAGEURL + item.DetailLink; result.Items.Add(resourceItem); } result.PageCount = analyser.GetPageCount(); } if (Request.IsAjaxRequest()) { string jsonStr = PubFunction.BuildResult(result); return(Content(jsonStr)); } else { return(View(result)); } }
private void NewFilmRating() { using (var db = new FilmDbContext(_connectionName)) { var films = db.Films.ToList(); var filmChoice = _view.GetFilmChoice(films); var filmRating = _view.GetNewFilmRating(); filmRating.Film = filmChoice; db.FilmRatings.Add(filmRating); db.SaveChanges(); } }
private void AddActorToFilm() { using (var db = new FilmDbContext(_connectionName)) { var actor = _view.GetActorChoice(db.Actors.ToList()); var film = _view.GetFilmChoice(db.Films.ToList()); film.Actors.Add(actor); db.SaveChanges(); } }
private void UpdateFilm() { using (var db = new FilmDbContext(_connectionName)) { var films = db.Films.ToList(); var filmChoice = _view.GetFilmChoice(films); var newFilmInfo = _view.GetNewFilmInfo(); filmChoice.Name = newFilmInfo.Name; filmChoice.Description = newFilmInfo.Description; filmChoice.Genre = newFilmInfo.Genre; db.SaveChanges(); } }
public bool AddRev(AddReview request) { if (request.SeeReview != null && request.MovieId > 0) { //var movie = db.Movies.Where(a => a.MovieId == request.MovieId).FirstOrDefault(); Reviews review = new Reviews(); review.Review = request.SeeReview; review.MovieId = request.MovieId; db.Review.Add(review); db.SaveChanges(); return(true); } return(false); }
private async void izbrisiKolekciju(object parametar) { if (OdabranaKolekcija != null)// && OdabranaKolekcija.Naziv!="") { using (var db = new FilmDbContext()) { for (int i = 0; i < MojiFilmoviIzKolekcije.Count; i++) { db.Filmovi.Remove(db.Filmovi.Where(x => x.KolekcijaId == OdabranaKolekcija.KolekcijaId).FirstOrDefault()); } db.SaveChanges(); } MojiFilmoviIzKolekcije.Clear(); using (var db = new KolekcijaDbContext()) { db.Kolekcije.Remove(db.Kolekcije.Where(x => x.KorisnikId == korisnik.KorisnikId && x.KolekcijaId == OdabranaKolekcija.KolekcijaId).FirstOrDefault()); db.SaveChanges(); MojeKolekcije.Clear(); foreach (Kolekcija k in db.Kolekcije) { if (k.KorisnikId == korisnik.KorisnikId) { MojeKolekcije.Add(k); } } } var dialog1 = new MessageDialog("Kolekcija uspješno obrisana."); await dialog1.ShowAsync(); } else { var dialog1 = new MessageDialog("Niste oznacili kolekciju."); await dialog1.ShowAsync(); } }
public ActionResult Register(string userName, string email, string psw, string checkCode) { if (string.IsNullOrEmpty(userName) || string.IsNullOrEmpty(email) || string.IsNullOrEmpty(psw) || string.IsNullOrEmpty(checkCode) || string.IsNullOrEmpty(Session["Validate_code"].ToString())) { if (Request.IsAjaxRequest()) { string jsonStr = PubFunction.BuildResult("err", null, false, -4); return(Content(jsonStr)); } else { return(RedirectToAction("Register", "Home")); } } User user = null; if (checkCode != (Session["Validate_code"].ToString())) { ViewBag.LoginFail = -1; return(Content(PubFunction.BuildResult(null, null, false, -1, "验证码错误"))); } else { user = db.Users.FirstOrDefault(r => (r.UserName == userName || r.Email == email)); if (user != null) { //用户已存在 bool UNExists = user.UserName == userName; return(Content(PubFunction.BuildResult(null, null, false, UNExists ? -2 : -3, UNExists ? "用户名已被注册" : "邮箱已被注册"))); } else { //创建用户 user = new User() { UserName = userName, LoginID = userName, LoginPSW = psw, Email = email, Sex = false, Permission = "", Gift = 100 //100积分 }; user = db.Users.Add(user); //关联角色 Role role = db.Roles.First(r => r.RID == (int)Role.RoleTypeID.RT_CLIENT); if (role.Users == null) { role.Users = new List <User>(); } role.Users.Add(user); db.SaveChanges(); //设置cookie StringBuilder tmpRPStr = new StringBuilder("," + user.Permission + ","); StringBuilder tmpRIDStr = new StringBuilder(","); StringBuilder tmpRNStr = new StringBuilder(","); foreach (Role tmpRole in user.Roles) { tmpRIDStr.Append(tmpRole.RID + ","); tmpRNStr.Append(tmpRole.RoleName + ","); tmpRPStr.Append(tmpRole.Permission + ","); } string tmpStr = string.Format("<USERID>{0}</USERID><USERNAME>{1}</USERNAME><RIDARR>{2}</RIDARR><RNARR>{3}</RNARR><PERMISSION>{4}</PERMISSION>", user.UID, user.UserName, tmpRIDStr.ToString(), tmpRNStr.ToString(), tmpRPStr.ToString()); FormsAuthenticationTicket authTicket = new FormsAuthenticationTicket( 1, user.UserName, DateTime.Now, DateTime.Now.AddMinutes(30), true, tmpStr); string encryptedTicket = FormsAuthentication.Encrypt(authTicket); HttpCookie authCookie = new HttpCookie(FormsAuthentication.FormsCookieName, encryptedTicket); Response.Cookies.Add(authCookie); authCookie = new HttpCookie("UserInfo"); authCookie.Values.Add("UID", user.UID.ToString()); authCookie.Values.Add("UserName", user.UserName); authCookie.Values.Add("RID", tmpRIDStr.ToString()); authCookie.Values.Add("Permission", tmpRPStr.ToString()); Response.Cookies.Add(authCookie); } } if (Request.IsAjaxRequest()) { string jsonStr = PubFunction.BuildResult(user); return(Content(jsonStr)); } else { return(View(user)); } }
public void Commit() { _databaseContext.SaveChanges(); }