/// <summary> /// Updates orderrows /// </summary> /// <param name="orderrow"></param> public void UpdateOrderrow(Orderrow orderrow) { using (SqlConnection conn = CreateConnection()) { try { SqlCommand cmd = new SqlCommand("appSchema.uspUpdateOrderrow", conn); cmd.CommandType = CommandType.StoredProcedure; conn.Open(); cmd.Parameters.Add("@RowID", SqlDbType.Int, 4).Value = orderrow.RowID; cmd.Parameters.Add("@OrderID", SqlDbType.Int, 4).Value = orderrow.OrderID; cmd.Parameters.Add("@ProductID", SqlDbType.Int, 4).Value = orderrow.ProductID; cmd.Parameters.Add("@TaxID", SqlDbType.Int, 4).Value = orderrow.TaxID; cmd.Parameters.Add("@Quantity", SqlDbType.SmallInt, 2).Value = orderrow.Quantity; cmd.Parameters.Add("@Price", SqlDbType.Decimal, 9).Value = orderrow.Price; cmd.Parameters.Add("@Discount", SqlDbType.Decimal, 9).Value = orderrow.Discount; cmd.ExecuteNonQuery(); } catch { throw new ApplicationException("An error occured in the data access layer."); } } }
public void OrderFormView_InsertItem(WebshopClick.Model.BLL.Order order) { if (ModelState.IsValid) { try { Service service = new Service(); Orderrow orderrow = new Orderrow(); List<Item> cart = (List<Item>)Session["cart"]; if (cart.Count > 0) { service.UpdateOrder(order); foreach (Item item in cart) { orderrow.OrderID = order.OrderID; orderrow.ProductID = item.Product.ProductID; orderrow.TaxID = 1; orderrow.Quantity = item.Quantity; orderrow.Price = item.Product.Price; orderrow.Discount = Convert.ToDecimal(0); service.UpdateOrderrow(orderrow); orderrow.RowID = 0; } cart.Clear(); FlashPlaceHolder.Visible = true; } } catch (Exception) { ModelState.AddModelError(String.Empty, "Fel inträffade då beställning skulle genomföras."); } } }
public void UpdateOrderrow(Orderrow orderrow) { ICollection<ValidationResult> validationResults; if (!orderrow.Validate(out validationResults)) { var ex = new ValidationException("Objektet klarade inte valideringen."); ex.Data.Add("ValidationResults", validationResults); throw ex; } if (orderrow.RowID == 0) // New post if ID is 0! { OrderrowDAL.InsertOrderrow(orderrow); } else { OrderrowDAL.UpdateOrderrow(orderrow); } }