Soul Searching...The Escape Route

JWT token secured with RSA256

noreply@blogger.com (Amit Rajkhowa) — Wed, 20 Nov 2024 19:23:00 +0000

The purpose of this article is to create a JWT token secured with RSA256 private key.

The first step is to generate the private key used by the sending Application. To generate the key we need to use OpenSSL. If we are using Windows 10/11 OS, this is easy since the OpenSSL is already available at C:\Program Files\Git\usr\bin. If not available, it can be downloaded. The next step is to open Git Bash and start OpenSSL command. The next steps are mentioned below:

- openssl genrsa -out mbprivate.key 2048

Next we need to generate .csr file for submitting to Certificate Authority

- openssl req -new -key mbprivate.key -out mbrequest.csr

The .crt file that will be used by the application that will be needed by the receiving Application - openssl x509 -req -days 365 -in mbrequest.csr -signkey mbprivate.key -out mbcertificate.crt

If we need the JWT token to have a key id in the header we need to generate that:
- openssl rsa -in mbprivate.key -pubout -outform DER | openssl dgst -sha256 -binary | openssl enc -base64

        [HttpGet]
        public async Task<IActionResult> GenerateToken(string UserName)
        {
            var authClaims = new List<Claim>
            {
                new Claim(JwtRegisteredClaimNames.Sub, UserName),
                new Claim(JwtRegisteredClaimNames.Jti, Guid.NewGuid().ToString()),
            };
            var token = CreateRsaToken(authClaims);

            return Ok(token);
        }

        private string CreateRsaToken(List<Claim> authClaims)
        {
            var rsaPrivateKey = System.IO.File.ReadAllText(System.IO.Path.Combine(Environment.CurrentDirectory, "mbprivate.key"));
            using var rsa = RSA.Create();
            rsa.ImportFromPem(rsaPrivateKey);
            RsaSecurityKey rsaSecurityKey = new RsaSecurityKey(rsa);
            rsaSecurityKey.KeyId = "gdNz9m5dR/tFD5AQ0SghAkiM8VAC2yWSkTb+K2Nv/k=";

            var signingCredentials = new SigningCredentials(rsaSecurityKey, SecurityAlgorithms.RsaSha256)
            {
                CryptoProviderFactory = new CryptoProviderFactory { CacheSignatureProviders = false }
            };

            var now = DateTime.Now;

            var jwt = new JwtSecurityToken(
              issuer: _configuration["JWT:ValidIssuer"],
              audience: _configuration["JWT:ValidAudience"],
              claims: authClaims,
              notBefore: now,
              expires: now.AddHours(1),
              signingCredentials: signingCredentials
            );

            return new JwtSecurityTokenHandler().WriteToken(jwt);
        }

noreply@blogger.com (Amit Rajkhowa) — Fri, 10 May 2024 00:19:00 +0000

How do I send a server side Push Notification on Firebase Http V1 for Android

Here I am using the FirebaseAdmin Nuget package

Create a NotificationPayload class

    public class NotificationPayload
    {
        public string Title { get; set; }
        public string Body { get; set; }
        public Dictionary<string, string> CustomFields { get; set; }
    }

Now you can create the method "SendAndroidPushNotificationAsync" that is going to send the Push Notification:

using System;
using System.Collections.Generic;
using System.Net.Http;
using System.Threading.Tasks;
using FirebaseAdmin.Messaging;
using FirebaseAdmin;
using Google.Apis.Auth.OAuth2;
using System.IO;

    public async Task SendAndroidPushNotificationAsync(string deviceId, NotificationPayload notificationPayload)
    {
        var customFields = new Dictionary<string, string>();
        if (notificationPayload.CustomFields != null && notificationPayload.CustomFields.Count > 0)
        {
            foreach (var field in notificationPayload.CustomFields)
            {
                customFields.Add(field.Key.ToString(), field.Value);
            }
        }
        FirebaseApp.Create(new AppOptions()
        {
            Credential = GoogleCredential.FromFile(Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "firebase-adminsdk.json")),
        });
        var notificationMessage = new FirebaseAdmin.Messaging.Message()
        {
            Data = customFields,
            Notification = new FirebaseAdmin.Messaging.Notification
            {
                Title = notificationPayload.Title,
                Body = notificationPayload.Body
            },
            Android = new FirebaseAdmin.Messaging.AndroidConfig()
            {
                Priority = Priority.Normal,
                TimeToLive = TimeSpan.FromHours(1),
            },
            Token = deviceId
        };
        var result = await FirebaseMessaging.DefaultInstance.SendAsync(notificationMessage);

        Console.WriteLine(result);
    }

The "firebase-adminsdk.json" is the private key json file that you need to generate from your Firebase Project and store in your Application's root folder.

Now you can call this method "SendAndroidPushNotificationAsync" from whichever project that you want to sent the Push Notification. You will need an App to which you want to send the Notification and the deviceId/channelId to which the Notification need to be sent.

If we are getting a result like "//projects/myapp/messages/2492588335721724324" we should be good

Set DropdownList Selected Value from Hidden Field

noreply@blogger.com (Amit Rajkhowa) — Thu, 24 Mar 2016 12:55:00 +0000

Aim :- Set DropdownList Selected Value from Hidden Field. I have added complexity that the dropdownlist id is dynamically generated as it may be necessary to generate the same controls in the page multiple times.

So let’s see what we have here.

Partial view Page

Part of the view content will come from a Partial Page. The Partial Page may be called multiple times (repeated in main view). Hence the hidden field has id/name generated dynamically

@Html.Hidden("SelectedCls"+session.Recipient.RecipientId.ToString(), selectedClass.ClassId)

View Page

The Dropdownlist may be also generated multiple times, hence id is partially generated dynamically.

@Html.DropDownList("TempClsId",new SelectList(Model.ViewOnlyClassRoomList, "Id", "Name"),new { @class = "roomClassStyle", id = String.Format("TempClsId {0}", uniqueId), style = "width: 260px" })

Javascript/Jquery

We need to set the selected value in the dropdownlist once the page load is completed. Hence our code will be set inside document.ready. We are using two loops here, they are not necessary in case we have only one dropdownlist. Here, first we are fetching all the dropdownlist which has TempClsId preceding its name. Once all the dropdownlists are fetched in an array, we look for hidden fields which has name starting with SelectedCls and the ID which is common for both the dropdownlist & the hiddenfield. The selected value is set to the hidden field value at the next step.

$(document).ready(function () {

var retval = []

$("select[name^='TempClsId']").each(function () {

retval.push($(this).attr('id'))

})

for (var i = 0; i < retval.length; i++) {

var selcls = 'SelectedCls' + retval[i].replace('TempClsId', '');

var selval = $('input[name^=' + selcls + ']').attr('value');

$('#' + retval[i]).val(selval);

}

});

</script>

Oracle – Output in XML format and tag customization

noreply@blogger.com (Amit Rajkhowa) — Mon, 30 Mar 2015 07:08:00 +0000

DBMS XMLGEN is a PL/SQL package that allows a programmer to extract data in XML format from Oracle database tables.

Select DBMS_XMLGEN.GETXML('Select FIRST_NM FIRSTNAME, MDL_NM MIDDLENAME, LAST_NM LASTNAME, PHON_NR PHONENUMBER FROM SchemaName.EmployeeTable WHERE Emp_ID = 987654321') from dual;

The resultant XML data is below:

<?xml version="1.0" encoding="UTF-8"?>

<ROW>

</ROW>

</ROWSET>

We notice that the ‘RowSet’ and ‘Row’ tags are default root and row elements. However we have the option to customize them.

DECLARE

ctx DBMS_XMLGEN.ctxHandle;

XML CLOB;

P_Emp_Id number;

BEGIN

P_Emp_Id:= 987654321;

