public IActionResult Create(Models.Operation operation) { operation.Result = Math.Pow(operation.First, operation.Second); _context.Operations.Add(operation); _context.SaveChanges(); return(RedirectToAction("List")); }
public IHttpActionResult Put(int id, [FromBody] Models.Operation modelOperation, string operation = null, string fvalue = null, string svalue = null) { if (modelOperation != null) { return(Content(HttpStatusCode.Created, _calculatorManager.dbManager.Update(modelOperation.OperationName, modelOperation.Fvalue, modelOperation.Svalue, id))); } else { return(Content(HttpStatusCode.Forbidden, _calculatorManager.dbManager.Update(operation, Double.Parse(fvalue), Double.Parse(svalue), id))); } }
public IHttpActionResult Post(string operation, [FromBody] Models.Operation modelOperation, string fvalue = null, string svalue = null) { if (modelOperation != null) { return(Content(HttpStatusCode.Accepted, string.Format("Result:" + _calculatorManager.Operation(operation, modelOperation.Fvalue, modelOperation.Svalue)))); } else { return(Content(HttpStatusCode.Gone, string.Format("Result:" + _calculatorManager.Operation(operation, Double.Parse(fvalue), Double.Parse(svalue))))); } }
public Models.Operation GetOperation(int id, out string exception) { try { using (IDbConnection db = new SqlConnection(connectionString)) { Models.Operation operation = db.Query <Models.Operation>( @"SELECT OperationName, Fvalue, Svalue FROM Operations WHERE id = @id", new { id }).FirstOrDefault(); exception = "Returnd Data Done!"; return(operation); } } catch (SqlException ex) { exception = ex.ToString(); return(null); //how to return ex??? } }
/// <summary> /// record an operation completed /// </summary> /// <param name="qty"></param> /// <returns></returns> public void RecordOperationCompleted(int qty) { Models.OrderItemOperation orderItemOp = Globals.dbContext.OrderItemOperations.Where(o => o.ID == OrderItemOp.ID).FirstOrDefault(); int qtyDone = qty; Models.OrderItemOperationPerformed itemOpPerformed = new Models.OrderItemOperationPerformed(); Models.OperationPerformed opPerformed = new Models.OperationPerformed(); opPerformed.qtyDone = qtyDone; opPerformed.timePerformed = DateTime.Now; opPerformed.usr = currentUser; opPerformed.OrderItemOperationsPerformed = new List <Models.OrderItemOperationPerformed>(); int totalQtyLeftToDo = qtyDone; // assign operations to order items foreach (Models.OrderItemOperation associatedOrderItemOp in associatedOrderItemOps) { if (associatedOrderItemOp.qtyDone < associatedOrderItemOp.qtyRequired) { int itemQtyLeftToDo = associatedOrderItemOp.qtyRequired - associatedOrderItemOp.qtyDone; Models.OrderItemOperationPerformed orderItemOpPerformed = new Models.OrderItemOperationPerformed(); if (totalQtyLeftToDo <= itemQtyLeftToDo) { orderItemOpPerformed = new Models.OrderItemOperationPerformed(); orderItemOpPerformed.qtyDone = totalQtyLeftToDo; associatedOrderItemOp.qtyDone += totalQtyLeftToDo; associatedOrderItemOp.OrderItemOperationPerformeds.Add(orderItemOpPerformed); opPerformed.OrderItemOperationsPerformed.Add(orderItemOpPerformed); totalQtyLeftToDo -= totalQtyLeftToDo; break; } else { orderItemOpPerformed = new Models.OrderItemOperationPerformed(); orderItemOpPerformed.qtyDone = itemQtyLeftToDo; associatedOrderItemOp.qtyDone = associatedOrderItemOp.qtyRequired; associatedOrderItemOp.OrderItemOperationPerformeds.Add(orderItemOpPerformed); opPerformed.OrderItemOperationsPerformed.Add(orderItemOpPerformed); totalQtyLeftToDo -= itemQtyLeftToDo; } } } // if we've filled all the order items, we need to do something with the rest... if (totalQtyLeftToDo > 0) { Models.Operation overBatchOperation = new Models.Operation(); overBatchOperation.Location = orderItemOp.operation.Location; overBatchOperation.Name = orderItemOp.operation.Name; overBatchOperation.Part = orderItemOp.operation.Part; Globals.dbContext.Operations.Add(overBatchOperation); Models.OrderItemOperation overBatchItemOperation = new Models.OrderItemOperation(); overBatchItemOperation.operation = overBatchOperation; overBatchItemOperation.orderItem = null; overBatchItemOperation.qtyDone = totalQtyLeftToDo; overBatchItemOperation.qtyRequired = 0; Globals.dbContext.OrderItemOperations.Add(overBatchItemOperation); Models.OrderItemOperationPerformed overBatchItemOperatonPerformed = new Models.OrderItemOperationPerformed(); overBatchItemOperatonPerformed.orderItemOperation = overBatchItemOperation; overBatchItemOperatonPerformed.qtyDone = totalQtyLeftToDo; overBatchItemOperatonPerformed.opPerformed = opPerformed; Globals.dbContext.OrderItemOperationPerformeds.Add(overBatchItemOperatonPerformed); opPerformed.OrderItemOperationsPerformed.Add(overBatchItemOperatonPerformed); overBatchOperation.OrderItemOperations.Add(overBatchItemOperation); } Globals.dbContext.OperationPerformeds.Add(opPerformed); Globals.dbContext.SaveChanges(); }