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