/*
        Metodo utilizado para insertar recipes
        */
        private void saveAuxiliar()
        {
            if (Product2.SelectedItem != null & Process2.SelectedItem != null & Operation2.SelectedItem != null)
            {
                if (Process2.SelectedItem.Value != "" & Operation2.SelectedItem.Value != "")
                {
                    if (validateParameterOnRecipeInsert())
                    {
                        if (validatetableParameterOneForInt())
                        {
                            //Crea el servicio
                            RecipeService recipeService = new RecipeService();
                            RecipeInsertView recipe = new RecipeInsertView();
                            recipe.ProcessId = Int32.Parse(Process2.SelectedItem.Value);
                            recipe.OperationId = Int32.Parse(Operation2.SelectedItem.Value);
                            recipe.RecipeEnable = recipeEnable2.Items[0].Selected;
                            String user = Context.User.Identity.Name;
                            String reason = "N/A";
                            //Añade los datos para la auditoria
                            AuditDataFromWeb audit = new AuditDataFromWeb();
                            audit.Reason = reason;
                            audit.StationIP = General.getIp(this.Page);
                            audit.UserName = user;
                            //Realiza la insercion
                            CUDView crud = recipeService.insertRecipe(recipe, audit);
                            string idRecipNew = crud.insertPK;

                            if (crud.insert == false)
                            {
                                this.Page.ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('Could not insert the recipe')", true);
                            }
                            else
                            {

                                //Insert Parameters
                                foreach (GridViewRow gvrow in GridView4.Rows)
                                {
                                    Label lblParameterId = (Label)gvrow.FindControl("ParameterId");
                                    TextBox lblValue = (TextBox)gvrow.FindControl("Value");

                                    if (lblValue.Text != "")
                                    {
                                        RecipeParameterInsertView newParameter = new RecipeParameterInsertView();
                                        newParameter.ParameterId = Int32.Parse(lblParameterId.Text);
                                        newParameter.ParameterValue = Int32.Parse(lblValue.Text);
                                        newParameter.RecipeId = Int32.Parse(idRecipNew);

                                        crud = recipeService.InsertRecipeParameter(newParameter, audit);
                                    }
                                }

                                //Insert Equipments
                                foreach (GridViewRow gvrow in GridView5.Rows)
                                {
                                    CheckBox chk = (CheckBox)gvrow.FindControl("Link");
                                    Label lblID = (Label)gvrow.FindControl("ID");
                                    Label lblEquipment = (Label)gvrow.FindControl("EquipmentName");

                                    RecipeEquipmentInsertView newEquipment = new RecipeEquipmentInsertView();
                                    newEquipment.EquipmentId = lblID.Text;
                                    newEquipment.Link = chk.Checked;
                                    newEquipment.RecipeId = Int32.Parse(idRecipNew);
                                    newEquipment.OperationId = recipe.OperationId;
                                    crud = recipeService.insertRecipeEquipment(newEquipment, audit);
                                }

                                clearFields();
                            }

                        }
                        else
                        {
                            this.Page.ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('All parameter values must be numbers')", true);
                        }
                    }
                    else
                    {
                        this.Page.ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('Please add parameters for this process.')", true);

                    }

                }
                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);
            }
        }
Пример #2
0
 /*
   Funcion: Inserta Parametros para una receta
   Param: RecipeId, ParameterId,ParameterValue
   Return: Status
   */
 public String InsertRecipeParameter(RecipeParameterInsertView parameter)
 {
     return context.InsertUpdateDeleteMSQL("InsertRecipeParameter @RecipeId= " + parameter.RecipeId + ", @ParameterId= " + parameter.ParameterId
         + ",  @ParameterValue= " + parameter .ParameterValue+ ";");
 }
Пример #3
0
        /*Funcion: Insertar un parametro para la receta
          Param: RecipeParameterInsertView,AuditDataFromWeb
          Return: Status
          */
        public CUDView InsertRecipeParameter(RecipeParameterInsertView parameter, AuditDataFromWeb audit)
        {
            RecipeDao Dao = new RecipeDao();
            String state = Dao.InsertRecipeParameter(parameter);
            CUDView logic = CUDVerifyLogic.verifierInsertDeleteUpdate("insert", state);

            if (logic.insert == true)
            {
                AuditService auditservice = new AuditService();
                String Action = "Insert recipe parameter";

                String NewValues = "RecipeId: " + parameter.RecipeId
                    + ", ParameterId: " + parameter.ParameterId
                    + ", ParameterValue: " + parameter.ParameterValue;

                auditservice.formInsert(Action, NewValues, audit);
            }

            return logic;
        }
        private void saveAuxiliar()
        {
            if (Product2.SelectedItem != null & Process2.SelectedItem != null & Operation2.SelectedItem != null)
            {
                if (Process2.SelectedItem.Value != "" & Operation2.SelectedItem.Value != "")
                {

                    if (validatetableParameterOneForInt())
                    {
                        string confirmValue = Request.Form["confirm_value"];
                        if (confirmValue == "Yes")
                        {
                            RecipeService recipeService = new RecipeService();
                            RecipeInsertView recipe = new RecipeInsertView();

                            recipe.ProcessId = Int32.Parse(Process2.SelectedItem.Value);
                            recipe.OperationId = Int32.Parse(Operation2.SelectedItem.Value);

                            string DOMAINUSER = User.Identity.Name;
                            string[] paramsLogin = DOMAINUSER.Split('\\');
                            recipe.FirstUserLoginPermision = paramsLogin[1].ToString();// login with actice directory

                            CUDView crud = recipeService.insertRecipe(recipe);
                            string idRecipNew = crud.insertPK;

                            if (crud.insert == false)
                            {
                                this.Page.ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('Could not insert the recipe')", true);
                            }
                            else
                            {

                                //Insert Parameters
                                foreach (GridViewRow gvrow in GridView4.Rows)
                                {
                                    Label lblParameterId = (Label)gvrow.FindControl("ParameterId");
                                    TextBox lblValue = (TextBox)gvrow.FindControl("Value");

                                    if (lblValue.Text != "")
                                    {
                                        RecipeParameterInsertView newParameter = new RecipeParameterInsertView();
                                        newParameter.ParameterId = Int32.Parse(lblParameterId.Text);
                                        newParameter.ParameterValue = Int32.Parse(lblValue.Text);
                                        newParameter.RecipeId = Int32.Parse(idRecipNew);
                                        crud = recipeService.InsertRecipeParameter(newParameter);
                                    }
                                }

                                //Insert Equipments
                                foreach (GridViewRow gvrow in GridView5.Rows)
                                {
                                    CheckBox chk = (CheckBox)gvrow.FindControl("Link");
                                    Label lblID = (Label)gvrow.FindControl("ID");
                                    Label lblEquipment = (Label)gvrow.FindControl("EquipmentName");

                                    RecipeEquipmentInsertView newEquipment = new RecipeEquipmentInsertView();
                                    newEquipment.EquipmentId = lblID.Text;
                                    newEquipment.Link = chk.Checked;
                                    newEquipment.RecipeId = Int32.Parse(idRecipNew);
                                    newEquipment.OperationId = recipe.OperationId;
                                    crud = recipeService.insertRecipeEquipment(newEquipment);
                                }

                                clearFields();
                            }
                        }
                    }
                    else
                    {
                        this.Page.ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('All parameter values must be numbers')", true);
                    }

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