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 bool ThemSanPham(Product sanPham)
{
try
{
db.Products.InsertOnSubmit(sanPham);
db.SubmitChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
public void ThemSP(Product pr)
{
db.Products.InsertOnSubmit(pr);
db.SubmitChanges();
//SqlCommand cmd;
//string query = string.Format("insert into Products (ProductName, UnitsInStock, UnitPrice, CategoryID ,SupplierID) " +
// "values ('{0}', '{1}', '{2}', '{3}', '{4}')",
// tenSP, soLuong, donGia, maLoaiSP, maNCC);
//cmd = new SqlCommand(query, conn);
//conn.Open();
//cmd.ExecuteNonQuery();
//conn.Close();
}
public bool ThemNhanVien(Employee nv)
{
try
{
db.Employees.InsertOnSubmit(nv);
db.SubmitChanges();
return(true);
}
catch (Exception ex)
{
System.Windows.Forms.MessageBox.Show(ex.Message);
return(false);
}
}
public bool ThemCTDH(Order_Detail chiTietDH, int maDH, int maSP)
{
bool trangThai = true;
try
{
chiTietDH = db.Order_Details.First(s => s.OrderID == maDH && s.ProductID == maSP);
trangThai = false;
}
catch (Exception)
{
trangThai = true;
}
if (trangThai)
{
db.Order_Details.InsertOnSubmit(chiTietDH);
db.SubmitChanges();
}
return(trangThai);
}
public ActionResult Create(FormCollection fC) // hành động thêm
{
var maSP = fC["MaSP"];
var tenSP = fC["TenSP"];
if (string.IsNullOrEmpty(maSP))
{
ViewData["Loi"] = "Không được để trống";
}
else if (string.IsNullOrEmpty(tenSP))
{
ViewData["nullProductName"] = "Không được để trống product name";
}
else
{
Product p = new Product();
p.ProductName = tenSP;
nDC.Products.InsertOnSubmit(p);
nDC.SubmitChanges();
return(RedirectToAction("Index"));
}
return(View());
}
public void ThemDH(Order donHang)
{
db.Orders.InsertOnSubmit(donHang);
db.SubmitChanges();
}
public void ThemDH(Order oD)
{
db.Orders.InsertOnSubmit(oD);
db.SubmitChanges();
}
public void ThemNV(Employee em)
{
db.Employees.InsertOnSubmit(em);
db.SubmitChanges();
}