/* 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); } }
/* Funcion: Inserta Nueva Receta Param: ProcessId,OperationId,RecipeStatusxs Return: PK,Status,Error */ public List<String> insertRecipe(RecipeInsertView recipe) { return context.insertPKReturnMSQL("EXEC insertRecipe @ProcessId =" + recipe.ProcessId + ", @OperationId =" + recipe.OperationId + ", @RecipeStatus ='" + recipe.RecipeEnable+ "'; "); }
/*Funcion: insertar una receta Param: RecipeInsertView,AuditDataFromWeb Return: Lista RecipeParameterView */ public CUDView insertRecipe(RecipeInsertView recipe, AuditDataFromWeb audit) { CUDView logic = new CUDView(); RecipeDao Dao = new RecipeDao(); int operationProcessID = 0; DataTable DaoResultIsTest = Dao.isTest(recipe.OperationId); foreach (DataRow row in DaoResultIsTest.Rows) { if (DaoResultIsTest.Columns.Contains("OperationProcessId") && row["OperationProcessId"] != DBNull.Value) { operationProcessID = Convert.ToInt32(row["OperationProcessId"]); } } if (operationProcessID == 0) { int countRecipeTest = 0; DataTable DaoResultCountRecipeTest = Dao.hasRecipeTest(); foreach (DataRow row in DaoResultCountRecipeTest.Rows) { if (DaoResultCountRecipeTest.Columns.Contains("RecipeTest") && row["RecipeTest"] != DBNull.Value) { countRecipeTest = Convert.ToInt32(row["RecipeTest"]); } } if (countRecipeTest > 0) { logic = CUDVerifyLogic.verifierInsertDeleteUpdate("insert", "There is already a recipe with 'test' operation."); } else { List<String> state = Dao.insertRecipe(recipe); logic = CUDVerifyLogic.verifierInsertPKReturnMSQL("insert", state); } } else { List<String> state = Dao.insertRecipe(recipe); logic = CUDVerifyLogic.verifierInsertPKReturnMSQL("insert", state); } if (logic.insert == true) { AuditService auditservice = new AuditService(); String Action = "Insert new recipe"; String NewValues = "RecipeId: " + logic.insertPK + ", RecipeEnable: " + recipe.RecipeEnable + ", OperationId: " + recipe.OperationId + ", ProcessId: " + recipe.ProcessId; 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); } }