public async Task UpSertTable(TableName tableName, List <KeyValuePair <string, string> > parameters, string filePath = "")
{
await ReadTable(tableName, filePath);
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 time = "NULL";
string healthInfo = "NULL";
string json = string.Empty;
string key = string.Empty;
if (filePath.Trim().Length > 0)
{
key = filePath + @"\" + tableName.ToString();
}
else
{
key = tableName.ToString();
}
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 + key + ".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 + key + ".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 + key + ".txt"), json);
break;
case TableName.TBL_HEALTH_INFO:
foreach (var a in parameters)
{
if (a.Key.Equals("serverName", StringComparison.OrdinalIgnoreCase))
{
serverName = a.Value;
}
if (a.Key.Equals("time", StringComparison.OrdinalIgnoreCase))
{
time = a.Value;
}
if (a.Key.Equals("healthInfo", StringComparison.OrdinalIgnoreCase))
{
healthInfo = a.Value;
}
}
TBL_HEALTH_INFO.Insert(
new TBL_HEALTH_INFO_KEY
{
serverName = serverName,
time = time
},
new TBL_HEALTH_INFO_VALUE
{
healthInfo = healthInfo
});
json = TBL_HEALTH_INFO.GetJson();
File.WriteAllText(Path.Combine(AppDomain.CurrentDomain.BaseDirectory + key + ".txt"), json);
break;
default:
throw new ArgumentOutOfRangeException("unknown table");
}
await UploadFileToObject(tableName, filePath);
}
public async Task DeleteTable(TableName tableName, List <KeyValuePair <string, string> > parameters, string filePath = "")
{
await ReadTable(tableName, filePath);
string clusterName = string.Empty;
string serverName = string.Empty;
string time = string.Empty;
string json = string.Empty;
string key = string.Empty;
if (filePath.Trim().Length > 0)
{
key = filePath + @"\" + tableName.ToString();
}
else
{
key = tableName.ToString();
}
switch (tableName)
{
case TableName.TBL_CLUSTER:
foreach (var a in parameters)
{
if (a.Key.Equals("clusterName", StringComparison.OrdinalIgnoreCase))
{
clusterName = a.Value;
}
}
TBL_CLUSTER.Delete(new TBL_CLUSTER_KEY {
clusterName = clusterName
});
json = TBL_CLUSTER.GetJson();
File.WriteAllText(Path.Combine(AppDomain.CurrentDomain.BaseDirectory + key + ".txt"), json);
break;
case TableName.TBL_SERVER:
foreach (var a in parameters)
{
if (a.Key.Equals("serverName", StringComparison.OrdinalIgnoreCase))
{
serverName = a.Value;
}
}
TBL_SERVER.Delete(new TBL_SERVER_KEY {
serverName = serverName
});
json = TBL_SERVER.GetJson();
File.WriteAllText(Path.Combine(AppDomain.CurrentDomain.BaseDirectory + key + ".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;
}
}
TBL_CLUSTER_SERVER.Delete(new TBL_CLUSTER_SERVER_KEY {
clusterName = clusterName, serverName = serverName
});
json = TBL_CLUSTER_SERVER.GetJson();
File.WriteAllText(Path.Combine(AppDomain.CurrentDomain.BaseDirectory + key + ".txt"), json);
break;
case TableName.TBL_HEALTH_INFO:
foreach (var a in parameters)
{
if (a.Key.Equals("serverName", StringComparison.OrdinalIgnoreCase))
{
serverName = a.Value;
}
if (a.Key.Equals("time", StringComparison.OrdinalIgnoreCase))
{
time = a.Value;
}
}
TBL_HEALTH_INFO.Delete(new TBL_HEALTH_INFO_KEY {
serverName = serverName, time = time
});
json = TBL_HEALTH_INFO.GetJson();
File.WriteAllText(Path.Combine(AppDomain.CurrentDomain.BaseDirectory + key + ".txt"), json);
break;
default:
throw new ArgumentOutOfRangeException("unknown table");
}
await UploadFileToObject(tableName, filePath);
}
