Create a Web Page using Razor without Entity Framework.

Suman Raj

Requirement:

1.Web Page using Razor without Entity Framework.
2.Page Containg grid with edit & Delete Button
3. Edit & Delete should be written in same view page

4. Update data using stored procedure

Can Anyone help me regarding this scenario Thanks.

1 Reply

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

Sachin Singh6y ago
Accepted answer
Paste the below code , it is self explainatory.
@model IEnumerable
Vehicle Details




Id


Name


ChasisNo


OwnerId


@foreach (var item in Model)
{



























@item.Id
@item.Name
@item.ChasisNo
@item.OwnerId

    "submit">Show
    "btn" type="submit" data-Id="@item.Id" onclick="Edit(this)"> Edit
    "btn" type="submit" data-Id="@item.Id" onclick="deletee(this)"> Delete
}
"Edit">
public class AutoModel
{
public int Id { get; set; }
public string Name { get; set; }
public int ChasisNo { get; set; }
public int OwnerId { get; set; }
}
//Index view
"~/Home/Create" method="post">
Id "text" name="Id" value=" " />
Name "text" name="Name" value=" " />
ChasisNo "text" name="ChasisNo" value=" " />
OwnerId "text" name="OwnerId" value=" " />
"submit" name="Save"> Save
//Partial page for edit
model Automobile.Models.AutoModel
"/Home/Update" method="post">
Id "text" name="Id" value="@Model.Id" />
Name "text" name="Name" value="@Model.Name " />
ChasisNo "text" name="ChasisNo" value="@Model.ChasisNo " />
OwnerId "text" name="OwnerId" value="@Model.OwnerId " />
"submit" name="Update"> Update
//store procedure
CREATE procedure [dbo].[SpgetVehicle]
@Id int=null ,
@Name varchar(50)=null ,
@ChasisNo int=null ,
@ownerId int =null ,
@Type varchar(50)
as begin
if(@Type='Select')
begin
select * from Vehicle
end
if(@Type='Insert')
begin
insert into Vehicle values (@Name,@ChasisNo,@ownerId)
end
if(@Type='Update')
begin
Update Vehicle set Name=@Name,ChasisNo=@ChasisNo,OwnerId=@ownerId where Id=@Id
end
if(@Type='Delete')
begin
delete from Vehicle where Id=@Id
end
end
GO

Create a Web Page using Razor without Entity Framework.

Vehicle Details