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