I've created a EntityFramework ASP.NET solution and i'm trying to create a XUnit test project to test my differents classes i've created. I've created a TestClass for my Activity Class : using LADS_Model; using LADS_WebUI.Controllers; using Microsoft.VisualStudio.TestTools.UnitTesting; using System.Collections.Generic; using…
Controller: [HttpGet] [Route("MIDKalorimetar/Delete/{Id}/{Id2}/{Id3}/{Id4}/{Id5}")] public async Task<IActionResult> Delete(DeleteKalorimetarVM modelVM) { var model = await _db.ParametriMjerila.Where(x => x.Id == modelVM.Id).Include(d => d.Id == modelVM.Id2).Include(x=>x.Id == modelVM.Id3).Include(x => x.Id == modelVM.Id4).Include(x => x.Id == modelVM.Id5).FirstOrDefaultAsync(); return PartialView("Delete", model); } [HttpPost] public async Task<IActionResult>…
How can I save rows created in the list view in my database? How can I access the values in the (list view)? How to save the values created in the view list to the database? <asp:ListView ID="ListView1" runat="server"> <ItemTemplate…
I want to create one to one relation between tables. My table is public class StudentModel { public int Id { get; set; } [Required] public string Name { get; set; } [Required] [DataType(DataType.Date)] [DisplayFormat(DataFormatString = "{0:yyyy-MM-dd}", ApplyFormatInEditMode = true)]…
I have two tables Users and Get_cal like below : Users id_user(pk) com 1004 700 1005 700 1006 700 1010 701 1011 701 1012 701 1013 701 1014 800 1015 800 1016 800 1017 800 Get_cal id_user(fk) status 1004 ABAN…
I'm doing a small project using Razor pages. It's about cars. So I've created two scaffolded items from two classes: Maker and Model. This is the Maker class public class Maker { public int Id { get; set; } public…
I'm using EF 6 in my project. All i want is to fetch some data from the database and sometimes join additional data. Here is my code: var queryable = dbContext.Manuals .AsNoTracking() .Where(x => x.Status == "ACTIVE"); if (showDisabledParents) {…
I am implementing an API and as part of it I have setup a custom .Net Middleware service extension UseRequestLoggingModdlewareExtension() that it run between the following: app.UseHttpsRedirection(); app.UseRequestLoggingModdlewareExtension(); app.UseRouting(); The code is simple, and just logs the output of the…
I have a database table with columns of type dateTime. Now I need to see if there already is a row with today's date, but I don't know how to compare the column with the current date without the hour,…
I would like to insert data into TripApplicationUser table - to save that for example that Jake has enrolled for a trip to London. The table is in my SQL Server in Visual Studio. It has 2 columns: TripId and…