ASP.Net MVC Razor Sum and Count functions?

Hi i want to count the total number of rows in my view . I will explain my issue clearly..

My output

1) i want to count the total no of rows in the view and want to display that count in the same view of right top corner

2) I have three Customer Type New customer, Potential Customer, Existing Customer. i want to count the each type and want to display it in right top corner of the view.

I gave as like this @Model.Sum(i => i.CustomerName) but it showing error and i donno where i have to declare this line and how to calculate the Types and show in the view. please any one give

suggestion or solution for my problem.

My View

@model IEnumerable

ViewBag.Title = "customerid";

}

CustomerType

Customer

@foreach (var i in Model)

{

@Model.Sum(i => i.CustomerName) (getting error in this line)

}

Customer Name	Customer Type
@i.CustomerName	@i.CustomerType
Customer Name

My View Model

public class CustomerTypeViewModel

{

public System.Guid CustomerID { get; set; }

public string CustomerName { get; set; }

public DateTime CreatedDate { get; set; }

public string SalesCount { get; set; }

public string CustomerType { get; set; }

}

My controller

public ActionResult customerid()

{

List n = (from c in db.Customers where c.IsDeleted == false select c).ToList();

var customertype = string.Empty;

List obj = new List();

for (var i = 0; i < n.Count; i++)

{

var objCustomerName = n[i].DisplayName;

var objCustomerID = n[i].CustomerID;

var objCusCreatedDate = n[i].CreatedDate;

var objNextDate = objCusCreatedDate.GetValueOrDefault().AddDays(120);

var salescount = (from sc in db.SalesOrders where sc.CustomerID == objCustomerID && sc.CreatedDate >= objCusCreatedDate && sc.CreatedDate <= objNextDate select sc.SalesOrderID).Count();

if (salescount <= 3 && salescount > 0)

{

customertype = "potential Customer";

}

else if (salescount >= 3)

{

customertype = "Existing Customer";

}

else

{

customertype = "New Customer";

}

obj.Add(new CustomerTypeViewModel()

{

CustomerName = objCustomerName,

CustomerType = customertype,

SalesCount = salescount.ToString()

});

}

return View(obj);

}

11 Replies

Know the answer? Post it — somebody with the same question will find it here.

Shuvojit Halder10y ago
Use

@Model.Count()

for showing Total row.
Sneha K10y ago
ok lets i have a try Saillesh pawar . if i got any issue means i will tell you
Saillesh Pawar10y ago
atleast look at your view code as well you can also resolve this error.
use
Sample_Customer.Models.CustomerTypeViewModel instead of
CustomerTypeViewModel
var count = list.Where(cust => cust.CustomerType == "Existing customer").ToList().Count;
Sneha K10y ago

See my error .
Saillesh Pawar10y ago
tell me the error
Sneha K10y ago
Saillesh pawar i gave as per you said but it showing error
Saillesh Pawar10y ago
View
Sneha K10y ago
where i have to declare this line in controller??
Saillesh Pawar10y ago
@Model.Where(cust => cust.CustomerType == "Existing customer").ToList().Count;
Sneha K10y ago
Saillesh pawar can you explain your answer in detail.
Saillesh Pawar10y ago
You can apply LINQ on the Model returned from the controller inside the view