public CancelBookingViewModel GetCancelledBooking(int transId) { CancelBookingViewModel cancelledBooking = null; var booking = (from b in _dbcontext.Bookings where b.trn_Id.Equals(transId) select b).FirstOrDefault(); if (booking != null) { cancelledBooking = new CancelBookingViewModel() { TransId = booking.trn_Id, CustomerFullname = Utilities.getfullname(booking.Customer.lastname, booking.Customer.firstname, booking.Customer.middle), EventDate = (DateTime)booking.startdate, PackageDesc = booking.Package.p_descripton, NoofPax = (int)booking.noofperson, Venue = booking.venue, CancelDate = DateTime.Now, AmountDue = bookingPayments.Get_TotalAmountBook(transId), AmountPaid = transdetails.GetTotalPaymentByTrans(transId), }; } _dbcontext.Dispose(); return(cancelledBooking); }
public IEnumerable <RefundsViewModel> GetAllRefundsList() { List <RefundsViewModel> listRefunds = new List <RefundsViewModel>(); try { IEnumerable <Booking> bookings = (from booking in dbentities.Bookings select booking).ToList(); listRefunds = (from b in bookings select new { _tId = b.trn_Id, _trEvtDate = b.startdate, _cusId = b.c_Id, _cusfullname = Utilities.getfullname(b.Customer.lastname, b.Customer.firstname, b.Customer.middle), _occasion = b.occasion, _evtVenue = b.venue, _iscancelledbooking = b.is_cancelled, _serveStat = b.serve_stat, _tpackageAmt = bookingPayments.Get_TotalAmountBook(b.trn_Id), _totapayment = (from p in dbentities.Payments select p).Where(s => s.trn_Id == b.trn_Id).Sum(x => x.amtPay), _hasrefundEntry = (from rp in dbentities.Refunds select rp).Any(x => x.trn_Id == b.trn_Id), _stat = " " //}).ToList().Where(t=> t._serveStat==false || t._iscancelledbooking==true) .Select(book => new RefundsViewModel() }).ToList().Where(t => t._serveStat == false).Select(book => new RefundsViewModel() { TransId = book._tId, cId = (int)book._cusId, CustomerName = book._cusfullname, EventLocation = book._evtVenue, Eventdate = (DateTime)book._trEvtDate, isCancelled = (bool)book._iscancelledbooking, PaymemntAmount = Convert.ToDecimal(book._totapayment), RefundAmount = book._totapayment > book._tpackageAmt?Convert.ToDecimal(book._totapayment - book._tpackageAmt):0, //RefundAmount =book._iscancelledbooking==false? Convert.ToDecimal(book._totapayment - book._tpackageAmt): Convert.ToDecimal(book._totapayment), hasrefundEntry = book._hasrefundEntry, Status = book._stat }).ToList(); } catch (Exception e) { Console.WriteLine(e); throw; } return(listRefunds); }
public IEnumerable <AccnRecieveSummaryViewModel> GetAllAccnRecievables() { List <AccnRecieveSummaryViewModel> listAccn = new List <AccnRecieveSummaryViewModel>(); var _dbentities = new PegasusEntities(); var bookingPayments = new BookingPaymentsViewModel(); var transdetails = new TransactionDetailsViewModel(); var bookingRefund = new BookingRefundViewModel(); try { var bookings = (from booking in _dbentities.Bookings where booking.is_cancelled == false select booking).OrderBy(x => x.Customer.lastname).ToList(); listAccn = (from b in bookings //let daydue = Convert.ToDateTime(b.transdate).AddDays(30) let eventdatedue = Convert.ToDateTime(b.startdate).AddDays(30) where b.startdate != null && DateTime.Now.Subtract((DateTime)b.startdate).Days >= 0 select new AccnRecieveSummaryViewModel { cusId = Convert.ToInt32(b.c_Id), cusname = Utilities.getfullname(b.Customer.lastname, b.Customer.firstname, b.Customer.middle), transId = b.trn_Id, transDate = Convert.ToDateTime(b.startdate), duedate = eventdatedue, daysOdd = Convert.ToInt32(DateTime.Now.Subtract(eventdatedue).Days) <= 0 ? 0 : Convert.ToInt32(DateTime.Now.Subtract(eventdatedue).Days), balance = bookingPayments.Get_TotalAmountBook(b.trn_Id) - transdetails.GetTotalPaymentByTrans(b.trn_Id) }).ToList(); } catch (Exception e) { Console.WriteLine(e); throw; } return(listAccn.Where(x => x.balance > 0).ToList()); }
public IEnumerable <CustomerBookingsViewModel> GetCusBookings() { var _dbEntities = new PegasusEntities(); List <CustomerBookingsViewModel> lst = new List <CustomerBookingsViewModel>(); try { List <Booking> listbookings = new List <Booking>(); listbookings = (from b in _dbEntities.Bookings select b).ToList(); lst = (from l in listbookings select new CustomerBookingsViewModel() { transId = l.trn_Id, cusId = l.c_Id, cusfullname = Utilities.getfullname_nonreverse(l.Customer.lastname, l.Customer.firstname, l.Customer.middle), occasion = l.occasion, venue = l.venue, bookdatetime = l.startdate, package = l.Package.p_descripton, packageType = l.Package.p_type.Trim(), packageDue = bookingPayments.Get_TotalAmountBook(l.trn_Id), isServe = Convert.ToBoolean(l.serve_stat), isCancelled = Convert.ToBoolean(l.is_cancelled), bookingtype = l.booktype?.Trim() ?? "", transType = "bk" }).ToList(); } catch (Exception e) { Console.WriteLine(e); throw; } return(lst); }
public IEnumerable <TransRecievablesViewModel> GetAllRecievables(IQueryable <Booking> tBookings) { List <TransRecievablesViewModel> recievable_list = new List <TransRecievablesViewModel>(); try { IEnumerable <Booking> bookings = tBookings.ToList(); recievable_list = (from b in bookings select new { _tId = b.trn_Id, _trDate = b.transdate, _evtDate = b.startdate, _cusId = b.c_Id, _cusfullname = Utilities.getfullname(b.Customer.lastname, b.Customer.firstname, b.Customer.middle), _address = b.Customer.address, _contact = b.Customer.contact1, _occasion = b.occasion, _venue = b.venue, _iscancelledbooking = b.is_cancelled, _packagedetails = b.Package.p_descripton, _pAmountperPax = b.Package.p_amountPax, _tpackageAmt = bookingPayments.Get_TotalAmountBook(b.trn_Id), _totapayment = (from p in db_entities.Payments select p).Where(s => s.trn_Id == b.trn_Id) .Sum(x => x.amtPay), _refunds = (from re in db_entities.Refunds select re).FirstOrDefault(t => t.trn_Id == b.trn_Id) }).Select(p => new TransRecievablesViewModel() { transId = p._tId, transDate = Convert.ToDateTime(p._trDate), bookdatetime = Convert.ToDateTime(p._evtDate), cusId = Convert.ToInt32(p._cusId), cusfullname = p._cusfullname, address = p._address, contact = p._contact, occasion = p._occasion, venue = p._venue, iscancelled = Convert.ToBoolean(p._iscancelledbooking), packagedetails = p._packagedetails, p_amountperPax = Convert.ToDecimal(p._pAmountperPax), totalPackageAmount = p._tpackageAmt, totalPayment = Convert.ToDecimal(p._totapayment), //balance = Convert.ToDecimal(p._totapayment)> p._tpackageAmt?Convert.ToDecimal(p._refunds) > 0 ? Convert.ToDecimal(((p._tpackageAmt - p._totapayment) + Convert.ToDecimal(p._refunds.rf_Amount))) : Convert.ToDecimal(p._tpackageAmt - p._totapayment): p._tpackageAmt, balance = Convert.ToDecimal(p._totapayment) > p._tpackageAmt ? p._refunds != null ? Convert.ToDecimal(((p._tpackageAmt - p._totapayment) + Convert.ToDecimal(p._refunds.rf_Amount))) : Convert.ToDecimal(p._tpackageAmt - p._totapayment) : p._refunds != null?0: p._tpackageAmt == p._totapayment?0: p._tpackageAmt > p._totapayment?Convert.ToDecimal(p._tpackageAmt - p._totapayment):p._tpackageAmt, refunds = p._refunds != null ? Convert.ToDecimal(p._refunds.rf_Amount) : 0 }).ToList(); } catch (Exception e) { Console.WriteLine(e); throw; } return(recievable_list); }