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