@{
Validation.RequireField("Name", "Product name is required.");
Validation.RequireField("Description", "Product description is required.");
Validation.RequireField("Price", "Product price is required.");
var Name = "";
var Description = "";
var Price = Decimal.Zero;
var ProductId = UrlData[0];
if (ProductId.IsEmpty()) {
Response.Redirect("~/EditProducts");
}
var db = Database.Open("SmallBakery");
if (IsPost && Validation.IsValid()) {
var updateQueryString =
"UPDATE Product SET Name=@0, Description=@1, Price=@2 WHERE Id=@3" ;
Name = Request["Name"];
Description = Request["Description"];
Price = Request["Price"].AsDecimal();
db.Execute(updateQueryString, Name, Description, Price, ProductId);
Response.Redirect(@Href("~/EditProducts"));
}
else {
var selectQueryString = "SELECT * FROM Product WHERE Id=@0";
var row = db.QuerySingle(selectQueryString, ProductId);
Name = row.Name;
Description = row.Description;
Price = row.Price;
}
}
Add Products
Update Product
@Html.ValidationSummary("Errors with your submission:")