public bool insertReg(registros registro) { bool flag = false; if (this.connect()) { try { using (SqlCommand cmd = new SqlCommand(SQLQ.InsertReg, this.xconn)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@folio", registro.folio).Direction = ParameterDirection.Input; cmd.ExecuteNonQuery(); flag = !flag; } } catch (Exception ex) { globals.show(globals.current_asp_page, ex.Message.ToString()); } finally { this.disconn(); } } return(flag); }
private void clickAdd() { if (txtfolio.Text != string.Empty) { if (this.db.existFolio(txtfolio.Text.Trim())) { registros rtmp = new registros(txtfolio.Text.Trim()); if (this.db.insertReg(rtmp)) { globals.show(this.Page, "Registro Guardado Satisfactoriamente..."); this.txtfolio.Text = string.Empty; globals.go(this.Page, "Default.aspx"); } else { globals.show(this.Page, "Problema al Guardar Registro, contacte al Adminsitrador del Sistema..."); } } else { globals.show(this.Page, "Folio Inexistente, Corrija..."); } this.txtfolio.Focus(); } else { globals.show(this.Page, "Ingrese Folio de Usuario."); this.txtfolio.Focus(); } }
/// <summary> /// Seleccionar Objetivo /// </summary> /// <param name="sender">Objeto seleccionado</param> /// <param name="e">Envio de objetivo</param> void OnItemSelected(Object sender, SelectedItemChangedEventArgs e) { BindingContext = e.SelectedItem as RestServiceRegistro; registros itm = (registros)e.SelectedItem; ID.Text = itm.id.ToString(); Console.WriteLine("Enviado" + itm.id); }
/// <summary> /// Metodo para seleccionar un usuario /// </summary> /// <param name="sender">The sender.</param> /// <param name="e">The <see cref="SelectedItemChangedEventArgs"/> instance containing the event data.</param> async void OnItemSelected(Object sender, SelectedItemChangedEventArgs e) { registros itm = (registros)e.SelectedItem; idObjetivo = itm.id.ToString(); await Navigation.PushAsync(new TodosObjetivos { BindingContext = e.SelectedItem as registros }); Console.WriteLine(itm.id); /*BindingContext = e.SelectedItem as registros; * registros itm = (registros)e.SelectedItem; * //ID.Text = itm.id.ToString(); * Console.WriteLine("Enviado" + itm.id);*/ }
/// <summary> /// Guardar Datos /// </summary> /// <param name="item">Objeto de Registros</param> /// <returns>Guarda un Registro</returns> public async Task SaveTodoItemAsync(registros item) { var uri = new Uri(string.Format("http://192.168.1.21/proyectobdSigma/objetivo", string.Empty)); try { var json = JsonConvert.SerializeObject(item); var content = new StringContent(json, Encoding.UTF8, "application/json"); HttpResponseMessage response = null; response = await _client.PutAsync(uri, content); if (response.IsSuccessStatusCode) { Debug.WriteLine(@"\tTodoItem successfully saved."); } } catch (Exception ex) { Debug.WriteLine(@"\tERROR {0}", ex.Message); } }
/// <summary> /// Borra Registro /// </summary> /// <param name="item">ID de registro</param> /// <returns>Task.</returns> public Task DeleteTaskAsync(registros item) { return(restService.DeleteTodoItemAsync(item.id)); }
/// <summary> /// Guarda Registro /// </summary> /// <param name="item">Objeto de registro</param> /// <returns>Task.</returns> public Task SaveTaskAsync(registros item) { return(restService.SaveTodoItemAsync(item)); }