public void AddCity([FromBody] CityModel model)
{
if (ModelState.IsValid)
{
if (model.Id == 0)
{
City city = new City()
{
Id = model.Id,
Name = model.Name,
CountryId = model.CountryId,
IsDeleted = false
};
db.Cities.Add(city);
}
if (model.Id != 0)
{
City city = db.Cities.FirstOrDefault(x => x.Id == model.Id);
city.Name = model.Name;
city.CountryId = model.CountryId;
db.Entry(city).State = EntityState.Modified;
}
db.SaveChanges();
}
}
public void AddAirport([FromBody] AirportModel model)
{
if (ModelState.IsValid)
{
if (model.Id == 0)
{
Airport airport = new Airport()
{
Id = model.Id,
Name = model.Name,
Code = model.Code,
CityId = model.CityId,
IsDeleted = false
};
db.Airports.Add(airport);
}
if (model.Id != 0)
{
Airport airport = db.Airports.FirstOrDefault(x => x.Id == model.Id);
airport.Name = model.Name;
airport.Code = model.Code;
airport.CityId = model.CityId;
db.Entry(airport).State = EntityState.Modified;
}
db.SaveChanges();
}
}
public IHttpActionResult EditCustomer(Customer editCustomer)
{
if (ModelState.IsValid)
{
var customer = db.Customers.Find(GetCustomer(User.Identity.Name).Id);
User user = db.Users.Include(u => u.Role).FirstOrDefault(u => u.Email == customer.Email);
if (user != null && User.Identity.Name != editCustomer.Email)
{
ModelState.AddModelError("", "user with such email already exists");
return(BadRequest(ModelState));
}
customer.FirstName = editCustomer.FirstName;
customer.LastName = editCustomer.LastName;
customer.PhoneNumber = editCustomer.PhoneNumber;
customer.DateOfBirth = editCustomer.DateOfBirth;
customer.Email = editCustomer.Email;
db.Entry(customer).State = EntityState.Modified;
user.Email = editCustomer.Email;
db.Entry(user).State = EntityState.Modified;
db.SaveChanges();
Utils utils = new Utils();
utils.AddUserInCookies(user, AuthenticationManager);
return(Ok());
}
return(BadRequest(ModelState));
}
public void DeleteCity(int id)
{
City city = GetCityById(id);
city.IsDeleted = true;
context.Entry(city).State = EntityState.Modified;
Save();
}
public IHttpActionResult DeleteTour([FromBody] int id)
{
Tour tour = db.Tours.Find(id);
tour.IsDeleted = true;
db.Entry(tour).State = EntityState.Modified;
db.SaveChanges();
return(Ok());
}
public void EditFlight([FromBody] EditFlightModel model)
{
Flight flight = db.Flights.FirstOrDefault(x => x.Id == model.id);
flight.Number = model.number;
flight.Price = model.price;
flight.DepartureAirportId = model.departureAirportId;
flight.ArrivalAirportId = model.arrivalAirportId;
flight.Airplane.Model = model.airplaneModel;
flight.Airplane.Company = model.airplaneCompany;
flight.Airplane.SeatsAmount = model.seatsAmount;
db.Entry(flight).State = EntityState.Modified;
db.Entry(flight.Airplane).State = EntityState.Modified;
db.SaveChanges();
}
public void AddCountry(CountryModel model)
{
if (model.Id == 0)
{
Country country = new Country()
{
Id = model.Id,
Name = model.Name,
IsDeleted = false
};
db.Coutries.Add(country);
}
if (model.Id != 0)
{
Country country = db.Coutries.FirstOrDefault(x => x.Id == model.Id);
country.Name = model.Name;
db.Entry(country).State = EntityState.Modified;
}
db.SaveChanges();
}
private void AddCountriesForManager(SevenWondersContext db, Manager manager, int[] countries)
{
if (manager.Countries != null)
{
foreach (var country in manager.Countries.ToList())
{
country.ManagerId = null;
db.Entry(country).State = EntityState.Modified;
}
}
db.SaveChanges();
if (countries != null)
{
var length = countries.Length;
for (int i = 0; i < length; i++)
{
var country = db.Coutries.Find(countries[i]);
country.ManagerId = manager.Id;
db.Entry(country).State = EntityState.Modified;
}
}
db.SaveChanges();
}
public virtual bool ChangePersonStatus(SevenWondersContext db, int id)
{
DbSet <T> dbSet = db.Set <T>();
var result = false;
var customer = dbSet.Find(id);
if (customer != null)
{
customer.IsDeleted = !customer.IsDeleted;
db.Entry(customer).State = EntityState.Modified;
result = true;
db.SaveChanges();
}
return(result);
}
public void EditFullManager(SevenWondersContext db, FullManagerViewModel user, int[] countries)
{
Manager manager = db.Managers.Find(user.Id);
var userFromDb = db.Users.FirstOrDefault(x => x.Email == manager.Email);
manager.LastName = user.LastName;
manager.FirstName = user.FirstName;
manager.Email = user.Email;
manager.PhoneNumber = user.PhoneNumber;
manager.DateOfBirth = user.DateOfBirth;
db.Entry(manager).State = EntityState.Modified;
db.SaveChanges();
Utils utils = new Utils();
if (user.Password != userFromDb.Password)
{
userFromDb.Password = utils.GetEncodedHash(user.Password, Security.solt);
}
userFromDb.Email = user.Email;
AddCountriesForManager(db, manager, countries);
db.Entry(userFromDb).State = EntityState.Modified;
db.SaveChanges();
}
public IHttpActionResult AddHotel([FromBody] HotelShortInfoModel model)
{
Hotel hotel = new Hotel();
if (model.Id == -1)
{
hotel.Name = model.Name;
hotel.Address = model.Address;
hotel.Description = model.Description;
hotel.CityId = model.CityId;
hotel.FoodPrice = model.FoodPrice;
hotel.FoodTypeId = model.FoodTypeId;
hotel.RatingId = model.Rating;
db.Hotels.Add(hotel);
if (model.Facilities != null)
{
foreach (var f in model.Facilities)
{
Facility facility = db.Facilities.FirstOrDefault(e => e.Id.ToString() == f);
facility.Hotels.Add(hotel);
}
}
}
else
{
hotel = db.Hotels.FirstOrDefault(x => x.Id == model.Id);
hotel.Name = model.Name;
hotel.Address = model.Address;
hotel.Description = model.Description;
hotel.CityId = model.CityId;
hotel.FoodPrice = model.FoodPrice;
hotel.FoodTypeId = model.FoodTypeId;
hotel.RatingId = model.Rating;
var photosForDeleting = hotel.HotelsPhotos.Where(x => !model.HotelPhotos.Any(y => y.Id == x.Id));
foreach (var photo in photosForDeleting)
{
string path = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, photo.PhotoLink.Remove(0, 6).Replace("/", "\\"));
if (System.IO.File.Exists(path))
{
System.IO.File.Delete(path);
}
photo.IsDeleted = true;
db.Entry(photo).State = EntityState.Modified;
}
hotel.Facilities.RemoveRange(0, hotel.Facilities.Count);
if (model.Facilities != null)
{
foreach (var eq in model.Facilities)
{
Facility facility = db.Facilities.FirstOrDefault(e => e.Id.ToString() == eq);
hotel.Facilities.Add(facility);
}
}
db.Entry(hotel).State = EntityState.Modified;
}
db.SaveChanges();
return(Ok(hotel.Id));
}
