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