public async Task<IHttpActionResult> PutOrder(int id, Order order) { if (!ModelState.IsValid) { return BadRequest(ModelState); } if (id != order.ID) { return BadRequest(); } db.Entry(order).State = EntityState.Modified; try { await db.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!OrderExists(id)) { return NotFound(); } else { throw; } } return StatusCode(HttpStatusCode.NoContent); }
public async Task<IHttpActionResult> PostOrder(Order order) { if (!ModelState.IsValid) { return BadRequest(ModelState); } order.InsertDateTime = DateTime.Now; order.InsertProcess = "IrfankWEBAPI"; order.InsertProcess = "IrfanTest"; var paramCustomerId = new SqlParameter("@pn_customer_id", order.CustomerId); var paramTotalAmount = new SqlParameter("@pn_total_amount", order.TotalAmount); var paramTaxAmount = new SqlParameter("@pn_tax_amount", order.TaxAmount); var paramNetAmount = new SqlParameter("@pn_net_amount", order.NetAmount); var paramComments = new SqlParameter("@pn_comments", order.Comments); var orderIdParameter = new SqlParameter(); orderIdParameter.ParameterName = "@pn_output_id"; orderIdParameter.Direction = ParameterDirection.Output; orderIdParameter.SqlDbType = SqlDbType.Int; await db.Database.ExecuteSqlCommandAsync("Exec dbp_insert_orders @pn_customer_id, @pn_total_amount, @pn_tax_amount,@pn_net_amount, @pn_comments, @pn_output_id OUTPUT", paramCustomerId, paramTotalAmount, paramTaxAmount, paramNetAmount, paramComments, orderIdParameter).ContinueWith((result) => { var res = result.Result; if (Convert.ToInt32(orderIdParameter.Value) > 1) { order.ID = Convert.ToInt32(orderIdParameter.Value); } }); //db.Orders.Add(order); await db.SaveChangesAsync(); return CreatedAtRoute("DefaultApi", new { id = order.ID }, order); }
public async Task<IHttpActionResult> PostOrder(Order order) { if (!ModelState.IsValid) { return BadRequest(ModelState); } order.InsertDateTime = DateTime.Now; order.InsertProcess = "IrfankWEBAPI"; order.InsertProcess = "IrfanTest"; var pName = new SqlParameter("@pv_order_name", order.OrderName); var pCustId = new SqlParameter("@pv_customer_id", order.CustomerId); var pDate = new SqlParameter("@pv_order_date", order.OrderDate); var prequiredDate = new SqlParameter("@pv_required_date", order.RequiredDate); //var pMenuId = new SqlParameter("@pv_menu_id", order.MenuId); //var pPrice = new SqlParameter("@pv_unit_price", order.UnitPrice); //var pQuantity = new SqlParameter("@pv_quantity", order.Quantity); var pComments = new SqlParameter("@pv_comments", order.Comments); var orderIdParameter = new SqlParameter(); orderIdParameter.ParameterName = "@pn_output_id"; orderIdParameter.Direction = ParameterDirection.Output; orderIdParameter.SqlDbType = SqlDbType.Int; try { } catch (Exception ex) { throw new ApplicationException(ex.Message); } //db.Orders.Add(order); await db.SaveChangesAsync(); return CreatedAtRoute("DefaultApi", new { id = order.ID }, order); }