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