private void button4_Click(object sender, EventArgs e)
{
crm_aspect_monitor_aod crm = new crm_aspect_monitor_aod();
crm_aspect_monitor_aod aoddata = new crm_aspect_monitor_aod();
string tmp = JsonConvert.SerializeObject(aoddata);
// string tmp = "abc";
string str = "{" + string.Format("\"aod_12\":\"{0}\"", tmp) + "}";
//string str = string.Format("{0}", tmp);
Console.WriteLine(str);
}
private void button4_Click_1(object sender, EventArgs e)
{
using (var ctx = new testEntities_crm_aspect_monitor_aod())
{
{
try
{
var users = from ex in ctx.crm_aspect_monitor_aod2 select ex;
foreach (var c in users)
{
crm_aspect_monitor_aod aodaspect = utils.TransToAod(c);
string jsonkey = string.Format("aod_{0}", c.serviceid);
string jsonvalue = JsonConvert.SerializeObject(aodaspect);
Console.WriteLine(jsonvalue);
using (var bucket = Cluster.OpenBucket("osms_cb"))
{
if (bucket.Exists(jsonkey))
{
var result = bucket.Replace(jsonkey, jsonvalue);
Console.WriteLine(String.Format("======Replace======={0},{1}", jsonkey, result.Success));
}
else
{
var result = bucket.Insert(jsonkey, jsonvalue);
Console.WriteLine(String.Format("======Insert======={0},{1}", jsonkey, result.Success));
}
}
break;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
}
public static crm_aspect_monitor_aod TransToAod(object t)
{
crm_aspect_monitor_aod aodaspect = new crm_aspect_monitor_aod();
crm_aspect_monitor_aod2 c = (crm_aspect_monitor_aod2)t;
aodaspect.serviceId = c.serviceid;
aodaspect.service = c.service;
aodaspect.status = c.status;
aodaspect.agentsInAccept = c.agentsInAccept;
aodaspect.agentsInActive = c.agentsInActive;
aodaspect.agentsInConnect = c.agentsInConnect;
aodaspect.agentsInHold = c.agentsInHold;
aodaspect.agentsInHdle = c.agentsInHdle;
aodaspect.agentsInInternal = c.agentsInInternal;
aodaspect.agentsInManual = c.agentsInManual;
aodaspect.agentsInMultil = c.agentsInMultil;
aodaspect.agentsInNotReady = c.agentsInNotReady;
aodaspect.agentsInOther = c.agentsInOther;
aodaspect.agentsInPark = c.agentsInPark;
aodaspect.agentsInPreview = c.agentsInPreview;
aodaspect.agentsInWrap = c.agentsInWrap;
aodaspect.agentsLoggedIn = c.agentsLoggedIn;
aodaspect.application = c.application;
aodaspect.applicationId = c.applicationId;
aodaspect.avgAgentActiveTime = c.avgAgentActiveTime;
aodaspect.avgAgentIdleTime = c.avgAgentIdleTime;
aodaspect.avgAgentWrapTime = c.avgAgentWrapTime;
aodaspect.callsAnswered = c.callsAnswered;
aodaspect.callsInProgress = c.callsInProgress;
aodaspect.callsInQueue = c.callsInQueue;
aodaspect.callsServicedWithInServiceLevelDaily = c.callsServicedWithInServiceLevelDaily;
aodaspect.callsTransferredToAgent = c.callsTransferredToAgent;
aodaspect.callsTransferredToAxternal = c.callsTransferredToAxternal;
aodaspect.callsTransferredToService = c.callsTransferredToService;
aodaspect.durActiveTime = c.durActiveTime;
aodaspect.durWrapTime = c.durWrapTime;
aodaspect.maxCallsInQueue = c.maxCallsInQueue;
aodaspect.occupancy = c.occupancy;
aodaspect.serviceType = c.serviceType;
aodaspect.serviceTypeId = c.serviceTypeId;
aodaspect.startTimeMilitary = c.startTimeMilitary;
aodaspect.statusId = c.statusId;
aodaspect.stopTimeMilitary = c.stopTimeMilitary;
aodaspect.abandonByDialer24Hour = c.abandonByDialer24Hour;
aodaspect.abandonedByCustomer = c.abandonedByCustomer;
aodaspect.abandonedBySwitch = c.abandonedBySwitch;
aodaspect.agentAnsweringMachines = c.agentAnsweringMachines;
aodaspect.agentAnsweringMachines24Hour = c.agentAnsweringMachines24Hour;
aodaspect.abandonedPercent = c.abandonedPercent;
aodaspect.answeringMachines24Hour = c.answeringMachines24Hour;
aodaspect.answeringMachinesCurrent = c.answeringMachinesCurrent;
aodaspect.busyHourCallRate = c.busyHourCallRate;
aodaspect.callingPartyInfoViolation = c.callingPartyInfoViolation;
aodaspect.callsAnsweredServiceLevelInterval = c.callsAnsweredServiceLevelInterval;
aodaspect.callsDialed = c.callsDialed;
aodaspect.callStartToGreetingAverage = c.callStartToGreetingAverage;
aodaspect.callStartToGreetingHigh = c.callStartToGreetingHigh;
aodaspect.callStartToGreetingLow = c.callStartToGreetingLow;
aodaspect.currentDetectionType = c.currentDetectionType;
aodaspect.currentDialMode = c.currentDialMode;
aodaspect.currentDialRatio = c.currentDialRatio;
aodaspect.currentDialSettingsAutoRevert = c.currentDialSettingsAutoRevert;
aodaspect.currentQuota = c.currentQuota;
aodaspect.detectToTransferAverage = c.detectToTransferAverage;
aodaspect.detectToTransferHigh = c.detectToTransferHigh;
aodaspect.detectToTransferLow = c.detectToTransferLow;
aodaspect.falseNegativeCount = c.falseNegativeCount;
aodaspect.falsePositiveCount = c.falsePositiveCount;
aodaspect.greetingToConnectAverage = c.greetingToConnectAverage;
aodaspect.greetingToconnectHigh = c.greetingToconnectHigh;
aodaspect.greetingToconnectLow = c.greetingToconnectLow;
aodaspect.greetingTodetectAverage = c.greetingTodetectAverage;
aodaspect.greetingTodetectHigh = c.greetingTodetectHigh;
aodaspect.greetingTodetectLow = c.greetingTodetectLow;
aodaspect.hangup = c.hangup;
aodaspect.hitRate = c.hitRate;
aodaspect.lastFailAbandonPercent = c.lastFailAbandonPercent;
aodaspect.lastTimeToFail = c.lastTimeToFail;
aodaspect.lastTimeToRecover = c.lastTimeToRecover;
aodaspect.maxQuota = c.maxQuota;
aodaspect.minutesLeftOnSchedule = c.minutesLeftOnSchedule;
aodaspect.numberAlertsOFCOM = c.numberAlertsOFCOM;
aodaspect.numberAlertsOFCOM24Hours = c.numberAlertsOFCOM24Hours;
aodaspect.numberHits24Hour = c.numberHits24Hour;
aodaspect.numberHits24HourForFalsePositive = c.numberHits24HourForFalsePositive;
aodaspect.numberHitsCurrent = c.numberHitsCurrent;
aodaspect.numberHitsForFalsePositiveCurrent = c.numberHitsForFalsePositiveCurrent;
aodaspect.numberMisses24Hour = c.numberMisses24Hour;
aodaspect.numberMissesCurrent = c.numberMissesCurrent;
aodaspect.numberOFCOMAbandons24Hour = c.numberOFCOMAbandons24Hour;
aodaspect.numberOFCOMAbandonsCurrent = c.numberOFCOMAbandonsCurrent;
aodaspect.numberOfRecoveries = c.numberOfRecoveries;
aodaspect.numberOfSales = c.numberOfSales;
aodaspect.peakHourCallRate = c.peakHourCallRate;
aodaspect.playMessage = c.playMessage;
aodaspect.playMessageFailure = c.playMessageFailure;
aodaspect.playMessageTimeSuccess = c.playMessageTimeSuccess;
aodaspect.playMessageTimeViolation = c.playMessageTimeViolation;
aodaspect.playScript = c.playScript;
aodaspect.recoveryTimeBegin = c.recoveryTimeBegin;
aodaspect.recoveryTimeEnd = c.recoveryTimeEnd;
aodaspect.ringNoAnswerViolation = c.ringNoAnswerViolation;
aodaspect.scheduledCallbacks = c.scheduledCallbacks;
aodaspect.sendDigits = c.sendDigits;
aodaspect.sendFax = c.sendFax;
aodaspect.timezoneIdentifier = c.timezoneIdentifier;
aodaspect.transferTimeSuccess = c.transferTimeSuccess;
aodaspect.transferTimeViolation = c.transferTimeViolation;
aodaspect.transferCoConnectAverage = c.transferCoConnectAverage;
aodaspect.transferToConnectHigh = c.transferToConnectHigh;
aodaspect.transferToConnectLow = c.transferToConnectLow;
aodaspect.utcStartTime = c.utcStartTime;
aodaspect.utcStopTime = c.utcStopTime;
aodaspect.getAodData = c.getAodData;
return(aodaspect);
}
