public ActionResult _SaveBatchEditing([Bind(Prefix = "inserted")] IEnumerable <EditableOrder> insertedOrders,
[Bind(Prefix = "updated")] IEnumerable <EditableOrder> updatedOrders,
[Bind(Prefix = "deleted")] IEnumerable <EditableOrder> deletedOrders)
{
var nw = new NWDataContext();
if (insertedOrders != null)
{
foreach (var order in insertedOrders)
{
nw.Orders.InsertOnSubmit(new Order {
OrderID = order.OrderID,
OrderDate = order.OrderDate,
Employee = nw.Employees.Where(e => e.EmployeeID == order.Employee.EmployeeID).SingleOrDefault(),
Freight = order.Freight
});
nw.SubmitChanges();
}
}
if (updatedOrders != null)
{
foreach (var order in updatedOrders)
{
var target = nw.Orders.Where(o => o.OrderID == order.OrderID).SingleOrDefault();
if (target != null)
{
target.OrderDate = order.OrderDate;
target.Employee = nw.Employees.Where(e => e.EmployeeID == order.Employee.EmployeeID).SingleOrDefault();
target.Freight = order.Freight;
}
}
nw.SubmitChanges();
}
if (deletedOrders != null)
{
foreach (var order in deletedOrders)
{
nw.Orders.DeleteOnSubmit(nw.Orders.Where(o => o.OrderID == order.OrderID).SingleOrDefault());
nw.SubmitChanges();
}
}
List <EditableOrder> list = nw.Orders
.Select(o => new EditableOrder
{
OrderID = o.OrderID,
OrderDate = o.OrderDate ?? DateTime.Now,
Employee = new EditableEmployee {
EmployeeID = o.Employee.EmployeeID, FirstName = o.Employee.FirstName, LastName = o.Employee.LastName
},
Freight = o.Freight ?? 0
})
.ToList();
return(View(new GridModel(list)));
}
public ActionResult _SelectEmployees()
{
var employees = new NWDataContext().Employees
.Select(e => new { Id = e.EmployeeID, Name = e.FirstName + " " + e.LastName })
.OrderBy(e => e.Name);
return(new JsonResult {
Data = new SelectList(employees.ToList(), "Id", "Name")
});
}
public JsonResult _GetProducts(int?categoryId)
{
NWDataContext nw = new NWDataContext();
IQueryable <Product> products = nw.Products.AsQueryable <Product>();
if (categoryId.HasValue)
{
products = products.Where(p => p.CategoryID == categoryId.Value);
}
return(Json(new SelectList(products, "ProductID", "ProductName"), JsonRequestBehavior.AllowGet));
}
public ActionResult _GetOrders(int?productId)
{
NWDataContext nw = new NWDataContext();
IList <Order> orders = new List <Order>();
if (productId.HasValue)
{
orders = nw.Order_Details.Where(od => od.ProductID == productId).Select(od => od.Order).ToList();
}
return(View(new GridModel <Order>
{
Data = orders
}));
}
public List<BlogEntyTreeItem> GetTree()
{
NWDataContext db = new NWDataContext();
var p = db.Posts.ToList();
var list = p.GroupBy(g => g.DateCreated.Year).Select(g => new BlogEntyTreeItem
{
Text = g.Key.ToString(),
Children = g.GroupBy(g1 => g1.DateCreated.ToString("MMMM")).Select(g1 => new BlogEntyTreeItem
{
Text = g1.Key,
Children = g1.Select(i => new BlogEntyTreeItem { Text = i.Name }).ToList()
}).ToList()
}).ToList();
return list;
}
public ActionResult _SelectBatchEditing()
{
using (var nw = new NWDataContext())
{
List <EditableOrder> list = nw.Orders
.Select(o => new EditableOrder
{
OrderID = o.OrderID,
OrderDate = o.OrderDate ?? DateTime.Now,
Employee = new EditableEmployee {
EmployeeID = o.Employee.EmployeeID, FirstName = o.Employee.FirstName, LastName = o.Employee.LastName
},
Freight = o.Freight ?? 0
})
.ToList();
return(View(new GridModel(list)));
}
}
public DAO_SanPham()
{
db = new NWDataContext();
}
public DAO_CTDH()
{
db = new NWDataContext();
}
public DAO_DonHang()
{
db = new NWDataContext();
}
public Dao_SanPham()
{
chuoiKetNoi = ConfigurationManager.ConnectionStrings["cnstr"].ConnectionString;
conn = new SqlConnection(chuoiKetNoi);
db = new NWDataContext();
}
public DAO_DonHang()
{
//ket noi voi database
db = new NWDataContext();
}
public Dao_DonHang()
{
// tao ket noi den DB
db = new NWDataContext();
}
public DAO_NhanVien()
{
db = new NWDataContext();
}
