Daynight

SQL Server Reporting Service (SSRS)

2012-02-08T12:23:00.001-06:00

SQL Server Reporting Service (SSRS)

SSRS is a bigger software application. SSRS is part of SQL server since SQL SERVER 2005.
The SSRS installation doesn’t need to have SQL Database in one box, but SSRS still needs to connects to an existing SQL server database instance.
All the SSRS configurations and reports definitions are eventually saved in the database, the configuration database for SSRS by default named as “ReportServer” and “ReportServerTempDB”.
Good practice to keep SSRS Report engine / Report definitions & web pages are at web server, i.e., n-tier enterprise solution.
In SQL Server 2005, SSRS does need IIS to be together in one box, because it needs IIS to host its web service / portal interface.
In SQL 2008, SSRS has its own embedded web server, and doesn’t need IIS anymore.
SSRS can be setup as totally independent server, no AD/Domain at all, although AD/Domain setup can bring it to normal enterprise security level.

SSRS web management portal is for admin works (such as setup data source, online folders, security, adjust reports parameters, schedules etc.). More info SSRS Web Management Portal - User Roles and Permissions

SSRS web service is for rendering reports during the run time.
When you deploy RDL from VS 2008/2010 BI stuidio (i.e. Business Intelligence Projects Template), you setup the deploy folder to http://localhost/Reportserver/<your report folder>.
More info Deploying a SSRS report to the Server

Report Viewer Control is a smaller, it’s either part of .NET 3.5 or 4.0 environment, or you can install it separately (put necessary DLLs to GAC -> c:\windows\assembly).
Download Report Viewer Control 2010 Redistributable Package from Microsoft.

Report Definition Language (RDL)

RDL is a file extension, such as “Report1.rdl”. It’s a pure text XML file.
RDL can be deployed to SSRS server. “Deploy” is the process to put RDL into SSRS configuration databases which are “ReportServer” and “ReportServerTempDB”.
Deployment can be done via Visual Studio or SSRS web management portal
RDL is the skeleton, layout and structure of the report, data (from query against the SQL DB) is the meat.
SSRS + RDL + Data will give you a rendered report either in HTML or other formats (PDF, WORD, Excel).
RDL is created from VS Business Intelligence Projects Template.

Report Definition Language Client (RDLC)

RDLC is pretty much the same as RDL , more info from microsoft link.
RDLC usually is applied to Report Viewer Control, but still served the same purpose as RDL as a skeleton of the report.
Report Viewer Control + RDLC + Data will also render you a report.
Report Viewer Control can also link to RDL on SSRS.
RDLC can be part of your ASP.NET web application or windows form application (either in file system or resource file).
RDLC is much easier, you can directly create it from normal VS project (win / web application), i.e., reference to the Report Viewer Control library.

Display SSRS Report in ASP.NET Web Page

2012-02-07T16:10:00.000-06:00

1)Open VS 2010 and Create a ASP.NET Web Application project.

2)Add a ScriptManager (AJAX Externsions), ReportViewer (Reporting) and Button (Standard) control from the toolbox in the Default.aspx page.

3)Double Click on the button, to add the following code in the button event.

protected void Button1_Click(object sender, EventArgs e)
{
ReportViewer1.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Remote;
ReportViewer1.ServerReport.ReportServerUrl = new Uri("http://localhost/ReportServer");
ReportViewer1.ServerReport.ReportPath = "/Report Project2/Report4";
ReportViewer1.ServerReport.Refresh();
}

SSRS Web Management Portal - User Roles and Permissions

2012-02-07T14:42:00.003-06:00

Assign a user or group to a system role
1)Open the Report Manager URL, http://localhost/reports or http://server_name/reports
2)Click on the Site Setting link at the top right corner. Click on Security link at the left side menu to proceed further. By default BUILTIN\Administrators user assigned to System Administrators role.

3)Click on the New Role Assignment menu button. An admin screen will appear with an option to enter the user name to which we need to assign the role. Enter the user name and select their role.

Assign a user or group to a role-based security for Home
1)Open the Report Manager URL, http://localhost/reports or http://server_name/reports
2)Click on the Folder Settings top menu. By default BUILTIN\Administrators user assigned to Content Manager role.

3)Click on the New Role Assignment menu button, it will navigate to the list roles that can be assigned to the user as shown in the screen below. Enter the user name and select their role.

Deploying a SSRS report to the Server

2012-02-07T13:13:00.002-06:00

1)Right click on the project. Select properties and there you will get to see the Deployment properties and you should see the TargetServerURL property as shown ihe below image. Set the TargetServerURL value (In the Reporting Services Configuration Tools dialog box, click Web Service URL in the left pane, the URLs below Report Server Web Service URLs just is the URL you should use as the TargetServerURL.)

2)Click on the ‘solution explorer project name’ and right click to select the Deploy option to publish the report to the server.

Once the report is deployed to the server we can see the output message indicating that the deploy is completed.

If you get the below error
"The permissions granted to user 'domain_name\daynight' are insufficient for performing this operation."
You must open Business Intelligence Development Studio with elevated permissions:
From the Start menu, click All Programs, click SQL Server 2008, right-click Business Intelligence Development Studio, and then click Run as administrator.

More information, please see: http://msdn.microsoft.com/en-us/library/bb630430.aspx

3)Copy and paste the URL on to the browser and navigate through the URL. This will allow us to see the list of projects deployed as shown in the screen below.

Here I deployed the 2 project, if you click the "Report Project1" project, it will navigate to the next page where you can see the report listed. Click the report name, then you can the report being generated.

Configuring SQL Server Reporting Services (SSRS) in Windows Server 2008

2012-02-06T19:34:00.003-06:00

To deploy/access the report on a server, need to have the Report Server up and running. For this purpose, do some configuration for the report server.

1.Go to All Programs -> Microsoft SQL Server 2008 R2 -> Configuration Tools -> Reporting Services Configuration Manager(RSCM), RSCM will open as shown in the screen below. Select the appropriate Server and Instance Name and click on Connect as shown in the screen below.

2.Once connected successfully, you can see the Reporting Services Status as shown in the screen below.

3)Click on the Service Account to configure the account details. 2 options to select the account details. Either a)Use domain controlled user name and password. Or b)Use the built-in account as shown in the screen below. Once he account set, click on Apply button to save the configuration. Here i used settings "a)".

4)Click on to the Web Service URL to configure the Virtual Directory. Here i used the default configurations as shown in the screen below. Click on Apply button to save the changed configurations or leave it for default settings.

5)Click on the Database to set a create/use new/existing database for the SSRS for saving all the reporting server data and application data for running the reports. Click on Change Database to select the database as shown in the screen below.

6)Click on the Report Manager URL and set the Virtual Directory or by default name as shown in the screen below. Click on Apply once we are done with the configuration.

7)Once done with all the above configurations. To verify it the configurations are done perfectly, need to browse http://servername/Reports or http://localhost/Reports.

8)If you get SQL Server Reporting Services Error, like these User 'domain_name\daynightsoft' does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed.

Configure the report server for local administration. To access the report server and Report Manager locally, follow these steps:

Start Internet Explorer together with the Run as administrator option. To do this, click Start, click All Programs, right-click Internet Explorer, and then click Run as administrator. Open Report Manager. By default, the Report Manager URL is http://ServerName/reports.
Re-enter the url for Report Server Manager (http://localhost/Reports)
and you will be see the following
Click Site Settings in the upper right hand corner. You are now
in the site settings section of Report Server (if you are familiar with Windows
SharePoint Server 3.0 you will notice some similarities in the setup of the screen.
(Always nice of them to reuse good ideas.)
On the left hand side click Security
Click New Role Assignment this will take you to the page were new
users can be added with different level of security (admin or user)
Here is a summary of the roles available, paraphrased from ‘User Predefined Role’ at http://msdn.microsoft.com/en-us/library/ms157363.aspx.
In addition to setting the system roles you must setup roles for the actual folder/viewing level also. To do this return to Home, and click Folder Settings.
You will see a similar security setting page as before. Click New Role Assignment

SQL Server Reporting Services (SSRS) - Design Report

2012-02-06T17:28:00.003-06:00

Designing a report using Report Wizard

1)Programs -> Microsoft SQL Server 2008/2008 R2 -> SQL Server Business Intelligence Development Studio.

2)Create a new Project
Open File -> New -> Project (a list of templates will be display) -> Report Server Project Wizard -> Press OK button to create the project.

3)You can see a Welcome screen, press "Next >" button to process further. Now you can see a new Data Source screen. You can either use a shared data source or create a new data source.

4)Click the Edit button to connect the database as shown in the screen below. Once the database connection is set, click on OK to back the Data Source window.

5)Pres "Next" button to move the Design the Query screen. Press "Query Builder" button to open a new Query Designer window. Add authors table(and their fields) and Press OK to back Design the Query window.

6)Press Next button to select Report Type, 2 format options (Tabular and Matrix). Press Next button to Design the Table window, as shown in the screen below.

7)Press Next button to choose Table Layout screen, then press next button to move Table Style, Finally click on "Finish >>|" button to complete the wizard.

8)You can see a Completing the Wizard screen. Clicking on Finish button will open the report in the designer view of the Business Intelligence Development Studio as shown in the screen below.

9)Press F5 key or Preview link to executing/preview the report.

Designing a report using Report Designer

1)Create a new Project
Open File -> New -> Project (a list of templates will be display) -> Report Server Project -> Press OK button to create the project.

2)Under Solutions Exporter, there 3 Project folders are available (one is Report). To add the report, click on the Reports folder and select Add -> New Item. ( Selecting Add New Report will go directly to the Report Wizard that we have already covered in the top part). Select Report from the Templates and click on Add button to add a report to the project.

4)Go to the Tool Box, then drag and drop a table to design the report. Now to configure the data set first in order to design our report table as shown in the screen below.

Click on the New button to set new datasource. Press Query Designer button to select the tables, click OK to complete this process.

5)Now you can see the table created in the designer view, you can customize the report in your way as shown below.

6)Go to the project properties of the solution explorer and select the report as shown in the screen below.

7)Press F5 key or Preview link to executing/preview the report.

Creating a Report with Charts
In the left side menu, drag and drop chart and gauge control to design chart report.

Alternate row color
In report design mode, select the details row, then from the Properties panel select the BackgroundColor property and go to edit its Expression, you will find the default value is Transparent or No Value, so replace it with this line of code:
=IIF(RowNumber(Nothing) mod 2, "Wheat", "White") and click OK.

SQL Server - BLOB Import and Export

2012-01-10T19:12:00.000-06:00

SQL scripts to insert File to BLOB field and export BLOB to File

Using SQL server 2008, you can saved images / files to BLOB binaries and retrieve back them to file system.
Import
Test table structure:

CREATE TABLE [dbo].[TestBlob](
[tbId] [int] IDENTITY(1,1) NOT NULL,
[tbName] [varchar](50) NULL,
[tbDesc] [varchar](100) NULL,
[tbBin] [varbinary](max) NULL
) ON [PRIMARY]
Insert file to BLOB test table is fairly easy. Open Microsoft SQL server management studio, run the below script, script is inserting one pdf, doc, image and exe fil.

Insert TestBlob(tbName, tbDesc, tbBin) Select '81.pdf','PDF file', BulkColumn from Openrowset( Bulk 'C:\blob\udoc\81.pdf', Single_Blob) as tb

Insert TestBlob(tbName, tbDesc, tbBin) Select 'mountain.jpg','Image jpeg', BulkColumn from Openrowset( Bulk 'C:\blob\udoc\mountain.jpg', Single_Blob) as tb

Insert TestBlob(tbName, tbDesc, tbBin) Select 'Questionnaire.docx','Doc Question', BulkColumn from Openrowset( Bulk 'C:\blob\udoc\Questionnaire.docx', Single_Blob) as tb

