// GET: Facilities
public ActionResult Home()
{
RepositoryTypeRoom repositoryTypeRoom = new RepositoryTypeRoom(connectionString);
IList <TypeRoom> typeRoom = repositoryTypeRoom.GetAllTypeRoom();
List <TypeRoomModel> typeRoomModel = new List <TypeRoomModel>();
DateTime date = DateTime.Today;
for (int i = 0; i < typeRoom.Count; i++)
{
TypeRoomModel typeRoomNew = new TypeRoomModel(connectionString);
typeRoomNew.quantityperson = typeRoom[i].quantityperson;
typeRoomNew.quantitybed = typeRoom[i].quantitybed;
typeRoomNew.description = typeRoom[i].description;
typeRoomNew.amount = typeRoom[i].amount;
typeRoomNew.urlimage = typeRoom[i].urlimage;
typeRoomNew.descriptiontyperoom = typeRoom[i].descriptiontyperoom;
if (date.ToString("MM") == "12" || date.ToString("MM") == "01" || date.ToString("MM") == "02" || date.ToString("MM") == "03")
{
typeRoomNew.amount += Convert.ToInt32(typeRoomNew.amount * 0.1);
}
typeRoomModel.Add(typeRoomNew);
}
return(View(typeRoomModel));
}
public JsonResult GetManageRooms(string description)
{
RepositoryTypeRoom repositoryTyperoom = new RepositoryTypeRoom(connectionString);
List <TypeRoom> typeRoom = repositoryTyperoom.GetAllTypeRoom();
TypeRoom typeRoomNew = new TypeRoom();
typeRoomNew = typeRoom.Find(r => r.description == description);
counter = description;
return(Json(typeRoomNew));
}
public ActionResult DeleteSeason(int id)
{
RepositoryTypeRoom repositoryTyperoom = new RepositoryTypeRoom(connectionString);
SeasonModel seasonModel = new SeasonModel(connectionString);
List <TypeRoomModel> typeroomModel = new List <TypeRoomModel>();
IList <TypeRoom> typeRoom = repositoryTyperoom.GetAllTypeRoom();
for (int j = 0; j < typeRoom.Count; j++)
{
TypeRoomModel typeRoomNew = new TypeRoomModel(connectionString);
typeRoomNew.description = typeRoom[j].description;
typeRoomNew.id = typeRoom[j].id;
typeroomModel.Add(typeRoomNew);
}
seasonModel.DeleteSeason(id);
Season();
return(View("Season", typeroomModel));
}
public ActionResult Update(IFormFile file, string descriptionArea, string amount)
{
string descriptionType = counter;
RepositoryTypeRoom repositoryTyperoom = new RepositoryTypeRoom(connectionString);
IList <TypeRoom> typeRoom = repositoryTyperoom.GetAllTypeRoom();
List <TypeRoomModel> typeroomModel = new List <TypeRoomModel>();
string urlimage = "";
var path = "./images/TipoHabitacion/";
var pathClient = "../../../Client/Presentation/wwwroot/images/TipoHabitacion/";
string folderFiles = Path.Combine(environment.WebRootPath, path);
string folderFilesClient = Path.Combine(environment.WebRootPath, pathClient);
int idTypeRoom = 0;
if (file != null)
{
repositoryTyperoom.SaveImage(file, folderFiles);
repositoryTyperoom.SaveImage(file, folderFilesClient);
urlimage = "/images/TipoHabitacion/" + file.FileName;
}
for (int i = 0; i < typeRoom.Count; i++)
{
if (typeRoom[i].description == descriptionType)
{
idTypeRoom = typeRoom[i].id;
if (file == null)
{
urlimage = typeRoom[i].urlimage;
}
}
TypeRoomModel typeRoomNew = new TypeRoomModel(connectionString);
typeRoomNew.description = typeRoom[i].description;
typeroomModel.Add(typeRoomNew);
}
repositoryTyperoom.UpdateTypeRoom(descriptionArea, amount, urlimage, idTypeRoom);
return(RedirectToAction("ManageRooms"));
}
// GET: /<controller>/
public IActionResult ManageRooms()
{
RepositoryTypeRoom repositoryTyperoom = new RepositoryTypeRoom(connectionString);
IList <TypeRoom> typeRoom = repositoryTyperoom.GetAllTypeRoom();
TypeRoomModel typeRoomModel = new TypeRoomModel(connectionString);
List <TypeRoomModel> typeroomModel = new List <TypeRoomModel>();
RoomModel room = new RoomModel(connectionString);
IList <Room> listRoom = room.GetAllRoom();
List <RoomModel> roomModel = new List <RoomModel>();
ReservationModel reservation = new ReservationModel(connectionString);
IList <Reservation> listReservation = reservation.GetAllReservation();
List <ReservationModel> reservationModel = new List <ReservationModel>();
for (int i = 0; i < listRoom.Count; i++)
{
RoomModel roomNew = new RoomModel(connectionString);
roomNew.state = listRoom[i].state;
roomNew.number = listRoom[i].number;
roomNew.idtyperoom = listRoom[i].idtyperoom;
roomModel.Add(roomNew);
}
for (int j = 0; j < typeRoom.Count; j++)
{
TypeRoomModel typeRoomNew = new TypeRoomModel(connectionString);
typeRoomNew.description = typeRoom[j].description;
typeRoomNew.id = typeRoom[j].id;
typeroomModel.Add(typeRoomNew);
}
for (int j = 0; j < listReservation.Count; j++)
{
ReservationModel reservationNew = new ReservationModel(connectionString);
reservationNew.idroom = listReservation[j].idroom;
reservationModel.Add(reservationNew);
}
ViewBag.reservation = reservationModel;
ViewBag.room = roomModel;
return(View(typeroomModel));
}
public ActionResult insert(string description, string dateinputseason, string dateoutputseason, string descriptionText, int percentation)
{
RepositoryTypeRoom repositoryTyperoom = new RepositoryTypeRoom(connectionString);
SeasonModel seasonModel = new SeasonModel(connectionString);
IList <TypeRoom> typeRoom = repositoryTyperoom.GetAllTypeRoom();
int idtyperoom = 0;
List <TypeRoomModel> typeroomModel = new List <TypeRoomModel>();
for (int j = 0; j < typeRoom.Count; j++)
{
TypeRoomModel typeRoomNew = new TypeRoomModel(connectionString);
typeRoomNew.description = typeRoom[j].description;
typeRoomNew.id = typeRoom[j].id;
if (description.Equals(typeRoom[j].description))
{
idtyperoom = typeRoom[j].id;
}
typeroomModel.Add(typeRoomNew);
}
if (idtyperoom != 0 || percentation != 0)
{
seasonModel.InsertSeason(idtyperoom, idtyperoom, dateinputseason, dateoutputseason, descriptionText, 1, percentation);
}
idtyperoom = 0;
percentation = 0;
dateinputseason = null;
dateoutputseason = null;
descriptionText = null;
Season();
return(View("Season", typeroomModel));
}
public IActionResult Season()
{
SeasonModel seasonModel = new SeasonModel(connectionString);
IList <Season> season = seasonModel.GetAllSeason();
List <SeasonModel> seasonModellist = new List <SeasonModel>();
RepositoryTypeRoom repositoryTyperoom = new RepositoryTypeRoom(connectionString);
IList <TypeRoom> typeRoom = repositoryTyperoom.GetAllTypeRoom();
List <TypeRoomModel> typeroomModel = new List <TypeRoomModel>();
for (int i = 0; i < season.Count; i++)
{
SeasonModel reservationNew = new SeasonModel();
reservationNew.id = season[i].id;
reservationNew.idtyperoom = season[i].idtyperoom;
reservationNew.percentation = season[i].percentation;
reservationNew.state = season[i].state;
reservationNew.dateinputseason = season[i].dateinputseason;
reservationNew.dateoutputseason = season[i].dateoutputseason;
reservationNew.description = season[i].description;
seasonModellist.Add(reservationNew);
}
for (int j = 0; j < typeRoom.Count; j++)
{
TypeRoomModel typeRoomNew = new TypeRoomModel(connectionString);
typeRoomNew.description = typeRoom[j].description;
typeRoomNew.id = typeRoom[j].id;
typeroomModel.Add(typeRoomNew);
}
ViewBag.type = typeroomModel;
ViewBag.season = seasonModellist;
return(View(typeroomModel));
}//State
public IActionResult State()
{
ReservationModel repositoryReservation = new ReservationModel(connectionString);
IList <Reservation> reservation = repositoryReservation.GetAllReservation();
List <ReservationModel> reservationModel = new List <ReservationModel>();
List <ReservationModel> reservationModelfree = new List <ReservationModel>();
RepositoryTypeRoom repositoryTyperoom = new RepositoryTypeRoom(connectionString);
IList <TypeRoom> typeRoom = repositoryTyperoom.GetAllTypeRoom();
List <TypeRoomModel> typeroomModel = new List <TypeRoomModel>();
List <TypeRoomModel> typeroomModelfree = new List <TypeRoomModel>();
RoomModel repositoryroom = new RoomModel(connectionString);
IList <Room> room = repositoryroom.GetAllRoom();
List <RoomModel> roomModel = new List <RoomModel>();
List <RoomModel> roomModelfree = new List <RoomModel>();
string date = DateTime.Now.ToString("yyyy-MM-dd");
DateTime enteredDate1 = DateTime.Parse(date);
for (int i = 0; i < reservation.Count; i++)
{
ReservationModel reservationNew = new ReservationModel();
reservationNew.idroom = reservation[i].idroom;
reservationNew.arrivaldate = reservation[i].arrivaldate;
string strDate = reservation[i].arrivaldate.ToString("yyyy-MM-dd");
string strDate1 = reservation[i].departuredate.ToString("yyyy-MM-dd");
DateTime enteredDate2 = DateTime.Parse(strDate);
DateTime enteredDate3 = DateTime.Parse(strDate1);
for (int j = 0; j < room.Count; j++)
{
if (reservationNew.idroom.Equals(room[j].id) && (enteredDate1 >= enteredDate2 && enteredDate1 <= enteredDate3))
{
RoomModel RoomNew = new RoomModel(connectionString);
RoomNew.id = room[j].id;
RoomNew.number = room[j].number;
RoomNew.idtyperoom = room[j].idtyperoom;
for (int k = 0; k < typeRoom.Count; k++)
{
if (RoomNew.idtyperoom.Equals(typeRoom[k].id))
{
TypeRoomModel typeRoomNew = new TypeRoomModel(connectionString);
typeRoomNew.id = typeRoom[k].id;
typeRoomNew.description = typeRoom[k].description;
typeroomModel.Add(typeRoomNew);
reservationModel.Add(reservationNew);
roomModel.Add(RoomNew);
}
} //tercer for
} /// if reservation with Room
} //segundo for
} //primer for
for (int i = 0; i < reservation.Count; i++)
{
ReservationModel reservationNew = new ReservationModel();
reservationNew.idroom = reservation[i].idroom;
string strDate = reservation[i].arrivaldate.ToString("yyyy-MM-dd");
for (int j = 0; j < room.Count; j++)
{
if (reservationNew.idroom.Equals(room[j].id) && !strDate.Equals(date))
{
RoomModel RoomNew = new RoomModel(connectionString);
RoomNew.id = room[j].id;
RoomNew.number = room[j].number;
RoomNew.idtyperoom = room[j].idtyperoom;
for (int k = 0; k < typeRoom.Count; k++)
{
if (RoomNew.idtyperoom.Equals(typeRoom[k].id))
{
TypeRoomModel typeRoomNew = new TypeRoomModel(connectionString);
typeRoomNew.id = typeRoom[k].id;
typeRoomNew.description = typeRoom[k].description;
typeroomModelfree.Add(typeRoomNew);
reservationModelfree.Add(reservationNew);
roomModelfree.Add(RoomNew);
}
} //tercer for
} /// if reservation with Room
} //segundo for
} //primer for
ViewBag.roomfree = roomModelfree;
ViewBag.typeroomfree = typeroomModelfree;
ViewBag.reservationfree = reservationModelfree;
ViewBag.room = roomModel;
ViewBag.typeroom = typeroomModel;
ViewBag.reservation = reservationModel;
return(View());
}//State