.NET Development: 2014

miércoles, 26 de noviembre de 2014

SSIS exporting SQL query result to txt file

1. Create OLE DB Source, connect to data source.

2. Create Execute SQL Task, to get the value of the PATH parameter.

3. Create Script Task to pass the value to the TXTFILEDIR variable.

4. Create OLE DB Source to load que data set.

5. Create Flat File Destination to export the data set to txt file.

Create OLE DB Source

Create Variables

Create Execute SQL Task

configuring

include result values on variables

edit breakpoints

testing

debugging

Create Script Task & configuring

including variables on script list

editting script

Script Update date query

Script Task

Create OLE DB Source

configuring

alternativa usando variable

Create Flat File Connection

configuring

Create Flat File Destination

configuring

Create File Connection Manager

Create SMTP Connection Manager

miércoles, 5 de noviembre de 2014

Front Office, Middle Office, Back Office

Source: hexaware, ssc, microgen
References: FO, MO, BO, Settlement

martes, 4 de noviembre de 2014

SSO, sign in on real world Azure

Read full article on microsoft

jueves, 30 de octubre de 2014

Secure password

static void Main(string[] args)
{

// Instantiate the secure string.
System.Security.SecureString securePwd = new System.Security.SecureString();
ConsoleKeyInfo key;

Console.Write("Enter password: ");
do
{
key = Console.ReadKey(true);

// Ignore any key out of range.
if (((int)key.Key) >= 32 && ((int)key.Key <= 190))
{
// Append the character to the password.
securePwd.AppendChar(key.KeyChar);
Console.Write("*");
}
// Exit if Enter key is pressed.
}
while (key.Key != ConsoleKey.Enter);

Console.WriteLine();

try
{
System.Diagnostics.Process.Start("Notepad.exe", "ryanes", securePwd, "lanet");
}
catch (Win32Exception ex)
{
Console.WriteLine(ex.Message);
}

}

domingo, 19 de octubre de 2014

Azure storage

http://azure.microsoft.com/en-us/documentation/articles/fundamentals-introduction-to-azure/

http://azure.microsoft.com/en-us/documentation/articles/web-sites-dotnet-deploy-aspnet-mvc-app-membership-oauth-sql-database/

jueves, 25 de septiembre de 2014

Microsoft Azure business models

source: microsoft.com

miércoles, 24 de septiembre de 2014

Filling dropdownlist and filter gridview using Jquery & ASP.NET

Default.aspx

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
<script src="Scripts/jquery-1.7.1.js"></script>
</head>
<body>
<script type="text/javascript">
$(document).ready(function () {
$.ajax({
type: "POST",
contentType: "application/json; charset=utf-8",
url: "Default.aspx/GetCustomers",
data: "{}",
dataType: "json",
async: true,
cache: false,
success: function (result) {
$.each(result.d, function (key, value) {
$("#combo").append($("<option></option>").val(value.id).html(value.name));
});
},
error: function (result) {
alert("Error");
}
});
});
</script>

<script type="text/javascript">
function changeIndex() {
//clear grid rows
$("[id*=gv] tr").not($("[id*=gv] tr:first-child")).remove();

fillgrid($("#combo").val());
}
</script>

<script type="text/javascript">
function fillgrid(val) {
$.ajax({
type: "POST",
contentType: "application/json; charset=utf-8",
url: "Default.aspx/GetComplaints",
data: JSON.stringify({ id: val }),
dataType: "json",
async: true,
cache: false,
success: function (data) {
for (var i = 0; i < data.d.length; i++) {
$("#gv").append(
"<tr><td>" + data.d[i].complaintId +
"</td><td>" + data.d[i].complaintTypeId +
"</td><td>" + data.d[i].complaintSubtypeId +
"</td><td>" + data.d[i].closureDate +
"</td><td>" + data.d[i].expirationDate +
"</td><td>" + data.d[i].isActive +
"</td><td>" + data.d[i].createdBy +
"</td></tr>");
}
},
error: function (result) {
alert("Error");
}
});
};
</script>

<form id="form1" runat="server">
<div>
<asp:DropDownList ID="combo" runat="server" onchange="changeIndex();">
<asp:ListItem Selected="True" Text="Seleccione..." Value="0"></asp:ListItem>
</asp:DropDownList>
<br />
<br />
</div>
<asp:GridView ID="gv" runat="server"></asp:GridView>
</form>
</body>
</html>

Default.aspx.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;

public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
BindColumnToGridview();
}
}

public class customer
{
public int id { get; set; }
public string name { get; set; }
}