Insert TestBlob(tbName, tbDesc, tbBin) Select 'txpeng542.exe','Texpad Exe', BulkColumn from Openrowset( Bulk 'C:\blob\udoc\txpeng542.exe', Single_Blob) as tb

Export
To export BLOB field to file, you need a SQL server utility called “bcp”, more info http://msdn.microsoft.com/en-us/library/ms162802.aspx. You can run bcp.exe from DOS command line or within SQL server management studio query window.
Enable xp_cmdshell
xp_cmdshell is a TSQL command to execute OS shell command, by default it’s not enabled. Here are the scripts to enable it 2 ways:
1. EXEC sp_configure 'show advanced options', 1;
  GO
  RECONFIGURE;
  GO
  EXEC sp_configure 'xp_cmdshell',1
  GO
  RECONFIGURE
  GO
  If you get error, use 2nd option:
  
  Configuration option 'show advanced options' changed from 0 to 1. Run the RECONFIGURE statement to install.
  Msg 5808, Level 16, State 1, Line 1
  Ad hoc update to system catalogs is not supported.
  Msg 15123, Level 16, State 1, Procedure sp_configure, Line 51
  The configuration option 'xp_cmdshell' does not exist, or it may be an advanced option.
  Msg 5808, Level 16, State 1, Line 1
  Ad hoc update to system catalogs is not supported.
2. Use Surface Area Configuration(SAC) tool to enable
  MS has removed the SAC tool that was shipped in SQL Server 2005. The Services and Connections that were once managed in SAC tool should now be managed using the SQL Server Configuration Manager. So how do you manage the Database Engine features? You can now manage the SAC for the Database Engine using Policy Based Management. A new SAC Facet in SQL Server Management Studio exposes the properties necessary to make required changes.
  
  First, right-click on the instance name that you would like to configure in SQL Server Management Studio and select "Facets" from the context menu as shown below.
  
  Select SAC from the Facet list, set True to XPCmdShellEnabled properties.
Creating a Format File, more info from microsoft link1, link2.

Declare @sql varchar(500)
SET @sql = 'bcp AdventureWorks2008R2.dbo.TestBlob format nul -T -n -f C:\dns\testblob.fmt -S ' + @@SERVERNAME
select @sql
EXEC master.dbo.xp_CmdShell @sql
Open the format testblob.fmt file, this FORMAT file mapped the whole testblob table fields.

10.0
4
1       SQLINT              0       4       ""   1     tbId             ""
2       SQLCHAR             2       50      ""   2     tbName           Latin1_General_100_CS_AS
3       SQLCHAR             2       100     ""   3     tbDesc           Latin1_General_100_CS_AS
4       SQLBINARY           8       0       ""   4     tbBin            ""
For retrieve image blob, need only the "tbBin" binary field. so manually modify the above format file to like below, Please note: original 8 change to 0 and save it:

10.0
1
1       SQLBINARY           0       0       ""   1     tbBin            ""
Execute the below script to export, 4 exported (pdf, doc, image and exe) files in the ddoc folder.
Declare @sql varchar(500)
set @sql = 'BCP "SELECT tbBin FROM AdventureWorks2008R2.dbo.TestBlob where tbId=3" QUERYOUT C:\blob\ddoc\81.pdf -T -f C:\blob\testblob.fmt -S ' + @@SERVERNAME
EXEC master.dbo.xp_CmdShell @sql

SET @sql = 'BCP "SELECT tbBin FROM AdventureWorks2008R2.dbo.TestBlob where tbId=4" QUERYOUT C:\blob\ddoc\mountain.jpg -T -f C:\blob\testblob.fmt -S ' + @@SERVERNAME
EXEC master.dbo.xp_CmdShell @sql

SET @sql = 'BCP "SELECT tbBin FROM AdventureWorks2008R2.dbo.TestBlob where tbId=5" QUERYOUT C:\blob\ddoc\Questionnaire.docx -T -fC:\blob\testblob.fmt -S ' + @@SERVERNAME
EXEC master.dbo.xp_CmdShell @sql

SET @sql = 'BCP "SELECT tbBin FROM AdventureWorks2008R2.dbo.TestBlob where tbId=6" QUERYOUT C:\blob\ddoc\txpeng542.exe -T -f C:\blob\testblob.fmt -S ' + @@SERVERNAME
EXEC master.dbo.xp_CmdShell @sql

Install Microsoft SQL Server 2008 R2

2012-01-09T10:58:00.003-06:00

Create a local user account (just user group), ‘sqlsrvdba’ for SQL Server.
Right click Setup and choose Run as administrator.
Setup will install all the require Prerequisite.
Once the installation of Prerequisite has completed successfully the SQL Server Installation Center will open up as shown in the figure.
Navigate to the Options screen to choose the appropriate Processor Type to specify the architecture of SQL Server 2008 R2 to be installed.

Choose the “System Configuration Checker” from the Planning menu, just to make sure nothing is seriously wrong. If it is,fix it, then exit the Checker.
Once that is complete, navigate “Installation”, then choose “New installation or add features to an existing installation.” This will start the installer. Follow along and enter the license key, then advance to accepting the license terms.
The installer will prompt you to install Setup Support files. You will probably get a warning for the Windows Firewall. That is because some ports needs to be opened if you plan to access your SQL Server installation from outside. Read more at http://go.microsoft.com/fwlink/?LinkId=94001. If not, no worries.
In “Setup Role” screen, choose “SQL Server Feature Installation”. On the “Feature Selection” page: Select All or Check “Instance Features -> Database Engine Services”, Under “Shared Features” choose Client Tools Connectivity, Integration Services, Management Tools – Basic, and Management Tools – Complete, SQL Server Books Online.
On the “Instance Configuration” screen: choose the default instance, leaving the instance ID set to the default (MSSQLSERVER).
Keep clicking Next until you get to the “Server Configuration” screen:
Click “Use the same account for all SQL Server services” and enter the account information for the ‘sqlsrvdba’ user you created. Set “SQL Server Agent” to startup type of Automatic. Ensure the “SQL Server Database Engine” is also set to Automatic. Double-check that “SQL Server Browser” is set to Disabled and has the account name set to “NT AUTHORITY\LOCAL SERVICE”.
On the “Database Engine Configuration” screen: On the “Account Provisioning” tab choose Mixed Mode (SQL Server authentication and Windows authentication). Set a password for the built-in SQL Server system administrator account. Under “Specify SQL Server administrators”, click Add Current User, click Add and enter the Administrators user group.
In the FILESTREAM tab, you can configure the FILESTREAM feature of SQL Server 2008 R2.
In the Analysis Services Configuration screen: In the Account Provisioning tab, click Add Current User, click Add and enter the Administrators user group.
Keep moving through the pages of the installation wizard and finish the installation, then install the latest SQL Server Service Pack.

Capability Maturity Model Integration-Development (CMMI-DEV) Process Areas

2011-10-04T16:16:00.011-05:00

Capability Maturity Model Integration-Development (CMMI-DEV) Process Areas

Process Area 0Category	Maturity Level 2	Maturity Level 3	Maturity Level 4	Maturity Level 5
Process Management		Organizational Process Focus (OPF) Organizational Process Definition (OPD) Organizational Training (OT)	Organizational Process Performance (OPP)	Organizational Performance Management (OPM)
Project Management	Requirements Management (REQM) Project Planning (PP) Project Monitoring and Control (PMC) Supplier Agreement Management (SAM)	Integrated Project Management (IPM) Risk Management (RSKM)	Quantitative Project Management (QPM)
Engineering		Requirements Development (RD) Technical Solution (TS) Product Integration (PI) Verification (VER) Validation (VAL)
Support	Configuration Management (CM) Process and Product Quality Assurance (PPQA) Measurement and Analysis (MA)	Decision Analysis and Resolution (DAR)		Casual Analysis and Resolution (CAR)

Capability Maturity Model Integration (CMMI)

2011-10-01T16:26:00.002-05:00

Overview

Capability Maturity Model Integration (CMMI) is a process improvement approach that provides organizations with the essential elements of effective processes and improve their performance.

CMMI can be used to guide process improvement across a project, a division, or an entire organization.

CMMI helps integrate traditionally separate organizational functions, set process improvement goals and priorities, provide guidance for quality processes, and provide a point of reference for appraising current processes.

The CMMI (V1.3, released October 2010) has 3 different groups (called "constellations").

Development (CMMI-DEV) - 22 Process Areas
Acquisition (CMMI-ACQ) - 21 Process Areas
Service Delivery (CMMI-SVC) - 24 Process Areas

CMMI-ACQ and CMMI-SVC are now all at V1.3.

SCAMPI - Standard CMMI Appraisal Method for Process Improvement

Maturity Levels

5 Levels are

Initial - the starting point for use of a new or undocumented repeat process.
Repeatable - the process is at least documented sufficiently such that repeating the same steps may be attempted.
Defined - the process is defined/confirmed as a standard business process.
Managed - the process is quantitatively managed in accordance with agreed-upon metrics.
Optimizing - the process management includes deliberate process optimization/improvement.

Process Areas

Each groups share 16 Core Process Areas (PA). Some of the process areas are common to other groups. Supplier Agreement Management (SAM) process area is shared between CMMI-DEV and CMMI-SVC.

Process Areas are organized in 2 main ways (called "Representations").

Staged - is designed to provide a standard sequence of improvements, and can serve as a basis for comparing the maturity of different projects and organizations.
Continuous - is designed to allow the user to focus on the specific processes that are considered important for the organization's immediate business objectives, or those to which the organization assigns a high degree of risks.

Each process area is made of 2 kinds of goals (Specific Goals (SG) and Generic Goals (GG)) , 2 kinds of practices (Specific Practices (SP) and Generic Practices (GP)) and a whole lot of
informative material.

Each Process Area (PA) includes its name, purpose and required and expected components.

CMMI Process Areas Goals and Practices

The Generic Goals(GG) and Generic Practices (GP), which apply to all Process Areas.

GG 1 - The specific goals of the process area are supported by the process by transforming identifiable input work products into identifiable output work products.
GP 1.1 - Perform the specific practices of the process area to develop work products and provide services to achieve the specific goals of the process area.
GG 2 - The process is institutionalized as a managed process.
GP 2.1 - Establish and maintain an organizational policy for planning and performing the process.
GP 2.2 - Establish and maintain the plan for performing the process.
GP 2.3 - Provide adequate resources for performing the process, developing the work products, and providing the services of the process.
GP 2.4 - Assign responsibility and authority for performing the process, developing the work products, and providing the services of the process.
GP 2.5 - Train the people performing or supporting the process as needed.
GP 2.6 - Place selected work products of the process under appropriate levels of control.
GP 2.7 - Identify and involve the relevant stakeholders as planned.
GP 2.8 - Monitor and control the process against the plan for performing the process and take appropriate corrective action.
GP 2.9 - Objectively evaluate adherence of the process and selected work products against the process description, standards, and procedures, and address non-compliance.
GP 2.10 - Review the activities, status, and results of the process with higher level management and resolve issues..
GG 3 - The process is institutionalized as a defined process.
GP 3.1 - Establish and maintain the description of a defined process.
GP 2.2 - Collect process related experiences derived from planning and performing the process to support the future use and improvement of the organization's processes and process assets.

Matrix Report using SQL Server XML and XSLT Code

2011-08-24T17:00:00.002-05:00

Desiging Matrix Report using SQL Server XML, XSLT and JAVA Code

In the above matrix report image is grouped week by employee vs employee by week.
Part 1 - SQL CODE

DECLARE @depart_id int
DECLARE @startdate datetime
DECLARE @enddate DATETIME

SET @depart_id = 314
SET @startdate = '01/01/2001'
SET @enddate = '02/28/2001'

