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