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

How to create properties and use it with Generic class

Here, I have created properties in GetDetails class and use to get large amount of data which comes from database . see below code i have added lots of data in dataset make loop to add all data in list by help of properties . This is best to have good programmer. Follow this type of technique to get data. List<Details > Details = new List<Details >();          if (Ds.Tables[0].Rows.Count > 0)         {             foreach (DataRow dtrow in Ds.Tables[0].Rows)             {                 Details user = new GetDetails();                 user.RowNumber = dtrow["RowNumber"].ToString();                 user.Date = dtrow["Date"].ToString();                 user.FromTime = dtrow["FromTim...

What is object in C#

Object  : - Object is a instance of class. We can create more than one object a class according to requirements. Suppose we have a class name employee then create obect name of class . In the previous section we have discuss Office Owner will access and use all the Cabinof the Office and its Items. Similarly, to access all Class Method and Variable we use Objects. Example  : Class Employee {  --------- ---------- } Employee emp = new Employee(); here emp is an object of employee Class.

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        ...

What is scope inheritance ?

 scope inheritance  Scope inheritance in AngularJS is in organize into hierarchy and it is use by views. In Hierarchy of scope $rootScope is a parent and $Scope is a child. $rootScope is a global variable it is a single in application and $Scope can be multiple in a application.variable created in $scope is use by the view based on that controller. See Example which can help you understand. Suppose we have two controller parent and child. <html> <head> <script src="lib/angular.js"></script> <script> var app = angular.module('ScopeChain', []); app.controller("parent", function ($scope) { $scope.Name = 'Shashi Keshar'; $scope.$parent.CompAddress = 'Delhi '; }); app.controller("childController", function ($scope, $controller) { $scope.compHead = 'Noida; }); </script> </head> <body ng-...

Homework 1.4 MongoDB for DBAs

MongoDB Homework 1.4 for DBAs. Ans is given.