Example #1
0
        public Repository()
        {
            EntityConnectionStringBuilder csb = new EntityConnectionStringBuilder();

            csb.Metadata = "res://*/DuctosDBModel.csdl|res://*/DuctosDBModel.ssdl|res://*/DuctosDBModel.msl";
            csb.Provider = "System.Data.SqlClient";
            csb.ProviderConnectionString = ConfigurationManager.ConnectionStrings["CNPC_Ductos"].ConnectionString;
            String entityConnStr = csb.ToString();

            Context = new CNPC_DuctosEntities(entityConnStr);
        }
Example #2
0
        public bool ValidaRolconAccion(int rolid, string controller)
        {
            EntityConnectionStringBuilder csb = new EntityConnectionStringBuilder();

            csb.Metadata = "res://*/DuctosDBModel.csdl|res://*/DuctosDBModel.ssdl|res://*/DuctosDBModel.msl";
            csb.Provider = "System.Data.SqlClient";
            csb.ProviderConnectionString = ConfigurationManager.ConnectionStrings["CNPC_Ductos"].ConnectionString;
            String entityConnStr = csb.ToString();

            int nroRegistros = new CNPC_DuctosEntities(entityConnStr).usp_ValidaRolconAccion(rolid, controller);

            return(nroRegistros > 0);
        }