protected void ArtistsTable_RowCommand(object sender, GridViewCommandEventArgs e)
        {
            int rowIndex = Convert.ToInt32(e.CommandArgument);
            // Retrieve the row that contains the button
            // from the Rows collection.
            GridViewRow row = ArtistsTable.Rows[rowIndex];
            HiddenField hfd = row.FindControl("HiddenFieldUserId") as HiddenField;

            switch (e.CommandName)
            {
                case "DeleteUser":
                    if (hfd != null)
                    {
                        long targetId = 0;
                        if (!long.TryParse(hfd.Value, out targetId))
                            targetId = 0;
                        if (targetId > 0)
                        {
                            long sourceId = Util.UserId;
                            using (Database db = new MySqlDatabase())
                            {
                                db.DeleteRelation(sourceId, targetId, 1);
                            }
                        }
                    }
                    break;

                case "RelateUser":
                    if (hfd != null)
                    {
                        long targetId = 0;
                        if (!long.TryParse(hfd.Value, out targetId))
                            targetId = 0;
                        if (targetId > 0)
                        {
                            long sourceId = Util.UserId;
                            using (Database db = new MySqlDatabase())
                            {
                                UserInfo targetUi = db.GetUser(targetId);
                                ClientInfo targetCI = db.GetClientInfo(targetId);

                                RequestConfirmation(targetUi.Email, 1, targetCI.FirstName, targetCI.LastName);
                            }
                        }
                    }
                    break;
            }
            FillManagedRelationsTable();
        }
        //For Deletion Relations
        protected void dlMyRelations_ItemCommand(object source, DataListCommandEventArgs e)
        {
            int rowIndex = Convert.ToInt32(e.CommandArgument);
            // Retrieve the row that contains the button
            // from the Rows collection.

            switch (e.CommandName)
            {
                case "DeleteUser":
                    if (rowIndex > 0)
                    {
                        long targetId = 0;
                        if (!long.TryParse(rowIndex.ToString(), out targetId))
                            targetId = 0;
                        if (targetId > 0)
                        {
                            long sourceId = Util.UserId;
                            using (Database db = new MySqlDatabase())
                            {
                                db.DeleteRelation(sourceId, targetId, 1);
                            }
                        }
                    }
                    break;

                case "RelateUser":
                    if (rowIndex > 0)
                    {
                        long targetId = 0;
                        if (!long.TryParse(rowIndex.ToString(), out targetId))
                            targetId = 0;
                        if (targetId > 0)
                        {
                            long sourceId = Util.UserId;
                            using (Database db = new MySqlDatabase())
                            {
                                UserInfo targetUi = db.GetUser(targetId);
                                ClientInfo targetCI = db.GetClientInfo(targetId);

                                RequestConfirmation(targetUi.Email, 1, targetCI.FirstName, targetCI.LastName);
                            }
                        }
                    }
                    break;
                case "RevokeUser":
                    if (rowIndex > 0)
                    {

                        long targetId = 0;
                        if (!long.TryParse(rowIndex.ToString(), out targetId))
                            targetId = 0;
                        if (targetId > 0)
                        {
                            long sourceId = Util.UserId;
                            using (Database db = new MySqlDatabase())
                            {
                                db.DeleteRelation(sourceId, targetId, 2);
                            }
                        }
                    }
                    break;
            }
            FillManagedRelationsTable();
            FillInvitationsTable();
            FillManagedUsersTable();
        }
        //For Deletion ManAcc Relations
        protected void dlMyManagedRelations_ItemCommand(object source, DataListCommandEventArgs e)
        {
            int rowIndex = Convert.ToInt32(e.CommandArgument);
            string url = null;

            switch (e.CommandName)
            {
                case "AddTrack":
                    {

                        if (rowIndex > 0)
                        {
                            url = string.Format("~/Member/RegisterDocManaged.aspx?id={0}", rowIndex);
                        }
                    }
                    break;

                case "ViewTracks":
                    {

                        if (rowIndex > 0)
                        {
                            url = string.Format("~/Member/ViewDocManaged.aspx?id={0}", rowIndex);
                        }
                    }
                    break;
                case "DeleteUser":
                    if (rowIndex > 0)
                    {
                        long targetId = 0;
                        if (!long.TryParse(rowIndex.ToString(), out targetId))
                            targetId = 0;
                        if (targetId > 0)
                        {
                            long sourceId = Util.UserId;
                            using (Database db = new MySqlDatabase())
                            {
                                db.DeleteRelation(sourceId, targetId, 1);
                            }
                            FillManagedUsersTable();

                            string mainAccUserFirstName = string.Empty;
                            string mainAccUserLastName = string.Empty;
                            string userFirstaName = string.Empty;
                            string userEmail = string.Empty;

                            using (Database db = new MySqlDatabase())
                            {
                                ClientInfo ci = db.GetClientInfo(sourceId);

                                mainAccUserFirstName = ci.FirstName;
                                mainAccUserLastName = ci.Language;
                            }

                            using (Database db = new MySqlDatabase())
                            {
                                UserInfo ui = db.GetUser(targetId);
                                ClientInfo ci = db.GetClientInfo(targetId);

                                userFirstaName = ci.FirstName;

                                userEmail = ui.Email;
                            }

                            sendMail(mainAccUserFirstName, mainAccUserLastName, userFirstaName, userEmail);
                        }

                        FillManagedRelationsTable();
                        FillInvitationsTable();
                        FillManagedUsersTable();
                    }
                    break;
            }
            if (!string.IsNullOrEmpty(url))
                Response.Redirect(url, false);
        }