public static void editServiceEvent(ServiceEvent serviceEvent)
{
BasicVehicleDbContext db = new BasicVehicleDbContext();
db.Entry(serviceEvent).State = EntityState.Modified;
db.SaveChanges();
}
public static void editVehicle(Vehicle vehicle)
{
BasicVehicleDbContext db = new BasicVehicleDbContext();
db.Entry(vehicle).State = EntityState.Modified;
db.SaveChanges();
}
public static void createServiceEvent(ServiceEvent serviceEvent)
{
BasicVehicleDbContext db = new BasicVehicleDbContext();
db.Entry(serviceEvent).State = EntityState.Added;
db.ServiceEvents.Add(serviceEvent);
db.SaveChanges();
}
public static void deleteServiceEvent(ServiceEvent serviceEvent)
{
BasicVehicleDbContext db = new BasicVehicleDbContext();
db.Entry(serviceEvent).State = EntityState.Deleted;
db.ServiceEvents.Remove(serviceEvent);
db.SaveChanges();
}
public static void createVehicle(Vehicle vehicle)
{
BasicVehicleDbContext db = new BasicVehicleDbContext();
db.Entry(vehicle).State = EntityState.Added;
db.Vehicles.Add(vehicle);
db.SaveChanges();
}
public static void deleteVehicle(Vehicle vehicle)
{
BasicVehicleDbContext db = new BasicVehicleDbContext();
db.Entry(vehicle).State = EntityState.Deleted;
db.Vehicles.Remove(vehicle);
db.SaveChanges();
}
public static VehicleServiceEvent getVehicleAndServiceEvents(int?id)
{
BasicVehicleDbContext db = new BasicVehicleDbContext();
VehicleServiceEvent vehServiceEvents = new VehicleServiceEvent();
vehServiceEvents.vehicle = getVehicle(id);
var serviceEvents = db.ServiceEvents.Where(s => s.Vin == vehServiceEvents.vehicle.Vin);
vehServiceEvents.serviceEvents = serviceEvents.ToList();
return(vehServiceEvents);
}
public static ServiceEvent getServiceEvent(int?id)
{
BasicVehicleDbContext db = new BasicVehicleDbContext();
return(db.ServiceEvents.Find(id));
}
public static List <ServiceEvent> getServiceEvents()
{
BasicVehicleDbContext db = new BasicVehicleDbContext();
return(db.ServiceEvents.ToList());
}
public static Vehicle getVehicle(int?id)
{
BasicVehicleDbContext db = new BasicVehicleDbContext();
return(db.Vehicles.Find(id));
}
public static List <Vehicle> getVehicles()
{
BasicVehicleDbContext db = new BasicVehicleDbContext();
return(db.Vehicles.ToList());
}
public IEnumerable <Vehicle> GetData(out int totalRecords, string globalSearch, string filterFirstName, string filterLastName, bool?filterActive, int?limitOffset, int?limitRowCount, string orderBy, bool desc)
{
using (var db = new BasicVehicleDbContext())
{
var query = db.Vehicles.AsQueryable();
if (!String.IsNullOrWhiteSpace(globalSearch))
{
query = query.Where(p => (p.Make + " " + p.Model + " " + p.Vin + " " + p.Year + " " + p.CurrentMileage).Contains(globalSearch));
}
totalRecords = query.Count();
if (!String.IsNullOrWhiteSpace(orderBy))
{
switch (orderBy.ToLower())
{
case "make":
if (!desc)
{
query = query.OrderBy(p => p.Make);
}
else
{
query = query.OrderByDescending(p => p.Make);
}
break;
case "model":
if (!desc)
{
query = query.OrderBy(p => p.Model);
}
else
{
query = query.OrderByDescending(p => p.Model);
}
break;
case "year":
if (!desc)
{
query = query.OrderBy(p => p.Year);
}
else
{
query = query.OrderByDescending(p => p.Year);
}
break;
case "vin":
if (!desc)
{
query = query.OrderBy(p => p.Vin);
}
else
{
query = query.OrderByDescending(p => p.Vin);
}
break;
case "currentmileage":
if (!desc)
{
query = query.OrderBy(p => p.CurrentMileage);
}
else
{
query = query.OrderByDescending(p => p.CurrentMileage);
}
break;
case "id":
if (!desc)
{
query = query.OrderBy(p => p.Id);
}
else
{
query = query.OrderByDescending(p => p.Id);
}
break;
}
}
if (limitOffset.HasValue)
{
query = query.Skip(limitOffset.Value).Take(limitRowCount.Value);
}
return(query.ToList());
}
}