/*Funcion: Crea una RecipeEquipment a partir de los datos de la base Param: DataTable Return: Lista RecipeEquipmentView */ public List<RecipeEquipmentView> buildEquipment(DataTable DaoResult) { List<RecipeEquipmentView> ViewList = new List<RecipeEquipmentView>(); foreach (DataRow row in DaoResult.Rows) { RecipeEquipmentView x = new RecipeEquipmentView(); if (DaoResult.Columns.Contains("EquipmentName") && row["EquipmentName"] != DBNull.Value) { x.EquipmentName = row["EquipmentName"].ToString(); } if (DaoResult.Columns.Contains("ID") && row["ID"] != DBNull.Value) { x.ID = row["ID"].ToString(); } if (DaoResult.Columns.Contains("Link") && row["Link"] != DBNull.Value) { x.Link = (bool)row["Link"]; } if (DaoResult.Columns.Contains("GroupId") && row["GroupId"] != DBNull.Value) { x.GroupId = Convert.ToInt32(row["GroupId"]); } if (DaoResult.Columns.Contains("RecipeEquipmentId") && row["RecipeEquipmentId"] != DBNull.Value) { x.RecipeEquipmentId = Convert.ToInt32(row["RecipeEquipmentId"]); } ViewList.Add(x); } return ViewList; }
/* Metodo para realizar una actualizacion de un recipe */ private void updateAuxiliar() { //Verifica que un recipe haya sido seleccionado if (HttpContext.Current.Session["IdRecipe"] != null) { if (validatetableParameterTwoForInt()) { //Crea el servicio RecipeService recipeService = new RecipeService(); RecipeUpdateView recipe = new RecipeUpdateView(); recipe.RecipeId = Int32.Parse(HttpContext.Current.Session["IdRecipe"].ToString()); recipe.RecipeEnable = recipeEnable.Items[0].Selected; String reason = Session["reason"].ToString(); String user = Context.User.Identity.Name; //Llena los datos de la auditoria AuditDataFromWeb audit = new AuditDataFromWeb(); audit.Reason = reason; audit.StationIP = General.getIp(this.Page); audit.UserName = user; //Realiza la actualización CUDView crud = recipeService.updateRecipe(recipe, audit); if (crud.update == true) { int idRecipe = Int32.Parse(HttpContext.Current.Session["IdRecipe"].ToString()); //Update Parameters foreach (GridViewRow gvrow in GridView1.Rows) { Label lblParameterId = (Label)gvrow.FindControl("ParameterId"); TextBox lblValue = (TextBox)gvrow.FindControl("Value"); if (lblValue.Text != "") { RecipeUpdateValueView newParameter = new RecipeUpdateValueView(); newParameter.ParameterValue = Int32.Parse(lblValue.Text); newParameter.RecipeId = idRecipe; newParameter.ParameterId = Int32.Parse(lblParameterId.Text); crud = recipeService.updateRecipeValue(newParameter, audit); } } //Update Equipments foreach (GridViewRow gvrow in GridView2.Rows) { CheckBox chk = (CheckBox)gvrow.FindControl("Link"); Label lblID = (Label)gvrow.FindControl("ID"); Label RecipeEquipmentId = (Label)gvrow.FindControl("RecipeEquipmentId"); RecipeEquipmentView newEquipment = new RecipeEquipmentView(); newEquipment.RecipeId = idRecipe; newEquipment.EquipmentId = lblID.Text; newEquipment.Link = chk.Checked; newEquipment.RecipeEquipmentId = Int32.Parse(RecipeEquipmentId.Text); crud = recipeService.updateRecipeEquipment(newEquipment, audit); } clearFields(); } else { this.Page.ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('" + crud.errorMessage + "')", true); } } else { this.Page.ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('All parameter values must be numbers')", true); } } }
/*Funcion: actualizar equipos de la receta Param: RecipeEquipmentView,AuditDataFromWeb Return: status */ public CUDView updateRecipeEquipment(RecipeEquipmentView recipe, AuditDataFromWeb audit) { AuditDao auditDao = new AuditDao(); DataTable auditDaoResult = auditDao.getRecipeEquipmentByRecipeEquipMentIdAndRecipeId(recipe.RecipeId, recipe.RecipeEquipmentId); String OldValues = "RecipeId: " + recipe.RecipeId; foreach (DataRow row in auditDaoResult.Rows) { if (auditDaoResult.Columns.Contains("RecipeEquipmentId") && row["RecipeEquipmentId"] != DBNull.Value) { OldValues = OldValues + ", RecipeEquipmentId: " + Convert.ToInt32(row["RecipeEquipmentId"]); } if (auditDaoResult.Columns.Contains("Link") && row["Link"] != DBNull.Value) { OldValues = OldValues + ", Link: " + (bool)row["Link"]; } } //Update RecipeDao Dao = new RecipeDao(); String state = Dao.updateRecipeEquipment(recipe); CUDView logic = CUDVerifyLogic.verifierInsertDeleteUpdate("update", state); //Fin update if (logic.update == true) { AuditService auditservice = new AuditService(); String Action = "Update recipe equipment"; String NewValues = "RecipeId: " + recipe.RecipeId + ", RecipeEquipmentId: " + recipe.RecipeEquipmentId + ", Link: " + recipe.Link; auditservice.formUpdate(Action, NewValues, OldValues, audit); } return logic; }
/* Funcion: Actualiza el equipo de una receta Param: RecipeId, RecipeEquipmentId,RecipeEquipmentLink Return: Status */ public String updateRecipeEquipment(RecipeEquipmentView recipeEquipment) { return context.InsertUpdateDeleteMSQL("EXEC updateRecipeEquipmentLink @RecipeId=" + recipeEquipment.RecipeId + " ,@RecipeEquipmentId=" + recipeEquipment.RecipeEquipmentId + " ,@link=" + recipeEquipment.Link + ""); }
private void updateAuxiliar() { if (HttpContext.Current.Session["IdRecipe"] != null) { if (validatetableParameterTwoForInt()) { string confirmValue = Request.Form["confirm_value"]; if (confirmValue == "Yes") { RecipeService recipeService = new RecipeService(); //Update Recipe bool enable1 = (GridView3.SelectedRow.FindControl("FirstRecipeEnable") as CheckBox).Checked; bool enable2 = (GridView3.SelectedRow.FindControl("SecondRecipeEnable") as CheckBox).Checked; RecipeUpdateView recipe = new RecipeUpdateView(); recipe.RecipeId = Int32.Parse(HttpContext.Current.Session["IdRecipe"].ToString()); recipe.RecipeEnable = recipeEnable.Items[0].Selected; recipe.FirstRecipeEnable = enable1; recipe.SecondRecipeEnable = enable2; //----------------it can crash CUDView crud = recipeService.updateRecipe(recipe); if (crud.update == true) { //Update Parameters foreach (GridViewRow gvrow in GridView1.Rows) { Label lblParameterId = (Label)gvrow.FindControl("ParameterId"); TextBox lblValue = (TextBox)gvrow.FindControl("Value"); if (lblValue.Text != "") { RecipeUpdateValueView newParameter = new RecipeUpdateValueView(); newParameter.ParameterValue = Int32.Parse(lblValue.Text); newParameter.RecipeId = Int32.Parse(HttpContext.Current.Session["IdRecipe"].ToString()); newParameter.ParameterId = Int32.Parse(lblParameterId.Text); crud = recipeService.updateRecipeValue(newParameter); } } //Update Equipments foreach (GridViewRow gvrow in GridView2.Rows) { CheckBox chk = (CheckBox)gvrow.FindControl("Link"); Label lblID = (Label)gvrow.FindControl("ID"); RecipeEquipmentView newEquipment = new RecipeEquipmentView(); newEquipment.RecipeId = Int32.Parse(HttpContext.Current.Session["IdRecipe"].ToString()); newEquipment.EquipmentId = lblID.Text; newEquipment.Link = chk.Checked; crud = recipeService.updateRecipeEquipment(newEquipment); } clearFields(); } else { this.Page.ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('" + crud.errorMessage + "')", true); } } } else { this.Page.ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('All parameter values must be numbers')", true); } } }