How to create View based on Controller Code in mvc4?

Hi i want to create one view based on Controller code . i want one idea or solution for my problem. I will explain my issue with example.

Controller code

public ActionResult customerid()

{

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

var customertype = string.Empty;

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 = "Exisiting Customer";

}

else if (salescount >= 3)

{

customertype = "Potential Customer";

}

else

{

customertype = "New Customer";

}

//var details = (from c in db.Customers where c.IsDeleted == false select c);

}

return View();

}

Wanted Output

I want to create a view same as like which is mentioned in the above image. First i want to list all the Customer Name (which is from Customer table)

Customer Table

CustomerID uniqueidentifier primarykey not null,

DisplayName varchar(100) null

then i want to create one column manually in view Customer Type. The value for Customer Type have to get it from Controller(customertype = "Potential Customer";)

Customer Name	Customer Type
TBS Sizing Mill	Existing Customer
Kallam Spinning Mill	Potential Customer
Suryaprabha Sizing	New Customer
Skyweaves	Existing Customer

How i do this this is my task. please i did the controller part . please any one help me to do this task..

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

}

In controller's action, you need to return your view with model that you want to design on View. I will show you an example .

1. First, In your action you return model along with View. Like in below example, Test() action.

2. This is my model that is being returned in action.

3. And at last, You need to create a view for this action. Right click on action name and select Add View. It will open a dialog box.

Follow these steps now...

a) View Name should be exact as your action name. In this example it is Test.

b) Select Create a strongly-typed view. and select your model class. In this example it is TestModel (MvcApplication1.Models).

c) Select "List" in Scaffold Template. It will create a view of List type.
d) Click Add and its done. Now you run your application, go to that action and you will find same view as you are looking.

It's done. So you follow these steps and try to make a sample as you are looking, and then later you start customizing as per your model and tables.

1 Reply

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

Vishwakant Tripathi10y ago
In controller's action, you need to return your view with model that you want to design on View. I will show you an example .
1. First, In your action you return model along with View. Like in below example, Test() action.

2. This is my model that is being returned in action.

3. And at last, You need to create a view for this action. Right click on action name and select Add View. It will open a dialog box.

Follow these steps now...
a) View Name should be exact as your action name. In this example it is Test.
b) Select Create a strongly-typed view. and select your model class. In this example it is TestModel (MvcApplication1.Models).
c) Select "List" in Scaffold Template. It will create a view of List type.
d) Click Add and its done. Now you run your application, go to that action and you will find same view as you are looking.

It's done. So you follow these steps and try to make a sample as you are looking, and then later you start customizing as per your model and tables.