DECLARE @e_id int
DECLARE @ename varchar(100)

Creating temporary table

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'[dbo].[#tmpWeeklyAmounts]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[#tmpWeeklyAmounts]
CREATE TABLE #tmpWeeklyAmounts(eid int, ename varchar(100), sumofspend decimal(10,2), weekenddate datetime)

Inserting employee's sum of weekly spending amount data to the temporary table.

INSERT INTO #tmpWeeklyAmounts
SELECT
 eid, ename, sum(sumofspend), weekenddate
FROM
 viewTimeSheettmpWeeklyAmounts
WHERE
 ptypeid = 2 and
 (weekenddate >= CONVERT(DATETIME, @startdate, 102)) AND
 (weekenddate <= CONVERT(DATETIME, @enddate, 102)) and departid = @depart_id
GROUP BY
 eid, ename, weekenddate, departid, departname
ORDER BY
 weekenddate

Creating Cursor, to insert null value if employee not spending amount on the weekly.

DECLARE tsweekenddate_cursor CURSOR FOR

SELECT DISTINCT eid, ename FROM #tmpWeeklyAmounts ORDER BY eid
OPEN tsweekenddate_cursor
FETCH NEXT FROM tsweekenddate_cursor INTO @e_id, @ename

WHILE @@FETCH_STATUS = 0
BEGIN
  INSERT INTO #tmpWeeklyAmounts
  SELECT DISTINCT
    @e_id, @ename, null, weekenddate
  FROM
    #tmpWeeklyAmounts
  WHERE
    weekenddate NOT IN (SELECT weekenddate FROM #tmpWeeklyAmounts WHERE eid = @e_id)
  ORDER BY
    weekenddate
  FETCH NEXT FROM tsweekenddate_cursor INTO @e_id, @ename
END

CLOSE tsweekenddate_cursor
DEALLOCATE tsweekenddate_cursor

Generating the temporary table record select statement into XML using SQL XML EXPLICIT.
List of all the distinct employee records. (i.e., top of the record, tag is 1 and parent is null)
1 NULL 1234 Kid Mah NULL NULL
1 NULL 7342 Tio Aal NULL NULL
1 NULL 7567 Sia Rbj NULL NULL

SELECT DISTINCT
  1 AS Tag,
  NULL AS Parent,
  eid AS [emp!1!eid],
  ename AS [emp!1!empname],
  null AS [ts!2!sumofspend],
  null AS [ts!2!weekenddate]
FROM
  #tmpWeeklyAmounts emp

Create a dummy one header record for the week header.(i.e., top of the record, tag is 1 and parent is null)
1 NULL 0 NULL NULL

UNION ALL
SELECT
  1 AS Tag,
  NULL AS Parent,
  0 AS [emp!1!eid],
  '' AS [emp!1!empname],
  null AS [ts!2!sumofspend],
  null AS [ts!2!weekenddate]

List of all the distinct weekend date records.(i.e., Parent of tag 1, tag is 2 and parent is 1)
2 1 0 0 01/01/2001
2 1 0 0 01/08/2001
2 1 0 0 01/15/2001

UNION ALL
SELECT DISTINCT
  2 AS Tag,
  1 AS Parent,
  0 AS [emp!1!eid],
  '' AS [emp!1!empname],
  0 AS [ts!2!sumofspend],
  CONVERT(VARCHAR(10),weekenddate,101) AS [ts!2!weekenddate]
FROM
  #tmpWeeklyAmounts ts

List of all the distinct employee's and weekend's sum of spending amount records.(i.e., tag is 2 and parent is 1)
2 1 1234 Mdr Mih NULL 01/01/2001
2 1 1344 Mdr Mih NULL 01/08/2001
2 1 1454 Mdr Mih 21.50 01/29/2001
2 1 1564 Mdr Mih 0.00 01/15/2001
2 1 1674 Mdr Mih 3.00 01/22/2001
2 1 7892 Mbo Ahl .00 01/15/2001
2 1 7902 Mbo Ahl .00 01/29/2001
2 1 7122 Mbo Ahl 11.00 01/08/2001
2 1 7142 Mbo Ahl 21.00 01/01/2001

UNION ALL
SELECT DISTINCT
  2 AS Tag,
  1 AS Parent,
  eid AS [emp!1!eid],
  ename AS [emp!1!empname],
  sumofspend AS [ts!2!sumofspend],
  CONVERT(VARCHAR(10),weekenddate,101) AS [ts!2!weekenddate]
FROM
  #tmpWeeklyAmounts ts

Order by empname and weeek end, list of all the combine records are converted into XML format.
1 NULL 0 NULL NULL
2 1 0 .00 01/01/2001
2 1 0 .00 01/08/2001
2 1 0 .00 01/15/2001
1 NULL 21261 Mke Dkn NULL NULL
2 1 21261 Mke Dkn NULL 01/01/2001
2 1 21261 Mke Dkn NULL 01/08/2001
2 1 21261 Mke Dkn NULL 01/15/2001
1 NULL 33219 Maa Dlk NULL NULL

ORDER BY
[emp!1!empname],[ts!2!weekenddate]
FOR XML EXPLICIT

Delete temporary table

DROP TABLE #tmpWeeklyAmounts

Final XML Output

XML_F52E2B61-18A1-11d1-B105-00805F49916B
<emp eid="0" ename="">
 <ts sumofspend="0.00" weekenddate="01/01/2001"/>
 <ts sumofspend="0.00" weekenddate="01/08/2001"/>
 <ts sumofspend="0.00" weekenddate="01/15/2001"/>
</emp>
<emp eid="7122" ename="Mbo Ahl">
 <ts sumofspend="2.00" weekenddate="01/01/2011"/>
 <ts sumofspend="1.00" weekenddate="01/08/2011"/>
 <ts sumofspend="0.00" weekenddate="01/15/2011"/>
</emp>
<emp eid="6723" ename="Est Vid">
 <ts sumofspend="5.00" weekenddate="01/01/2011"/>
 <ts sumofspend="16.00" weekenddate="01/08/2011"/>
 <ts sumofspend="40.00" weekenddate="01/15/2011"/>
</emp>

Part 2 - Java Code
Read the above records through any program language (like .net, java or php). Here i put java code example to understand to retrieve XML records and pass to the XSLT code. Finally XSLT code is displaying final matrix report.
Java Database Code.

//Database Connection Code
//Calling Stored Procedure through CallableStatement and execute
conDB.prepareCall("{call uspDepart_amount_By_Weekendd()}");
// Return xml based results, assign to string
ResultSet rs = csReport.getResultSet();
while (rs.next()) {
xmlOutput = xmlOutput+rs.getString("XML_F52E2B61-18A1-11d1-B105-00805F49916B");
}

Java XML Transform code.

//Close both resultset and connection
//Call javax.xml.transform.* function to transform XML to XSLT.
TransformerFactory tf = TransformerFactory.newInstance();
StreamResult tr = new StreamResult( new ByteArrayOutputStream() );
//Pass xsl file name with full path.
Transformer trans = tf.newTransformer(new StreamSource("depart_amount_by_weekend.xsl"));
//Pass parameter if any to display header information.
trans.setParameter("param1", "01/01/2001");
trans.setParameter("param2", "02/25/2001");
//Pass SQL XML output result.
trans.transform(new StreamSource(new StringReader("<Reports>"+xmlOutput +"</Reports>")), tr);
//Print matrix report.
out.println((tr.getOutputStream().toString()).trim());

Part 3 - XSLT Code - depart_amount_by_weekend.xsl

<?xml version='1.0'?>
<xsl:stylesheet xmlns:xsl='http://www.w3.org/1999/XSL/Transform' version='1.0'>
<xsl:param name="param1" select="Value"/>
<xsl:param name="param2" select="Value"/>

Parsing xml.

<xsl:template match='Reports'>
 <xsl:variable name="totalweekend" select="0"/>
 <HTML>
 <BODY valign="top"><TABLE cellSpacing='0' cellPadding='0' width="100%" border='1' valign="top"><TBODY valign="top">
 <TR valign="top">
 <TD class='title1' nowrap="nowarp">Name</TD>

Display header information with the weekend date data.

<xsl:for-each select="emp[@eid=0]">
 <xsl:for-each select="ts">
 <TD class='title1' align='center'><xsl:value-of select="substring(@weekenddate,1,5)"/></TD>
 </xsl:for-each>
 </xsl:for-each>
 <TD class='title1' align='center'>Total</TD>
 </TR>

Count total number of weekend date.

<xsl:variable name="totalweekend"><xsl:value-of select="count(emp[@eid=0]/ts/@weekenddate)" /></xsl:variable>
 <xsl:for-each select="emp[@eid!=0]">
 <TR valign="top">

Display employee name.

Display corresponding employee's amount.

<xsl:for-each select="ts">
 <TD align="right">
 <xsl:value-of select="@sumofspend"/>
 <xsl:text disable-output-escaping="yes">  </xsl:text>
 </TD>
 </xsl:for-each>

Calculate sum of row wise (employee) total amount of all the week.

<xsl:call-template name="for.loop">
 <xsl:with-param name="i"><xsl:value-of select="count(ts/@weekenddate)+1"/></xsl:with-param>
 <xsl:with-param name="count"><xsl:value-of select="$totalweekend"/></xsl:with-param>
 <xsl:with-param name="class"></xsl:with-param>
 <xsl:with-param name="cellvalue"></xsl:with-param>
 <xsl:with-param name="type">display</xsl:with-param>
 </xsl:call-template>
 <TD nowrap="nowarp" class='title1' align="right"><xsl:value-of select="format-number(sum(ts/@sumofspend), '##,##,##0.00')"/><xsl:text disable-output-escaping="yes">  </xsl:text></TD>
 </TR>
 </xsl:for-each>

Calculate sum of column wise (weekend) total amount of all the employee.

<TR valign="top">
 <TD class='title1' nowrap="nowarp" align="right">Total<xsl:text disable-output-escaping="yes">  </xsl:text></TD>
 <xsl:call-template name="for.loop">
 <xsl:with-param name="i">1</xsl:with-param>
 <xsl:with-param name="count"><xsl:value-of select="$totalweekend"/></xsl:with-param>
 <xsl:with-param name="class">title1</xsl:with-param>
 <xsl:with-param name="type">total</xsl:with-param>
 <xsl:with-param name="cellvalue"><xsl:value-of select="format-number(sum(emp/ts[1]/@sumofspend), '##,##,##0.00')"/></xsl:with-param>
 </xsl:call-template>
 <TD nowrap="nowarp" class='title1' align="right"><xsl:value-of select="format-number(sum(emp/ts/@sumofspend), '##,##,##0.00')"/><xsl:text disable-output-escaping="yes">  </xsl:text></TD>
 </TR>
 </TBODY></TABLE></BODY>
 </HTML>
</xsl:template>

Function for sum of amounts.

<xsl:template name="for.loop">
 <xsl:param name="i" />
 <xsl:param name="count" />
 <xsl:param name="class" />
 <xsl:param name="cellvalue" />
 <xsl:param name="type" />
 <xsl:if test="$i <= $count">
 <TD align="right"><xsl:attribute name="class"><xsl:value-of select="$class"/></xsl:attribute><xsl:value-of select="$cellvalue"/><xsl:text disable-output-escaping="yes">  </xsl:text></TD>
 </xsl:if>

 <xsl:if test="$i <= $count">
 <xsl:call-template name="for.loop">
 <xsl:with-param name="i"> <xsl:value-of select="$i + 1"/></xsl:with-param>
 <xsl:with-param name="count"> <xsl:value-of select="$count"/></xsl:with-param>
 <xsl:with-param name="class"> <xsl:value-of select="$class"/></xsl:with-param>
 <xsl:with-param name="cellvalue">
 <xsl:if test="$type='total'">
 <xsl:value-of select="format-number(sum(emp/ts[$i+1]/@sumofspend), '##,##,##0.00')"/>
 </xsl:if>
 </xsl:with-param>
 <xsl:with-param name="type"> <xsl:value-of select="$type"/></xsl:with-param>
 </xsl:call-template>
 </xsl:if>
</xsl:template>
</xsl:stylesheet>

ASP.NET Custom Errors(customErrors) and URL Mappings (urlMappings)

2011-08-16T14:42:00.002-05:00

URL Mappings

Open web.config file. (see MSDN)
Create new urlMappings section within the system.web section.
<urlMappings enabled="true">
<add url="~/contactus.aspx" mappedUrl="~/index.aspx" />
</urlMappings>
If user types contactus.aspx, page mapped to the index.aspx.
This approach won't work if you have 100 of pages to map.
Best solution is to use regular expressions, but ASP.NET does not support. SEE
URL Rewriting

Custom ASP.NET Error Pages

Open web.config file. (see MSDN)
Modify/Create the <customErrors> section within the system.web section.
<customErrors mode="On" defaultRedirect="GenericErrorPage.htm">
<error statusCode="404" redirect="FileNotFound.htm" />
<error statusCode="403" redirect="~/errors/NoAccess.htm" />
</customErrors>
redirect url may be relative(~/errors/PageNotFount.aspx) or absolute (http://makdns.blogspot.com/errors/PageNotFount.aspx)
~ point to the root of your web application

Custom Non-ASP.NET Error Pages (HTML, ASP,..)

Open the Internet Services Manager.
Expand your Default Web Site.
Right-click and select Properties.
Click the Custom Errors tab.
Scroll down and highlight the 404 HTTP error and click Edit Properties.
Change Message Type to URL.
Enter the URL to "/FileNotFound.aspx".
Click OK.

XSLT Pagination and For Loop Code

2011-08-09T12:42:00.020-05:00

For Loop 1 - 10

<xsl:call-template name="forloop">
 <xsl:with-param name="i"><xsl:value-of select="count(ts/@weekenddate)+1"/></xsl:with-param>
 <xsl:with-param name="count"><xsl:value-of select="$totalweekend"/></xsl:with-param>
</xsl:call-template>

<xsl:template name="forloop">
 <xsl:param name="i" />
 <xsl:param name="count" />
 <xsl:if test="$i <= $count"><TD align="center"> </TD></xsl:if>

 <xsl:if test="$i <= $count">
 <xsl:call-template name="for.loop">
 <xsl:with-param name="i">
 <xsl:value-of select="$i + 1"/>
 </xsl:with-param>
 <xsl:with-param name="count">
 <xsl:value-of select="$count"/>
 </xsl:with-param>
 </xsl:call-template>
 </xsl:if>
</xsl:template>

Pagination

<?xml version="1.0" ?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
 <xsl:param name='page' select='Value'/>
 <xsl:param name='startpageposition' select='Value'/>
 <xsl:param name='displayrecord' select='Value'/>
 <xsl:param name='displaypage' select='Value'/>
 <xsl:include href="xslPaginationNumber.xsl"/>
 <xsl:template match="NewDataSet">
 <td class="veranda10" vAlign="middle"><td>
 <xsl:call-template name="Pagination">
 <xsl:with-param name="TotalRecord"><xsl:value-of select="count(AgencyList/id)"/></xsl:with-param>
 </xsl:call-template>
 </td>
 </xsl:template>

<xsl:template name="Pagination">
 <xsl:param name="TotalRecord"/>
 <xsl:if test="$startpageposition > 1">
 <a><xsl:attribute name="href">javascript:SearchProfileResults(<xsl:value-of select="($displaypage * ($startpageposition -1))"/>,<xsl:value-of select="$startpageposition - 1"/>,)</xsl:attribute>«</a>
 </xsl:if>
 <xsl:if test="$startpageposition = 1">
 <xsl:text disable-output-escaping="yes">  </xsl:text>
 <xsl:attribute name="href">javascript:SearchProfileResults('1','1',)</xsl:attribute>«
 </xsl:if>

 <xsl:call-template name="PaginationPublic">
 <xsl:with-param name="TotalRecord"></xsl:with-param>
 <xsl:with-param name="DisplayRecord"><xsl:value-of select="$displayrecord"/></xsl:with-param>
 <xsl:with-param name="displaypage"><xsl:value-of select="$displaypage"/></xsl:with-param>
 </xsl:call-template>
 <xsl:choose>
 <xsl:when test="ceiling($TotalRecord div ($displaypage * $displayrecord))>1 and (($displaypage *(10* $startpageposition)) < $TotalRecord)">
 <xsl:text disable-output-escaping="yes">  </xsl:text>
 <a><xsl:attribute name="href">javascript:SearchProfileResults(<xsl:value-of select="($displaypage * $startpageposition) +1"/>,<xsl:value-of select="$startpageposition + 1"/>,)</xsl:attribute>»</a>
 </xsl:when>
 <xsl:otherwise>
 <xsl:text disable-output-escaping="yes">  </xsl:text>
 <xsl:attribute name="href">javascript:SearchProfileResults(<xsl:value-of select="($displaypage * $startpageposition) +1"/>,<xsl:value-of select="$startpageposition + 1"/>,)</xsl:attribute>»
 </xsl:otherwise>
 </xsl:choose>
</xsl:template>

<xsl:template name = "PageNumberDisplay">
 <xsl:param name="aListPageNo"/>
 <xsl:param name="aListPageValue"/>
 <a><xsl:attribute name="href">subcon.aspx?page=<xsl:value-of select="$aListPageValue"/>&spage=<xsl:value-of select="$startpageposition"/></xsl:attribute><xsl:value-of select="$aListPageNo"/></a>
 </xsl:template>
</xsl:stylesheet>

<xsl:include href="xslPaginationNumber.xsl"/>

<?xml version="1.0" ?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:template name="PaginationPublic">
 <xsl:param name="TotalRecord"/>
 <xsl:param name="DisplayRecord"/>
 <xsl:param name="displaypage"/>
 Pages
 <xsl:choose>
 <xsl:when test="$TotalRecord > $DisplayRecord">
 <xsl:text disable-output-escaping="yes">  </xsl:text>
 <xsl:call-template name="CountPages">
 <xsl:with-param name="startCount">
 <xsl:value-of select="(($startpageposition - 1) * $displaypage) + 1"/>
 </xsl:with-param>
 <xsl:with-param name="pagecount">
 <xsl:value-of select="ceiling($TotalRecord div $DisplayRecord)"/>
 </xsl:with-param>
 <xsl:with-param name="startpageposition">
 <xsl:value-of select="$startpageposition"/>
 </xsl:with-param>
 </xsl:call-template>
 </xsl:when>
 <xsl:otherwise>
 <xsl:text disable-output-escaping="yes">  </xsl:text>
 1
 </xsl:otherwise>
 </xsl:choose>
 
</xsl:template>

<xsl:template name="CountPages">
 <xsl:param name="startCount"/>
 <xsl:param name="pagecount"/>
 <xsl:param name="startpageposition"/>
 <xsl:if test="$startCount != $page">
 <xsl:call-template name="PageNumberDisplay">
 <xsl:with-param name="aListPageNo">
 <xsl:value-of select="$startCount"/>
 </xsl:with-param>
 <xsl:with-param name="aListPageValue">
 <xsl:value-of select="$startCount"/>
 </xsl:with-param>
 </xsl:call-template>
 </xsl:if>
 <xsl:if test="$startCount = $page">
 <xsl:value-of select="$startCount"/>
 </xsl:if>
 <xsl:text disable-output-escaping="yes">  </xsl:text>
 <xsl:if test="$startCount!= $pagecount">
 <xsl:call-template name="CountPages">
 <xsl:with-param name="pagecount">
 <xsl:value-of select="$pagecount"/>
 </xsl:with-param>
 <xsl:with-param name="startCount">
 <xsl:value-of select="$startCount+1"/>
 </xsl:with-param>
 <xsl:with-param name="startpageposition">
 <xsl:value-of select="startpageposition"/>
 </xsl:with-param>
 </xsl:call-template>
 </xsl:if>
</xsl:template>

<xsl:template name="PaginationPublicB">
 <xsl:param name="TotalRecord"/>
 <xsl:choose>
 <xsl:when test="$TotalRecord > $DisplayRecord">
 <xsl:text disable-output-escaping="yes">  </xsl:text>
 <xsl:call-template name="CountPagesB">
 <xsl:with-param name="startCount">
 <xsl:value-of select="(($startpageposition - 1) * $displaypage) + 1"/>
 </xsl:with-param>
 <xsl:with-param name="pagecount">
 <xsl:value-of select="ceiling($TotalRecord div $DisplayRecord)"/>
 </xsl:with-param>
 <xsl:with-param name="startpageposition">
 <xsl:value-of select="$startpageposition"/>
 </xsl:with-param>
 </xsl:call-template>
 </xsl:when>
 <xsl:otherwise>
 <xsl:text disable-output-escaping="yes">  </xsl:text>
 1
 </xsl:otherwise>
 </xsl:choose>
</xsl:template>

<xsl:template name="CountPagesB">
 <xsl:param name="startCount"/>
 <xsl:param name="pagecount"/>
 <xsl:param name="startpageposition"/>
 <xsl:if test="$startCount != $page">
 <xsl:call-template name="PageNumberDisplay">
 <xsl:with-param name="aListPageNo">
 <xsl:value-of select="$startCount"/>
 </xsl:with-param>
 <xsl:with-param name="aListPageValue">
 <xsl:value-of select="$startCount"/>
 </xsl:with-param>
 </xsl:call-template>
 </xsl:if>
 <xsl:if test="$startCount = $page">
 <xsl:value-of select="$startCount"/>
 </xsl:if>
 <xsl:if test="(($startCount >= ((($startpageposition - 1) * $displaypage) + 1)) and ($startCount < ($startpageposition * $displaypage)) )">
 <xsl:text disable-output-escaping="yes">  </xsl:text>
 <xsl:if test="$startCount!= $pagecount">
 <xsl:call-template name="CountPages">
 <xsl:with-param name="pagecount">
 <xsl:value-of select="$pagecount"/>
 </xsl:with-param>
 <xsl:with-param name="startCount">
 <xsl:value-of select="$startCount+1"/>
 </xsl:with-param>
 <xsl:with-param name="startpageposition">
 <xsl:value-of select="startpageposition"/>
 </xsl:with-param>
 </xsl:call-template>
 </xsl:if>
 </xsl:if>
</xsl:template>
</xsl:stylesheet>

Regular Expressions - Java Matcher

2011-08-04T12:17:00.004-05:00

Class Import

import java.util.regex.Matcher;
import java.util.regex.Pattern;
Regular Expressions
Find, Group Method - Words example

Pattern word = Pattern.compile("\\G\\w+");
//Pattern word = Pattern.compile("\\w+");
Matcher mat = word.matcher("this is a java reqular expression 19th blog. JAVA blog");
mat.find(); //true
while (mat.find())
m.groupCount() // 0
mat.group();
/*
this
is
a
java
reqular
expression
19th
blog
*/

Pattern p = Pattern.compile("j(av)a");
mat.group(0); // java
mat.group(1); // ava

Pattern p = Pattern.compile("java", Pattern.CASE_INSENSITIVE);
Matcher mat = p.matcher("this is a java reqular expression 19th blog. JAVA blog");
mat.find(0); //java
mat.find(1); //JAVA

Pattern,Reset Method

mat.pattern(); // \\w+
mat.reset("this is a java matcher reset");
Start/End Method

Pattern p = Pattern.compile("java");
mat.find();
mat.start(); //10
mat.end() // 14

Pattern p = Pattern.compile("j(ava)");
mat.find();
mat.start(0); // 10
mat.start(1); // 11

Pattern p = Pattern.compile("j(av)a");
mat.end(0); // 14
mat.end(1); // 13
Matcher, AppendReplacement, AppendTail Method

Pattern p = Pattern.compile("JAVA");
Matcher mat = p.matcher("java"); //false
mat = p.matcher("JAVA"); //true

Pattern p = Pattern.compile("(Java) (blog)");
StringBuffer sb = new StringBuffer();
String str = "this is a Java reqular expression 19th blog. Java blog.";
Matcher mat = p.matcher(str);
mat.find();
mat.appendReplacement(sb, "$1 REGEX $2");
sb.toString();

//Apply proper uppercase and lowercase on a String
StringBuffer sb = new StringBuffer();
Matcher mat = Pattern.compile("([a-z])([a-z]*)", Pattern.CASE_INSENSITIVE).matcher(str);
while (m.find()) {
mat.appendReplacement(sb, m.group(1).toUpperCase() + m.group(2).toLowerCase());
}
mat.appendTail(sb).toString();
// This Is A Java Reqular Expression 19Th Blog. Java Blog.
LookingAt Method

Pattern p = Pattern.compile("JAVA");
Matcher mat = p.matcher("JAVA Regex Blog");
mat.lookingAt()); \\true
mat.reset("Blog JAVA Regex");
mat.lookingAt()); \\false
mat.reset("JAVARegex");
mat.lookingAt()); \\true
ReplaceFirst, ReplaceAll Method

