public async Task <Cluster> GetClusterByID(long id)
{
var clusterMapper = new ClusterMappers();
var param = new DynamicParameters();
param.Add("@ID", id);
return((await SqlMapper.QueryAsync(
_unitOfWork.Connection,
"GetClusterByID",
new[]
{
typeof(Cluster),
typeof(string),
typeof(Log),
typeof(string)
},
obj =>
{
return clusterMapper.Map(obj[0] as Cluster,
obj[1] as string,
obj[2] as Log,
obj[3] as string);
},
param,
splitOn: "ID,Nodes,LogID,AllNodes",
commandType: CommandType.StoredProcedure,
transaction: _unitOfWork.Transaction)).FirstOrDefault());
}
public async Task <IEnumerable <Cluster> > GetClusterByNode(string cNode)
{
var mapper = new ClusterMappers();
var param = new DynamicParameters();
param.Add("@Node", cNode);
return(await SqlMapper.QueryAsync(
_unitOfWork.Connection,
"GetClusterByNode",
new[]
{
typeof(Cluster),
typeof(string)
},
obj =>
{
return mapper.Map(obj[0] as Cluster, obj[1] as string);
},
param,
splitOn: "ID,Nodes",
commandType: CommandType.StoredProcedure,
transaction: _unitOfWork.Transaction));
}
public async Task <IEnumerable <Cluster> > Select()
{
var mapper = new ClusterMappers();
return((await SqlMapper.QueryAsync(
_unitOfWork.Connection,
"GetCluster",
new[]
{
typeof(Cluster),
typeof(string),
typeof(Log),
typeof(string)
},
obj =>
{
return mapper.Map(obj[0] as Cluster,
obj[1] as string,
obj[2] as Log,
obj[3] as string);
},
splitOn: "ID,Nodes,LogID,AllNodes",
commandType: CommandType.StoredProcedure,
transaction: _unitOfWork.Transaction)).Distinct());
}
public async Task <IList <Premise> > Select()
{
var mapper = new ClusterMappers();
return((await SqlMapper.QueryAsync(
_unitOfWork.Connection,
"GetPremise",
new[]
{
typeof(Premise),
typeof(Customer)
},
obj =>
{
var _premise = obj[0] as Premise;
var _customer = obj[1] as Customer;
_premise.Customer = _customer;
return _premise;
},
splitOn: "PremiseCustomerID",
commandType: CommandType.StoredProcedure,
transaction: _unitOfWork.Transaction)).Distinct().ToList());
}