public async Task <IActionResult> PutReserv([FromRoute] int id, [FromBody] Reserv reserv)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != reserv.Id)
{
return(BadRequest());
}
_context.Entry(reserv).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!ReservExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
private Reserv GetReservations()
{
var client = new Client()
{
Name = "AAA", PhoneNumber = "777", SurName = "BBB", Quantity = 10
};
var reservation = new Reserv()
{
FromReservationDate = new DateTime(2020, 06, 15, 13, 2, 13),
ToReservationDate = new DateTime(2020, 06, 12, 13, 45, 13),
Client = client
};
var client2 = new Client()
{
Name = "ABC", PhoneNumber = "777", SurName = "BBB", Quantity = 10
};
var reservation2 = new Reserv()
{
FromReservationDate = new DateTime(2020, 06, 15, 13, 2, 13),
ToReservationDate = new DateTime(2020, 06, 12, 13, 45, 13),
Client = client
};
ReservationRepository repository = new ReservationRepository();
repository.Create(reservation);
repository.Create(reservation2);
return(reservation);
}
public Reserv Reserve(int UserID, int ProductID, int count)
{
User user = GetUser(UserID);
Product prod = GetProduct(ProductID);
if (!prod.TryReserv(count))
{
return(null);
}
Reserv r = new Reserv
{
ProductID = prod.id,
UserID = user.id,
Count = count
};
prod.Reserveds.Add(r.id);
db.Reserved.Add(r);
user.ReservedsID.Add(r.id);
db.ChangeTracker.DetectChanges();
db.SaveChanges();
return(r);
}
public IActionResult Reservation([FromQuery] ClientReservationViewModel clientReservationViewModel)
{
Reserv reserv = new Reserv();
reserv.Client = new Client();
reserv.FromReservationDate = clientReservationViewModel.FromReservationDate;
reserv.ToReservationDate = clientReservationViewModel.ToReservationDate;
reserv.Client.Name = clientReservationViewModel.Name;
reserv.Client.SurName = clientReservationViewModel.Surname;
reserv.Client.Quantity = clientReservationViewModel.Quantity;
reserv.Client.PhoneNumber = clientReservationViewModel.PhoneNumber;
if (clientReservationViewModel.Surname == null || clientReservationViewModel.Name == null)
{
return(Ok(-1));
}
else if (clientReservationViewModel.PhoneNumber == null || clientReservationViewModel.PhoneNumber.Length != 12)
{
return(Ok(-2));
}
else if (clientReservationViewModel.Quantity > 15)
{
return(Ok(-3));
}
if (_reservation.CheckIfTimeIsAvailable(clientReservationViewModel.FromReservationDate,
clientReservationViewModel.ToReservationDate))
{
return(Ok(_reservation.Create(reserv)));
}
return(Ok(0));
}
public ActionResult DeleteConfirmed(int id)
{
Reserv reserv = db.ReservCollection.Find(id);
db.ReservCollection.Remove(reserv);
db.SaveChanges();
return(RedirectToAction("Index"));
}
async Task encloseHandleAsync()
{
for (int j = 0; j <= 1000; j++)
{
Reserv r = await shop.ReserveAsync(1, 1, rnd.Next(1, 4));
reserveds += r.Count;
}
}
public async Task <IActionResult> PostReserv([FromBody] Reserv reserv)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
_context.Reservs.Add(reserv);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetReserv", new { id = reserv.Id }, reserv));
}
public ActionResult Create([Bind(Include = "id,Customer_Id,FlightsSchedule_Id,Weight,Pcs,ULD,Description,UserName,Canceled,RequestedDate,CreateDate")] Reserv reserv)
{
if (ModelState.IsValid)
{
db.ReservCollection.Add(reserv);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Customer_Id = new SelectList(db.Customers, "Id", "Name", reserv.Customer_Id);
ViewBag.FlightsSchedule_Id = new SelectList(db.RoutsCollection, "id", "FlightNumber", reserv.FlightsSchedule_Id);
return(View(reserv));
}
public void Update(int id)
{
Reserv reserv = Database.ReserveManager.Get(id);
if (reserv != null)
{
reserv.Date = DateTime.UtcNow;
reserv.Resolution = true;
reserv.FinishDate = DateTime.UtcNow.AddMonths(3);
Database.ReserveManager.Update(reserv);
Database.SaveAsync();
}
}
public void Create(ReservDTO reservDto)
{
Reserv reserv = new Reserv
{
Date = reservDto.Date,
UserName = reservDto.UserName,
BookName = reservDto.BookName,
FinishDate = reservDto.FinishDate
};
Database.ReserveManager.Create(reserv);
Database.SaveAsync();
}
public void Create_ReservationObject_IdReservation()
{
var mock = new Mock <IReservationRepository>();
var reserv = new Reserv()
{
Id = 2
};
mock.Setup(repo => repo.Create(It.IsAny <Reserv>())).Returns(22);
var service = new ReservationService(mock.Object);
Assert.AreEqual(reserv.Id, service.Create(reserv));
}
public void GetReservation_Id_Reservation()
{
var mock = new Mock <IReservationRepository>();
var reserv = new Reserv()
{
FromReservationDate = DateTime.Today
};
mock.Setup(repo => repo.GetReserv(It.IsAny <int>())).Returns(reserv);
var service = new ReservationService(mock.Object);
Assert.IsTrue(reserv == service.GetReserv(22));
}
public ActionResult Edit([Bind(Include = "id,Customer_Id,FlightsSchedule_Id,Weight,Pcs,ULD,Description,UserName,Canceled,RequestedDate,CreateDate")] Reserv reserv)
{
if (ModelState.IsValid)
{
db.Entry(reserv).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Customer_Id = new SelectList(db.Customers, "Id", "Name", reserv.Customer_Id);
ViewBag.FlightsSchedule_Id = new SelectList(db.RoutsCollection.Join(db.ScheduleCollection, it => it.Id, it2 => it2.Routs_Id, (it1, it2) => new { Title = it1.FlightNumber + " " + it2.FltDate, Id = it2.id }), "Id", "Title", reserv.FlightsSchedule_Id);
return(View(reserv));
}
// GET: AdminPanel/Reservs/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Reserv reserv = db.ReservCollection.Find(id);
if (reserv == null)
{
return(HttpNotFound());
}
return(View(reserv));
}
public bool Delete(int id)
{
Reserv reserv = _dbContext.Reservs.Find(id);
Client client = _dbContext.Clients.Find(id);
if (reserv != null)
{
_dbContext.Reservs.Remove(reserv);
_dbContext.Clients.Remove(client);
_dbContext.SaveChanges();
return(true);
}
return(false);
}
private Reserv GetReservation()
{
var client = new Client()
{
Name = "111", PhoneNumber = "1111", SurName = "111", Quantity = 111
};
var reservation = new Reserv()
{
FromReservationDate = DateTime.Now, ToReservationDate = DateTime.Now, Client = client
};
ReservationRepository repository = new ReservationRepository();
repository.Create(reservation);
return(reservation);
}
public bool Delete(Client client)
{
Client tmp = _context.Clients.FirstOrDefault(x => x.Name == client.Name & x.SurName == client.SurName
& x.PhoneNumber == client.PhoneNumber & x.Id == client.Id);
if (tmp != null)
{
Reserv reserv = _context.Reservs.Find(tmp.Id);
_context.Clients.Remove(tmp);
_context.Reservs.Remove(reserv);
_context.SaveChanges();
return(true);
}
return(false);
}
// GET: AdminPanel/Reservs/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Reserv reserv = db.ReservCollection.Find(id);
if (reserv == null)
{
return(HttpNotFound());
}
ViewBag.Customer_Id = new SelectList(db.Customers, "Id", "Name", reserv.Customer_Id);
ViewBag.FlightsSchedule_Id = new SelectList(db.RoutsCollection.Join(db.ScheduleCollection, it => it.Id, it2 => it2.Routs_Id, (it1, it2) => new { Title = it1.FlightNumber + " " + it2.FltDate, Id = it2.id }), "Id", "Title", reserv.FlightsSchedule_Id);
return(View(reserv));
}
public List <Reserv> GetReserveList()
{
string query = "SELECT * FROM ReservesView";
command = new SqlCommand(query, connection);
connection.Open();
reader = command.ExecuteReader();
List <Reserv> reserveList = new List <Reserv>();
while (reader.Read())
{
Reserv reserv = new Reserv();
reserv.Sailor = reader["Sailor_Name"].ToString();
reserv.Boat = reader["Boat_Name"].ToString();
reserv.Date = reader["Date"].ToString();
reserveList.Add(reserv);
}
connection.Close();
return(reserveList);
}
public void GetAllResrvs_Date_Reservs()
{
var mock = new Mock <IReservationRepository>();
var reesrv = new Reserv()
{
FromReservationDate = DateTime.Now
};
var reesrv2 = new Reserv()
{
FromReservationDate = DateTime.Now
};
var list = new List <Reserv>()
{
reesrv, reesrv2
};
mock.Setup(x => x.GetAllReservations()).Returns(list);
var service = new ReservationService(mock.Object);
Assert.IsTrue(list.Contains(reesrv) == service.CheckIfTimeIsAvailable(DateTime.Now, DateTime.Today));
}
public int Create(Reserv reserv)
{
_dbContext.Reservs.Add(reserv);
_dbContext.SaveChanges();
return(reserv.Id);
}
public void Update(Reserv reserv)
{
_dbContext.Reservs.Update(reserv);
_dbContext.SaveChanges();
}
public int Create(Reserv reserv)
{
_reservation.Create(reserv);
return(reserv.Id);
}
