private void button5_Click(object sender, EventArgs e) { using (var ctx = new testEntities_acd()) { { try { var users = from ex in ctx.crm_aspect_monitor_acd2 select ex; foreach (var c in users) { acd acdaspect = utils.TransToAcd(c); string jsonkey = string.Format("acd_{0}", c.serviceId); string jsonvalue = JsonConvert.SerializeObject(acdaspect); Console.WriteLine(jsonvalue); if (mc.Get(jsonkey) != null) { bool b = mc.Store(StoreMode.Replace, jsonkey, jsonvalue); Console.WriteLine(string.Format("replace key {0}============{1}", jsonkey, b)); } else { bool b = mc.Store(StoreMode.Add, jsonkey, jsonvalue); Console.WriteLine(string.Format("add key {0}============{1}", jsonkey, b)); } } } catch (Exception ex) { MessageBox.Show(ex.Message); } } } }
public static acd TransToAcd(object t) { acd acdaspect = new acd(); crm_aspect_monitor_acd2 c = (crm_aspect_monitor_acd2)t; acdaspect.serviceId = c.serviceId; acdaspect.service = c.service; acdaspect.status = c.status; acdaspect.agentsInAccept = c.agentsInAccept; acdaspect.agentsInActive = c.agentsInActive; acdaspect.agentsInConnect = c.agentsInConnect; acdaspect.agentsInHold = c.agentsInHold; acdaspect.agentsInIdle = c.agentsInIdle; acdaspect.agentsInInternal = c.agentsInInternal; acdaspect.agentsInManual = c.agentsInManual; acdaspect.agentsInMultil = c.agentsInMultil; acdaspect.agentsInNotReady = c.agentsInNotReady; acdaspect.agentsInOther = c.agentsInOther; acdaspect.agentsInPark = c.agentsInPark; acdaspect.agentsInPreview = c.agentsInPreview; acdaspect.agentsInWrap = c.agentsInWrap; acdaspect.agentsLoggedIn = c.agentsLoggedIn; acdaspect.application = c.application; acdaspect.applicationId = c.applicationId; acdaspect.avgAgentActiveTime = c.avgAgentActiveTime; acdaspect.avgAgentIdleTime = c.avgAgentIdleTime; acdaspect.avgAgentWrapTime = c.avgAgentWrapTime; acdaspect.avgSpeedOfAnswer = c.avgSpeedOfAnswer; acdaspect.avgTimeInQueue = c.avgTimeInQueue; acdaspect.avgTimeToAbandon = c.avgTimeToAbandon; acdaspect.avgWaitTime = c.avgWaitTime; acdaspect.callsAbandonedBeforeQueue = c.callsAbandonedBeforeQueue; acdaspect.callsAbandonedBeforeServiceLevelInterval = c.callsAbandonedBeforeServiceLevelInterval; acdaspect.callsAbandonedBeforeServiceLevelIntervalDaily = c.callsAbandonedBeforeServiceLevelIntervalDaily; acdaspect.callsAbandonedBeforeShortCallInterval = c.callsAbandonedBeforeShortCallInterval; acdaspect.callsAbandonedBeforeShortCallIntervalDaily = c.callsAbandonedBeforeShortCallIntervalDaily; acdaspect.callsAbandonedInQueue = c.callsAbandonedInQueue; acdaspect.callsAbandonedTotal = c.callsAbandonedTotal; acdaspect.callsAbandonedTotalDaily = c.callsAbandonedTotalDaily; acdaspect.callsAnswered = c.callsAnswered; acdaspect.callsInProgress = c.callsInProgress; acdaspect.callsInQueue = c.callsInQueue; acdaspect.callsInVoiceMail = c.callsInVoiceMail; acdaspect.callsOffered = c.callsOffered; acdaspect.callsOfferedServiceLevelInterval = c.callsOfferedServiceLevelInterval; acdaspect.callsOverflowed = c.callsOverflowed; acdaspect.callsRejected = c.callsRejected; acdaspect.callsRerouted = c.callsRerouted; acdaspect.callsServicedWithinServiceLevel = c.callsServicedWithinServiceLevel; acdaspect.callsServicedWithinServiceLevelDaily = c.callsServicedWithinServiceLevelDaily; acdaspect.callsTransferredToAgent = c.callsTransferredToAgent; acdaspect.callsTransferredToExternal = c.callsTransferredToExternal; acdaspect.callsTransferredToService = c.callsTransferredToService; acdaspect.currentLongestQueueWaitSeconds = c.currentLongestQueueWaitSeconds; acdaspect.durActiveTime = c.durActiveTime; acdaspect.durWrapTime = c.durWrapTime; acdaspect.maxCallsInQueue = c.maxCallsInQueue; acdaspect.maxWaitInQueue = c.maxWaitInQueue; acdaspect.occupancy = c.occupancy; acdaspect.percentServiceWithinServiceLevel = c.percentServiceWithinServiceLevel; acdaspect.serviceLevelCalculationMethod = c.serviceLevelCalculationMethod; acdaspect.serviceType = c.serviceType; acdaspect.serviceTypeId = c.serviceTypeId; acdaspect.startTimeMilitary = c.startTimeMilitary; acdaspect.statusId = c.statusId; acdaspect.stopTimeMilitary = c.stopTimeMilitary; acdaspect.timezoneIdentifier = c.timezoneIdentifier; acdaspect.totalQueuedTime = c.totalQueuedTime; acdaspect.totalRoutedToUser = c.totalRoutedToUser; acdaspect.totalTimeToService = c.totalTimeToService; acdaspect.utcStartTime = c.utcStartTime; acdaspect.utcStopTime = c.utcStopTime; return(acdaspect); }