Stored proc (xmldoc XML) calling methods

Public Function CreateXml() As String

        Dim xml As New StringBuilder()

        Try

            xml.Append(“<root><Tasks TasksId=”"”)

            xml.Append(TasksId)

 

            xml.Append(“”" Name=”"”)

            xml.Append(Name)

 

            xml.Append(“”" Priority=”"”)

            xml.Append(Priority)

 

            xml.Append(“”" IsNotificationOnly=”"”)

            xml.Append(IsNotificationOnly)

 

            xml.Append(“”" IsRetain=”"”)

            xml.Append(IsRetain)

 

            xml.Append(“”" EngagementID=”"”)

            xml.Append(EngagementID)

 

            xml.Append(“”" Assignor=”"”)

            xml.Append(Assignor)

 

            xml.Append(“”" AssignedDate=”"”)

            xml.Append(AssignedDate)

 

            xml.Append(“”" Desc=”"”)

            xml.Append(Desc)

 

            xml.Append(“”" DueDate=”"”)

            xml.Append(DueDate)

 

            xml.Append(“”" HasIssues=”"”)

            xml.Append(HasIssues)

 

            xml.Append(“”" HasAttachment=”"”)

            xml.Append(HasAttachment)

 

            xml.Append(“”" Requester=”"”)

            xml.Append(Requester)

 

            xml.Append(“”" HasServiceExtension=”"”)

            xml.Append(HasServiceExtension)

 

            xml.Append(“”" ReviewStatus=”"”)

            xml.Append(ReviewStatus)

 

            xml.Append(“”" ImportSrc=”"”)

            xml.Append(ImportSrc)

 

            xml.Append(“”" ImportSourceInfo=”"”)

            xml.Append(ImportSourceInfo)

 

            xml.Append(“”" ImportSourceItem=”"”)

            xml.Append(ImportSourceItem)

 

            xml.Append(“”" ImportSourceVersion=”"”)

            xml.Append(ImportSourceVersion)

 

            xml.Append(“”" ImportSourceType=”"”)

            xml.Append(ImportSourceType)

 

            xml.Append(“”" CreatedBy=”"”)

            xml.Append(CreatedBy)

 

            xml.Append(“”" CreatedOn=”"”)

            xml.Append(CreatedOn)

 

            xml.Append(“”" rowguid=”"”)

            xml.Append(rowguid)

 

 

 

            xml.Append(“”"/></root>”)

            Return (xml.ToString())

        Catch err As Exception

            Throw err

        End Try

    End Function

 

    Public Function saveTask(ByVal xmlTasks As String, ByVal StrTaskid As String) As Boolean

 

        Dim _sqlConnection As New SqlConnection()

        Dim cmdInsert As New SqlCommand()

        Dim retVal As Boolean

 

        Dim strConn As String = ConfigurationManager.ConnectionStrings(“sqlConnectionString”).ToString()

 

        Try

            _sqlConnection.ConnectionString = strConn

            _sqlConnection.Open()

 

            cmdInsert.Connection = _sqlConnection

            cmdInsert.CommandType = CommandType.StoredProcedure

 

            cmdInsert.CommandText = “Proc_SaveTask”

 

            cmdInsert.Parameters.Add(“@xmldoc”, SqlDbType.Xml)

            cmdInsert.Parameters(0).Value = xmlTasks

 

            cmdInsert.Parameters.Add(“@Id”, SqlDbType.VarChar)

            cmdInsert.Parameters(1).Value = StrTaskid

 

            cmdInsert.ExecuteNonQuery()

 

            retVal = True

 

        Catch ex As Exception

 

            retVal = False

 

        End Try

 

 

        Return retVal

 

 

    End Function

 

===============================================

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
create PROCEDURE [dbo].[Proc_SaveTask](@xmldoc XML,@Id varchar(50))

AS
DECLARE @idoc int

BEGIN TRAN
if isnull(@Id,”)<>”  delete from Task where TasksId=@Id
 

–Create an internal representation of the XML document.
EXEC sp_xml_preparedocument @idoc OUTPUT, @xmldoc

INSERT INTO Task (TasksId,[Name], Priority,IsNotificationOnly,IsRetain,
 EngagementID,Assignor, AssignedDate,[Desc],DueDate,
 HasIssues,HasAttachment,Requester,HasServiceExtension,
 ReviewStatus,ImportSrc,ImportSourceInfo,ImportSourceItem,
 ImportSourceVersion,ImportSourceType,CreatedBy,CreatedOn,rowguid)

SELECT   
 
 TasksId ,  
 CASE WHEN [Name] <>” THEN [Name] ELSE NULL END,
 CASE WHEN Priority <>” THEN Priority ELSE NULL END,
 CASE WHEN IsNotificationOnly <>” THEN IsNotificationOnly ELSE NULL END,
 CASE WHEN IsRetain <>” THEN IsRetain ELSE NULL END,
 CASE WHEN EngagementID <>” THEN EngagementID ELSE NULL END,
 CASE WHEN Assignor <>” THEN Assignor ELSE NULL END,
 CASE WHEN AssignedDate <>” THEN AssignedDate ELSE NULL END,  
 CASE WHEN [Desc] <>” THEN [Desc] ELSE NULL END,
 CASE WHEN DueDate <>” THEN DueDate ELSE NULL END,
 CASE WHEN HasIssues <>” THEN HasIssues ELSE NULL END,
 CASE WHEN HasAttachment <>” THEN HasAttachment ELSE NULL END,
 CASE WHEN Requester <>” THEN Requester ELSE NULL END,
 CASE WHEN HasServiceExtension <>” THEN HasServiceExtension ELSE NULL END,
 CASE WHEN ReviewStatus <>” THEN ReviewStatus ELSE NULL END,
 CASE WHEN ImportSrc <>” THEN ImportSrc ELSE NULL END,
 CASE WHEN ImportSourceInfo <>” THEN ImportSourceInfo ELSE NULL END,
 CASE WHEN ImportSourceItem <>” THEN ImportSourceItem ELSE NULL END,
 CASE WHEN ImportSourceVersion <>” THEN ImportSourceVersion ELSE NULL END,
 CASE WHEN ImportSourceType <>” THEN ImportSourceType ELSE NULL END,
 CASE WHEN CreatedBy <>” THEN CreatedBy ELSE NULL END,
 CASE WHEN CreatedOn <>” THEN CreatedOn ELSE NULL END,  
 rowguid
 
FROM       OPENXML (@idoc, ‘/root/Tasks’,1)
            WITH
    (TasksId varchar(50), [Name] varchar(200),Priority varchar(200),IsNotificationOnly varchar(200),
    IsRetain varchar(200),EngagementID varchar(50), Assignor varchar(200),  AssignedDate varchar(25),
    [Desc] varchar(200), DueDate varchar(25), HasIssues varchar(50), HasAttachment varchar(50),
    Requester varchar(50), HasServiceExtension varchar(200), ReviewStatus varchar(200),
    ImportSrc varchar(200), ImportSourceInfo varchar(200),  ImportSourceItem varchar(200),
    ImportSourceVersion varchar(200), ImportSourceType varchar(200),
    CreatedBy varchar(200), CreatedOn varchar(25), rowguid uniqueidentifier )
IF @@ERROR>0
BEGIN
ROLLBACK TRAN
END
ELSE
BEGIN
COMMIT TRAN
END
EXEC SP_XML_REMOVEDOCUMENT @xmldoc

——————————————————————————-
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
create  PROCEDURE [dbo].[Proc_SelectTask](@TaskId varchar(50))

AS
select * from task Where TasksId=@TaskId For XML Auto  , ELEMENTS

——————————————————————————-

javascript validations radiobutton list etc…..(full page)

<html xmlns=”http://www.w3.org/1999/xhtml”>

<head runat=”server”>

        <title>Untitled Page</title>

        <script type=”text/javascript”>

            function ValidateNumbers()

            {

                if(document.getElementById(‘txtNumber’).value!=”)

                {

                     var input= document.getElementById(‘txtNumber’).value;

 

//                    var testName =/^([0-9])*$/;

//                    if(!testName.test(input))

//                    {

//                       alert(“Enter only numeric values”);

//                       return false;

//                    }

                    if (input == null || !input.toString().match(/^[-]?\d*\.?\d*$/))

                    {

                        alert(“Enter only numeric values”);

                        return false;

                    }

                    

                   

                }

                if(document.getElementById(‘ddlInput’).selectedIndex  == 0)

                {

                     alert(“Select Numbers”);

                       return false;

                }              

                 //validate radio list

                 var listItemArray = document.getElementsByName(‘ddlColors’);

                 var isItemChecked = false;

 

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

                 {

                  var listItem = listItemArray[i];

 

                  if ( listItem.checked )

                  {

                   //alert(listItem.value);

                   isItemChecked = true;

                  }

                 }

 

                 if ( isItemChecked == false )

                 {

                  alert(‘Nothing is checked!’);

 

                  return false;

                 }

 

 

 

            }

        </script>

    </head>

<body>

    <form id=”form1″ runat=”server”>

    <div>

       

        <asp:TextBox ID=”txtNumber” runat=”server”></asp:TextBox>

        <asp:DropDownList ID=”ddlInput” runat=”server”>

             <asp:ListItem Text=”Select”></asp:ListItem>

            <asp:ListItem Text=”One”></asp:ListItem>

            <asp:ListItem Text=”Two”></asp:ListItem>

            <asp:ListItem Text=”Three”></asp:ListItem>

        </asp:DropDownList>

        <asp:RadioButtonList ID=”ddlColors” runat=”server”>

            <asp:ListItem Text=”Red”></asp:ListItem>

            <asp:ListItem Text=”Blue”></asp:ListItem>

            <asp:ListItem Text=”White”></asp:ListItem>

        </asp:RadioButtonList>

         <asp:Button ID=”btnSubmit” runat=”server” OnClientClick=”return ValidateNumbers()” Text=”Submit” />

    </div>

    </form>

</body>

</html>

 

javascripts -1

<script language=”javascript” type=”text/javascript”>

 

      

 

 

        //the following function is currently not used

    

        function reSize()

        {

            var winW = 630, winH = 460;

 

            if (parseInt(navigator.appVersion)>3)

            {

                if (navigator.appName==“Netscape”)

                {

                    winW = window.innerWidth;

                    winH = window.innerHeight;

                }

                if (navigator.appName.indexOf(“Microsoft”)!=-1)

                {

                    winW = document.body.offsetWidth;

                    winH = document.body.offsetHeight;

                }

            }

           

            alert(winH);

            winH = winH – 90;

            var windowheight = window.screen.height;

            var objMenu = document.getElementById(“CategoryMenu_tblMenuControl”);

            var objHeader = document.getElementById(“tbHeader”);

            //objMenu.height = winH + “px”

        }

       

        //The following ConfirmDialog function is used in MultiLocation grid events

        function ConfirmDialog()

        {          

            var obj = document.getElementById(“MultiLocation1_pnlMulti”); 

            if (obj.disabled == false)

            {          

                return confirm(‘Are you sure you want to delete this record’);

            }           

        }

       

       

       var dtpSdate;

      

        function GetDateName(strName)

       {

           var obj = document.getElementById(‘Engpanel1_Dtp’+ strName +‘_MyDtpText’);      

           dtpSdate=‘Engpanel1_Dtp’+ strName +‘_MyDtpText’;      

            if(obj == null)

           {

           obj = document.getElementById(‘Engpanel1_txt’+strName); 

            if(obj != null)

            {

             dtpSdate=‘Engpanel1_txt’+strName;            

            }

           }

           return dtpSdate;

       }

      

       function showAlert(msg)

       {

           alert(msg);     

           return false;

       }

   

        function Validate(ctrl,msg)

        {

            var obj = document.getElementById(ctrl); 

 

            if(obj != null)

            {

                if(obj.value == ”)

                {

                    showAlert(msg);                  

                    return false;

                }               

            }                   

        }

        function checkObjExsist(ctrl)

        {

            var obj = document.getElementById(ctrl);

            if(obj == null)

            {

                return false;

            }

        }

        function DateNullCheck()

        {

          

            if (Validate( GetDateName(‘Periodstartdate’) ,‘Period Start Date should not be empty’)== false  )

            {

                return false ;

            }

            if (Validate(GetDateName(‘Periodenddate’),‘Period End Date should not be empty’)== false  )

            {

                return false ;

            }

            if (Validate(GetDateName(‘Expectedreportingdate’),‘Reporting date should not be empty’)== false  )

            {

                return false ;

            }

            return true;

        }

       

        function ValidateDateControls()

        {  

             

          

            if (Validate(‘Engpanel1_txtClientname’,‘Client Name should not be empty’)== false && checkObjExsist(‘Engpanel1_txtClientname’)!=false)

            {             

                return false ;

            }

 

            if (Validate(‘Engpanel1_txtEngagementname’,‘Engagement Name should not be empty’)== false  )

            {

                return false ;

            }

                       

            if(checkObjExsist(‘Engpanel1_txtSentinelnumber’)!= false)

            {

                var input= document.getElementById(‘Engpanel1_txtSentinelnumber’).value;

              

                var testName =/^([0-9])*$/;

 

                if (Validate(‘Engpanel1_txtSentinelnumber’,‘Sentinel Number should not be empty’)== false  )

                {

                    return false ;

                }

 

                if(!testName.test(input))

                {

                   showAlert(“Digits Only Allowed in Sentinel number”);

                   return false;

                }

            }

               

            if(checkObjExsist(‘Engpanel1_txtEngagementnumber’)!= false)

            {

                var input= document.getElementById(‘Engpanel1_txtEngagementnumber’).value;

              

                var testName =/^([0-9])*$/;

 

                if (Validate(‘Engpanel1_txtEngagementnumber’,‘Engagement Number should not be empty’)== false  )

                {

                    return false ;

                }

 

                if(!testName.test(input))

                {

                   showAlert(“Digits Only Allowed in Engagement number”);

                   return false;

                }

            }                

         

 

            if ((checkObjExsist(GetDateName(‘Periodstartdate’))!= false && checkObjExsist(GetDateName(‘Periodenddate’))!= false && checkObjExsist(GetDateName(‘Expectedreportingdate’))!= false))

            {

                if (DateNullCheck()==false)

                {

                    return false;

                }

           

                if( document.getElementById(GetDateName(‘Periodstartdate’)).value !=” && document.getElementById(GetDateName(‘Periodenddate’)).value!=” && document.getElementById(GetDateName(‘Expectedreportingdate’)).value!=”)

                {

                    if( Date.parse(document.getElementById(GetDateName(‘Periodstartdate’)).value)> Date.parse(document.getElementById(GetDateName(‘Periodenddate’)).value))

                    {

                        showAlert(“End Date should not be less than Start Date”); 

                        return false;

                    }                       

                    if ( Date.parse(document.getElementById(GetDateName(‘Expectedreportingdate’)).value)>Date.parse(document.getElementById(GetDateName(‘Periodenddate’)).value))

                    {

                        showAlert(‘Expected Reporting Date should not be greater than Period End Date’);   

                        return false;

                    }                       

                    if (Date.parse(document.getElementById(GetDateName(‘Periodstartdate’)).value)> Date.parse(document.getElementById(GetDateName(‘Expectedreportingdate’)).value))

                    {

                        showAlert(‘Expected Reporting date should not be less than Period Start Date’);

                        return false;

                    }

                }

                else

                {

                    return false;

                }

            }//Datenullcheck

        

            if(checkObjExsist(‘Engpanel1_DrpInwhichcountryistheengagementbeingperformed?’)!= false && document.getElementById(‘Engpanel1_DrpInwhichcountryistheengagementbeingperformed?’).selectedIndex  == 0  )

            {                

               showAlert(“Select in Which Country is the engagement being performed”);

               return false;

            }

        }

    </script>