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