Pattern p = Pattern.compile("(j|J)ava");
Matcher mat = p.matcher("this is a java reqular expression 19th blog. JAVA blog");
mat.replaceAll(".NET"); // this is a .NET reqular expression 19th blog. JAVA blog

Pattern p = Pattern.compile("java", Pattern.CASE_INSENSITIVE);
mat.replaceAll(".NET"); // this is a .NET reqular expression 19th blog. .NET blog
Multline Match - Pattern.DOTALL, Pattern.MULTILINE

Pattern p = Pattern.compile("blog.JAVA blog");
p.matcher("this is a java reqular expression 19th blog\nJAVA blog").find(); \\ false
Pattern p = Pattern.compile("blog.JAVA blog", Pattern.DOTALL | Pattern.MULTILINE);
p.matcher("this is a java reqular expression 19th blog\nJAVA blog").find(); \\ true
Split up Code

Pattern p = Pattern.compile("[,\\s]+");
String[] result = splitter.split("Red,White, Blue Green Yellow, Orange");
for (String colour : result) System.out.println(colour);
Ignore case differences

String str = "this is a Java reqular expression 19thBlog.Java regex.";
str.matches("(?i).*blog.*") //true
Match Punctuation

Pattern p = Pattern.compile("\\G\\p{Punct}");
Matcher mat = p.matcher("this is a java 19th blog");
mat.find(); \\false
mat = p.matcher("@)($)word@google.com#)(*$&$");
mat.find() \\true
Split

