public int Create(RoleEntity role)
{
CatchMeContext.Roles.Add(role);
CatchMeContext.SaveChanges();
return(role.Id);
}
private void Update(TripEntity trip)
{
var tripToUpdate = this.GetById(trip.Id);
if (tripToUpdate != null)
{
tripToUpdate.DriverId = trip.DriverId;
tripToUpdate.Price = trip.Price;
tripToUpdate.Seats = trip.Seats;
tripToUpdate.StaticMapUrl = trip.StaticMapUrl;
tripToUpdate.StartDateTime = trip.StartDateTime;
if (tripToUpdate.Vehicle != null)
{
tripToUpdate.Vehicle.Color = trip.Vehicle.Color;
tripToUpdate.Vehicle.Manufacturer = trip.Vehicle.Manufacturer;
tripToUpdate.Vehicle.Model = trip.Vehicle.Model;
tripToUpdate.Vehicle.Year = trip.Vehicle.Year;
}
CatchMeContext.MapPoints.RemoveRange(tripToUpdate.MapPoints);
CatchMeContext.SaveChanges();
AddMapPoints(trip);
}
}
public void Update(UserEntity user)
{
var userToUpdate = CatchMeContext.Users.Find(user.Id);
if (userToUpdate != null)
{
var userProfile = CatchMeContext.UserProfiles.FirstOrDefault(up => up.UserId == user.Id);
if (userProfile != null)
{
userProfile.FirstName = user.Profile.FirstName;
userProfile.LastName = user.Profile.LastName;
userProfile.PhoneNumber = user.Profile.PhoneNumber;
}
userToUpdate.Email = user.Email;
userToUpdate.EmailConfirmed = user.EmailConfirmed;
userToUpdate.PasswordHash = user.PasswordHash;
userToUpdate.SecurityStamp = user.SecurityStamp;
userToUpdate.UserName = user.UserName;
userToUpdate.Profile = user.Profile;
userToUpdate.CreationTime = user.CreationTime;
CatchMeContext.SaveChanges();
}
}
public int Create(UserEntity user)
{
CatchMeContext.UserProfiles.Add(user.Profile);
CatchMeContext.Users.Add(user);
CatchMeContext.SaveChanges();
return(user.Id);
}
private void Add(TripEntity trip)
{
CatchMeContext.Vehicles.Add(trip.Vehicle);
CatchMeContext.Trips.Add(trip);
CatchMeContext.SaveChanges();
AddMapPoints(trip);
}
public void Update(RoleEntity role)
{
var roleToUpdate = CatchMeContext.Roles.Find(role.Id);
if (roleToUpdate != null)
{
roleToUpdate.Name = role.Name;
CatchMeContext.SaveChanges();
}
}
public void Delete(int id)
{
var trip = CatchMeContext.Trips.Find(id);
if (trip != null)
{
CatchMeContext.Trips.Remove(trip);
CatchMeContext.SaveChanges();
}
}
private void AddMapPoint(int tripId, MapPoint point, int sequence)
{
point.TripId = tripId;
point.Sequence = sequence;
CatchMeContext.MapPoints.Add(point);
CatchMeContext.Addresses.Add(point.AddressDetails);
CatchMeContext.SaveChanges();
}
public void Delete(UserEntity user)
{
var userToDelete = CatchMeContext.Users
.FirstOrDefault(u => u.Id == user.Id);
if (userToDelete != null)
{
CatchMeContext.Users.Remove(userToDelete);
CatchMeContext.SaveChanges();
}
}
public void AddToRole(UserEntity user, string roleName)
{
var role = CatchMeContext.Roles.FirstOrDefault(r => r.Name == roleName);
if (role != null)
{
var foundedUser = CatchMeContext.Users
.Where(u => u.Id == user.Id)
.Include(x => x.Roles)
.FirstOrDefault();
foundedUser.Roles.Add(role);
CatchMeContext.SaveChanges();
}
}
public void AddPassenger(int tripId, int passengerId)
{
var passenger = CatchMeContext.Passengers.FirstOrDefault(x => x.TripId == tripId && x.UserId == passengerId);
if (passenger != null)
{
passenger.BookedSeats++;
}
else
{
CatchMeContext.Passengers.Add(new PassengerEntity()
{
TripId = tripId,
UserId = passengerId,
BookedSeats = 1
});
}
CatchMeContext.SaveChanges();
}
public void Delete(RoleEntity role)
{
CatchMeContext.Roles.Remove(role);
CatchMeContext.SaveChanges();
}
