public IActionResult AddAnimal(AddAnimalsReguest reguest)
{
bool IfSucces = _service.AddAnimal(reguest);
if (IfSucces)
{
return(Ok());
}
return(BadRequest(400));
}
public bool AddAnimal(AddAnimalsReguest reguest)
{
bool ifCorrect = false;
using (SqlConnection con = new SqlConnection(ConString))
using (SqlCommand com = new SqlCommand())
{
com.Connection = con;
con.Open();
SqlTransaction tran = con.BeginTransaction();
com.Transaction = tran;
try
{
com.CommandText = "INSERT INTO Animal VALUES(@Name, @AnimalType, @DateOfAdmission, @IdOwner)";
com.Parameters.AddWithValue("Name", reguest.Name);
com.Parameters.AddWithValue("AnimalType", reguest.AnimalType);
com.Parameters.AddWithValue("DateOfAdmission", reguest.DateOfAdmission);
com.Parameters.AddWithValue("IdOwner", reguest.IdOwner);
com.ExecuteNonQuery();
//Odkomentuj i nie będzie działać przez ten błąd co napisałem, według mnie to to jest wszystko ok
// if (reguest.ProcedureAnimals != null)
// {
// com.CommandText = "select IdAnimal from Animal where name = @Name";
// SqlDataReader dr = com.ExecuteReader();
// if (dr.Read())
// {
// int IdAnimal = (int) dr[0];
// dr.Close();
// com.Parameters.AddWithValue("IdAnimal", IdAnimal);
// for (int i = 0; i < reguest.ProcedureAnimals.Count; i++)
// {
// com.CommandText = "INSERT INTO \"Procedure_Animal\" VALUES(@IdPocedu, @IdAnimal, @Date)";
// com.Parameters.AddWithValue("IdPocedu", reguest.ProcedureAnimals[i].IdProcedu);
// com.Parameters.AddWithValue("Date", reguest.ProcedureAnimals[i].Date);
// com.ExecuteNonQuery();
// }
// }
// dr.Close();
// }
ifCorrect = true;
tran.Commit();
}
catch (SqlException ex)
{
tran.Rollback();
ifCorrect = false;
}
}
return(ifCorrect);
}