public async Task <ResponseBase> InsertarDisponibilidadMunicipio(DisponibilidadDomicilio dm) { var response = new ResponseBase(); try { using (var connection = new SqlConnection(con.getConnection())) { using (var command = new SqlCommand("Catalogos.spInsertarDisponibilidadDomicilio", connection)) { command.CommandType = CommandType.StoredProcedure; command.Parameters.Clear(); command.Parameters.AddWithValue("@idDisponibilidad", 0); command.Parameters.AddWithValue("@idEmpresa", dm.idEmpresa); command.Parameters.AddWithValue("@idZona", dm.idZona); command.Parameters["@idDisponibilidad"].Direction = ParameterDirection.Output; connection.Open(); var result = await command.ExecuteNonQueryAsync(); if (result > 0) { response.success = true; response.id = Convert.ToInt32(command.Parameters["@idDisponibilidad"].Value); response.message = "datos insertados correctamente"; } } } } catch (Exception ex) { response.success = false; response.message = ex.Message; } return(response); }
public async Task <ActionResult> InsertarDisponibilidadD([FromBody] DisponibilidadDomicilio dm) { var response = new ResponseBase(); try { response = await this._disponibilidadD.InsertarDisponibilidadMunicipio(dm); } catch (Exception ex) { response.success = true; response.message = ex.Message; } return(Ok(response)); }