private async Task VPDbServerExistsCheck()
        {
            StatusUpdate(Status.Working);
            string returnMessage = string.Empty;
            bool   serverExists  = false;
            Dictionary <string, string> dicCloudDBInstance = new Dictionary <string, string>();

            try
            {
                ConfigSaveAllItem();

                string json     = string.Empty;
                var    settings = new JsonSerializerSettings
                {
                    NullValueHandling     = NullValueHandling.Ignore,
                    MissingMemberHandling = MissingMemberHandling.Ignore
                };

                json = await GetZoneListAsync();

                getZoneList getZoneList = JsonConvert.DeserializeObject <getZoneList>(json, settings);
                List <zone> zones       = getZoneList.getZoneListResponse.zoneList;

                foreach (var a in zones)
                {
                    string InstancesOfZoneJson = string.Empty;
                    nlog.Warn(string.Format("{0},{1},{2},{3},{4}", a.zoneNo, a.zoneName, a.zoneCode, a.zoneDescription, a.regionNo));
                    InstancesOfZoneJson = await GetVPCloudDBInstanceListAsync(a.zoneNo.ToString());

                    dicCloudDBInstance.Add(a.zoneNo.ToString(), InstancesOfZoneJson); // stirng dic
                    nlog.Warn(InstancesOfZoneJson);
                }

                foreach (var a in dicCloudDBInstance)
                {
                    getCloudMssqlInstanceList getCloudMssqlInstanceList = JsonConvert.DeserializeObject <getCloudMssqlInstanceList>(a.Value, settings);
                    List <CloudMssqlInstance> CloudMssqlInstanceList    = getCloudMssqlInstanceList.getCloudMssqlInstanceListResponse.cloudMssqlInstanceList;
                    foreach (var b in CloudMssqlInstanceList)
                    {
                        nlog.Warn(b.cloudMssqlInstanceNo);
                        if (b.cloudMssqlInstanceNo.Equals(textCloudDbInstanceNo.Text.Trim()))
                        {
                            serverExists = true;
                            break;
                        }
                    }
                }
                if (serverExists)
                {
                    MessageBox.Show("DatabaseInfo Connection test was successful");
                    DatabaseInfoTested = true;
                }
                if (!serverExists)
                {
                    MessageBox.Show(string.Format("{0} : Server dose not exists", CallResult.Fail.ToString()));
                    DatabaseInfoTested = false;
                }
            }
            catch (Exception ex)
            {
                nlog.Error(string.Format("{0}, {1}", ex.Message, ex.StackTrace));
                MessageBox.Show(string.Format("{0} : {1}", CallResult.Fail.ToString(), ex.Message));
            }

            StatusUpdate(Status.Completed);
        }
Пример #2
0
        private async void buttonDbServerExistsCheck_Click(object sender, EventArgs e)
        {
            nlog.Warn("BackupStorageFileList Started");
            StatusUpdate(Status.Working);
            string returnMessage = string.Empty;
            bool   serverExists  = false;
            Dictionary <string, string> cloudDBInstanceLists = new Dictionary <string, string>();

            try
            {
                ConfigSaveAllItem();

                string json     = string.Empty;
                var    settings = new JsonSerializerSettings
                {
                    NullValueHandling     = NullValueHandling.Ignore,
                    MissingMemberHandling = MissingMemberHandling.Ignore
                };

                json = await GetZoneListAsync();

                getZoneList getZoneList = JsonConvert.DeserializeObject <getZoneList>(json, settings);
                List <zone> zones       = getZoneList.getZoneListResponse.zoneList;

                foreach (var a in zones)
                {
                    string InstancesOfZoneJson = string.Empty;
                    nlog.Warn(string.Format("{0},{1},{2},{3},{4}", a.zoneNo, a.zoneName, a.zoneCode, a.zoneDescription, a.regionNo));
                    InstancesOfZoneJson = await GetCloudDBInstanceListAsync(a.zoneNo.ToString());

                    cloudDBInstanceLists.Add(a.zoneNo.ToString(), InstancesOfZoneJson);
                    nlog.Warn(InstancesOfZoneJson);
                }

                foreach (var a in cloudDBInstanceLists)
                {
                    getCloudDBInstanceList     getCloudDBInstanceList = JsonConvert.DeserializeObject <getCloudDBInstanceList>(a.Value, settings);
                    List <cloudDBInstanceList> cloudDBInstanceList    = getCloudDBInstanceList.getCloudDBInstanceListResponse.cloudDBInstanceList;
                    foreach (var b in cloudDBInstanceList)
                    {
                        nlog.Warn(b.cloudDBInstanceNo);
                        //if (b.cloudDBInstanceNo == textCloudDbInstanceNo.Text)
                        if (b.cloudDBInstanceNo.Equals(textCloudDbInstanceNo.Text.Trim()))
                        {
                            serverExists = true;
                            MessageBox.Show(CallResult.Success.ToString());
                            break;
                        }
                    }
                }
                if (!serverExists)
                {
                    MessageBox.Show(string.Format("{0} : Server dose not exists", CallResult.Fail.ToString()));
                }
            }
            catch (Exception ex)
            {
                nlog.Error(string.Format("{0}, {1}", ex.Message, ex.StackTrace));
                MessageBox.Show(string.Format("{0} : {1}", CallResult.Fail.ToString(), ex.Message));
            }

            StatusUpdate(Status.Completed);
            nlog.Warn("BackupStorageFileList Completed");
        }