public void AddClient(DT.Client client)
{
string country = string.Empty;
OperationContext opContext = OperationContext.Current;
if (opContext != null)
{
MessageProperties properties = opContext.IncomingMessageProperties;
RemoteEndpointMessageProperty endpoint = properties[RemoteEndpointMessageProperty.Name] as RemoteEndpointMessageProperty;
string ipAdr = endpoint.Address;
country = GeoIPLookupService.Instance.GetCountryName(ipAdr);
}
using (DA.AccessServiceDataContext context = new DA.AccessServiceDataContext()) {
DA.Client entity = Convert.ToEntity(client);
if (country != string.Empty)
{
var query = from c in context.GetTable <DA.Country>()
where c.Name == country
select c;
if (query.Count() > 0)
{
entity.CountryId = query.First().Id;
}
}
if (entity.OperatingSystem != null)
{
string osversion = entity.OperatingSystem.Name;
var query = from os in context.GetTable <DA.OperatingSystem>()
where os.Name == osversion
select os;
if (query.Count() > 0)
{
entity.OperatingSystem = query.First();
}
}
if (entity.ClientType != null)
{
string cType = entity.ClientType.Name;
var query = from t in context.GetTable <DA.ClientType>()
where t.Name == cType
select t;
if (query.Count() > 0)
{
entity.ClientType = query.First();
}
}
context.Resources.InsertOnSubmit(entity);
context.SubmitChanges();
}
}
public IEnumerable<DT.Client> GetAllClients() {
using (DA.AccessServiceDataContext context = new DA.AccessServiceDataContext()) {
var query = from c in context.GetTable<DA.Resource>().OfType<DA.Client>()
select Convert.ToDto(c);
return query.ToList();
}
}
public IEnumerable<DT.Client> GetClients(IEnumerable<Guid> ids) {
using (DA.AccessServiceDataContext context = new DA.AccessServiceDataContext()) {
var query = from c in context.GetTable<DA.Resource>().OfType<DA.Client>()
where ids.Contains(c.Id)
select Convert.ToDto(c);
return query.ToList();
}
}
public IEnumerable <DT.Client> GetAllClients()
{
using (DA.AccessServiceDataContext context = new DA.AccessServiceDataContext()) {
var query = from c in context.GetTable <DA.Resource>().OfType <DA.Client>()
select Convert.ToDto(c);
return(query.ToList());
}
}
public IEnumerable <DT.ClientGroupMapping> GetClientGroupMapping()
{
using (DA.AccessServiceDataContext context = new DA.AccessServiceDataContext()) {
var query = from c in context.GetTable <DA.ResourceResourceGroup>()
select Convert.ToDto(c);
return(query.ToList());
}
}
public IEnumerable <DT.Client> GetClients(IEnumerable <Guid> ids)
{
using (DA.AccessServiceDataContext context = new DA.AccessServiceDataContext()) {
var query = from c in context.GetTable <DA.Resource>().OfType <DA.Client>()
where ids.Contains(c.Id)
select Convert.ToDto(c);
return(query.ToList());
}
}
public DT.Client GetClient(Guid id) {
using (DA.AccessServiceDataContext context = new DA.AccessServiceDataContext()) {
var query = from c in context.GetTable<DA.Resource>().OfType<DA.Client>()
where c.Id == id
select c;
if (query.Count() > 0) {
return Convert.ToDto(query.FirstOrDefault());
} else {
return null;
}
}
}
public DT.Client GetClient(Guid id)
{
using (DA.AccessServiceDataContext context = new DA.AccessServiceDataContext()) {
var query = from c in context.GetTable <DA.Resource>().OfType <DA.Client>()
where c.Id == id
select c;
if (query.Count() > 0)
{
return(Convert.ToDto(query.FirstOrDefault()));
}
else
{
return(null);
}
}
}
public void DeleteClientGroup(DT.ClientGroup clientGroup)
{
RoleVerifier.AuthenticateForAllRoles(AccessServiceRoles.Administrator);
using (DA.AccessServiceDataContext context = new DA.AccessServiceDataContext()) {
//load clientGroup because we could get a detached object
var query = from c in context.GetTable <DA.Resource>().OfType <DA.ClientGroup>()
where c.Id == clientGroup.Id
select c;
if (query.Count() > 0)
{
context.Resources.DeleteOnSubmit(query.First());
context.SubmitChanges();
}
}
}
public void UpdateClient(DT.Client client)
{
string country = string.Empty;
OperationContext opContext = OperationContext.Current;
if (opContext != null)
{
MessageProperties properties = opContext.IncomingMessageProperties;
RemoteEndpointMessageProperty endpoint = properties[RemoteEndpointMessageProperty.Name] as RemoteEndpointMessageProperty;
string ipAdr = endpoint.Address;
country = GeoIPLookupService.Instance.GetCountryName(ipAdr);
}
using (DA.AccessServiceDataContext context = new DA.AccessServiceDataContext()) {
var query = from c in context.Resources.OfType <DA.Client>()
where c.Id == client.Id
select c;
if (query.Count() > 0)
{
var entity = query.First();
if (country != string.Empty)
{
var countryQuery = from c in context.GetTable <DA.Country>()
where c.Name == country
select c;
if (countryQuery.Count() > 0)
{
entity.CountryId = countryQuery.First().Id;
}
}
entity.Name = client.Name;
entity.Description = client.Description;
entity.HeuristicLabVersion = client.HeuristicLabVersion;
entity.Timestamp = DateTime.Now;
context.SubmitChanges();
}
}
}
public void DeleteClient(DT.Client client)
{
RoleVerifier.AuthenticateForAllRoles(AccessServiceRoles.Administrator);
using (DA.AccessServiceDataContext context = new DA.AccessServiceDataContext()) {
//load client because we could get a detached object
var query = from c in context.GetTable <DA.Resource>().OfType <DA.Client>()
where c.Id == client.Id
select c;
if (query.Count() > 0)
{
//delete affiliation first
var queryMapping = context.ResourceResourceGroups.Where(x => x.ResourceId == client.Id);
if (queryMapping.Count() > 0)
{
context.ResourceResourceGroups.DeleteAllOnSubmit(queryMapping);
}
context.Resources.DeleteOnSubmit(query.First());
context.SubmitChanges();
}
}
}
public void AddClient(DT.Client client) {
string country = string.Empty;
OperationContext opContext = OperationContext.Current;
if (opContext != null) {
MessageProperties properties = opContext.IncomingMessageProperties;
RemoteEndpointMessageProperty endpoint = properties[RemoteEndpointMessageProperty.Name] as RemoteEndpointMessageProperty;
string ipAdr = endpoint.Address;
country = GeoIPLookupService.Instance.GetCountryName(ipAdr);
}
using (DA.AccessServiceDataContext context = new DA.AccessServiceDataContext()) {
DA.Client entity = Convert.ToEntity(client);
if (country != string.Empty) {
var query = from c in context.GetTable<DA.Country>()
where c.Name == country
select c;
if (query.Count() > 0) {
entity.CountryId = query.First().Id;
}
}
if (entity.OperatingSystem != null) {
string osversion = entity.OperatingSystem.Name;
var query = from os in context.GetTable<DA.OperatingSystem>()
where os.Name == osversion
select os;
if (query.Count() > 0) {
entity.OperatingSystem = query.First();
}
}
if (entity.ClientType != null) {
string cType = entity.ClientType.Name;
var query = from t in context.GetTable<DA.ClientType>()
where t.Name == cType
select t;
if (query.Count() > 0) {
entity.ClientType = query.First();
}
}
context.Resources.InsertOnSubmit(entity);
context.SubmitChanges();
}
}
public IEnumerable<DT.ClientGroupMapping> GetClientGroupMapping() {
using (DA.AccessServiceDataContext context = new DA.AccessServiceDataContext()) {
var query = from c in context.GetTable<DA.ResourceResourceGroup>()
select Convert.ToDto(c);
return query.ToList();
}
}
public void DeleteClientGroup(DT.ClientGroup clientGroup) {
RoleVerifier.AuthenticateForAllRoles(AccessServiceRoles.Administrator);
using (DA.AccessServiceDataContext context = new DA.AccessServiceDataContext()) {
//load clientGroup because we could get a detached object
var query = from c in context.GetTable<DA.Resource>().OfType<DA.ClientGroup>()
where c.Id == clientGroup.Id
select c;
if (query.Count() > 0) {
context.Resources.DeleteOnSubmit(query.First());
context.SubmitChanges();
}
}
}
public void DeleteClient(DT.Client client) {
RoleVerifier.AuthenticateForAllRoles(AccessServiceRoles.Administrator);
using (DA.AccessServiceDataContext context = new DA.AccessServiceDataContext()) {
//load client because we could get a detached object
var query = from c in context.GetTable<DA.Resource>().OfType<DA.Client>()
where c.Id == client.Id
select c;
if (query.Count() > 0) {
//delete affiliation first
var queryMapping = context.ResourceResourceGroups.Where(x => x.ResourceId == client.Id);
if (queryMapping.Count() > 0) {
context.ResourceResourceGroups.DeleteAllOnSubmit(queryMapping);
}
context.Resources.DeleteOnSubmit(query.First());
context.SubmitChanges();
}
}
}
public void UpdateClient(DT.Client client) {
string country = string.Empty;
OperationContext opContext = OperationContext.Current;
if (opContext != null) {
MessageProperties properties = opContext.IncomingMessageProperties;
RemoteEndpointMessageProperty endpoint = properties[RemoteEndpointMessageProperty.Name] as RemoteEndpointMessageProperty;
string ipAdr = endpoint.Address;
country = GeoIPLookupService.Instance.GetCountryName(ipAdr);
}
using (DA.AccessServiceDataContext context = new DA.AccessServiceDataContext()) {
var query = from c in context.Resources.OfType<DA.Client>()
where c.Id == client.Id
select c;
if (query.Count() > 0) {
var entity = query.First();
if (country != string.Empty) {
var countryQuery = from c in context.GetTable<DA.Country>()
where c.Name == country
select c;
if (countryQuery.Count() > 0) {
entity.CountryId = countryQuery.First().Id;
}
}
entity.Name = client.Name;
entity.Description = client.Description;
entity.HeuristicLabVersion = client.HeuristicLabVersion;
entity.Timestamp = DateTime.Now;
context.SubmitChanges();
}
}
}