public ActionResult OverView(Booking booking)
{
////find vehicle by vehicle ID
ApplicationUser user = db.Users.Include(x => x.Bookings).FirstOrDefault(x => x.Id == booking.userId);
Bookingvalidation bookingvalidation = new Bookingvalidation();
Booking booking1 = bookingvalidation.BookingVal(booking, user);
BookingOverview overview = new BookingOverview
{
ChargeWithoutTax = String.Format("{0:c}", booking1.Reciept.ChargeAmount),
Tax = String.Format("{0:c}", booking1.Reciept.TAX),
TotalCharge = String.Format("{0:c}", booking1.Reciept.TotalCharges),
ReturnAddress = booking1.ReturnLocationAddress,
PickUpAddress = booking1.PickUpLocationAddress,
NumberOfDays = booking1.NumberOfDays,
VehicleName = booking1.vehicle.make + " " + booking1.vehicle.model,
Dates = "(" + booking1.PickUpDate.ToString("MMM dd") + "- " + booking1.ReturnDate.ToString("MMM dd, yyyy") + ")"
};
JsonResult res = new JsonResult
{
ContentEncoding = Encoding.Default,
ContentType = "application/json",
Data = Json(overview),
};
return(Json(overview));
}
public BookingOverview GetOverview(int Createdby)
{
//string Message;
int? Current_year = DateTime.Now.Year;
int? Current_mounth = DateTime.Now.Month;
DateTime startDate = new DateTime(DateTime.Now.Year, 1, 1);
int?TotalRequest = (from calculate in _context.BookingDetails
where calculate.Createdby == Createdby && calculate.BookingDate > DateTime.Now && calculate.BookingApproval == "P"
select calculate.BookingApproval).Count();
//var Name = (from user in _context.Registration
// where user.ID == Createdby
// select new { user.Name, user.Username }).SingleOrDefault();
int?TotalUpcoming = (from calculate in _context.BookingDetails
where calculate.Createdby == Createdby && calculate.BookingDate > DateTime.Now && calculate.BookingApproval == "A"
select calculate.BookingApproval).Count();
int?TotalCancel = (from calculate in _context.BookingDetails
where calculate.Createdby == Createdby && calculate.BookingDate > DateTime.Now && (calculate.BookingApproval == "C" || calculate.BookingApproval == "R")
select calculate.BookingApproval).Count();
DateTime?RecentBookingDate = (from calculate in _context.BookingDetails
where (calculate.Createdby == Createdby && calculate.BookingDate > DateTime.Now) && (calculate.BookingApproval == "C" || calculate.BookingApproval == "R" || calculate.BookingApproval == "A" || calculate.BookingApproval == "P")
select calculate.BookingDate).LastOrDefault();
//int? PayableFeeYearly = (from pfee in _context.AllFee
// join user in _context.Registration on pfee.ClassID equals user.ClassID
// where pfee.FeeTimeID == 1 && user.ID == Createdby
// select pfee.FeeAmount).Sum();
//int? PayableTuitionFee = (from pfee in _context.AllFee
// join user in _context.Registration on pfee.ClassID equals user.ClassID
// where pfee.FeeTimeID == 2 && user.ID == Createdby
// select pfee.FeeAmount).Sum();
//int? TotalPayableAmount = PayableFeeYearly + (PayableTuitionFee * Current_mounth);
//int? TotalDueAmount = TotalPayableAmount - TotalAmount;
BookingOverview overview = new BookingOverview()
{
TotalRequest = TotalRequest,
TotalUpcoming = TotalUpcoming,
TotalCancel = TotalCancel,
RecentBookingDate = RecentBookingDate?.ToString("dd MMMM yyyy") ?? "[N/A]"
//TotalAmount = TotalAmount,
//TotalPayableAmount = TotalPayableAmount,
//Current_year = Current_year,
//First_date = startDate.ToString("dd MMMM yyyy"),
//TotalDueAmount = TotalDueAmount,
//Name = Name.Name,
//Username = Name.Username
};
return(overview);
}
