public int InsertPerson(PersonTableType person)
{
try
{
SqlParameter pId = new SqlParameter();
pId.ParameterName = "@Id";
pId.SqlDbType = System.Data.SqlDbType.Int;
pId.Direction = System.Data.ParameterDirection.Output;
var proc = new spInsertPerson()
{
Id = 0,
PersonAddress = new List <PersonTableType>()
{
person
}
};
var res = context.Database.ExecuteStoredProcedure <spInsertPerson>(proc);
var resultId = proc.Id;
return(resultId);
}
catch (Exception ex)
{
throw ex;
}
}
public IActionResult Post(PersonTableType person)
{
try
{
var res = service.InsertPerson(person);
return(Ok(res));
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
