asp.net-mvc

What does the DBContext.Entry do?

by

[HttpPost] public ActionResult Edit(Movie movie) { if (ModelState.IsValid) { db.Entry(movie).State = EntityState.Modified; db.SaveChanges(); return RedirectToAction("Index"); } return View(movie); } This action receives a movie model and updates it in the database. But I can’t figure out how. The movie object isn’t attached to the db, so how does entity framework know which row in the … Read more

Checking login user role in razor page

by

@if (Request.IsAuthenticated && User.Identity.Name=="administrator") { <div id="sidebar"> <div class="module"> <ul class="menu"> <li>@Html.ActionLink("Home", "Index", "Home")</li> <li>@Html.ActionLink("About", "About", "Home")</li> <li>@Html.ActionLink("Contact", "Contact", "Home")</li> </ul> </div> <div class="mainContent"> Hello, @User.Identity.Name ! </div> </div> This is my layout if the user is authenticated as administrator but this sort of check looks no good, I need to check the role of … Read more

ASP.NET MVC EPPlus Download Excel File

by

So I’m using the fancy EPPlus library to write an Excel file and output it to the user to download. For the following method I’m just using some test data to minimize on the code, then I’ll add the code I’m using to connect to database later. Now I can download a file all fine, but when I go to open the file, Excel complains that it’s not a valid file and might be corrupted. When I go to look at the file, it says it’s 0KB big. So my question is, where am I going wrong? I’m assuming it’s with the MemoryStream. Haven’t done much work with streams before so I’m not exactly sure what to use here. Any help would be appreciated!