public IOption GetById(int id) { using (var context = new EPEntities()) { return(context.option.Find(id)); } }
public ISubscription Create( int plan_id, int client_id, string phone_number, DateTime start_date, DateTime?end_date ) { using (var context = new EPEntities()) { subscription s = new subscription() { plan_id = plan_id, client_id = client_id, phone_number = phone_number, start_date = start_date, }; if (end_date != null) { s.end_date = (DateTime)end_date; } context.subscription.Add(s); context.SaveChanges(); if (s.subscription_id > 0) { return(s); } return(null); } }
public void Update(IOption option) { using (var context = new EPEntities()) { context.Entry(option).State = EntityState.Modified; context.SaveChanges(); } }
public void Delete(IHistory history) { using (var context = new EPEntities()) { context.Entry(history).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(IClient client) { using (var context = new EPEntities()) { context.Entry((client)client).State = EntityState.Deleted; context.SaveChanges(); } }
public void Delete(IPlan plan) { using (var context = new EPEntities()) { context.Entry(plan).State = EntityState.Deleted; context.SaveChanges(); } }
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 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 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 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 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 <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 <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 <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); } }
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 <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 IClient Create(string name, DateTime birthday) { using (var context = new EPEntities()) { client c = new client() { name = name, birthday = birthday }; context.client.Add(c); context.SaveChanges(); if (c.client_id > 0) { return(c); } return(null); } }
public ISMSHistory CreateSMS(int subscription_id, DateTime timestamp, string destination_number, string phone_code) { using (var context = new EPEntities()) { sms_history c = new sms_history() { subscription_id = subscription_id, timestamp = timestamp, destination_number = destination_number, phone_code = phone_code }; context.history.Add(c); context.SaveChanges(); if (c.history_id > 0) { return(c); } return(null); } }
public ISubOption Create(int subscription_id, int option_id, DateTime start_date, DateTime end_date) { using (var context = new EPEntities()) { sub_option c = new sub_option() { subscription_id = subscription_id, option_id = option_id, start_date = start_date, end_date = end_date }; context.sub_option.Add(c); context.SaveChanges(); if (c.sub_option_id > 0) { return(c); } return(null); } }
public ICallHistory CreateVoice(int subscription_id, DateTime timestamp, string destination_number, string phone_code, int duration) { using (var context = new EPEntities()) { call_history c = new call_history() { subscription_id = subscription_id, timestamp = timestamp, destination_number = destination_number, phone_code = phone_code, duration = duration }; context.history.Add(c); context.SaveChanges(); if (c.history_id > 0) { return(c); } return(null); } }
public IOption Create(string name, int minute_limit, int sms_limit, decimal price, bool is_available) { using (var context = new EPEntities()) { option c = new option() { name = name, minute_limit = minute_limit, sms_limit = sms_limit, price = price, is_available = is_available }; context.option.Add(c); context.SaveChanges(); if (c.option_id > 0) { return(c); } return(null); } }
public IPlan Create(string name, int minute_limit, int sms_limit, decimal price, decimal overage_minute_price, decimal overage_sms_price, bool is_available) { using (var context = new EPEntities()) { plan c = new plan() { name = name, minute_limit = minute_limit, sms_limit = sms_limit, price = price, overage_minute_price = overage_minute_price, overage_sms_price = overage_sms_price, is_available = is_available }; context.plan.Add(c); context.SaveChanges(); if (c.plan_id > 0) { return(c); } return(null); } }