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)); }