public async Task ReadTable(TableName tableName)
{
await IfNotExistsCreateTableInObject(tableName);
await DownloadFileFromObject(tableName);
string json = File.ReadAllText(Path.Combine(AppDomain.CurrentDomain.BaseDirectory + tableName.ToString() + ".txt"));
switch (tableName)
{
case TableName.TBL_CLUSTER:
TBL_CLUSTER.Truncate();
foreach (var a in JsonConvert.DeserializeObject <List <KeyValuePair <TBL_CLUSTER_KEY, TBL_CLUSTER_VALUE> > >(json))
{
TBL_CLUSTER.Insert(
new TBL_CLUSTER_KEY {
clusterName = a.Key.clusterName
},
new TBL_CLUSTER_VALUE
{
clusterNo = a.Value.clusterNo,
domainName = a.Value.domainName,
clusterPort = a.Value.clusterPort
});
}
break;
case TableName.TBL_SERVER:
TBL_SERVER.Truncate();
foreach (var a in JsonConvert.DeserializeObject <List <KeyValuePair <TBL_SERVER_KEY, TBL_SERVER_VALUE> > >(json))
{
TBL_SERVER.Insert(
new TBL_SERVER_KEY {
serverName = a.Key.serverName
},
new TBL_SERVER_VALUE
{
serverInstanceNo = a.Value.serverInstanceNo,
serverPublicIp = a.Value.serverPublicIp,
serverPrivateIp = a.Value.serverPrivateIp,
serverPort = a.Value.serverPort,
serverUserId = a.Value.serverUserId,
serverPassword = a.Value.serverPassword,
serverAliasName = a.Value.serverAliasName,
regionNo = a.Value.regionNo,
zoneNo = a.Value.zoneNo,
serverImageProductCode = a.Value.serverImageProductCode,
serverProductCode = a.Value.serverProductCode,
feeSystemTypeCode = a.Value.feeSystemTypeCode,
loginKeyName = a.Value.loginKeyName,
accessControlGroupConfigurationNoList_1 = a.Value.accessControlGroupConfigurationNoList_1,
accessControlGroupConfigurationNoList_2 = a.Value.accessControlGroupConfigurationNoList_2,
accessControlGroupConfigurationNoList_3 = a.Value.accessControlGroupConfigurationNoList_3,
accessControlGroupConfigurationNoList_4 = a.Value.accessControlGroupConfigurationNoList_4,
accessControlGroupConfigurationNoList_5 = a.Value.accessControlGroupConfigurationNoList_5
});
}
break;
case TableName.TBL_CLUSTER_SERVER:
TBL_CLUSTER_SERVER.Truncate();
foreach (var a in JsonConvert.DeserializeObject <List <KeyValuePair <TBL_CLUSTER_SERVER_KEY, TBL_CLUSTER_SERVER_VALUE> > >(json))
{
TBL_CLUSTER_SERVER.Insert(
new TBL_CLUSTER_SERVER_KEY
{
clusterName = a.Key.clusterName,
serverName = a.Key.serverName
},
new TBL_CLUSTER_SERVER_VALUE
{
serverRole = a.Value.serverRole
});
}
break;
default:
throw new ArgumentOutOfRangeException("unknown table");
}
}
public async Task UpSertTable(TableName tableName, List <KeyValuePair <string, string> > parameters)
{
await ReadTable(tableName);
string clusterName = "NULL";
string serverName = "NULL";
string clusterNo = "NULL";
string domainName = "NULL";
string clusterPort = "NULL";
string serverInstanceNo = "NULL";
string serverPublicIp = "NULL";
string serverPrivateIp = "NULL";
string serverPort = "NULL";
string serverUserId = "NULL";
string serverPassword = "******";
string serverAliasName = "NULL";
string regionNo = "NULL";
string zoneNo = "NULL";
string serverImageProductCode = "NULL";
string serverProductCode = "NULL";
string feeSystemTypeCode = "NULL";
string loginKeyName = "NULL";
string accessControlGroupConfigurationNoList_1 = "NULL";
string accessControlGroupConfigurationNoList_2 = "NULL";
string accessControlGroupConfigurationNoList_3 = "NULL";
string accessControlGroupConfigurationNoList_4 = "NULL";
string accessControlGroupConfigurationNoList_5 = "NULL";
string serverRole = "NULL";
string json = string.Empty;
switch (tableName)
{
case TableName.TBL_CLUSTER:
foreach (var a in parameters)
{
if (a.Key.Equals("clusterName", StringComparison.OrdinalIgnoreCase))
{
clusterName = a.Value;
}
if (a.Key.Equals("clusterNo", StringComparison.OrdinalIgnoreCase))
{
clusterNo = a.Value;
}
if (a.Key.Equals("domainName", StringComparison.OrdinalIgnoreCase))
{
domainName = a.Value;
}
if (a.Key.Equals("clusterPort", StringComparison.OrdinalIgnoreCase))
{
clusterPort = a.Value;
}
}
TBL_CLUSTER.Insert(
new TBL_CLUSTER_KEY {
clusterName = clusterName
}
, new TBL_CLUSTER_VALUE {
clusterNo = clusterNo, domainName = domainName, clusterPort = clusterPort
});
json = TBL_CLUSTER.GetJson();
File.WriteAllText(Path.Combine(AppDomain.CurrentDomain.BaseDirectory + tableName.ToString() + ".txt"), json);
break;
case TableName.TBL_SERVER:
foreach (var a in parameters)
{
if (a.Key.Equals("serverName", StringComparison.OrdinalIgnoreCase))
{
serverName = a.Value;
}
if (a.Key.Equals("serverInstanceNo", StringComparison.OrdinalIgnoreCase))
{
serverInstanceNo = a.Value;
}
if (a.Key.Equals("serverPublicIp", StringComparison.OrdinalIgnoreCase))
{
serverPublicIp = a.Value;
}
if (a.Key.Equals("serverPrivateIp", StringComparison.OrdinalIgnoreCase))
{
serverPrivateIp = a.Value;
}
if (a.Key.Equals("serverPort", StringComparison.OrdinalIgnoreCase))
{
serverPort = a.Value;
}
if (a.Key.Equals("serverUserId", StringComparison.OrdinalIgnoreCase))
{
serverUserId = a.Value;
}
if (a.Key.Equals("serverPassword", StringComparison.OrdinalIgnoreCase))
{
serverPassword = a.Value;
}
if (a.Key.Equals("serverAliasName", StringComparison.OrdinalIgnoreCase))
{
serverAliasName = a.Value;
}
if (a.Key.Equals("regionNo", StringComparison.OrdinalIgnoreCase))
{
regionNo = a.Value;
}
if (a.Key.Equals("zoneNo", StringComparison.OrdinalIgnoreCase))
{
zoneNo = a.Value;
}
if (a.Key.Equals("serverImageProductCode", StringComparison.OrdinalIgnoreCase))
{
serverImageProductCode = a.Value;
}
if (a.Key.Equals("serverProductCode", StringComparison.OrdinalIgnoreCase))
{
serverProductCode = a.Value;
}
if (a.Key.Equals("feeSystemTypeCode", StringComparison.OrdinalIgnoreCase))
{
feeSystemTypeCode = a.Value;
}
if (a.Key.Equals("loginKeyName", StringComparison.OrdinalIgnoreCase))
{
loginKeyName = a.Value;
}
if (a.Key.Equals("accessControlGroupConfigurationNoList_1", StringComparison.OrdinalIgnoreCase))
{
accessControlGroupConfigurationNoList_1 = a.Value;
}
if (a.Key.Equals("accessControlGroupConfigurationNoList_2", StringComparison.OrdinalIgnoreCase))
{
accessControlGroupConfigurationNoList_2 = a.Value;
}
if (a.Key.Equals("accessControlGroupConfigurationNoList_3", StringComparison.OrdinalIgnoreCase))
{
accessControlGroupConfigurationNoList_3 = a.Value;
}
if (a.Key.Equals("accessControlGroupConfigurationNoList_4", StringComparison.OrdinalIgnoreCase))
{
accessControlGroupConfigurationNoList_4 = a.Value;
}
if (a.Key.Equals("accessControlGroupConfigurationNoList_5", StringComparison.OrdinalIgnoreCase))
{
accessControlGroupConfigurationNoList_5 = a.Value;
}
}
TBL_SERVER.Insert(
new TBL_SERVER_KEY {
serverName = serverName
},
new TBL_SERVER_VALUE
{
serverInstanceNo = serverInstanceNo,
serverPublicIp = serverPublicIp,
serverPrivateIp = serverPrivateIp,
serverPort = serverPort,
serverUserId = serverUserId,
serverPassword = serverPassword,
serverAliasName = serverAliasName,
regionNo = regionNo,
zoneNo = zoneNo,
serverImageProductCode = serverImageProductCode,
serverProductCode = serverProductCode,
feeSystemTypeCode = feeSystemTypeCode,
loginKeyName = loginKeyName,
accessControlGroupConfigurationNoList_1 = accessControlGroupConfigurationNoList_1,
accessControlGroupConfigurationNoList_2 = accessControlGroupConfigurationNoList_2,
accessControlGroupConfigurationNoList_3 = accessControlGroupConfigurationNoList_3,
accessControlGroupConfigurationNoList_4 = accessControlGroupConfigurationNoList_4,
accessControlGroupConfigurationNoList_5 = accessControlGroupConfigurationNoList_5
});
json = TBL_SERVER.GetJson();
File.WriteAllText(Path.Combine(AppDomain.CurrentDomain.BaseDirectory + tableName.ToString() + ".txt"), json);
break;
case TableName.TBL_CLUSTER_SERVER:
foreach (var a in parameters)
{
if (a.Key.Equals("clusterName", StringComparison.OrdinalIgnoreCase))
{
clusterName = a.Value;
}
if (a.Key.Equals("serverName", StringComparison.OrdinalIgnoreCase))
{
serverName = a.Value;
}
if (a.Key.Equals("serverRole", StringComparison.OrdinalIgnoreCase))
{
serverRole = a.Value;
}
}
TBL_CLUSTER_SERVER.Insert(
new TBL_CLUSTER_SERVER_KEY
{
clusterName = clusterName,
serverName = serverName
},
new TBL_CLUSTER_SERVER_VALUE
{
serverRole = serverRole
});
json = TBL_CLUSTER_SERVER.GetJson();
File.WriteAllText(Path.Combine(AppDomain.CurrentDomain.BaseDirectory + tableName.ToString() + ".txt"), json);
break;
default:
throw new ArgumentOutOfRangeException("unknown table");
}
await UploadFileToObject(tableName);
}