public void AddCustomer(Customer customer)
{
using (var context = new DataMapperContext())
{
context.Customers.Add(customer);
context.SaveChanges();
}
}
public void AddMinuteType(MinuteType minuteType)
{
using (var context = new DataMapperContext())
{
context.MinuteTypes.Add(minuteType);
context.SaveChanges();
}
}
public void AddMessageType(MessageType messageType)
{
using (var context = new DataMapperContext())
{
context.MessageTypes.Add(messageType);
context.SaveChanges();
}
}
public void AddSubscriptionType(SubscriptionType subscriptionType)
{
using (var context = new DataMapperContext())
{
context.SubscriptionTypes.Add(subscriptionType);
context.SaveChanges();
}
}
public void AddCurrency(Currency currency)
{
using (var context = new DataMapperContext())
{
context.Currencies.Add(currency);
context.SaveChanges();
}
}
public MinuteType GetMinuteTypeByName(string minuteTypeName)
{
using (var context = new DataMapperContext())
{
var minTypeVar = (from subMinute in context.MinuteTypes
where subMinute.MinuteTypeName.Equals(minuteTypeName)
select subMinute).FirstOrDefault();
return(minTypeVar);
}
}
public Contract GetContractByName(string contractName)
{
using (var context = new DataMapperContext())
{
var subVar = (from contract in context.Contracts
where contract.ContractName.Equals(contractName)
select contract).FirstOrDefault();
return(subVar);
}
}
public MessageType GetMessageTypeByName(string messageTypeName)
{
using (var context = new DataMapperContext())
{
var mesTypeVar = (from mesType in context.MessageTypes
where mesType.MessageTypeName.Equals(messageTypeName)
select mesType).FirstOrDefault();
return(mesTypeVar);
}
}
public void UpdateExtraCharge(Message message)
{
using (var context = new DataMapperContext())
{
context.Messages.Attach(message);
var entry = context.Entry(message);
entry.Property(m => m.ExtraCharge).IsModified = true;
context.SaveChanges();
}
}
public void UpdateSubscriptionEndDate(Subscription subscription)
{
using (var context = new DataMapperContext())
{
context.Subscriptions.Attach(subscription);
var entry = context.Entry(subscription);
entry.Property(u => u.EndDate).IsModified = true;
context.SaveChanges();
}
}
public void UpdateIncludedMinutes(Minute minute)
{
using (var context = new DataMapperContext())
{
context.Minutes.Attach(minute);
var entry = context.Entry(minute);
entry.Property(m => m.IncludedMinutes).IsModified = true;
context.SaveChanges();
}
}
public void UpdateContractPrice(Contract contract)
{
using (var context = new DataMapperContext())
{
context.Contracts.Attach(contract);
var entry = context.Entry(contract);
entry.Property(u => u.Price).IsModified = true;
context.SaveChanges();
}
}
public void UpdatePhone(Customer customer)
{
using (var context = new DataMapperContext())
{
context.Customers.Attach(customer);
var entry = context.Entry(customer);
entry.Property(u => u.Phone).IsModified = true;
context.SaveChanges();
}
}
public SubscriptionType GetSubscriptionTypeByName(string subscriptionTypeName)
{
using (var context = new DataMapperContext())
{
var subTypeVar = (from subType in context.SubscriptionTypes
where subType.SubscriptionTypeName.Equals(subscriptionTypeName)
select subType).FirstOrDefault();
return(subTypeVar);
}
}
public Customer GetCustomerByCNP(string cnp)
{
using (var context = new DataMapperContext())
{
var customerVar = (from customer in context.Customers
where customer.CNP.Equals(cnp)
select customer).FirstOrDefault();
return(customerVar);
}
}
public Subscription GetSubscriptionByName(string subName)
{
using (var context = new DataMapperContext())
{
var subVar = (from subscription in context.Subscriptions
where subscription.SubscriptionName.Equals(subName)
select subscription).FirstOrDefault();
return(subVar);
}
}
public Currency GetCurrencyByName(string currencyName)
{
using (var context = new DataMapperContext())
{
var currencyVar = (from currency in context.Currencies
where currency.CurrencyName.Equals(currencyName)
select currency).FirstOrDefault();
return(currencyVar);
}
}
public Minute GetMinuteById(int id, MinuteType minuteType)
{
using (var context = new DataMapperContext())
{
var customerVar = (from minute in context.Minutes
where minute.MinuteId == id &&
minute.MinuteType.MinuteTypeId == minuteType.MinuteTypeId
select minute).FirstOrDefault();
return(customerVar);
}
}
public void AddMinute(Minute minute, MinuteType minuteType)
{
using (var context = new DataMapperContext())
{
context.MinuteTypes.Attach(minuteType);
context.Minutes.Attach(minute);
context.Entry(minuteType).Collection(c => c.Minutes).Load();
context.Minutes.Add(minute);
context.SaveChanges();
}
}
public void AddCurrencyRate(CurrencyRate currencyRate, Currency currency)
{
using (var context = new DataMapperContext())
{
context.Currencies.Attach(currency);
context.CurrencieRates.Attach(currencyRate);
context.Entry(currency).Collection(c => c.CurrencyRates).Load();
context.CurrencieRates.Add(currencyRate);
context.SaveChanges();
}
}
public void AddMessage(Message message, MessageType messageType)
{
using (var context = new DataMapperContext())
{
context.MessageTypes.Attach(messageType);
context.Messages.Attach(message);
context.Entry(messageType).Collection(c => c.Messages).Load();
context.Messages.Add(message);
context.SaveChanges();
}
}
public Message GetMessageById(int id, MessageType messageType)
{
using (var context = new DataMapperContext())
{
var mesVar = (from message in context.Messages
where message.MessageId == id &&
message.MessageType.MessageTypeId == messageType.MessageTypeId
select message).FirstOrDefault();
return(mesVar);
}
}
public CurrencyRate GetCurrencyRateByMonth(string currencyRateMonth, Currency currency)
{
using (var context = new DataMapperContext())
{
var currencyRateVar = (from currencyRate in context.CurrencieRates
where currencyRate.Valability.Equals(currencyRateMonth) &&
currencyRate.Currency.CurrencyId == currency.CurrencyId
select currencyRate).FirstOrDefault();
return(currencyRateVar);
}
}
public void AddSubscription(Subscription subscription, SubscriptionType subType, Currency currency)
{
using (var context = new DataMapperContext())
{
context.SubscriptionTypes.Attach(subType);
context.Currencies.Attach(currency);
context.Subscriptions.Attach(subscription);
context.Entry(subType).Collection(c => c.Subscriptions).Load();
context.Entry(currency).Collection(c => c.Subscriptions).Load();
context.Subscriptions.Add(subscription);
context.SaveChanges();
}
}
public void AddContract(Contract contract, Customer customer, Subscription subscription)
{
using (var context = new DataMapperContext())
{
context.Subscriptions.Attach(subscription);
context.Customers.Attach(customer);
context.Contracts.Attach(contract);
context.Entry(subscription).Collection(c => c.Contracts).Load();
context.Entry(customer).Collection(c => c.Contracts).Load();
context.Contracts.Add(contract);
context.SaveChanges();
}
}
public void DropCustomerByCNP(string cnp)
{
Customer customer = GetCustomerByCNP(cnp);
if (customer == null)
{
throw new EntityDoesNotExistException("Invalid CNP.");
}
using (var context = new DataMapperContext())
{
context.Customers.Attach(customer);
context.Customers.Remove(customer);
context.SaveChanges();
}
}
public void DropMinuteType(string minuteTypeName)
{
MinuteType minuteType = GetMinuteTypeByName(minuteTypeName);
if (minuteType == null)
{
throw new EntityDoesNotExistException("Invalid Minute Type Name.");
}
using (var context = new DataMapperContext())
{
context.MinuteTypes.Attach(minuteType);
context.MinuteTypes.Remove(minuteType);
context.SaveChanges();
}
}
public void DropContractByName(Contract contract, Customer customer, Subscription subscription)
{
using (var context = new DataMapperContext())
{
var sub = context.Subscriptions.Find(subscription.SubscriptionId);
var cus = context.Customers.Find(customer.CustomerId);
var con = context.Contracts.Find(contract.ContractId);
context.Entry(sub).Collection("Contracts").Load();
context.Entry(cus).Collection("Contracts").Load();
sub.Contracts.Remove(con);
cus.Contracts.Remove(con);
context.Contracts.Attach(con);
context.Contracts.Remove(con);
context.SaveChanges();
}
}
public void DropCurrency(string currencyName)
{
Currency currency = GetCurrencyByName(currencyName);
if (currency == null)
{
throw new EntityDoesNotExistException("Invalid Currency Name.");
}
using (var context = new DataMapperContext())
{
context.Currencies.Attach(currency);
context.Currencies.Remove(currency);
context.SaveChanges();
}
}
public void DropSubscriptionType(string subscriptionTypeName)
{
SubscriptionType subType = GetSubscriptionTypeByName(subscriptionTypeName);
if (subType == null)
{
throw new EntityDoesNotExistException("Invalid Subscription Type Name.");
}
using (var context = new DataMapperContext())
{
context.SubscriptionTypes.Attach(subType);
context.SubscriptionTypes.Remove(subType);
context.SaveChanges();
}
}