String input = "This!!is!!java blog!!19th";
Arrays.asList(Pattern.compile("!!").split(input)) \\[This, is, java blog, 19th]
//split first 3
Arrays.asList(Pattern.compile("!!").split(input, 3)) \\[This, is, java blog||19th]
Split

String statement = "I will learn. I will cooperate. There will be no work, no billable, no "
+ "finding the programmer, and no income and outcome.";

Sring splitPattern = "learn|cooperate|work|billable|(finding the programmer)|(income and outcome)";

String tokens[] = statement.split(splitPattern);

for (int i = 0; i < tokens.length; i++) System.out.println(tokens[i]); /*I will . I will . There will be no , no , no , and no .*/

Regular Expressions

2011-08-03T17:03:00.005-05:00

Pattern Description

[]	Matches any single character [ae] "a" in "orange", "a" and "e" in "lane"	Character Classes
[^]	Not matches any single character [^aeio] "r", "g","n" in "region"	Character Classes
[start - end]	Matches any single character in the range from start to end. [A-Z] "A", "B" in "AB123"	Character Classes
.	Matches any single character except \n. a.e => "ave" in "nave" , "ate" in "water"	Character Classes
*	Matches the previous element zero or more times. "be+" => "bee" in "been", "be" in "bent"	Quantifiers
+	Matches the previous element one or more times. \\d*\\.\\d = > ".0", "19.9", "219.9"	Quantifiers
?	Matches the previous element zero or one time. "rai?n" = > "ran", "rain"	Quantifiers
{ n }	Matches the previous element exactly n times. ",\\d{3}" = >",043" in "1,043.6", ",876",",210" in "9,876,210"	Quantifiers
{ n ,}	Matches the previous element one or more times. "\d{2,}" = > "166", "29", "1930"	Quantifiers
{ n , m }	Matches the previous element at least n times, but no more than m times. \d{3,5}" = > "166", "17668" , => "19302" in "193024"	Quantifiers
*?	Matches the previous element zero or more times, but as few times as possible. \d*?\.\d => ".0", "19.9", "219.9"	Quantifiers
+?	Matches the previous element one or more times, but as few times as possible. "be+?" = > "be" in "been", "be" in "bent"	Quantifiers
??	Matches the previous element zero or one time, but as few times as possible. "rai??n" => "ran", "rain"	Quantifiers
{ n }?	Matches the preceding element exactly n times. \\",\\d{3}?" = > ",043" in "1,043.6", ",876", ",210" in "9,876,210"	Quantifiers
{ n ,}?	Matches the previous element at least n times, but as few times as possible. "\\d{2,}?" = > "166", "29", "1930"	Quantifiers
{ n , m }?	Matches the previous element between n and m times, but as few times as possible. \\d{3,5}?" => "166", "17668" , => "193", "024" in "193024"	Quantifiers
^	Match must occur at the beginning of the string/line ^\\d{3} = > "901-" in "901-333-"	Anchors
$	Match must occur at the end of the string/line or before \n at the end of the string/line. -\\d{3}$ = > "-333" in "901-333"	Anchors
\\A	Match must occur at the beginning of the string/line (no multiline support) \\A\\d{3} = > "901" in "901-333"	Anchors
\\Z	Match must occur at the end of the string or before \n at the end of the string -\\d{3}\\Z = > "901" in "901-333"	Anchors
\\z	Match must occur at the end of the string only -\\d{3}\\z = > "-333" in "901-333"	Anchors
\\G	Begin where the last match ended \\G$\\d\$ => "(1)", "(3)", "(5)" in "(1)(3)(5)[7](9)"	Anchors
\\b	Match must occur on a word boundary \\b\\w+\\s\\w+\\b => "them them" in "them theme them them"	Anchors
\\B	Match must not occur on a word boundary Bend\\w*\\b = > "ends", "ender" in "end sends endure lender"	Anchors
\\w	Match any word characters "I", "D", "A", "1", "3" in "ID A1.3"	Character Classes
\\W	Match any non word characters " ", "." in "ID A1.3"	Character Classes
\\w+	Match one or more word characters
\\w*	Match zero or more word characters
\\s	Match any white space character "D " in "ID A1.3"	Character Classes
\\S	Match any non white space character " _" in "int __ctr"	Character Classes
\\s?	Match zero or one space
\\s*	Match zero or more space
\\d	Match any decimal digit "4" in "4 = IV"	Character Classes
\\D	Match any character not decimal digit " ", "=", " ", "I", "V" in "4 = IV"	Character Classes
[0-9]+	Match one or more decimal digits
[0-9]{0,3}	Match 0 to 3 occurrence of the decimal digits 0 through 9
[-+]?	Match zero or one of either a positive or negative sign

Pattern
SSN pattern: "\d{3}-\d{2}-\d{4}"
ZIP pattern: "\d{5}(-\d{4})?"
US Phone pattern: "(\\d-)?(\\d{3}-)?\\d{3}-\\d{4}"
Date format pattern: "\\d{1,2}(/|-)\\d{1,2}\\1(\\d{4}|\\d{2})$"
Email pattern: "^[\\w-_\\.+]*[\\w-_\\.]\\@([\\w]+\\.)+[\\w]+[\\w]$"
URL pattern: "http://([\w-]+\.)+[\w-]+(/[\w- ./?%&=]*)?"
IPAddress pattern: "^((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9][0-9]|[0-9])\.){3}(25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9][0-9]|[0-9])$"

LDAP

2011-07-28T11:04:00.003-05:00

LDAP is the Lightweight Directory Access Protocol, is an application protocol for accessing and maintaining distributed server directory information services over an TCP/IP network.
LDAP Servers - Netscape Directory Server, Microsoft Active Directory (AD), Novell Directory Services (NDS), Sun Directory Services (SDS), ucent's Internet Directory Server (IDS)
LDAP uses a client server model, with clients sending LDAP request over TCP/IP to the server.
Stores attribute based data information. Stores these entries in a hierachial structure (i.e., Directory Information Tree(DIT)), based on the unique identifier (Distinguish Name(DN)).
Designed to be read data more than written, such as No transactions or rollback.

LDIF - LDAP Data Interchange Format, is a human readable format, to allow easily
exchanging and modifying of the data.

ldbmcat converts ldbm database to ldif. ldif2ldbm converts ldif back to ldbm database.

LDIF example, entry for a user account
dn : CN=Day Night,CN=Users,DC=DNS,DC=local
cn: Day Night
objectclass: top
objectclass: person
objectclass: organizationalPerson
objectclass: user
mail : mkader@daynightsoft.com
mailnickname : mkader
memberof : CN=DNS-SPAdmin,CN=Users,DC=DNS,DC=local
Abbreviations
uid - User ID
cn - Comman Name
sn - Surname
l - Location
ou - Organization Unit
o- Organization
dc - domain Component
st - state
c - country
oid - Object Identifier
RDN - Relative Distinuished Name
Search Filters - Criteria for attributes that must be fulfilled for an entry to be returned, and a base DN that the search is performed against

Operators
& - and
| - or
! - not
~= - approx equal
>= - greater than or equal
<= - less than or equal
* - any

Example
(&(uid=d*)(uid=*l)) - search for all users who's userid (uid), started with d and ended with l. (cn=Jim*)
LDAP URL - ldap://hostname:[portnumber]/[attributes][ "?" scope "?" filter]

attributes - List of attributes you want returned
scope - base = base object search, one = one level search, sub = subtree search
filter - Standard LDAP search filter

Examples:
LDAP://DNS-FPS01.DNS.local:389/DC=DNS,DC=local
ldap://ldap.sun.com/dc=bar,dc=com?cn?sub?uid=jim
LDAP Windows AD Search
Open Active Directory Users and Computers. Right-click the domain object and select Find.

Click the drop-down list next to Find, and then select Custom Search. From the next screen, select the Advanced tab. Type the appropriate LDAP statement under Enter LDAP query.
LDAP WINDOWS AD search using LDP tool
Open LDP and connect to a valid domain controller.
LDAP command line UNIX tools
ldapadd, ldapmodify - Used to add or modify ldap entries
$ ldapmodify -r -D 'cn=foo,dc=bar,dc=com' -W < /tmp/user.ldif
ldapdelete - Used to delete entries
$ ldapdelete -D 'cn=foo,dc=bar,dc=com' -W 'cn=user,dc=bar,dc=com'
ldapsearch - Used to search ldap servers
$ ldapsearch -L -D 'cn=foo,dc=bar,dc=com' 'objectclass=posixAccount'

Puzzle 'N' Relax - Intel Algorithm

2011-07-18T10:37:00.120-05:00

Find out the minimum palindrome cost.

A palindrome is a string that reads the same from left to right as it does from right to left.

