public List <tbl_salesman> GetAllSalesmen()
{
using (var db = new KnockAroundDBContext())
{
return(db.Salesman.ToList());
}
}
public tbl_salesman SalesDetails(int id)
{
using (var db = new KnockAroundDBContext())
{
return(db.Salesman.FirstOrDefault(x => x.SALESMAN_ID == id));
}
}
public tbl_orders OrderDetails(int id)
{
using (var db = new KnockAroundDBContext())
{
return(db.Orders.FirstOrDefault(x => x.ORD_NO == id));
}
}
public List <tbl_orders> GetAllOrders()
{
using (var db = new KnockAroundDBContext())
{
return(db.Orders.ToList());
}
}
public tbl_customer CustomerDetails(int id)
{
using (var db = new KnockAroundDBContext())
{
return(db.Customer.FirstOrDefault(x => x.CUSTOMER_ID == id));
}
}
public tbl_customer CreateNewCustomer(tbl_customer cust)
{
using (var db = new KnockAroundDBContext())
{
var newcust = db.Customer.Add(cust);
db.SaveChanges();
return(newcust);
}
}
public void EditTheCustomer(tbl_customer cust)
{
using (var db = new KnockAroundDBContext())
{
//var editcust = db.Customer.Add(cust);
db.Entry(cust).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
public List <tbl_customer> GetAllCustomers()
{
using (var db = new KnockAroundDBContext())
{
var x = db.Customer.ToList();
return(x);
}
}
