private void runHMZPrusedure(WorkOrdersParameter wop) { int userID = db.Users.First(p => p.userName == Thread.CurrentPrincipal.Identity.Name).ID; string a1, a2, a3; if (wop.isDone == null) { a1 = "NULL"; } else { a1 = wop.isDone.ToString(); } if (wop.DoneLength == null) { a2 = "NULL"; } else { a2 = wop.DoneLength.ToString(); } if (wop.DoneAmount == null) { a3 = "NULL"; } else { a3 = wop.DoneAmount.ToString(); } string updateSQL; updateSQL = "Exec PMDB.dbo.InsertIntoWorkordersParametersActions @userID_FK=" + userID + " ,@workordersParametersID_FK=" + wop.ID + " ,@isDone=" + a1 + " ,@DoneLength=" + a2 + " ,@DoneAmount=" + a3; //updateSQL = "SELECT * FROM dbo.[WorkOrderStatus]"; SqlConnection con = new SqlConnection(connectionString); SqlCommand cmd = new SqlCommand(updateSQL, con); //cmd.CommandType = CommandType.StoredProcedure; try { con.Open(); cmd.ExecuteNonQuery(); con.Close(); } catch (Exception err) { var a = err.Message; } }
public IHttpActionResult PutWorkOrdersParameter(int id, WorkOrdersParameter workOrdersParameter) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != workOrdersParameter.ID) { return(BadRequest()); } db.Entry(workOrdersParameter).State = EntityState.Modified; try { db.SaveChanges(); runHMZPrusedure(workOrdersParameter); } catch (DbUpdateConcurrencyException) { if (!WorkOrdersParameterExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public ActionResult DeleteConfirmed(int id) { WorkOrdersParameter workOrdersParameter = db.WorkOrdersParameters.Find(id); db.WorkOrdersParameters.Remove(workOrdersParameter); db.SaveChanges(); return(RedirectToAction("Index")); }
public IHttpActionResult GetWorkOrdersParameter(int id) { WorkOrdersParameter workOrdersParameter = db.WorkOrdersParameters.Find(id); if (workOrdersParameter == null) { return(NotFound()); } return(Ok(workOrdersParameter)); }
public ActionResult Edit([Bind(Include = "ID,workOrder_FKID,parameter_FKID,Lenght,Amount,isDone,lastUpdate,DoneLength,DoneAmount,weightAmount")] WorkOrdersParameter workOrdersParameter) { if (ModelState.IsValid) { db.Entry(workOrdersParameter).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.parameter_FKID = new SelectList(db.Parameters, "ID", "Name", workOrdersParameter.parameter_FKID); ViewBag.workOrder_FKID = new SelectList(db.WorkOrders, "ID", "Number", workOrdersParameter.workOrder_FKID); return(View(workOrdersParameter)); }
public IHttpActionResult DeleteWorkOrdersParameter(int id) { WorkOrdersParameter workOrdersParameter = db.WorkOrdersParameters.Find(id); if (workOrdersParameter == null) { return(NotFound()); } db.WorkOrdersParameters.Remove(workOrdersParameter); db.SaveChanges(); return(Ok(workOrdersParameter)); }
// GET: WorkOrdersParameters/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } WorkOrdersParameter workOrdersParameter = db.WorkOrdersParameters.Find(id); if (workOrdersParameter == null) { return(HttpNotFound()); } return(View(workOrdersParameter)); }
// GET: WorkOrdersParameters/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } WorkOrdersParameter workOrdersParameter = db.WorkOrdersParameters.Find(id); if (workOrdersParameter == null) { return(HttpNotFound()); } ViewBag.parameter_FKID = new SelectList(db.Parameters, "ID", "Name", workOrdersParameter.parameter_FKID); ViewBag.workOrder_FKID = new SelectList(db.WorkOrders, "ID", "Number", workOrdersParameter.workOrder_FKID); return(View(workOrdersParameter)); }