public string GetUserDataForDataTable(string user, string iDisplayLength, string iDisplayStart, string iSortCol_0, string sSortDir_0, string sSearch) { string strUser = string.Empty; Domain.Socioboard.Domain.User _User = (Domain.Socioboard.Domain.User) new JavaScriptSerializer().Deserialize(user, typeof(Domain.Socioboard.Domain.User)); if (_User.UserType == "SuperAdmin") { int dispalyLength = Int32.Parse(iDisplayLength); int displayStart = Int32.Parse(iDisplayStart); int sortCol = Int32.Parse(iSortCol_0); string sortDir = sSortDir_0; string search = sSearch; Domain.Socioboard.Helper.UserDetails _UserDetails = new Domain.Socioboard.Helper.UserDetails(); _UserDetails = objUserRepo.GetUserDataForDataTable(dispalyLength, displayStart, sortCol, sortDir, search); strUser = new JavaScriptSerializer().Serialize(_UserDetails); } else { Domain.Socioboard.Helper.UserDetails _UserDetails = new Domain.Socioboard.Helper.UserDetails(); strUser = new JavaScriptSerializer().Serialize(_UserDetails); } return(strUser); }
public Domain.Socioboard.Helper.UserDetails GetUserDataForDataTable(int iDisplayLength, int iDisplayStart, int iSortCol_0, string sSortDir_0, string sSearch) { if (iSortCol_0 < 2) { iSortCol_0 = 2; } int count = 0; Domain.Socioboard.Helper.UserDetails _UserDetails = new Domain.Socioboard.Helper.UserDetails(); List<Domain.Socioboard.Domain.User> lstUser = new List<User>(); var sortColumnIndex = iSortCol_0; Func<User, dynamic> orderingFunction = (c => sortColumnIndex == 2 ? c.UserName : sortColumnIndex == 3 ? c.AccountType : sortColumnIndex == 4 ? c.CreateDate.ToString() : sortColumnIndex == 5 ? c.EmailId : c.ActivationStatus ); var sortDirection = sSortDir_0; // asc or desc using (NHibernate.ISession session = SessionFactory.GetNewSession()) { if (!string.IsNullOrEmpty(sSearch)) { if (sortDirection == "asc") { lstUser = session.Query<Domain.Socioboard.Domain.User>().Where(u => u.UserName.Contains(sSearch) || u.AccountType.Contains(sSearch) || u.CreateDate.ToString().Contains(sSearch) || u.EmailId.Contains(sSearch) || u.ActivationStatus.Contains(sSearch)).OrderBy(orderingFunction).ToList(); } else { lstUser = session.Query<Domain.Socioboard.Domain.User>().Where(u => u.UserName.Contains(sSearch) || u.AccountType.Contains(sSearch) || u.CreateDate.ToString().Contains(sSearch) || u.EmailId.Contains(sSearch) || u.ActivationStatus.Contains(sSearch)).OrderByDescending(orderingFunction).ToList(); } } else { if (sortDirection == "asc") { lstUser = session.Query<Domain.Socioboard.Domain.User>().OrderBy(orderingFunction).ToList(); count = lstUser.Count; } else { lstUser = session.Query<Domain.Socioboard.Domain.User>().OrderByDescending(orderingFunction).ToList(); } } } _UserDetails.lstUser = lstUser.Skip(iDisplayStart).Take(iDisplayLength).ToList(); _UserDetails.resultCount = lstUser.Count; _UserDetails.totalCount = GetAllUserCount(); return _UserDetails; }
public string GetUserDataForDataTable(string user, string iDisplayLength, string iDisplayStart, string iSortCol_0, string sSortDir_0, string sSearch) { string strUser = string.Empty; Domain.Socioboard.Domain.User _User = (Domain.Socioboard.Domain.User)new JavaScriptSerializer().Deserialize(user, typeof(Domain.Socioboard.Domain.User)); if (_User.UserType == "SuperAdmin") { int dispalyLength = Int32.Parse(iDisplayLength); int displayStart = Int32.Parse(iDisplayStart); int sortCol = Int32.Parse(iSortCol_0); string sortDir = sSortDir_0; string search = sSearch; Domain.Socioboard.Helper.UserDetails _UserDetails = new Domain.Socioboard.Helper.UserDetails(); _UserDetails = objUserRepo.GetUserDataForDataTable(dispalyLength, displayStart, sortCol, sortDir, search); strUser = new JavaScriptSerializer().Serialize(_UserDetails); } else { Domain.Socioboard.Helper.UserDetails _UserDetails = new Domain.Socioboard.Helper.UserDetails(); strUser = new JavaScriptSerializer().Serialize(_UserDetails); } return strUser; }