public MonitoringRegistrationDetailResponse GetMonitoringRegistrationDetailResponseFromDB(string MonitoringRegistrationName) { MonitoringRegistrationDetailResponse monitoringRegistrationDetailResponse = new MonitoringRegistrationDetailResponse(); SettingFacade fac = new SettingFacade(this.CurrentClient.ApplicationDBConnectionString); DataTable dt = fac.GetDPMRegistrationByName(MonitoringRegistrationName); if (dt != null && dt.Rows != null && dt.Rows.Count > 0) { monitoringRegistrationDetailResponse.messages = new Messages(); monitoringRegistrationDetailResponse.messages.registration = new Registration(); monitoringRegistrationDetailResponse.messages.registration.reference = Convert.ToString(dt.Rows[0]["MonitoringRegistrationName"]); monitoringRegistrationDetailResponse.messages.registration.productId = Convert.ToString(dt.Rows[0]["productId"]); monitoringRegistrationDetailResponse.messages.registration.versionId = Convert.ToString(dt.Rows[0]["versionId"]); monitoringRegistrationDetailResponse.messages.registration.email = Convert.ToString(dt.Rows[0]["email"]); monitoringRegistrationDetailResponse.messages.registration.fileTransferProfile = Convert.ToString(dt.Rows[0]["fileTransferProfile"]); monitoringRegistrationDetailResponse.messages.registration.description = Convert.ToString(dt.Rows[0]["description"]); monitoringRegistrationDetailResponse.messages.registration.deliveryTrigger = Convert.ToString(dt.Rows[0]["deliveryTrigger"]); monitoringRegistrationDetailResponse.messages.registration.deliveryFrequency = Convert.ToString(dt.Rows[0]["deliveryFrequency"]); monitoringRegistrationDetailResponse.messages.registration.seedData = Convert.ToBoolean(dt.Rows[0]["seedData"]); monitoringRegistrationDetailResponse.messages.registration.blockIds = Convert.ToString(dt.Rows[0]["blockIds"]); monitoringRegistrationDetailResponse.messages.dunsCount = dt.Rows[0]["dunsCount"] != DBNull.Value ? Convert.ToInt32(dt.Rows[0]["dunsCount"]) : 0; monitoringRegistrationDetailResponse.messages.registration.Tags = Convert.ToString(dt.Rows[0]["Tags"]); monitoringRegistrationDetailResponse.messages.registration.CredentialId = dt.Rows[0]["CredentialId"] != DBNull.Value ? Convert.ToInt32(dt.Rows[0]["CredentialId"]) : 0; monitoringRegistrationDetailResponse.messages.registration.CredentialName = dt.Rows[0]["CredentialName"] != DBNull.Value ? Convert.ToString(dt.Rows[0]["CredentialName"]) : string.Empty; monitoringRegistrationDetailResponse.messages.registration.AuthToken = dt.Rows[0]["AuthToken"] != DBNull.Value ? Convert.ToString(dt.Rows[0]["AuthToken"]) : string.Empty; } return(monitoringRegistrationDetailResponse); }