private void SetStatus(Guid promoCode, Order.StatusEnum status)
{
if (!IsOrderExist(promoCode))
{
throw new ArgumentException($"Заказ {promoCode} не существует");
}
using (var connection = new SqlConnection(ConnectionString))
{
connection.Open();
using (var command = connection.CreateCommand())
{
command.CommandText = "update Orders set StatusID=@StatusID where PromoCode=@PromoCode";
command.Parameters.AddWithValue("@StatusID", status);
command.Parameters.AddWithValue("@PromoCode", promoCode);
command.ExecuteNonQuery();
}
}
}
public UpdateRequest Status(Order.StatusEnum status)
{
m_params.AddOpt("status", status);
return(this);
}
public ImportOrderRequest Status(Order.StatusEnum status)
{
m_params.Add("status", status);
return(this);
}