[System.Web.Services.WebMethod]
public static List<customer> GetCustomers()
{
customer cus = new customer();
List<customer> cuslist = new List<customer>();

System.Data.DataSet ds;

using (SqlConnection con = new SqlConnection(
"Data Source=FACTORY\\FACTORY;User Id=sa;Password=pa$$w0rd;DataBase=SAQ_DEV"))
{
using (SqlCommand cmd = new SqlCommand(
"SELECT DISTINCT c.[CustomerId], c.[FullName] FROM [CMP_Complaint] cc " +
"INNER JOIN [CUS_Customer] c ON c.CustomerId = cc.CustomerId", con))
{
con.Open();
cmd.Connection = con;
cmd.CommandType = CommandType.Text;
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{

ds = new DataSet();
da.Fill(ds);
}
}
}
try
{
if (ds != null)
{
if (ds.Tables.Count > 0)
{
if (ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
cuslist.Add(new customer()
{
id = Convert.ToInt32(dr["CustomerId"]),
name = dr["FullName"].ToString()
});
}
}
}
}
}
catch (Exception ex)
{
throw ex;
}
return cuslist;
}

public class complaint
{
public int complaintId { get; set; }
public int complaintTypeId { get; set; }
public int complaintSubtypeId { get; set; }
public string closureDate { get; set; }
public string expirationDate { get; set; }
public int isActive { get; set; }
public string createdBy { get; set; }
}

private void BindColumnToGridview()
{
DataTable dt = new DataTable();
dt.Columns.Add("Id queja");
dt.Columns.Add("Id tipo de queja");
dt.Columns.Add("Id subtipo de queja");
dt.Columns.Add("Fecha de cierre");
dt.Columns.Add("Fecha de expiracion");
dt.Columns.Add("Activo");
dt.Columns.Add("Creador");
dt.Rows.Add();
gv.DataSource = dt;
gv.DataBind();
gv.Rows[0].Visible = false;
}

[System.Web.Services.WebMethod]
public static List<complaint> GetComplaints(int id)
{
complaint cmp = new complaint();
List<complaint> cmplist = new List<complaint>();

System.Data.DataSet ds;

using (SqlConnection con = new SqlConnection(
"Data Source=FACTORY\\FACTORY;User Id=sa;Password=pa$$w0rd;DataBase=SAQ_DEV"))
{
using (SqlCommand cmd = new SqlCommand(
"SELECT [ComplaintId],[ComplaintTypeId],[ComplaintSubtypeId],[ClosureDate]," +
"[ExpirationDate],[IsActive],[CreatedBy] FROM [CMP_Complaint] WHERE [CustomerId] = " +
id.ToString(), con))
{
con.Open();
cmd.Connection = con;
cmd.CommandType = CommandType.Text;
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
ds = new DataSet();
da.Fill(ds);
}
}
}
try
{
if (ds != null)
{
if (ds.Tables.Count > 0)
{
if (ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
try
{
cmplist.Add(new complaint()
{
complaintId = Convert.ToInt32(dr["ComplaintId"]),
complaintTypeId = Convert.ToInt32(dr["ComplaintTypeId"]),
complaintSubtypeId = Convert.ToInt32(dr["ComplaintSubtypeId"]),
closureDate = dr["ClosureDate"].ToString().Substring(0,
dr["ClosureDate"].ToString().IndexOf(' ')),
expirationDate = dr["ExpirationDate"].ToString().Substring(0,
dr["ExpirationDate"].ToString().IndexOf(' ')),
isActive = Convert.ToInt32(dr["IsActive"]),
createdBy = dr["CreatedBy"].ToString()
});
}
catch { }
}
}
}
}
}
catch (Exception ex)
{
throw ex;
}

return cmplist;
}
}

Database tables and example data view

Final result

lunes, 22 de septiembre de 2014

Boxing & Unboxing in C#

The concept of boxing and unboxing underlies the C# unified view of the type system in which a value of any type can be treated as an object.

Boxing Conversion

Boxing is the process of converting a value type to the type object or to any interface type implemented by this value type. When the CLR boxes a value type, it wraps the value inside a System.Object and stores it on the managed heap.

Boxing is used to store value types in the garbage-collected heap. Boxing is an implicit conversion of a value type to the type object or to any interface type implemented by this value type. Boxing a value type allocates an object instance on the heap and copies the value into the new object.

Boxing is implicit

// Boxing copies the value of i into object o.
object o = i;

int i = 123;
object o = (object)i; // explicit boxing

Unboxing Conversion

Unboxing extracts the value type from the object.

Unboxing is an explicit conversion from the type object to a value type or from an interface type to a value type that implements the interface. An unboxing operation consists of: Checking the object instance to make sure that it is a boxed value of the given value type. Copying the value from the instance into the value-type variable.

Unboxing is explicit.

int i = 123; // a value type
object o = i; // boxing
int j = (int)o; // unboxing

source: msdn.microsoft.com

viernes, 19 de septiembre de 2014

Twenty C# questions explained

#1 When do you use structs vs classes?

