IT Knowledge

 Example 1 listProjectPersonDO  is a List<ClsRelProjectPersonDO> foreach (ClsRelProjectPersonDO clsRelProjectPersonDO in              listProjectPersonDO.Where(element => element.IdProjectDomainSubdomain == row))             {              }  Example2  GeneralReport is a DataTable  var qWorkingArea = GeneralReport.AsEnumerable()              .GroupBy(r => r.Field<String>("workingArea"))             .Select(g => new             {                 totalW = g.Count(),            ...

 To send a message follow the next steps: Add the reference:  using AjaxControlToolkit;  Build the message through an alert using JQuery Use the method RegisterClientScriptBlock   The function should look like this:         StringBuilder sb = new StringBuilder();         sb.Append("<script type=\"text/javascript\">alert('");         sb.Append(mensaje.Replace("'", ""));         sb.Append("'); ");         sb.Append("window.location.href='");         sb.Append(url);         sb.Append("';</script>");        ToolkitScriptManager.RegisterClientScriptBlock(this, typeof(Button), "Mensaje", sb.ToString(), false);

How to create a User-Defined  in your database and use it in C# like DataTable Create the data type and refresh the DB [ty pe _ name ] - The name for the new data type [ parameter ] - The name of your paramenter int - The data type NULL - Declare if the parameter has to be null or not   CREATE TYPE [ relProjectDS ] AS TABLE(       [idProject] int NOT NULL ,     [ idCatDomain ] int NULL,     [catSubdomain ] [nvarchar]  (50) NULL ) Create the Store procedure CREATE PROCEDURE  [dbo].[insertProject]     @ myDataType relProjectDS readonly AS BEGIN       insert into [dbo].[Table] select * from @ myDataType END Create and fill the DataTable in C# idProject - Name of the parameter according with data type from the DB typeof(int) - The type definition according with the DB Rows.Add(param1, param2) - The method to add each row to the DataTable DataTable projectsTable = new DataTable(); proje...

In the view: Define the method in the event  OnSelectedIndexChanged Add the tag  AutoPostBack="true" <asp:TemplateField HeaderText="Competence Domain">        <ItemTemplate>                 <asp:DropDownList ID="ddlCompDomain" runat="server" AppendDataBoundItems="true" AutoPostBack="true" OnSelectedIndexChanged="ddlCompDomain_SelectedIndexChanged">                 </asp:DropDownList>         </ItemTemplate> </asp:TemplateField> In the code inside the method  ddlCompDomain_SelectedIndexChanged : Cast the  sender  object to the element you wanted to know the index, for our case a  DropDownList From the  DropDownList  get the  GridViewRow  through the parent property Get the index with  RowIndex protected void ddlCompDomain_SelectedIndexChanged(object sender , EventArgs e) ...

AJAX (Asynchronous JavaScript Xml) This is the method to invoke ajax $.ajax({         url: "my_data.xml" ,       // URL of you want to GET via AJAX     cache: false,     dataType: " xml ",            //  data  - The  data  return from the Ajax call     success: function(xml_reader){        // Run this function is the method ajax is  successful         $(xml).find("runner").each(function() {   var info = '<li>Name: ' + $(this).find("fname").text() + ' ' + $(this).find("lname").text() + '</li>';  if( $(this).find("gender").text() == "m" ){ $('#finishers_m').append( info ); }else if ( $(this).find("gender").text() == "f" ){ $('#finishers_f').append( info ); }   $('#finishers_all').append( info ); });                      } }); A...

Declare Objects You can create objects using JavaScript, also you can assign this object to a variable. function object (param1, param2){  this.param   = param1;  this. param2 = param2;   my_function: function(){      } } var my_object = object(1, 2); Properties To access the properties use object.property Ej:  var name =   object . param2 ; Using JSON the syntax is     object [' param2 '] Arrays The arrays can be created with the following sintax var  array  = new Array(); var  array  = new Array('obj1', 'obj2', 'obj3'); var  array  = ['obj1', 'obj2', 'obj3']; Functions $.inArray get the index where is the element. var element_index = $.inArray('value', array ); Window object Each time a tab is open a window object is created. Methods window. onFocus - tells when a tab is activated. window. onBlur - detects when the tab lose the focus. Functions window. setTimeout ( function(){}, 400) - Wait the define...

Method Listener There are two ways to bind events to elements Case 1:  $("my_element"). click (  function () { }  ); Case 2:  $("my_element").bind(' click ', function () { }   ); Unbind method The function .unbind remove the mehod pass as paramenter.  Also the function .each iterate in all the elements from the element selector. $("div.guess_box") .each ( function(){ $(this) .unbind  ('click'); }); Functions There are two ways to declare a function Function declaration function nameFunction () {    //Code } Function variable var  nameFunction =  function () {    //Code } Anonymous Function Is when inside another function you declare your own function. In this case $(this).unbind('click'); is the anonymous function. $("div.guess_box").each( function(){ $(this).unbind('click'); }); Contains Function Compate inside this if have the element with Id "has_discount" if ($.contains( this  , docum...

Function $( ) is the shortcut of jquery( ) Syntaxis :    $( "Selector Element" ).Method(); $( "Selector Element" ).Method( Function( ){  } ); JQuery select elements as CSS h1 -> Element selector .h1 { color: red}    ->  Css Class select a grouping of elements #my_h1 { color: #3300FF; } -> Id Selector, only affects one element Example 1 $("span. Italian ").toggle(); <span class=" Italian ">Nel Mezzo del cammin di  nostra vita</span>  <span class="English">In the middle of this road  called "our life"</span>     <span class=" Italian ">mi ritrovai per una selva  oscura</span> Example 2 $("p #mytext ").show(); <p id=" mytext ">One morning, when Gregor Samsa  woke from troubled dreams . . .  </p>  <p id=" mytext ">he found himself transformed in  his bed into a horrible vermin.</p>  <p>He lay on his armour-like back...

What do Prototypes Prototype? Feel - What might it look like? Implementation - What might it work like? Role - What might the experience be like? The best way to have a good idea is to have lots of ideas.    - Linus Pauling Biggest changes at early stages. Evaluating Designs Labs Surveys Feedback from Experts Comparatives Experiments Participant Observation Simulation Users Estreme Users Users seldom use it

Presentation Operation Contract Data Contract Implementation  -> svc.cs RN Business Rules Data  Data Access Layer (DAL) Entities Class Data Repository Data Methods

This code show how to open an external web page. Evaluating if is an Desktop or Web Apllication. using System.Runtime.InteropServices.Automation; using System.Windows.Browser; using Microsoft.LightSwitch.Client; using Microsoft.LightSwitch.Threading; var uri = new Uri("http://google.com", UriKind.RelativeOrAbsolute); Dispatchers.Main.BeginInvoke(() => {    try{                          // If is a Desktop application            if (AutomationFactory.IsAvailable){                  var shell = AutomationFactory.CreateObject("Shell.Application");                  shell.ShellExecute(uri.ToString());             }            // If is a Web application              else if (!System.Windows.Application...

Name a File dinamically In connections (as a File) you can change the Output File name using expressions. With the following expression you can named a file according with the actual date. “C:\\Projects\\SSISPersonalTrainer\\EmployeeCount_”+ RIGHT ( “ 0”+(DT_WSTR, 2) Month(GETDATE() ), 2 ) + RIGHT ( “ 0”+(DT_WSTR, 2) Day(GETDATE() ), 2 ) + (DT_WSTR, 4) Year( GETDATE() )+”.txt” Function Getdate() LEFT( (DT_WSTR,30) GETDATE() , 10) E.g: 2015-05-26

Description of the SSIS Toolbox Items Script Task Just do a simple task and you can code some actions like evaluate some variables, also you can evaluate two Script task with AND or OR conditional. File System Task Can do all the actions to interact with a FTP. Execute SQL  You can execute a sql sentence, also you can put the result in a variable or variables. Execute Process Task You can execute an external program like a *.bat where you can send it some parameters Expression Task Evaluate variables with many functions like Round, Sum, Date functions, etc. You can use it in a For Loop Container. Send Mail Task As the name say, you send an email with all the attributes you can imagen. Data Flow The Data Flow Task is used to transfer data from a source to a destination and can transform the data as needed. Data Conversion Transfor the data type, usefull in case of non-unicode to unicode Devived Column  create or replace a column in the data stream Aggregate Rolling up data, wit...

After did your package, insert as a job in SQL Server Select in Visual Studio -> Save As Go to the file system and copy the file to C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL *You have to put the file in this path if not SQL Server will not be able to read the file. Go to SQL Server Manager  Expand SQL Server Agent Right click in Jobs Select New Job Type a Name Click in Steps Click in New Type a Name In Package select the file *.dtsx In the Tab "Execution options", select "Use 32 bit runtime" Click OK In Jobs do right click and select Start Job at Step Ready!!

The purpose is to upload an Excel file into a Database without duplicate information. Install SQL Server Data Tools for Visual Studio 2012 Create a New Project  Type: Integration Services Project Create New Package Menu: Project -> New SSIS Package  Inside the Package In the tab Control Flow , drag a "Data Flow Task" Inside the Data Flow tab, drag the following Items, as the image Excel Source OLE DB Source Sort elements (x2) Mege Join Conditional Split Data Conversion OLE DB Destination Excel Source Double click in the element In Connection Manager, Select "New" and then choose the file path Select the Excel tab  In Columns, select all the items OLE DB Source Double click in the element In Connection Manager, Select "New" and then choose the Server Name and Table Click Ok Select the table where you are comparing the information (is the same table where you are going to store the new data) In Columns, select all the items Click OK SORT Double click in t...