public Customer getById(int id)
{
Customer customer = new Customer();
using (DataClassesOurCompanyDataContext db = new DataClassesOurCompanyDataContext())
{
customer = (from c in db.Customers where c.id == id select c).First();
}
return customer;
}
public void deleteCustomer(int id)
{
using (DataClassesOurCompanyDataContext db = new DataClassesOurCompanyDataContext())
{
Customer customer = (from c in db.Customers where c.id == id select c).First();
db.Customers.DeleteOnSubmit(customer);
db.SubmitChanges();
}
}
public List<Customer> getAll()
{
List<Customer> customerList = new List<Customer>();
using (DataClassesOurCompanyDataContext db = new DataClassesOurCompanyDataContext())
{
customerList = (from c in db.Customers select c).ToList();
}
return customerList;
}
public void editCustomer(Customer c)
{
using (DataClassesOurCompanyDataContext db = new DataClassesOurCompanyDataContext())
{
var q = (from cust in db.Customers where cust.id == c.id select cust).First();
q.Name = c.Name;
q.Address = c.Address;
q.TelephoneNo = c.TelephoneNo;
q.EmailAddress = c.EmailAddress;
db.SubmitChanges();
}
}
public void create(Customer c)
{
try
{
using (DataClassesOurCompanyDataContext db = new DataClassesOurCompanyDataContext())
{
Customer cust = new Customer();
cust.Name = c.Name;
cust.Address = c.Address;
cust.TelephoneNo = c.TelephoneNo;
cust.EmailAddress = c.EmailAddress;
db.Customers.InsertOnSubmit(cust);
db.SubmitChanges();
}
}
catch (Exception e)
{
throw e;
}
}
