No path is too difficult. No destination is too far !
Archive for February, 2010
Thanks Sachin!
Feb 24th
You being the God of Indian Cricket made us proud once again hitting a voluptous 200. Just grant one world cup to us. That’s it.
Dot net openings at Microsoft, Hyderabad.
Feb 24th
Job Description/Responsibilities:
This position is responsible for developing several units of functionality usually making up part of an application. Examples include designing and implementing process workflow, simple schemas, read only access etc. “Simple” is defined as a limited number of requirements, isolated or a limited number of interfaces, low transaction volume, and/or deployment in a single region. The position may include working on multiple development projects simultaneously ensuring that they are being developed in line with all internal standards and best practices. SQL and .Net experience as well as structured software development methodologies is required.
As IT Software Development Engineer, this person will be responsible for:
- Code and test applications in accordance to design specifications and standards.
- Code and test SQL Server database applications that support the requirements defined by users and analysts.
- Design as per architectural directions simple to medium complexity modules/features
- Responsible for developing major subsystems on high risk business systems under deadline pressure
- Responsible for successful completion of development aspects of projects in conformance to project goals and requirements
- Deliver assignments according to a schedule
- Analyze applications and make necessary changes to optimize performance
- Analyze and troubleshoot existing processes and optimize code in order to improve performance whenever possible
- Develop and enforce coding practices designed to promote code reusability; assist in defining and updating the team standards to improve the development process and quality of deliverables
- Participate in design reviews and code reviews
- Assist Test and Production Support teams with installation of the application
- Design and code database applications that perform efficiently, are operationally stable, and meet the business requirements.
- Accurately estimates work/time required to complete tasks within their skill set
- Assist with the creation of project plans.
- Communicates and defends design, requirements, feature set, functionality and limitations of subsystem to team members and development lead.
- Fosters proactive and cooperative relationships within the project team
- Participates in project team activities and contributes to documentation requirements consistent with methodology.
- When necessary, participates in the creation of new guidelines and procedures.
- Act in lead role (if required), and oversees the design and development for smaller, lower risk business systems
- Exercises independent judgment in selecting methods and techniques for obtaining solutions.
- Ensures that team’s code meets specifications and is easily maintainable.
- Participates in project team activities and contributes to documentation requirements consistent with methodology
- Prepares presentations and status reports.
- Fosters proactive and cooperative relationships exist within the project team
- Proficient with and guides others in using development tools.
- May make recommendations on staffing and hiring decisions.
Requirements/Qualifications and Previous Work and Related Experience (including educational requirements):
- Excellent English communications skills, both written and oral. Must be able to effectively communicate technical and business problems in a non technical manner to multiple groups (customer groups, project team, IT support groups)
- Understands networking
- Strong understanding of how to design applications for optimal network performance
- Proficiency in multiple program languages, especially c# and vb.net, ASP/ASP.Net, n-tier development environment and HTML scripting languages (Javascript.Jscript,VbScript) or similar application structures
- A solid working knowledge of SQL Server, Windows NT, and development practices for working with a team of developers.
- Experience working with relational database management systems and client-server technologies
- Strong leadership skills
- Sound problem resolution, judgment, negotiating and decision making skills required.
- Strong analytical and organizational skills.
- Able to participate in a team environment, communicate effectively and promote cooperative relationships.
- Ability to work under pressure and be able to work to tight deadlines.
- Must have a strong understanding of software architectures and MS products.
- Demonstrated experience with a Software Development Life Cycle Methodology and information systems development. Experience with agile development methodologies and PSP/TSP would be an advantage.
- Strong knowledge and ability to apply latest technology, standards, capabilities and limitations of technology.
- Demonstrated knowledge of relational database and client-server technologies.
- Promotes cooperative relationships
- Ability to work with multiple people, resources and partners, remotely if necessary
- BS/BA in computer science or related field
- Minimum of five to eight years of related developer experience – or – An equivalent combination of training and related work experience
Please send your updated resume in word format and give below details
Current CTC:
Expected CTC:
Notice period:
Send these details to balraj@techpointsolutions.com
Java professional required in chennai
Feb 24th
Urgent opening with one of esteemed CMMI level Client for the position of SSE/ Lead
Position: SSE/Lead with 5 to 7 Years of Exp
Work Location: Chennai (India)
Required Skills:
· Relevant 3.5 Yrs hands on experience in Java and j2ee.
· Must have Hands on experience in web services.
· Need Candidates who can join with in 10 Days is preferable but not mandatory.
If Ur profile matches the above requirement plz send Ur CV to j.priya@aequor.com with the details of
Tot Exp:
Rev Experience in web services:
Current CTC:
Expected CTC:
Notice Period:
Current Location:
Willing to relocate to Chennai (Yes/No):
Current Employment (Contract/Permanent):
Can u able to take up F2F interview on 27th Feb Saturday (Yes/No):
Can u join in 10 Days (Yes/No):
Bind with Enum in Silverlight
Feb 23rd
Silverlight doesn’t have any kind of ObjEctDataProvider with it. So the famous example of binding the controls with an ObjectDataProvider doesn’t work with silverlight as it works with WPF 
<UserControl.Resources>
<ObjectDataProvider MethodName=“GetValues” ObjectType=”{x:Type sys:Enum}“ x:Key=“AlignmentValues”> <ObjectDataProvider.MethodParameters>
<x:Type TypeName=“HorizontalAlignment” />
</ObjectDataProvider.MethodParameters>
</ObjectDataProvider>
This can be done via code behind in the Silverlight. Just add a reference to the Reflection assembly.
using System.Reflection;
Use this simple function to get IEnumerable collection out of Enum type.
public IEnumerable<Enum> GetEnumValues(Enum enumeration)
{
return from gField in enumeration.GetType().GetFields(BindingFlags.Static | BindingFlags.Public)
select (Enum)gField.GetValue(enumeration);
}
Just bind the results of this function with your control and its done !
ComboFrom.ItemsSource = GetEnumValues(new SehajService.Currency());
Currency amount in words in indian format using T-SQL Stored Procedure
Feb 18th
I know it is not that much crucial but neither easy to get rid of financial application’s requirements as clients demand more and more facilities even they are small in size.
Here is one that kinda SQL Script that every finance domain expert looks for. That is the currency writer in WORDS instead of digits.
CREATE FUNCTION dbo.AMOUNT_IN_WORDS
(
@Amount INT,
@PAISE INT
)
RETURNS int
BEGIN
DECLARE
–Step 1:
–Here we define the temporary tables to hold the WORDs representation of possible digits/amounts
DECLARE @INNTBL_01 TABLE (RECNO INT IDENTITY(1, 1), MTEXT NVARCHAR(50))
DECLARE @INNTBL_02 TABLE (RECNO INT IDENTITY(1, 1), MTEXT NVARCHAR(50))
–Step 2:
–Now add up the salt and pepper onto table i.e. insert the WORDs into it
INSERT INTO @INNTBL_01 SELECT ‘ONE’
INSERT INTO @INNTBL_01 SELECT ‘TWO’
INSERT INTO @INNTBL_01 SELECT ‘THREE’
INSERT INTO @INNTBL_01 SELECT ‘FOUR’
INSERT INTO @INNTBL_01 SELECT ‘FIVE’
INSERT INTO @INNTBL_01 SELECT ‘SIX’
INSERT INTO @INNTBL_01 SELECT ‘SEVEN’
INSERT INTO @INNTBL_01 SELECT ‘EIGHT’
INSERT INTO @INNTBL_01 SELECT ‘NINE’
INSERT INTO @INNTBL_01 SELECT ‘TEN’
INSERT INTO @INNTBL_01 SELECT ‘ELEVEN’
INSERT INTO @INNTBL_01 SELECT ‘TWELVE’
INSERT INTO @INNTBL_01 SELECT ‘THIRTEEN’
INSERT INTO @INNTBL_01 SELECT ‘FOURTEEN’
INSERT INTO @INNTBL_01 SELECT ‘FIFTEEN’
INSERT INTO @INNTBL_01 SELECT ‘SIXTEEN’
INSERT INTO @INNTBL_01 SELECT ‘SEVENTEEN’
INSERT INTO @INNTBL_01 SELECT ‘EIGHTEEN’
INSERT INTO @INNTBL_01 SELECT ‘NINETEEN’
INSERT INTO @INNTBL_01 SELECT ‘TWENTY’–Similary, insert the multiples
INSERT INTO @INNTBL_02 SELECT ‘TEN’
INSERT INTO @INNTBL_02 SELECT ‘TWENTY’
INSERT INTO @INNTBL_02 SELECT ‘THIRTY’
INSERT INTO @INNTBL_02 SELECT ‘FORTY’
INSERT INTO @INNTBL_02 SELECT ‘FIFTY’
INSERT INTO @INNTBL_02 SELECT ‘SIXTY’
INSERT INTO @INNTBL_02 SELECT ‘SEVENTY’
INSERT INTO @INNTBL_02 SELECT ‘EIGHTY’
INSERT INTO @INNTBL_02 SELECT ‘NINETY’
–Step 3:
–Check for the limit of the amount i.e. what is the place value of digits – LACs, Thousands or Hundreds
DECLARE @WORD VARCHAR(300)
SELECT @WORD = ”
DECLARE @M_AMT01 INT, @M_AMT02 INT
IF @AMOUNT < 10000000 AND @AMOUNT >= 100000 BEGIN
SET @M_AMT01 = @AMOUNT
SELECT @AMOUNT = ( @AMOUNT % 100000 )
SET @M_AMT01 = ( @M_AMT01 – @AMOUNT ) / 100000
DECLARE @WORD1 VARCHAR(300)
SET @WORD1 = ”
IF @M_AMT01 < 100 AND @M_AMT01 > 20 BEGIN
SET @M_AMT02 = @M_AMT01
SET @M_AMT01 = ( @M_AMT01 % 10)
SET @M_AMT02 = ( @M_AMT02 – @M_AMT01 ) / 10
SET @WORD1 = ( SELECT @WORD1 + MTEXT FROM @INNTBL_02 WHERE RECNO = @M_AMT02 )
END
IF @M_AMT01 <= 20 AND @M_AMT01 <> 0 BEGIN
SET @WORD1 = ( SELECT @WORD1 + MTEXT FROM @INNTBL_01 WHERE RECNO = @M_AMT01 )
END
SET @WORD = @WORD + @WORD1 + ‘ LAC ‘
END
IF @AMOUNT < 100000 AND @AMOUNT >= 1000 BEGIN
SET @M_AMT01 = @AMOUNT
SET @AMOUNT = ( @AMOUNT % 1000 )
SET @M_AMT01 = ( @M_AMT01 – @AMOUNT ) / 1000
SET @WORD1 = ”
IF @M_AMT01 < 100 AND @M_AMT01 > 20 BEGIN
SET @M_AMT02 = @M_AMT01
SET @M_AMT01 = ( @M_AMT01 % 10 )
SET @M_AMT02 = ( @M_AMT02 – @M_AMT01 ) / 10
SET @WORD1 = ( SELECT @WORD1 + MTEXT + ‘ ‘ FROM @INNTBL_02 WHERE RECNO = @M_AMT02 )
END
IF @M_AMT01 <= 20 AND @M_AMT01 <> 0 BEGIN
SET @WORD1 = ( SELECT @WORD1 + MTEXT +’ ‘ FROM @INNTBL_01 WHERE RECNO = @M_AMT01 )
END
SET @WORD = @WORD + @WORD1 + ‘ THOUSAND ‘
END
IF @AMOUNT < 1000 AND @AMOUNT > = 100 BEGIN
SET @M_AMT01 = @AMOUNT
SET @AMOUNT = ( @AMOUNT % 100 )
SET @M_AMT01 = ( @M_AMT01 – @AMOUNT ) / 100
SET @WORD = ( SELECT @WORD + ‘ ‘ +MTEXT + ‘ HUNDRED ‘ FROM @INNTBL_01 WHERE RECNO = @M_AMT01
)
END
IF @AMOUNT < 100 AND @AMOUNT > 20 BEGIN
SET @M_AMT01 = @AMOUNT
SET @AMOUNT = ( @AMOUNT % 10 )
SET @M_AMT01 = ( @M_AMT01 – @AMOUNT ) / 10
SET @WORD = ( SELECT @WORD + MTEXT + ‘ ‘ FROM @INNTBL_02 WHERE RECNO = @M_AMT01 )
END
IF @AMOUNT <= 20 AND @AMOUNT >= 1 BEGIN
SET @WORD = ( SELECT @WORD + MTEXT +’ ‘ FROM @INNTBL_01 WHERE RECNO = @AMOUNT )
END
–STEP 4:
–Calculate the paise also.
DECLARE @WORDP VARCHAR(300)
SET @WORDP = ”
IF @PAISE <> 0 BEGIN
IF @PAISE < 100 AND @PAISE > 20 BEGIN
DECLARE @PAISE_01 VARCHAR(300)
SET @PAISE_01 = @PAISE
SET @PAISE = ( @PAISE % 10 )
SET @PAISE_01 = ( @PAISE_01 – @PAISE ) / 10
SET @WORDP = ( SELECT @WORDP + MTEXT FROM @INNTBL_02 WHERE RECNO = @PAISE_01 )
END
IF @PAISE <= 20 AND @PAISE >= 1 BEGIN
SET @WORDP = ( SELECT @WORDP + MTEXT FROM @INNTBL_01 WHERE RECNO = @PAISE )
END
SET @WORD = @WORD + ‘AND ‘ + @WORDP + ‘ PAISE’
END
–STEP 5:
–Time to return answer from the function.
RETURN (REPLACE(@WORD, ‘ ‘, ‘ ‘))
–Its done dude. Try by yourself.
END
Now when you need to use this function, simply call it inline to any select statement.
CALLING THE FUNCTION
Select dbo.AMOUNT_IN_WORDS(IM.GRAND_TOTAL, 0) AS words from TBL_INVOICE_MAIN IM
Here, it will convert GRAND_TOTAL field from the table TBL_INVOICE_MAIN.
or more simply,
Select dbo.AMOUNT_IN_WORDS(654321, 0)
Isn’t it simple enough !
Create Word Document with Hyperlinks in it with C# code
Feb 18th
First of all you need to add reference to COM library in project.
Add reference to Microsoft word 11.0 word library under COM reference tab Add this in the code behind “using” section
using Microsoft.Office.Interop.Word;
private void CreateWordDocument()
{
// create annonymous object to be referenced throughout
object oMissingReference = System.Reflection.Missing.Value;
object Visible=true;
// define arbitrary starting point for defining range object.
object oStartRange = 0;
object oEndRange = 0;
// create instance of application class
ApplicationClass WordApp = new ApplicationClass();
// create document instance
Document docObject = WordApp.Documents.Add(ref oMissingReference , ref oMissingReference , ref oMissingReference , ref oMissingReference );
// select a range to add some text/image there
Range rng=docObject.Range(ref oStartRange,ref oMissingReference );
rng.Font.Name=”Arial”;
rng.InsertAfter(”Ashish Sehajpal”);
// create Hyperlink object and assign address, screen tip to it
Object address = @”http://www.sehajpal.com”;
Object screenTip = “Welcome to sehajpal.com”;
// adding Hyperlink to the text “Ashish Sehajpal“
rng.Hyperlinks.Add(rng, ref address, ref oMissingReference , ref screenTip, ref oMissingReference , ref oMissingReference );
// give file name to it so as to save the document
object filename = @”C:\createdbycsharp.doc”;
docObject.SaveAs(ref filename, ref oMissingReference , ref oMissingReference , ref oMissingReference , ref oMissingReference , ref oMissingReference ,ref oMissingReference , ref oMissingReference , ref oMissingReference , ref oMissingReference , ref oMissingReference , ref oMissingReference , ref oMissingReference , ref oMissingReference , ref oMissingReference , ref oMissingReference );
WordApp.Visible=true;
}
Unable to debug the silverlight project
Feb 18th
I have some strange thing happening in my application. I was able to debug anything but silverlight code !!
I did so much of RnD on net and tried various tricks, but only this thing worked : -
When you add a Silverlight project to a asp.net solution, you create 2 projects…
A. the startup project (interface starter)
B. the interface itself
1. right click on the startup project (SilverlightWeb — the one with default.aspx in it )…
2. click on ‘Property Pages’
3. open ‘Start Options’ Tab
4. enable Silverlight Debugger
5. OK
This was the solution for me
Versioning problem in reference.cs in WCF service consumption in Silverlight 2
Feb 18th
A starnge problem occured when I was trying to add reference to one of my WCF service in my silverlight project. When deeply researched I found that some of the data contracts have been references twice in the reference.cs i.e. some classes with version 3.0.0.0 and some with 2.0.0.0 version. Strange!!
A quick work around was to generate the reference via svcutil.exe and it worked well in case where the project was justa relay service and not the silverlight application. In silverlght app, it throws the error for async and completed methods. Then I used SLSvcutil.exe i.e. svcutil for silverlight which is bundled with silverlight 3 only. I used this and generated the refences.cs for me. One problem left is FAULTCONTRACTS in the code. That i removed manually and it is working now.
How to detect resolution of client in WPF?
Feb 18th
I was wondering about how to detect scrren resolution for client’s machine in wpf. I searched internet, tried googling but in vein.
Here is the snippet that can help the folks looking for similar solution.
// Detect screen height available. Remember it is the inner area of screen.
SystemParameters.FullPrimaryScreenWidth
// Detect screen width available. Remember it is the inner area of screen.
SystemParameters.FullPrimaryScreenHeight;