public IHttpActionResult DeleteHoliday(int holidayId)
{
if (CheckRole("Admin"))
{
return(StatusCode(HttpStatusCode.Unauthorized));
}
HolidayDays holiday = context.Holidays.Where(x => x.ID == holidayId).FirstOrDefault();
holiday.Deleted = true;
//context.Amenities.Remove(amm);
context.SaveChanges();
return(Ok("Succsesfuly deleted"));
}
public IHttpActionResult AddHoliday(DateTime holiday)
{
if (CheckRole("Admin"))
{
return(StatusCode(HttpStatusCode.Unauthorized));
}
HolidayDays test = context.Holidays.Where(x => x.Holiday == holiday && x.Deleted == false).FirstOrDefault();
if (test != null)
{
return(BadRequest("There is already a holiday with that date"));
}
HolidayDays holidayDay = new HolidayDays();
holidayDay.Holiday = holiday;
holidayDay.Deleted = false;
context.Holidays.Add(holidayDay);
context.SaveChanges();
return(Ok("Succsesfuly added"));
}
protected override void Seed(AirBnb_Web1.DataAccessLayer.AirBnbContext context)
{
// This method will be called after migrating to the latest version.
// You can use the DbSet<T>.AddOrUpdate() helper extension method
// to avoid creating duplicate seed data.
Adress adress1 = new Adress();
adress1.ID = 1;
adress1.Streat = "Bulevar Oslobodjenja";
adress1.StreatNumber = 30;
adress1.ZipCode = 21000;
adress1.Settlement = "Novi Sad";
context.Adresss.Add(adress1);
context.SaveChanges();
Amenitie amenitie1 = new Amenitie();
amenitie1.Name = "Klima";
context.Amenities.Add(amenitie1);
context.SaveChanges();
Location location1 = new Location();
location1.ID = 1;
location1.Latitude = 45.23;
location1.Longitude = 25.23;
location1.AdressID = adress1.ID;
context.Locations.Add(location1);
context.SaveChanges();
User user1 = new User {
ID = 1, Name = "Sasa", Surname = "Dragomirovic", Gender = Helper.Enums.Genders.Male, Password = "******", Role = Helper.Enums.Roles.Admin, UserName = "******", Blocked = false
};
User user2 = new User {
ID = 2, Name = "Biba", Surname = "Bibic", Gender = Helper.Enums.Genders.Male, Password = "******", Role = Helper.Enums.Roles.Guest, UserName = "******", Blocked = false
};
User user3 = new User {
ID = 3, Name = "Gruja", Surname = "Grujic", Gender = Helper.Enums.Genders.Male, Password = "******", Role = Helper.Enums.Roles.Host, UserName = "******", Blocked = false
};
context.Users.Add(user1);
context.Users.Add(user2);
context.Users.Add(user3);
context.SaveChanges();
Apartman apartman1 = new Apartman {
ID = 1, SingUpTime = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day, 12, 0, 0), SingOutTime = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day, 12, 0, 0), Status = Helper.Enums.ApartmanStatus.Active, GuestNumber = 3, HostID = user3.ID, LocationID = location1.ID, PricePerNight = 20, RoomNumber = 2
};
context.Apartmans.Add(apartman1);
context.SaveChanges();
Comment comment1 = new Comment {
ID = 1, ApartmanID = apartman1.ID, GuestID = user2.ID, Rate = 9.5, Text = "Nice one"
};
context.Comments.Add(comment1);
context.SaveChanges();
DatesModel rentDate1 = new DatesModel {
ID = 1, ApartmanID = apartman1.ID, Available = true, RentDate = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day, 12, 0, 0)
};
context.DatesModels.Add(rentDate1);
context.SaveChanges();
DatesModel rentDate2 = new DatesModel {
ID = 1, ApartmanID = apartman1.ID, Available = true, RentDate = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day, 12, 0, 0)
};
context.DatesModels.Add(rentDate2);
context.SaveChanges();
DatesModel rentDate3 = new DatesModel {
ID = 1, ApartmanID = apartman1.ID, Available = true, RentDate = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day, 12, 0, 0)
};
context.DatesModels.Add(rentDate3);
context.SaveChanges();
Reservation reservation1 = new Reservation {
ID = 1, ApartmanID = apartman1.ID, GuestID = user2.ID, NumberOfNights = 10, SingUpDate = rentDate1.RentDate, Stauts = Helper.Enums.ReservationStatus.Accepted, TotalPrice = 100
};
context.Reservations.Add(reservation1);
context.SaveChanges();
Reservation reservation2 = new Reservation {
ID = 2, ApartmanID = apartman1.ID, GuestID = user2.ID, NumberOfNights = 10, SingUpDate = rentDate2.RentDate, Stauts = Helper.Enums.ReservationStatus.Created, TotalPrice = 200
};
context.Reservations.Add(reservation2);
context.SaveChanges();
Reservation reservation3 = new Reservation {
ID = 3, ApartmanID = apartman1.ID, GuestID = user2.ID, NumberOfNights = 10, SingUpDate = rentDate3.RentDate, Stauts = Helper.Enums.ReservationStatus.Done, TotalPrice = 200
};
context.Reservations.Add(reservation3);
context.SaveChanges();
HolidayDays h1 = new HolidayDays {
Deleted = false, Holiday = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day, 12, 0, 0)
};
context.Holidays.Add(h1);
context.SaveChanges();
}