public JsonResult GetCustomers(string sidx, string sort, int page, int rows)
{
MCustomerContext context = new MCustomerContext();
sort = (sort == null) ? "" : sort;
int pageIndex = Convert.ToInt32(page) - 1;
int pageSize = rows;
//var StudentList = context.MCustomers.Select(
// t => new
// {
// t.CustomerId,
// t.CustomerName
// });
var customer = context.MCustomers.ToList();
var order = context.MOrders.ToList();
var product = context.MProducts.ToList();
var viewModel = new CustomerViewModel
{
customers = new MCustomer(),
orders = order,
products = product
};
var innerJoinQuery =
from category in categories
join prod in products on category.ID equals prod.CategoryID
select new { ProductName = prod.Name, Category = category.Name }; //produces flat sequence
int totalRecords = StudentList.Count();
var totalPages = (int)Math.Ceiling((float)totalRecords / (float)rows);
if (sort.ToUpper() == "DESC")
{
StudentList = StudentList.OrderByDescending(t => t.CustomerName);
StudentList = StudentList.Skip(pageIndex * pageSize).Take(pageSize);
}
else
{
StudentList = StudentList.OrderBy(t => t.CustomerName);
StudentList = StudentList.Skip(pageIndex * pageSize).Take(pageSize);
}
var jsonData = new
{
total = totalPages,
page,
records = totalRecords,
rows = StudentList
};
return(Json(jsonData, JsonRequestBehavior.AllowGet));
}
public void SortStudentListByGrades()
{
List <Student> SortedStudentList = new List <Student>();
if (StudentList.Count() == 1)
{
SortedStudentList.Add(StudentList[0]);
}
if (StudentList.Count() == 2)
{
if (StudentList[0].ReturnStudentGrade() < StudentList[1].ReturnStudentGrade())
{
SortedStudentList.Add(StudentList[0]);
SortedStudentList.Add(StudentList[1]);
}
if (StudentList[0].ReturnStudentGrade() > StudentList[1].ReturnStudentGrade())
{
SortedStudentList.Add(StudentList[1]);
SortedStudentList.Add(StudentList[2]);
}
}
if (StudentList.Count() > 2)
{
if (StudentList[0].ReturnStudentGrade() < StudentList[1].ReturnStudentGrade())
{
SortedStudentList.Add(StudentList[0]);
SortedStudentList.Insert(1, StudentList[1]);
}
if (StudentList[0].ReturnStudentGrade() > StudentList[1].ReturnStudentGrade())
{
SortedStudentList.Add(StudentList[1]);
SortedStudentList.Insert(1, StudentList[2]);
}
RemoveStudent(StudentList[0].ReturnID());
RemoveStudent(StudentList[1].ReturnID());
foreach (Student student in StudentList)
{
if (student.ReturnStudentGrade() < SortedStudentList[0].ReturnStudentGrade())
{
SortedStudentList.Add(StudentList[0]);
}
for (int i = 0; i < SortedStudentList.Count() - 1; i++)
{
if (i < SortedStudentList.Count() - 2 && student.ReturnStudentGrade() > SortedStudentList[i].ReturnStudentGrade() && student.ReturnStudentGrade() < SortedStudentList[i + 1].ReturnStudentGrade())
{
SortedStudentList.Insert(i, student);
}
if (i == SortedStudentList.Count() - 1 && student.ReturnStudentGrade() > SortedStudentList[i].ReturnStudentGrade())
{
SortedStudentList.Add(student);
}
}
}
}
StudentList = SortedStudentList;
}
public void LoadTest()
{
StudentList students = new StudentList();
students.StudentListLoad();
int expected = 14;
int actual = students.Count();
Assert.AreEqual(expected, actual);
}
public decimal Median()
{
int middle = StudentList.Count() / 2;
SortStudentListByGrades();
if (StudentList.Count() % 2 == 1)
{
return(StudentList[middle].ReturnStudentGrade());
}
else
{
Console.WriteLine("There is an even number of students in this course, the median would be: ");
return((StudentList[middle].ReturnStudentGrade() + StudentList[middle + 1].ReturnStudentGrade()) / 2);
}
}
public double AverageGrade()
{
double averGradeSum = 0;
double studCount = StudentList.Count();
foreach (var item in StudentList)
{
if (item.AverageGrade == 0)
{
studCount--;
}
averGradeSum += item.AverageGrade;
}
return(averGradeSum / studCount);
}
public string StudentCounter()
{
return(StudentList.Count().ToString());
}