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