jQuery, ASP.NET, C#, MVC, Ajax, Web Tutorials

Audit Trail Generator for Microsoft SQL

2012-02-26T07:14:00.001-08:00

Audit Trail With Shadow Table and Triggers
Ref: http://www.codeproject.com/Articles/21068/Audit-Trail-Generator-for-Microsoft-SQL

http://www.blogger.com/img/blank.gif
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[GenerateAudittrail]
 @TableName varchar(128),
 @Owner varchar(128) = 'dbo',
 @AuditNameExtention varchar(128) = '_shadow',
 @DropAuditTable bit = 0
AS
BEGIN

 -- Check if table exists
 IF not exists (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'[' + @Owner + '].[' + @TableName + ']') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
 BEGIN
  PRINT 'ERROR: Table does not exist'
  RETURN
 END

 -- Check @AuditNameExtention
 IF @AuditNameExtention is null
 BEGIN
  PRINT 'ERROR: @AuditNameExtention cannot be null'
  RETURN
 END

 -- Drop audit table if it exists and drop should be forced
 IF (exists (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'[' + @Owner + '].[' + @TableName + @AuditNameExtention + ']') and OBJECTPROPERTY(id, N'IsUserTable') = 1) and @DropAuditTable = 1)
 BEGIN
  PRINT 'Dropping audit table [' + @Owner + '].[' + @TableName + @AuditNameExtention + ']'
  EXEC ('drop table ' + @TableName + @AuditNameExtention)
 END

 -- Declare cursor to loop over columns
 DECLARE TableColumns CURSOR Read_Only
 FOR SELECT b.name, c.name as TypeName, b.length, b.isnullable, b.collation, b.xprec, b.xscale
  FROM sysobjects a 
  inner join syscolumns b on a.id = b.id 
  inner join systypes c on b.xtype = c.xtype and c.name <> 'sysname' 
  WHERE a.id = object_id(N'[' + @Owner + '].[' + @TableName + ']') 
  and OBJECTPROPERTY(a.id, N'IsUserTable') = 1 
  ORDER BY b.colId

 OPEN TableColumns

 -- Declare temp variable to fetch records into
 DECLARE @ColumnName varchar(128)
 DECLARE @ColumnType varchar(128)
 DECLARE @ColumnLength smallint
 DECLARE @ColumnNullable int
 DECLARE @ColumnCollation sysname
 DECLARE @ColumnPrecision tinyint
 DECLARE @ColumnScale tinyint

 -- Declare variable to build statements
 DECLARE @CreateStatement varchar(8000)
 DECLARE @ListOfFields varchar(2000)
 SET @ListOfFields = ''


 -- Check if audit table exists
 IF exists (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'[' + @Owner + '].[' + @TableName + @AuditNameExtention + ']') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
 BEGIN
  -- AuditTable exists, update needed
  PRINT 'Table already exists. Only triggers will be updated.'

  FETCH Next FROM TableColumns
  INTO @ColumnName, @ColumnType, @ColumnLength, @ColumnNullable, @ColumnCollation, @ColumnPrecision, @ColumnScale
  
  WHILE @@FETCH_STATUS = 0
  BEGIN
   IF (@ColumnType <> 'text' and @ColumnType <> 'ntext' and @ColumnType <> 'image' and @ColumnType <> 'timestamp')
   BEGIN
    SET @ListOfFields = @ListOfFields + @ColumnName + ','
   END

   FETCH Next FROM TableColumns
   INTO @ColumnName, @ColumnType, @ColumnLength, @ColumnNullable, @ColumnCollation, @ColumnPrecision, @ColumnScale

  END
 END
 ELSE
 BEGIN
  -- AuditTable does not exist, create new

  -- Start of create table
  SET @CreateStatement = 'CREATE TABLE [' + @Owner + '].[' + @TableName + @AuditNameExtention + '] ('
  SET @CreateStatement = @CreateStatement + '[AuditId] [bigint] IDENTITY (1, 1) NOT NULL,'

  FETCH Next FROM TableColumns
  INTO @ColumnName, @ColumnType, @ColumnLength, @ColumnNullable, @ColumnCollation, @ColumnPrecision, @ColumnScale
  
  WHILE @@FETCH_STATUS = 0
  BEGIN
   IF (@ColumnType <> 'text' and @ColumnType <> 'ntext' and @ColumnType <> 'image' and @ColumnType <> 'timestamp')
   BEGIN
    SET @ListOfFields = @ListOfFields + @ColumnName + ','
  
    SET @CreateStatement = @CreateStatement + '[' + @ColumnName + '] [' + @ColumnType + '] '
    
    IF @ColumnType in ('binary', 'char', 'nchar', 'nvarchar', 'varbinary', 'varchar')
    BEGIN
     IF (@ColumnLength = -1)
      Set @CreateStatement = @CreateStatement + '(max) '   
     ELSE
      SET @CreateStatement = @CreateStatement + '(' + cast(@ColumnLength as varchar(10)) + ') '   
    END
  
    IF @ColumnType in ('decimal', 'numeric')
     SET @CreateStatement = @CreateStatement + '(' + cast(@ColumnPrecision as varchar(10)) + ',' + cast(@ColumnScale as varchar(10)) + ') '   
  
    IF @ColumnType in ('char', 'nchar', 'nvarchar', 'varchar', 'text', 'ntext')
     SET @CreateStatement = @CreateStatement + 'COLLATE ' + @ColumnCollation + ' '
  
    IF @ColumnNullable = 0
     SET @CreateStatement = @CreateStatement + 'NOT '   
  
    SET @CreateStatement = @CreateStatement + 'NULL, '   
   END

   FETCH Next FROM TableColumns
   INTO @ColumnName, @ColumnType, @ColumnLength, @ColumnNullable, @ColumnCollation, @ColumnPrecision, @ColumnScale
  END
  
  -- Add audit trail columns
  SET @CreateStatement = @CreateStatement + '[AuditAction] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,'
  SET @CreateStatement = @CreateStatement + '[AuditDate] [datetime] NOT NULL ,'
  SET @CreateStatement = @CreateStatement + '[AuditUser] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,'
  SET @CreateStatement = @CreateStatement + '[AuditApp] [varchar](128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL)' 

  -- Create audit table
  PRINT 'Creating audit table [' + @Owner + '].[' + @TableName + @AuditNameExtention + ']'
  EXEC (@CreateStatement)

  -- Set primary key and default values
  SET @CreateStatement = 'ALTER TABLE [' + @Owner + '].[' + @TableName + @AuditNameExtention + '] ADD '
  SET @CreateStatement = @CreateStatement + 'CONSTRAINT [DF_' + @TableName + @AuditNameExtention + '_AuditDate] DEFAULT (getdate()) FOR [AuditDate],'
  SET @CreateStatement = @CreateStatement + 'CONSTRAINT [DF_' + @TableName + @AuditNameExtention + '_AuditUser] DEFAULT (suser_sname()) FOR [AuditUser],CONSTRAINT [PK_' + @TableName + @AuditNameExtention + '] PRIMARY KEY  CLUSTERED '
  SET @CreateStatement = @CreateStatement + '([AuditId])  ON [PRIMARY], '
  SET @CreateStatement = @CreateStatement + 'CONSTRAINT [DF_' + @TableName + @AuditNameExtention + '_AuditApp]  DEFAULT (''App=('' + rtrim(isnull(app_name(),'''')) + '') '') for [AuditApp]'

  EXEC (@CreateStatement)

 END

 CLOSE TableColumns
 DEALLOCATE TableColumns

 /* Drop Triggers, if they exist */
 PRINT 'Dropping triggers'
 IF exists (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'[' + @Owner + '].[tr_' + @TableName + '_Insert]') and OBJECTPROPERTY(id, N'IsTrigger') = 1) 
  EXEC ('drop trigger [' + @Owner + '].[tr_' + @TableName + '_Insert]')

 IF exists (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'[' + @Owner + '].[tr_' + @TableName + '_Update]') and OBJECTPROPERTY(id, N'IsTrigger') = 1) 
  EXEC ('drop trigger [' + @Owner + '].[tr_' + @TableName + '_Update]')

 IF exists (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'[' + @Owner + '].[tr_' + @TableName + '_Delete]') and OBJECTPROPERTY(id, N'IsTrigger') = 1) 
  EXEC ('drop trigger [' + @Owner + '].[tr_' + @TableName + '_Delete]')

 /* Create triggers */
 PRINT 'Creating triggers' 
 EXEC ('CREATE TRIGGER tr_' + @TableName + '_Insert ON ' + @Owner + '.' + @TableName + ' FOR INSERT AS INSERT INTO ' + @TableName + @AuditNameExtention + '(' +  @ListOfFields + 'AuditAction) SELECT ' + @ListOfFields + '''I'' FROM Inserted')

 EXEC ('CREATE TRIGGER tr_' + @TableName + '_Update ON ' + @Owner + '.' + @TableName + ' FOR UPDATE AS INSERT INTO ' + @TableName + @AuditNameExtention + '(' +  @ListOfFields + 'AuditAction) SELECT ' + @ListOfFields + '''U'' FROM Inserted')

 EXEC ('CREATE TRIGGER tr_' + @TableName + '_Delete ON ' + @Owner + '.' + @TableName + ' FOR DELETE AS INSERT INTO ' + @TableName + @AuditNameExtention + '(' +  @ListOfFields + 'AuditAction) SELECT ' + @ListOfFields + '''D'' FROM Deleted')

END

2 Quotes From Swami Ramsukhdasji

2011-11-19T05:09:00.000-08:00

1. This "Jeev" even if it receives the highest post or things in this world, then too its hunger will not be satiated till it does not attain the Eternal, its very own Lord, because only God is such, through whom all fulfillment is possible. Besides God, everyone else is incomplete and imperfect.
इस जीव को संसार के किसी भी उच्चे-से- उच्चे पद या पदार्थ की प्राप्ति क्यों न हो जाए, इसकी भूक तब तक नहीं मिटती, जब तक यह अपने परम आत्मीय भगवान् को प्राप्त नहीं कर लेता, क्योंकि भगवान् ही ऐसे हैं जिनसे सब तरह की पूर्ती हो सकती है | उनके सिवा सभी अपूर्ण है | (Jeevan ka Kartavya)

2. जिन मन, बुद्धि, इन्द्रियोंको आप वश में नहीं कर सकते हो, अपनेमें एक कमजोरी का अनुभव होता है, वह कमजोरी नहीं रहेगी। आपको आश्चर्य आये, ऐसा बल आ जयगा। काम को जीतने की, लोभ को जीतने की, मोह को जीतने की, मात्सर्य-दोष दूर करनेकी ताकत स्वत: आ जायगी। परन्तु ताकत लेने के लिये स्थित नहीं होना है। इसका विचार ही नहीं करना है कि हमें ताकल लेनी है। केवल चितशक्तिमें, अपने स्वरुपमें स्थित होना है कि मेरे में कोई विकार नहीं है। दिन में दस बार, पन्द्रह बार, बीस बार, पचास बार, सौ बार, दो-दो, तीन-तीन सेकेण्डके लिये भी इसमें स्थित हो जाओ कि हमारे में दोष नहीं है। अपने स्वरुपको सँभाल लो। यह तत्काल सिद्धि देनेवाला योग है। (‘भगवत्प्राप्ति की सुगमता’ पृष्ठ-७ पुस्तक से)

Meditation Techniques from beginning to end in Hindi

2011-11-19T05:02:00.000-08:00

This video tell about deep meditation. A journey from beginning to end. It tell using 3D models that how easy and simple to meditate.Meditation techniques are easy. For full knowledge of kundalini jagran. Awaken 6th sense. Watch this video. It will tell in scientific way how we are part of universe

Really this is great video!!!

Song: Shambho Shankar Namah Shivaya

2011-05-29T07:28:00.000-07:00

- Avdhoot Baba Shivanand Ji Song

When you are in great tension or too much tired, Listen this song carefully and look at the pictures and feel weight less.

Har Har Mahadev!!!

jQuery Popup on button click instead of link navigation

2010-05-31T19:22:00.000-07:00

See Here

OOPS Concept in Javascript

2010-05-31T19:19:00.001-07:00

Here is the sample code to show oops concept in javascript.


<script type="text/javascript" >
  //Declare Class
    function myClass() {
        //Member Variable
        this.memberVariable = '';
        //Method
        this.methodTest = function(obj) {
            alert(this.memberVariable + ' ' + obj);
        }
    }
    //Extend Class
    myClass.prototype.newMethodTest = function(obj) {
    
        alert(this.memberVariable + ' ' + obj);
    }
    //Static Method
    myClass.myStaticMethod = function(obj) {
        alert('This is static method with arg '+ obj);
    }

    //derived Class
    derivedClass.prototype = new myClass(); 
    function derivedClass() {
        //New member variable
        this.newMemberVariable = '';
        //Override New method
        this.newMethodTest = function() {
            alert('old value' + this.memberVariable + 'new value' + this.newMemberVariable);
        }
     }
    
     

 
    var obj = new derivedClass();
    obj.newMemberVariable = 'New Test';
    obj.memberVariable = 'Old Test';
    obj.newMethodTest();
    obj.methodTest('arg'); 
  

   

</script>

Get-Set Radio Button –Checkbox value using jQuery

2010-05-31T19:11:00.000-07:00

See Here.

Custom role provider based sitemap navigation in asp.net

2010-03-12T07:00:00.000-08:00

See Here.

Add KickIt Badge for DotNetKicks.com in blogger

2009-12-28T09:26:00.000-08:00

We can add KickIt Badge for DotNetKicks in blogger using the javascript. But, It is loaded after loading all elements even it is in middle of page. Suppose, your page has a lot of ads and links and you have added DotNetKicks javascript below the post then It appears after loading all links/ads/content. Here are the steps to fix this problem without using javascript.

1. Login to blogger and go to Layout >> Edit HTML
2. Check "Expand Widget Templates"
3. Search
4. Paste following code after this where you want to place.

<!-- DotNetKicks -->
<a expr:href='&quot;http://www.dotnetkicks.com/kick/?url=&quot; + data:post.url'>
<img border='0' expr:src='&quot;http://www.dotnetkicks.com/Services/Images/KickItImageGenerator.ashx?url=&quot; + data:post.url'/>
</a>

It will load DotNetKicks badge immediately.

Enjoy this.

Active Directory group in sharepoint

2009-12-12T07:53:00.000-08:00

what is the best approach for assigning permission levels in SharePoint?
One recommendation is to use AD groups or SharePoint groups that contain AD groups rather than individuals to control access. It's much easier to clean up AD group membership when an individual leaves than to track down all the places where you've given them individual access (including membership in SharePoint groups).

Most Intranet based organizations use Active Directory to manage user profiles and authentication process in the network. In SharePoint, Active Directory has been used to authenticate users and build user profiles using basic personalization features. This means that if the organization uses Active Directory, SharePoint becomes a great browser-based tool in which to work because a user who logs in to the domain does not typically need to enter credentials again to access a SharePoint site. This is because when the system administrator configured the SharePoint server, it was added as a member of your Active Directory domain. Therefore, when you enter your username and password to connect to the network, the SharePoint environment recognizes you as a member and therefore does not require you to specify your username and password again. In addition, SharePoint allows you to connect to sites based on your site group membership and retains your permissions as you access various other Windows-based systems such as file shares or printers. Most users prefer this type of experience because it can be tedious and confusing to manage both multiple usernames and passwords.
See here how to Add Active Directory Group to sharepoint.

Advantages of Active directory group over sharepoint group:
> Members of this group can be managed within Active Directory. Only Active Directory administrators have the permission to modify group memberships. Normally created and maintained by the IT department.
> AD Groups can be nested - e.g. you can add another AD Group as a member to an existing AD group
> It can be used across different SharePoint sites and site collections.
> There is no need of depth knowledge of sharepoint, A network guy can implement this.
If AD groups are used in sharepoint group then generally it is required to get the sharepoint group for AD User. You can get all AD groups from a user using following:
http://urenjoy.blogspot.com/2009/04/getting-active-directory-groups-from.html and use the AD Groups as a sharepoint user to get the sharepoint groups for checking role/permissions.

Conclusion:
However, in organizations with thousands of users, it’s more realistic to add Active Directory security groups to a SharePoint site group. This not only reduces administrative overhead when you first set up a site, but also means the site’s membership stays up-to-date as new users join or leave the organization. As you add users to the Active Directory security group, they are automatically assigned to the SharePoint site group that has been associated with the security group.

How to deploy Office Shared Add-in

2009-12-04T08:18:00.000-08:00

Suppose you have implemented shared add-in using VS 2008 for Office 2007 and now you have to create installation package.

1. Download and install COMShimWizardSetup.exe and follow
http://msdn.microsoft.com/en-us/library/bb508939.aspx
2. Now Build your setup project and install on another machine. If you face any problem See following:
http://blogs.msdn.com/vsod/archive/2008/04/22/Troubleshooting-com-add-in-load-failures.aspx

Hope, It helps.

unable to create specified activex control Office add-in error

2009-12-04T08:00:00.000-08:00

Add-ins that directly implement ICustomTaskPaneConsumer expose one or more ActiveX controls that you must register. To use the test add-in for ICustomTaskPaneConsumer, you can either rebuild the add-in, which registers it, or simply register the add-in assembly that contains the managed ActiveX control. You must also be sure to rebuild or re-register the shim, so that the shim registration overrides the add-in registration.

public class TaskPaneX : Office.ICustomTaskPaneConsumer
{
    private Office.ICTPFactory _taskPaneFactory;
    internal Office.CustomTaskPane _taskPane;
 
    public void CTPFactoryAvailable(Office.ICTPFactory CTPFactoryInst)
    {
        try
        {
            _taskPaneFactory = CTPFactoryInst;
            _taskPane = _taskPaneFactory.CreateCTP(
"ContosoAddin.SimpleControl", "SimpleControl", Type.Missing);
        }
        catch (Exception ex)
        {
            MessageBox.Show(ex.ToString());
        }
    }
}

1. Make sure user control class has Comvisible and ProgID defined. See for above code:

[ComVisible(true)]
[ProgId("ContosoAddin.SimpleControl")]
[Guid("918E7B30-E23A-4226-85A2-181ABB514C66")]
public partial class SimpleControl : UserControl
{
    public SimpleControl()
    {
        InitializeComponent();
    }
}

2. Make sure the managed assembly must be strong name assembly and would be better if shim assembly has same GUID /ProgID.
3. First register the original shared add-in assembly:

cd C:\Windows\Microsoft.NET\Framework\v2.0.50727
regasm /codebase "<install_locationC:\Data\COMShims\2.3\Sample Managed Assemblies\TestExcel2007Addin\TestExcel2007Addin\bin\Debug\TestExcel2007Addin.dll"

4. Register shim assembly:

Regsvr32 “<shim assembly path>”

5. Test the add-in.

Hope, It helps.

_spbodyonloadfunctionnames is undefined Javascript Error in sharepoint

2009-11-21T22:09:00.000-08:00

_spBodyOnLoadFunctionNames: Generally, ASP.NET 2.0 Master page concept is used for sharepoint pages and the “body ” is defined in master page. So, the content page is not able to add function to the body’s onload event directly. In order to work around this limitation, SharePoint provides the “_spBodyOnLoadFunctionNames” array. When the body is loaded, the onload event handler executes each function whose name is contained in this array. We added “myFunction” to the array so that it would run when the body’s onload event fires.
_spBodyOnLoadFunctionNames.push("myFunction ");

To fix the javascript error: View source of sharepoint page from browser.
1. Make sure in the head tag, init.js is included.

<script type="text/javascript" language="javascript" src="/_layouts/1033/init.js?rev=VhAxGc3rkK79RM90tibDzw%3D%3D"></script>

2. Body onload is properly defined.

<BODY scroll="yes" onload="javascript:if (typeof(_spBodyOnLoadWrapper) != 'undefined') _spBodyOnLoadWrapper();">

If these are not defined then it causes javascript error.
Hope, It helps.

Pass parameters to web-service with image uploading in iphone

2009-10-28T07:54:00.000-07:00

When you upload a file you are really posting a form's content to the browser by using a different encoding type (enctype) in your form. That encoding is specified as enctype="multipart/form-data" as an attribute of your form.
The specification in RFC 1867 "Form-based File Upload in HTML" describes the mechanism by which a file may be uploaded from a Web browser to the server.
There are a lot of articles to pass image to webservice. but, I require to pass some parameters with image.

Suppose I need to pass following parameters with image:
Parameter1
tag
status
customerID
customerName

Then following should be posted:

-----------------------------14737809831466499882746641449
Content-Disposition: form-data; name="parameter1"

MyValue1
-----------------------------14737809831466499882746641449
Content-Disposition: form-data; name="tag"

MyTags
-----------------------------14737809831466499882746641449
Content-Disposition: form-data; name="status"

1
-----------------------------14737809831466499882746641449
Content-Disposition: form-data; name="customerID"

B115B57A-23D3-56BC-B457-860BFDA83AB3
-----------------------------14737809831466499882746641449
Content-Disposition: form-data; name="customerName"

MyName 007
-----------------------------14737809831466499882746641449
Content-Disposition: form-data; name="image"; filename="20091228144754.jpg"
Content-Type: application/octet-stream

(Binary Content)
-----------------------------14737809831466499882746641449--

Format:
For normal input:

<hex value>CRLFContent-Disposition: form-data; name="<input
name>"CRLFCRLF<input value>CRLF

For file type input:

<hex value>CRLFContent-Disposition: form-data; name="<input
name>"; filename="<file
path>"CRLFContent-Type: <mime-type>CRLFCRLF<input
value>CRLF

iPhone Implementation:
We will pass the parameters in the above format. For this:
1. All the text like -----------------------------14737809831466499882746641449 is what separates each input.
2. Note also that in the end of the post we also have the text -----------------------------14737809831466499882746641449-- but it signals the end of our post, since it ends with 2 minus signs (--). Anyway, don't forget that this strange.

// setting up the request object now
 NSURL *nsurl =[NSURL URLWithString:urlString];
 NSMutableURLRequest *request = [NSMutableURLRequest requestWithURL:nsurl cachePolicy:NSURLRequestUseProtocolCachePolicy timeoutInterval:60.0]; 
 [request setURL:nsurl];
 [request setHTTPMethod:@"POST"];


NSString *boundary = [NSString stringWithString:@"---------------------------14737809831466499882746641449"];
 NSString *contentType = [NSString stringWithFormat:@"multipart/form-data; boundary=%@",boundary];
 [request addValue:contentType forHTTPHeaderField: @"Content-Type"];
 
 /*
  now lets create the body of the post
  */
 NSMutableData *body = [NSMutableData data];
 
 //parameter1
 [body appendData:[[NSString stringWithFormat:@"\r\n--%@\r\n",boundary] dataUsingEncoding:NSUTF8StringEncoding]]; 
 [body appendData:[[NSString stringWithFormat:@"Content-Disposition: form-data; name=\"parameter1\"\r\n\r\n%@", parameter1] dataUsingEncoding:NSUTF8StringEncoding]];
 [body appendData:[[NSString stringWithFormat:@"\r\n--%@\r\n",boundary] dataUsingEncoding:NSUTF8StringEncoding]];
 //Tags
 [body appendData:[[NSString stringWithFormat:@"Content-Disposition: form-data; name=\"tag\"\r\n\r\n%@", tag] dataUsingEncoding:NSUTF8StringEncoding]];
 [body appendData:[[NSString stringWithFormat:@"\r\n--%@\r\n",boundary] dataUsingEncoding:NSUTF8StringEncoding]];
 //Status
 [body appendData:[[NSString stringWithFormat:@"Content-Disposition: form-data; name=\"status\"\r\n\r\n%@", status] dataUsingEncoding:NSUTF8StringEncoding]];
 [body appendData:[[NSString stringWithFormat:@"\r\n--%@\r\n",boundary] dataUsingEncoding:NSUTF8StringEncoding]];
 //customerID
 [body appendData:[[NSString stringWithFormat:@"Content-Disposition: form-data; name=\"customerID\"\r\n\r\n%@", customerID] dataUsingEncoding:NSUTF8StringEncoding]];
 [body appendData:[[NSString stringWithFormat:@"\r\n--%@\r\n",boundary] dataUsingEncoding:NSUTF8StringEncoding]];
 //customerName
 [body appendData:[[NSString stringWithFormat:@"Content-Disposition: form-data; name=\"customerName\"\r\n\r\n%@", customerName] dataUsingEncoding:NSUTF8StringEncoding]];
 [body appendData:[[NSString stringWithFormat:@"\r\n--%@\r\n",boundary] dataUsingEncoding:NSUTF8StringEncoding]];
 //Image
 [body appendData:[[NSString stringWithFormat:@"Content-Disposition: form-data; name=\"image\"; filename=\"%@\"\r\n",[fileName text]] dataUsingEncoding:NSUTF8StringEncoding]];
 [body appendData:[[NSString stringWithString:@"Content-Type: application/octet-stream\r\n\r\n"] dataUsingEncoding:NSUTF8StringEncoding]];
 [body appendData:[NSData dataWithData:imageData]];
 [body appendData:[[NSString stringWithFormat:@"\r\n--%@--\r\n",boundary] dataUsingEncoding:NSUTF8StringEncoding]];
 
 // setting the body of the post to the reqeust
 [request setHTTPBody:body];
 
NSData *returnData = [NSURLConnection sendSynchronousRequest:request returningResponse:nil error:nil];

Hope, It helps.

Get Custom Document Properties / Document Information Panel Values using C#

2009-10-03T22:57:00.000-07:00

Object: To retrieve custom document properties of office documents using C#.
Generally, it is required to get or set custom document properties programmatically. For example, when document is checked out from sharepoint server then document information panel shows server properties. Our object is to modify the properties using C# in word. But problem is document type. Before office 2007, the document is binary file and in Office 2007, it is compressed XML file. Here is the sample code to do this. In the code, all the properties name are passed as hashtable keys.

//Collection of all column Names
Hashtable ht = new Hashtable();
//Collection of name and values of custom document properties
List<ListItem> lstTags = new List<ListItem>();
//Active Document
Microsoft.Office.Interop.Word.Document objDoc;

void LoadValuesFromDocuments(Hashtable ht)
{
//Office 2007 Documents
if (objDoc.Name.ToLower().EndsWith("docx"))
{
//Load Document Information Panel
XmlDocument InfoPathXML = new XmlDocument();
InfoPathXML.LoadXml(objDoc.CustomXMLParts[4].XML);
//Log("XML: "+ Doc.CustomXMLParts[4].XML);
foreach (string str in ht.Keys)
{
try
{
ListItem lstItem = new ListItem();
lstItem.Text = str;
lstItem.Value = InfoPathXML.SelectSingleNode("//*[local-name(.)='" + ht[str].ToString() + "']").InnerText;
lstTags.Add(lstItem);
}
catch (Exception ex)
{
Log(ex.ToString());
}
}
}
else            //Old Documents
{
foreach (string str in ht.Keys)
{
try
{
ListItem lstItem = new ListItem();
lstItem.Text = str;
lstItem.Value = ((DocumentProperties)objDoc.CustomDocumentProperties)[str].Value.ToString();
lstTags.Add(lstItem);
}
catch (Exception ex)
{ Log(ex.ToString()); }

}

}
}

To set values for older version documents (NOT Office 2007 docs)

try
{                   
((DocumentProperties)objDoc.CustomDocumentProperties)[fieldName].Value = fieldValue;                   
// Add and Remove sample text to indicate msword that the document is modified so that It will pass 
// DIP info to sharepoint even there is no change in content.
object startPosition = 0;
object endPosition = 0;                    
Range r = objDoc.Range(ref startPosition, ref endPosition);
r.InsertAfter("this is test.");
object unit = Microsoft.Office.Interop.Word.WdUnits.wdCharacter;
object count = 1;
r.Delete(ref unit, ref count);
}
catch (Exception ex)
{
Log(ex.ToString());                  
}

Hope! It helps.

Managing custom task panes across multiple documents in shared add in for office 2007 using .NET

2009-10-03T22:43:00.000-07:00

I see a lot of articles on this topic but all are related to VSTO. But I required this for shared addin. I followed MSDN to create custom task pane using shared addin. It works fine but when multiple documents are opened then it appears only for the first document. I have implemented to show document wise custom task pane.

using MSword = Microsoft.Office.Interop.Word;
public class Connect : Object, Extensibility.IDTExtensibility2,  ICustomTaskPaneConsumer 
{
public Connect()
{
}
public void OnConnection(object application, Extensibility.ext_ConnectMode connectMode, object addInInst, ref System.Array custom)
{
applicationObject = (MSword.Application)application;
addInInstance = addInInst;

}
public void OnStartupComplete(ref System.Array custom)
{
applicationObject.DocumentOpen += new Microsoft.Office.Interop.Word.ApplicationEvents4_DocumentOpenEventHandler(applicationObject_DocumentOpen);
applicationObject.WindowActivate += new Microsoft.Office.Interop.Word.ApplicationEvents4_WindowActivateEventHandler(applicationObject_WindowActivate); 
}
void applicationObject_DocumentOpen(Microsoft.Office.Interop.Word.Document Doc)
{   
AddCustomTaskPane();             
}
void applicationObject_WindowActivate(Microsoft.Office.Interop.Word.Document Doc, Microsoft.Office.Interop.Word.Window Wn)
{
}
public void OnBeginShutdown(ref System.Array custom)
{
}
public void OnDisconnection(Extensibility.ext_DisconnectMode disconnectMode, ref System.Array custom)
{
}
public void OnAddInsUpdate(ref System.Array custom)
{
}
private MSword.Application applicationObject;
private object addInInstance;        

#region ICustomTaskPaneConsumer Members
ICTPFactory ctpFactory;
object missing = Type.Missing;


public void CTPFactoryAvailable(ICTPFactory CTPFactoryInst)
{
ctpFactory = CTPFactoryInst;
AddCustomTaskPane(); 
}
public void AddCustomTaskPane()
{
CustomTaskPane CTP = ctpFactory.CreateCTP("MyNameSpace.MyUserControl", "My Task Pane", missing);
MyUserControl sampleAX = (MyUserControl)CTP.ContentControl;               
CTP.Visible = true;        
}


#endregion
}

Database Installation using VS setup

2009-08-19T21:55:00.000-07:00

Database installation is common task in setup programming.Here are the steps to install sql server database with setup using custom action. the summary is following

1. create a text file that contains a SQL statement to create a database, Tables, functions and stored procedures
2. Add installer class to execute sql statements
3. Create deployment project for Primary output for the Existing project.
4. Create custom installation dialog for database server.
5. Create custom action for installing database, build setup project and install it.

For more details, See here.

Add/Remove Assembly to WSP (VSEWSS)

2009-08-19T04:27:00.000-07:00

I was facing a problem to add an assembly in VSEWSS generated WSP. I added assembly in “manifest.xml” but it is refreshed during packaging. I added assembly in VS but it was not included in WSP. There is no direct way to access ddf in VSEWSS. At Last, I got solution:

1. Add reference > Select Assembly > OK
2. Right click of Assembly > Properties
3. Set “Copy Local” property = true

4. Deploy Solution
Now, you will get assembly in WSP. You can see by renaming wsp to cab and open cab file.
To Remove assembly from WSP, Perform same steps and set “Copy Local” property = false.

Hope! You will enjoy it.

Display Hierarchical Data with TreeView in ASP.NET

2009-08-06T21:59:00.000-07:00

See Here.

Dynamic multiline label with custom font in UITableViewController

2009-07-30T09:11:00.000-07:00

Suppose you need to show long text in tableview cell with custom font then height is the major issue. See following steps to do this:
1. Download FontLabel app source from
http://github.com/zynga/FontLabel
It has a good library with sample to use custom fonts embedded with project. Add FontLabel library to your project.

2. See following to generate label with custom font dynamically.

#define CELL_CONTENT_WIDTH 320.0f
#define CELL_CONTENT_MARGIN 10.0f

//Create Label with specific font, size and text on specific x,y.
- (FontLabel *)getLabel:(CGFloat)x :(CGFloat )y :(NSString *)fontName :(CGFloat )fontSize :(NSString *)text
{
 CGSize constraint = CGSizeMake(CELL_CONTENT_WIDTH - (CELL_CONTENT_MARGIN+x), 20000.0f);
    
    CGSize size = [text sizeWithFont:[UIFont systemFontOfSize:fontSize] constrainedToSize:constraint lineBreakMode:UILineBreakModeWordWrap];
    
 
 
 FontLabel *lbl =[[FontLabel alloc] initWithFrame:CGRectMake(x, y, CELL_CONTENT_WIDTH- (CELL_CONTENT_MARGIN+x), size.height)
            fontName:fontName pointSize:fontSize];
 lbl.textColor = [UIColor blackColor];
 lbl.text = text;
 lbl.numberOfLines = 0;
 //lbl.textAlignment = UITextAlignmentLeft;
 lbl.lineBreakMode = UILineBreakModeWordWrap;
 lbl.baselineAdjustment = UIBaselineAdjustmentNone;  
 [lbl sizeToFit];
 return lbl;
}

3.You can add labels in tableview cell using cellForRowAtIndexPath method

lblID = [self getLabel:CELL_CONTENT_MARGIN :CELL_CONTENT_MARGIN :@"angelina" :24.0f :title];
[cell addSubview: lblID];

4. We need to set tableview cell height according to multiline label height. See following for this:

- (CGFloat)tableView:(UITableView *)tableView heightForRowAtIndexPath:(NSIndexPath *)indexPath;
{
    
 FontLabel *lbl = [[self getLabelFromIndex:indexPath] retain];
 CGSize constraint = CGSizeMake(CELL_CONTENT_WIDTH - (CELL_CONTENT_MARGIN * 2), 20000.0f);
    
    CGSize size = [lbl.text sizeWithFont:lbl.font constrainedToSize:constraint lineBreakMode:UILineBreakModeWordWrap];
    
    CGFloat height = size.height;
    
  
    return height + (CELL_CONTENT_MARGIN * 2);
 
}

where getLabelFromIndex returns label of the cell.

Hope, It helps.

Show UIImagePickerController from UITableViewController in iPhone

2009-07-30T09:01:00.000-07:00

Suppose you need to show UIImagePickerController on cell click of UITableViewController class. Then
1. define UIImagePickerControllerDelegate in the header class.
2. Put following code for the cell index of didSelectRowAtIndexPath method

imgPicker = [[UIImagePickerController alloc] init];
    imgPicker.allowsImageEditing = NO;
    imgPicker.delegate = self; 
    imgPicker.sourceType = UIImagePickerControllerSourceTypePhotoLibrary;
    imgPicker.navigationBar.tintColor =  self.navigationController.navigationBar.tintColor;
    imgPicker.navigationBar.barStyle =self.navigationController.navigationBar.barStyle; 
    [self.navigationController presentModalViewController:imgPicker animated:YES];

To return from image picker

- (void)imagePickerController:(UIImagePickerController *)picker didFinishPickingImage:(UIImage *)img editingInfo:(NSDictionary *)editInfo {
  
 
... Perform operation on selected image ...

 [[picker parentViewController]  dismissModalViewControllerAnimated:YES];
 

}

Hope, it helps.

Resize Image to scale for a given max dimension in iphone

2009-07-30T08:47:00.000-07:00

Generally , It is required to resize image for a given max size. the ratio of the image width and height is called Aspect ratio. If resized image aspect ratio is different from original image then it is distorted. So, It is required to resize the image in such a way that it must be in the given max size keeping same aspect ratio.
Suppose our image object is selImage to be resized in iPhone app. See following code for this:

CGFloat newWidth = selImage.size.width;
 CGFloat newHeight = selImage.size.height;
 CGFloat maxWidth = [[dict valueForKey:@"MaxWidth"] floatValue];
 CGFloat maxHeight = [[dict valueForKey:@"MaxHeight"] floatValue]; 
 
 
 //Scale the Image
 CGFloat scale = 0.0;
 
 if (newWidth > maxWidth || newHeight > maxHeight)
 {
  if (maxWidth/newWidth < maxHeight/newHeight)
  {
   scale = maxWidth/newWidth;
  }
  else
  {
   scale = maxHeight/newHeight;
  }
  newWidth = newWidth*scale;
  newHeight = newHeight*scale;
  
 }
 
selImage = [self resizedImage:selImage Rect:CGRectMake(0.0, 0.0, newWidth, newHeight)];

- (UIImage *) resizedImage:(UIImage *)inImage Rect:(CGRect)thumbRect
{

 UIGraphicsBeginImageContext(thumbRect.size);
 [inImage drawInRect:thumbRect];
 UIImage *newImage = UIGraphicsGetImageFromCurrentImageContext();
 UIGraphicsEndImageContext();
 return newImage;
}

Hope, It helps.

Search Engine style paging in asp.net(C#)

2009-07-28T02:12:00.000-07:00

When a large number of records are to be displayed and total number of records is variable in nature then search engine style paging is the best approach. For a search query, we need to pass start record number and page size for paging. In the most search engine, the start index is passed using querystring.
See following, Google uses “start” query string parameter.

To create search engine style pagination in asp.net, see following method. It takes 3 parameters:
1. totalRecords
2. pageSize
3. totalNumericLinks : total number of numeric links. It is 20 in above image.

string GetPaging(int totalRecords, int pageSize, int totalNumericLinks)
{
if (totalRecords <= pageSize)
{
return "";
}

StringBuilder str = new StringBuilder();
//Get Total no of pages
int totalPages = totalRecords / pageSize + (totalRecords % pageSize > 0 ? 1 : 0);
//Get Current Page no
int currentPageNo = 1;
string pageUrl = Context.Request.Url.AbsolutePath;    
if (Context.Request.QueryString["start"] != null)
{
currentPageNo = 1 + (Convert.ToInt32(Context.Request.QueryString["start"]) - 1) / pageSize;           
}

//Add previous button
if (currentPageNo > 1)
{
str.Append(string.Format(" <a  href=\"" + pageUrl + "?start={0}\" title=\"Previous page\"><Prev</a>", (currentPageNo - 2)*pageSize + 1));
}
//Add Numeric link
int sp, ep;
if (totalNumericLinks >= totalPages)
{
sp = 1;
ep = totalPages;
}
else
{
if (currentPageNo - totalNumericLinks / 2 > 0)
{                    
ep = (currentPageNo + totalNumericLinks / 2 - (totalNumericLinks-1)%2);
ep = ep < totalPages ? ep : totalPages;
}
else
{                  
ep = totalNumericLinks;
}
sp = ep - totalNumericLinks+1 > 0?ep - totalNumericLinks+1:1;
}
for (int p = sp; p <= ep; p++)
{
//For Current Page, No Link, Bold Text  
if (p == currentPageNo)
{
str.Append(String.Format(" <b>{0}</b>", p.ToString()));
}
else
{
str.Append(String.Format(" <a href=\"" + pageUrl + "?start={1}\" title=\"{0}\">{0}</a> ", p, (p - 1) * pageSize + 1));
}
}
//Add Next button
if (currentPageNo < totalPages)
{
str.Append(String.Format(" <a href=\"" + pageUrl + "?start={0}\" title=\"Next page\">Next></a>", (currentPageNo * pageSize +1).ToString()));
}

return str.ToString(); 

}

Hope ! It helps.

Reload Table View with different values iPhone

2009-07-25T07:44:00.000-07:00

Sometimes, It is required to use same tableviewcontroller multiple times with different parameters. For example, in a game, we need to show same screen with different elements. Here, our object is to reuse UITableViewController with different parameters and it will be happened on navigation next button click.
Here are the simple steps to do this:

1. Declare all parameters which make changes in tableview in AppDelegate class.
2. Load all parameters/Data sources in applicationDidFinishLaunching method.
3. Add a UITableViewController class and add all required controls, methods and properties.
4. In init method of UITableViewController initialize appDelegate class object to access the parameters.
5. Now in following method loads control with the appDelegate's parameters value and add it in the cell view.

- (UITableViewCell *)tableView:(UITableView *)tableView cellForRowAtIndexPath:(NSIndexPath *)indexPath {

...... Setup the cell ......

}

6. Process and Call [self loadView]; where you want to reload data with changes.

Suppose you need to set tableview according NSMutableArray and On next click, you need to show next element of NSMutableArray.
Then declare index parameter in AppDelegate class and use it in cellForRowAtIndexPath method. On next click, Increment the index value and reload using [self loadView]; It will call cellForRowAtIndexPath again for the next value.

Hope, It helps.

Set div’s all anchor tags onclick event using javascript

2009-07-24T22:48:00.000-07:00

Here is an example to set all child anchor tags onclick event.
A div (id str1) has 3 anchor tags (First, Second and Third). When user clicks on any link, it should call “ShowValue” javascript method which displays text of that link. We have to set onclick event dynamically using javascript. See following for this:

<script type="text/javascript" >
function SetThis(anc)
{    
var s = document.getElementById(anc).getElementsByTagName("a");   
for (var i=0;i<s.length;i++)
{
s[i].onclick = Function("ShowValue('"+s[i].innerText+"')");     
}          
}
function ShowValue(atag)
{   
alert(atag); 
}     
</script>
<div id= "str1">
<a href="javascript: void(0)">First</a><br/>
<a href="javascript: void(0)">Second</a><br/>
<a href="javascript: void(0)">Third</a><br/>
</div>
<script type="text/javascript">
SetThis('str1'); 
</script>

In the code I used
s[i].onclick = Function("ShowValue('"+s[i].innerText+"')");

Suppose If I use
s[i].onclick = ShowValue(s[i].innerText);
It is executed immediately and on page load, ‘First’ is displayed. But onclick, “Object expected” error is thrown.
If I use
s[i].onclick =function(){ ShowValue(s[i].innerText)};
In this case, We get error:
“’s[…].innerText’ is null or not an object”
So s[i].onclick = Function("ShowValue('"+s[i].innerText+"')"); works perfect.
Hope, It helps.