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