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 DeleteTour([FromBody] int id) { Tour tour = db.Tours.Find(id); tour.IsDeleted = true; db.Entry(tour).State = EntityState.Modified; db.SaveChanges(); return(Ok()); }
public IHttpActionResult AddPhotos(int id) { var keys = System.Web.HttpContext.Current.Request.Files.AllKeys; string path = AppDomain.CurrentDomain.BaseDirectory + "static\\Content\\img\\Hotels\\Hotel" + id + "\\"; if (!Directory.Exists(path)) { Directory.CreateDirectory(path); } foreach (var key in keys) { var picture = System.Web.HttpContext.Current.Request.Files[key]; string imgpath = path + picture.FileName; WebImage img = new WebImage(picture.InputStream); if (img.Width > 600 || img.Height > 350) { img.Resize(600, 350, false, true); } img.Save(imgpath); HotelPhoto hotelPhoto = new HotelPhoto(); hotelPhoto.PhotoLink = String.Format("../../static/Content/img/Hotels/Hotel{0}/{1}", id, picture.FileName); hotelPhoto.HotelId = id; db.HotelsPhotos.Add(hotelPhoto); db.SaveChanges(); } return(Ok()); }
public IHttpActionResult Register(RegisterViewModel model) { if (ModelState.IsValid) { Utils utils = new Utils(); var user = GetPersonByEmail <User>(model.Email); if (user != null) { ModelState.AddModelError("", "user with such email already exists"); return(BadRequest(ModelState)); } user = new User() { Email = model.Email, Password = utils.GetEncodedHash(model.Password, Security.solt), Role = db.Roles.Find(1) }; var customer = new Customer() { Email = model.Email, FirstName = model.FirstName, LastName = model.LastName, DateOfBirth = model.DateOfBirth, PhoneNumber = model.PhoneNumber }; db.Users.Add(user); db.Customers.Add(customer); db.SaveChanges(); utils.AddUserInCookies(user, AuthenticationManager); return(Ok()); } return(BadRequest(ModelState)); }
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 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 AddFlight([FromBody] EditFlightModel model) { Airplane airplane = new Airplane() { Model = model.airplaneModel, Company = model.airplaneCompany, SeatsAmount = model.seatsAmount, IsDeleted = false }; Flight flight = new Flight() { Number = model.number, Price = model.price, DepartureAirportId = model.departureAirportId, ArrivalAirportId = model.arrivalAirportId, Airplane = airplane, AirplaneId = airplane.Id }; db.Airplanes.Add(flight.Airplane); db.Flights.Add(flight); db.SaveChanges(); }
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 BookTour([FromBody] TourForBookingModel model) { try { Room room = db.Rooms.Find(model.RoomId); Schedule leaveSchedule = db.Schedule.Find(model.LeaveScheduleId); Schedule returnSchedule = db.Schedule.Find(model.ReturnScheduleId); decimal totalPrice = model.Duration * (room.Price + model.PersonAmount * (model.WithoutFood ? 0 : room.Hotel.FoodPrice)) + model.PersonAmount * (leaveSchedule.Flight.Price + returnSchedule.Flight.Price); Reservation reservation = new Reservation() { RoomId = model.RoomId, PersonAmount = model.PersonAmount, LeaveScheduleId = model.LeaveScheduleId, ReturnScheduleId = model.ReturnScheduleId, LeaveDate = model.LeaveDate, ReturnDate = model.LeaveDate.AddDays(model.Duration), IsDeleted = false, WithoutFood = model.WithoutFood }; Tour tour = new Tour() { Reservation = reservation, ReservationId = reservation.Id, CreationDate = DateTime.Now, TotalPrice = totalPrice, TourStateId = 1, IsDeleted = false, CustomerId = getCustomer(User.Identity.Name).Id }; db.Reservations.Add(tour.Reservation); db.Tours.Add(tour); db.SaveChanges(); } catch (Exception ex) { int i = 1 + 1; } return(Ok()); }
public void AddFullManager(SevenWondersContext db, FullManagerViewModel user, int[] countries) { if (db.Users.Any(x => x.Email == user.Email)) { throw new OverflowException("user with this email is already exist"); } Utils utils = new Utils(); string password = utils.GetEncodedHash(user.Password, Security.solt); db.Users.Add(new User() { Email = user.Email, Password = password, RoleId = 3 }); Manager manager = new Manager() { DateOfBirth = user.DateOfBirth.ToUniversalTime(), FirstName = user.FirstName, LastName = user.LastName, PhoneNumber = user.PhoneNumber, Email = user.Email, IsDeleted = false }; db.Managers.Add(manager); db.SaveChanges(); AddCountriesForManager(db, manager, countries); }
public void Save() { context.SaveChanges(); }