The length of a input String s is even. Each character of s is either 'o', 'x', or '?' Your task in this problem is to replace each occurrence of '?' in s with either 'o' or 'x' so that s becomes a palindrome. You are also given integers oCost and xCost. Replacing '?' with 'o' costs oCost, and replacing '?' with 'x' costs xCost.

Return the minimum cost of replacing '?'s by 'x's and 'o's that turns s into a palindrome. If it is impossible to obtain a palindrome, return -1 instead.

Method: public int getMinimum(String s, int oCost, int xCost)

Examples
1)i/p="oxo?xox?", 3, 5
Returns: 8
Steps are
s[7] = ? = > s[7] replace by 'o' of s[0]. s[7] = o, so cost is 3.
s[3] = ? = > s[3] replace by 'x' of s[4]. s[2] = x, so cost is 5.
Total Cost is 8.

2)i/p="x??x", 9, 4
Returns: 8
Steps are
s[1] = s[2] = ? > both are replaced by minimum cost 4 is 'x'.
Total Cost is 8.

3)i/p="ooooxxxx",12,34
Returns: -1
Steps are
No '?' character, and s is not a palindrome.
Total Cost is -1.

4)i/p="oxoxooxxxxooxoxo",7,4
Returns: 0
Steps are
No '?' character, and s is already a palindrome.
Total Cost is 0.

5)i/p="?o", 6, 2
Returns: 6
Steps are
s[0] = ? = > s[0] replace by 'o' of s[1]. s[0] = o, so cost is 6.
Total Cost is 6.

import java.util.*;

import java.util.Arrays;
import java.util.Collections;

public class MinCostPalindrom {
public int getMinimum(String s, int oCost, int xCost) {
 int totalvalue = 0;
 int slen = s.length()-1;
 for (int i=0;i<=slen/2;i++) { if (s.charAt(i)=='?' && s.charAt(slen-i)=='?') { if (oCost>xCost) totalvalue+=xCost+xCost; else totalvalue+=oCost+oCost;
 } else if (s.charAt(i)!=s.charAt(slen-i)) {
 if (s.charAt(i)=='?') {
 if (s.charAt(slen-i)=='o') totalvalue+=oCost; else totalvalue+=xCost;
 } else if (s.charAt(slen-i)=='?') {
 if (s.charAt(i)=='o') totalvalue+=oCost; else totalvalue+=xCost;
 } else
 return -1;
 }
 }
return totalvalue;
}

public static void main(String[] args) {
 MinCostPalindrom mp = new MinCostPalindrom();
 System.out.println(mp.getMinimum("oxo?xox?", 3, 5));
 System.out.println(mp.getMinimum("x??x",9,4));
 System.out.println(mp.getMinimum("ooooxxxx",12,34));
 System.out.println(mp.getMinimum("oxoxooxxxxooxoxo",7, 4));
 System.out.println(mp.getMinimum("?o",6,2));
 System.out.println(mp.getMinimum("????????????????????",50,49));
 System.out.println(mp.getMinimum("o??oxxo?xoox?ox??x??",3,10));
 System.out.println(mp.getMinimum("??o?x??o????", 3, 36));
}
}

Find out the maximum cut.

Kader only likes to eat eels of length exactly 10, no more, no less. Before she eats, she may cut the eels to prepare pieces of desired length. However, she only has the time to make at most maxCuts cuts. You are given a int[] eelLengths. Each element of eelLengths is the length of one of the eels Kader has at the beginning. You are also given the int maxCuts. Return the maximum number of eels of length exactly 10 she can produce.

Method: public int getMaximum(int[] eelLengths, int maxCuts)

Examples
1)i/p={13,20,13}, 2
Returns: 3
Steps are
13 = 13/10 = 1, exactly 10 length 10 is 1.
20 = 20/10 = 2, exactly 10 length is 2, total is 3. (reached maxcuts 2).
Total is 3.

2)i/p={5, 5, 5, 5}, 2
Returns: 0
All are less then 10.

3)i/p={34, 10, 48}, 4
Returns: 5
Steps are
34 = 34/10 = 3 = 3 (maxcuts 5-3= 2)
10 = 10/10 = 1 = 4
48 = 48/10 - 4 = 1(exceed maxcuts 4>2)

4)i/p={30, 50, 30, 50}, 350
Returns: 16

public class Cut {
public int getMaximum(int[] eel, int maxCuts) {
 int tcut =0;
 Arrays.sort(eel);
 for(int i = 0; i < eel.length; i++) {
if(eel[i]%10 == 0) {
while(eel[i] > 10 && maxCuts >0) {
 eel[i] -= 10;
 tcut++;
 maxCuts--;
 }
 if(eel[i] == 10) {
 tcut++;
 eel[i] = 0;
 }
 }
 }
 Arrays.sort(eel);
 for(int i = 0; i 10 && maxCuts > 0) {
 eel[i] -= 10;
 maxCuts--;
 tcut++;
 }
 }
 return tcut;
}

public static void main(String[] args) {
 Cut c = new Cut();
 System.out.println(c.getMaximum(new int[]{13,20,13}, 2)); //3
 System.out.println(c.getMaximum(new int[]{5, 5, 5, 5}, 2)); //0
 System.out.println(c.getMaximum(new int[]{34, 10, 48}, 4)); //5
 System.out.println(c.getMaximum(new int[]{30, 50, 30, 50}, 350)); //16
 System.out.println(c.getMaximum(new int[]{1}, 1)); //0
 System.out.println(c.getMaximum(new int[]{10}, 1)); //1
 System.out.println(c.getMaximum(new int[]{20}, 1)); //2
 System.out.println(c.getMaximum(new int[]{25,15}, 3)); //3
 System.out.println(c.getMaximum(new int[]{25,15}, 4)); //3
 System.out.println(c.getMaximum(new int[]{25,15}, 5)); //3
 System.out.println(c.getMaximum(new int[]{10, 10, 10, 10, 10, 50, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10}, 3)); //52
 System.out.println(c.getMaximum(new int[]{10, 10, 10, 10, 10, 50, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10}, 4)); //54
 System.out.println(c.getMaximum(new int[]{10, 10, 10, 10, 10, 50, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10}, 5)); //54
 System.out.println(c.getMaximum(new int[]{10, 10, 10, 10, 10, 50, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10}, 1000)); //54
 System.out.println(c.getMaximum(new int[]{999}, 99)); //99
 System.out.println(c.getMaximum(new int[]{999}, 100)); //99
}

Puzzle 'N' Relax - Intel Algorithm

2011-07-08T16:03:00.000-05:00

Find out the total card flip.

Problem Statement

Kader has a set of 64 cards: for each x between 0 and 63, he has a card that is blank on one side and has 2^x dots on the other side. Kader's cards are placed on a table. At any moment, the cards show some integer between 0 and (2^64)-1, inclusive. To read the number, you just count all the dots you see. Kader is using the cards to count from A to B. That is, he is flipping some of the cards in such a way that the numbers A, A+1, ..., B appear in this order.

Kader is using the shortest possible sequence of flips. Additionally, he always flips the cards one at a time. Sometimes, changing the number from some Z to Z+1 requires Kader to flip more than one card. In that case, he flips the necessary cards ordered by the number of dots they have, starting with the one with the most dots.

For example, if A=6 and B=8, the following will happen:

In the beginning, the card with 4 dots and the card with 2 dots are showing the dots, all other cards are blank side up. This shows the number 6.
He flips the card with 1 dot. Now the number 7 is shown.
He flips the card with 8 dots.
He flips the card with 4 dots.
He flips the card with 2 dots.
He flips the card with 1 dot. Now the number 8 is shown and he is done.
Given are longs A and B. Your method must return the largest number that will be shown at any moment during his counting.

Method: public long largestNumber(long A, long B)

Examples
1)i/p = 6 6 o/p = 3
Steps are
0110 = 6
0110 = 6
----------------
0110 = 6

2)i/p = 6 7 o/p = 7
Steps are
0110 = 6
0111 = 7
----------------
0111 = 7

3)i/p = 6 8 o/p = 15
Steps are
0110 = 6
1000 = 8
----------------
1111 = 15

4)i/p = 1 11 o/p = 15
Steps are
0001 = 1
1011 = 11
----------------
1111 = 15

5)i/p = 35 38 o/p = 39
Steps are
100011 = 35
100110 = 38
----------------
100111 = 39

import java.util.*;
import java.math.BigInteger;

public class BinaryCards {
public long largestNumber(long A, long B) {
if (A == B) return B;
String AN = Long.toBinaryString(A);
String BN = Long.toBinaryString(B);
while (AN.length() != BN.length()) AN = '0' + AN;
String ABN="";
int i=0;
for (; i<AN.length(); ++i) {
if (AN.charAt(i)!=BN.charAt(i)) break;
ABN+=AN.charAt(i);
}

for (; i<AN.length(); ++i)
ABN+="1";
System.out.println(AN + " - " + BN);
return Long.valueOf(String.valueOf(ABN), 2);

}

public static void main(String[] args) {
BinaryCards bc = new BinaryCards();
System.out.println(bc.largestNumber(35,38));
System.out.println(bc.largestNumber(1125899906842630,1125899906842632 ));
//1125899906842639
}
}

Puzzle 'N' Relax - Intel Algorithm

2011-05-21T12:52:00.002-05:00

Find out the missed day of the week.

Problem Statement

This week there will be an important delivery of your entire team. You clearly remember your team manger telling you about it. The only thing you forgot is the day of the week when the delivery will take place.

You asked six of your team members about the delivery. None of them knew the day when it will take place, but each of them remembered one day when it will not take place. The days they remembered were distinct. For a clever coder like you, this was enough to determine the day of the meeting.

You are given a String[] notOnThisDay containing six weekdays when the meeting will not take place. Return the weekday of the meeting.

Method: public String getDay(String[] notOnThisDay)

Examples
1)i/p=>{"Sunday", "Monday", "Tuesday", "Wednesday", "Thursday", "Friday"}, o/p=> "Saturday".

2)i/p=>{"Sunday", "Monday", "Tuesday", "Wednesday", "Friday", "Thursday"}, o/p=> "Saturday".

3)i/p=>{"Sunday", "Monday", "Tuesday", "Thursday", "Friday", "Saturday"}, o/p=> "Wednesday".

4)i/p=>{"Sunday", "Friday", "Tuesday", "Wednesday", "Monday", "Saturday"}, o/p=> "Thursday".

import java.util.Arrays;

public class WhichDay {
 public String getDay(String[] notOnThisDay) {
 String[] theDays = {"Sunday", "Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Saturday"};
 String theday = "";
 for (int i =0;i<theDays.length;i++) {
 for (int j =0;j<notOnThisDay.length;j++) {
 if (theDays[i]==notOnThisDay[j]) {
 j = notOnThisDay.length;
 } else {
 if (j==notOnThisDay.length-1) {
 theday = theDays[i];
 j = theDays.length;
 }
 }
 }
 }
 System.out.println(theday);
 return theday;
 }

 public static void main(String[] args) {
 WhichDay wh= new WhichDay();
 wh.getDay(new String[] {"Sunday", "Monday", "Tuesday", "Wednesday", "Thursday", "Friday"});

 wh.getDay(new String[] {"Sunday", "Monday", "Tuesday", "Wednesday", "Friday", "Thursday"});

 wh.getDay(new String[] {"Sunday", "Monday", "Tuesday", "Thursday", "Friday", "Saturday"});

 wh.getDay(new String[] {"Sunday", "Friday", "Tuesday", "Wednesday", "Monday", "Saturday"});

 wh.getDay(new String[] {"Friday", "Monday", "Thursday", "Tuesday", "Sunday", "Saturday"});

 wh.getDay(new String[] {"Thursday", "Friday", "Sunday", "Wednesday", "Saturday", "Tuesday"});

 wh.getDay(new String[] {"Thursday", "Saturday", "Sunday", "Tuesday", "Friday", "Wednesday"});

 wh.getDay(new String[] {"Friday", "Thursday", "Tuesday", "Sunday", "Wednesday", "Saturday"});

 wh.getDay(new String[] {"Monday", "Friday", "Wednesday", "Saturday", "Sunday", "Thursday"});

 wh.getDay(new String[] {"Sunday", "Tuesday", "Saturday", "Monday", "Wednesday", "Thursday"});

}

}

