//end put_ticket_sources
static void put_ticket_queues(net.autotask.webservices.Field field)
{
AutotaskDataContext atDataset = new AutotaskDataContext();
foreach (net.autotask.webservices.PickListValue plv in field.PicklistValues)
{
Ticket_Queue queue;
//check if queue exists in db
bool exists = atDataset.Ticket_Queues.Where(s => s.Value == Convert.ToInt32(plv.Value)).Any();
if (!exists)
{
queue = new Ticket_Queue();
queue.Value = Convert.ToInt32(plv.Value);
}
else
{
queue = atDataset.Ticket_Queues.Single(s => s.Value == Convert.ToInt32(plv.Value));
}
queue.IsActive = Convert.ToByte(plv.IsActive);
queue.IsDefaultValue = Convert.ToByte(plv.IsDefaultValue);
queue.IsSystem = Convert.ToByte(plv.IsSystem);
queue.Label = plv.Label;
queue.ParentValue = plv.parentValue;
queue.SortOrder = plv.SortOrder;
if (!exists)
{
atDataset.Ticket_Queues.InsertOnSubmit(queue);
}
}
atDataset.SubmitChanges();
}
//end put_ticket_queues
static void put_ticket_priorities(net.autotask.webservices.Field field)
{
AutotaskDataContext atDataset = new AutotaskDataContext();
foreach (net.autotask.webservices.PickListValue plv in field.PicklistValues)
{
Ticket_Priority priority;
//check if priority exists in db
bool exists = atDataset.Ticket_Priorities.Where(s => s.Value == Convert.ToInt32(plv.Value)).Any();
if (!exists)
{
priority = new Ticket_Priority();
priority.Value = Convert.ToInt32(plv.Value);
}
else
{
priority = atDataset.Ticket_Priorities.Single(s => s.Value == Convert.ToInt32(plv.Value));
}
priority.IsActive = Convert.ToByte(plv.IsActive);
priority.IsDefaultValue = Convert.ToByte(plv.IsDefaultValue);
priority.IsSystem = Convert.ToByte(plv.IsSystem);
priority.Label = plv.Label;
priority.ParentValue = plv.parentValue;
priority.SortOrder = plv.SortOrder;
if (!exists)
{
atDataset.Ticket_Priorities.InsertOnSubmit(priority);
}
}
atDataset.SubmitChanges();
}
} //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.GetFieldInfo(entity.GetType().Name).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 PicklistValue()
public FieldInformation(net.autotask.webservices.Field field_information)
{
this.Name = field_information.Name;
this.Label = field_information.Label;
this.Type = field_information.Type;
this.Description = field_information.Description;
this.IsRequired = field_information.IsRequired;
this.IsReadOnly = field_information.IsReadOnly;
this.IsQueryable = field_information.IsQueryable;
this.IsReference = field_information.IsReference;
this.ReferenceEntityType = string.IsNullOrEmpty(field_information.ReferenceEntityType) ? null : System.Type.GetType(field_information.ReferenceEntityType, false, false);
this.IsPickList = field_information.IsPickList;
this.PicklistValues = field_information.PicklistValues == null ? null : new List <PicklistValue>();
if (field_information.PicklistValues != null && field_information.PicklistValues.Length > 0)
{
foreach (net.autotask.webservices.PickListValue plv in field_information.PicklistValues)
{
this.PicklistValues.Add(new PicklistValue(plv));
}
}
this.PicklistParentFieldName = field_information.PicklistParentValueField;
this.DefaultValue = field_information.DefaultValue;
this.Length = field_information.Length;
} //end PicklistValue()
