public List <Object> Load()
{
List <Travel> lstTravels = new List <Travel>();
using (var db = new TravelAgenciesContext())
{
foreach (var row in db.Travel)
{
lstTravels.Add(new Travel
{
Id = row.Id,
AgencyID = row.AgencyID,
Titular = row.Titular,
StartDate = row.StartDate,
EndDate = row.EndDate,
Destination = row.Destination,
Hotel = row.Hotel,
TotalCost = row.TotalCost,
Description = row.Description,
Notes = row.Notes
});
}
}
return(lstTravels.ToList <Object>());
}
public Object GetModelById(int Id)
{
Travel travel = null;
using (var db = new TravelAgenciesContext())
{
travel = db.Travel.Find(Id);
}
return(travel);
}
public int Create(Object travelModel)
{
try
{
using (var db = new TravelAgenciesContext())
{
Travel travel = this.ConvertTravelModelToEntityTravel(travelModel);
db.Travel.Add(travel);
db.SaveChanges();
return(1);
}
}
catch (Exception)
{
throw;
}
}
public int Edit(Object travelModel, int Id)
{
try
{
using (var db = new TravelAgenciesContext())
{
// Get current Travel by Id
Travel currentTravel = GetModelById(Id) as Travel;
// Convert the New MVC Travel to Entity Travel
Travel newTravel = this.ConvertTravelModelToEntityTravel(travelModel);
db.Travel.Attach(newTravel);
db.Entry(newTravel).State = EntityState.Modified;
db.SaveChanges();
return(1);
}
}
catch (Exception)
{
throw;
}
}
