Tuesday, April 28, 2009

SQL SP for Update with the Condition cheking

ALTER PROCEDURE [dbo].[uspUpdateEmployee]
@UserName varchar(50),
@JoinDate datetime,
@PermantApprovedDate datetime,
@IsActive bit,
@EmployeeStatus int
AS

DECLARE @IsPermentEmployeeVal BIT
IF(@EmployeeStatus = 1)

BEGIN
SET @IsPermentEmployeeVal=1
END

ELSE
BEGIN
SET @IsPermentEmployeeVal = 0
END

UPDATE tblEmployees

SET
[LastModifiedDate] = Getdate(),
[PermantApprovedDate] = @PermantApprovedDate,
[JoinedDate] = @JoinDate,
[IsActive]=@IsActive,
[EmployeeStatus] =@EmployeeStatus,
IsPermentEmployee=@IsPermentEmployeeVal
WHERE UserName=@UserName

Friday, April 24, 2009

Changing the text in a Div using java script

java script code
================
document.getElementById("divMenuText").innerText="Title for top level menu";

html code
=========
< td width="130" > <div id="divMenuText" > Menu Text:</div > </td >

Close the browser window Using C# code

StringBuilder postBackScript = new StringBuilder();
postBackScript.Append("< script language=JavaScript >");
postBackScript.Append("self.close(); ");
postBackScript.Append("</script >");

if (!Page.ClientScript.IsClientScriptBlockRegistered("parentCallBack"))
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "parentCallBack", postBackScript.ToString());

return false in javascript message box

this.btnLogOut.Attributes.Add("OnClick", "window.close(); return false;");

Set Culture setting from web config and get required Date time format

< globalization requestEncoding="utf-8" responseEncoding="utf-8" culture="en-AU" uiCulture="en-AU"/>