Skip to main content

Featured post

XM Cloud content sync from prod to uat or UAT to prod step by step

When working with Sitecore, it’s common to need content synchronization across environments. Today, I’ll walk you through the steps to sync content from Production to UAT/TEST and vice versa. Steps to Follow 1. Set Up Your Workspace Create a folder on your computer where you will manage the script files and exported data. Open the folder path in PowerShell to begin scripting. We need to run some scripts in PowerShell to update the folder with the basic requirements for syncing content. PS C:\Soft\ContentSync> dotnet new tool-manifest PS C:\Soft\ContentSync> dotnet nuget add source -n Sitecore https://nuget.sitecore.com/resources/v3/index.json PS C:\Soft\ContentSync> dotnet tool install Sitecore.CLI PS C:\Soft\ContentSync> dotnet sitecore cloud login If the above error occurs, you will need to run a different command to resolve the issue. PS C:\Soft\ContentSync> dotnet sitecore init now, Again run above command to open and authenticate with XM Cloud. It will be there a...

How to bind data in grid using web method in asp.net

Here I have created method BindDataGrid () In this method I have used ajax method to get value from database by using web method . Web method return all the required data and bind it in table to form a grid for more details read the below code care fully.

This is the web method which call through ajax.

[WebMethod]
    public static ScheduleDetails[] BindGridByJs(string Status, string FromDate, string ToDate, string pagesize, string pageno, string Classname, string SubjectName, string TopicName)
    {
        DataSet Ds = new DataSet();
        List<GetLectureScheduleDetails> Details = new List<GetLectureScheduleDetails>();
        DataUtility Objdut = new DataUtility();
        SqlParameter[] Param = new SqlParameter[10];
        Param[0] = new SqlParameter("@FromDate", FromDate);
        Param[1] = new SqlParameter("@ToDate", ToDate);
        Param[2] = new SqlParameter("@Status", Status);
        Param[3] = new SqlParameter("@pagesize", pagesize);
        Param[4] = new SqlParameter("@pageno", pageno);
        Param[5] = new SqlParameter("@Classname", Classname);
        Param[6] = new SqlParameter("@SubjectName", SubjectName);
        Param[7] = new SqlParameter("@TopicName", TopicName);
        Param[8] = new SqlParameter("@Brid", HttpContext.Current.Session["Brbrid"]);
        Param[9] = new SqlParameter("@empid", HttpContext.Current.Session["empid"]);
        Ds = Objdut.GetDataSetSP(Param, "[usp_FacultyLecScheduled]");
        if (Ds.Tables[0].Rows.Count > 0)
        {
            foreach (DataRow dtrow in Ds.Tables[0].Rows)
            {
                GetLectureScheduleDetails user = new GetLectureScheduleDetails();
                user.RowNumber = dtrow["RowNumber"].ToString();
                user.Date = dtrow["Date"].ToString();
                user.FromTime = dtrow["FromTime"].ToString();
                user.InTime = dtrow["InTime"].ToString();
                user.ToTime = dtrow["ToTime"].ToString();
                user.OutTime = dtrow["OutTime"].ToString();
                user.ClassName = dtrow["ClassName"].ToString();
                user.SubjectName = dtrow["SubjectName"].ToString();
                user.TopicName = dtrow["TopicName"].ToString();
                user.Status = dtrow["Status"].ToString();
                user.pagecount = Ds.Tables[1].Rows[0]["pages"].ToString();
                Details.Add(user);
            }
        }
        return Details.ToArray();
    }
 This method is used create properties for different values.

    public class ScheduleDetails
    {
        public string RowNumber { get; set; }

        public string Date { get; set; }

        public string FromTime { get; set; }

        public string InTime { get; set; }

        public string ToTime { get; set; }

        public string OutTime { get; set; }

        public string ClassName { get; set; }

        public string SubjectName { get; set; }

        public string TopicName { get; set; }

        public string Status { get; set; }
                                                
        public string pagecount { get; set; }
    }





