Sunday 10 May 2015

CSharp Read Resource File as Json

protected void Page_Load(object sender, EventArgs e)
        {
          mapResFileName = "MapResources.en-US.resx";
            if (m_UserLanguage == "ar")
            {
                mapResFileName = "MapResources.resx";
            }
            ClientScript.RegisterStartupScript(this.GetType(), "localizedString", getReourseFileAsJSON(mapResFileName), true);
        }





        public string getReourseFileAsJSON(String resourceFileName)
        {           
            try
            {
                string mapResString = "localizedString={'userLang':'" + m_UserLanguage + "',";
                ResXResourceReader rsxr = new ResXResourceReader(
                String.Format("{0}{1}\\{2}", System.AppDomain.CurrentDomain.BaseDirectory.ToString(), "App_GlobalResources", resourceFileName));
                foreach (DictionaryEntry d in rsxr)
                {
                    mapResString += "'" + d.Key.ToString() + "':'" + d.Value.ToString() + "',";
                }
                mapResString += "};";
                return mapResString;
            }
            catch (Exception exc)
            {
                return "File Not Found";
            }
            

        }

Tuesday 5 May 2015

DROP all tables starting with “Na_” in Oracle

BEGIN
  FOR c IN ( SELECT table_name FROM user_tables WHERE table_name LIKE 'EXT_%' )
  LOOP
    EXECUTE IMMEDIATE 'DROP TABLE ' || c.table_name;
  END LOOP;
END;

create your MDSys Tables in your schema


create table my_user_sdo_geom_metadata as select * from user_sdo_geom_metadata;

create table my_user_sdo_styles as select * from user_sdo_styles;

create table my_user_sdo_themes as select * from user_sdo_themes ;

create table my_user_sdo_maps as select * from user_sdo_maps;

create table my_user_sdo_cached_maps as select * from user_sdo_cached_maps;

create table my_user_sdo_geor_sysdata as select * from user_sdo_geor_sysdata;


To insert them again to MDSys views 

insert into user_sdo_geom_metadata select * from my_user_sdo_geom_metadata;

insert into user_sdo_styles select * from my_user_sdo_styles;

insert into user_sdo_themes select * from my_user_sdo_themes;

insert into user_sdo_maps select * from my_user_sdo_maps;

insert into user_sdo_cached_maps select * from my_user_sdo_cached_maps;

insert into user_sdo_geor_sysdata select * from my_user_sdo_geor_sysdata;

commit;

To insert them again to MDSys views without duplicate 

insert into user_sdo_styles
(select * from my_user_sdo_styles
where name not in (select name from user_sdo_styles ))

insert into user_sdo_geom_metadata
(select * from my_user_sdo_geom_metadata
where table_name  not in (select table_name  from user_sdo_geom_metadata))

insert into user_sdo_themes
(select * from my_user_sdo_themes
where name not in (select name from user_sdo_themes))

insert into user_sdo_maps
(select * from my_user_sdo_maps
where name not in (select name from user_sdo_maps))

insert into user_sdo_cached_maps
(select * from my_user_sdo_cached_maps
where name not in (select name from user_sdo_cached_maps))

commit;

delete from user_sdo_styles;
delete from user_sdo_themes;
delete from user_sdo_maps;
delete from user_sdo_cached_maps;
delete from user_sdo_geom_metadata;
delete from user_sdo_geor_sysdata;
commit;

drop table my_user_sdo_geom_metadata;
drop table my_user_sdo_styles;
drop table my_user_sdo_themes;
drop table my_user_sdo_maps;
drop table my_user_sdo_cached_maps;
drop table my_user_sdo_geor_sysdata;