public ViewTripUser Login(ViewTripUser vuser)
{
ViewTripUser user = new ViewTripUser();
string token = "";
using (OnATripEntities tr = new OnATripEntities())
{
token = (from l in tr.Logins from u in tr.Users where u.UserId == l.UserId && u.UserName == vuser.UserName && u.Password == vuser.Password select l.Token).FirstOrDefault();
var dbUser = (from u in tr.Users where u.UserName == vuser.UserName && u.Password == vuser.Password select u).FirstOrDefault();
// spatne prihlaseni - vyvola vyjimku securityException
if (dbUser == null)
{
throw new System.Security.SecurityException("Login or password is incorrect.");
}
if (string.IsNullOrEmpty(token))
{
token = Guid.NewGuid().ToString();
tr.Logins.Add(new Repositories.Login() { Token = token, UserId = dbUser.UserId, LastHit = DateTime.UtcNow });
tr.SaveChanges();
}
Mapper.Map(dbUser, user);
user.Token = token;
}
return user;
}
public void CloneTrip(int TripId, int UserId, DateTime startDate)
{
using (OnATripEntities tr = new OnATripEntities())
{
tr.spCloneTrip(UserId, TripId, startDate);
}
}
public void DeleteActivity(int id)
{
using (OnATripEntities tr = new OnATripEntities())
{
tr.Activities.RemoveRange(tr.Activities.Where(act => act.ActivityID == id));
tr.SaveChanges();
}
}
public ICollection<ViewCountry> ImportCountries(ICollection<ViewCountry> countries)
{
using (OnATripEntities tr = new OnATripEntities())
{
tr.countries.AddRange(Mapper.Map<ICollection<country>>(countries));
tr.SaveChanges();
}
return countries;
}
public ViewActivity GetActivity(int activityId)
{
ViewActivity viewActivity = new ViewActivity();
using (OnATripEntities tr = new OnATripEntities())
{
var dbActivity = (from a in tr.Activities where a.ActivityID == activityId select a).FirstOrDefault();
Mapper.Map(dbActivity, viewActivity);
}
return viewActivity;
}
public ICollection<ViewCountry> GetCountries()
{
ICollection<ViewCountry> states = new HashSet<ViewCountry>();
using (OnATripEntities tr = new OnATripEntities())
{
var dbStates = from s in tr.countries orderby s.name select s;
Mapper.Map(dbStates, states);
}
return states;
}
public ViewTrip CreateTrip(ViewTrip viewTrip)
{
using (OnATripEntities tr = new OnATripEntities())
{
Trip dbTrip = tr.Trips.Add(Mapper.Map<Trip>(viewTrip));
tr.SaveChanges();
viewTrip.TripId = dbTrip.TripId;
}
return viewTrip;
}
public ICollection<ViewActivity> GetActivities(int id)
{
ICollection<ViewActivity> activities = new HashSet<ViewActivity>();
using (OnATripEntities tr = new OnATripEntities())
{
var dbActivity = (from a in tr.Activities where a.TripID == id select a).ToList();
Mapper.Map(dbActivity, activities);
}
return activities;
}
public ICollection<ViewTrip> GetTrips(int stateId)
{
ICollection<ViewTrip> trips = new HashSet<ViewTrip>();
using (OnATripEntities tr = new OnATripEntities())
{
ICollection<Trip> dbTrips = tr.Trips.Where(trp => trp.IsPublic).Select(trp => trp).ToList<Trip>();
trips = Mapper.Map<ICollection<ViewTrip>>(dbTrips);
}
return trips;
}
public bool CheckAuthorization(string resource, string action, string role, int userId, int id)
{
System.Data.Entity.Core.Objects.ObjectResult<int?> result;
using (OnATripEntities tr = new OnATripEntities())
{
result = tr.CheckAuthorization(resource, action, role, userId, id);
return (result.SingleOrDefault() >= 1);
}
}
public ViewTrip UpdateTrip(ViewTrip viewTrip, int id)
{
using (OnATripEntities tr = new OnATripEntities())
{
Trip dbTrip = tr.Trips.Where(trp => trp.TripId == viewTrip.TripId).Select(trp => trp).FirstOrDefault();
Mapper.Map(viewTrip, dbTrip);
tr.SaveChanges();
viewTrip.TripId = dbTrip.TripId;
}
return viewTrip;
}
public ViewTrip GetTrip(int tripId)
{
ViewTrip trip = new ViewTrip();
using (OnATripEntities tr = new OnATripEntities())
{
Trip dbTrip = tr.Trips.Where(trp => trp.TripId == tripId).Select(trp => trp).FirstOrDefault();
Mapper.Map(dbTrip, trip);
ICollection<Activity> dbActivity = (from a in tr.Activities where a.TripID == tripId select a).ToList();
trip.activity = Mapper.Map <ICollection<ViewActivity>>(dbActivity);
}
return trip;
}
public ViewTripUser Update(ViewTripUser user)
{
using (OnATripEntities tr = new OnATripEntities())
{
User u1 = tr.Users.Where (u => u.UserId == user.UserId).Select(u => u).FirstOrDefault();
Mapper.Map(user, u1);
//tr.Entry(u1).State = System.Data.Entity.EntityState.Modified;
tr.SaveChanges();
}
return user;
}
public ViewTripUser Create(ViewTripUser user)
{
using (OnATripEntities tr = new OnATripEntities())
{
User repositoryUser = Mapper.Map<User>(user);
tr.Users.Add(repositoryUser);
tr.SaveChanges();
user.UserId = repositoryUser.UserId;
}
return user;
}
public void DeleteTrip(int id)
{
using (OnATripEntities tr = new OnATripEntities())
{
var x = tr.Trips.Where(trp => trp.TripId == id).FirstOrDefault();
if (x != null)
{
tr.Trips.Remove(x);
}
tr.SaveChanges();
}
}
public void Delete(int userId)
{
using (OnATripEntities tr = new OnATripEntities())
{
tr.Logins.Remove(tr.Logins.Where(l => l.UserId == userId).FirstOrDefault());
tr.SaveChanges();
var user = tr.Users.Where(u => u.UserId == userId).FirstOrDefault();
if (user != null)
{
tr.Users.Remove(user);
tr.SaveChanges();
}
}
}
public ViewActivity CreateActivity(ViewActivity viewActivity,int id)
{
// nacteni spravneho tripID ktere se overi v controlleru ze uzivatel je
// vlastnikem tohoto vyletu
viewActivity.TripID = id;
using (OnATripEntities tr = new OnATripEntities())
{
Activity dbActivity = tr.Activities.Add(Mapper.Map<Activity>(viewActivity));
var point = string.Format("POINT({1} {0})", viewActivity.gps.lat, viewActivity.gps.lon);
dbActivity.GPS = System.Data.Entity.Spatial.DbGeography.FromText(point);
tr.SaveChanges();
viewActivity.ActivityID = dbActivity.ActivityID;
}
return viewActivity;
}
public static ViewTripUser GetUserFromToken(string token)
{
using (OnATripEntities tr = new OnATripEntities())
{
var dbUser = (from u in tr.Users from l in tr.Logins where u.UserId == l.UserId && l.Token == token select u).FirstOrDefault();
if (dbUser != null)
{
ViewTripUser user = new ViewTripUser();
Mapper.Map(dbUser, user);
user.Token = token;
return user;
}
return null;
}
}
public ViewActivity UpdateActivity(ViewActivity viewActivity, int id)
{
using (OnATripEntities tr = new OnATripEntities())
{
Activity dbActivity = tr.Activities.Where(act => act.ActivityID == id).Select(act => act).FirstOrDefault();
tr.ActivityActivityTypeMaps.RemoveRange(tr.ActivityActivityTypeMaps.Where(at => at.ActivityID == id));
tr.SaveChanges();
// odstranim z viewActivity objekty activityType, aby se znovu nepridaly do activityType
foreach (var at in viewActivity.activityActivityTypeMaps)
{
at.activityType = null;
}
Mapper.Map(viewActivity, dbActivity);
dbActivity.ActivityID = id;
var point = string.Format("POINT({1} {0})", viewActivity.gps.lat, viewActivity.gps.lon);
dbActivity.GPS = System.Data.Entity.Spatial.DbGeography.FromText(point);
tr.SaveChanges();
}
return viewActivity;
}
public ViewActivity Update(ViewActivity activity)
{
ICollection<ViewActivity> activities = new HashSet<ViewActivity>();
using (OnATripEntities tr = new OnATripEntities())
{
Activity activityDb = tr.Activities.Where(a => a.ActivityID == activity.ActivityID).Select(a => a).FirstOrDefault();
Mapper.Map(activity, activityDb);
//tr.Entry(u1).State = System.Data.Entity.EntityState.Modified;
tr.SaveChanges();
}
return activity;
}
public void DeleteActivities(int id)
{
ICollection<ViewActivity> activities = new HashSet<ViewActivity>();
using (OnATripEntities tr = new OnATripEntities())
{
tr.Activities.Remove(tr.Activities.Where(tam => tam.TripID == id).FirstOrDefault());
tr.SaveChanges();
}
}
public ICollection<ViewActivityType> GetTypes()
{
ICollection<ViewActivityType> activityTypes = new HashSet<ViewActivityType>();
using (OnATripEntities tr = new OnATripEntities())
{
var dbActivityTypes = from at in tr.ActivityTypes where at.ParentID == null select at;
Mapper.Map(dbActivityTypes, activityTypes);
}
return activityTypes;
}
