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!!!
}
