//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 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_accounts static void put_resources(List <net.autotask.webservices.Resource> resources) { AutotaskDataContext atDataset = new AutotaskDataContext(); foreach (net.autotask.webservices.Resource res in resources) { Resource resource; //check if resource exists in db bool exists = atDataset.Resources.Where(r => r.id == res.id).Any(); if (!exists) { resource = new Resource(); resource.id = res.id; } else { resource = atDataset.Resources.Single(r => r.id == res.id); } resource.AccountingReferenceID = Convert.ToString(res.AccountingReferenceID); resource.Active = Convert.ToByte(res.Active); resource.DateFormat = Convert.ToString(res.DateFormat); resource.DefaultServiceDeskRoleID = Convert.ToInt64(res.DefaultServiceDeskRoleID); resource.Email = Convert.ToString(res.Email); resource.Email2 = Convert.ToString(res.Email2); resource.Email3 = Convert.ToString(res.Email3); resource.EmailTypeCode = Convert.ToString(res.EmailTypeCode); resource.EmailTypeCode2 = Convert.ToString(res.EmailTypeCode2); resource.EmailTypeCode3 = Convert.ToString(res.EmailTypeCode3); resource.FirstName = Convert.ToString(res.FirstName); resource.Gender = Convert.ToString(res.Gender); resource.Greeting = Convert.ToInt32(res.Greeting); resource.HireDate = Convert.ToDateTime(res.HireDate) > new DateTime(1753, 1, 1) ? Convert.ToDateTime(res.HireDate) : new DateTime(1753, 1, 1); resource.HomePhone = Convert.ToString(res.HomePhone); resource.Initials = Convert.ToString(res.Initials); resource.InternalCost = Convert.ToDouble(res.InternalCost); resource.LastName = Convert.ToString(res.LastName); resource.LocationID = Convert.ToInt32(res.LocationID); resource.MiddleName = Convert.ToString(res.MiddleName); resource.MobilePhone = Convert.ToString(res.MobilePhone); resource.NumberFormat = Convert.ToString(res.NumberFormat); resource.OfficeExtension = Convert.ToString(res.OfficeExtension); resource.OfficePhone = Convert.ToString(res.OfficePhone); resource.Password = Convert.ToString(res.Password); resource.PayrollType = Convert.ToInt32(res.PayrollType); resource.ResourceType = Convert.ToString(res.ResourceType); resource.Suffix = Convert.ToString(res.Suffix); resource.TimeFormat = Convert.ToString(res.TimeFormat); resource.Title = Convert.ToString(res.Title); resource.TravelAvailabilityPct = Convert.ToString(res.TravelAvailabilityPct); resource.UserName = Convert.ToString(res.UserName); resource.UserType = Convert.ToInt32(res.UserType); if (!exists) { atDataset.Resources.InsertOnSubmit(resource); } } atDataset.SubmitChanges(); }
//end put_tasks static void put_timeentries(List <net.autotask.webservices.TimeEntry> timeentries) { AutotaskDataContext atDataset = new AutotaskDataContext(); foreach (net.autotask.webservices.TimeEntry tim in timeentries) { TimeEntry timeentry; //check if time entry exists in db bool exists = atDataset.TimeEntries.Where(r => r.id == tim.id).Any(); if (!exists) { timeentry = new TimeEntry(); timeentry.id = tim.id; } else { timeentry = atDataset.TimeEntries.Single(t => t.id == tim.id); } timeentry.AllocationCodeID = Convert.ToInt64(tim.AllocationCodeID); timeentry.BillingApprovalDateTime = tim.BillingApprovalDateTime == null ? new DateTime?() : Convert.ToDateTime(tim.BillingApprovalDateTime); timeentry.BillingApprovalLevelMostRecent = Convert.ToInt32(tim.BillingApprovalLevelMostRecent); timeentry.BillingApprovalResourceID = Convert.ToInt64(tim.BillingApprovalResourceID); timeentry.ContractID = Convert.ToInt64(tim.ContractID); timeentry.ContractServiceBundleID = Convert.ToInt64(tim.ContractServiceBundleID); timeentry.ContractServiceID = Convert.ToInt64(tim.ContractServiceID); timeentry.CreateDateTime = tim.CreateDateTime == null ? new DateTime?() : Convert.ToDateTime(tim.CreateDateTime); timeentry.CreatorUserID = Convert.ToInt32(tim.CreatorUserID); timeentry.DateWorked = Convert.ToDateTime(tim.DateWorked) > new DateTime(1753, 1, 1) ? Convert.ToDateTime(tim.DateWorked) : new DateTime(1753, 1, 1); timeentry.EndDateTime = tim.EndDateTime == null ? new DateTime?() : Convert.ToDateTime(tim.EndDateTime); timeentry.HoursToBill = Convert.ToDouble(tim.HoursToBill); timeentry.HoursWorked = Convert.ToDouble(tim.HoursWorked); timeentry.InternalAllocationCodeID = Convert.ToInt64(tim.InternalAllocationCodeID); timeentry.InternalNotes = Convert.ToString(tim.InternalNotes); timeentry.LastModifiedDateTime = tim.LastModifiedDateTime == null ? new DateTime?() : Convert.ToDateTime(tim.LastModifiedDateTime); timeentry.LastModifiedUserID = Convert.ToInt32(tim.LastModifiedUserID); timeentry.NonBillable = Convert.ToByte(tim.NonBillable); timeentry.OffsetHours = Convert.ToDouble(tim.OffsetHours); timeentry.ResourceID = Convert.ToInt64(tim.ResourceID); timeentry.RoleID = Convert.ToInt64(tim.RoleID); timeentry.ShowOnInvoice = Convert.ToByte(tim.ShowOnInvoice); timeentry.StartDateTime = tim.StartDateTime == null ? new DateTime?() : Convert.ToDateTime(tim.StartDateTime); timeentry.SummaryNotes = Convert.ToString(tim.SummaryNotes); timeentry.TaskID = Convert.ToInt64(tim.TaskID); timeentry.TicketID = Convert.ToInt64(tim.TicketID); timeentry.Type = Convert.ToInt32(tim.Type); if (!exists) { atDataset.TimeEntries.InsertOnSubmit(timeentry); } } atDataset.SubmitChanges(); }
//end put_projects static void put_tasks(List <net.autotask.webservices.Task> tasks) { AutotaskDataContext atDataset = new AutotaskDataContext(); foreach (net.autotask.webservices.Task tas in tasks) { Task task; //check if task exists in db bool exists = atDataset.Tasks.Where(t => t.id == tas.id).Any(); if (!exists) { task = new Task(); task.id = tas.id; } else { task = atDataset.Tasks.Single(t => t.id == tas.id); } task.AllocationCodeID = Convert.ToInt64(tas.AllocationCodeID); task.AssignedResourceID = Convert.ToInt64(tas.AssignedResourceID); task.AssignedResourceRoleID = Convert.ToInt64(tas.AssignedResourceRoleID); task.CanClientPortalUserCompleteTask = Convert.ToByte(tas.CanClientPortalUserCompleteTask); task.CompletedDateTime = tas.CompletedDateTime == null ? new DateTime?() : Convert.ToDateTime(tas.CompletedDateTime); task.CreateDateTime = tas.CreateDateTime == null ? new DateTime?() : Convert.ToDateTime(tas.CreateDateTime); task.CreatorResourceID = Convert.ToInt64(tas.CreatorResourceID); task.DepartmentID = Convert.ToInt32(tas.DepartmentID); task.Description = Convert.ToString(tas.Description); task.EndDateTime = tas.EndDateTime == null ? new DateTime?() : Convert.ToDateTime(tas.EndDateTime); task.EstimatedHours = Convert.ToDouble(tas.EstimatedHours); task.ExternalID = Convert.ToString(tas.ExternalID); task.HoursToBeScheduled = Convert.ToDouble(tas.HoursToBeScheduled); task.IsVisibleInClientPortal = Convert.ToByte(tas.IsVisibleInClientPortal); task.LastActivityDateTime = tas.LastActivityDateTime == null ? new DateTime?() : Convert.ToDateTime(tas.LastActivityDateTime); task.PhaseID = Convert.ToInt64(tas.PhaseID); task.Priority = Convert.ToInt32(tas.Priority); task.ProjectID = Convert.ToInt64(tas.ProjectID); task.PurchaseOrderNumber = Convert.ToString(tas.PurchaseOrderNumber); task.RemainingHours = Convert.ToDouble(tas.RemainingHours); task.StartDateTime = tas.StartDateTime == null ? new DateTime?() : Convert.ToDateTime(tas.StartDateTime); task.Status = Convert.ToInt32(tas.Status); task.TaskIsBillable = Convert.ToByte(tas.TaskIsBillable); task.TaskNumber = Convert.ToString(tas.TaskNumber); task.TaskType = Convert.ToInt32(tas.TaskType); task.Title = Convert.ToString(tas.Title); if (!exists) { atDataset.Tasks.InsertOnSubmit(task); } } atDataset.SubmitChanges(); }
//end put_ticket_priorities static void put_projects(List <net.autotask.webservices.Project> projects) { AutotaskDataContext atDataset = new AutotaskDataContext(); foreach (net.autotask.webservices.Project pro in projects) { Project project; //check if project exists in db bool exists = atDataset.Projects.Where(p => p.id == pro.id).Any(); if (!exists) { project = new Project(); project.id = pro.id; } else { project = atDataset.Projects.Single(p => p.id == pro.id); } project.AccountID = Convert.ToInt64(pro.AccountID); project.ActualBilledHours = Convert.ToDouble(pro.ActualBilledHours); project.ActualHours = Convert.ToDouble(pro.ActualHours); project.ChangeOrdersBudget = Convert.ToDouble(pro.ChangeOrdersBudget); project.ChangeOrdersRevenue = Convert.ToDouble(pro.ChangeOrdersRevenue); project.CompanyOwnerResourceID = Convert.ToInt64(pro.CompanyOwnerResourceID); project.CompletedDateTime = pro.CompletedDateTime == null ? new DateTime?() : Convert.ToDateTime(pro.CompletedDateTime); project.CompletedPercentage = Convert.ToInt32(pro.CompletedPercentage); project.ContractID = Convert.ToInt64(pro.ContractID); project.CreateDateTime = pro.CreateDateTime == null ? new DateTime?() : Convert.ToDateTime(pro.CreateDateTime); project.CreatorResourceID = Convert.ToInt64(pro.CreatorResourceID); project.Department = Convert.ToInt32(pro.Department); project.Description = Convert.ToString(pro.Description); project.Duration = Convert.ToInt32(pro.Duration); project.EndDateTime = Convert.ToDateTime(pro.EndDateTime) > new DateTime(1753, 1, 1) ? Convert.ToDateTime(pro.EndDateTime) : new DateTime(1753, 1, 1); project.EstimatedSalesCost = Convert.ToDouble(pro.EstimatedSalesCost); project.EstimatedTime = Convert.ToDouble(pro.EstimatedTime); project.ExtPNumber = Convert.ToString(pro.ExtPNumber); project.ExtProjectType = Convert.ToInt32(pro.ExtProjectType); project.LaborEstimatedCosts = Convert.ToDouble(pro.LaborEstimatedCosts); project.LaborEstimatedMarginPercentage = Convert.ToDouble(pro.LaborEstimatedMarginPercentage); project.LaborEstimatedRevenue = Convert.ToDouble(pro.LaborEstimatedRevenue); project.LineOfBusiness = Convert.ToInt32(pro.LineOfBusiness); project.OriginalEstimatedRevenue = Convert.ToDouble(pro.OriginalEstimatedRevenue); project.ProjectCostEstimatedMarginPercentage = Convert.ToDouble(pro.ProjectCostEstimatedMarginPercentage); project.ProjectCostsBudget = Convert.ToDouble(pro.ProjectCostsBudget); project.ProjectCostsRevenue = Convert.ToDouble(pro.ProjectCostsRevenue); project.ProjectLeadResourceID = Convert.ToInt64(pro.ProjectLeadResourceID); project.ProjectName = Convert.ToString(pro.ProjectName); project.ProjectNumber = Convert.ToString(pro.ProjectNumber); project.PurchaseOrderNumber = Convert.ToString(pro.PurchaseOrderNumber); project.SGDA = Convert.ToDouble(pro.SGDA); project.StartDateTime = Convert.ToDateTime(pro.StartDateTime) > new DateTime(1753, 1, 1) ? Convert.ToDateTime(pro.StartDateTime) : new DateTime(1753, 1, 1); project.Status = Convert.ToInt32(pro.Status); project.StatusDateTime = pro.StatusDateTime == null ? new DateTime?() : Convert.ToDateTime(pro.StatusDateTime); project.StatusDetail = Convert.ToString(pro.StatusDetail); project.Type = Convert.ToInt32(pro.Type); if (!exists) { atDataset.Projects.InsertOnSubmit(project); } } atDataset.SubmitChanges(); }
//end put_contacts static void put_tickets(List <net.autotask.webservices.Ticket> tickets) { AutotaskDataContext atDataset = new AutotaskDataContext(); foreach (net.autotask.webservices.Ticket tic in tickets) { Ticket ticket; //check if ticket exists in db bool exists = atDataset.Tickets.Where(t => t.id == tic.id).Any(); if (!exists) { ticket = new Ticket(); ticket.id = tic.id; } else { ticket = atDataset.Tickets.Single(t => t.id == tic.id); } ticket.AccountID = Convert.ToInt64(tic.AccountID); ticket.AEMAlertID = Convert.ToString(tic.AEMAlertID); ticket.AllocationCodeID = Convert.ToInt64(tic.AllocationCodeID); ticket.AssignedResourceID = Convert.ToInt64(tic.AssignedResourceID); ticket.AssignedResourceRoleID = Convert.ToInt64(tic.AssignedResourceRoleID); ticket.ChangeApprovalBoard = Convert.ToInt32(tic.ChangeApprovalBoard); ticket.ChangeApprovalStatus = Convert.ToInt32(tic.ChangeApprovalStatus); ticket.ChangeApprovalType = Convert.ToInt32(tic.ChangeApprovalType); ticket.ChangeInfoField1 = Convert.ToString(tic.ChangeInfoField1); ticket.ChangeInfoField2 = Convert.ToString(tic.ChangeInfoField2); ticket.ChangeInfoField3 = Convert.ToString(tic.ChangeInfoField3); ticket.ChangeInfoField4 = Convert.ToString(tic.ChangeInfoField4); ticket.ChangeInfoField5 = Convert.ToString(tic.ChangeInfoField5); ticket.CompletedDate = tic.CompletedDate == null ? new DateTime?() : Convert.ToDateTime(tic.CompletedDate); ticket.ContactID = Convert.ToInt64(tic.ContactID); ticket.ContractID = Convert.ToInt64(tic.ContractID); ticket.ContractServiceBundleID = Convert.ToInt64(tic.ContractServiceBundleID); ticket.ContractServiceID = Convert.ToInt64(tic.ContractServiceID); ticket.CreateDate = tic.CreateDate == null ? new DateTime?() : Convert.ToDateTime(tic.CreateDate); ticket.CreatorResourceID = Convert.ToInt64(tic.CreatorResourceID); ticket.Description = Convert.ToString(tic.Description); ticket.DueDateTime = Convert.ToDateTime(tic.DueDateTime) > new DateTime(1753, 1, 1) ? Convert.ToDateTime(tic.DueDateTime) : new DateTime(1753, 1, 1); ticket.EstimatedHours = Convert.ToDouble(tic.EstimatedHours); ticket.ExternalID = Convert.ToString(tic.ExternalID); ticket.FirstResponseAssignedResourceID = Convert.ToInt32(tic.FirstResponseAssignedResourceID); ticket.FirstResponseDateTime = tic.FirstResponseDateTime == null ? new DateTime?() : Convert.ToDateTime(tic.FirstResponseDateTime); ticket.FirstResponseDueDateTime = tic.FirstResponseDueDateTime == null ? new DateTime?() : Convert.ToDateTime(tic.FirstResponseDueDateTime); ticket.FirstResponseInitiatingResourceID = Convert.ToInt32(tic.FirstResponseInitiatingResourceID); ticket.HoursToBeScheduled = Convert.ToDouble(tic.HoursToBeScheduled); ticket.InstalledProductID = Convert.ToInt64(tic.InstalledProductID); ticket.IssueType = Convert.ToInt32(tic.IssueType); ticket.LastActivityDate = tic.LastActivityDate == null ? new DateTime?() : Convert.ToDateTime(tic.LastActivityDate); ticket.LastCustomerNotificationDateTime = tic.LastCustomerNotificationDateTime == null ? new DateTime?() : Convert.ToDateTime(tic.LastCustomerNotificationDateTime); ticket.LastCustomerVisibleActivityDateTime = tic.LastCustomerVisibleActivityDateTime == null ? new DateTime?() : Convert.ToDateTime(tic.LastCustomerVisibleActivityDateTime); ticket.MonitorID = Convert.ToInt32(tic.MonitorID); ticket.MonitorTypeID = Convert.ToInt32(tic.MonitorTypeID); ticket.OpportunityId = Convert.ToInt64(tic.OpportunityId); ticket.Priority = Convert.ToInt32(tic.Priority); ticket.ProblemTicketId = Convert.ToInt64(tic.ProblemTicketId); ticket.ProjectID = Convert.ToInt64(tic.ProjectID); ticket.PurchaseOrderNumber = Convert.ToString(tic.PurchaseOrderNumber); ticket.QueueID = Convert.ToInt32(tic.QueueID); ticket.Resolution = Convert.ToString(tic.Resolution); ticket.ResolutionPlanDateTime = tic.ResolutionPlanDateTime == null ? new DateTime?() : Convert.ToDateTime(tic.ResolutionPlanDateTime); ticket.ResolutionPlanDueDateTime = tic.ResolutionPlanDueDateTime == null ? new DateTime?() : Convert.ToDateTime(tic.ResolutionPlanDueDateTime); ticket.ResolvedDateTime = tic.ResolvedDateTime == null ? new DateTime?() : Convert.ToDateTime(tic.ResolvedDateTime); ticket.ResolvedDueDateTime = tic.ResolvedDueDateTime == null ? new DateTime?() : Convert.ToDateTime(tic.ResolvedDueDateTime); ticket.ServiceLevelAgreementHasBeenMet = Convert.ToByte(tic.ServiceLevelAgreementHasBeenMet); ticket.ServiceLevelAgreementID = Convert.ToInt32(tic.ServiceLevelAgreementID); ticket.Source = Convert.ToInt32(tic.Source); ticket.Status = Convert.ToInt32(tic.Status); ticket.SubIssueType = Convert.ToInt32(tic.SubIssueType); ticket.TicketCategory = Convert.ToInt32(tic.TicketCategory); ticket.TicketNumber = Convert.ToString(tic.TicketNumber); ticket.TicketType = Convert.ToInt32(tic.TicketType); ticket.Title = Convert.ToString(tic.Title); if (!exists) { atDataset.Tickets.InsertOnSubmit(ticket); } } atDataset.SubmitChanges(); }
//end put_resources static void put_contacts(List <net.autotask.webservices.Contact> contacts) { AutotaskDataContext atDataset = new AutotaskDataContext(); foreach (net.autotask.webservices.Contact con in contacts) { Contact contact; //check if contact exists in db bool exists = atDataset.Contacts.Where(c => c.id == con.id).Any(); if (!exists) { contact = new Contact(); contact.id = con.id; } else { contact = atDataset.Contacts.Single(c => c.id == con.id); } contact.AccountID = Convert.ToInt64(con.AccountID); contact.Active = Convert.ToByte(con.Active); contact.AdditionalAddressInformation = Convert.ToString(con.AdditionalAddressInformation); contact.AddressLine = Convert.ToString(con.AddressLine); contact.AddressLine1 = Convert.ToString(con.AddressLine1); contact.AlternatePhone = Convert.ToString(con.AlternatePhone); contact.BulkEmailOptOut = Convert.ToByte(con.BulkEmailOptOut); contact.BulkEmailOptOutTime = con.BulkEmailOptOutTime == null ? new DateTime?() : Convert.ToDateTime(con.BulkEmailOptOutTime); contact.City = Convert.ToString(con.City); contact.Country = Convert.ToString(con.Country); contact.CountryID = Convert.ToInt64(con.CountryID); contact.CreateDate = con.CreateDate == null ? new DateTime?() : Convert.ToDateTime(con.CreateDate); contact.EMailAddress = Convert.ToString(con.EMailAddress); contact.EMailAddress2 = Convert.ToString(con.EMailAddress2); contact.EMailAddress3 = Convert.ToString(con.EMailAddress3); contact.Extension = Convert.ToString(con.Extension); contact.ExternalID = Convert.ToString(con.ExternalID); contact.FacebookURL = Convert.ToString(con.FacebookUrl); contact.FaxNumber = Convert.ToString(con.FaxNumber); contact.FirstName = Convert.ToString(con.FirstName); contact.LastActivityDate = con.LastActivityDate == null ? new DateTime?() : Convert.ToDateTime(con.LastActivityDate); contact.LastModifiedDate = con.LastModifiedDate == null ? new DateTime?() : Convert.ToDateTime(con.LastModifiedDate); contact.LastName = Convert.ToString(con.LastName); contact.LinkedInURL = Convert.ToString(con.LinkedInUrl); contact.MiddleInitial = Convert.ToString(con.MiddleInitial); contact.MobilePhone = Convert.ToString(con.MobilePhone); contact.NamePrefix = Convert.ToInt32(con.NamePrefix); contact.NameSuffix = Convert.ToInt32(con.NameSuffix); contact.Note = Convert.ToString(con.Note); contact.Notification = Convert.ToByte(con.Notification); contact.Phone = Convert.ToString(con.Phone); contact.PrimaryContact = Convert.ToByte(con.PrimaryContact); contact.RoomNumber = Convert.ToString(con.RoomNumber); contact.State = Convert.ToString(con.State); contact.SurveyOptOut = Convert.ToByte(con.SurveyOptOut); contact.Title = Convert.ToString(con.Title); contact.TwitterURL = Convert.ToString(con.TwitterUrl); contact.ZipCode = Convert.ToString(con.ZipCode); if (!exists) { atDataset.Contacts.InsertOnSubmit(contact); } } atDataset.SubmitChanges(); }
static void put_accounts(List <net.autotask.webservices.Account> accounts) { AutotaskDataContext atDataset = new AutotaskDataContext(); foreach (net.autotask.webservices.Account acc in accounts) { Account account; //check if account exists in db bool exists = atDataset.Accounts.Where(r => r.id == acc.id).Any(); if (!exists) { account = new Account(); account.id = acc.id; } else { account = atDataset.Accounts.Single(r => r.id == acc.id); } account.AccountName = Convert.ToString(acc.AccountName); account.AccountNumber = Convert.ToString(acc.AccountNumber); account.AccountType = Convert.ToInt16(acc.AccountType); account.Active = Convert.ToByte(acc.Active); account.AdditionalAddressInformation = Convert.ToString(acc.AdditionalAddressInformation); account.Address1 = Convert.ToString(acc.Address1); account.Address2 = Convert.ToString(acc.Address2); account.AlternatePhone1 = Convert.ToString(acc.AlternatePhone1); account.AlternatePhone2 = Convert.ToString(acc.AlternatePhone2); account.AssetValue = Convert.ToDouble(acc.AssetValue); account.BillToAdditionalAddressInformation = Convert.ToString(acc.BillToAdditionalAddressInformation); account.BillToAddress1 = Convert.ToString(acc.BillToAddress1); account.BillToAddress2 = Convert.ToString(acc.BillToAddress2); account.BillToAddressToUse = Convert.ToInt32(acc.BillToAddressToUse); account.BillToAttention = Convert.ToString(acc.BillToAttention); account.BillToCity = Convert.ToString(acc.BillToCity); account.BillToCountryID = Convert.ToInt64(acc.BillToCountryID); account.BillToState = Convert.ToString(acc.BillToState); account.BillToZipCode = Convert.ToString(acc.BillToZipCode); account.City = Convert.ToString(acc.City); account.ClientPortalActive = Convert.ToByte(acc.ClientPortalActive); account.CompetitorID = Convert.ToInt32(acc.CompetitorID); account.Country = Convert.ToString(acc.Country); account.CountryID = Convert.ToInt64(acc.CountryID); account.CreateDate = acc.CreateDate == null ? new DateTime?() : Convert.ToDateTime(acc.CreateDate); account.CurrencyID = Convert.ToInt64(acc.CurrencyID); account.Fax = Convert.ToString(acc.Fax); account.InvoiceEmailMessageID = Convert.ToInt32(acc.InvoiceEmailMessageID); account.InvoiceMethod = Convert.ToInt32(acc.InvoiceMethod); account.InvoiceNonContractItemsToParentAccount = Convert.ToByte(acc.InvoiceNonContractItemsToParentAccount); account.InvoiceTemplateID = Convert.ToInt64(acc.InvoiceTemplateID); account.KeyAccountIcon = Convert.ToInt32(acc.KeyAccountIcon); account.LastActivityDate = acc.LastActivityDate == null ? new DateTime?() : Convert.ToDateTime(acc.LastActivityDate); account.MarketSegmentID = Convert.ToInt32(acc.MarketSegmentID); account.OwnerResourceID = Convert.ToInt64(acc.OwnerResourceID); account.ParentAccountID = Convert.ToInt64(acc.ParentAccountID); account.Phone = Convert.ToString(acc.Phone); account.PostalCode = Convert.ToString(acc.PostalCode); account.QuoteEmailMessageID = Convert.ToInt32(acc.QuoteEmailMessageID); account.QuoteTemplateID = Convert.ToInt64(acc.QuoteTemplateID); account.SICCode = Convert.ToString(acc.SICCode); account.State = Convert.ToString(acc.State); account.StockMarket = Convert.ToString(acc.StockMarket); account.StockSymbol = Convert.ToString(acc.StockSymbol); account.TaskFireActive = Convert.ToByte(acc.TaskFireActive); account.TaxExempt = Convert.ToByte(acc.TaxExempt); account.TaxID = Convert.ToString(acc.TaxID); account.TaxRegionID = Convert.ToInt32(acc.TaxRegionID); account.TerritoryID = Convert.ToInt32(acc.TerritoryID); account.WebAddress = Convert.ToString(acc.WebAddress); if (!exists) { atDataset.Accounts.InsertOnSubmit(account); } } atDataset.SubmitChanges(); }