public bool AddCurrency(Models.Currency currency) { using (BVPEntities context = new BVPEntities()) { context.Currencies.AddObject(CreateEntityInstance(currency)); return context.SaveChanges() > 0; } }
public bool AddPaymentToDatabase(Models.Payment pay) { using (BVPEntities context = new BVPEntities()) { context.Payments.AddObject(CreatePaymentEntityInstance(pay)); return context.SaveChanges() > 0; } }
public bool DeleteCard(int id) { using (BVPEntities context = new BVPEntities()) { Card card = context.Cards.SingleOrDefault(c => c.Id == id); context.Cards.DeleteObject(card); return context.SaveChanges() > 0; } }
public bool UpdateClientKeyword(Models.Client client) { using (BVPEntities context = new BVPEntities()) { Client clnt = context.Clients.SingleOrDefault(c => c.Id == client.Id); clnt.Keyword = client.Keyword; return context.SaveChanges() > 0; } }
public bool AddMoneyToAccount(Models.Payment pay) { using (BVPEntities context = new BVPEntities()) { Card crd = context.Cards.SingleOrDefault(c => c.Id == pay.ToAccount.Id); crd.Balance += Convert.ToDouble(ConverToCardCurrency(pay.FromAccount, pay.ToAccount, pay.TotalAmount)); return context.SaveChanges() > 0; } }
public bool DeleteCurrency(Models.Currency currency) { if (currency == null) throw new ArgumentNullException("currency", "CurrencyDAL.DeleteCurrency"); using (BVPEntities context = new BVPEntities()) { context.Currencies.DeleteObject(context.Currencies.SingleOrDefault(c => c.Id == currency.Id)); return context.SaveChanges() > 0; } }
public bool DeleteUserGroupByName(string name) { bool result = false; using (BVPEntities context = new BVPEntities()) { context.UserGroups.DeleteObject(context.UserGroups.SingleOrDefault(ug => ug.GroupName == name)); result = context.SaveChanges() > 0; } return result; }
public bool DeleteUserGroupById(int id) { bool result = false; using (BVPEntities context = new BVPEntities()) { context.UserGroups.DeleteObject(context.UserGroups.SingleOrDefault(ug => ug.Id == id)); result = context.SaveChanges() > 0; } return result; }
public bool DeleteAllCardsByUserId(int userId) { bool result = false; using (BVPEntities context = new BVPEntities()) { IQueryable<Card> cards = context.Cards.Where(c => c.Client.Id == userId); foreach (Card card in cards) { context.Cards.DeleteObject(context.Cards.SingleOrDefault(c => c.Id == card.Id)); } result = context.SaveChanges() > 0; } return result; }
public bool AddUserGroup(Models.UserGroup newGroup) { bool result = false; if (newGroup != null) { using (BVPEntities context = new BVPEntities()) { context.UserGroups.AddObject(new UserGroup { GroupName = newGroup.GroupName }); result = context.SaveChanges() > 0; } } return result; }
public bool AddCard(int clientId, Models.Card newCard) { if (newCard == null) throw new ArgumentNullException("newCard", "CardDAL.AddCard"); using (BVPEntities context = new BVPEntities()) { Card card = new Card() { currencyId = newCard.Currency.Id, cardTypeId = newCard.CardType.Id, ZipCode = newCard.ZipCode, Balance = Convert.ToDouble(newCard.Balance), CardNumber = newCard.CardNumber, ExpirationDate = newCard.ExpirationDate, accountTypeId = newCard.AccountType.Id, Description = newCard.Description }; context.Clients.SingleOrDefault(c => c.Id == clientId).Cards.Add(card); return context.SaveChanges() > 0; } }
public bool PerformTransaction(Models.Payment payment) { decimal from = GetValueForCard(payment.FromAccount, payment.Currency, payment.TotalAmount); decimal to = GetValueForCard(payment.ToAccount, payment.Currency, payment.TotalAmount); if (!CardContainsEnoughMoney(payment.FromAccount, from)) return false; using (BVPEntities context = new BVPEntities()) { Card sCrd = context.Cards.SingleOrDefault(c => c.Id == payment.FromAccount.Id); sCrd.Balance -= Convert.ToDouble(from); Card tCrd = context.Cards.SingleOrDefault(c => c.Id == payment.ToAccount.Id); tCrd.Balance += Convert.ToDouble(to); context.Payments.AddObject(this.CreatePaymentEntityInstance(payment)); return (context.SaveChanges() > 0); } }
public bool UpdateCard(Models.Card newCardData) { using (BVPEntities context = new BVPEntities()) { Card card2update = context.Cards.First(c => c.Id == newCardData.Id); card2update.CardNumber = newCardData.CardNumber; card2update.ZipCode = newCardData.ZipCode; card2update.Balance = Convert.ToDouble(newCardData.Balance); card2update.ExpirationDate = newCardData.ExpirationDate; card2update.currencyId = newCardData.Currency.Id; card2update.cardTypeId = newCardData.CardType.Id; card2update.accountTypeId = newCardData.AccountType.Id; card2update.Description = newCardData.Description; return context.SaveChanges() > 0; } }
public bool UpdateCurrencyRateByIsoNumber(string IsoNumber, double rate) { using (BVPEntities context = new BVPEntities()) { Currency curr = context.Currencies.SingleOrDefault(c => c.IsoNumber.Equals(IsoNumber)); if (curr != null) { curr.Rate = rate; return context.SaveChanges() > 0; } } return false; }
public bool UpdateCurrencyRate(Models.Currency currency) { using (BVPEntities context = new BVPEntities()) { Currency curr = context.Currencies.SingleOrDefault(c => c.Id == currency.Id); curr.Rate = Convert.ToDouble(currency.Rate); return context.SaveChanges() > 0; } }
public bool UpdateCurrency(Models.Currency currency) { using (BVPEntities context = new BVPEntities()) { Currency curr = context.Currencies.SingleOrDefault(c => c.Id == currency.Id); curr.Abbreveature = currency.Abbreveature; curr.IsoName = currency.IsoName; curr.IsoNumber = currency.IsoNumber; curr.Rate = Convert.ToDouble(currency.Rate); curr.Sign = currency.Sign; return context.SaveChanges() > 0; } }
public bool RemoveMoneyFromAccount(Models.Payment pay) { if (!CardContainsEnoughMoney(pay.FromAccount, pay.TotalAmount)) return false; using (BVPEntities context = new BVPEntities()) { Card crd = context.Cards.SingleOrDefault(c => c.Id == pay.FromAccount.Id); crd.Balance -= Convert.ToDouble(pay.TotalAmount); return context.SaveChanges() > 0; } }