public void DeleteSubscriber(int _id)
{
using (db = new GoldenNumberDatabaseEntities())
{
db.Subscribers.Remove(db.Subscribers.FirstOrDefault(x => x.Id == _id));
db.SaveChanges();
}
}
public bool AddSubscriber(Subscriber _Subscriber)
{
using (db = new GoldenNumberDatabaseEntities())
{
db.Subscribers.Add(_Subscriber);
db.SaveChanges();
}
return(true);
}
public bool UpdateSubscriber(Subscriber _Subscriber)
{
using (db = new GoldenNumberDatabaseEntities())
{
db.Entry(_Subscriber).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
return(true);
}
public bool AddNumber(Number _NUmber)
{
using (db = new GoldenNumberDatabaseEntities())
{
db.Numbers.Add(_NUmber);
db.SaveChanges();
}
return(true);
}
public bool AddCustomer(Customer _Customer)
{
using (db = new GoldenNumberDatabaseEntities())
{
db.Customers.Add(_Customer);
db.SaveChanges();
}
return(true);
}
public Subscriber getSubscriberById(int _Id)
{
GoldenNumberDatabaseEntities db = new GoldenNumberDatabaseEntities();
Subscriber Subscribers = db.Subscribers.Where(x => x.IsActive == 1).FirstOrDefault(x => x.Id == _Id);
return(Subscribers);
}
public List <Subscriber> getSubscriberList()
{
List <Subscriber> Subscribers;
GoldenNumberDatabaseEntities db = new GoldenNumberDatabaseEntities();
Subscribers = db.Subscribers.Where(x => x.IsActive == 1).ToList();
return(Subscribers);
}
public Number getNumberById(int _Id)
{
GoldenNumberDatabaseEntities db = new GoldenNumberDatabaseEntities();
Number Numbers = db.Numbers.Where(x => x.IsActive == 1).FirstOrDefault(x => x.Id == _Id);
return(Numbers);
}
public List <Number> getNumbersList()
{
List <Number> Numbers;
GoldenNumberDatabaseEntities db = new GoldenNumberDatabaseEntities();
Numbers = db.Numbers.Where(x => x.IsActive == 1).ToList();
return(Numbers);
}
public List <Customer> getCustomersList()
{
List <Customer> Customers;
GoldenNumberDatabaseEntities db = new GoldenNumberDatabaseEntities();
Customers = db.Customers.Where(x => x.IsActive == 1).ToList();
return(Customers);
}
