public void Init()
{
ctx = EFContext.CreateContext();
repo = new BookingRepository(ctx);
b = new Booking()
{
Comment = "I am a comment",
DateArrival = DateTime.Now.AddYears(1),
DateCreation = DateTime.Now,
DateDeparture = DateTime.Now.AddYears(3),
DateDesiredPayment = DateTime.Now.AddYears(3).AddMonths(1),
DateModification = DateTime.Now,
DateValidation = DateTime.Now.AddMonths(4),
Home = ctx.HomeSet.FirstOrDefault(x => x.Title == "LaCorderie"),
IsOnline = false,
IsSatisfactionSended = false,
People = new People()
{
AcceptMailing = true,
Addr = "4 place kleber",
City = "Strasbourg",
Civility = "Mr",
Comment = "A mis le feu à la chambre",
Country = "FRANCE",
DateBirth = DateTime.Now,
DateCreation = DateTime.Now,
Email = "*****@*****.**",
Firstname = "CHAABANE",
Home = ctx.HomeSet.FirstOrDefault(x => x.Title == "LaCorderie"),
Lastname = "Jalal",
Mark = 0,
Phone1 = "0600000000",
Phone2 = null,
State = null,
ZipCode = "67000",
Hide = false
},
TotalPeople = 4
};
}
public BookingController()
{
repo = new BookingRepository();
}
private void CreateBooking(BookingsModel model)
{
BookingRepository bookingRepo = new BookingRepository(_sqlConnectionString);
Booking booking = new Booking();
booking.Dealer = new Dealer();
booking.Dealer.Id = _userInfo.Id;
booking.Dealer.Name = _userInfo.DealerName;
IList<BookingItem> items = new List<BookingItem>();
foreach (BookingItemModel modelItem in model.BookingItems)
{
BookingItem bookingItem = new BookingItem();
bookingItem.Item = new Item()
{
Id = modelItem.LubeItemId
};
bookingItem.Package = new Package()
{
Id = modelItem.PackageId
};
bookingItem.Quantity = modelItem.Quantity;
bookingItem.Unit = modelItem.Unit;
items.Add(bookingItem);
}
booking.Items = items;
booking.InvoiceDate = model.InvoiceDate;
bookingRepo.Create(booking);
}
// GET: Bookings
public ActionResult Index()
{
//Get list of bookings viewable by current user
BookingRepository bookingRepo = new BookingRepository(_sqlConnectionString);
IEnumerable<Booking> model = bookingRepo.GetList();
return View(model);
}
public IEnumerable <Booking> BookingGetAllByCriterion(User user, DateTime?date, Cruise cruise, IEnumerable <StatusType> listStatus)
{
return(BookingRepository.BookingGetAllByCriterion(user, date, cruise, listStatus));
}
public IQueryOver <Booking, Booking> BookingGetByCriterion(DateTime?date, Cruise cruise)
{
return(BookingRepository.BookingGetByCriterion(date, cruise));
}
public IList <Booking> BookingGetAllBy(DateTime?startDate, int bookingStatus, bool isLimousine)
{
return(BookingRepository.BookingGetAllBy(startDate, bookingStatus, isLimousine));
}
public IList <Booking> BookingReportBLL_BookingSearchBy(DateTime startDate, int cruiseId, int bookingStatus)
{
return(BookingRepository.BookingReportBLL_BookingSearchBy(startDate, cruiseId, bookingStatus));
}
public InstantPaymentNotification(HttpRequest request, string accountEmail, NameValueCollection form, BookingRepository repositoryTicket)
{
this.request = request;
this.accountEmail = accountEmail;
this.form = form;
_bookingRepository = repositoryTicket;
}
public BookingReportBLL()
{
BookingRepository = new BookingRepository();
CruiseRepository = new CruiseRepository();
}
public CreateBookingCommand(BookingRepository bookingRepostiory, UnitOfWork uow)
{
_bookingRepository = bookingRepostiory;
_uow = uow;
}
// GET: Room
public ActionResult Index(string sortOrder, string option, string searchString, string currentFilter, int?page)
{
ViewBag.CurrentSort = sortOrder;
ViewBag.nameSortParm = String.IsNullOrEmpty(sortOrder) ? "name_desc" : "";
ViewBag.descrSortParm = sortOrder == "descr" ? "descr_desc" : "descr";
ViewBag.capacitySortParm = sortOrder == "capacity" ? "capacity_desc" : "capacity";
if (searchString != null)
{
page = 1;
}
else
{
searchString = currentFilter;
}
ViewBag.CurrentFilter = searchString;
var details = from r in db.Rooms select r;
if (!String.IsNullOrEmpty(searchString))
{
details = details.Where(r => (r.RoomName.Contains(searchString)) || (r.Description.Contains(searchString)));
}
switch (sortOrder)
{
case "name_desc":
details = details.OrderByDescending(d => d.RoomName);
break;
case "descr":
details = details.OrderBy(d => d.Description);
break;
case "descr_desc":
details = details.OrderByDescending(d => d.Description);
break;
case "capacity":
details = details.OrderBy(d => d.Capacity);
break;
case "capacity_desc":
details = details.OrderByDescending(d => d.Capacity);
break;
default:
details = details.OrderBy(d => d.RoomName);
break;
}
int pageSize = 5;
int pageNumber = (page ?? 1);
BookingRepository repository = new BookingRepository();
var userRoles = repository.GetRoles(User.Identity.Name);
if (userRoles.Any(ur => ur == "admin"))
{
ViewBag.IsAdmin = true;
}
else
{
ViewBag.IsAdmin = false;
}
return(View(details.ToPagedList(pageNumber, pageSize)));
//return View(db.Rooms.ToList());
}
public IHttpActionResult GetSales(int id)
{
Dictionary <string, double> keyValuePairs = new Dictionary <string, double>();
BookingRepository bookingRepository = new BookingRepository();
var bookings = bookingRepository.GetAll().Where(b => b.BookingTime <= DateTime.Now && b.Trip.Bus.VendorId == id);
foreach (var booking in bookings)
{
var str = booking.BookingTime.Date.ToShortDateString();
if (keyValuePairs.ContainsKey(str))
{
keyValuePairs[str] += booking.Trip.Bus.PerSeatFair;
}
else
{
keyValuePairs.Add(str, booking.Trip.Bus.PerSeatFair);
}
}
var dates = keyValuePairs.Keys;
var sales = keyValuePairs.Values;
keyValuePairs = new Dictionary <string, double>();
bookingRepository = new BookingRepository();
bookings = bookingRepository.GetAll().Where(b => b.Trip.Bus.VendorId == 1);
BusRepository busRepository = new BusRepository();
var buses = busRepository.GetAll().Where(b => b.VendorId == 1);
List <string> busList = new List <string>();
List <double> earning = new List <double>();
foreach (var bus in buses)
{
var b = bus.BusName + "[" + bus.BusId.ToString() + "]";
var d = 0.0;
var trp = bus.Trips;
foreach (var t in trp)
{
int pti = t.Bookings.Where(x => x.SeatStatus != "reserved").ToList().Count;
d += pti * t.Bus.PerSeatFair;
}
//busList.Add(b);
//earning.Add(d);
keyValuePairs.Add(b, d);
}
var ordered = keyValuePairs.OrderByDescending(x => x.Value).Take(10).ToDictionary(x => x.Key, x => x.Value);
int n = ordered.Count < 3 ? ordered.Count : 3;
for (int i = 0; i < n; i++)
{
busList.Add(ordered.Keys.ElementAt(i));
earning.Add(ordered.Values.ElementAt(i));
}
return(Ok(new
{
dates,
sales,
busList,
earning
}));
}
public SeriesManagerBLL()
{
SeriesRepository = new SeriesRepository();
BookingRepository = new BookingRepository();
}
//Creamos el constructor y desde el mismo detectamos alguna exepcion en la data
public BookingController(BookingRepository bookingRepository)
{
_bookingRepository = bookingRepository ?? throw new ArgumentNullException(nameof(bookingRepository));
}