ctx := dbms_xmlgen.newcontext('SELECT FIRST_NM FirstName, MDL_NM MiddleName, LAST_NM LastName, PHON_NR PhoneNumber FROM SchemaName.EmployeeTable WHERE Emp_ID ='||P_ Emp_Id||'');

DBMS_XMLGEN.SETROWTAG(CTX, 'ContactPerson');

dbms_xmlGEN.setRowSetTag(CTX, 'EmployeeApplication');

XML := DBMS_XMLGEN.GETXML(CTX);

DBMS_OUTPUT.PUT_LINE(SUBSTR(XML,1,1255));

END;

The output with customized names for RowSet & Row tag:

<?xml version="1.0" encoding="UTF-8"?>

<EmployeeApplication>

   <ContactPerson>

      <FIRSTNAME>Ho</FIRSTNAME>

      <MIDDLENAME>Chin</MIDDLENAME>

      <LASTNAME>Minh</LASTNAME>

      <PHONENUMBER>9989798</PHONENUMBER>

   </ContactPerson>

</EmployeeApplication>

We notice that the inner XML tags are caps by default. That can be customized by adding the tag names under double quotes

Select DBMS_XMLGEN.GETXML('Select FIRST_NM “FirstName”, MDL_NM “MiddleName”, LAST_NM “LastName”, PHON_NR “PhoneNumber” FROM SchemaName.EmployeeTable WHERE Emp_ID = 987654321') from dual;

The resultant XML data is below:

<?xml version="1.0" encoding="UTF-8"?>

<ROW>

</ROW>

</ROWSET>

Reloading a DropDownList using jQuery

noreply@blogger.com (Amit Rajkhowa) — Mon, 24 Nov 2014 10:09:00 +0000

Note: This solution will not be applicable for ASP.Net with ViewState (as ViewState will not be updated while using Webmethod call to reload the control).

<asp:DropDownList ID="ddlTemplate" runat="server" ClientIDMode="Static" ></asp:DropDownList>

I kept the control clientIDmode static, it is necessary when we use Master page and the javascript code is in separate file. With HTML combo box control we can remove some of the code specific that is used to handle asp.net control.

The frontend javascript/jquery code :

