[Solved] Return data from the database instead of api [closed]

In Controller: Make sure you created and inherited DbContext in model and also added Dbset of your table to it. public ActionResult getFromDataBase() { // create object for your context of Database var studentContext = new studentContext(); // return tablename data you want to retrieve in view return View(studentContext.TableName.ToList()); } In View: First import model … Read more

[Solved] Linq query to group payment receipts for a person over a period

Based on the view you want to display, your models are incorrect and they need to be public class MemberPaymentVM { public string MemberName{ get; set; } public string TransactId { get; set; } [DisplayFormat(DataFormatString = “{0:d}”)] public DateTime PayDate { get; set; } public IEnumerable<CategoryAmountsVM> Payments { get; set; } [DisplayFormat(DataFormatString = “{0:C}”)] public … Read more

[Solved] multiple User.IsInRole on same page

If I understood your intent I would use for example (my understanding is that you want to render a list of actions with a | character between each action) : @Html.ActionLink(“Edit”, “Edit”, new { id = category.id }) | text is a Razor syntax to force switching back to the HTML context. solved multiple User.IsInRole … Read more

[Solved] Does not work java script for more than one element

firstly I found java script Part with id = “demo-select2-1” in theme’s scripts then I redefine same function with New Name and use new id in other DropDownListFor: @Html.DropDownListFor(model => model.MemberInstance.MemberType_Id, new SelectList(Model.MemberTypeList, “Id”, “Title”), new { @id = “demo-select2-1”, @class = “form-control” }) @Html.DropDownListFor(model => model.SurgeryInstance.SurgeryType_Id, new SelectList(Model.SurgeryTypeList, “Id”, “SurgeryTitle”), new { @id = … Read more

[Solved] ASP.NET MVC – Complex Queries [closed]

Introduction ASP.NET MVC is a powerful web development framework that allows developers to create dynamic, data-driven web applications. It is a great platform for creating complex queries that can be used to retrieve data from a database. In this article, we will discuss how to create complex queries in ASP.NET MVC and how to use … Read more