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 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 DropSubscriptionByName(Subscription subscription, SubscriptionType subscriptionType, Currency currency)
{
using (var context = new DataMapperContext())
{
var subType = context.SubscriptionTypes.Find(subscriptionType.SubscriptionTypeId);
var cur = context.Currencies.Find(currency.CurrencyId);
var sub = context.Subscriptions.Find(subscription.SubscriptionId);
context.Entry(subType).Collection("Subscriptions").Load();
context.Entry(cur).Collection("Subscriptions").Load();
subType.Subscriptions.Remove(sub);
cur.Subscriptions.Remove(sub);
context.Subscriptions.Attach(sub);
context.Subscriptions.Remove(sub);
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 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 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 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 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 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 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 void DropCurrencyRate(string currencyRateMonth, Currency currency)
{
CurrencyRate currencyRate = GetCurrencyRateByMonth(currencyRateMonth, currency);
if (currencyRate == null)
{
throw new EntityDoesNotExistException("Invalid Currency Rate.");
}
using (var context = new DataMapperContext())
{
var currencyVar = context.Currencies.Find(currency.CurrencyId);
var currencyRateVar = context.CurrencieRates.Find(currencyRate.CurrencyRateId);
context.Entry(currencyVar).Collection("CurrencyRates").Load();
currencyVar.CurrencyRates.Remove(currencyRateVar);
context.CurrencieRates.Attach(currencyRateVar);
context.CurrencieRates.Remove(currencyRateVar);
context.SaveChanges();
}
}
public void DropMinute(int id, MinuteType minuteType)
{
Minute minute = GetMinuteById(id, minuteType);
if (minute == null)
{
throw new EntityDoesNotExistException("Invalid ID.");
}
using (var context = new DataMapperContext())
{
var minType = context.MinuteTypes.Find(minuteType.MinuteTypeId);
var min = context.Minutes.Find(minute.MinuteId);
context.Entry(minType).Collection("Minutes").Load();
minType.Minutes.Remove(min);
context.Minutes.Attach(min);
context.Minutes.Remove(min);
context.SaveChanges();
}
}
public void DropMessage(int id, MessageType messageType)
{
Message message = GetMessageById(id, messageType);
if (message == null)
{
throw new EntityDoesNotExistException("Invalid ID.");
}
using (var context = new DataMapperContext())
{
var mesType = context.MessageTypes.Find(messageType.MessageTypeId);
var mes = context.Messages.Find(message.MessageId);
context.Entry(mesType).Collection("Messages").Load();
mesType.Messages.Remove(mes);
context.Messages.Attach(mes);
context.Messages.Remove(mes);
context.SaveChanges();
}
}
