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 Delete(IPlan plan)
{
using (var context = new EPEntities())
{
context.Entry(plan).State = EntityState.Deleted;
context.SaveChanges();
}
}
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(ISubscription subscription)
{
using (var context = new EPEntities())
{
//context.subscription.Remove((subscription)subscription);
context.Entry((subscription)subscription).State = EntityState.Deleted;
context.SaveChanges();
}
}
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 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 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 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 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 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);
}
}