structs are value types that can contain data and functions
structs are value types and do not require heap allocation.
structs directly store their data in the struct, classes store a reference to a dynamically allocated object.
structs are useful for small data structures
structs can affect performance
Constructors are invoked with the new operator, but that does not allocate memory on the heap
A struct constructor simply returns the struct value itself (typically in a temporary location on the stack), and this value is then copied as necessary
With classes, multiple variables may have a reference to the same object
It is possible for operations on one variable to affect the object referenced by the other variable.
With structs, the variables each have their own copy of the data, and it is not possible for operations on one to affect the other.
structs do not support user-specified inheritance, and they implicitly inherit from type object

call to functions

#2 How Does One Parse XML Files?

Reference System.Xml
Use XmlReader to parse the text string
You will need to have an idea of the XML elements and attributes for this example
Use the XmlReader methods to read the XML data

#3 What is the difference between String and string ?

No difference but code conventions state that upper case String should be used for class methods.

#4 How do I get the application’s path in a C# console app?

Use reflection to get the executing assembly path
Pass that the IO.Path.GetDirectoryName

#5 How do you call a base constructor in C#?

Method 1 - Traditional

public InheritTest(string newName) : base(newName) { }

Method 2 - New

public InheritTest(string name) : base(ModifyBase(name)) { }
private static string ModifyBase(string newName) { return newName.ToUpper(); }

#6 How would you count the occurrences of a string within a string?

Single character search

- foreach

String search

- RegEx

#7 How to Check if a Number is a Power of 2?

Use binary & operator
Converts values to binary
Performs logical AND operation on values

1000 - 8

0111 - 7

0000 – 0

1001 – 9

1000 – 8

1000 - 8

#8 What is the difference between break and continue in a loop?

Break leaves immediately
Continue allows loop to continue
Place the word loop after each keyword to make sense of it

break loop

continue loop

#9 What is the difference between abstract and virtual functions?

Abstract methods have no implementation and MUST be overridden
Virtual methods MAY have an implementation but are not required to and then CAN be overridden.
You cannot call base.method() for abstract but you can for virtual methods

#10 What is the difference between ref and out keywords?

ref causes an argument to be passed by reference not by value. It provides a reference to the source value and changes made in the method will be made to the source object

- Arguments passed as ref must be initialized before they are passed.

out also causes an argument to be passed by reference. Changes made to the parameter are also changed in the source.

- Arguments passed using out do not have to be initialized first.
- The called method must assign a value prior to the method return statement

#11 Explain how to encrypt/decrypt a string in .NET?

Generate secret key
Encrypt string
Decrypt string using same key and encryption provider

#12 How do I get the index of the current iteration of a foreach loop?

Maintain a counter and increment it manually
Some collection types provide IndexOf()

#13 How do I get my own IP address in C#?

Check private internal IP address

- Use Dns.GetHostEntry, IPAddress, and AddressList

Check public external IP address

- Make external calls

#14 How do I calculate someone's age in C#?

Use the DateTime class
Get the current date
Subtract the birth year from the current year
Allow for actual birth month

#15 How do I get string value of an enum?

Use Enum.GetName()
Use ToString()

#16 How do I make a textbox that only accepts numbers?

Use NumericUpDown
Handle the KeyPress Event
Handle the Text_Changed Event

#17 How do I round a decimal value to two places for output?

Use string format specifiers
("#.##")
("{0:0.00}", value)
("n2")
("{0:c}", value)

#18 How do I remove duplicates from an array?

Use LINQ
Use a List

#19 How do I sort a dictionary by value?

Use LINQ
Sorts into a new object

#20 How do I return multiple values from a function in C#?

Using out parameters
Using arrays or structs
Consider finding min and max values in an array

source: Microsoft MVA

miércoles, 26 de noviembre de 2014

miércoles, 5 de noviembre de 2014

martes, 4 de noviembre de 2014

jueves, 30 de octubre de 2014

domingo, 19 de octubre de 2014

jueves, 25 de septiembre de 2014

miércoles, 24 de septiembre de 2014

lunes, 22 de septiembre de 2014

viernes, 19 de septiembre de 2014

#​1 When do you use structs vs classes?

#​2 How Does One Parse XML Files?

#​3 What is the difference between String and string ?

#​4 How do I get the application’s path in a C# console app?

#​5 How do you call a base constructor in C#?

#​6 How would you count the occurrences of a string within a string?

#​7 How to Check if a Number is a Power of 2?

#​8 What is the difference between break and continue in a loop?

#​9 What is the difference between abstract and virtual functions?

#​10 What is the difference between ref and out keywords?

#​11 Explain how to encrypt/decrypt a string in .NET?

#​12 How do I get the index of the current iteration of a foreach loop?

#​13 How do I get my own IP address in C#?

#​15 How do I get string value of an enum?

#​16 How do I make a textbox that only accepts numbers?

#​17 How do I round a decimal value to two places for output?

#​18 How do I remove duplicates from an array?

#​19 How do I sort a dictionary by value?

#​20 How do I return multiple values from a function in C#?