public void DodajZwierze(AnimalsRequest request)
{
using (var client = new SqlConnection("Data Source = db-mssql; Initial Catalog = s18445; Integrated Security = True"))
using (var com = new SqlCommand())
{
com.Connection = client;
client.Open();
com.CommandText = "Insert into Animal (Name, Type, AdmissionDate, IdOwner) " +
"Values (@Name, @Type, @AdmissionDate, @IdOwner)";
//com.Parameters.AddWithValue("IdAnimal", request.IdAnimal);
com.Parameters.AddWithValue("Name", request.Name);
com.Parameters.AddWithValue("Type", request.Type);
com.Parameters.AddWithValue("AdmissionDate", request.AdmissionDate);
com.Parameters.AddWithValue("IdOwner", request.IdOwner);
var dr = com.ExecuteReader();
com.CommandText = "Insert into Procedure ( Name, Description)" +
"Values ( @NameProcedure, @Description)";
//com.Parameters.AddWithValue("IdProcedure", request.IdProcedure);
//com.Parameters.AddWithValue("NameProcedure", request.NameProcedure);
//com.Parameters.AddWithValue("Description", request.Description);
//var fr = com.ExecuteReader();
}
}
public IActionResult InsertAnimal(AnimalsRequest request)
{
if (request.AdmissionDate == null ||
request.Description == null ||
//request.IdAnimal == null ||
//request.IdOwner == null ||
//request.IdProcedure == null ||
request.Name == null ||
request.NameProcedure == null ||
request.Type == null)
{
return(BadRequest("Nie podano wszystkich danych!"));
}
service.DodajZwierze(request);
return(Ok("Zwierze dodano!"));
}
