public AstroObjectByName(string AstroObjectName)
            {
                strErrorMsg = "";
                SqlConnection myConnection2 = Database.GetConnectionAstroObjects();

                try
                {
                    myConnection2.Open();
                    SqlDataAdapter Cmd2 = new SqlDataAdapter("spGetAstroObjects", myConnection2);

                    Cmd2.SelectCommand.CommandType = CommandType.StoredProcedure;

                    SqlParameter CustParm = new SqlParameter("@pAstroObjectName", SqlDbType.NVarChar);
                    CustParm.Value = AstroObjectName;
                    Cmd2.SelectCommand.Parameters.Add(CustParm);

                    ds = new AstroObjectsDataset();

                    Cmd2.Fill(ds, ds.Tables[0].TableName);
                }
                catch (Exception ex)
                {
                    throw
                        WWTWebService.RaiseException("GetAstroObjectsByName", "http://WWTWebServices", ex.Message, "2000", "GetAstroObjectsByName", WWTWebService.FaultCode.Client);
                }
                finally
                {
                    if (myConnection2.State == ConnectionState.Open)
                    {
                        myConnection2.Close();
                    }
                }
            }
Exemplo n.º 2
0
        public AstroObjectsDataset GetAstroObjectsInCatalog(string CatalogName)
        {
            AstroObjectServices.AstroObjectDataInCatalog x3 = new AstroObjectServices.AstroObjectDataInCatalog(CatalogName);

            AstroObjectsDataset dsAstroObjectData = x3.dsAstroObjectData;

            return(dsAstroObjectData);
        }
Exemplo n.º 3
0
        public AstroObjectsDataset GetAstroObjectsByName(string AstroObjectName)
        {
            AstroObjectServices.AstroObjectByName x1 = new AstroObjectServices.AstroObjectByName(AstroObjectName);

            AstroObjectsDataset dsAstroObjectData = x1.dsAstroObjectData;

            return(dsAstroObjectData);
        }
Exemplo n.º 4
0
        public AstroObjectsDataset GetAstroObjectsByRaDec(float Ra, float Dec, float PlusMinusArcSecs)
        {
            AstroObjectServices.AstroObjectDataByRaDec x2 = new AstroObjectServices.AstroObjectDataByRaDec(Ra, Dec, PlusMinusArcSecs);

            AstroObjectsDataset dsAstroObjectData = x2.dsAstroObjectData;

            return(dsAstroObjectData);
        }
Exemplo n.º 5
0
            public AstroObjectDataByRaDec(float Ra, float Dec, float PlusMinusArcSecs)
            {
                strErrorMsg = "";
                SqlConnection myConnection2 = Database.GetConnectionAstroObjects();

                try
                {

                    myConnection2.Open();
                    SqlDataAdapter Cmd2 = new SqlDataAdapter("spGetAstroObjects", myConnection2);

                    Cmd2.SelectCommand.CommandType = CommandType.StoredProcedure;

                    SqlParameter CustParm = new SqlParameter("@pRa", SqlDbType.Float);
                    CustParm.Value = Ra;
                    Cmd2.SelectCommand.Parameters.Add(CustParm);

                    SqlParameter CustParm2 = new SqlParameter("@pDec", SqlDbType.Float);
                    CustParm2.Value = Dec;
                    Cmd2.SelectCommand.Parameters.Add(CustParm2);

                    SqlParameter CustParm3 = new SqlParameter("@pPlusMinusArcSecs", SqlDbType.Float);
                    CustParm3.Value = PlusMinusArcSecs;
                    Cmd2.SelectCommand.Parameters.Add(CustParm3);

                    ds = new AstroObjectsDataset();

                    Cmd2.Fill(ds, ds.Tables[0].TableName);
                }
                catch (Exception ex)
                {
                    throw
                        WWTWebService.RaiseException("GetAstroObjectByRADec", "http://WWTWebServices", ex.Message, "2000", "GetAstroObjectByRADec", WWTWebService.FaultCode.Client);
                }
                finally
                {
                    if (myConnection2.State == ConnectionState.Open)
                        myConnection2.Close();
                }


            }
            public AstroObjectDataByRaDec(float Ra, float Dec, float PlusMinusArcSecs)
            {
                strErrorMsg = "";
                SqlConnection myConnection2 = Database.GetConnectionAstroObjects();

                try
                {
                    myConnection2.Open();
                    SqlDataAdapter Cmd2 = new SqlDataAdapter("spGetAstroObjects", myConnection2);

                    Cmd2.SelectCommand.CommandType = CommandType.StoredProcedure;

                    SqlParameter CustParm = new SqlParameter("@pRa", SqlDbType.Float);
                    CustParm.Value = Ra;
                    Cmd2.SelectCommand.Parameters.Add(CustParm);

                    SqlParameter CustParm2 = new SqlParameter("@pDec", SqlDbType.Float);
                    CustParm2.Value = Dec;
                    Cmd2.SelectCommand.Parameters.Add(CustParm2);

                    SqlParameter CustParm3 = new SqlParameter("@pPlusMinusArcSecs", SqlDbType.Float);
                    CustParm3.Value = PlusMinusArcSecs;
                    Cmd2.SelectCommand.Parameters.Add(CustParm3);

                    ds = new AstroObjectsDataset();

                    Cmd2.Fill(ds, ds.Tables[0].TableName);
                }
                catch (Exception ex)
                {
                    throw
                        WWTWebService.RaiseException("GetAstroObjectByRADec", "http://WWTWebServices", ex.Message, "2000", "GetAstroObjectByRADec", WWTWebService.FaultCode.Client);
                }
                finally
                {
                    if (myConnection2.State == ConnectionState.Open)
                    {
                        myConnection2.Close();
                    }
                }
            }
