Wednesday 21 October 2015

Edit map using Oracle Map Editor


  1. Installing the USER_SDO_EDIT_SESSIONS View
  2. Making a MapViewer Data Source Editable
  3. Launching the MapViewer Editor and Logging In
  4. Selecting a Data Source and Creating a New Session
  5. Adding Data Layers to a Session

Wednesday 14 October 2015

RadGrid Reduce the Filter Menu Options

protected void RadGrid1_Init(object sender, System.EventArgs e) { GridFilterMenu menu = RadGrid1.FilterMenu; int i = 0; while (i < menu.Items.Count) { if (menu.Items[i].Text == "NoFilter" ||
menu.Items[i].Text == "Contains" || menu.Items[i].Text == "EqualTo"
|| menu.Items[i].Text == "GreaterThan" ||
menu.Items[i].Text == "LessThan") { i++; } else { menu.Items.RemoveAt(i); } } }

Localizing GridFilterMenu to Arabic

protected void Page_Load(object sender, EventArgs e)
        {
            if (!Page.IsPostBack)
            {
                Telerik.Web.UI.GridFilterMenu menu = RadGrid1.FilterMenu;
                foreach (Telerik.Web.UI.RadMenuItem item in menu.Items)
                {
                    switch (item.Text)
                    {
                        case "NoFilter":
                            item.Text = "بدون فلترة"; break;
                        case "Contains":
                            item.Text = "يحتوي على"; break;
                        case "DoesNotContain":
                            item.Text = "لا يحتوي على"; break;
                        case "StartsWith":
                            item.Text = "يبدأ بـ"; break;
                        case "EndsWith":
                            item.Text = "ينتهي بـ"; break;
                        case "EqualTo":
                            item.Text = "يساوي"; break;
                        case "NotEqualTo":
                            item.Text = "لا يساوي"; break;
                        case "GreaterThan":
                            item.Text = "أكبر من"; break;
                        case "LessThan":
                            item.Text = "أقل من"; break;
                        case "GreaterThanOrEqualTo":
                            item.Text = "أكبر من أو يساوي"; break;
                        case "LessThanOrEqualTo":
                            item.Text = "أقل من أو يساوي"; break;
                        case "Between":
                            item.Text = "بين"; break;
                        case "NotBetween":
                            item.Text = "ليس من بين"; break;
                        case "IsEmpty":
                            item.Text = "فارغ"; break;
                        case "NotIsEmpty":
                            item.Text = "غير فارغ"; break;
                        case "IsNull":
                            item.Text = "لا شيء"; break;
                        case "NotIsNull":
                            item.Text = "بلا لا شيء"; break;
                        case "Custom":
                            item.Text = "مخصص"; break;
                    }
                }
            }

        }

Wednesday 7 October 2015

general insert into geom

INSERT INTO user_sdo_geom_metadata
    (TABLE_NAME,
     COLUMN_NAME,
     DIMINFO,
     SRID)
  VALUES (
  'spatialTableOrViewName',
  'SHAPE',

(
select diminfo from user_sdo_geom_metadata where table_name = upper('LB_INTERNATIAL_BORDERS_GIS')
)

,
  28191   -- SRID
);
commit;


Update

update user_sdo_geom_metadata
    set DIMINFO=
  (
select diminfo from user_sdo_geom_metadata where table_name = upper('BACKGROUND')
)
where table_name like 'MB_%' or table_name like 'MP_%';

Monday 5 October 2015

DNN Spot rotator

DNN spot rotator  is a DNN module which enables you to create slider and customize it's template

To use it, download it, and create a new template, inside the template body past the following


<style type="text/css">
    .sliderContainer {
        direction: rtl;
        text-align: right;
    }

        .sliderContainer .nextBtn a {
            color: rgba(255, 255, 255, 0.00);
            width: 27px;
            height: 27px;
            position: absolute;
            top: 50%;
            right: 0;
            z-index: 999;
            padding-top: 10px;
            padding-bottom: 10px;
            cursor: pointer;
            background-color: rgba(255, 255, 255, 0.42);
            background: center url('/images/next.png') no-repeat;
            opacity: 0.5;
            -moz-transition: opacity ease-in-out 500ms;
            -o-transition: opacity ease-in-out 500ms;
            -webkit-transition: opacity ease-in-out 500ms;
            transition: opacity ease-in-out 500ms;
        }

        .sliderContainer .prevBtn a {
            color: rgba(255, 255, 255, 0.00);
            width: 27px;
            height: 27px;
            position: absolute;
            top: 50%;
            left: 0;
            z-index: 999;
            padding-top: 10px;
            padding-bottom: 10px;
            cursor: pointer;
            background-color: rgba(255, 255, 255, 0.42);
            background: center url('/images/prev.png') no-repeat;
            opacity: 0.5;
            -moz-transition: opacity ease-in-out 500ms;
            -o-transition: opacity ease-in-out 500ms;
            -webkit-transition: opacity ease-in-out 500ms;
            transition: opacity ease-in-out 500ms;
        }

        .sliderContainer .nextBtn:hover, .sliderContainer .prevBtn:hover {
            opacity: 1;
        }

        .sliderContainer .slides {
            float: right;
        }

            .sliderContainer .slides img {
                border: 1px solid #D7D7D7;
            }

        .sliderContainer .slidePager {
            float: right;
        }

            .sliderContainer .slidePager ul {
                position: relative;
                display: inline-block;
                width: 100%;
            }

                .sliderContainer .slidePager ul li {
                    display: block;
                    padding: 2px;
                    padding-right: 5px;
                    line-height: 1.6em;
                    border-bottom: 1px solid #D7D7D7;
                }

                    .sliderContainer .slidePager ul li a {
                        color: black;
                    }

            .sliderContainer .slidePager .activeSlide {
                background-color: antiquewhite;
            }
</style>
<div class="sliderContainer">
    <div class="slides">
        [SLIDES]
        <div class="nextBtn">
            [NEXT]
        </div>
        <div class="prevBtn">
            [PREV]
        </div>
    </div>
    <div class="slidePager">
        [PAGER]
    </div>

</div>