} //end Update
#endregion //Update
#region Delete
/// <summary>
/// Deletes entities
/// </summary>
/// <param name="entity">entity to delete</param>
/// <returns></returns>
public bool Delete(Entities.Entity entity)
{
bool deletedEntity = false;
if (!entity.CanDelete)
{
throw new AutotaskNETException($"The {entity.GetType()} entity can not be deleted.");
}
else
{
dynamic typedEntity = Convert.ChangeType(entity, entity.GetType());
//delete entity
net.autotask.webservices.ATWSResponse resp = _atws.deleteAsync(
new deleteRequest(new AutotaskIntegrations(),
new net.autotask.webservices.Entity[] { typedEntity })).Result.deleteResult;
if (resp.Errors.Length > 0)
{
throw new AutotaskNETException(string.Join("\r\n", resp.Errors.Select(r => r.Message)));
}
else
{
deletedEntity = true;
}
}
return(deletedEntity);
} //end Delete
} //end Create
#endregion //Create
#region Update
/// <summary>
/// Updates the specified entity.
/// </summary>
/// <param name="entity">The entity to update.</param>
/// <returns>the updated entity.</returns>
/// <exception cref="AutotaskNETException">
/// The entity cannot be updated.
/// Response error.
/// </exception>
public Entity Update(Entities.Entity entity)
{
Entities.Entity updatedEntity = null;
if (!entity.CanUpdate)
{
throw new AutotaskNETException($"The {entity.GetType()} entity can not be updated.");
}
else
{
dynamic typedEntity = Convert.ChangeType(entity, entity.GetType());
//update entity
net.autotask.webservices.ATWSResponse resp = this._atws.updateAsync(
new updateRequest()
{
Entities =
new net.autotask.webservices.Entity[] { typedEntity }
}).Result.updateResult;
if (resp.Errors.Length > 0 && resp.EntityReturnInfoResults.Length <= 0)
{
throw new AutotaskNETException(string.Join("\r\n", resp.Errors.Select(r => r.Message)));
}
else
{
updatedEntity = this.Query(entity.GetType(), new QueryFilter()
{
new QueryField("id", QueryFieldOperation.Equals, resp.EntityReturnInfoResults[0].EntityId)
}).FirstOrDefault();
}
}
return(updatedEntity);
} //end Update
} //end GetUDFInfo(Type entity_type)
/// <summary>
/// Gets UDF information.
/// Currently, the following Autotask entities can include UDFs:
/// Account
/// AccountLocation
/// Contact
/// InstalledProduct
/// Opportunity
/// Product
/// Project
/// Task
/// Ticket
/// </summary>
/// <param name="entity">The entity.</param>
/// <returns></returns>
public List <FieldInformation> GetUDFInfo(Entities.Entity entity)
{
List <FieldInformation> UDFs = new List <FieldInformation>();
List <net.autotask.webservices.Field> fields = this._atws.getUDFInfoAsync(
new getUDFInfoRequest(new AutotaskIntegrations(),
entity.GetType().Name)).Result.getUDFInfoResult.ToList();
if (fields != null && fields.Count > 0)
{
foreach (net.autotask.webservices.Field field in fields)
{
UDFs.Add(new FieldInformation(field));
}
}
return(UDFs);
} //end getUDFInfo
} //end GetFieldInfo(Type entity_type)
/// <summary>
/// Gets the field information.
/// </summary>
/// <param name="entity">The entity.</param>
/// <returns></returns>
public List <FieldInformation> GetFieldInfo(Entities.Entity entity)
{
List <FieldInformation> fieldInfo = new List <FieldInformation>();
List <net.autotask.webservices.Field> eInfo = this._atws.GetFieldInfoAsync(
new GetFieldInfoRequest(
new AutotaskIntegrations(),
entity.GetType().Name)).Result.GetFieldInfoResult.ToList();
foreach (net.autotask.webservices.Field fld in eInfo)
{
fieldInfo.Add(new FieldInformation(fld));
}
return(fieldInfo);
} //end GetFieldInfo(Entities.Entity entity)
} //end GetPicklistValues(Type entity_type, string field)
/// <summary>
/// Gets the picklist values of a field.
/// </summary>
/// <param name="entity">The entity.</param>
/// <param name="field">The field name.</param>
/// <returns></returns>
public List <PicklistValue> GetPicklistValues(Entities.Entity entity, string field)
{
List <PicklistValue> listValues = new List <PicklistValue>();
net.autotask.webservices.Field fieldInfo = this._atws.GetFieldInfoAsync(
new GetFieldInfoRequest(
new AutotaskIntegrations(),
entity.GetType().Name)).Result.GetFieldInfoResult.ToList().SingleOrDefault(f => f.Name == field);
if (fieldInfo != null)
{
foreach (net.autotask.webservices.PickListValue plv in fieldInfo.PicklistValues)
{
listValues.Add(new PicklistValue(plv));
}
}
return(listValues);
} //end GetPicklistValues(Entities.Entity entity, string field)
} //end Query(Type entity_type, List<QueryFilter> filters = null)
/// <summary>
/// Queries entities using instance
/// </summary>
/// <param name="entity">instance of entity to query</param>
/// <param name="filters">query filters</param>
/// <returns></returns>
public IEnumerable <Entity> Query(Entities.Entity entity, QueryFilter filters = null)
{
//List<Entities.Entity> entities = null;
if (!entity.CanQuery)
{
throw new AutotaskNETException($"The {entity.GetType().Name} entity can not be queried.");
}
else
{
//query entity
//entities = new List<Entities.Entity>();
bool query_done = false;
long current_id = 0;
while (!query_done)
{
//create query
StringBuilder query = new StringBuilder();
query.Append("<queryxml version=\"1.0\">");
query.Append($"<entity>{entity.GetType().Name}</entity>");
query.Append("<query>");
#region QueryFilters
//use id to pull more than 500 records if id is not already a filter
if (filters == null || !QueryFilter.ContainsCondition(new QueryCondition(filters), "id"))
{
query.Append($"<field>Id<expression op=\"greaterthan\">{current_id}</expression></field>");
}
//handle all other filters
if (filters != null)
{
string cond = this.ParseConditions(new QueryCondition(filters));
query.Append(cond);
}
#endregion //QueryFilters
query.Append("</query>");
query.Append("</queryxml>");
//Console.WriteLine(query.ToString());
//submit query
ATWSResponse response = this._atws.queryAsync(new queryRequest(
new AutotaskIntegrations(),
query.ToString())).Result.queryResult;
//parse response
if (response.ReturnCode > 0 && response.EntityResults.Length > 0)
{
List <Entities.Entity> temp_entities = new List <Entities.Entity>();
foreach (net.autotask.webservices.Entity atws_entity in response.EntityResults)
{
temp_entities.Add((Entities.Entity)Activator.CreateInstance(entity.GetType(), atws_entity));
}
current_id = temp_entities.First(e => e.id == temp_entities.Max(m => m.id)).id;
foreach (var i in temp_entities)
{
yield return(i);
}
//entities.AddRange(temp_entities);
temp_entities = null;
//###########################################################################
if ((filters != null && QueryFilter.ContainsCondition(
new QueryCondition(filters), "id")) || response.EntityResults.Length < 500)
{
query_done = true;
}
}
else
{
//no results or error
query_done = true;
}
}
}
//return entities;
} //end Query(Entities.Entity entity, List<QueryFilter> filters = null)
