//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()