IT Knowledge

How send arrays and parameters in a single request?? Your request will have the following format $scope.request.VistTitle = ''; $scope.request.VisitName = ''; $scope.request.VisitLastName = ''; $scope.request.VisitMail = ''; $scope.request.VisitNationality = '';} $scope.request.Providers = [{},{}] Send your object using JSON.stringfy  $http({                 method: 'POST',                 url: './AccessRequestProvider/Add',                 data: JSON.stringify( request )             }).success(function (a) { ..... In your controller using C#, create a dynamic List IList Create the objects  public class Request2         {             public String VistTitle { get; set; }           ...

How to upload files to a server In the ASPX  <% using (Html.BeginForm(" UploadFile ", " AccessRequestProvider ",                     FormMethod.Post, new { enctype = "multipart/form-data" })) {%> Where  UploadFile  is the method and  AccessRequestProvider  is the controller (.cs) Then include the fields to upload the files  <input type="file" name="files" id="file1" class="filestyle" data-classbutton="btn btn-primary" data-input="false" data-classicon="icon-plus" data-buttontext="TEst.">                                                               <input type="file" name="files" id="file2" class="filestyle" data-buttonname="btn-primary" data-buttontext=" TEst."> Close the form  <%}  %> ...

How create a connection to AD? Include in the References Define the variables server = company.se container = DC=compan,DC=se Create the connection              PrincipalContext pc = new PrincipalContext(ContextType.Domain, server, container);             DirectorySearcher directorySearcher = new DirectorySearcher(pc.ConnectedServer);             directorySearcher.Filter = "(sAMAccountName=" + signum + ")";             SearchResult results = directorySearcher.FindOne();             DataTable dtDomain = new DataTable("DomainP"); Parse the result if (results != null)             {                 dtDomain.Columns.Add("displayname");                 dtDomain.Columns.Add("departmen...

How to pass parameters using $state $state.go('access_request2', { signum: request.Signum }); in the app.config -> .state('access_request2', {         url: "/access_request2/{signum}",         templateUrl: function ($stateParams) {             return 'AccessRequest2/' + $stateParams.signum;         },     })

First Steps to use Ionic Install   Node.j s Remember the installation path Review that in the System variable "PATH" appear the Node's intallation path, the Node installer automatically add it to the variable

http://www.asp.net/mvc/overview/older-versions-1/models-%28data%29/creating-model-classes-with-the-entity-framework-cs MVC

Import Data Select the option Data -> From Web Then select the data to import Functions FIND( caracter, cell) LEFT (cell, untilPosition) IF (condition, true condition, false condition) SUMIF( condition, equal value, value to add)

Uso de CTE Especifica un conjunto de resultados temporal con nombre, conocido como expresión de tabla común (CTE).   Se deriva de una consulta simple y se define en el ámbito de ejecución de una sola instrucción SELECT, INSERT, UPDATE o DELETE.   Esta cláusula también se puede utilizar en una instrucción CREATE VIEW como parte de la instrucción SELECT que la define.   Una expresión de tabla común puede incluir referencias a ella misma.   Esto se conoce como expresión de tabla común recursiva. Ejemplo WITH Sales_CTE (SalesPersonID, NumberOfOrders) AS ( SELECT SalesPersonID, COUNT(*) FROM Sales.SalesOrderHeader WHERE SalesPersonID IS NOT NULL GROUP BY SalesPersonID ) SELECT AVG(NumberOfOrders) AS "Average Sales Per Person" FROM Sales_CTE ; GO Using multiple CTEs WITH Sales_CTE AS ( ) ,New CTE as ( ) select * from Sales_CTE , N ew CTE Using parameters DECLARE @ somevar DECIMAL ; WITH SomeName AS ( SELECT ....) SELE...

SSIS Expression Examples This example casts a numeric value to an integer. (DT_I4) 3.57 This example casts an integer to a character string using the 1252 code page. (DT_STR,1,1252)5 This example casts a three-character string to double-byte characters. (DT_WSTR,3)"Cat" This example casts an integer to a decimal with a scale of two. (DT_DECIMAl,2)500 This example casts an integer to a numeric with a precision of seven and scale of three. (DT_NUMERIC,7,3)4000 This example casts values in the  FirstName  column, defined with an  nvarchar  data type and a length of 50, to a character string using the 1252 code page. (DT_STR,50,1252)FirstName This example casts values in the  DateFirstPurchase  column of type DT_DBDATE, to a Unicode character string with a length of 20. (DT_WSTR,20)DateFirstPurchase This example casts the string literal ...

Kinds of Architectures Business Architecture / Business Process Architecture    Define the business strategy, governance, organization and key business processes Data Architecture    Describe the structure of an organization logical and physical data assets and data resources Application Architecture    Describe a blueprint for the individual application systems to be deploy, interactions and  their relationships to the core business processes of the organization Technology Architecture    Describe the logical software and hardware capabilities that are required to support the deployment of business data and application services. This includes middle-ware infrastructure, networks, communications, processing standards  Architecture Governance Increase transparency of accountability, and informed delegation of authority Controlled risk management Protection of the existing asset base through maximizing  re-us...

Videos http://www.wrox.com/WileyCDA/Section/id-814197.html Manejo de Archivos https://matiasespinoza.wordpress.com/2008/04/28/eliminar-archivos-con-ssis/ http://sqlserversolutions.blogspot.mx/2009/04/copyrename-file-using-file-system-task.html http://muytux.blogspot.mx/2011/07/ssis-mover-y-renombrar-un-archivo.html http://www.mssqltips.com/sqlservertutorial/211/sql-server-integration-services-ssis-data-flow/ Create dinamicall files http://i0.wp.com/blog.dbandbi.com/wp-content/uploads/2013/10/ssis-create-excel-file-Different-FIleName-Step71.jpg Format Mail http://microsoft-ssis.blogspot.mx/2013/08/sending-mail-within-ssis-part-2-script.html https://sendhtmlmailtask.codeplex.com/