public IActionResult Product(int productId)
{
var product = _reader.GetWithIncludes <Product>().FirstOrDefault(
p => p.Id.Equals(productId));
//var author = _reader.GetWithIncludes<Product>().FirstOrDefault(
// p => p.Id.Equals(productId));
//var module = _reader.Get<ListItem>()
// .Where(x => x.ProductId == productId);
var module = from li in _reader.Get <ListItem>()
where li.ProductId.Equals(productId)
select new ListItem
{
Id = li.Id,
Description = li.Description,
Name = li.Name,
Product = li.Product,
ProductId = li.ProductId,
Items = _reader.Get <Item>().Where(i => i.ListItemId.Equals(li.Id)).ToList()
};
//var module = _reader.GetWithIncludes<ListItem>().Where(
// x => x.ProductId == productId);
var model = new ProductViewModel {
Product = product, ListItems = module.ToList()
};
return(View(model));
}
public IActionResult OnGet(string userid, int courseid)
{
UserCourse = _reader.Get <UserCourse>(userid, courseid);
ViewData["Email"] = _db.GetUser(userid).Email;
ViewData["CourseTitle"] = _reader.Get <Course>(courseid).Result.Title;
return(Page());
}
public User GetUserByEmail(string email)
{
Preconditions.CheckNotNull(email, "email");
var user = dbReader.Get <User> ("Email = :Email", x => x.Email = email).SingleOrDefault();
if (user == null)
{
throw new UserNotFoundException();
}
return(user);
}
public void Handle(QueueSpy.Messages.BrokerEvent brokerEvent)
{
var connectionEstablished = (Messages.ConnectionEstablished)brokerEvent;
var vhost = dbReader.Get <QueueSpy.VHost> ("Name = :Name", x => x.Name = connectionEstablished.VHostName).FirstOrDefault();
if (vhost == null)
{
return;
}
var connectionId = dataWriter.Insert <Executor.Connection> (new Executor.Connection {
VHostId = vhost.Id, // TODO:
Name = connectionEstablished.Name,
Connected = connectionEstablished.DateTimeUTC,
IsConnected = true
});
foreach (var clientProperty in connectionEstablished.Properties)
{
dataWriter.Insert <Executor.ClientProperty> (new Executor.ClientProperty {
ConnectionId = connectionId,
Key = clientProperty.Key,
Value = clientProperty.Value
});
}
}
/// <summary>
/// 初始化数据
/// </summary>
/// <param name="reader"></param>
public virtual void Initialize(IDbReader reader)
{
foreach (var ni in reader.NameIndex)
{
//this.Set(ni.Key, reader.Get(ni.Key));
this.propertys.Add(ni.Key, reader.Get(ni.Key));
}
}
public void OnTimer(object state)
{
var brokers = dbReader.Get <Broker> ("Active = TRUE");
foreach (var broker in brokers)
{
logger.Log("Querying broker: {0}", broker.Url);
var status = new Messages.BrokerStatus {
BrokerId = broker.Id,
UserId = broker.UserId,
Url = broker.Url,
SampledAtUtc = DateTime.UtcNow
};
try {
var part = BuildBrokerUrl(broker.Url);
var client = new ManagementClient(part.HostPart, broker.Username, broker.Password, part.Port, true);
try {
var overview = client.GetOverview();
status.IsResponding = true;
status.RabbitMQVersion = overview.ManagementVersion;
var connections = client.GetConnections();
var channels = client.GetChannels();
foreach (var connection in connections)
{
var connectionMessage = new Messages.Connection {
Name = connection.Name
};
foreach (var property in connection.ClientProperties.PropertiesDictionary)
{
connectionMessage.ClientProperties.Add(new Messages.ClientProperty {
Key = property.Key,
Value = property.Value.ToString()
});
}
AddConsumersToConnection(client, channels, connectionMessage);
status.GetOrCreateVHost(connection.Vhost).Connections.Add(connectionMessage);
}
AddQueuesToBroker(client, status);
} catch (Exception e) {
logger.Log("Exception in Harvester: {0}", e);
status.IsResponding = false;
status.ErrorMessage = string.Format("{0}: {1}", e.GetType().Name, e.Message);
}
} catch (UrlParseException ex) {
logger.Log("UrlParseException in Harvester: {0}", ex);
status.IsResponding = false;
status.ErrorMessage = string.Format("{0}", ex.Message);
}
bus.Publish(status);
}
}
public void Should_be_able_to_do_a_table_join()
{
var consumers = dbReader.Get <Consumer, Connection> ("BrokerId = :BrokerId", x => x.BrokerId = 4);
foreach (var consumer in consumers)
{
System.Console.WriteLine(consumer.QueueName);
}
}
public Broker LoadBrokerModel(int brokerId)
{
var brokerModel = dbReader.GetById <Broker> (brokerId);
var connections = dbReader.Get <Connection, VHost> ("BrokerId = :BrokerId and IsConnected = TRUE", x => x.BrokerId = brokerId).ToList();
var consumers = dbReader.Get <Consumer, Connection, VHost> ("BrokerId = :BrokerId AND IsConsuming = TRUE", x => x.BrokerId = brokerId).ToList();
var queues = dbReader.Get <Queue, VHost> ("BrokerId = :BrokerId AND IsCurrent = TRUE", x => x.BrokerId = brokerId).ToList();
brokerModel.VHosts = dbReader.Get <VHost> ("BrokerId = :BrokerId", x => x.BrokerId = brokerId).ToList();
foreach (var vhost in brokerModel.VHosts)
{
vhost.Connections = connections.Where(x => x.VHostId == vhost.Id).ToList();
vhost.Queues = queues.Where(x => x.VHostId == vhost.Id).ToList();
foreach (var connection in vhost.Connections)
{
connection.Consumers = consumers.Where(x => x.ConnectionId == connection.Id).ToList();
}
}
return(brokerModel);
}
public async Task <IActionResult> OnGetAsync(int?id)
{
if (id == null)
{
return(NotFound());
}
ItemType = await _reader.Get <ItemType>((int)id);
if (ItemType == null)
{
return(NotFound());
}
return(Page());
}
public async Task <IActionResult> OnGetAsync(int?id)
{
if (id == null)
{
return(NotFound());
}
Author = await _reader.Get <Author>()
.SingleOrDefaultAsync(m => m.Id == id);
if (Author == null)
{
return(NotFound());
}
return(Page());
}
public async Task <IActionResult> OnGetAsync(int?id)
{
if (id == null)
{
return(NotFound());
}
Module = await _reader.Get <Module>((int)id);
ViewData["Courses"] = _reader.GetSelectList <Course>("Id", "Title");
if (Module == null)
{
return(NotFound());
}
return(Page());
}
public async Task <IActionResult> OnGetAsync(int?id)
{
if (id == null)
{
return(NotFound());
}
Item = await _reader.Get <Item>()
.SingleOrDefaultAsync(m => m.Id == id);
if (Item == null)
{
return(NotFound());
}
ViewData["ItemTypes"] = _reader.GetSelectList <ItemType>("Id", "Title");
ViewData["Modules"] = _reader.GetSelectList <Module>("Id", "Title");
return(Page());
}
public void Handle(QueueSpy.Messages.BrokerEvent brokerEvent)
{
Preconditions.CheckNotNull(brokerEvent, "brokerEvent");
var queueCreated = (Messages.QueueCreated)brokerEvent;
var vhost = dbReader.Get <QueueSpy.VHost> ("Name = :Name", x => x.Name = queueCreated.VHostName).FirstOrDefault();
if (vhost == null)
{
return;
}
dataWriter.Insert(new Executor.Queue {
VHostId = vhost.Id,
Name = queueCreated.Name,
Created = queueCreated.DateTimeUTC,
IsCurrent = true
});
}
public void Handle(QueueSpy.Messages.BrokerEvent brokerEvent)
{
var newConsumer = (Messages.NewConsumer)brokerEvent;
var connection = dbReader.Get <QueueSpy.Connection> ("Name = :Name and IsConnected = TRUE", x => x.Name = newConsumer.ConnectionName)
.SingleOrDefault();
if (connection == null)
{
return;
}
dataWriter.Insert <Executor.Consumer> (new Executor.Consumer {
ConnectionId = connection.Id,
Tag = newConsumer.Tag,
QueueName = newConsumer.QueueName,
Created = newConsumer.DateTimeUTC,
IsConsuming = true
});
}
public dynamic GetQueueLevels(IDbReader dbReader, int queueId)
{
return(dbReader.Get <QueueLevel> ("QueueId = :QueueId", x => x.QueueId = queueId).ToList());
}
IEnumerable <Webhook> GetWebhooks(IDbReader dbReader, int userId)
{
return(dbReader.Get <Webhook> ("UserId = :UserId", x => x.UserId = userId));
}
public IEnumerable <Broker> GetUsersBrokers(int userId)
{
return(dbReader.Get <Broker>("UserId = :UserId", x => x.UserId = userId));
}
public void OnGet()
{
ItemType = _db.Get <ItemType>().ToList();
}
