protected override ValidationResult IsValid(object value, ValidationContext validationContext) { try { var emaill = value.ToString(); pszczupakEntities ent = new pszczupakEntities(); if (ent.Users.Where(x => x.email == emaill).Count() > 0) { return(new ValidationResult("Taki adres email już istnieje")); } return(ValidationResult.Success); } catch { return(new ValidationResult("Email wymagany.")); } }
public ActionResult EditEmail(EditEmailModel model) { if (ModelState.IsValid) { pszczupakEntities ent = new pszczupakEntities(); Users u = ent.Users.Where(x => x.id == model.id).FirstOrDefault(); u.email = model.email; ent.SaveChanges(); return(RedirectToAction("UserDetails", "Account")); } else { return(View(model)); } }
public PartialViewResult ShowNewses() { pszczupakEntities ent = new pszczupakEntities(); List <NewsViewModel> lista = new List <NewsViewModel>(); foreach (News item in ent.News.OrderByDescending(x => x.add_date).Take(10)) { NewsViewModel model = new NewsViewModel(); model.add_date = item.add_date; model.news1 = item.news1; model.user_id = item.user_id; model.id = item.id; lista.Add(model); } return(PartialView(lista)); }
public ActionResult Edit(int?Id) { if ((UserHelper.GetUserRole(User.Identity.Name) != "admin") && (UserHelper.GetUserRole(User.Identity.Name) != "worker") && (UserHelper.GetUserRole(User.Identity.Name) != "manager")) { return(RedirectToAction("Index", "Home")); } if (Id == null) { return(HttpNotFound()); } pszczupakEntities ent = new pszczupakEntities(); RacesModel race = ent.Races.Where(x => x.id == Id).FirstOrDefault().ToRacesModelWithID(); return(View(race)); }
public ActionResult Delete(int?id) { if (!id.HasValue) { return(HttpNotFound()); } if ((UserHelper.GetUserRole(User.Identity.Name) != "admin") && (UserHelper.GetUserRole(User.Identity.Name) != "worker") && (UserHelper.GetUserRole(User.Identity.Name) != "manager")) { return(RedirectToAction("Index", "Home")); } pszczupakEntities ent = new pszczupakEntities(); EventsModel model = ent.Events.Where(x => x.id == id).FirstOrDefault().ToEventsModelWithID(); return(View(model)); }
public ActionResult EditUser() { pszczupakEntities ent = new pszczupakEntities(); EditUserModel model = new EditUserModel(); Users u = ent.Users.Where(x => x.login == User.Identity.Name).FirstOrDefault(); model.id = u.id; model.name = u.name; model.surname = u.surname; model.pesel = u.pesel; model.city = u.city; model.street = u.street; model.house = u.house; model.phone = u.phone; return(View(model)); }
public ActionResult Create() { if ((UserHelper.GetUserRole(User.Identity.Name) != "admin") && (UserHelper.GetUserRole(User.Identity.Name) != "worker") && (UserHelper.GetUserRole(User.Identity.Name) != "manager")) { return(RedirectToAction("Index", "Home")); } { DogsModel d = new DogsModel(); pszczupakEntities ent = new pszczupakEntities(); ViewData["Race"] = ent.Races.Select(x => new SelectListItem() { Value = x.id.ToString(), Text = x.name }).ToList(); return(View(d)); } }
public ActionResult Index() { if ((UserHelper.GetUserRole(User.Identity.Name) != "admin") && (UserHelper.GetUserRole(User.Identity.Name) != "manager")) { return(RedirectToAction("Index", "Home")); } pszczupakEntities ent = new pszczupakEntities(); List <UsersEventsModel> ue = new List <UsersEventsModel>(); foreach (UsersEvents m in ent.UsersEvents.ToList()) { ue.Add(new UsersEventsModel(m)); } return(View(ue)); }
public ActionResult Edit(DogsModel dog, HttpPostedFileBase file) { if ((UserHelper.GetUserRole(User.Identity.Name) != "admin") && (UserHelper.GetUserRole(User.Identity.Name) != "worker") && (UserHelper.GetUserRole(User.Identity.Name) != "manager")) { return(RedirectToAction("Index", "Home")); } if (ModelState.IsValid) { if (file != null) { var path = Path.Combine(Server.MapPath($"~/Images/Dogs/Index/{dog.id}"), file.FileName); System.IO.Directory.CreateDirectory(Server.MapPath($"~/Images/Dogs/Index/{dog.id}")); file.SaveAs(path); } pszczupakEntities ent = new pszczupakEntities(); Dogs d = new Dogs(); d = ConverterHelper.ToDogsWithID(dog); if (file != null) { d.photo_path = $"/Images/Dogs/Index/{dog.id}/{file.FileName}"; } ent.Entry(ent.Dogs.Where(x => x.id == d.id).First()).CurrentValues.SetValues(d); ent.SaveChanges(); return(RedirectToAction("Index")); } else { pszczupakEntities ent = new pszczupakEntities(); ViewData["Race"] = ent.Races.Select(x => new SelectListItem() { Value = x.id.ToString(), Text = x.name }).ToList(); return(View(dog)); } }
public bool logowanie(string username, string password) { pszczupakEntities ent = new pszczupakEntities(); var Usr = ent.Users.Where(x => x.password == password && (x.login == username || x.email == username)).FirstOrDefault(); if (Usr != null) { //autentykacja metoda forms if (Usr.role == null) { Usr.role = ""; } FormsAuthenticationTicket ticket = new FormsAuthenticationTicket(1, Usr.login, DateTime.Now, DateTime.Now.AddDays(1), true, Usr.role, FormsAuthentication.FormsCookiePath); // Kodowanie biletu string encTicket = FormsAuthentication.Encrypt(ticket); // Tworze ciasteczko Response.Cookies.Add(new HttpCookie(FormsAuthentication.FormsCookieName, encTicket)); return(true); } return(false); }
public ActionResult DeleteConf(int?id) { if (!id.HasValue) { return(HttpNotFound()); } if ((UserHelper.GetUserRole(User.Identity.Name) != "admin") && (UserHelper.GetUserRole(User.Identity.Name) != "worker") && (UserHelper.GetUserRole(User.Identity.Name) != "manager")) { return(RedirectToAction("Index", "Home")); } pszczupakEntities ent = new pszczupakEntities(); Events events = ent.Events.Where(x => x.id == id).First(); ent.Events.Remove(events); ent.SaveChanges(); return(RedirectToAction("Schedule")); }
public ActionResult DeleteConf(int?id) { if ((UserHelper.GetUserRole(User.Identity.Name) != "admin") && (UserHelper.GetUserRole(User.Identity.Name) != "worker") && (UserHelper.GetUserRole(User.Identity.Name) != "manager")) { return(RedirectToAction("Index", "Home")); } if (id == null) { return(HttpNotFound()); } pszczupakEntities ent = new pszczupakEntities(); Dogs dog = ent.Dogs.Where(x => x.id == id).First(); ent.Dogs.Remove(dog); ent.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Create() { EventsModel e = new EventsModel(); e.id_user = UserHelper.GetUserId(User.Identity.Name); pszczupakEntities ent = new pszczupakEntities(); ViewData["U"] = ent.Users.Select(x => new SelectListItem() { Value = x.id.ToString(), Text = x.name }).ToList(); ViewData["D"] = ent.Dogs.Select(x => new SelectListItem() { Value = x.id.ToString(), Text = x.name }).ToList(); e.id_user = UserHelper.GetUserId(User.Identity.Name); return(View(e)); }
public ActionResult DeleteUser(int?id) { if (!User.Identity.IsAuthenticated) { return(RedirectToAction("Login", "Account")); } if ((UserHelper.GetUserRole(User.Identity.Name) != "admin")) { return(RedirectToAction("Index", "Home")); } if (id == null) { return(HttpNotFound()); } pszczupakEntities ent = new pszczupakEntities(); UserViewModel model = new UserViewModel(ent.Users.Where(x => x.id == id).FirstOrDefault()); return(View(model)); }
public ActionResult Edit(int?Id) { if ((UserHelper.GetUserRole(User.Identity.Name) != "admin") && (UserHelper.GetUserRole(User.Identity.Name) != "worker") && (UserHelper.GetUserRole(User.Identity.Name) != "manager")) { return(RedirectToAction("Index", "Home")); } if (Id == null) { return(HttpNotFound()); } pszczupakEntities ent = new pszczupakEntities(); DogsModel dog = ent.Dogs.Where(x => x.id == Id).FirstOrDefault().ToDogsModelWithID(); ViewData["Race"] = ent.Races.Select(x => new SelectListItem() { Value = x.id.ToString(), Text = x.name }).ToList(); return(View(dog)); }
protected override ValidationResult IsValid(object value, ValidationContext validationContext) { var login = value.ToString(); pszczupakEntities ent = new pszczupakEntities(); List <String> logins = new List <String>(); logins = ent.Users.Select(x => x.login).ToList(); foreach (String s in logins) { if (s == login) { return(new ValidationResult("Taki Login juz istnieje")); } } return(ValidationResult.Success); }
public ActionResult Edit(EventsModel e) { e.id_user = UserHelper.GetUserId(User.Identity.Name); // DLACZEGO GUBI SIE ID_USER???????????? //USER moze edytowac tylko swoje eventy if ((UserHelper.GetUserRole(User.Identity.Name) == "user" && (UserHelper.GetUserId(User.Identity.Name) != e.id_user)) || UserHelper.GetUserRole(User.Identity.Name) == "") // return Json("lololo"+ UserHelper.GetUserId(User.Identity.Name)+" "+ e.id_user+" id idusera"); { return(RedirectToAction("Index", "Home")); } if (ModelState.IsValid) { if (UserHelper.GetUserRole(User.Identity.Name) == "user") { e.approved = 0; } pszczupakEntities ent = new pszczupakEntities(); Events events = ConverterHelper.ToEventsWithID(e); ent.Entry(ent.Events.Where(x => x.id == events.id).First()).CurrentValues.SetValues(events); ent.SaveChanges(); return(RedirectToAction("Schedule")); } else { pszczupakEntities ent = new pszczupakEntities(); ViewData["U"] = ent.Users.Select(x => new SelectListItem() { Value = x.id.ToString(), Text = x.name }).ToList(); ViewData["D"] = ent.Dogs.Select(x => new SelectListItem() { Value = x.id.ToString(), Text = x.name }).ToList(); return(View(e)); } }
public ActionResult Create(EventsModel e) { if (ModelState.IsValid) { pszczupakEntities ent = new pszczupakEntities(); if (UserHelper.GetUserRole(User.Identity.Name) == "user" || UserHelper.GetUserRole(User.Identity.Name) == "worker") { e.approved = 0; } else { e.approved = 1; } e.id_user = UserHelper.GetUserId(User.Identity.Name); ent.Events.Add(e.ToEventsWithoutID()); ent.SaveChanges(); return(RedirectToAction("Schedule")); } else { pszczupakEntities ent = new pszczupakEntities(); ViewData["U"] = ent.Users.Select(x => new SelectListItem() { Value = x.id.ToString(), Text = x.name }).ToList(); ViewData["D"] = ent.Dogs.Select(x => new SelectListItem() { Value = x.id.ToString(), Text = x.name }).ToList(); e.id_user = UserHelper.GetUserId(User.Identity.Name); return(View(e)); } }
public ActionResult Edit(RacesModel race) { if ((UserHelper.GetUserRole(User.Identity.Name) != "admin") && (UserHelper.GetUserRole(User.Identity.Name) != "worker") && (UserHelper.GetUserRole(User.Identity.Name) != "manager")) { return(RedirectToAction("Index", "Home")); } if (ModelState.IsValid) { pszczupakEntities ent = new pszczupakEntities(); Races r = ent.Races.Where(x => x.id == race.id).FirstOrDefault(); r = ConverterHelper.RacesSameValuesWithoutID(r, race); ent.Entry(ent.Races.Where(x => x.id == r.id).First()).CurrentValues.SetValues(r); ent.SaveChanges(); return(RedirectToAction("Index")); } else { return(View(race)); } }
public ActionResult Create(RacesModel r) { if ((UserHelper.GetUserRole(User.Identity.Name) != "admin") && (UserHelper.GetUserRole(User.Identity.Name) != "worker") && (UserHelper.GetUserRole(User.Identity.Name) != "manager")) { return(RedirectToAction("Index", "Home")); } if (ModelState.IsValid) { pszczupakEntities ent = new pszczupakEntities(); ent.Races.Add(r.ToRacesWithoutID()); ent.SaveChanges(); return(RedirectToAction("Index")); } else { return(View(r)); } }
public ActionResult Add(NewsViewModel model) { if ((UserHelper.GetUserRole(User.Identity.Name) != "admin") && (UserHelper.GetUserRole(User.Identity.Name) != "manager") && (UserHelper.GetUserRole(User.Identity.Name) != "worker") && (UserHelper.GetUserRole(User.Identity.Name) != "user")) { return(RedirectToAction("Login", "Account")); } if (UserHelper.GetUserRole(User.Identity.Name) == "user") { return(RedirectToAction("Index", "Home")); } model.user_id = UserHelper.GetUserId(User.Identity.Name); model.add_date = DateTime.Now; pszczupakEntities ent = new pszczupakEntities(); News n = model.ToNews(); ent.News.Add(n); ent.SaveChanges(); return(RedirectToAction("Index", "Home")); }
public ActionResult DeleteNewsConf(int?id) { if ((UserHelper.GetUserRole(User.Identity.Name) != "admin") && (UserHelper.GetUserRole(User.Identity.Name) != "manager") && (UserHelper.GetUserRole(User.Identity.Name) != "worker") && (UserHelper.GetUserRole(User.Identity.Name) != "user")) { return(RedirectToAction("Login", "Account")); } if (UserHelper.GetUserRole(User.Identity.Name) == "user") { return(RedirectToAction("Index", "Home")); } if (id == null) { return(HttpNotFound()); } pszczupakEntities ent = new pszczupakEntities(); News n = null; List <News> newsy = ent.News.ToList(); foreach (News item in newsy) { if (item.id == id) { n = item; } } try { ent.News.Remove(n); } catch { } ent.SaveChanges(); return(RedirectToAction("Index", "Home")); }
public ActionResult EditUser(EditUserModel user) { if (ModelState.IsValid) { pszczupakEntities ent = new pszczupakEntities(); Users u = ent.Users.Where(x => x.login == User.Identity.Name).FirstOrDefault(); u.name = user.name; u.surname = user.surname; u.pesel = user.pesel; u.city = user.city; u.street = user.street; u.house = user.house; u.phone = user.phone; ent.Entry(ent.Users.Where(x => x.id == u.id).First()).CurrentValues.SetValues(u); ent.SaveChanges(); return(RedirectToAction("Index", "Home")); } else { return(View(user)); } }
public ActionResult DeleteNews(int?id) { if ((UserHelper.GetUserRole(User.Identity.Name) != "admin") && (UserHelper.GetUserRole(User.Identity.Name) != "manager") && (UserHelper.GetUserRole(User.Identity.Name) != "worker") && (UserHelper.GetUserRole(User.Identity.Name) != "user")) { return(RedirectToAction("Login", "Account")); } if (UserHelper.GetUserRole(User.Identity.Name) == "user") { return(RedirectToAction("Index", "Home")); } if (id == null) { return(HttpNotFound()); } pszczupakEntities ent = new pszczupakEntities(); News n = null; List <News> newsy = ent.News.ToList(); foreach (News item in newsy) { if (item.id == id) { n = item; } } NewsViewModel nvm = new NewsViewModel(); nvm.id = n.id; nvm.user_id = n.user_id; nvm.add_date = n.add_date; nvm.news1 = n.news1; return(View(nvm)); }
public ActionResult DeleteConf(int?id) { if (!User.Identity.IsAuthenticated) { return(RedirectToAction("Login", "Account")); } if ((UserHelper.GetUserRole(User.Identity.Name) != "admin")) { return(RedirectToAction("Index", "Home")); } if (id == null) { return(HttpNotFound()); } pszczupakEntities ent = new pszczupakEntities(); Users user = ent.Users.Where(x => x.id == id).First(); ent.Users.Remove(user); ent.SaveChanges(); return(RedirectToAction("UsersRole")); }
public ActionResult Schedule() { pszczupakEntities ent = new pszczupakEntities(); List <EventsModel> events = new List <EventsModel>(); IEnumerable <Events> query = ent.Events.ToList().OrderBy(e => e.time); query = ent.Events.ToList().OrderBy(e => e.date); foreach (Events e in query) { //if there is no time_end == time_end is at 23:59 TimeSpan t = new TimeSpan(23, 59, 59); if (e.time_end.HasValue) { t = (TimeSpan)e.time_end; } //here is checked if time_end crossed current moment if ((e.date.Add(t).CompareTo(DateTime.Now)) < 0) { ent.Events.Remove(e); } //jesli data z dzisiaj //if (e.date.CompareTo(DateTime.Now) == 0){ // //jesli nie ma wartosci to automatycznie do konca dnia // if (!e.time_end.HasValue) // e.time_end = new TimeSpan(23, 59, 59); // if (e.time_end.Value.CompareTo(DateTime.Now.TimeOfDay) <= 0) { // ent.Events.Remove(e); // } /* * DateTime? now = DateTime.Now; * e.time.CompareTo(e.time_end); * TimeSpan t = new TimeSpan(); * t.Hours = DateTime.Now.TimeOfDay. * if (e.time_end.HasValue && ((DateTime)e.time_end.CompareTo(DateTime.Now) < 0)) * { * //jesli zakonczenie starsze niz dzisiaj to usun * ent.Events.Remove(e); * continue; * } * //zakonczenie null ale juz kolejny dzien * if ((!e.time_end.HasValue) && (e.date.Day!= DateTime.Now.Day)) * { * ent.Events.Remove(e); * continue; * } * //jeszcze nie skonczone */ //} if (UserHelper.GetUserRole(User.Identity.Name) == "admin" || UserHelper.GetUserRole(User.Identity.Name) == "manager") { events.Add(e.ToEventsModelWithID()); continue; } string eUserLogin = ent.Users.Find(e.id_user).login; if (UserHelper.GetUserRole(User.Identity.Name) == "worker" && UserHelper.GetUserRole(eUserLogin) == "user") { events.Add(e.ToEventsModelWithID()); continue; } if (e.id_user == UserHelper.GetUserId(User.Identity.Name)) { events.Add(e.ToEventsModelWithID()); continue; } //pracownik widzi eventy userow: } int id = UserHelper.GetUserId(User.Identity.Name); IEnumerable <UsersEvents> ue = ent.UsersEvents.Where(x => x.id_user == id).ToList(); //var eventsQuery = // from e in query // join ue in e on e.Doge.DogId equals d.DogId into eq // select new { Key = e.Doge.DogId, Items = eq }; foreach (var ueue in ue) { EventsModel test = ent.Events.Where(x => x.id == ueue.id_event).FirstOrDefault().ToEventsModelWithID(); bool f = true; foreach (EventsModel em in events) { if (em.id == test.id) { f = false; } } if (f) { events.Add(test); } } //events.GroupBy(o => o.id).Distinct().ToList(); //List<EventsModel> trololl = events.ToList().OrderBy(e => e.id); ViewData["EU"] = ent.UsersEvents.ToList(); ViewData["U"] = ent.Users.ToList();//Select(x => new SelectListItem() { Value = x.id.ToString(), Text = x.name }).ToList(); ent.SaveChanges(); return(View(events.OrderBy(e => e.time).OrderBy(e => e.date))); //posortowac!!! }