//Friday , Monday, Saturday, Sunday, Tuesday, Thursday, Wednesday

//Friday , Monday, Sunday, Tuesday, Thursday, Wednesday

Windows Service Using C#

2011-05-16T17:05:00.003-05:00

Create Windows Service Project
Create "File -> New ->Project -> Select Windows Service" template project and name it "QuarantineSer".
Right click "Service1.cs" designer -> select Properties. Then
set "Name" property to "tryDNSQuarantine",
set "AutoLog" property to "True",
set "ServiceName" property to "DNS Quarantine Service".
"Program.cs" class contains the below code

static void Main()
{
ServiceBase[] ServicesToRun;
ServicesToRun = new ServiceBase[] { new tryDNSQuarantine() };

ServiceBase.Run(ServicesToRun);
}

Create the Installer class
Return to tryDNSQuarantine.cs (Service1.cs) designer, right click in the Properties menu to "Add Installer".
Added "ProjectInstaller.cs" class file with 2 Component ServiceProjectInstaller (serviceProjectInstaller1) and ServiceInstaller (serviceInstaller1).
Right click serviceInstaller1 component -> select Properties, then
set "Description" property to "DNS Quarantine Service - Delete File",
set "DisplayName" property to "DNS Quarantine Service",
set "ServiceName" property to "DNS Quarantine Service",
set "StartType" property to "Automatic".
To run all the users in the system and avoid to ask username and password when service start, enter the below in the "ProjectInstaller.Designer.cs" file, like show below

private void InitializeComponent()
{
this.serviceProcessInstaller1 = new System.ServiceProcess.ServiceProcessInstaller();
this.serviceInstaller1 = new System.ServiceProcess.ServiceInstaller();
//
// serviceProcessInstaller1
//
this.serviceProcessInstaller1.Account = System.ServiceProcess.ServiceAccount.LocalSystem;
this.serviceProcessInstaller1.Password = null;
this.serviceProcessInstaller1.Username = null;
//
// serviceInstaller1
//
this.serviceInstaller1.ServiceName = "DNS Quarantine Service";
this.serviceInstaller1.Description = "DNS Quarantine Service - Delete File";
this.serviceInstaller1.DisplayName = "DNS Quarantine Service";
this.serviceInstaller1.StartType = System.ServiceProcess.ServiceStartMode.Automatic;
//
// ProjectInstaller
//
this.Installers.AddRange(new System.Configuration.Install.Installer[]
{
this.serviceProcessInstaller1,
this.serviceInstaller1});

}
Return to trySESQuarantine.cs class file, to add your code (below code to delete the file every one minute).

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Diagnostics;
using System.ServiceProcess;
using System.Text;
using System.Configuration;
using System.Timers;

namespace QuarantineSer
{
public partial class trySESQuarantine : ServiceBase
{
string sFolderPath = ConfigurationSettings.AppSettings.Get("FolderPath");
private static System.Timers.Timer timerEffectiveDate = new System.Timers.Timer();

public trySESQuarantine()
{
InitializeComponent();
}

protected override void OnStart(string[] args)
{
EventLog.WriteEntry("SES Quarantine Service Started");
deleteFile();
Effective_Date_Timer();
}

private void deleteFile()
{
System.IO.DirectoryInfo dirInfo = new System.IO.DirectoryInfo(sFolderPath + "\\antigen\\Quarantine\\");
System.IO.FileInfo[] fileNames = dirInfo.GetFiles("*.*");
foreach (System.IO.FileInfo fi in fileNames)
{
if (fi.Extension != ".ldb" && fi.Extension != ".mdb")
{
fi.Delete();
}
}
}

private void Effective_Date_Timer()
{
try
{
//1 min = 60000
timerEffectiveDate.Elapsed += new ElapsedEventHandler(timerEffective_Date_Elapsed);
timerEffectiveDate.AutoReset = true;
timerEffectiveDate.Interval = 30000;
timerEffectiveDate.Start();
}
catch (System.Exception obEx)
{
throw obEx;
}
}

private void timerEffective_Date_Elapsed(object sender, System.Timers.ElapsedEventArgs e)
{
try
{
deleteFile();
}
catch (System.Exception obEx)
{
//MessageBox.Show(obEx.Message.ToString());
}
}

protected override void OnStop()
{
EventLog.WriteEntry("SES Quarantine Service Stopped");
}
}
}
Right click project properties, choose QuarantineSer.Program for Startup object. Then Ctrl+Shift+B to build the project.
Create the Setup Project
Right click the project solution , select Add -> New Project -> Other Project Types -> Setup and Deployment -> Setup Project.
Right click setup project, Select Add -> Project Output -> select QuarantineSer from Project
Right click setup project, Select View -> Custom Actions -> Right click Custom Actions -> Add Custom Actions -> select Application Folder -> Select Primary output QuarantineSer (Active) -> Press Ok

Finally Ctrl+Shift+B to build the set up project.

Install and Start Service

Run the setup exe, to install Windows Service

Open Services window from Control Panel -> Administrative Tools, Look "DNS Quarantine Service" service and Start it

Competitions - Programming Contest

2011-05-01T12:56:00.000-05:00

Depreciation - Sum-of-the-years'-digits method - PHP Code - Part 4

2011-04-19T14:48:00.001-05:00

Sum-of-the-years'-digits Method

More accelerated write-off than straight line, but less than declining-balance method.
Depreciation = (Cost - Salvage value) X x Fraction
Fraction for the first year = n / (1+2+3+...+ n)
Fraction for the second year = (n-1) / (1+2+3+...+ n)
Fraction for the third year = (n-2) / (1+2+3+...+ n)
...
Fraction for the last year = 1 / (1+2+3+...+ n)

n represents the number of years for total life expectancy.

function Sumoftheyearsdigit($dtotallife, $dofdep, $damount, $dsalvage, $bdisplay=true)
{
global $depTotalValue;
$arrDepreciation = array();
$iCountMonth = 0;
$iTotalMonths = $dtotallife* 12;
$depTotalValue = 0;
$dofYear = 0;
$iRecord = 1;
if ($bdisplay)
echo "<tr ><th>Year</th><th nowrap>Year's Digit</th><th nowrap>No. Of Months</th><th>Depreciation</th><th></th></tr>";
for ($iyear = 1;$iyear<=$dtotallife;$iyear++)
{
$dofdep=explode('/',$dofdep);
$dofYear = $dofdep[2];
$dofMonth = $dofdep[0];
$dofDay = $dofdep[1];

$noofMonthDep = 12 - $dofMonth +1;
$iCountMonth += $noofMonthDep;
$arrDepreciation[$iRecord] = SumoftheyearsdigitPrint($dtotallife, $damount, $dsalvage, $noofMonthDep, $dofYear, $iyear, $iyear, $bdisplay);
$iCountMonth += 12-$noofMonthDep;
if (12-$noofMonthDep>0)
{
$iRecord++;
$arrDepreciation[$iRecord] = SumoftheyearsdigitPrint($dtotallife, $damount, $dsalvage, 12-$noofMonthDep, $dofYear+1, $iyear, $iyear+1, $bdisplay);
}
$dofYearDep = $dofYear + 1;
$dofdep = "$dofMonth/$dofDay/$dofYearDep";
$iRecord++;
}
if ($iTotalMonths!=$iCountMonth)
{
$dofYear+=1;
$noofMonthDep = $iTotalMonths - $iCountMonth;
$arrDepreciation[$iRecord] = SumoftheyearsdigitPrint($dtotallife, $damount, $dsalvage, $noofMonthDep, $dofYear, ($dtotallife+1), $bdisplay);
}
$depTotalValue = sprintf("%.2f",$depTotalValue);
$depTotalValue = number_format($depTotalValue,2);
$iTotalYear = ($dtotallife+1) * ($dtotallife / 2);
if ($bdisplay)
{
echo "<tr bgcolor='gold'><td align='right'>Total</td>
<td align='right'>$iTotalYear</td><td align='right'>$iTotalMonths</td><td nowrap align='right'>$$depTotalValue</td>
<td></td></tr>";
}
//print_r($arrDepreciation);
return $arrDepreciation;
}
function SumoftheyearsdigitPrint($dtotallife, $damount, $dsalvage, $noofMonthDep ,$dofYear, $iyear, $row, $bdisplay=true)
{
global $depTotalValue;
$iYearOfDigit = $dtotallife - $iyear +1;
if ($iYearOfDigit==0) $iYearOfDigit=1;
if ($row % 2 == 1 ) $ctype ="even"; else $ctype ="odd";
$iTotalYear = ($dtotallife+1) * ($dtotallife / 2);
$depValue = ($damount - $dsalvage) * $iYearOfDigit/$iTotalYear * $noofMonthDep/12;
$depTotalValue += $depValue;
$depValue = number_format($depValue,2);
$damount = number_format($damount,2);
$dsalvage = number_format($dsalvage,2);
if ($bdisplay)
{
echo "<tr class='$ctype'><td align='right'>$dofYear</td>
<td align='right'>$iYearOfDigit</td>
<td align='right'>$noofMonthDep</td>
<td align='right'>$$depValue</td><td nowrap width='60%'>
($$damount - $$dsalvage) * $iYearOfDigit/$iTotalYear * $noofMonthDep/12</td></tr>";
}
return array($dofYear,$noofMonthDep,$depValue);
}

Depreciation - 150% Declining Balance Depreciation method - PHP Code - Part 3

2011-04-17T13:23:00.002-05:00

150% Declining Balance Depreciation Method

As know as Double Reducing balance method
Higher depreciation charge in the first year and gradually decreasing charges in subsequent years are called accelerated depreciation methods.
Depreciation = (Cost - Salvage value) X (150% X (1 / Total life expectancy) X (No of months used of year / Total months of year(12)))

function DoubleDecliningBalance($dtotallife, $dofdep, $dsalvage, $dpercentage, $bdisplay=true) {
global $depTotalValue, $ddepexpeaccu, $bstar;
$arrDepreciation = array();
$iCountMonth = 0;
$iTotalMonths = $dtotallife* 12;
$depTotalValue = 0;
$dofYear = 0;
if ($bdisplay) {
echo "<tr ><th>Year</th><th nowrap>Book value at the beginning of year</th>
<th>Depreciation rate</th><th>No. Of Months</th>
<th>Depreciation expense</th>
<th>Accumulated depreciation</th><th>Book value at year-end</th></tr>";
}
for ($iyear = 1;$iyear<=$dtotallife;$iyear++) {
$dofdep=explode('/',$dofdep);
$dofYear = $dofdep[2];
$dofMonth = $dofdep[0];
$dofDay = $dofdep[1];

$noofMonthDep = 12 - $dofMonth +1;
$iCountMonth += $noofMonthDep;
$arrDepreciation[$iyear] = DoubleDecliningBalancePrint($dtotallife, $dsalvage, $noofMonthDep, $dofYear, $iyear, $dpercentage, $bdisplay, $iCountMonth);
$dofYearDep = $dofYear + 1;
$dofdep = "01/01/".$dofYearDep;
}
if ($iTotalMonths!=$iCountMonth) {
$dofYear+=1;
$noofMonthDep = $iTotalMonths - $iCountMonth;
$iCountMonth += $noofMonthDep;
$arrDepreciation[$dtotallife+1] = DoubleDecliningBalancePrint($dtotallife, $dsalvage, $noofMonthDep, $dofYear, ($dtotallife+1), $dpercentage, $bdisplay, $iCountMonth);
}
$depTotalValue = number_format($depTotalValue,2);
if ($bdisplay) {
echo "<tr bgcolor='gold'><td align='right' colspan='3'>Total</td><td align='right'>$iTotalMonths</td><td align='right'></td>
<td align='right'>$$depTotalValue</td><td align='right'></td></tr>";
}
if ($bstar==1 && $bdisplay)
echo "<tr><td colspan='7'>(*) Depreciation stops when accumulated depreciation reaches depreciation base.</d></td></tr>";
return $arrDepreciation;
}

