public JsonResult GetEmailAccount(jQueryDataTableParamModel param) { try { var allRecords = new List <EmailAccount>(); allRecords = MS.GetAllEmailAccount(param); List <EmailAccount> filteredRecords = null; if (!string.IsNullOrWhiteSpace(param.sSearch)) { allRecords = allRecords.Where(t => t.Id.ToString().Contains(param.sSearch.ToLower()) || t.EmailId.ToLower().ToString().Contains(param.sSearch.ToLower()) || t.Password.ToLower().ToString().Contains(param.sSearch.ToLower()) || t.SMTPRelay.ToLower().ToString().Contains(param.sSearch.ToLower()) || t.Port.ToLower().ToString().Contains(param.sSearch.ToLower()) || t.EnableSSL.ToString().Contains(param.sSearch.ToLower())).OrderBy(t => t.EmailId).ToList(); filteredRecords = allRecords.Skip(param.iDisplayStart).Take(param.iDisplayLength).ToList(); } else { filteredRecords = allRecords .Skip(param.iDisplayStart) .Take(param.iDisplayLength).OrderBy(t => t.EmailId).ToList(); } int totalRecords = allRecords.Count(); var result = from c in filteredRecords select new[] { "", c.Id.ToString(), c.EmailId, c.Password, c.SMTPRelay, c.Port, c.EnableSSL.ToString(), "" }; return(Json(new { sEcho = param.sEcho, iTotalRecords = totalRecords, iTotalDisplayRecords = totalRecords, aaData = result }, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { CommonServices.ErrorLogging(ex); return(Json(new { sEcho = 1, iTotalRecords = 0, iTotalDisplayRecords = 0, aaData = new List <string[]> { } }, JsonRequestBehavior.AllowGet)); } }