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(); }