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