public void ChangeStatus(int?id, string status)
{
Bookings b = db.Bookings.Find(id);
b.Status = status;
db.Entry(b).State = EntityState.Modified;
db.SaveChanges();
}
public ActionResult Index()
{
ViewBag.Message = string.Empty;
Bookings bookings = new Bookings();
return(View("IndexBooking", bookings));
}
public ActionResult MarkComplete([FromBody] HelperResources c)
{
Bookings booking = context.Bookings.FirstOrDefault(x => x.BId == c.id1 && x.CompanyId == c.id2);
booking.Status = 2;
context.SaveChanges();
return(Ok(booking));
}
public virtual IList <Booking> GetConflictingBookings(DateTime pickUp, DateTime dropOff)
{
return(Bookings.Where(booking =>
(pickUp >= booking.PickUp && pickUp < booking.DropOff) ||
(dropOff > booking.PickUp && dropOff <= booking.DropOff) ||
(pickUp <= booking.PickUp && dropOff >= booking.DropOff))
.ToList());
}
public ActionResult DeleteConfirmed(string id)
{
Bookings bookings = db.Bookings.Find(id);
db.Bookings.Remove(bookings);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult DisApprovedBooking(int id)
{
Bookings booking = context.Bookings.FirstOrDefault(x => x.UId == id);
booking.Status = 3;
context.SaveChanges();
return(Ok(booking));
}
// Set references to this item
public override void Attach()
{
Bookings.ForEach(b => b.Rooms.Add(this));
if (Department != null)
{
Department.Rooms.Add(this);
}
}
async void GetBookings()
{
Bookings bookings = new Bookings();
LoginResponse loginUser = Application.Current.Properties["userData"] as LoginResponse;
bookings.On_ResponseRecived += Bookings_On_ResponseRecived;
await bookings.GetScheduleBookings(loginUser.id);
}
public async Task Manual_correction_should_call_notification()
{
var service = CreateBookingRecordsUpdaterService();
await service.ChangeStatus(Bookings.First(), BookingStatuses.ManualCorrectionNeeded, DateTime.UtcNow, ApiCaller, ChangeReason);
_notificationServiceMock.Verify(x => x.NotifyBookingManualCorrectionNeeded(It.IsAny <string>(), It.IsAny <string>(), It.IsAny <string>(), It.IsAny <string>()));
}
public bool IsDatabaseEmpty()
{
return
(SalesUnits.Count() == 0 &&
Ships.Count() == 0 &&
Bookings.Count() == 0
);
}
public OperationsStatus UpdateBookings(Bookings bookingsObj)
{
OperationsStatus operationsStatusObj = new OperationsStatus();
try
{
SqlParameter statusCode = null;
using (SqlConnection con = _databaseFactory.GetDBConnection())
{
using (SqlCommand cmd = new SqlCommand())
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
cmd.Connection = con;
cmd.CommandText = "[UpdateBookings]";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@ID", SqlDbType.Int).Value = bookingsObj.ID;
cmd.Parameters.Add("@BookingStatus", SqlDbType.Int).Value = bookingsObj.Status;
cmd.Parameters.Add("@Price", SqlDbType.Decimal).Value = bookingsObj.Price;
cmd.Parameters.Add("@AdditionalCharges", SqlDbType.Decimal).Value = bookingsObj.AdditionalCharges;
cmd.Parameters.Add("@TaxAmt", SqlDbType.Decimal).Value = bookingsObj.TaxAmt;
cmd.Parameters.Add("@DiscountAmt", SqlDbType.Decimal).Value = bookingsObj.DiscountAmt;
cmd.Parameters.Add("@UpdatedBy", SqlDbType.NVarChar, 250).Value = bookingsObj.logDetails.UpdatedBy;
cmd.Parameters.Add("@UpdatedDate", SqlDbType.SmallDateTime).Value = bookingsObj.logDetails.UpdatedDate;
statusCode = cmd.Parameters.Add("@Status", SqlDbType.SmallInt);
statusCode.Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
switch (statusCode.Value.ToString())
{
case "0":
operationsStatusObj.StatusCode = Int16.Parse(statusCode.Value.ToString());
operationsStatusObj.StatusMessage = constObj.UpdateFailure;
break;
case "1":
operationsStatusObj.StatusCode = Int16.Parse(statusCode.Value.ToString());
operationsStatusObj.StatusMessage = constObj.UpdateSuccess;
operationsStatusObj.ReturnValues = bookingsObj.ID;
break;
default:
break;
}
}
}
}
catch (Exception ex)
{
throw ex;
}
return(operationsStatusObj);
}
public void AddBooking(Booking booking)
{
foreach (var book in Bookings)
{
book.OverlapGuard(booking);
}
booking.BookedBy.AddBooking(booking);
Bookings.Add(booking);
}
// calculate which bookings we want to place
public void UpdateGoalBookings()
{
// pick all placed + the first non-placed - skipped
List <Booking> goalBookings = Bookings.Where(b => !SkippedBookingsIds.Contains(b.Id) && Assignments.Where(a => a.BookingId == b.Id).Count() != 0).ToList();
int nextUnplacedBookingId = GetUnplacedBookings().First(x => !SkippedBookingsIds.Contains(x.Id)).Id; //goalBookings.Last().Id + 1;
goalBookings.Add(Bookings[nextUnplacedBookingId]);
GoalBookings = goalBookings;
}
private async Task <double> CalculateRentalPrice(Bookings booking, CarCategories carCategory)
{
Prices priceOfBaceDayRental = await GetPriceOfBaceDayRental();
double daysOfRentalDifference = (booking.DateTimeForReturn - booking.DateTimeForRental).Value.TotalDays;
double daysOfRental = Math.Ceiling(daysOfRentalDifference);
return(daysOfRental * priceOfBaceDayRental.Cost.Value * carCategory.AddCostPerDay.Value);
}
public async Task Discarding_should_discard_from_supplier_and_return_the_money(BookingStatuses status)
{
var service = CreateBookingRecordsUpdaterService();
await service.ChangeStatus(Bookings.First(), status, DateTime.UtcNow, ApiCaller, ChangeReason);
_supplierOrderServiceMock.Verify(x => x.Discard(It.IsAny <string>()));
_bookingMoneyReturnServiceMock.Verify(x => x.ReturnMoney(It.IsAny <Booking>(), It.IsAny <DateTime>(), It.IsAny <ApiCaller>()));
}
public async Task Confirmation_should_call_notification_and_sending_invoice()
{
var service = CreateBookingRecordsUpdaterService();
await service.ChangeStatus(Bookings.First(), BookingStatuses.Confirmed, DateTime.UtcNow, ApiCaller, ChangeReason);
_notificationServiceMock.Verify(x => x.NotifyBookingFinalized(It.IsAny <AccommodationBookingInfo>(), It.IsAny <SlimAgentContext>()));
_documentsMailingServiceMock.Verify(x => x.SendInvoice(It.IsAny <Booking>(), It.IsAny <string>(), It.IsAny <bool>(), It.IsAny <SlimAgentContext>()));
}
//GET: PendingBooking
public ActionResult PendingBooking(int id)
{
var book = new Bookings()
{
id = id
};
return(View(book));
}
protected void BindAvailableRooms(SqlDateTime sFromDate, SqlDateTime stoDate, SqlInt32 roomType)
{
DataTable table = new Bookings().SelectAvailableRooms(sFromDate, stoDate, roomType);
this.lstSelectedRoom.DataSource = table;
this.lstSelectedRoom.DataTextField = "RoomName_EN";
this.lstSelectedRoom.DataValueField = "Room_ID";
this.lstSelectedRoom.DataBind();
}
// Branch out references
public override void Attach()
{
Bookings.ForEach(b => b.Teacher = this);
if (Department != null)
{
Department.Teachers.Add(this);
}
Classes.ForEach(c => c.Owner = this);
}
public BookingViewModel(Bookings model)
{
ID = model.ID;
FromDate = model.FromDate;
ToDate = model.ToDate;
NumberOfAdults = model.NumberOfAdults;
NumberOfChildren = model.NumberOfChildren;
Duration = model.Duration;
}
private void MaintainOldInvoices(Bookings booking)
{
var chargeInvoice = new Invoices
{
BookingId = booking.BookingId,
PassStatus = booking.PassStatus,
StripeChargeId = booking.StripeChargeId,
ChargeAmount = booking.TotalPrice,
CreatedDate = DateTime.UtcNow,
CreatedBy = PublicCustomerInfos != null ? PublicCustomerInfos.CustomerId : 1,
HotelPrice = booking.HotelPrice,
InvoiceStatus = (int)Enums.InvoiceStatus.Charge,
MerchantPrice = booking.MerchantPrice,
Quantity = booking.Quantity,
RefundAmount = 0,
StripeRefundId = string.Empty,
StripeRefundStatus = string.Empty,
TotalPrice = booking.TotalPrice
};
_bookingRepository.AddInvoices(chargeInvoice, string.Empty);
if (!string.IsNullOrEmpty(booking.StripeRefundTransactionId))
{
double refundAmount = booking.StripeRefundAmount.HasValue
? booking.StripeRefundAmount.Value
: 0;
var refundInvoice = new Invoices
{
BookingId = booking.BookingId,
PassStatus = booking.PassStatus,
StripeChargeId = string.Empty,
ChargeAmount = 0,
CreatedDate = DateTime.UtcNow,
CreatedBy = PublicCustomerInfos != null ? PublicCustomerInfos.CustomerId : 1,
HotelPrice = booking.HotelPrice,
InvoiceStatus = refundAmount >= booking.TotalPrice * 100 ? (int)Enums.InvoiceStatus.FullRefund : (int)Enums.InvoiceStatus.PartialRefund,
MerchantPrice = booking.MerchantPrice,
Quantity = booking.Quantity,
RefundAmount = (double)refundAmount / 100,
StripeRefundId = booking.StripeRefundTransactionId,
StripeRefundStatus = booking.StripeRefundStatus,
TotalPrice = booking.TotalPrice
};
_bookingRepository.AddInvoices(refundInvoice, string.Empty);
}
booking.StripeChargeId = string.Empty;
booking.StripeRefundAmount = 0;
booking.StripeRefundStatus = string.Empty;
booking.StripeRefundTransactionId = string.Empty;
booking.HasInvoice = true;
_bookingRepository.UpdateStatus(new List <Bookings> {
booking
});
}
public static Boolean AddNewBooking(Bookings bkns)
{
Boolean result = false;
BookingsDAClass.InsertBooking(bkns);
result = true;
return(result);
}
public ActionResult Edit(Bookings bookings)
{
if (ModelState.IsValid)
{
db.Entry(bookings).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(bookings));
}
public ActionResult Edit([Bind(Include = "Id,userID,workshopID,dateAndTime,workshopName")] Bookings bookings)
{
if (ModelState.IsValid)
{
db.Entry(bookings).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(bookings));
}
public ActionResult Edit([Bind(Include = "Id,BookingID,Name,Surname,IdentityNumber,Address,CellNo,Date,Clerk,Technician,JobCard,Title,Country,Province,AreaCode,DateOfBirth,Model,SerialNo,Signature,Email,DeviceName,type,datein,dateout,status")] Bookings bookings)
{
if (ModelState.IsValid)
{
db.Entry(bookings).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(bookings));
}
public ActionResult Edit([Bind(Include = "BookingIds,pickupdate,clientname,cellnum,email,ConNum,ConType,Size,specInstruct,testtext,two,Distance,final,Collection,Dropoff,priority,est,estTime,news,newss,estimate1")] Bookings bookings)
{
if (ModelState.IsValid)
{
db.Entry(bookings).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(bookings));
}
public ActionResult Edit([Bind(Include = "BookingsID,UserID,DeliveryName,DeliveryAddress,AnimalName,DateCreated")] Bookings bookings)
{
if (ModelState.IsValid)
{
db.Entry(bookings).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(bookings));
}
public ActionResult Edit([Bind(Include = "Booking_id,booking_title,start_time,end_time,participants,note,room_id,users_id")] Bookings bookings)
{
if (ModelState.IsValid)
{
db.Entry(bookings).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(bookings));
}
public ActionResult Edit([Bind(Include = "BookingIds,ColStreetNum,ColStreetName,ColArea,ColCity,ColCode,pickupdate,DelStreetNum,DelStreetName,DelArea,DelCity,DelCode,dropofdate,clientname,cellnum,email,ConNum,ConType,specInstruct,Assigned,delcon,colcon,testtext,two,finna,Collection,Dropoff")] Bookings bookings)
{
if (ModelState.IsValid)
{
db.Entry(bookings).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(bookings));
}
//books a car
/// <summary>
/// requirement number 6
/// The system should allow booking cars for interested buyers/customers
/// </summary>
/// <param name="usr"></param>
/// <param name="reservedCarModelNumber"></param>
/// <returns></returns>
public bool BookCar(Customer usr, string reservedCarModelNumber)
{
if (FindAllBookedCarsForCMN(reservedCarModelNumber) == null)
{
Booking bk = new Booking(usr, reservedCarModelNumber);
Bookings.Add(bk);
return(true);
}
return(false);
}
