public void PassengersUpdate()
{
Models.Passenger p = new Models.Passenger();
p.Id = 999999;
p.FirstName = "Svend";
p.LastName = "Andersen";
p.Luggage = true;
p.PassportId = 1234567890;
p.SeatNumber = null;
DB.DbPassenger dbPass = new DB.DbPassenger();
dbPass.Delete(999999);
Assert.IsNull(dbPass.Get(999999));
dbPass.Create(p);
Assert.AreEqual(p.PassportId, dbPass.Get(999999).PassportId);
p.PassportId = 0987654321;
dbPass.Update(p);
Assert.AreEqual(p.PassportId, dbPass.Get(999999).PassportId);
}
public int ReserveFlight(int userId, int flightId, List <ViewModel.ReseveFlightVM> model)
{
using (var tran = _db.Database.BeginTransaction())
{
Models.Reserve r = new Models.Reserve()
{
ReserveDate = DateTime.Now,
UserId = userId,
};
_db.Reserves.Add(r);
_db.SaveChanges();
try
{
foreach (var item in model)
{
//به ازای هر یک از اطلاعات مسافران اگر آیدی یا کد ملی وجود داشته باشد همان را از دیتابیس می گیریم
// در صورتی که اطلاعات در دیتابیس وجود نداشته باشد آنرا میسازیم
var passenger = _db.Passengers.FirstOrDefault(p => p.NationalityCode == item.NationalityCode || p.Id == item.Id);
if (passenger == null)
{
passenger = new Models.Passenger()
{
Age = item.Age,
NationalityCode = item.NationalityCode,
CreateDate = DateTime.Now,
FullName = item.FullName
};
_db.Passengers.Add(passenger);
_db.SaveChanges();
}
int? maxCod = _db.Tickets.Any() ? _db.Tickets.Max(p => p.Code) : 0;
Models.Ticket t = new Models.Ticket()
{
PassengerId = passenger.Id,
Code = maxCod.HasValue ? maxCod.Value + 1 : 1,
ReseveId = r.Id,
Price = 1000,
FlightId = flightId
};
_db.Tickets.Add(t);
_db.SaveChanges();
}
tran.Commit();
return(r.Id);
}
catch (System.Exception ex)
{
tran.Rollback();
throw ex;
}
}
}
public ActionResult DeleteConfirmed(long id)
{
var passenger = new Models.Passenger();
if (passenger.Seleccionar(id))
{
passenger.Eliminar();
}
return RedirectToAction("Index", new { pagina = 1 });
}
/// <summary>
/// GET /Passenger/Details/5
/// </summary>
public ActionResult Details(long id)
{
var passenger = new Models.Passenger();
if (passenger.Seleccionar(id))
{
return View(passenger);
}
else
{
return HttpNotFound();
}
}
private Entities.Passenger MapJsonPassenger(int passengerId, Models.InputJson.Json inputJson)
{
Models.Passenger jsonPassenger = inputJson.Passengers.First(x => x.Id == passengerId);
Entities.Passenger entityPassenger = new Entities.Passenger
{
Id = passengerId,
DestinationStationId = jsonPassenger.DestinationStation,
PersonId = jsonPassenger.Person,
Person = MapJsonPerson(jsonPassenger.Person, inputJson),
IsActive = jsonPassenger.IsActive
};
return(entityPassenger);
}
public async Task <ActionResult> Create(Models.Passenger p)
{
Models.Message m = new Models.Message();
try
{
string flightJson = JsonConvert.SerializeObject(p);
HttpContent stringContent = new StringContent(flightJson, Encoding.UTF8, "application/json");
HttpResponseMessage response = await _httpClient.PostAsync("api/Passengers", stringContent);
response.EnsureSuccessStatusCode();
string data = await response.Content.ReadAsStringAsync();
m.Content = data;
return(View("ShowMessage", m));
}
catch (Exception e)
{
m.Content = e.Message;
return(View("ShowMessage", m));
}
}
public void AddPassenger(Models.Passenger p)
{
passengerRepo.Create(p);
}
/// <summary>
/// GET /Passenger/pagina
/// </summary>
public ActionResult Index(int pagina)
{
var passengers = new Models.Passenger().Todos(10, pagina);
return View(passengers);
}