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

What is layout service in sitecore and how to configure it

 What is layout service in sitecore and how to configure it The Layout Service in Sitecore is a RESTful API that provides access to the data and presentation details of a Sitecore website, allowing developers to build modern, headless applications that consume content from Sitecore. To configure the Layout Service, you need to perform the following steps: Install the Sitecore JavaScript Services (JSS) package on your Sitecore instance. Define a new route in the jss.config file to specify the endpoint for the Layout Service. Configure the security settings to specify the roles and users who are allowed to access the Layout Service. Test the Layout Service endpoint to ensure that it is configured correctly and returning data as expected. Note that these steps are just a high-level overview and the specific details of each step may vary depending on the version of Sitecore you are using and the specific requirements of your project.

HttpRequestProcessed pipeline implementation in sitecore with C# code

 HttpRequestProcessed pipeline implementation in sitecore with C# code Here is an example of how you can implement the HttpRequestProcessed pipeline in Sitecore using C# code: using System; using Sitecore.Pipelines.HttpRequest; namespace MySite.Pipelines {     public class MyHttpRequestProcessed : HttpRequestProcessor     {         public override void Process(HttpRequestArgs args)         {             // Perform custom processing logic here             Console.WriteLine("HttpRequestProcessed pipeline processed successfully");         }     } } This code defines a custom HttpRequestProcessed processor that will be executed as part of the HttpRequestProcessed pipeline. The Process method is called when the pipeline is executed, and you can perform any custom processing logic you need within this method. To activate this custom process...