Beispiel #1
0
 public JsonResult PaginationResult(jsonstudent ss)
 {
     Result r = new Result();
     int perpage = ss.perpage;
     try
     {
         using (StudentsEntities se = new StudentsEntities())
         {
             var students = se.newstudents.Where(s => s.first_name.Contains(ss.first_name) && s.last_name.Contains(ss.last_name) && s.email.Contains(ss.email)
                 && s.rollnumber.Contains(ss.rollnumber)
                 ).ToList();
             foreach (var item in ss.range)
             {
                 students = students.Where(s => item.min <= (int)s[item.field] && (int)s[item.field] <= item.max).ToList();
             }
             foreach (var item in ss.selectables)
             {
                 if(item.value != null) students = students.Where(s => item.value.Any(x => x == s[item.key].ToString())).ToList();
             }
             r.status = 1;
             if ((ss.pageno - 1) * ss.perpage + ss.perpage > students.Count)
                 perpage = students.Count - (ss.pageno - 1) * ss.perpage;
             r.data = students.GetRange((ss.pageno - 1) * ss.perpage, perpage);
             if (ss.orderBy != null)
             {
                 if (ss.orderType.ToLower() == "asc") r.data = students.GetRange((ss.pageno - 1) * ss.perpage, perpage).OrderBy(s => s[ss.orderBy]);
                 else r.data = students.GetRange((ss.pageno - 1) * ss.perpage, perpage).OrderByDescending(s => s[ss.orderBy]);
             }
         }
     }
     catch(Exception e)
     {
         r.data = "";
         r.error = e.Message;
         r.status = 0;
     }
     return Json(r);
 }
Beispiel #2
0
        public JsonResult SearchResult(jsonstudent ss)
        {
            Result r = new Result();
            try
            {
                using (StudentsEntities se = new StudentsEntities())
                {
                    var students = se.newstudents.Where(s => s.first_name.Contains(ss.first_name) && s.last_name.Contains(ss.last_name) && s.email.Contains(ss.email)
                        && s.rollnumber.Contains(ss.rollnumber)
                        ).ToList();
                    if (ss.israngeChanged)
                    {
                        foreach (var item in ss.range)
                        {
                            students = students.Where(s => item.min <= (int)s[item.field] && (int)s[item.field] <= item.max).ToList();
                        }
                    }
                    if (ss.isselectionChanged)
                    {
                        foreach (var item in ss.selectables)
                        {
                            if (item.value != null) students = students.Where(s => item.value.Any(x => x == s[item.key].ToString())).ToList();
                        }
                    }
                    outputResult o = new outputResult();
                    o.count = students.Count();
                    if (!ss.isselectionChanged)
                    {
                        foreach (var item in ss.selectables)
                        {
                            var tempdata = students.GroupBy(s => s[item.key]).Select(g => new{
                                key = g.Key,
                                count = g.Count()
                            }
                            ).ToList().Distinct().ToList();
                            List<string[]> sampledata = new List<string[]>();
                            foreach (var temp in tempdata)
                            {
                                string[] tempArray = new string[2];
                                tempArray[0] = temp.key.ToString();
                                tempArray[1] = temp.count.ToString();
                                sampledata.Add(tempArray);
                            }
                            o.selectables.Add(item.key, sampledata);
                        }
                    }
                    foreach (var item in ss.range)
                    {
                        o.range.Add(new Range {
                            field = item.field,
                            min = (int)students.Min(s => s[item.field]),
                            max = (int)students.Max(s => s[item.field])
                        });
                    }
                    r.status = 1;
                    r.data = o;

                }
            }
            catch (Exception e)
            {
                r.data = "";
                r.error = e.Message;
                r.status = 0;
            }
            return Json(r);
        }