How implement GET and PUT API for updating two tables data

Question

Hello, I have two tables - Student Table and Student address table and this tables having relation one to one and I want to write an Get and Put API for those two tables for fetching and updating data using Asp.Net Core using single ViewModels. Student Table Columns- StudentId, Name, MobileNo Student Address Table Columns- StudentId, Address, City. Source Code- using System; using System.Threading.Tasks; using Bds.Api.AutoMapper; using Bds.Api.Models.Public; using Bds.Data.Models; using Bds.Service.Helpers; using Bds.Service.Interfaces; using Microsoft.AspNetCore.Authorization; using Microsoft.AspNetCore.Mvc; namespace Bds.Api.Controllers.Public.V1 { [Route( "api/v1/[controller]" )] [Authorize] public class CoverController : Controller { private readonly IStudentService _studentService; private readonly IStudentAddressService _studentaadressService; public CoverController(IStudentService studentService, IStudentAddressService studentaadressService) { _studentService= studentService; _studentaadressService= studentaadressService; } [HttpGet( "{id}" )] public async Task Get( int id) { try { var studModel = await _studentService.GetSingleByConditionAsync(u => u.StudentId== id); if (studModel == null ) return BadRequest(ResponseMessages.GetErrorMessage(ResponseMessages.MessageType.NotFound)); return Ok(studModel.ToSingle ()); var studAddressModel = await _studentaadressService.GetSingleByConditionAsync(u => u.StudentId== id); if (studAddressModel == null ) return BadRequest(ResponseMessages.GetErrorMessage(ResponseMessages.MessageType.NotFound)); return Ok(studAddressModel.ToSingle ()); } catch (Exception ex) { return StatusCode(500, ResponseMessages.GetErrorMessage(ResponseMessages.MessageType.Fetch, ex.Message)); } } [HttpPut( "{id}" )] public async Task Put( int id, [FromBody]StudentModel studmodel, [FromBody]StudentAddressModel studaddmodel) { try { if (id == 0 || studmodel== null || studaddmodel== null ) return BadRequest(ResponseMessages.GetErrorMessage(ResponseMessages.MessageType.InValid)); var response = await _studentService.UpdateAsync(model.ToSingle ()); var response = await _studentaadressService.UpdateAsync(model.ToSingle ()); return response > 0 ? Ok(ResponseMessages.GetSuccessMessage(ResponseMessages.MessageType.Edit)) : StatusCode(500, ResponseMessages.GetErrorMessage(ResponseMessages.MessageType.Edit)); } catch (Exception ex) { return StatusCode(500, ResponseMessages.GetErrorMessage(ResponseMessages.MessageType.Edit, ex.Message)); } } } }

Adhikar Patil · Answer

Hello It is giving me error like Cannot implicitly convert type Data.Models.Model' to 'Api.Models.ViewModel' in asp.net core

Bhuban Magar · Answer

Hi, public class StudentModel { public int StudentId { get; set; } public string Name { get; set; } public int MobileNo { get; set; } } public class StudentAddressModel { public int StudentId { get; set; } public string Address { get; set; } public string City { get; set; } } public class StudentViewModel { public StudentModel StudentVM { get; set; } public StudentAddressModel StudentAddressVM { get; set; } } In controller. [HttpGet("{id}")] public async Task Get(int id) { try { StudentViewModel viewModel = new StudentViewModel(); viewModel.StudentVM = await _studentService.GetSingleByConditionAsync(u => u.StudentId == id); viewModel.StudentAddressVM = await _studentaadressService.GetSingleByConditionAsync(u => u.StudentId == id); if (viewModel.StudentVM == null || viewModel.StudentAddressVM==null) return BadRequest(ResponseMessages.GetErrorMessage(ResponseMessages.MessageType.NotFound)); return Ok(viewModel); } catch (Exception ex) { return StatusCode(500, ResponseMessages.GetErrorMessage(ResponseMessages.MessageType.Fetch, ex.Message)); } } Hope this will help you.