function GetTemplates() {

var ddlTestDropDownListXML = '#ddlTemplate';

var tableName = "TempDataTable";

$.ajax({

type: "POST",

dataType: "json",

contentType: "application/json; charset=utf-8",

url: "Search.aspx/GetTemplates",

data: '{tableName: "' + tableName + '"}',

success: function (response) {

$(ddlTestDropDownListXML).empty().append($("<option></option>").val("[-]").html("Select"));

$.each(response.d, function () {

$(ddlTestDropDownListXML).append($("<option></option>").val(this['Value']).html(this['Text']));

});

error: function (xhr, status, error) {

var err = eval("(" + xhr.responseText + ")");

alert(err.Message);

}

});

}

And the code behind looks like below:

        [System.Web.Services.WebMethod]

        public static ArrayList GetTemplates(string tableName)

            AdBusiness ab = new AdBusiness();

            DataTable templateTable = new DataTable();

            ArrayList lstArrTemplate = new ArrayList();

try

                templateTable = ab.GetTemplates();

                foreach (DataRow row in templateTable.Rows)

                    lstArrTemplate.Add(new ListItem((string)row[0], (string)row[1]));

                return lstArrTemplate;

            catch (Exception ex)

                return lstArrTemplate;

Error with Entity Framework 6 after importing Stored Procedures & Functions

noreply@blogger.com (Amit Rajkhowa) — Tue, 28 Oct 2014 04:48:00 +0000

I have recently started using Entity Framework 6 for my VS2012 project in 4.5 framework. I was confronted with an error after importing Stored Procedures & Functions, which I did much later after importing the tables.

cannot convert from 'System.Data.Objects.ObjectParameter' to 'System.Data.Entity.Core.Objects.ObjectParameter'

The issue may have arisen because I had used EF5 in my previous project. The solution that I figured out is quite simple. We need to replace

using System.Data.Objects;

with

using System.Data.Entity.Core.Objects;

noreply@blogger.com (Amit Rajkhowa) — Thu, 23 Oct 2014 12:29:00 +0000

I just added the Ajax control toolkit to my VS2012 project and then run the project. Got the following error.

'MsAjaxBundle' is not a valid script name. The name must end in '.js'

The name it is referring to is available in the Master page, though it doesn’t make clear as to what the error is.

How to solve it? There are a few changes to be made in the Master page.


   <asp:ScriptManager runat="server"> must be changed to <ajaxToolkit:ToolkitScriptManager runat="server">
    The Assembly="System.Web" reference must be removed from all the ScriptReferences
   MsAjaxBundle reference must be removed

Once these 3 changes are made, your application will run trouble free.

Getting Table Column names in Linq to Entity

noreply@blogger.com (Amit Rajkhowa) — Tue, 14 Oct 2014 04:42:00 +0000

We can get the list of column names of a table through SQL query using the following query:

SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS

where TABLE_NAME = 'TableName'

To get the same result while using LINQ to Entity Framework, we need to use Reflection.

using (var context = new DatabaseContext())

{

var queryString = typeof(TableName).GetProperties().Select(a => a.Name).ToList();

}

Records as radio buttons create dynamically

noreply@blogger.com (Amit Rajkhowa) — Thu, 19 Jun 2014 09:19:00 +0000

I have a requirement where a set of records has to be displayed as radio button dynamically, the record being fetched from DB.

Let’s start with deciding the ‘rdassets’ as the content holder of the radio buttons.

We will do an ajax request to the controller with some parameter passed. The result will be checked for null, and then the fetched records will be looped through and appended to the ‘rdassets’. Here below is the ajax call along with the solution to add records as radio buttons in the page.

$("#BtnSearch").click(function () {

var param = $("#somepagecontrol").val();

$.ajax({

url: "/Controller/Method/",

type: 'POST',

dataType: 'json',

data: { Param: param },

success: function (result) {

if (result != null) {

$.each(result, function () {

$("#rdassets").append(

$('<input />', {

type: 'radio',

name: 'rdoAsset',

id: this. RequestId

})

);

$("#rdassets").append(

$('<label />', {

'text': this.Item

})

)

});

}

else {

}

error: function (xhr, ajaxOptions, thrownError) {

alert('Error in fetching details.');

}

});

The ajax response will look similar to the below sample:

[{"RequestId":110,"Item":"Samsung TV"},{"RequestId":103,"Item":"Sample Asset 003"},{"RequestId":206,"Item":"Toyota Cars"}]

Parameter passing at Url.Action

noreply@blogger.com (Amit Rajkhowa) — Thu, 19 Jun 2014 08:48:00 +0000

What is my goal: Open a model window (partial page) through a javascript function, passing a parameter with it.

Where the challenge is: The parameter cannot be directly added in the url Action.

What is the solution: Add a hardcoded parameter value and replace it in the next step

Normally we would like to pass the parameter in the url in the below way:

reqid = paramvalue;

url = '@Url.Action("PageName", new { requestId = reqid })';

This above code doesn’t work. Below is the sample code which works perfectly. We set a dummy value “-1” as the parameter in the first step. In the next step we replace the dummy value with the actual one.

</div>

function ViewRecord(objValue) {

reqid = objValue;

url = '@Url.Action("PageName", new { requestId = "-1" })';

url = url.replace("-1", reqid);

modelwindow = $("#modelwindow")

.kendoWindow({

title: true,

modal: true,

visible: false,

resizable: true,

width: '800px',

content: url

}).data("kendoWindow");

modelwindow.title("Request Details");

modelwindow.center().open();

}

Sending email through MS Sql Server

noreply@blogger.com (Amit Rajkhowa) — Wed, 19 Mar 2014 13:21:00 +0000

This sample is intended for MVC, C# code. The front end code consists of Kendo UI & jquery.

I will be using asynchronous mode to upload the file to a temporary destination path “FileUploads” in the server. Users need to be given access to this folder first.

[HttpPost]

public ActionResult SaveAttachment(HttpPostedFileBase ImageFile)

{

imagepath = ImageFile.FileName;

var destinationPath = Path.Combine(Server.MapPath("~/FileUploads"), imagepath);

FileInfo files = new FileInfo(destinationPath);

ImageFile.SaveAs(destinationPath);

imagepath = destinationPath;

}

Once the file has been uploaded to the folder in server, our program needs a method to get the server IP. (We may hardcode the IP for server, but that will not be ideal.)

private string GetIP()

{

IPHostEntry host;

string localIP = "?";

host = Dns.GetHostEntry(Dns.GetHostName());

foreach (IPAddress ip in host.AddressList)

{

if (ip.AddressFamily == AddressFamily.InterNetwork)

{

localIP = ip.ToString();

}

return localIP;

}

public ActionResult EMail([DataSourceRequest] DataSourceRequest request, Somemodel model)

{

string ip = GetIP();

string fileUploadPath = @"\\" + ip + "\\FileUploads\\";

String[] filecount = FileNames.Split(','); //Here get FileNames from FileUploads folder

//Handling multiple files in the attachment here, attachments must be separated by ;

foreach (string filename in filecount)

{

if (attachmentPath == "")

{

attachmentPath = fileUploadPath + filename;

}

else

{

attachmentPath = attachmentPath + ";" + fileUploadPath + filename;

}

//Use some business entity to send the mail information to Data access layer

SomeBusinessEntity mailMaster = new MailMaster

{

Recipients = model.Recipients,

Subject = model.Subject,

Body = System.Web.HttpUtility.HtmlDecode(model.Body),

BodyFormat = model.BodyFormat,

FileAttachments = attachmentPath

CreatedDate = DateTime.Now

};

MailDAL.Email(mailMaster);

}

You may directly call the msdb.dbo.sp_send_dbmail stored procedure from DAL, or the other option is to write a separate stored procedure which will then call the system defined one.

If all code goes fine, your mail will be reaching the intended recipient.

This example also solves the issue "attachment file is invalid" – error 22051 as we use GetIP() to get IP of the server.

Kendo UI Tips

noreply@blogger.com (Amit Rajkhowa) — Tue, 11 Mar 2014 10:53:00 +0000

How to clear Kendo fields from javascript function:

function ClearFields() {

$('#Result').hide();//div

$("# Subject ").val(''); //Kendo TextBox control

$("#Importance").data("kendoDropDownList").value('-1'); //Kendo DropDownList control

var editor = $("#Body").data("kendoEditor"); //Kendo Editor

editor.value('');

}

How to set Kendo Dropdownlist values/text if we aren’t fetching from DB.

How to add the default (optional) field.

@(Html.Kendo().DropDownListFor(model => model.Importance)

.DataTextField("Text")

.DataValueField("Value")

.OptionLabel("-- Select --")

.BindTo(new List<SelectListItem>() {

new SelectListItem() {

Text = "NORMAL",

Value = "0"

new SelectListItem() {

Text = "PERSONAL",

Value = "1"

}

})

Will keep on adding to it with time...

Javascript function: Sending MVC Razor parameter containing special characters

noreply@blogger.com (Amit Rajkhowa) — Wed, 26 Feb 2014 12:42:00 +0000

I am working on MVC Razor. I have to call a javascript function loadHierarchyData on click event. It works fine if we use the Razor format @item.HierarchyName which allows the parameters to be passed to the function successfully.

However we face issue when the dynamic parameter contains special characters. In this example our parameter contains ‘ character. The solution is to include \\ character in front of the special character as shown in the below example.

SplitString SQL function returning comma seperated values in a table

noreply@blogger.com (Amit Rajkhowa) — Thu, 01 Aug 2013 05:58:00 +0000

Missed on the function that will receive comma seperated IDs and return as a table after splitting them.

CREATE
FUNCTION [dbo].[SplitString] (
@myString
VARCHAR(500),
@deliminator
VARCHAR(10)
)
RETURNS
@ReturnTable
TABLE (
[id] [int]
IDENTITY(1,1) NOT NULL,
[part] [varchar]
(50) NULL
)
AS
BEGIN
DECLARE @iSpaces INT
DECLARE @part VARCHAR(50)
SELECT @iSpaces = CHARINDEX(@deliminator,@myString,0)
WHILE @iSpaces > 0
BEGIN
SELECT @part = SUBSTRING(@myString,0,CHARINDEX(@deliminator,@myString,0))
INSERT INTO @ReturnTable(part)
SELECT @part
SELECT @myString = SUBSTRING(@mystring,CHARINDEX(@deliminator,@myString,0)+ LEN(@deliminator),LEN(@myString) - CHARINDEX(' ',@myString,0))
SELECT @iSpaces = CHARINDEX(@deliminator,@myString,0)
END
IF LEN(@myString) > 0
INSERT INTO @ReturnTable
SELECT @myString
RETURN END

Fetch Cartesian product count from 2 column, both columns containing ID, one containing comma separated IDs

noreply@blogger.com (Amit Rajkhowa) — Mon, 29 Jul 2013 07:49:00 +0000

I am working on a chart which uses xml data to build the graph. Well, here I am not going to do anything on xml. Rather I will look into what data the chart is expecting, what were the challenges that I faced and how did I overcome it.

I have a table named ‘OfficeDetails’, of which I am interested in 3 columns viz., ‘AppID’, ‘ManagedBy’, ‘BU’. My graph will contain the information of the last 2 columns, but as I need some unique column for filtering the data, I had chosen AppID for that purpose. ManagedBy and BU contains the ID and the actual values are available in OFFICELookupValue table.

The graph need the count of ManagedBy for each BU. However the graph need the count even if a ManagedBy –BU count is 0; i.e, if there are 10 unique BU and 5 ManagedBy then we need to return 10*5=50 records. The logic becomes more complicated because the BU column consists of comma separated Ids. I looked for some sort of logic to loop through the rows in OfficeDetails table. Most of them suggested cursors. Well, I am aware that cursor in SqlServer is not a very good idea. Looked around and I found a much better solution.

Step 1

Create a table variable:

DECLARE @tempOfficeDetails TABLE(AppID INT , ManagedBy INT, BU VARCHAR(200))

Step 2

Insert the required data to the table variable, we may also filter data in this step:

INSERT INTO @tempOfficeDetails

SELECT AppID, ManagedBy, BU FROM OfficeDetails ORDER BY BU DESC

Step 3

Handling the comma separated values of BU need one more table variable:

DECLARE @tempOfficeDetailsSplitBU TABLE(AppID INT , ManagedBy INT, BU VARCHAR(200))

Step 4

As we move through the While loop the top values are inserted to tempOfficeDetailsSplitBU table:

SELECT TOP 1 @AppID = AppID, @ManagedBy = ManagedBy, @BU = BU FROM @tempOfficeDetails

WHILE @AppID IS NOT NULL

BEGIN

INSERT INTO @tempOfficeDetailsSplitBU SELECT AppID, ManagedBy, S.part FROM @tempOfficeDetails CROSS APPLY [dbo].[SplitString](@BU, ',') AS S WHERE AppID =@AppID

DELETE @tempOfficeDetails WHERE @AppID = AppID

SET @AppID = NULL

SELECT TOP 1 @AppID = AppID, @ManagedBy = ManagedBy, @BU = BU FROM @tempOfficeDetails

END

Step 5

We Created one more table variable @BusinessFunctManagedBy which will store the all the records where ManagedBy –BU count is >0.

DECLARE @BusinessFunctManagedBy TABLE

(

BusinessFunct VARCHAR(254),

ManagedBy VARCHAR(254),

OfficeCount INT

)

Step 6

The step/logic to insert the records from tempOfficeDetailsSplitBU is below:

INSERT INTO @BusinessFunctManagedBy

SELECT officelkp2.[Value] AS BusinessFunct, officelkp.[Value] AS ManagedBy,

OfficeCount = CASE WHEN officelkp2.[Value] IS NULL THEN 0 ELSE COUNT(1) END

FROM @tempOfficeDetailsSplitBU AS OfficeDetails

LEFT JOIN OFFICELookupValue officelkp

ON officelkp.pkID = OfficeDetails.ManagedBy

LEFT JOIN OFFICELookupValue officelkp2

ON officelkp2.pkID = OfficeDetails.BU

GROUP BY officelkp2.[Value], officelkp.[Value] ORDER BY officelkp2.[Value] DESC

Step 7

Since we need the records where BU-ManagedBy count is 0, we created 2 table variables and inserted records as below:

DECLARE @BusinessFunct TABLE

(

BusinessFunct VARCHAR(254)

)

DECLARE @ManagedByTab TABLE

(

ManagedBy VARCHAR(254)

)

INSERT INTO @BusinessFunct

SELECT DISTINCT officelkp.[Value] AS BusinessFunct

FROM @tempOfficeDetailsSplitBU AS OfficeDetails

LEFT JOIN OFFICELookupValue officelkp

ON officelkp.pkID = OfficeDetails.BU

--SELECT * from @BusinessFunct

INSERT INTO @ManagedByTab

SELECT DISTINCT officelkp.[Value] AS ManagedBy

FROM @tempOfficeDetailsSplitBU AS OfficeDetails

LEFT JOIN OFFICELookupValue officelkp

ON officelkp.pkID = OfficeDetails.ManagedBy

Step 8

We created one more table variable TotalMatching which inserts the Cartesian product of ManagedBy-BU columns with count 0. Next it update the OfficeCount with values from BusinessFunctManagedBy table that we created earlier. Next delete all the records where record count is 0. Hence we are left with only the records with 0 count. Insert them to BusinessFunctManagedBy.

DECLARE @TotalMatching TABLE

(

BusinessFunct VARCHAR(254),

ManagedBy VARCHAR(254),

OfficeCount INT

)

INSERT INTO @TotalMatching

SELECT H.BusinessFunct,M.ManagedBy,0

FROM @BusinessFunct H

CROSS JOIN @ManagedByTab M

UPDATE T

SET T.OfficeCount = A.OfficeCount

FROM @TotalMatching T

INNER JOIN @BusinessFunctManagedBy A

ON T.BusinessFunct = A.BusinessFunct

AND T.ManagedBy=A.ManagedBy

DELETE FROM @TotalMatching

WHERE OfficeCount > 0

INSERT INTO @BusinessFunctManagedBy

SELECT * FROM @TotalMatching

The complete stored procedure is below:

CREATE PROC dbo.OFFICE_BusinessFunctManagedBy

BEGIN

DECLARE @tempOfficeDetails TABLE(AppID INT , ManagedBy INT, BU VARCHAR(200))

DECLARE @tempOfficeDetailsSplitBU TABLE(AppID INT , ManagedBy INT, BU VARCHAR(200))

DECLARE @AppID INT, @ManagedBy INT, @BU VARCHAR(200)

INSERT INTO @tempOfficeDetails

SELECT AppID, ManagedBy, BU FROM OfficeDetails ORDER BY BU DESC

SELECT TOP 1 @AppID = AppID, @ManagedBy = ManagedBy, @BU = BU FROM @tempOfficeDetails

WHILE @AppID IS NOT NULL

BEGIN

INSERT INTO @tempOfficeDetailsSplitBU SELECT AppID, ManagedBy, S.part FROM @tempOfficeDetails CROSS APPLY [dbo].[SplitString](@BU, ',') AS S WHERE AppID =@AppID

DELETE @tempOfficeDetails WHERE @AppID = AppID

SET @AppID = NULL

SELECT TOP 1 @AppID = AppID, @ManagedBy = ManagedBy, @BU = BU FROM @tempOfficeDetails

END

DECLARE @BusinessFunctManagedBy TABLE

(

BusinessFunct VARCHAR(254),

ManagedBy VARCHAR(254),

OfficeCount INT

)

INSERT INTO @BusinessFunctManagedBy

SELECT officelkp2.[Value] AS BusinessFunct, officelkp.[Value] AS ManagedBy,

OfficeCount = CASE WHEN officelkp2.[Value] IS NULL THEN 0 ELSE COUNT(1) END

FROM @tempOfficeDetailsSplitBU AS OfficeDetails

LEFT JOIN OFFICELookupValue officelkp

ON officelkp.pkID = OfficeDetails.ManagedBy

LEFT JOIN OFFICELookupValue officelkp2

ON officelkp2.pkID = OfficeDetails.BU

GROUP BY officelkp2.[Value], officelkp.[Value] ORDER BY officelkp2.[Value] DESC

--SELECT * from @BusinessFunctManagedBy order by BusinessFunct asc

DECLARE @BusinessFunct TABLE

(

BusinessFunct VARCHAR(254)

)

DECLARE @ManagedByTab TABLE

(

ManagedBy VARCHAR(254)

)

INSERT INTO @BusinessFunct

SELECT DISTINCT officelkp.[Value] AS BusinessFunct

FROM @tempOfficeDetailsSplitBU AS OfficeDetails

LEFT JOIN OFFICELookupValue officelkp

ON officelkp.pkID = OfficeDetails.BU

--SELECT * from @BusinessFunct

INSERT INTO @ManagedByTab

SELECT DISTINCT officelkp.[Value] AS ManagedBy

FROM @tempOfficeDetailsSplitBU AS OfficeDetails

LEFT JOIN OFFICELookupValue officelkp

ON officelkp.pkID = OfficeDetails.ManagedBy

DECLARE @TotalMatching TABLE

(

BusinessFunct VARCHAR(254),

ManagedBy VARCHAR(254),

OfficeCount INT

)

INSERT INTO @TotalMatching

SELECT H.BusinessFunct,M.ManagedBy,0

FROM @BusinessFunct H

CROSS JOIN @ManagedByTab M

UPDATE T

SET T.OfficeCount = A.OfficeCount

FROM @TotalMatching T

INNER JOIN @BusinessFunctManagedBy A

ON T.BusinessFunct = A.BusinessFunct

AND T.ManagedBy=A.ManagedBy

DELETE FROM @TotalMatching

WHERE OfficeCount > 0

INSERT INTO @BusinessFunctManagedBy

SELECT * FROM @TotalMatching

SELECT * FROM @BusinessFunctManagedBy ORDER BY LEN(BusinessFunct) DESC, 2, 1

END

Finding ASP.Net control in User Control when using Master Page

noreply@blogger.com (Amit Rajkhowa) — Wed, 18 Jul 2012 10:38:00 +0000

Finding a control from User Control while using Master page can cause some confusion.

The code when NOT using Master page:

ucl_slareport WebUserControl1 = (ucl_slareport)FindControl(reportview);
Repeater ulRepeater1 = (Repeater)WebUserControl1.FindControl("Repeater1");
ulRepeater1.DataSource = reader;
ulRepeater1.DataBind();

Here ucl_slareport is my user control. The control that we are searching is a Repeater control. "reportview" is a new name of the control that we passing from a different function.

When we have the Master Page and trying to find the Repeater control, we first do a FindControl of the ContentPlaceHolder - "MainContent", and then we do a find control of the repeater.

ContentPlaceHolder mpContentPlaceHolder = (ContentPlaceHolder)this.Master.FindControl("MainContent");
ucl_slareport WebUserControl1 = (ucl_slareport)mpContentPlaceHolder.FindControl(reportview);
Repeater ulRepeater1 = (Repeater)WebUserControl1.FindControl("Repeater1");
ulRepeater1.DataSource = reader;
ulRepeater1.DataBind();

So that solves the problem of finding the control from the user control.

Calling an executable file from Website and passing arguments

noreply@blogger.com (Amit Rajkhowa) — Wed, 18 Jul 2012 10:21:00 +0000

I had a requirement where I needed to call a exe file from my web application. Also I needed to pass arguments to the exe.

Am calling the exe from my website through a button click. The below code explains:

Webpage.aspx

protected void Button1_Click(object sender, EventArgs e)
    {
        ProcessStartInfo prodRun = new ProcessStartInfo(ConfigurationManager.AppSettings["exepath"] + "ConClientServer.exe", ConfigurationManager.AppSettings["paths"]);
        Process exProducts = new Process();
        prodRun.WorkingDirectory = @"C:\my work\EduProj\ConClientServer\bin\Debug\";
        prodRun.Arguments = "C:\\Development\\Temp\\NewFilesTemp\\cab.txt";
        exProducts = Process.Start(prodRun);
    }

The exe file name is mentioned in ProcessStartInfo - "ConClientServer.exe".
WorkingDirectory is where my exe resides.
The 4th line, I passed a single argument. We can however pass multiple argument, separated by comma.

The exe file is called from the location mentioned in the working directory, it accepts the argument from the website as below:

ConClientServer.exe
    class Program
    {
        static void Main(string[] args)
        {
            Client cl = new Client();
            if (args.Length > 0)
            {
                string path = args[0];
                cl.FetchFileFromServer(path);
            }
        }
    }

    public class Client
    {
        public void FetchFileFromServer(string storepath)
        {
string downloadpath = storepath;
         }
     }

IE Developer Toolbar disabled

noreply@blogger.com (Amit Rajkhowa) — Wed, 08 Jun 2011 07:22:00 +0000

I am using Windows XP and IE7. Recently, after some updates ran on my system I found that the IE Developer toolbar is not working. When I looked further, I found that “Enable third-party browser extensions*” is disabled in Tools->Internet Options->Advanced->Browsing. It’s grayed out, and there is no way it can be checked (tried through system administrator also). So what was the solution?

Somewhere after a lot of googling/binging, I got this solution:

Go to command prompt, type regedit, enter. The registry key window will open.

Go to HKEY_LOCAL_MACHINE->SOFTWARE->Policies->Microsoft->Internet Explorer->Main

Here you will see the Data as “no” for “Enable Browser Extensions”. Set it to “yes”. Hurray!!!

IE Developer Toolbar is working. If you check in Internet Options, the browser extension checkbox is checked.

Column values as a single string - MS Sql Server

noreply@blogger.com (Amit Rajkhowa) — Thu, 19 May 2011 09:14:00 +0000

There are situations where you need the resultant values of a single column to be displayed/processed as a single string. So here goes the query:

DECLARE @Str VARCHAR(MAX)
SELECT @Str = COALESCE(@Str+',' ,'') + CONVERT(varchar,Column1) FROM MyTable
SELECT @Str

Multiple Count from Single Table Sql Server

noreply@blogger.com (Amit Rajkhowa) — Thu, 19 May 2011 09:04:00 +0000

Recently my collegue was working with a query where he needed multiple counts from a table with different conditions. Say its something like a company has multiple office buildings with multiple floors. They need the count of total space for each floor of each building and empty space with the same conditions.
The query I referred was like this:

SELECT SUM(CASE WHEN condition1 THEN 1 ELSE 0 END) count1, SUM(CASE WHEN condition2 THEN 1 ELSE 0 END) count2 FROM yourtable

Customizing it to my need I wrote the following query

SELECT SUM(CASE SeatStatus WHEN 0 THEN 1 ELSE 0 END) FreeSpace, COUNT(Seat) TotalSpace FROM MyTable

Find Last Modified File in a folder

noreply@blogger.com (Amit Rajkhowa) — Fri, 25 Mar 2011 08:51:00 +0000

Let me first explain the requriements & constraints and then arrive at the solution.
I have a folder in a designated path (here C:/Testing), in which there are a lot of files. My requirement need me to find a specific type of files (here *.txt) in the folder. Of all the files of that type, I have to choose only those files who have a specific name (here Hello) and get the one which was the latest modified.

Here we can see the folder with 6 text files.

5 of the files name contains "Hello", so they fulfill our criteria. Although the 6th file "little.txt" was latest modified of all the files, our logic should not choose it; instead it should choose "Hello4.txt" since it was the latest modified of the other 5 files, that matches our criteria.

string dirname = @"C:\Testing";
string[] txtFiles = System.IO.Directory.GetFiles(dirname,"*.txt");
DateTime lastmodified= Convert.ToDateTime("01/01/1900");
string LastModifiedfile = string.Empty;
foreach (string filenm in txtFiles)
{
if (filenm.Contains("Hello"))
{
if (File.GetLastWriteTime(filenm) > lastmodified)
{
lastmodified =
LastModifiedfile = filenm;
}
}
}
Response.Write(LastModifiedfile + File.GetLastWriteTime(filenm);" at "+lastmodified+" was last modified.");

Hence we successfully get the result as:

Dropdownlist - Adding tooltip for each listitem

noreply@blogger.com (Amit Rajkhowa) — Fri, 25 Mar 2011 08:25:00 +0000

There are times when you are designing a page with space constraint for the cotrols.
One such case can be with the Dropdownlist whose items may need more space then what it was allocated for. In this situation the user will not be able to see the complete text of the listitems. A solution to this situation is to add tooltip for the listitems.

Consider here, we have the Dropdownlist:

<div style="width: 600px; margin: auto;">
<div style="width: 150px; float:left">Account Name: </div>
<div style="width: 400px; float:left">
<asp:DropDownList ID="DropDownList1" runat="server" Width="120px">
<asp:ListItem Value="1">Application Services</asp:ListItem>
<asp:ListItem Value="2">Toyota Motors Private Limited</asp:ListItem>
<asp:ListItem Value="3">Ford Motors Private Limited</asp:ListItem>
</asp:DropDownList>
</div>
</div>

Which leads us to have a dropdownlist as below.

We added the tooltip for each listitem.

foreach(ListItem _listItem in this.DropDownList1.Items)
{
_listItem.Attributes.Add("title", _listItem.Text);
}

Hence we have the Dropdownlist with tooltip as shown below:

Using Data from XML file within project

noreply@blogger.com (Amit Rajkhowa) — Fri, 03 Dec 2010 07:51:00 +0000

I have a xml file in my local project - Data.xml with the following content
<TestApp>
<ManagerList>
       <Manager>
         <Name>Amit Rajkhowa</Name>
         <EmpId>88378</EmpId>
        </Manager>
      <Manager>
        <Name>Bijoy Gogoi</Name>
        <EmpId>88506</EmpId>
      </Manager>
    </ManagerList>
</TestApp>

I used the following code in my code to pull the data from the xml.

DataSet dsStore = new DataSet();
DataTable dt= new DataTable();
dsStore.ReadXml("Data.xml");
dt= dsStore.Tables["Manager"];
string[] items = new string[dt.Rows.Count];
int i = 0;
foreach(DataRow dr in dt.Rows)
{
items.SetValue(dr["Name"].ToString(), i);
i++;
}
return items;

I found that the xml file is not found. Hence changed the path to the following:

dsStore.ReadXml(Server.MapPath("~/Data.xml"));

Dot Net Questions

noreply@blogger.com (Amit Rajkhowa) — Tue, 21 Sep 2010 12:23:00 +0000

What Great .NET Developers Ought To Know

( Nothing here is original from my side. The questions I found in the blog of Scott Hanselman. The answers I found in some other sites, although I changed some of the answer myself. Its just for my reference that I am posting them here. I will keep posting new questions and changing/updating the answers for better knowledge gathering)

Everyone who writes code

· Describe the difference between a Thread and a Process?

o A thread is a path of execution that run on CPU, a proccess is a collection of threads that share the same virtual memory. A process have at least one thread of execution, and a thread always run in a process context.

· What is a Windows Service and how does its lifecycle differ from a "standard" EXE?

o Windows service doesn't require a logged on user to activate it, (there is a bit more, but that is basicaly it).

· What is the maximum amount of memory any single process on Windows can address? Is this different than the maximum virtual memory for the system? How would this affect a system design?

o Hmm, that is a tough question, there is the 2Gb of normal user space, 3Gb if you run windows with the right switch (which has problems of its own, apperantly) and the max virutal memory of 32bits machine is 4Gb. This affect system design when you reach big things such as databases, applications server and Enterprise "stuff" that require a lot of memory.

· What is the difference between an EXE and a DLL?

o An exe is an Executable file that contain instructions for the processor to run as well as an entry point to start execution (main() in C/C++, Public Static Void Main() in .Net). A dll is a file that contain a piece of functionality that an exe will call.

· What is strong-typing versus weak-typing? Which is preferred? Why?

o Strong type is checking the types of variables as soon as possible, usually at compile time. While weak typing is delaying checking the types of the system as late as possible, usually to run-time. Which is preferred depends on what you want. For scripts & quick stuff you'll usually want weak typing, because you want to write as much less (is this a correct way to use Ensligh?) code as possible. In big programs, strong typing can reduce errors at compile time. Going any further will cause Holy War, so I stop here.

· Corillian's product is a "Component Container." Name at least 3 component containers that ship now with the Windows Server Family.

o No idea what a component container is, sorry.

· What is a PID? How is it useful when troubleshooting a system?

o Process Identifier, usually so you can kill an offending process (at least that is how I use it) or for logging / debugging purposes.

· How many processes can listen on a single TCP/IP port?

o AFAIK, One. It make sense, but I'm not 100% sure. The results of more than one process listenning to the same port would be strange at best.

· What is the GAC? What problem does it solve?

o Global Assembly Cache. Versioning. Dll Hell, etc.

Mid-Level .NET Developer

· Describe the difference between Interface-oriented, Object-oriented and Aspect-oriented programming.

o That one is tough, Interface oriented would probably be (first time I hear this term) writing everything in terms of interfaces and only using the interfaces, using concentrate classes for instatition only. Object orient is the shebang of classes, polymorphism, inheritance, and the like. Very powerful, allows you to hook your objects together and just let the program run. OO is a must for Interface bases. Aspect Oriented programming is when you have code running on certain aspects of your code (method entry, method return, exception thrown, etc) most useful in logging and security.

· Describe what an Interface is and how it’s different from a Class.

o Interface define a contract, but no executable code. Interface is implemented by classes.

· What is Reflection?

o A way to explore the structure of assemblies at run-time (discover which classes/resources/methods there are).

· What is the difference between XML Web Services using ASMX and .NET Remoting using SOAP?

o Never done either, but XML WS is interoperatable, and .Net Remoting is extensible.

· Are the type system represented by XmlSchema and the CLS isomorphic?

o No.

· Conceptually, what is the difference between early-binding and late-binding?

o Early binding is knowing at compile time what you are calling, late binding is discovering it in run time. That is not a good explanation, but generally this mean whatever you're using a concentrate class or an interface.

· Is using Assembly.Load a static reference or dynamic reference?

o Dynamic reference.

· When would using Assembly.LoadFrom or Assembly.LoadFile be appropriate?

o When trying to load a file that is not on your private path. (Plug-ins comes to mind, or things like Reflector).

· What is an Asssembly Qualified Name? Is it a filename? How is it different?

o It contain the name of the assembly, its version and its public key, it's not a file name, and it's different in that it allows signing and versioning.

· Is this valid? Assembly.Load("foo.dll");

o No, Assembly.Load() accept assemblies names and not file names (got bitten by that a few times).

· How is a strongly-named assembly different from one that isn’t strongly-named?

o It's an assembly that has been signed using public/private key pair. It can be placed in the GAC, mainly. It also help is versioning and code verification (if you know the publisher Public Key, you can verify that it hasn't been tampered with.)

· Can DateTimes be null?

o Since it is a value type it cannot represent null(Or DBNull). Simple way is just to set it to Dim MyDate as Date = Date.MinValue
Nullable type also can be used in this situation

· What is the JIT? What is NGEN? What are limitations and benefits of each?

o Just In Time compilation, it allows for better compilation magic because the JIT knows a lot more about the code when it's running, long startup time. NGen is compiling ahead of time, faster startup time, but not as much info for the compiler, so it may not produce as efficent code.

· How does the generational garbage collector in the .NET CLR manage object lifetime? What is non-deterministic finalization?

o It divide them to three generations, the first one is short lived and is collected often (and is cheap to collect), the other two are for longer term objects. Non deterministic finalization means that your object's finalizer (destructor in C++) isn't called when it falls out of scope, its memory isn't even neccecarily released when it falls out of scope .OTOH, it may be collected when it's still in scope, if you're not using it anymore.

· What is the difference between Finalize() and Dispose()?

o Dispose is called by the user (hopefully via using()) and Finalize is called by the runtime.

· How is the using() pattern useful? What is IDisposable? How does it support deterministic finalization?

o Make it harder to forget to release resources, IDisposable is an interface that define a way to release resources in a predicted way. It means that when you're out of the using() statement, then the object's Dispose() has been called and its resources (but not memory, that is up for the GC) are free.

· What does this useful command line do? tasklist /m "mscor*"

o Hm... No idea. First time I see the tasklist command. Maybe list only the processes that link to mscor* ? Probably will show all the processes that uses .Net.

· What is the difference between in-proc and out-of-proc?

o in proc is faster, out proc require marshaling between the process. There are more, but that is the main thing.

· What technology enables out-of-proc communication in .NET?

o Hm, Remoting for one, Windows Messages is another, all of Win32 RPC is yet another. Named piped, memory mapped files, etc.

· When you’re running a component within ASP.NET, what process is it running within on Windows XP? Windows 2000? Windows 2003?

o I don't know this one, but I think it's aspnet_wp.exe in XP & 2003 (never worked with that one, sadly) and inetinfo.exe for 200.

Senior Developers/Architects

· What’s wrong with a line like this? DateTime.Parse(myString);

o No locale? No variable to store the returned date? Not using ParseExact? No try-catch? Hard to tell.

· What are PDBs? Where must they be located for debugging to work?

o No idea what the TLA is, but they are debug symbol that tells the debugger which instruction belong to which line of code.

· What is cyclomatic complexity and why is it important?

o Even my dictionary doesn't know what "cyclomatic" is, but I would hazzard a guess and it's probably some sort of measuring method for the complexity of software.

· Write a standard lock() plus “double check” to create a critical section around a variable access.

o I know this one, but I can't recall how to do this, I'll finish the rest of the questions and return to it. Okay, I returned and here is my implementation.

if(shouldLock)
{
lock(lockableObj)
{
  if(shouldLock)
  {
   DoWork();
  }
}
}

· What is FullTrust? Do GAC’ed assemblies have FullTrust?

o Your code is allowed to do anything in the framework, meaning that all (.Net) permissions are granted. The GAC has FullTrust because it's on the local HD, and that has FullTrust by default, you can change that using caspol (I always think of that as cesspool for some reason.)

· What benefit does your code receive if you decorate it with attributes demanding specific Security permissions?

o Early failure if you don't get it. Easily discover what are the permission that the code need, etc.

· What does this do? gacutil /l | find /i "Corillian"

o Didn't get to work with gacutil, but /l is probably list, so this print all the assemblies in the GAC that has Corillian (not case sensitive).

· What does this do? sn -t foo.dll

o Does something to the strong name of the dll, probably show you the details of it, don't recall sn's CUI in my head.

· What ports must be open for DCOM over a firewall? What is the purpose of Port 135?

o Port 135 is for windows RPC, a much abused service. Can't recall what ports are for DCOM, but that is easily discoverable.

· Contrast OOP and SOA. What are tenets of each?

o OOP - Objects is everything (inheritance, ploymorphism, interfaces, etc). SOA - Services are the main thing (discoverability, interoperability, versioning, etc. At least those are the buzzwords that I hear, don't have experiance with this).

· How does the XmlSerializer work? What ACL permissions does a process using it require?

o It reflect on your object and read the attributes and then output the values according to it. I'm not aware of ACL permissions you need for this (ACL being Windows), but you need ReflectionPermission in order to use it (a .Net permission).

· Why is catch(Exception) almost always a bad idea?

o This means that you swallow an exception and not do anything about it. There are very few cases when it's okay to do that, usually when you have an action you don't care if it failed or not, or maybe you just care that it failed, and not why (validating input integer is one such case:

try
{
i = int.Parse(str);
Console.WriteLine(i+ " is a number");
}catch (Exception)
{
Console.WriteLine("This is not a number");
}

· What is the difference between Debug.Write and Trace.Write? When should each be used?

o The Debug.Write call won't be compiled when the DEBUG symbol is not defined (when doing a release build). Trace.Write calls will be compiled. Debug.Write is for information you want only in debug builds, Trace.Write is for when you want it in release build as well. And in any case, you should use something like log4net because that is both faster and better :-)

· What is the difference between a Debug and Release build? Is there a significant speed difference? Why or why not?

o Debug build contain debug symbols and can be debugged while release build doesn't contain debug symbols, doesn't have [Contional("DEBUG")] methods calls compiled, can't be debugged (easily, that is), less checking, etc. There should be a speed difference, because of disabling debug methods, reducing code size etc but that is not a gurantee (at least not a signifcant one)

· Does JITting occur per-assembly or per-method? How does this affect the working set?

o I believe that per method, but not certain. The working set should be smaller becaue methods that weren't called weren't JITed (meaning less memory taken, etc).

· Contrast the use of an abstract base class against an interface?

o Abstract base class can contain code, but there are some methods that are marked abstracted (no code) that an inheriting class must implement. This is a useful way to have some default action if the inheriting class isn't interested in override some method. Interface has no code, and an implementing class must implement all methods.

· What is the difference between a.Equals(b) and a == b?

o The first checks whatever the objects are equal, the second whatever they are reference-equal (the same object). At least that is the way it work in Java, didn't have trouble using just == everywhere in .Net, so far.

· In the context of a comparison, what is object identity versus object equivalence?

o Hm, that is a tough one. Object identity can mean either the same object (you've two references for the same object) or (not very often unless you are in ORM world) database identity. Basically, object identity mean that they are the same object (same place in memory or same row in the DB) and object equivalence means that they are a diferent objects but has the same value (all fields are are Equal() ).

· How would one do a deep copy in .NET?

o Implement IClonable? That is the way I would do it.

· Explain current thinking around IClonable.

o Uh... no comment is not a good answer?

· What is boxing?

o Taking a value type (on the stack) and putting it on the heap.

· Is string a value type or a reference type?

o reference type with immutable semantics (proof, you can do this: string s = null;).

· What is the significance of the "PropertySpecified" pattern used by the XmlSerializer? What problem does it attempt to solve?

o No idea.

· Why are out parameters a bad idea in .NET? Are they?

o .Net doesn't verify that an out parameter is set inside a method that uses an out parameter before an exception is called. This mean that you may use an uninitialized parameter without the compiler catching on to this. Use ref parameters instead. Personally, I think that it's a problem.

· Can attributes be placed on specific parameters to a method? Why is this useful?

o Yes. I think that for Remoting scenarios, but I'm not sure. I know that I saw such things, but never really paid much attention to it.

· C# Component (HI, TP) Developers

o Ha? Is this a question?

· Juxtapose the use of override with new. What is shadowing?

o Override means that using your class throught a base class will use your method, while new means your method will only be called if accessing through your class, and when using your class throught a base class the base class method will be called. I think that shadowing is the using new, but I'm not certain.

· Explain the use of virtual, sealed, override, and abstract.

o Virtual - a method that can be overriden in an inheriting class, and the invoked method will be the derived class one.
Sealed - means that you can't inherit from a class, often annoying when it's on the BCL.
Override - a marker that verify that you indeed override a method and no just create a method with the same name & parameters by mistake
Abstract - a method that are not implemented, abstract methods are virtual, and abstract classes are explained above.

· Explain the importance and use of each component of this string: Foo.Bar, Version=2.0.205.0, Culture=neutral, PublicKeyToken=593777ae2d274679d

o Foo.Bar - (so you won't get Foo.Baz by mistake), Version=2.0.205.0 - The version of the assembly, that you won't get the version 2.0.0.0 (dll hell), Culute=neutral - in case you are into globalization :-), PublicKeyToekn=... - verify that this file is indeed the file you are thinking about and has not been tampered with except by the original publisher.

· Explain the differences between public, protected, private and internal.

o Public - anyone can use, protected - only inheriting classes can use, private - only this class can use, internal - only members in this assembly can use.

· What benefit do you get from using a Primary Interop Assembly (PIA)?

o IIRC, using a COM compnent?

· By what mechanism does NUnit know what methods to test?

o Refection & Attributes.

· What is the difference between: catch(Exception e){throw e;} and catch(Exception e){throw;}

o The last one preserve the exception stack, it really should've been rethrow;

· What is the difference between typeof(foo) and myFoo.GetType()?

o typeof(foo) is a compile time structute, and foo is a type name, myFoo is an object, and GetType() is a method that return in run-time.

· Explain what’s happening in the first constructor: public class c{ public c(string a) : this() {;}; public c() {;} } How is this construct useful?

o The c(string) calls to c(), this is useful if you've a basic constructor that initialize all the fields, and then you can avoid duplication of code.

· What is this? Can this be used within a static method?

o a reference to the current object, static methods don't have an object, so they can't use this.

ASP.NET (UI) Developers

{Note, I'm not much of ASP.NET UI developer, but I'll try it anyway}

· Describe how a browser-based Form POST becomes a Server-Side event like Button1_OnClick.

o Probably something in the Application that takes the POST and fire an event, the spesifics I never had to find out.

· What is a PostBack?

o A way for the page to notify the asp.net application that some even occured (button clicked, etc).

· What is ViewState? How is it encoded? Is it encrypted? Who uses ViewState?

o A way to preserve the state of controls when doing postbacks, I think it's Base64 encoded, I don't think it's encrypted by default, though it probably can be. Nearly all web controls use it.

· What is the <machinekey> element and what two ASP.NET technologies is it used for?

o A public key that used for session & caching services when they are done in a cluster and no just a single server.

· What three Session State providers are available in ASP.NET 1.1? What are the pros and cons of each?

o in proc - fast, if the process crash then you lose state. out proc - slower, if the process crash you preserve state. Sql Server - slowest (network), you preserve state and can use the state from multiply machines.

· What is Web Gardening? How would using it affect a design?

o Clusters? No idea, as a matter of fact.

· Given one ASP.NET application, how many application objects does it have on a single proc box? A dual? A dual with Web Gardening enabled? How would this affect a design?

o Hm, no idea again.

· Are threads reused in ASP.NET between reqeusts? Does every HttpRequest get its own thread? Should you use Thread Local storage with ASP.NET?

o Yes, threads are reused, Request can jump between threads, and TLS wil not work, use the request context.

· Is the [ThreadStatic] attribute useful in ASP.NET? Are there side effects? Good or bad?

o Not really, because request may be served from multiply threads, you may get a different object from another request. Very bad.

· Give an example of how using an HttpHandler could simplify an existing design that serves Check Images from an .aspx page.

o No idea what the question is, what is "Check Images" ? Maybe URL Rewriting (my one use for HttpHandlers)

· What kinds of events can an HttpModule subscribe to? What influence can they have on an implementation? What can be done without recompiling the ASP.NET Application?

o No idea.

· Describe ways to present an arbitrary endpoint (URL) and route requests to that endpoint to ASP.NET.

o No idea, probably URL Rewriting and IIS redirection/virtual directories?

· Explain how cookies work. Give an example of Cookie abuse.

o The server tell the browser to put this file in a cookie, and the client then send all the cookies for the domain in each request. Possible abuses are big cookies which affect network traffic and speed of surfing and privacy (1x1 gifs).

· Explain the importance of HttpRequest.ValidateInput()?

o I'll have to learn what this is first, sorry.

· What kind of data is passed via HTTP Headers?

o document name, size, culture, mime type, basically the document meta data.

· Juxtapose the HTTP verbs GET and POST. What is HEAD?

o GET tells the server to send it a spesific page, POST also send variables (in GET they may be trasfered using query string) with the request, HEAD tell the server to send just the headers, and not the actual content.

· Name and describe at least a half dozen HTTP Status Codes and what they express to the requesting client.

o 200 - Ok, 404 - Document Not Found, 304 - No Update Neccecary, 500 - Server Error, 401 - Autorization Error

· How does if-not-modified-since work? How can it be programmatically implemented with ASP.NET?
Explain <@OutputCache%> and the usage of VaryByParam, VaryByHeader.

o if-not-modified-since header allows the server to send 304 reponse (not modified) and not the full content of the page. You implement this by capturing the headers, checking for the presence of if-not-modified-since value, and then returning 304 status code. I believe that this is the hard way and OutputCache will do it for you if the client send if-not-modified-since. VaryByParam means that the cache hold different copies of the page for different parameters, and the same is true for different header for VaryByHeader

· How does VaryByCustom work?

o Probably by implementing some interface or abstract class, but I don't really know.

· How would one implement ASP.NET HTML output caching, caching outgoing versions of pages generated via all values of q= except where q=5 (as in http://localhost/page.aspx?q=5)?

o Use VaryByCustom, I would guess, but I don't count this as an answer as I don't know what VaryByCustom really does.

Developers using XML

(I don't like the angle bracket tax, and it shows)

· What is the purpose of XML Namespaces?

o To allows me and you to use the <Id> tag without grief and pain.

· When is the DOM appropriate for use? When is it not? Are there size limitations?

o Small documents, and you need to modify the content. Big documents need to be loaded to memory entirely, so it's wasteful. Size limitation - probably so, but the performance is more often a consideration

· What is the WS-I Basic Profile and why is it important?

o I'll need to get back to you with that one :-)

· Write a small XML document that uses a default namespace and a qualified (prefixed) namespace. Include elements from both namespace.

o I know this, but I can't recall the syntax from the top of my head, (xml:ns?).

· What is the one fundamental difference between Elements and Attributes?

o Element can contain another elements and attributes?

· What is the difference between Well-Formed XML and Valid XML?

o Valid Xml is validated against a schema/dtd/etc, Well Formed Xml obey only to the grammer of XML, and valid XML is also well formed, but the reversed is not true.

· How would you validate XML using .NET?

o XmlValidatingReader, most probably.

· Why is this almost always a bad idea? When is it a good idea? myXmlDocument.SelectNodes("//mynode");

o The mean search me and all my childrens, this can cause to bad performace as unneccecary searches are made. It's much more efficent to use the full or relative path. I can't think of a good use right now, maybe when you really do want all the mynode nodes? (For counting them, or doing some work on them, etc).

· Describe the difference between pull-style parsers (XmlReader) and eventing-readers (Sax)

o In XmlReader you control the parsing, you move from one place to another using methods, Sax parse the Xml in its own time, and raise events whenever it find something interesting. Personally I like XmlReader, but I've never used Sax, so I can't tell much more.

· What is the difference between XPathDocument and XmlDocument? Describe situations where one should be used over the other.

o XPathDocument is not editable, that is the first and most important thing. Otherwise, it allows fast XPath queries. When I want to pull data, I'll use XPathDocument, when I need to edit it, I'll use XmlDocument.

· What is the difference between an XML "Fragment" and an XML "Document."

o I think that Xml fragement obey all the rules of Xml, but it doesn't have <?xml?>. No certain about this one, though.

· What does it meant to say “the canonical” form of XML?

o Without whitespace etc, just the content, regardless of the way it was saved.

· Why is the XML InfoSet specification different from the Xml DOM? What does the InfoSet attempt to solve?

o No idea.

· Contrast DTDs versus XSDs. What are their similarities and differences? Which is preferred and why?

o DTD & XSD are both ways to spesify a format for an XML dialect. XSD is written using XML, and DTD looks like a big regex. I rather read XSD, because I don't need to make the mental shift from XML to DTD dialect.

· Does System.Xml support DTDs? How?

o I think that it must to offfer a complete support, but I don't know.

· Can any XML Schema be represented as an object graph? Vice versa?

o I belive so, but not certain. Vice versa - I don't think so.

ASP.Net: Fetching data from a PopUp

noreply@blogger.com (Amit Rajkhowa) — Fri, 19 Feb 2010 13:17:00 +0000

Consider the case where you need to popup a page, perform some operation and fetch the resultant data from the Pop-Up page into your Parent page.
Starting with the Parent page, lets have a TextBox on the Parent page where we need to enter data from the Pop-Up page.Here is the code:

<head runat="server">
    <title>Parent Page</title>
    <script type="text/javascript" >
    function text()
    {
    window.open("popup.aspx", null, "scrollbars=no,menubar=no,status=no,width=400,top=300,left=350,right=0,height=250,resizable=no");
    }
    </script>
</head>
<body>
    <form id="form1" runat="server">
    <div>
      <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
      <asp:Button ID="Button1" runat="server" Text="Button" OnClientClick="return text();" />
    </div>
    </form>
</body>

On clicking the button on the base page the other page pops up. Here we are selecting a value in the Dropdown list and the selected value is returned to the base page using the code in javascript. The magic code is "window.opener.document.getElementById....", through which the parent page access the value that it is seeking.

<head runat="server">
    <title>PopUp Page</title>
    <script language="javascript" type="text/javascript">
        function passValues()
        {
          var oOption = document.getElementById("DropDownList1");
          var strText = oOption.options[oOption.selectedIndex].text;
          window.opener.document.getElementById("TextBox1").value = strText;
        }
    </script>
</head>
<body>
    <form id="form1" runat="server">
    <div>
      <asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="True">
        <asp:ListItem>Bulgaria</asp:ListItem>
        <asp:ListItem>Belgium</asp:ListItem>
        <asp:ListItem>Slovenia</asp:ListItem>
        <asp:ListItem>Latvia</asp:ListItem>
        <asp:ListItem>Gibraltar</asp:ListItem>
      </asp:DropDownList>
      <input type="submit" onclick="passValues(); window.close()" value="Submit" />
    </div>
    </form>
</body>
</html>

The hardcoded data from the Dropdownlist can be replaced with necessary data and you will get the desired result.