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