Exemplo n.º 7
0
            public AstroObjectByName(string AstroObjectName)
            {
                strErrorMsg = "";
                SqlConnection myConnection2 = Database.GetConnectionAstroObjects();

                try
                {

                    myConnection2.Open();
                    SqlDataAdapter Cmd2 = new SqlDataAdapter("spGetAstroObjects", myConnection2);

                    Cmd2.SelectCommand.CommandType = CommandType.StoredProcedure;

                    SqlParameter CustParm = new SqlParameter("@pAstroObjectName", SqlDbType.NVarChar);
                    CustParm.Value = AstroObjectName;
                    Cmd2.SelectCommand.Parameters.Add(CustParm);

                    ds = new AstroObjectsDataset();

                    Cmd2.Fill(ds, ds.Tables[0].TableName);
                }
                catch (Exception ex)
                {
                    throw
                        WWTWebService.RaiseException("GetAstroObjectsByName", "http://WWTWebServices", ex.Message, "2000", "GetAstroObjectsByName", WWTWebService.FaultCode.Client);
                }
                finally
                {
                    if (myConnection2.State == ConnectionState.Open)
                        myConnection2.Close();
                }

            }
Exemplo n.º 8
0
        internal static TourPlace FromAstroObjectsRow(AstroObjectsDataset.spGetAstroObjectsRow row)
        {
            TourPlace newPlace = new TourPlace();

            string seperator = "";

            string name = "";

            if (!row.IsPopularName1Null() && !String.IsNullOrEmpty(row.PopularName1) )
            {
                name = ProperCaps(row.PopularName1);
                seperator = ";";
            }

            if (!row.IsMessierNameNull() && !String.IsNullOrEmpty(row.MessierName))
            {
                name = name + seperator + row.MessierName;
                seperator = ";";
            }

            if (!row.IsNGCNameNull() && !String.IsNullOrEmpty(row.NGCName))
            {
                name = name + seperator + row.NGCName;
                seperator = ";";
            }

            newPlace.name = name;
            newPlace.Type = ImageSetType.Sky;
            newPlace.Lat = row.Dec2000;
            newPlace.Lng = row.Ra2000/15;
            newPlace.constellation = Constellations.Abbreviation(row.ConstellationName);
            newPlace.Classification = Classification.Galaxy; //(Classification)Enum.Parse(typeof(Classification), place.Attributes["Classification"].Value);
            newPlace.magnitude = row.IsVisualMagnitudeNull() ? row.VisualMagnitude : 0;
            newPlace.AngularSize = 0; // todo fix this
            newPlace.ZoomLevel = .00009;
            return newPlace;
        }