public ActionResult Register(RegisterModel model)
{
if (User.Identity.IsAuthenticated)
{
return(RedirectToAction("Index", "Home"));
}
if (ModelState.IsValid)
{
model.password = MD5Helper.MD5Hash(model.password); // hashowanie hasła
pszczupakEntities ent = new pszczupakEntities();
Users u = new Users();
u.login = model.login;
u.password = model.password;
u.email = model.email;
u.role = "user";
u.name = model.login;
ent.Users.Add(u);
ent.SaveChanges();
return(RedirectToAction("Login", "Account"));
}
else
{
return(View(model));
}
}
public ActionResult Create(UsersEventsModel e)
{
if ((UserHelper.GetUserRole(User.Identity.Name) != "admin") && (UserHelper.GetUserRole(User.Identity.Name) != "manager"))
{
return(RedirectToAction("Index", "Home"));
}
pszczupakEntities ent = new pszczupakEntities();
if (ModelState.IsValid)
{
UsersEvents eventt = new UsersEvents();
eventt.id_event = e.id_event;
eventt.id_user = e.id_user;
ent.UsersEvents.Add(eventt);
ent.SaveChanges();
return(RedirectToAction("Index"));
}
else
{
ViewData["U"] = ent.Users.Select(x => new SelectListItem()
{
Value = x.id.ToString(), Text = x.name
}).ToList();
ViewData["E"] = ent.Events.Select(x => new SelectListItem()
{
Value = x.id.ToString(), Text = x.description
}).ToList();
return(View(e));
}
}
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();
Races race = ent.Races.Where(x => x.id == id).First();
List <Dogs> dogs = ent.Dogs.Where(x => x.id_race == id).ToList();
foreach (Dogs d in dogs)
{
d.id_race = null;
ent.Entry(ent.Dogs.Where(x => x.id == d.id).First()).CurrentValues.SetValues(d);
}
ent.Races.Remove(race);
ent.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult ResetPassword(EditEmailModel model) //View BAG
{
if (User.Identity.IsAuthenticated)
{
return(RedirectToAction("Index", "Home"));
}
Guid g = Guid.NewGuid();
pszczupakEntities ent = new pszczupakEntities();
Users u = ent.Users.Where(x => x.email == model.email).FirstOrDefault();
if (u != null)
{
try
{
u.reset_hash = g.ToString();
ent.SaveChanges();
MailHelper.SendMessage(model.email, "Twój kod do resetowania hasła: " + g.ToString(), "Reset hasła na portalu schronisko");
return(View("ResetPasswordAfter"));
}
catch {
return(RedirectToAction("ResetPassword", "Account"));
}
}
else
{
ViewBag.reset = "Nie ma takiego Email w bazie spróbuj ponownie";
return(View(model));
}
}
public ActionResult Approve(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();
if (events.approved == 1)
{
events.approved = 0;
}
else
{
events.approved = 1;
}
ent.Entry(ent.Events.Where(x => x.id == events.id).First()).CurrentValues.SetValues(events);
ent.SaveChanges();
return(RedirectToAction("Schedule"));
}
public ActionResult ResetPasswordCheckGuid(RessetModel res)
{
if (User.Identity.IsAuthenticated)
{
return(RedirectToAction("Index", "Home"));
}
if (ModelState.IsValid)
{
pszczupakEntities ent = new pszczupakEntities();
Users u = new Users();
u = ent.Users.Where(x => x.email == res.email && x.reset_hash == res.guid).FirstOrDefault();
if (u != null)
{
u.password = MD5Helper.MD5Hash(res.password);
u.reset_hash = null;
ent.SaveChanges();
return(RedirectToAction("Login"));
}
else
{
ViewBag.reset = "Email lub kod jest niepoprawny.";
return(View(res));
}
}
else
{
return(View(res));
}
}
public ActionResult EditRole(EditRoleModel user)
{
if (!User.Identity.IsAuthenticated)
{
return(RedirectToAction("Login", "Account"));
}
if ((UserHelper.GetUserRole(User.Identity.Name) != "admin"))
{
return(RedirectToAction("Index", "Home"));
}
if (ModelState.IsValid)
{
pszczupakEntities ent = new pszczupakEntities();
Users u = new Users();
u = ent.Users.Where(x => x.id == user.id).FirstOrDefault();
u.role = user.role;
ent.Entry(ent.Users.Where(x => x.id == u.id).First()).CurrentValues.SetValues(u);
ent.SaveChanges();
return(RedirectToAction("UsersRole"));
}
else
{
pszczupakEntities ent = new pszczupakEntities();
Users u = ent.Users.Where(x => x.id == user.id).FirstOrDefault();
var b = new List <SelectListItem>
{
new SelectListItem {
Text = "admin", Value = "admin"
},
new SelectListItem {
Text = "manager", Value = "manager"
},
new SelectListItem {
Text = "worker", Value = "worker"
},
new SelectListItem {
Text = "user", Value = "user"
}
};
ViewData["Roles"] = b;
ViewBag.login = u.login;
return(View(user));
}
}
public ActionResult Create(DogsModel d, 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)
{
pszczupakEntities ent = new pszczupakEntities();
Dogs dog = d.ToDogsWithoutID();
ent.Dogs.Add(dog);
ent.SaveChanges();
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);
dog.photo_path = $"/Images/Dogs/Index/{dog.id}/{file.FileName}";
}
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(d));
}
}
}
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 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 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 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 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 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 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!!!
}