/*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 + "';"); }