public ActionResult DeleteConfirmed(string id)
{
ME_MATERIAL mE_MATERIAL = db.ME_MATERIAL.Find(id);
db.ME_MATERIAL.Remove(mE_MATERIAL);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "ID,NAME,DESCRIPTION,STATUS,LOT_SIZE,TYPE")] ME_MATERIAL mE_MATERIAL)
{
if (ModelState.IsValid)
{
db.Entry(mE_MATERIAL).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.STATUS = new SelectList(db.ME_MATERIAL_STATUS, "ID", "STATUS", mE_MATERIAL.STATUS);
return(View(mE_MATERIAL));
}
public ActionResult Create([Bind(Include = "ID,NAME,DESCRIPTION,STATUS,LOT_SIZE,TYPE")] ME_MATERIAL mE_MATERIAL, string Command)
{
if (ModelState.IsValid)
{
mE_MATERIAL.ID = Guid.NewGuid().ToString();
db.ME_MATERIAL.Add(mE_MATERIAL);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.STATUS = new SelectList(db.ME_MATERIAL_STATUS, "ID", "STATUS", mE_MATERIAL.STATUS);
return(View(mE_MATERIAL));
}
// GET: Material/Details/5
public ActionResult Details(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ME_MATERIAL mE_MATERIAL = db.ME_MATERIAL.Find(id);
if (mE_MATERIAL == null)
{
return(HttpNotFound());
}
return(View(mE_MATERIAL));
}
// GET: Material/Edit/5
public ActionResult Edit(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ME_MATERIAL mE_MATERIAL = db.ME_MATERIAL.Find(id);
if (mE_MATERIAL == null)
{
return(HttpNotFound());
}
ViewBag.STATUS = new SelectList(db.ME_MATERIAL_STATUS, "ID", "STATUS", mE_MATERIAL.STATUS);
ViewBag.TYPE = new SelectList(db.ME_MATERIAL_TYPE, "ID", "TYPE", mE_MATERIAL.TYPE);
return(View(mE_MATERIAL));
}
public XElement getNextSFC(int SFCCount)
{
ManufacturingExecutionEntities manufacturingExecutionEntities =
new ManufacturingExecutionEntities();
StringBuilder sbsfc = new StringBuilder();
XmlWriter xmlWriter = XmlWriter.Create(sbsfc);
xmlWriter.WriteStartDocument();
xmlWriter.WriteStartElement("SFCList");
for (int SFCCounter = 0; SFCCounter < SFCCount; SFCCounter++)
{
int ReleasedStatusID = manufacturingExecutionEntities.ME_SHOP_ORDER_STATUS.
Where(status => status.NAME.Equals(ReleasedStatus)).FirstOrDefault().ID;
ME_SHOP_ORDER mE_SHOP_ORDER = manufacturingExecutionEntities.ME_SHOP_ORDER.Where(shopOrder => shopOrder.STATUS == ReleasedStatusID).FirstOrDefault();
if (mE_SHOP_ORDER == null)
{
break;
}
xmlWriter.WriteStartElement("SFC");
mE_SHOP_ORDER.STATUS = manufacturingExecutionEntities.ME_SHOP_ORDER_STATUS.Where(status => status.NAME.Equals(ProductionStatus)).Select(status
=> status.ID).FirstOrDefault();
manufacturingExecutionEntities.Entry(mE_SHOP_ORDER).State = EntityState.Modified;
manufacturingExecutionEntities.SaveChanges();
string workCenterID = manufacturingExecutionEntities.ME_OPERATION.Where(operation => operation.ID.Equals(
manufacturingExecutionEntities.ME_ROUTING_DETAILS.Where(routing_detail => routing_detail.ROUTING.Equals(mE_SHOP_ORDER.ROUTING))
.Select(routing => routing.OPERATION).FirstOrDefault()))
.FirstOrDefault().WORKCENTER;
string plannedMaterial = manufacturingExecutionEntities.ME_MATERIAL.Where(material => material.ID.Equals(mE_SHOP_ORDER.PLANNED_MATERIAL)).
Select(material => material.NAME).FirstOrDefault();
xmlWriter.WriteAttributeString("ID", mE_SHOP_ORDER.ID);
xmlWriter.WriteAttributeString("WorkCenter", manufacturingExecutionEntities.
ME_WORKCENTER.Where(wc => wc.ID.Equals(workCenterID)).Select(wc => wc.NAME).FirstOrDefault());
xmlWriter.WriteAttributeString("Status", SFCState.New.ToString("G"));
xmlWriter.WriteElementString("SFCName", mE_SHOP_ORDER.NAME);
xmlWriter.WriteElementString("Material", plannedMaterial);
xmlWriter.WriteElementString("OrderNumber", mE_SHOP_ORDER.CUSTOMER_ORDER);
//xmlWriter.WriteStartElement("RoutingSteps");
foreach (ME_ROUTING_DETAILS mE_ROUTING_DETAILS in manufacturingExecutionEntities.
ME_ROUTING_DETAILS.Where(routing => routing.ROUTING.Equals(mE_SHOP_ORDER.ROUTING)).OrderBy(routing => routing.SEQUENCE))
{
ME_OPERATION mE_OPERATION = manufacturingExecutionEntities.ME_OPERATION.Where(opn => opn.ID.Equals(mE_ROUTING_DETAILS.OPERATION)).
FirstOrDefault();
ME_RESOURCE mE_RESOURCE = manufacturingExecutionEntities.ME_RESOURCE.Where(resource => resource.ID.Equals(mE_OPERATION.RESOURCE)).
FirstOrDefault();
ME_BOM_DETAILS mE_BOM_DETAIL = manufacturingExecutionEntities.ME_BOM_DETAILS.Where(bom_detail => bom_detail.BOM.Equals(bom_detail.BOM)).
Where(bom_detail => bom_detail.OPERATION.Equals(mE_OPERATION.ID)).FirstOrDefault();
ME_MATERIAL mE_MATERIAL = manufacturingExecutionEntities.ME_MATERIAL.Where(material => material.ID.Equals(mE_BOM_DETAIL.COMPONENT)).
FirstOrDefault();
ME_SETPOINT_DETAILS mE_SETPOINT_DETAIL = manufacturingExecutionEntities.ME_SETPOINT_DETAILS.
Where(sp => ((sp.RESOURCE.Equals(mE_RESOURCE.ID)) && (sp.MATERIAL.Equals(mE_MATERIAL.ID)))).FirstOrDefault();
xmlWriter.WriteStartElement("RoutingStep");
xmlWriter.WriteAttributeString("Status", OperationState.New.ToString("G"));
xmlWriter.WriteAttributeString("ID", mE_ROUTING_DETAILS.SEQUENCE.ToString());
xmlWriter.WriteAttributeString("Operation", mE_OPERATION.NAME);
xmlWriter.WriteAttributeString("Resource", mE_RESOURCE.NAME);
xmlWriter.WriteAttributeString("ShopOrder", mE_SHOP_ORDER.ID);
xmlWriter.WriteStartElement("Components");
xmlWriter.WriteStartElement("Component");
xmlWriter.WriteAttributeString("Name", mE_MATERIAL.NAME);
xmlWriter.WriteAttributeString("Assembly_Quantity", mE_BOM_DETAIL.ASSEMBLY_QUANTITY.ToString());
if (mE_SETPOINT_DETAIL != null)
{
ME_SETPOINT mE_SETPOINT = manufacturingExecutionEntities.ME_SETPOINT.Where(sp => sp.ID.Equals(mE_SETPOINT_DETAIL.SETPOINT)).
FirstOrDefault();
ME_SETPOINT_TYPE mE_SETPOINT_TYPE = manufacturingExecutionEntities.ME_SETPOINT_TYPE.
Where(sp => sp.ID == mE_SETPOINT.DATA_TYPE).FirstOrDefault();
xmlWriter.WriteStartElement("SetPoint");
xmlWriter.WriteElementString("Key", mE_SETPOINT.NAME);
if (mE_SETPOINT_TYPE.NAME.Equals(NumericSetPoint))
{
xmlWriter.WriteElementString("Value", mE_SETPOINT.NUMERIC_VALUE.ToString());
}
else
{
xmlWriter.WriteElementString("Value", mE_SETPOINT.STRING_VALUE);
}
xmlWriter.WriteEndElement();
}
xmlWriter.WriteEndElement();
xmlWriter.WriteEndElement();
xmlWriter.WriteEndElement();
}
xmlWriter.WriteEndElement();
}
xmlWriter.WriteEndElement();
xmlWriter.WriteEndDocument();
xmlWriter.Close();
return(XElement.Parse(sbsfc.ToString()));
}
