public IEnumerable<Models.UserGroup> GetAllGroups()
{
using (BVPEntities context = new BVPEntities())
{
return context.UserGroups.Select(ug => new Models.UserGroup { Id = ug.Id, GroupName = ug.GroupName });
}
}
public Models.UserGroup GetGroupById(int id)
{
using (BVPEntities context = new BVPEntities())
{
UserGroup userGroup = context.UserGroups.SingleOrDefault(ug => ug.Id == id);
return userGroup == null ? null : new Models.UserGroup { Id = userGroup.Id, GroupName = userGroup.GroupName };
}
}
public Models.Currency GetCurrencyByNumber(string number)
{
using (BVPEntities context = new BVPEntities())
{
Currency item = context.Currencies.SingleOrDefault(c => c.IsoNumber == number);
return this.CreateModelInstance(item);
}
}
public bool AddCurrency(Models.Currency currency)
{
using (BVPEntities context = new BVPEntities())
{
context.Currencies.AddObject(CreateEntityInstance(currency));
return context.SaveChanges() > 0;
}
}
public Models.Client GetClientById(int id)
{
using (BVPEntities context = new BVPEntities())
{
Client result = context.Clients.SingleOrDefault(c => c.Id == id);
return this.CreateModelInstance(result);
}
}
public Models.Currency GetCurrencyById(int id)
{
using (BVPEntities context = new BVPEntities())
{
Currency item = context.Currencies.SingleOrDefault(c => c.Id == id);
return this.CreateModelInstance(item);
}
}
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 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 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 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 CardContainsEnoughMoney(Models.Card card, decimal money)
{
using (BVPEntities context = new BVPEntities())
{
Card crd = context.Cards.SingleOrDefault(c => c.Id == card.Id);
if (Convert.ToDecimal(crd.Balance) >= money)
return true;
else return false;
}
}
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 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 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 List<Models.Client> GetAllClients()
{
List<Models.Client> result = new List<Models.Client>();
using (BVPEntities context = new BVPEntities())
{
IQueryable<Client> clients = context.Clients;
if (clients.Count() <= 0)
return result;
foreach (Client client in clients)
{
result.Add(this.CreateModelInstance(client));
}
}
return result;
}
public List<Models.Currency> GetAllCurrencies()
{
List<Models.Currency> result = new List<Models.Currency>();
using (BVPEntities context = new BVPEntities())
{
IQueryable<Currency> currencies = context.Currencies;
if (currencies.Count() <= 0)
return result;
foreach (Currency currency in currencies)
{
result.Add(this.CreateModelInstance(currency));
}
return result;
}
}
public List<Models.Card> GetAllCards()
{
List<Models.Card> result = new List<Models.Card>();
using (BVPEntities context = new BVPEntities())
{
IQueryable<Card> cards = context.Cards;
if (cards.Count() <= 0)
return result;
foreach (Card card in cards)
{
result.Add(CreateModelInstance(card));
}
}
return result;
}
public Models.Client GetClientByCardId(int id)
{
using (BVPEntities context = new BVPEntities())
{
Client client = context.Cards.SingleOrDefault(c => c.Id == id).Client;
return new Models.Client()
{
Id = client.Id,
FirstName = client.FirstName,
Keyword = client.Keyword,
Gender = client.Gender,
LastName = client.LastName,
DateOfBirth = Convert.ToDateTime(client.DateOfBirth),
MiddleName = client.MiddleName,
Email = client.Email,
PassportNumber = client.PassportNumber,
PhoneNumber = client.PhoneNumber.ToString()
};
}
}
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 List<Models.Payment> GetAutoPaymentsForClient(Models.Client client)
{
List<Models.Payment> result = new List<Models.Payment>();
using (BVPEntities context = new BVPEntities())
{
IQueryable<Card> cards = context.Cards.Where(c => c.clientId == client.Id);
foreach (Card card in cards)
{
//select payments of the client
IQueryable<Payment> payments = context.Payments.Where(p => p.fromAccountId == card.Id).Where(p => p.toAccountId != 2 && p.toAccountId != 2);
Hashtable hash = new Hashtable();
foreach (Payment payment in payments)
{
if (!hash.Contains(payment.toAccountId))
{
hash.Add(payment.toAccountId, payment);
result.Add(this.CreatePaymentModelInstance(payment));
}
}
}
}
return result;
}
public List<Models.Card> GetAllServiceCards()
{
List<Models.Card> result = new List<Models.Card>();
using (BVPEntities context = new BVPEntities())
{
IQueryable<Card> cards = context.Cards.Where(c => (c.AccountType.Id != 2 || c.AccountType.Id != 3) && !String.IsNullOrEmpty(c.Description));
if (cards.Count() <= 0)
return result;
foreach (Card card in cards)
{
result.Add(CreateModelInstance(card));
}
}
return result;
}
public int GetCurrencyIdByName(string isoName)
{
using (BVPEntities context = new BVPEntities())
{
Currency item = context.Currencies.SingleOrDefault(c => c.IsoName == isoName);
return item.Id;
}
}
public Models.CardType GetCardTypeById(int id)
{
using (BVPEntities context = new BVPEntities())
{
return this.CreatedModelInstance(context.CardTypes.SingleOrDefault(c => c.Id == id));
}
}
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 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 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 decimal GetCurrencyRate(int id)
{
///TODO: method implementation might be incorrect.
///review method
using (BVPEntities context = new BVPEntities())
{
Currency item = context.Currencies.SingleOrDefault(c => c.Id == id);
return Convert.ToDecimal(item.Rate);
}
}
internal UserGroup GetGroupOrDefault(Models.UserGroup group)
{
using (BVPEntities context = new BVPEntities())
{
UserGroup result = context.UserGroups.SingleOrDefault(g => g.GroupName == group.GroupName);
if (result == null)
{
return context.UserGroups.First();
}
return result;
}
}
