public IHttpActionResult PuttSalesOrderHeader(int id, tSalesOrderHeader tSalesOrderHeader) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != tSalesOrderHeader.ID) { return(BadRequest()); } db.Entry(tSalesOrderHeader).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!tSalesOrderHeaderExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public IHttpActionResult PuttSalesOrderHeader(tSalesOrderHeader tSalesOrderHeader) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (!ModelState.IsValid) { return(BadRequest(ModelState)); } try { tSalesOrderHeader updatetSalesOrderHeader = db.tSalesOrderHeaders.Find(tSalesOrderHeader.ID); updatetSalesOrderHeader.SAP_SalesOrderID = tSalesOrderHeader.SAP_SalesOrderID; updatetSalesOrderHeader.TransactionStatusID = tSalesOrderHeader.TransactionStatusID; updatetSalesOrderHeader.Discount1Amount = tSalesOrderHeader.Discount1Amount; updatetSalesOrderHeader.Discount2Amount = tSalesOrderHeader.Discount2Amount; updatetSalesOrderHeader.GrossAmount = tSalesOrderHeader.GrossAmount; updatetSalesOrderHeader.SalesOrderAmount = tSalesOrderHeader.SalesOrderAmount; updatetSalesOrderHeader.Status = tSalesOrderHeader.Status; db.Entry(updatetSalesOrderHeader).State = EntityState.Modified; db.SaveChanges(); return(StatusCode(HttpStatusCode.OK)); } catch (DbUpdateConcurrencyException) { } return(StatusCode(HttpStatusCode.NoContent)); }
public IHttpActionResult GettSalesOrderHeader(int id) { tSalesOrderHeader tSalesOrderHeader = db.tSalesOrderHeaders.Find(id); if (tSalesOrderHeader == null) { return(NotFound()); } return(Ok(tSalesOrderHeader)); }
public IHttpActionResult PosttSalesOrderHeader(tSalesOrderHeader tSalesOrderHeader) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.tSalesOrderHeaders.Add(tSalesOrderHeader); db.SaveChanges(); return(CreatedAtRoute("DefaultApi", new { id = tSalesOrderHeader.ID }, tSalesOrderHeader)); }
public IHttpActionResult DeletetSalesOrderHeader(int id) { tSalesOrderHeader tSalesOrderHeader = db.tSalesOrderHeaders.Find(id); if (tSalesOrderHeader == null) { return(NotFound()); } db.tSalesOrderHeaders.Remove(tSalesOrderHeader); db.SaveChanges(); return(Ok(tSalesOrderHeader)); }
public IHttpActionResult PuttSalesOrderHeaderStatus(UpdateSalesOrderStatus orderStatus) { tSalesOrderHeader existing = new tSalesOrderHeader(); //THIS ACTUALLY HOLDS THE SAP ID var SAPID = (orderStatus.SAPsalesOrderID).ToString(); var id = orderStatus.salesOrderID; existing = db.tSalesOrderHeaders.Where(x => x.SalesOrderID == id).SingleOrDefault(); var existingItems = db.tSalesOrderLines.Where(x => x.SalesOrderID == id).ToList(); if (existing != null) { //THIS ACTUALLY HOLDS THE SAP ORDER ID existing.SAP_SalesOrderID = SAPID; existing.TransactionStatusID = Convert.ToInt32(orderStatus.transactionStatusID); existing.Status = orderStatus.SAPstatus; } db.Entry(existing).State = EntityState.Modified; if (existingItems != null) { foreach (var items in existingItems) { //THIS ACTUALLY HOLDS THE SAP ORDER ID items.SAP_SalesOrderID = SAPID; items.TransactionStatus = (orderStatus.transactionStatusID).ToString(); db.Entry(items).State = EntityState.Modified; } } try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!tSalesOrderHeaderExists(id)) { return(NotFound()); } else { StatusCode(HttpStatusCode.BadRequest); } } return(StatusCode(HttpStatusCode.OK)); }
public IHttpActionResult UpdateSalesOrderTransactionStatus(tSalesOrderHeader tSalesOrderHeader) { var id = tSalesOrderHeader.SalesOrderID; tSalesOrderHeader existing = new tSalesOrderHeader(); existing = db.tSalesOrderHeaders.Where(x => x.SalesOrderID == id).SingleOrDefault(); if (existing != null) { existing.TransactionStatusID = tSalesOrderHeader.TransactionStatusID; } db.Entry(existing).State = EntityState.Modified; db.SaveChanges(); return(StatusCode(HttpStatusCode.OK)); }
public IHttpActionResult PosttSalesOrderHeader(tSalesOrderHeader tSalesOrderHeader) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } try { db.tSalesOrderHeaders.Add(tSalesOrderHeader); db.SaveChanges(); return(StatusCode(HttpStatusCode.OK)); } catch (DbEntityValidationException ex) { foreach (DbEntityValidationResult item in ex.EntityValidationErrors) { // Get entry DbEntityEntry entry = item.Entry; switch (entry.State) { case EntityState.Added: entry.State = EntityState.Detached; return(BadRequest()); //break; case EntityState.Modified: entry.CurrentValues.SetValues(entry.OriginalValues); entry.State = EntityState.Unchanged; return(BadRequest()); //break; case EntityState.Deleted: entry.State = EntityState.Unchanged; return(BadRequest()); //break; } } } return(BadRequest()); }
public IHttpActionResult PuttSalesOrderHeader(tSalesOrderHeader tSalesOrderHeader) { var id = tSalesOrderHeader.SalesOrderID; tSalesOrderHeader existing = new tSalesOrderHeader(); existing = db.tSalesOrderHeaders.Where(x => x.SalesOrderID == id).SingleOrDefault(); if (existing != null) { existing.AccountContactID = tSalesOrderHeader.AccountContactID; existing.PaymentTermsID = tSalesOrderHeader.PaymentTermsID; existing.ShippingAddress = tSalesOrderHeader.ShippingAddress; existing.Comments = tSalesOrderHeader.Comments; existing.Description = tSalesOrderHeader.Description; existing.ExternalReference = tSalesOrderHeader.ExternalReference; existing.TransactionStatusID = tSalesOrderHeader.TransactionStatusID; } db.Entry(existing).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!tSalesOrderHeaderExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.OK)); }