public static List <AllPage> GetRecord(string page_id)
{
List <AllPage> list_det = new List <AllPage>();
DataTable dt = getPageData(Convert.ToInt32(page_id));
for (Int32 i = 0; i < dt.Rows.Count; i++)
{
AllPage p = new AllPage();
p.Page_Name = Convert.ToString(dt.Rows[i]["Page_Name"]);
p.URl = Convert.ToString(dt.Rows[i]["URl"]);
p.Folder_Name = Convert.ToString(dt.Rows[i]["Folder_Name"]);
p.Icon_Name = Convert.ToString(dt.Rows[i]["Icon_Name"]);
list_det.Add(p);
}
return(list_det);
}
public void GetAll_Employees(int iDisplayLength, int iDisplayStart, int iSortCol_0, string sSortDir_0, string sSearch)
{
int displayLength = iDisplayLength;
int displayStart = iDisplayStart;
int sortCol = iSortCol_0;
string sortDir = sSortDir_0;
string search = sSearch;
string cs = ConfigurationManager.ConnectionStrings["DBMS"].ConnectionString;
List <AllPage> listEmployees = new List <AllPage>();
int filteredCount = 0;
using (SqlConnection con = new SqlConnection(cs))
{
SqlCommand cmd = new SqlCommand("get_Pages", con);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter paramDisplayLength = new SqlParameter()
{
ParameterName = "@DisplayLength",
Value = displayLength
};
cmd.Parameters.Add(paramDisplayLength);
SqlParameter paramDisplayStart = new SqlParameter()
{
ParameterName = "@DisplayStart",
Value = displayStart
};
cmd.Parameters.Add(paramDisplayStart);
SqlParameter paramSortCol = new SqlParameter()
{
ParameterName = "@SortCol",
Value = sortCol
};
cmd.Parameters.Add(paramSortCol);
SqlParameter paramSortDir = new SqlParameter()
{
ParameterName = "@SortDir",
Value = sortDir
};
cmd.Parameters.Add(paramSortDir);
SqlParameter paramSearchString = new SqlParameter()
{
ParameterName = "@Search",
Value = string.IsNullOrEmpty(search) ? null : search
};
cmd.Parameters.Add(paramSearchString);
con.Open();
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
AllPage emp = new AllPage();
emp.page_id = Convert.ToInt32(rdr["page_id"]);
filteredCount = Convert.ToInt32(rdr["TotalCount"]);
emp.Page_Name = rdr["Page_Name"].ToString();
emp.URl = Convert.ToString(rdr["URl"]);
emp.Folder_Name = rdr["Folder_Name"].ToString();
emp.Icon_Name = Convert.ToString(rdr["Icon_Name"]);
listEmployees.Add(emp);
}
}
var result = new
{
iTotalRecords = GetPageTotalCount(),
iTotalDisplayRecords = filteredCount,
aaData = listEmployees
};
JavaScriptSerializer js = new JavaScriptSerializer();
Context.Response.Write(js.Serialize(result));
}