function DoubleDecliningBalancePrint($dtotallife, $dsalvage, $noofMonthDep ,$dofYear, $iyear, $dpercentage, $bdisplay=true, $iCountMonth) {
global $depTotalValue, $ddepexpeaccu, $dbookvaluebegin, $ddepbase, $bstar;

$sstar =" ";
$ddeprate = $dpercentage * 1/$dtotallife * $noofMonthDep/12;
$ddeprate = sprintf("%.2f",$ddeprate);
$ddepexpe = ($dbookvaluebegin*$ddeprate/100);
$ddepexpeaccu += $ddepexpe;
if ($ddepexpeaccu > $ddepbase) {
$ddepexpe = $ddepexpe - ($ddepexpeaccu - $ddepbase);
$ddepexpeaccu = $ddepbase;
}
if ($ddepexpe<=0) $ddepexpe = 0;
if ($ddepexpe<=0 && $bstar ==0) {
$ddepexpe = 0;
$bstar = 1;
$sstar ="(*)";
}
$dbookvalueend = $dbookvaluebegin - $ddepexpe;
if ($iCountMonth == ($dtotallife * 12)) {
if ($dbookvalueend != $dsalvage) {
$ddepexpeaccu += $dbookvalueend - $dsalvage;
$ddeprate = (($ddepexpe + $dbookvalueend - $dsalvage) * 100) / $dbookvaluebegin;
$ddepexpe += $dbookvalueend - $dsalvage;

$dbookvalueend = $dsalvage;
$bstar = 1;
$sstar ="(*)";
}
}
$depTotalValue = $ddepexpeaccu;

if ($iyear % 2 == 1 ) $ctype ="even"; else $ctype ="odd";
$ddepexpeaccu = sprintf("%.2f",$ddepexpeaccu);
$ddepexpeaccu1 = number_format($ddepexpeaccu,2);
$dbookvaluebegin1 = number_format($dbookvaluebegin,2);
$dbookvalueend1 = number_format($dbookvalueend,2);
$ddepexpe1 = number_format($ddepexpe,2);
if ($bdisplay) {
echo "<tr class='$ctype'><td align='right'>$dofYear</td><td align='right'>$$dbookvaluebegin1</td>
<td align='right'>$ddeprate%</td><td align='right'>$noofMonthDep</td><td align='right'>$$ddepexpe1 $sstar</td>
<td align='right'>$$ddepexpeaccu1</td><td align='right'>$$dbookvalueend1</td></tr>";
}
$dbookvaluebegin = $dbookvalueend;
return array($dofYear,$noofMonthDep,$ddepexpe1);
}

Depreciation - Double Declining Balance Depreciation method - PHP Code - Part 2

2011-04-16T13:06:00.002-05:00

Double Declining Balance Depreciation Method

As know as Double Reducing balance method
Higher depreciation charge in the first year and gradually decreasing charges in subsequent years are called accelerated depreciation methods.
Depreciation = (Cost - Salvage value) X (200% X (1 / Total life expectancy) X (No of months used of year / Total months of year(12)))

$ddepexpeaccu = 0;
$bstar = 0;
$dbookvaluebegin = 5000;
$ddepbase = $dbookvaluebegin - $dsalvage; // 4500

DoubleDecliningBalance(7, "6/01/2006", 500, 200, true);

function DoubleDecliningBalance($dtotallife, $dofdep, $dsalvage, $dpercentage, $bdisplay=true) {
global $depTotalValue, $ddepexpeaccu, $bstar;
$arrDepreciation = array();
$iCountMonth = 0;
$iTotalMonths = $dtotallife* 12;
$depTotalValue = 0;
$dofYear = 0;
if ($bdisplay) {
echo "<tr ><th>Year</th><th nowrap>Book value at the beginning of year</th>
<th>Depreciation rate</th><th>No. Of Months</th>
<th>Depreciation expense</th>
<th>Accumulated depreciation</th><th>Book value at year-end</th></tr>";
}
for ($iyear = 1;$iyear<=$dtotallife;$iyear++) {
$dofdep=explode('/',$dofdep);
$dofYear = $dofdep[2];
$dofMonth = $dofdep[0];
$dofDay = $dofdep[1];

$noofMonthDep = 12 - $dofMonth +1;
$iCountMonth += $noofMonthDep;
$arrDepreciation[$iyear] = DoubleDecliningBalancePrint($dtotallife, $dsalvage, $noofMonthDep, $dofYear, $iyear, $dpercentage, $bdisplay);
$dofYearDep = $dofYear + 1;
$dofdep = "01/01/".$dofYearDep;
}
if ($iTotalMonths!=$iCountMonth) {
$dofYear+=1;
$noofMonthDep = $iTotalMonths - $iCountMonth;
$arrDepreciation[$dtotallife+1] = DoubleDecliningBalancePrint($dtotallife, $dsalvage, $noofMonthDep, $dofYear, ($dtotallife+1), $dpercentage, $bdisplay);
}
$depTotalValue = number_format($depTotalValue,2);
if ($bdisplay) {
echo "<tr bgcolor='gold'><td align='right' colspan='3'>Total</td><td align='right'>$iTotalMonths</td><td align='right'></td>
<td align='right'>$$depTotalValue</td><td align='right'></td></tr>";
}
if ($bstar==1 && $bdisplay)
echo "<tr><td colspan='7'>(*) Depreciation stops when accumulated depreciation reaches depreciation base.</d></td></tr>";
return $arrDepreciation;
}

function DoubleDecliningBalancePrint($dtotallife, $dsalvage, $noofMonthDep ,$dofYear, $iyear, $dpercentage, $bdisplay=true) {
global $depTotalValue, $ddepexpeaccu, $dbookvaluebegin, $ddepbase, $bstar;

$sstar =" ";
$ddeprate = $dpercentage * 1/$dtotallife * $noofMonthDep/12;
$ddeprate = sprintf("%.2f",$ddeprate);
$ddepexpe = ($dbookvaluebegin*$ddeprate/100);
$ddepexpeaccu += $ddepexpe;
if ($ddepexpeaccu > $ddepbase) {
$ddepexpe = $ddepexpe - ($ddepexpeaccu - $ddepbase);
$ddepexpeaccu = $ddepbase;
}
if ($ddepexpe<=0) $ddepexpe = 0;
if ($ddepexpe<=0 && $bstar ==0) {
$ddepexpe = 0;
$bstar = 1;
$sstar ="(*)";
}
$dbookvalueend = $dbookvaluebegin - $ddepexpe;
$depTotalValue = $ddepexpeaccu;

if ($iyear % 2 == 1 ) $ctype ="even"; else $ctype ="odd";
$ddepexpeaccu = sprintf("%.2f",$ddepexpeaccu);
$ddepexpeaccu1 = number_format($ddepexpeaccu,2);
$dbookvaluebegin1 = number_format($dbookvaluebegin,2);
$dbookvalueend1 = number_format($dbookvalueend,2);
$ddepexpe1 = number_format($ddepexpe,2);
if ($bdisplay) {
echo "<tr class='$ctype'><td align='right'>$dofYear</td><td align='right'>$$dbookvaluebegin1</td>
<td align='right'>$ddeprate%</td><td align='right'>$noofMonthDep</td><td align='right'>$$ddepexpe1 $sstar</td>
<td align='right'>$$ddepexpeaccu1</td><td align='right'>$$dbookvalueend1</td></tr>";
}
$dbookvaluebegin = $dbookvalueend;
return array($dofYear,$noofMonthDep,$ddepexpe1);
}

Depreciation - Straight line method - PHP Code - Part 1

2011-04-10T12:45:00.003-05:00

Depreciation is a process of allocating the cost of assets over the life of assets.
Cost to be allocated = (product cot - salvage value)/ based on the total life expectancy of product.

Methods

Straight line method
Double Declining Balance Depreciation Method
150% Declining Balance Depreciation Method
Sum-of-the-years'-digits Depreciation Method

Inputs

Name of equipment
Date of purchase
Amount of purchase (Cost) of equipment
Salvage value (Residual value)
Total life expectancy of equipment
Method of depreciation

Problem

On Mar, 02 2006, Daynight purchased an equipment Grasshopper at the cost of $5,000.00, expected to have 7 year useful life. At the end of the 7th year, the salvage value will be $500. Calculate the depreciation expenses for 2006 - 2013 using straight line depreciation method.

Straight line method

Simplest and most often used techique.
Depreciation = (Cost - Salvage value) X (1 / Total life expectancy) X (No of months used of year / Total months of year(12))

function StraightLine($dtotallife, $dofdep, $damount, $dsalvage, $bdisplay=true) {
global $depTotalValue;
$arrDepreciation = array();
$iCountMonth = 0;
$iTotalMonths = $dtotallife* 12;
$depTotalValue = 0;
$dofYear = 0;
if ($bdisplay)
echo "<tr ><th>Year</th><th nowrap>No. Of Months</th><th>Depreciation</th><th></th></tr>";
for ($iyear = 1;$iyear<=$dtotallife;$iyear++) {
$dofdep=explode('/',$dofdep);
$dofYear = $dofdep[2];
$dofMonth = $dofdep[0];
$dofDay = $dofdep[1];

$noofMonthDep = 12 - $dofMonth +1;
$iCountMonth += $noofMonthDep;
$arrDepreciation[$iyear] = StraightLinePrint($dtotallife, $damount, $dsalvage, $noofMonthDep, $dofYear, $iyear, $bdisplay);
$dofYearDep = $dofYear + 1;
$dofdep = "01/01/".$dofYearDep;
}
if ($iTotalMonths!=$iCountMonth) {
$dofYear+=1;
$noofMonthDep = $iTotalMonths - $iCountMonth;
$arrDepreciation[$dtotallife+1] = StraightLinePrint($dtotallife, $damount, $dsalvage, $noofMonthDep, $dofYear, ($dtotallife+1), $bdisplay);
}
$depTotalValue1 = number_format($depTotalValue,2);
if ($bdisplay) {
echo "<tr bgcolor='gold'><td align='right'>Total</td>
<td align='right'>$iTotalMonths</td><td nowrap align='right'>$$depTotalValue1</td>
<td></td></tr>";
}
return $arrDepreciation;
}

function StraightLinePrint($dtotallife, $damount, $dsalvage, $noofMonthDep ,$dofYear, $iyear, $bdisplay=true)
{
global $depTotalValue;
if ($iyear % 2 == 1 ) $ctype ="even"; else $ctype ="odd";
$depValue = ($damount - $dsalvage) * 1/$dtotallife * $noofMonthDep/12;
$depTotalValue += $depValue;
$depValue = number_format($depValue,2);
$dsalvage = number_format($dsalvage,2);
$damount = number_format($damount,2);
if ($bdisplay) {
echo "<tr class='$ctype'><td align='right'>$dofYear</td><td align='right'>$noofMonthDep</td>
<td align='right'>$$depValue</td><td nowrap width='60%'>
($$damount - $$dsalvage) * 1/$dtotallife * $noofMonthDep/12</td></tr>";
}
return array($dofYear,$noofMonthDep,$depValue);
}