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