/// <summary>
/// Updates orders
/// </summary>
/// <param name="order"></param>
public void UpdateOrder(Order order)
{
using (SqlConnection conn = CreateConnection())
{
try
{
SqlCommand cmd = new SqlCommand("appSchema.uspUpdateOrder", conn);
cmd.CommandType = CommandType.StoredProcedure;
conn.Open();
cmd.Parameters.Add("@OrderID", SqlDbType.Int, 4).Value = order.OrderID;
cmd.Parameters.Add("@UserID", SqlDbType.Int, 4).Value = order.UserID;
cmd.Parameters.Add("@Name", SqlDbType.NVarChar, 50).Value = order.Name;
cmd.Parameters.Add("@Date", SqlDbType.DateTime,8).Value = order.Date;
cmd.Parameters.Add("@Address", SqlDbType.NVarChar, 30).Value = order.Address;
cmd.Parameters.Add("@Postnumber", SqlDbType.NVarChar, 6).Value = order.Postnumber;
cmd.Parameters.Add("@City", SqlDbType.NVarChar, 20).Value = order.City;
cmd.Parameters.Add("@PaymentID", SqlDbType.Int, 4).Value = order.PaymentID;
cmd.Parameters.Add("@StatusID", SqlDbType.Int, 4).Value = order.StatusID;
cmd.ExecuteNonQuery();
}
catch
{
throw new ApplicationException("An error occured in the data access layer.");
}
}
}
public void UpdateOrder(Order order)
{
ICollection<ValidationResult> validationResults;
if (!order.Validate(out validationResults))
{
var ex = new ValidationException("Objektet klarade inte valideringen.");
ex.Data.Add("ValidationResults", validationResults);
throw ex;
}
if (order.OrderID == 0) // New post if ID is 0!
{
OrderDAL.InsertOrder(order);
}
else
{
OrderDAL.UpdateOrder(order);
}
}