public Vehicle GetVehicleDataByID(int ID)
{
using (VehicleDataContext context = new VehicleDataContext())
{
return(context.Vehicle.FirstOrDefault(vh => vh.ID == ID));
}
}
public IActionResult Vehicle(long Id)
{
var db = new VehicleDataContext();
var vehicle = db.Vehicles.SingleOrDefault(x => x.Id == Id);
return(View(vehicle));
}
public List <Vehicle> GetVehicleData()
{
using (VehicleDataContext context = new VehicleDataContext())
{
return(context.Vehicle.ToList());
}
}
public bool InsertVehicle(Vehicle vhc)
{
using (VehicleDataContext context = new VehicleDataContext())
{
try
{
context.Vehicle.Add(vhc);
context.SaveChanges();
return(true);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
return(false);
}
}
}
public bool UpdateVehicle(Vehicle vhc)
{
using (VehicleDataContext context = new VehicleDataContext())
{
try
{
Vehicle oldVhc = context.Vehicle.First(vh => vh.ID == vhc.ID);
oldVhc.MFDate = vhc.MFDate;
oldVhc.Name = vhc.Name;
oldVhc.Quantity = vhc.Quantity;
context.SaveChanges();
return(true);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
return(false);
}
}
}
static void Main(string[] args)
{
var factory = new ConnectionFactory()
{
HostName = "localhost"
};
using (var connection = factory.CreateConnection())
using (var channel = connection.CreateModel())
{
channel.QueueDeclare(queue: "Vehicle",
durable: false,
exclusive: false,
autoDelete: false,
arguments: null);
var consumer = new EventingBasicConsumer(channel);
consumer.Received += (model, ea) =>
{
var body = ea.Body;
var data = Encoding.UTF8.GetString(body);
VehicleBackUp vehicleBackUp = JsonConvert.DeserializeObject <VehicleBackUp>(data);
Console.WriteLine(" [x] Received {0}", vehicleBackUp.Name + " : " + vehicleBackUp.ID);
//Insert, Update Or Delete
switch ((OperationTypes)vehicleBackUp.OperationType)
{
case OperationTypes.Insert:
{
using (VehicleDataContext context = new VehicleDataContext())
{
try
{
context.VehicleBackUp.Add(vehicleBackUp);
context.SaveChanges();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
break;
}
case OperationTypes.Update:
{
using (VehicleDataContext context = new VehicleDataContext())
{
try
{
VehicleBackUp oldVhcBackUp = context.VehicleBackUp.First(vh => vh.ID == vehicleBackUp.ID);
oldVhcBackUp.MFDate = vehicleBackUp.MFDate;
oldVhcBackUp.Name = vehicleBackUp.Name;
oldVhcBackUp.Quantity = vehicleBackUp.Quantity;
context.SaveChanges();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
break;
}
case OperationTypes.Delete:
{
break;
}
}
//-------------------------
};
channel.BasicConsume(queue: "Vehicle",
autoAck: true,
consumer: consumer);
Console.WriteLine(" Press [enter] to exit.");
Console.ReadLine();
}
}
public Repository(VehicleDataContext context)
{
Db = context;
DbSet = Db.Set <TEntity>();
}
public VehicleController(VehicleDataContext dataContext)
{
_dataContext = dataContext;
}
public VehicleDatasController(VehicleDataContext context)
{
_context = context;
}
public VehicleRepository(VehicleDataContext context)
: base(context)
{
}
public CustomerRepository(VehicleDataContext context)
: base(context)
{
}
public UnitOfWork(VehicleDataContext context)
{
_context = context;
}
