public void Put(string id, [FromBody] ReservationDetails details)
{
_commandProcessor.Process(new ChangeReservationOutboundDateCommand(id)
{
DateTime = details.OutboundDateTime
});
}
public ReservationDetails GetReservationDetail(int id)
{
ReservationDetails reservationDetail;
Reservation reservation = _context.Reservation.Find(id);
Tutor tutor = _context.Tutor.Find(reservation.tutor_id);
Student student = _context.Student.Find(reservation.student_id);
User userSt = _context.User.Find(student.user_id);
User userTt = _context.User.Find(tutor.user_id);
Subject subject = _context.Subject.Find(reservation.subject_id);
reservationDetail = new ReservationDetails();
reservationDetail.id = reservation.id;
reservationDetail.reservation_date = reservation.reservation_date.ToString();
reservationDetail.reservation_time_start = reservation.reservation_time_start.ToString();
reservationDetail.reservation_time_end = reservation.reservation_time_end.ToString();
reservationDetail.studentNames = userSt.names;
reservationDetail.studentNames = userSt.last_names;
reservationDetail.tutorNames = userTt.names;
reservationDetail.tutorLastnames = userTt.last_names;
reservationDetail.subjectname = subject.name;
reservationDetail.totalpayment = "0";
return(reservationDetail);
}
public async Task <IActionResult> PutReservationDetails(int id, ReservationDetails reservationDetails)
{
if (id != reservationDetails.Id)
{
return(BadRequest());
}
_context.Entry(reservationDetails).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!ReservationDetailsExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public ActionResult DeleteConfirmed(int id)
{
ReservationDetails reservationDetails = db.ReservationDetails.Find(id);
db.ReservationDetails.Remove(reservationDetails);
db.SaveChanges();
return(RedirectToAction("Index"));
}
//
// GET: /ReservationDetails/
public ActionResult Reserve_Room(Guid reservationID)
{
ReservationDetails reserve_room = new ReservationDetails();
reserve_room.RESERVE_ID = reservationID;
reserve_room.CUST_ID = SessionHandler.CurrentUser.UserID;
return(View(reserve_room.Reserve_Room()));
}
public void returns_expected_result_from_argument(string value, ReservationDetails expectedResult)
{
var parser = BuildParser();
var result = parser.ParseProperty(value);
Assert.AreEqual(expectedResult, result);
}
public async Task <ReservationDetails> UpdateReservationDetails(ReservationDetails reservationDetailsChanges)
{
var ReservationDetails = context.ReservationDetails.Attach(reservationDetailsChanges);
ReservationDetails.State = Microsoft.EntityFrameworkCore.EntityState.Modified;
context.SaveChanges();
return(await context.ReservationDetails.FindAsync(reservationDetailsChanges.ReservationID));
}
public void returns_expected_result_from_argument(string value, ReservationDetails expectedResult)
{
var parser = BuildParser();
var result = parser.ParseProperty(value);
Assert.AreEqual(expectedResult, result);
}
//Reservation Details
public async Task <ReservationDetails> AddReservationDetails(ReservationDetails reservationDetails)
{
context.ReservationDetails.Add(reservationDetails);
await context.SaveChangesAsync();
var ReservationDetails = await context.ReservationDetails.OrderByDescending(s => s.ReservationID).FirstOrDefaultAsync();
return(ReservationDetails);
}
public string RequestReservation(string name, int guestCount)
{
var details = new ReservationDetails
{
Name = name,
GuestCount = guestCount,
};
return _reservationService.RequestReservation(details);
}
public ActionResult Edit([Bind(Include = "Id,RoomId,ReservationId,ChildQty,AdultQty")] ReservationDetails reservationDetails)
{
if (ModelState.IsValid)
{
db.Entry(reservationDetails).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.ReservationId = new SelectList(db.Reservations, "Id", "RoomNumber", reservationDetails.ReservationId);
ViewBag.RoomId = new SelectList(db.Rooms, "Id", "RoomNumber", reservationDetails.RoomId);
return(View(reservationDetails));
}
private void CreateDetailLines(long res_id, DateTime startDate, int nights)
{
ReservationDetails line;
for (DateTime day = startDate; day < startDate.AddDays(nights); day = day.AddDays(1))
{
line = new ReservationDetails();
line.ReservationId = res_id;
line.Rate = 999;
line.Date = day;
_context.ReservationDetails.Add(line);
}
}
public async Task <ActionResult <ReservationDetails> > GetReservation(long id)
{
var reservation = await _context
.Reservations
.Include(r => r.Remarks)
.FirstOrDefaultAsync(r => r.Id == id);
if (reservation == null)
{
return(NotFound());
}
return(ReservationDetails.FromReservation(reservation));
}
// GET: ReservationDetails/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ReservationDetails reservationDetails = db.ReservationDetails.Find(id);
if (reservationDetails == null)
{
return(HttpNotFound());
}
return(View(reservationDetails));
}
public async Task <IActionResult> CreateReservationForCar(ReservationDetails reservationDetails)
{
try
{
var car = await _context.CarInfo.FirstOrDefaultAsync(x => x.CarId == reservationDetails.Car.CarId);
var user = await _context.UserDetails.FirstOrDefaultAsync(x => x.UserId == reservationDetails.User.UserId);
reservationDetails.Car = car;
reservationDetails.User = user;
_context.Entry(reservationDetails).State = reservationDetails.ReservationId == 0 ? EntityState.Added : EntityState.Modified;
if (reservationDetails.StartOffice != null || reservationDetails.EndOffice != null)
{
_context.Entry(reservationDetails.StartOffice).State = reservationDetails.StartOffice.OfficeId == 0 ? EntityState.Added : EntityState.Modified;
_context.Entry(reservationDetails.EndOffice).State = reservationDetails.EndOffice.OfficeId == 0 ? EntityState.Added : EntityState.Modified;
}
if (_context.ConfigurationPrices.Count() != 0)
{
var points = _context.ConfigurationPrices.FirstOrDefault();
if (user.Points + 1 >= points.Points)
{
user.Points -= points.Points - 1;
}
else
{
user.Points += 1;
}
}
await _context.ReservationDetails.AddAsync(reservationDetails);
await _context.SaveChangesAsync();
const string subject = "Reservation";
var body = $"<p>For:{reservationDetails.User.Email}</p><p> Uspesno ste rezervisai let</a>";
await email.SendMailAsync(reservationDetails.User.Email, subject, body);
return(await Task.FromResult <IActionResult>(Ok()));
}
catch (Exception ex)
{
return(await Task.FromResult <IActionResult>(BadRequest(ex.Message)));
}
}
public void TestReservationDetailsLimousineNotReady()
{
Limousine limoTest = new Limousine("FIAT 500", 100, new List <Arrangement>()
{
});
DateTime reservationDateStart = new DateTime(2012, 01, 23, 12, 00, 00);
DateTime reservationDateEnd = new DateTime(2012, 01, 23, 18, 00, 00);
Arrangement arrangement = new HourlyArrangement(100, HourlyArrangementType.Airport, reservationDateStart, reservationDateEnd);
ReservationDetails detailsTest = new ReservationDetails(reservationDateStart, reservationDateEnd, Location.Gent, Location.Brussel, limoTest, arrangement);
DateTime reservationDateStartNext = new DateTime(2012, 01, 23, 20, 00, 00);
DateTime reservationDateEndNext = new DateTime(2012, 01, 24, 5, 00, 00);
Action a = () => new ReservationDetails(reservationDateStartNext, reservationDateEndNext, Location.Charleroi, Location.Brussel, limoTest, arrangement);
a.ShouldThrow <ArgumentException>().Message.ShouldBe("Tussen 2 reservaties moet er minstens 6 uur verschil zijn.");
}
private static void ValidateProperties(ReservationDetails item)
{
Assert.NotNull(item);
Assert.NotNull(item.Id);
Assert.NotNull(item.Name);
Assert.NotNull(item.Type);
Assert.NotNull(item.ReservationOrderId);
Assert.NotNull(item.ReservationId);
Assert.NotNull(item.UsageDate);
Assert.NotNull(item.SkuName);
Assert.NotNull(item.InstanceId);
Assert.NotNull(item.TotalReservedQuantity);
Assert.NotNull(item.ReservedHours);
Assert.NotNull(item.UsedHours);
}
// GET: ReservationDetails/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ReservationDetails reservationDetails = db.ReservationDetails.Find(id);
if (reservationDetails == null)
{
return(HttpNotFound());
}
ViewBag.ReservationId = new SelectList(db.Reservations, "Id", "RoomNumber", reservationDetails.ReservationId);
ViewBag.RoomId = new SelectList(db.Rooms, "Id", "RoomNumber", reservationDetails.RoomId);
return(View(reservationDetails));
}
public ActionResult DeleteReservation(int id, int idReservation)
{
if (id == null || idReservation == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ReservationDetails reservationDetails = db.ReservationDetails.Find(id);
db.ReservationDetails.Remove(reservationDetails);
db.SaveChanges();
string msg = Utilities.Utilities.ErrorHandling("Detalle de Reservacion", "", "", ErrorsCode.NoError);
var a = Alert(msg, NotificationType.success);
return(RedirectToAction("GetDetails", new { idReservation = idReservation }));
}
public ReservationDetails Reserve_Room(Guid reserveID, Guid custID)
{
SqlConnection con = new SqlConnection(ConnectionString);
string command = "[dbo].[RESERVE_ROOM_details]";
SqlCommand cmd = new SqlCommand(command, con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@ReservationID", SqlDbType.UniqueIdentifier).Value = reserveID;
cmd.Parameters.Add("@CustID", SqlDbType.UniqueIdentifier).Value = custID;
SqlDataReader reader;
ReservationDetails reserveInfo = null;
try
{
reserveInfo = new ReservationDetails();
con.Open();
reader = cmd.ExecuteReader();
if (reader.Read())
{
reserveInfo.RESERVE_ID = new Guid(reader["RESERVE_ID"].ToString());
reserveInfo.CUST_ID = new Guid(reader["CUST_ID"].ToString());
reserveInfo.ARRIVAL_DATE = Convert.ToDateTime(reader["ARRIVAL_DATE"].ToString());
reserveInfo.DEPARTURE_DATE = Convert.ToDateTime(reader["DEPARTURE_DATE"].ToString());
reserveInfo.ROOM_TYPE = reader["ROOM_TYPE"].ToString();
reserveInfo.DESCRIPTION = reader["DESCRIPTION"].ToString();
reserveInfo.MAX_GUEST = Convert.ToDecimal(reader["MAX_GUEST"].ToString());
reserveInfo.ROOM_PRICE = Convert.ToDecimal(reader["ROOM_PRICE"].ToString());
reserveInfo.DISCOUNT = Convert.ToDecimal(reader["DISCOUNT"].ToString());
}
}
catch
{
reserveInfo = null;
throw;
}
return(reserveInfo);
}
public ActionResult Create([Bind(Include = "Id,RoomId,ReservationId,ChildQty,AdultQty")] ReservationDetails reservationDetails)
{
ViewBag.ReservationId = new SelectList(Utilities.Utilities.GetClients(), "Value", "Text", reservationDetails.ReservationId);
var reservation = db.Reservations.Find(reservationDetails.ReservationId);
ViewBag.RoomId = new SelectList(Utilities.Utilities.GetRooms(reservation.CheckIn, reservation.CheckOut), "Value", "Text");
if (ModelState.IsValid)
{
if (!business.ValidateOccupation(reservationDetails.RoomId, reservationDetails.AdultQty + reservationDetails.ChildQty))
{
Alert("Hay demasiadas personas para este tipo de habitacion", NotificationType.warning);
return(View(reservationDetails));
}
db.ReservationDetails.Add(reservationDetails);
db.SaveChanges();
string msg = Utilities.Utilities.ErrorHandling("Detalle de Reservacion", "", "", ErrorsCode.NoError);
Alert(msg, NotificationType.success);
return(View(reservationDetails));
}
return(View(reservationDetails));
}
public async Task <ActionResult <ReservationDetails> > PostReservationDetails(ReservationDetails reservationDetails)
{
if (!Repository.ReservationExists(reservationDetails.ReservationID))
{
return(NoContent());
}
return(await Repository.AddReservationDetails(reservationDetails));
}
public async Task <ActionResult <ReservationDetails> > PutReservationDetails(int id, ReservationDetails reservationDetails)
{
if (id != reservationDetails.ReservationID)
{
return(BadRequest());
}
if (!Repository.ReservationExists(id))
{
return(NoContent());
}
return(await Repository.UpdateReservationDetails(reservationDetails));
}
public async Task <ActionResult <ReservationDetails> > PostReservationDetails(ReservationDetails reservationDetails)
{
_context.ReservationDetails.Add(reservationDetails);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetReservationDetails", new { id = reservationDetails.Id }, reservationDetails));
}
public string RequestReservation(ReservationDetails details)
{
throw new NotImplementedException();
}
public ReservationValidate()
{
RuleFor(contract => contract.ContactID).NotNull().NotEqual(0).WithMessage("طرف حساب باید مشخص شود");
RuleFor(contract => contract.DisplayRegisterDate).NotNull().WithMessage("تاریخ رزرو باید مشخص شود");
RuleFor(contract => contract.RegisterDate).NotNull().GreaterThanOrEqualTo(DateTime.Now.AddDays(-1)).WithMessage("تاریخ رزرو باید بزرگتر یا مساوی تاریخ روز باشد.");
// RuleFor(contract => contract.RegisterDate).NotNull().GreaterThan(DateTime.Now).WithMessage("تاریخ رزرو باید بزرگتر از تاریخ روز باشد.");
RuleFor(contract => contract.ReservationDetails).NotNull().WithMessage("هیچ رسانه در رزرو ثبت نشده است");
RuleFor(contract => contract.ValiditDuration).NotNull().NotEqual(0).WithMessage("مدت اعتبار باید مشخص شود");
RuleFor(contract => contract.ReservationDetails).Must((entity, ReservationDetails) =>
{
var items = ReservationDetails.Count();
if (items > 0)
{
return(true);
}
else
{
return(false);
}
}).WithMessage("هیچ رسانه در رزرو ثبت نشده است.");
RuleFor(contract => contract.ReservationDetails).Must((entity, ReservationDetails) =>
{
var items = ReservationDetails.Count();
if (items > 0)
{
foreach (var reservationDetail in ReservationDetails)
{
if (reservationDetail.SazeID == null || reservationDetail.SazeID == 0)
{
return(false);
}
}
return(true);
}
else
{
return(false);
}
}).WithMessage("در لیست رسانه ها رسانه را وارد نمایید..");
RuleFor(contract => contract.ReservationDetails).Must((entity, reservationDetails) =>
{
var countItems = reservationDetails.Count();
if (countItems > 0)
{
foreach (var reservationDetail in reservationDetails)
{
if (reservationDetail.StartDate == null || reservationDetail.StartDate == DateTime.MinValue)
{
return(false);
}
}
return(true);
}
else
{
return(false);
}
}).WithMessage("در لیست رسانه ها تاریخ شروع رسانه را وارد نمایید..");
RuleFor(contract => contract.ReservationDetails).Must((entity, reservationDetails) =>
{
var countReservationDetailsItems = reservationDetails.Count();
if (countReservationDetailsItems > 0)
{
foreach (var reservationDetail in reservationDetails)
{
if (reservationDetail.Quantity == null || reservationDetail.Quantity == 0)
{
return(false);
}
}
return(true);
}
else
{
return(false);
}
}).WithMessage("در لیست رسانه ها مدت اجاره رسانه را وارد نمایید..");
RuleFor(contract => contract.ReservationDetails).Must((entity, reservationDetails) =>
{
var countReservationItems = reservationDetails.Count();
if (countReservationItems > 0)
{
foreach (var reservationDetail in reservationDetails)
{
if (reservationDetail.NoeEjareID == null || reservationDetail.NoeEjareID == 0)
{
return(false);
}
}
return(true);
}
else
{
return(false);
}
}).WithMessage("در لیست رسانه ها نوع اجاره رسانه را وارد نمایید..");
RuleFor(contract => contract.ReservationDetails).Must((entity, reservationDetails) =>
{
var countReservationDetails = reservationDetails.Count();
if (countReservationDetails > 0)
{
foreach (var reservationDetail in reservationDetails)
{
if (reservationDetail.StartDate.Date < DateTime.Now.Date)
{
return(false);
}
}
return(true);
}
else
{
return(true);
}
}).WithMessage("در لیست رسانه ها تاریخ شروع اکران رسانه باید بزرگتر از تاریخ روز باشد");
//RuleFor(contract => contract.ReservationDetails).Must((entity, reservationDetails) =>
//{
// var countContractSazesItems = reservationDetails.Count();
// if (countContractSazesItems > 0)
// {
// foreach (var reservationDetail in reservationDetails)
// {
// using (var uow = new UnitOfWork())
// {
// var allSazes = uow.RepositoryAsync<Contract_Saze>().Queryable().Where(x => x.SazeId == reservationDetail.SazeID &&
// ((x.TarikhShorou >= reservationDetail.StartDate && x.TarikhShorou <= reservationDetail.EndDate) ||
// (x.TarikhShorou <= reservationDetail.StartDate && x.TarikhPayan >= reservationDetail.StartDate) ||
// x.TarikhShorou <= reservationDetail.StartDate && x.TarikhPayan >= reservationDetail.StartDate) ||
// x.TarikhShorou >= reservationDetail.StartDate && x.TarikhPayan <= reservationDetail.EndDate);
// var contractStopDetails = uow.RepositoryAsync<ContractStopDetails>().Queryable().Where(x => x.SazeID == reservationDetail.SazeID &&
// ((x.StartDate <= reservationDetail.StartDate.Date && x.StartDate >= reservationDetail.EndDate) ||
// (x.StartDate >= reservationDetail.StartDate.Date && x.EndDate <= reservationDetail.StartDate.Date) ||
// x.StartDate >= reservationDetail.StartDate.Date && x.EndDate <= reservationDetail.StartDate.Date) ||
// x.StartDate <= reservationDetail.StartDate.Date && x.EndDate >= reservationDetail.EndDate);
// if (contractStopDetails.Any())
// return true;
// if (allSazes.Any())
// {
// return false;
// }
// else
// {
// var reservation_Details = uow.RepositoryAsync<Reservation_Detail>().Queryable().Where(x => x.SazeID == reservationDetail.SazeID &&
// ((x.StartDate >= reservationDetail.StartDate && x.StartDate <= reservationDetail.EndDate) ||
// (x.StartDate <= reservationDetail.StartDate && x.EndDate >= reservationDetail.StartDate) ||
// x.StartDate <= reservationDetail.StartDate && x.EndDate >= reservationDetail.StartDate) ||
// x.StartDate >= reservationDetail.StartDate && x.EndDate <= reservationDetail.EndDate);
// if (reservation_Details.Any())
// {
// return false;
// }
// else
// return true;
// }
// }
// }
// return true;
// }
// else
// return true;
//}).WithMessage("در لیست رسانه ها رسانه ای در لیست رسانه در اجاره و یا رزرو شخص دیگری می باشد");
}
public string RequestReservation(ReservationDetails details)
{
throw new NotImplementedException();
}
private void btn1_Click(object sender, RoutedEventArgs e)
{
bool u1, u2, u3, u4 = false;
int parsedValue;
if (!int.TryParse(quan.Text, out parsedValue) || string.IsNullOrWhiteSpace(quan.Text.Trim('0')))
{
lbel3.Visibility = System.Windows.Visibility.Visible;
u1 = false;
}
else
{
u1 = true;
}
if (date1.SelectedDate == null)
{
labeld1.Visibility = System.Windows.Visibility.Visible;
u2 = false;
}
else
{
u2 = true;
}
if (date2.SelectedDate == null)
{
labeld2.Visibility = System.Windows.Visibility.Visible;
u3 = false;
}
else
{
u3 = true;
}
if (list1.SelectedItems.Count == 0)
{
labeld3.Visibility = System.Windows.Visibility.Visible;
u4 = false;
}
else
{
u4 = true;
}
if (u1 == true && u2 == true && u3 == true && u4 == true)
{
List <string> usr = obj3.ReadNames(App.Current.Properties[0].ToString()).ToList();
ReservationDetails reservationinfo = new ReservationDetails();
reservationinfo.Title = ((ListBoxItem)list1.SelectedValue).Content.ToString();
reservationinfo.UserName = App.Current.Properties[0].ToString();
reservationinfo.Firstname = usr[0].ToString();
reservationinfo.Lastname = usr[1].ToString();
DateTime?a = date1.SelectedDate;
reservationinfo.Startingdate = a.Value.Year + "-" + a.Value.Month + "-" + a.Value.Day;
DateTime?b = date2.SelectedDate;
reservationinfo.Endingdate = b.Value.Year + "-" + b.Value.Month + "-" + b.Value.Day;
DateTime?c = DateTime.Now;
reservationinfo.Submitdate = c.Value.Year + "-" + c.Value.Month + "-" + c.Value.Day + " " + c.Value.Hour + ":" + c.Value.Minute + ":" + c.Value.Second;
reservationinfo.Quantity = Convert.ToInt32(quan.Text);
reservationinfo.Accepted = false;
reservationinfo.Aborted = false;
obj.Reservation(reservationinfo);
wel.Visibility = System.Windows.Visibility.Hidden;
label1.Visibility = System.Windows.Visibility.Hidden;
label2.Visibility = System.Windows.Visibility.Hidden;
date1.Visibility = System.Windows.Visibility.Hidden;
date2.Visibility = System.Windows.Visibility.Hidden;
btn1.Visibility = System.Windows.Visibility.Hidden;
list1.Visibility = System.Windows.Visibility.Hidden;
lbl5.Visibility = System.Windows.Visibility.Visible;
quan.Visibility = System.Windows.Visibility.Hidden;
quan2.Visibility = System.Windows.Visibility.Hidden;
}
}
