public static bool DeleteCard(string UnitId) { using (var context = new CardContext()) { using (DbContextTransaction transaction = context.Database.BeginTransaction()) { try { var cards = context.Cards.Where(c => c.UnitId == UnitId).ToList(); if (cards == null || cards.Count == 0) { throw new Exception("No card found with '" + UnitId + "' unitid"); } context.Cards.RemoveRange(cards); context.SaveChanges(); transaction.Commit(); return(true); } catch (Exception ex) { transaction.Rollback(); return(false); } } } }
public static IEnumerable <Card> GetCardsByPinCodeAsync(string pinCode) { using (var context = new CardContext()) { var selectedCards = context.Cards.Where(c => c.Pincode == pinCode); return(selectedCards.ToList()); } }
public static IEnumerable <Card> GetCards() { using (var context = new CardContext()) { using (DbContextTransaction transaction = context.Database.BeginTransaction()) { var selectedCards = context.Cards; return(selectedCards.ToList()); } } }
public static bool AddCard(Card c) { using (var context = new CardContext()) { using (DbContextTransaction transaction = context.Database.BeginTransaction()) { try { context.Cards.Add(c); context.SaveChanges(); transaction.Commit(); return(true); } catch (Exception ex) { transaction.Rollback(); return(false); } } } }