/// <summary>
/// Updates products
/// </summary>
/// <param name="product"></param>
public void UpdateProduct(Product product)
{
using (SqlConnection conn = CreateConnection())
{
try
{
SqlCommand cmd = new SqlCommand("appSchema.uspUpdateProduct", conn);
cmd.CommandType = CommandType.StoredProcedure;
conn.Open();
cmd.Parameters.Add("@ProductID", SqlDbType.Int, 4).Value = product.ProductID;
cmd.Parameters.Add("@Name", SqlDbType.NVarChar, 40).Value = product.Name;
cmd.Parameters.Add("@Price", SqlDbType.Decimal, 9).Value = product.Price;
cmd.Parameters.Add("@Description", SqlDbType.NVarChar, 200).Value = product.Description;
cmd.Parameters.Add("@Image", SqlDbType.NVarChar, 50).Value = product.Image;
cmd.Parameters.Add("@CategoryID", SqlDbType.Int, 4).Value = product.CategoryID;
cmd.ExecuteNonQuery();
}
catch
{
throw new ApplicationException("An error occured in the data access layer.");
}
}
}
public void ProductFormView_InsertItem(Product product)
{
if (ModelState.IsValid)
{
try
{
Service service = new Service();
service.UpdateProduct(product);
//Session["Success"] = true;
Response.RedirectToRoute("AProducts");
}
catch (Exception)
{
ModelState.AddModelError(String.Empty, "Fel inträffade då linje skulle läggas till.");
}
}
}
public void UpdateProduct(Product product)
{
ICollection<ValidationResult> validationResults;
if (!product.Validate(out validationResults))
{
var ex = new ValidationException("Objektet klarade inte valideringen.");
ex.Data.Add("ValidationResults", validationResults);
throw ex;
}
if (product.ProductID == 0) // New post if ID is 0!
{
ProductDAL.InsertProduct(product);
}
else
{
ProductDAL.UpdateProduct(product);
}
}
public Item(Product product, int quantity)
{
this.product = product;
this.quantity = quantity;
}