private void ClearTalla()
{
AuxTalla = null;
AuxTalla = new bx_Talla();
// SelectedPersonaComboBox = null;
// SelectedPersonaComboBox = new b_Persona();
}
public void DeleteTalla(bx_Talla talla)
{
using (var conn = new SQLiteConnection(new SQLitePlatformWinRT(), path))
{
conn.RunInTransaction(() =>
{
var t = conn.Execute("DELETE FROM bx_Talla WHERE TallaId = ?", talla.TallaId);
});
}
}
//public List<TallaJoinPersona> GetTallaJoinPersona(int idPersona)
//{
// List<TallaJoinPersona> result;
// using (var conn = new SQLiteConnection(new SQLitePlatformWinRT(), path))
// {
// result = conn.Query<TallaJoinPersona>("SELECT * FROM bx_Talla where TallaId == idPersona");
// //result = conn.Query<TallaJoinPersona>("SELECT * FROM bx_Talla p INNER JOIN b_Persona c ON p.TallaPersonaId= c.PersonaId ");
// }
// return result;
//}
public void InsertOrUpdateTalla(bx_Talla talla)
{
using (var conn = new SQLiteConnection(new SQLitePlatformWinRT(), path))
{
if (talla.TallaId.Equals(0))
{
conn.RunInTransaction(() =>
{
conn.Execute("INSERT INTO bx_Talla (NombreTalla, Talla, TallaPersonaId) VALUES(?, ?)", talla.NombreTalla, talla.Talla, talla.TallaPersonaId);
});
}
/*
* [PrimaryKey, AutoIncrement]
* public int TallaId { get; set; }
*
* [MaxLength(50)]
* public int NombreTalla { get; set; }
*
* [MaxLength(4)]
* public int Talla { get; set; }
*
* [ForeignKey("b_PersonaBD")]
* public int TallaPersonaId { get; set; }
*
*
*/
else
{
conn.RunInTransaction(() =>
{
conn.Execute("UPDATE bx_Talla SET NombreTalla = ?, TallaPersonaId = ? WHERE TallaId = ?", talla.TallaId, talla.NombreTalla, talla.Talla, talla.TallaPersonaId);
});
}
}
}
