public ActionResult AddDetail(OrderDetailNew model) { //TODO: Kiểm tra tính hợp lệ của dữ liệu được nhập if (model.ProductID == 0) { ModelState.AddModelError("ProductID", "ProductID Expected"); } if (model.UnitPrice == 0) { ModelState.AddModelError("UnitPrice", "UnitPrice Expected"); } if (model.Quantity == 0) { ModelState.AddModelError("Quantity", "Quantity Expected"); } if (model.Discount == 0) { model.Discount = 0; } if (!ModelState.IsValid) { model.OrderID = model.OrderID; ViewBag.Title = model.OrderID != 0 ? "Create new OrderDetail" : "Edit Order"; return(View(model)); } //TODO: Lưu dữ liệu vao DB if (model.OrderID != 0) { CatalogBLL.AddOrderDetailNew(model); } return(RedirectToAction("Create")); }
public ActionResult AddDetail(string id = "") { if (!string.IsNullOrEmpty(id)) { ViewBag.Title = "Create OrderDetail"; ViewBag.SmallTitle = "Thêm Chi Tiết Đơn Hàng"; OrderDetailNew newOrder = new OrderDetailNew() { OrderID = Convert.ToInt32(id) }; return(View(newOrder)); } return(View()); }
public int Add(OrderDetailNew data) { int orderId = 0; using (SqlConnection connection = new SqlConnection(this.connectionString)) { connection.Open(); SqlCommand cmd = new SqlCommand(); cmd.CommandText = @"INSERT INTO OrderDetails ( OrderID, ProductID, UnitPrice, Quantity, Discount ) VALUES ( @OrderID, @ProductID, @UnitPrice, @Quantity, @Discount );"; cmd.CommandType = CommandType.Text; cmd.Connection = connection; cmd.Parameters.AddWithValue("@OrderID", data.OrderID); cmd.Parameters.AddWithValue("@ProductID", data.ProductID); cmd.Parameters.AddWithValue("@UnitPrice", data.UnitPrice); cmd.Parameters.AddWithValue("@Quantity", data.Quantity); cmd.Parameters.AddWithValue("@Discount", data.Discount); orderId = Convert.ToInt32(cmd.ExecuteScalar()); connection.Close(); } return(orderId); }
public static int AddOrderDetailNew(OrderDetailNew data) { return(OrderDetailNewDB.Add(data)); }