public ISubOption GetById(int id)
{
using (var context = new EPEntities())
{
sub_option subOption = context.sub_option.Find(id);
context.Entry(subOption).Reference(s => s.option).Load();
context.Entry(subOption).Reference(s => s.subscription).Load();
return(subOption);
}
}
public ISubscription GetById(int id)
{
using (var context = new EPEntities())
{
subscription subscription = context.subscription.Find(id);
context.Entry(subscription).Collection(c => c.history).Load();
context.Entry(subscription).Collection(c => c.sub_option).Load();
context.Entry(subscription).Reference(c => c.client).Load();
context.Entry(subscription).Reference(c => c.plan).Load();
return(subscription);
}
}
public List <ISubOption> GetAll()
{
using (var context = new EPEntities())
{
List <ISubOption> res = new List <ISubOption>();
foreach (sub_option subOption in context.sub_option.ToList())
{
context.Entry(subOption).Reference(s => s.option).Load();
context.Entry(subOption).Reference(s => s.subscription).Load();
res.Add(subOption);
}
return(res);
}
}
public List <ISubscription> GetAll()
{
using (var context = new EPEntities())
{
List <ISubscription> res = new List <ISubscription>();
foreach (subscription subscription in context.subscription.ToList())
{
context.Entry(subscription).Collection(c => c.history).Load();
context.Entry(subscription).Collection(c => c.sub_option).Load();
context.Entry(subscription).Reference(c => c.client).Load();
context.Entry(subscription).Reference(c => c.plan).Load();
res.Add(subscription);
}
return(res);
}
}
public void Update(IOption option)
{
using (var context = new EPEntities())
{
context.Entry(option).State = EntityState.Modified;
context.SaveChanges();
}
}
public void Delete(IClient client)
{
using (var context = new EPEntities())
{
context.Entry((client)client).State = EntityState.Deleted;
context.SaveChanges();
}
}
public void Delete(ISubOption subOption)
{
using (var context = new EPEntities())
{
context.Entry(subOption).State = EntityState.Deleted;
context.SaveChanges();
}
}
public void Delete(IHistory history)
{
using (var context = new EPEntities())
{
context.Entry(history).State = EntityState.Deleted;
context.SaveChanges();
}
}
public void Delete(IPlan plan)
{
using (var context = new EPEntities())
{
context.Entry(plan).State = EntityState.Deleted;
context.SaveChanges();
}
}
public IClient GetById(int id)
{
using (var context = new EPEntities())
{
client client = context.client.Find(id);
context.Entry(client).Collection(c => c.subscription).Load();
return(client);
}
}
public IHistory GetById(int id)
{
using (var context = new EPEntities())
{
history history = context.history.Find(id);
context.Entry(history).Reference(h => h.subscription);
return(history);
}
}
public void Delete(ISubscription subscription)
{
using (var context = new EPEntities())
{
//context.subscription.Remove((subscription)subscription);
context.Entry((subscription)subscription).State = EntityState.Deleted;
context.SaveChanges();
}
}
public IClient GetByPhoneNumber(string phone_number)
{
using (var context = new EPEntities())
{
client client = context.client.Where(c =>
c.subscription.Where(s => s.phone_number == phone_number).FirstOrDefault().client_id == c.client_id).First();
context.Entry(client).Collection(c => c.subscription).Load();
return(client);
}
}
public IPlan GetById(int id)
{
using (var context = new EPEntities())
{
plan plan = context.plan.Find(id);
context.Entry(plan).Collection(p => p.subscription).Load();
return(plan);
}
}
public List <IPlan> GetAll()
{
using (var context = new EPEntities())
{
List <IPlan> res = new List <IPlan>();
foreach (plan plan in context.plan.ToList())
{
context.Entry(plan).Collection(p => p.subscription).Load();
res.Add(plan);
}
return(res);
}
}
public List <IOption> GetAll()
{
using (var context = new EPEntities())
{
List <IOption> res = new List <IOption>();
foreach (option option in context.option.ToList())
{
context.Entry(option).Collection(o => o.sub_option).Load();
res.Add(option);
}
return(res);
}
}
public List <IClient> GetAll()
{
using (var context = new EPEntities())
{
List <IClient> res = new List <IClient>();
foreach (client client in context.client.ToList())
{
context.Entry(client).Collection(c => c.subscription).Load();
res.Add(client);
}
return(res);
}
}
public List <IHistory> GetAll()
{
using (var context = new EPEntities())
{
List <IHistory> res = new List <IHistory>();
foreach (history history in context.history.ToList())
{
context.Entry(history).Reference(h => h.subscription);
res.Add(history);
}
return(res);
}
}