How implement GET and PUT API for updating two tables data

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));
}
}
}
}

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.

2 Replies

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

Adhikar Patil7y ago
Hello
It is giving me error like Cannot implicitly convert type Data.Models.Model' to 'Api.Models.ViewModel' in asp.net core
0
Bhuban Magar7y ago
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.
0