Пример #1
0
        public HubList Post([FromBody] HubList hubList)
        {
            HubList hubList1 = new HubList();

            hubList1.InsertHubList(hubList);
            return(hubList);
        }
Пример #2
0
    //Insert HubList to database
    public void insertHubList(HubList hList)
    {
        SqlConnection con = null;
        SqlCommand    cmd1;
        SqlCommand    cmd2;

        try
        {
            con = connect("DBConnectionString");                               // create the connection

            String cStr1 = BuildInsertCommand(hList);                          // helper method to build the insert string

            cmd1 = CreateCommand(cStr1, con);                                  // create the command
            Int32 CreatedListID = Convert.ToInt32(cmd1.ExecuteScalar());       // execute the command

            String cStr2 = BuildInsertCommandUser_Lists(hList, CreatedListID); // helper method to build the insert string

            cmd2 = CreateCommand(cStr2, con);                                  // create the command
            cmd2.ExecuteScalar();
        }
        catch (Exception ex)
        {
            Console.WriteLine("Inside catch block. Exception: {0}", ex.Message);
            throw (ex);
        }
        finally
        {
            if (con != null)
            {
                con.Close();
            }
        }
    }
Пример #3
0
    private String BuildInsertCommandUser_Lists(HubList hlist, int CreatedListID)
    {
        String        command;
        StringBuilder sb = new StringBuilder();

        // use a string builder to create the dynamic string
        sb.AppendFormat("Values({0},{1})", hlist.OwnerUserID, CreatedListID);
        String prefix = "INSERT INTO User_Lists_CS " + "(UserID,ListID)";

        command = prefix + sb.ToString();
        return(command);
    }
Пример #4
0
        public TypeScriptHubList Create(HubList hubList)
        {
            var typeScriptClasslist       = new List <TypeScriptHub>();
            var typeScriptHubClassFactory = new TypeScriptHubClassFactory();

            foreach (var hub in hubList.Hubs)
            {
                var typeScriptClass = typeScriptHubClassFactory.Create(hub.HubType, hub.HubClientType);
                typeScriptClasslist.Add(typeScriptClass);
            }

            return(new TypeScriptHubList(typeScriptClasslist));
        }
Пример #5
0
        public int Delete(int UserID, int ListID)
        {
            HubList myList      = new HubList();
            User    myUser      = new User();
            int     CheckResult = myUser.CheckListOwnerShip(UserID, ListID);

            //1 Means he is the TableOwner
            if (CheckResult == 1)
            {
                myList.DeleteHubList(ListID, UserID);
            }
            return(CheckResult);
        }
Пример #6
0
    //--------------------------------------------------------------------
    // Build the Insert command String
    //--------------------------------------------------------------------
    private String BuildInsertCommand(HubList hlist)
    {
        String        command;
        StringBuilder sb = new StringBuilder();

        // use a string builder to create the dynamic string
        sb.AppendFormat("Values({0},'{1}','{2}','{3}')", hlist.OwnerUserID, hlist.ListName, hlist.ImageURL, hlist.ListDescription);
        String prefix = "INSERT INTO HubList_CS " + "(OwnerUserID,ListName,ImageURL,ListDescription) ";

        command  = prefix + sb.ToString();
        command += "SELECT SCOPE_IDENTITY()";

        return(command);
    }
Пример #7
0
    //Get All Lists from DB
    public List <HubList> getHubList()
    {
        SqlConnection con = null;

        //  SqlConnection con2 = null;
        try
        {
            con = connect("DBConnectionString"); // create a connection to the database using the connection String defined in the web config file

            String     selectSTR = "SELECT * FROM HubList_CS";
            SqlCommand cmd       = new SqlCommand(selectSTR, con);
            //  SqlCommand cmd2;

            // get a reader
            SqlDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); // CommandBehavior.CloseConnection: the connection will be closed after reading has reached the end
                                                                                   // SqlDataReader dr2;

            List <HubList> HubLists = new List <HubList>();

            while (dr.Read())
            {   // Read till the end of the data into a row
                HubList hubList = new HubList();

                hubList.ListID          = Convert.ToInt32(dr["ListID"]);
                hubList.OwnerUserID     = Convert.ToInt32(dr["OwnerUserID"]);
                hubList.ListName        = (string)dr["ListName"];
                hubList.ImageURL        = (string)dr["ImageURL"];
                hubList.ListDescription = (string)dr["ListDescription"];

                HubLists.Add(hubList);
            }

            con.Close();
            cmd.Connection.Close();

            return(HubLists);
        }
        catch (Exception ex)
        {
            // write to log
            throw (ex);
        }
        finally
        {
            if (con != null)
            {
                con.Close();
            }
        }
    }
Пример #8
0
    //Get All Lists from DB by USERID
    public List <HubList> getUserLists(int userID)
    {
        SqlConnection con = null;

        //  SqlConnection con2 = null;
        try
        {
            con = connect("DBConnectionString"); // create a connection to the database using the connection String defined in the web config file

            String selectSTR = "SELECT HL.ListID,ListName,ListDescription,OwnerUserID,ImageURL FROM HubList_CS AS HL";
            selectSTR += " INNER JOIN User_Lists_CS AS UL ON HL.ListID = UL.ListID";
            selectSTR += " INNER JOIN User_CS AS U ON U.UserID = UL.UserID";
            selectSTR += " WHERE U.UserID=" + userID;
            SqlCommand cmd = new SqlCommand(selectSTR, con);

            SqlDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); // CommandBehavior.CloseConnection: the connection will be closed after reading has reached the end

            List <HubList> HubLists = new List <HubList>();

            while (dr.Read())
            {
                HubList hubList = new HubList();
                hubList.ListID          = Convert.ToInt32(dr["ListID"]);
                hubList.OwnerUserID     = Convert.ToInt32(dr["OwnerUserID"]);
                hubList.ListName        = (string)dr["ListName"];
                hubList.ImageURL        = (string)dr["ImageURL"];
                hubList.ListDescription = (string)dr["ListDescription"];
                HubLists.Add(hubList);
            }

            con.Close();
            cmd.Connection.Close();

            return(HubLists);
        }
        catch (Exception ex)
        {
            throw (ex);
        }
        finally
        {
            if (con != null)
            {
                con.Close();
            }
        }
    }
Пример #9
0
        public SoftEtherList <HubList> GetList()
        {
            var rawData = _softEther.CallMethod("EnumHub");

            return(HubList.DeserializeMany(rawData));
        }
Пример #10
0
 public void RemoveHub(NodePeer h)
 {
     HubList.Remove(h);
 }
Пример #11
0
 public void AddHub(NodePeer h)
 {
     HubList.Add(h);
 }
Пример #12
0
 public void AddHubs(List <NodePeer> hubs)
 {
     HubList.AddRange(hubs);
 }
Пример #13
0
        // GET api/<controller>
        public IEnumerable <HubList> Get()
        {
            HubList hl = new HubList();

            return(hl.getHubLists());
        }