public void Add(Network network, User user)
{
var networkModel = NetworkModel.FromRepositoryType(network);
var userModel = UserModel.FromRepositoryType(user);
var sql = @"
INSERT
INTO NetworkGuestModels
(
Network_Id,
User_Id
)
VALUES
(
@Network_Id,
@User_Id
)
";
var parameters = new
{
Network_Id = networkModel.Id,
User_Id = userModel.Id,
};
_connection.Execute(sql, parameters);
}
public void Remove(Network network)
{
var model = NetworkModel.FromRepositoryType(network);
var sql = @"
DELETE
FROM NetworkModels
WHERE Id = @Id
";
var parameters = new
{
Id = model.Id,
};
_connection.Execute(sql, parameters);
}
public void Remove(Network network, User user)
{
var networkModel = NetworkModel.FromRepositoryType(network);
var userModel = UserModel.FromRepositoryType(user);
var sql = @"
DELETE
FROM NetworkGuestModels
WHERE Network_Id = @Network_Id
AND User_Id = @User_Id
";
var parameters = new
{
Network_Id = networkModel.Id,
User_Id = userModel.Id,
};
_connection.Execute(sql, parameters);
}
public User[] Get(Network network, IRepositoryModelCache cache = null)
{
var networkModel = NetworkModel.FromRepositoryType(network);
var sql = @"
SELECT User_Id
FROM NetworkGuestModels
WHERE Network_Id = @Network_Id
";
var parameters = new
{
Network_Id = networkModel.Id,
};
var userIds = _connection.Query <int>(sql, parameters).ToArray();
var result = userIds
.Select((id) => _userRepository.Get(id, cache))
.ToArray();
return(result);
}
public bool Check(Network network, User user)
{
var networkModel = NetworkModel.FromRepositoryType(network);
var userModel = UserModel.FromRepositoryType(user);
var sql = @"
SELECT COUNT(*)
FROM NetworkGuestModels
WHERE Network_Id = @Network_Id
AND User_Id = @User_Id
";
var parameters = new
{
Network_Id = networkModel.Id,
User_Id = userModel.Id,
};
var count = _connection.QuerySingle <int>(sql, parameters);
return(count > 0);
}
public Device[] Get(Network network, IRepositoryModelCache cache = null)
{
var networkModel = NetworkModel.FromRepositoryType(network);
var sql = @"
SELECT *
FROM DeviceModels
WHERE Network_Id = @Network_Id
";
var parameters = new
{
Network_Id = networkModel.Id,
};
var models = _connection.Query <DeviceModel>(sql, parameters).ToArray();
var result = models
.Select(x => x.ToRepositoryType(cache, _networkRepository, _scriptRepository, _taskRepository))
.ToArray();
return(result);
}
public void Update(Network network)
{
var model = NetworkModel.FromRepositoryType(network);
var sql = @"
UPDATE NetworkModels
SET
Address = @Address,
AttatchedComputer_Id = @AttatchedComputer_Id,
LastPing = @LastPing,
Name = @Name
WHERE Id = @Id
";
var parameters = new
{
Address = model.Address,
AttatchedComputer_Id = model.AttatchedComputer_Id,
Id = model.Id,
LastPing = model.LastPing,
Name = model.Name,
};
_connection.Execute(sql, parameters);
}
public void Add(Network network)
{
var model = NetworkModel.FromRepositoryType(network);
var sql = @"
INSERT INTO NetworkModels
(
Address,
AttatchedComputer_Id,
LastPing,
Name,
Owner_Id
)
VALUES
(
@Address,
@AttatchedComputer_Id,
@LastPing,
@Name,
@Owner_Id
)
SELECT CAST(IDENT_CURRENT('NetworkModels') as int)
";
var parameters = new
{
Address = model.Address,
AttatchedComputer_Id = model.AttatchedComputer_Id,
LastPing = model.LastPing,
Name = model.Name,
Owner_Id = model.Owner_Id,
};
var id = _connection.QuerySingle <int>(sql, parameters);
network.SetId(id);
}
