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