public ViewResult Index()
{
ProductCustomerSellMaintenanceEntities db = new ProductCustomerSellMaintenanceEntities();
/* List<Customer> getCustomerList = db.Customers.Distinct().ToList();
* ViewBag.CustomerList = new SelectList(getCustomerList, "CustomerName", "CustomerName");*/
List <Customer> getCustomerList = new List <Customer>();
var getCustomer = db.Customers.GroupBy(m => m.CustomerName).Select(m => m.FirstOrDefault());
getCustomerList = getCustomer.ToList();
ViewBag.CustomerList = new SelectList(getCustomerList, "CustomerName", "CustomerName");
List <Product> getProductList = new List <Product>();
var getProduct = db.Products.GroupBy(m => m.ProductName).Select(m => m.FirstOrDefault());
getProductList = getProduct.ToList();
ViewBag.ProductList = new SelectList(getProductList, "ProductName", "ProductName");
/*List<Product> getProductList = db.Products.ToList();
* ViewBag.ProductList = new SelectList(getProductList, "ProductName", "ProductName");*/
/* SalesEntities Sale = new SalesEntities();
* ViewBag.Sale = Sale.Sells.ToList();*/
return(View());
}
public ActionResult create()
{
ProductCustomerSellMaintenanceEntities db = new ProductCustomerSellMaintenanceEntities();
List <Product> getProductList = db.Products.ToList();
return(View(getProductList));
}
