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...
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.
This method is used create properties for different values.
This method is use to call web method.
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();
}
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
Post a Comment