/*Funcion: Insertar operacion de un equipo
Param: OperationEquipmentInsertView, AuditDataFromWeb
Return: status
*/
public CUDView insertOperationEquipment(OperationEquipmentInsertView operation, AuditDataFromWeb audit)
{
OperationDao Dao = new OperationDao();
String state = Dao.insertOperationEquipment(operation);
CUDView logic = CUDVerifyLogic.verifierInsertDeleteUpdate("insert", state);
if (logic.insert == true)
{
AuditService auditservice = new AuditService();
String Action = "Insert new equipment for operation";
String NewValues = "OperationId: " + operation.OperationId
+ ", EquipmentId: " + operation.EquipmentId;
auditservice.formInsert(Action, NewValues, audit);
}
return logic;
}
private void saveAuxiliar()
{
if (ProductText.SelectedItem != null & ProcessText.SelectedItem != null & OperationTypeText.SelectedItem != null)
{
if (ProductText.SelectedItem.Value != "" & ProcessText.SelectedItem.Value != "" & OperationTypeText.SelectedItem.Value != "" & OperationText.Text != "")
{
OperationService operationService = new OperationService();
OperationInsertView insertOperation = new OperationInsertView();
insertOperation.OperationName = OperationText.Text;
insertOperation.OperationTypeId = Int32.Parse(OperationTypeText.SelectedItem.Value);
insertOperation.ProcessId = Int32.Parse(ProcessText.SelectedItem.Value);
insertOperation.ProductLineId = Int32.Parse(ProductText.SelectedItem.Value);
CUDView crud = operationService.insertOperation(insertOperation);
int idOperation = Int32.Parse(crud.insertPK);
if (crud.insert == false)
{
this.Page.ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('Could not insert the Operation')", true);
}
else
{
List<OperationEquipmentView> insertlist = (List<OperationEquipmentView>)(HttpContext.Current.Session["listUpdateEquipment"]);
foreach (OperationEquipmentView item in insertlist)
{
OperationEquipmentInsertView insert = new OperationEquipmentInsertView();
insert.EquipmentId = item.EquipmentId;
insert.OperationId = idOperation;
operationService.insertOperationEquipment(insert);
}
clearFields();
fillTable();
}
}
else
{
this.Page.ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('Please complete all fields.')", true);
}
}
else
{
this.Page.ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('Please complete all fields.')", true);
}
}
private void updateAuxiliar()
{
if (HttpContext.Current.Session["Operationid"] != null)
{
OperationService operationService = new OperationService();
List<OperationEquipmentView> insertlist = (List<OperationEquipmentView>)(HttpContext.Current.Session["listUpdateEquipment"]);
foreach (OperationEquipmentView item in insertlist)
{
OperationEquipmentInsertView insert = new OperationEquipmentInsertView();
insert.EquipmentId = item.EquipmentId;
insert.OperationId = Int32.Parse(HttpContext.Current.Session["Operationid"].ToString());
operationService.insertOperationEquipment(insert);
}
clearFields();
fillTable();
}
}
/*
Funcion: Crea una nueva operacion de Equipos
Param: OperationId, EquipmentId
Return: Status
*/
public String insertOperationEquipment(OperationEquipmentInsertView operation)
{
return context.InsertUpdateDeleteMSQL("EXEC insertOperationEquipment @OperationId=" + operation.OperationId + ", @EquipmentId='" + operation.EquipmentId + "';");
}
