/*
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 Equipos para Recetas
Param: RecipeId,OperationId,EquipmentId,Link
Return: Status
*/
public String insertRecipeEquipment(RecipeEquipmentInsertView recipeEquipmentInsertView)
{
return context.InsertUpdateDeleteMSQL("EXEC insertRecipeEquipment @RecipeId= "+recipeEquipmentInsertView.RecipeId+", @OperationId= "+
recipeEquipmentInsertView.OperationId + ", @EquipmentId= '" + recipeEquipmentInsertView.EquipmentId + "', @Link= " + recipeEquipmentInsertView .Link+ ";");
}
/*Funcion: Insertar el equipo para una receta
Param: RecipeEquipmentInsertView, AuditDataFromWeb
Return: Status
*/
public CUDView insertRecipeEquipment(RecipeEquipmentInsertView recipeEquipmentInsertView, AuditDataFromWeb audit)
{
RecipeDao Dao = new RecipeDao();
String state = Dao.insertRecipeEquipment(recipeEquipmentInsertView);
CUDView logic = CUDVerifyLogic.verifierInsertDeleteUpdate("insert", state);
if (logic.insert == true)
{
AuditService auditservice = new AuditService();
String Action = "Insert recipe equipment";
String NewValues = "RecipeId: " + recipeEquipmentInsertView.RecipeId
+ ", EquipmentId: " + recipeEquipmentInsertView.EquipmentId
+ ", OperationId: " + recipeEquipmentInsertView.OperationId
+ ", Link: " + recipeEquipmentInsertView.Link;
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);
}
}