public bool CadastrarPet(ViewModelCadastroPet vm_cadastro_pet)
{
bool retorno = false;
try
{
this.connection.Open();
this.command.CommandText = string.Format(@"INSERT INTO pet
(id_pet_tipo,
id_cliente,
nome,
raca,
porte,
alergias,
observacao,
autorizacao,
ultima_alteracao,
responsavel)
VALUES
('{0}', '{1}', '{2}', '{3}', '{4}', '{5}', '{6}', '{7}', '{8}', '{9}')",
vm_cadastro_pet.cadastro_pet_id_pet_tipo,
vm_cadastro_pet.cadastro_pet_id_cliente,
vm_cadastro_pet.cadastro_pet_nome,
vm_cadastro_pet.cadastro_pet_raca,
vm_cadastro_pet.cadastro_pet_porte,
vm_cadastro_pet.cadastro_pet_alergias,
vm_cadastro_pet.cadastro_pet_observacao,
vm_cadastro_pet.cadastro_pet_autorizacao,
BASE_CORE.ConvertDateBrToMySql(vm_cadastro_pet.cadastro_pet_ultima_alteracao.ToString()),
vm_cadastro_pet.cadastro_pet_responsavel
);
int insert_retorno = command.ExecuteNonQuery();
if (insert_retorno > 0)
{
retorno = true;
}
this.connection.Close();
}
catch (Exception ex)
{
if (this.connection.State == System.Data.ConnectionState.Open)
{
this.connection.Close();
}
}
return(retorno);
}
public JsonResult <bool> Cadastrar(ViewModelCadastroPet vm_cadastro_pet)
{
PetBusiness pet_busines = new PetBusiness();
return(Json(pet_busines.CadastrarPet(vm_cadastro_pet)));
}