This method is use to call web method.

            function BindDataGrid() {
                call_progressbar("start");
                var trforappend = "";
                $('.stm tr:gt(0)').remove();
                $.ajax({
                    type: "POST",
                    contentType: "application/json; charset=utf-8",
                    url: "Schedule.aspx/BindGridByJs",
                    data: "{'Status':'" + status + "','FromDate':'" + frdate + "','ToDate':'" + todate + "','pagesize':'" + pagesize + "','pageno':'" + pageno + "','Classname':'" + Classname + "','SubjectName':'" + SubjectName + "','TopicName':'" + TopicName + "'}",
                    dataType: "json",
                    async: false,
                    success: function (data) {
                        if (data.d.length > 0) {
                            $('#hfpages').val(data.d[0].pagecount)
                            pagecount = parseInt(data.d[0].pagecount);
                            $("#lbltotalstudent").text(data.d[0].TotalStudent)
                            for (var i = 0; i < data.d.length; i++) {
                                if (i % 2 != 0)
                                    trforappend = '<tr class="stm_light"><td>' + data.d[i].RowNumber + '</td><td>' + data.d[i].Date + '</td><td>' + data.d[i].FromTime + '</td><td>' + data.d[i].InTime + '</td><td>' + data.d[i].ToTime + '</td><td>' + data.d[i].OutTime + '</td><td>' + data.d[i].ClassName + '</td><td>' + data.d[i].SubjectName + '</td><td>' + data.d[i].TopicName + '</td><td>' + data.d[i].Status + '</td></tr>';
                                else
                                    trforappend = '<tr class="stm_dark"><td>' + data.d[i].RowNumber + '</td><td>' + data.d[i].Date + '</td><td>' + data.d[i].FromTime + '</td><td>' + data.d[i].InTime + '</td><td>' + data.d[i].ToTime + '</td><td>' + data.d[i].OutTime + '</td><td>' + data.d[i].ClassName + '</td><td>' + data.d[i].SubjectName + '</td><td>' + data.d[i].TopicName + '</td><td>' + data.d[i].Status + '</td></tr>';
                                $('.stm').append(trforappend);
                                pagecount = parseInt(data.d[i].pagecount);
                                if (parseInt(pagecount) == 1) {
                                    $(".lbltotalpage").html("1");
                                    $(".lblpage").text("1");
                                }
                                else {
                                    $(".lbltotalpage").html(pagecount);
                                    $(".lblpage").text(pageno);
                                }
                            }
                            $(".lbltotalpage").html(pagecount); $('#lblnoofadm').html(i)
                            call_progressbar("end");
                        }

                        else {
                            alertify.error('No Record Found On The Behlaf Of Your Advance Searching.\n Reset All For Your Convienent.')
                            $('.lblpage').text('0');
                            $('.lbltotalpage').text('0');
                            call_progressbar("end");
                        }
                    },
                    error: function (result) {
                        call_progressbar("end");
                    }
                });
            }


Comments

Popular posts from this blog

List of pipeline in Sitecore and it's example

 List of pipeline in Sitecore and it's example Sitecore uses a pipeline architecture to process requests and manage the flow of data within the system. Here is a list of some common pipelines in Sitecore, along with an example for each one: HttpRequestBegin: This pipeline processes the initial request made by a user to the Sitecore website and sets up the environment for processing the request. For example, it might determine the language for the request based on the user's browser settings or the URL . HttpRequestProcessed: This pipeline processes the request after it has been processed by Sitecore and is used to perform any post-processing operations, such as logging or error handling. For example, it might log the request information to a database for later analysis. RenderLayout: This pipeline processes the layout for a page and is responsible for rendering the components of the page, including the header, footer, and content areas. For example, it might retrieve the layout...

Fileupload using AngularJS in asp.net c#

Fileupload using AngularJS in asp.net c# AngularJS built-in ng-model directive. I added an attribute called ng-files in to the file input element. Now, I need to  create a directive in the controller matching with the attribute  The attribute has a function named getTheFiles() with a parameter $files . I’ll initialize the parameter $files in my directive and later call the function getTheFiles() using the controller’s scope, along with $files parameter. <!DOCTYPE html> <html> <head>   <title>AngularJS File Upoad Example with $http and FormData</title>   <script src="http://ajax.googleapis.com/ajax/libs/angularjs/1.4.4/angular.min.js"></script> </head> <body ng-app="fupApp">     <div ng-controller="fupController">         <input type="file" id="file1" name="file" multiple        ...

How Directives are compiled in angularjs?

AngularJS always operates on DOM node. We are not able to do any notice when HTML page loads. It parse automatically into DOM. Compilation of HTML happens in three steps which is pointed below. 1.    In angularjs $compile is use to traverse the DOM and looks for directive. It find each directive and add it into the list of directive. 2.    It is use to sort the list of directive by their priority when the entire DOM has been traversed. Each directive has own compilation function to be executed and each have chance to modify by itself. Each compile function return linking function and then it is use to composed into combined linking function and return it. 3.    $compile relations the template with the choice by calling the joint linking function from the earlier step. This in turn will request the connecting function of the separate directives, process listeners on the elements and set up $watch with the scope as each directive is organised to...

XM Cloud content sync from prod to uat or UAT to prod step by step

When working with Sitecore, it’s common to need content synchronization across environments. Today, I’ll walk you through the steps to sync content from Production to UAT/TEST and vice versa. Steps to Follow 1. Set Up Your Workspace Create a folder on your computer where you will manage the script files and exported data. Open the folder path in PowerShell to begin scripting. We need to run some scripts in PowerShell to update the folder with the basic requirements for syncing content. PS C:\Soft\ContentSync> dotnet new tool-manifest PS C:\Soft\ContentSync> dotnet nuget add source -n Sitecore https://nuget.sitecore.com/resources/v3/index.json PS C:\Soft\ContentSync> dotnet tool install Sitecore.CLI PS C:\Soft\ContentSync> dotnet sitecore cloud login If the above error occurs, you will need to run a different command to resolve the issue. PS C:\Soft\ContentSync> dotnet sitecore init now, Again run above command to open and authenticate with XM Cloud. It will be there a...