//Llenado de lista para la tabla de ToolOnlineRulesDelete private AddToolOnlineRulesDelete FillDeleteCorporate() { AddToolOnlineRulesDelete deleteCorporate = new AddToolOnlineRulesDelete { Corporative = txtCorporate.Text, ToolOnline = cmbTools.Text, Attribute1 = txtDKPrincipal.Text, Supervisor = txtSupervisor.Text, SupAgente = Convert.ToInt32(txtFirmSupervisor.Text), SupStatus = chkAvailable.Checked.ToString(), Consultores = new List <ConsultorCRUD> { new ConsultorCRUD(txtConsultan1.Text, CadenaAEnteroONulo(txtFirmConsultant1.Text), txtPCC1.Text, chkAvailable1.Checked.ToString()), new ConsultorCRUD(txtConsultant2.Text, CadenaAEnteroONulo(txtFirmConsultant2.Text), txtPCC2.Text, chkAvailable2.Checked.ToString()), new ConsultorCRUD(txtConsultant3.Text, CadenaAEnteroONulo(txtFirmConsultant3.Text), txtPCC3.Text, chkAvailable3.Checked.ToString()), new ConsultorCRUD(txtConsultant4.Text, CadenaAEnteroONulo(txtFirmConsultant4.Text), txtPCC4.Text, chkAvailable4.Checked.ToString()), new ConsultorCRUD(txtConsultant5.Text, CadenaAEnteroONulo(txtFirmConsultant5.Text), txtPCC5.Text, chkAvailable5.Checked.ToString()) }, FechaInsert = list[0].FechaInsert, InsertBy = list[0].InsertBy, FechaUpdate = list[0].FechaUpdate, UpdateBy = list[0].UpdateBy, FechaDelete = DateTime.Now, DeleteBy = Convert.ToInt32(ConfigurationManager.AppSettings["DatosContacto"].Split('|')[1]) }; return(deleteCorporate); }
public static void AddCorporateDelete(AddToolOnlineRulesDelete addCorporateDelete) { AddToolOnlineRulesDeleteDAL objAddCorporateDelete = new AddToolOnlineRulesDeleteDAL(); try { try { objAddCorporateDelete.AddCorporateDelete(addCorporateDelete, CommonENT.MYCTSDB_CONNECTION); } catch (Exception ex) { new EventsManager.EventsManager(ex, EventsManager.EventsManager.OrigenError.BaseDeDatos); objAddCorporateDelete.AddCorporateDelete(addCorporateDelete, CommonENT.MYCTSDBBACKUP_CONNECTION); } } catch { } }
public void AddCorporateDelete(AddToolOnlineRulesDelete addCorporateDelete, string connectionName) { Database db = DatabaseFactory.CreateDatabase(connectionName); DbCommand dbcomand = db.GetStoredProcCommand(Resources.AddToolOnlineRulesDeleteResources.SP_ADDTOOLONLINERULESDELETE); db.AddInParameter(dbcomand, Resources.AddToolOnlineRulesDeleteResources.PARAM_CORPORATIVE, DbType.String, addCorporateDelete.Corporative); db.AddInParameter(dbcomand, Resources.AddToolOnlineRulesDeleteResources.PARAM_TOOLONLINE, DbType.String, addCorporateDelete.ToolOnline); db.AddInParameter(dbcomand, Resources.AddToolOnlineRulesDeleteResources.PARAM_ATTRIBUTE1, DbType.String, addCorporateDelete.Attribute1); db.AddInParameter(dbcomand, Resources.AddToolOnlineRulesDeleteResources.PARAM_PCC, DbType.String, addCorporateDelete.PCC); db.AddInParameter(dbcomand, Resources.AddToolOnlineRulesDeleteResources.PARAM_SUPERVISOR, DbType.String, addCorporateDelete.Supervisor); db.AddInParameter(dbcomand, Resources.AddToolOnlineRulesDeleteResources.PARAM_SUPAGENT, DbType.Int32, addCorporateDelete.SupAgente); db.AddInParameter(dbcomand, Resources.AddToolOnlineRulesDeleteResources.PARAM_SUPSTATUS, DbType.String, addCorporateDelete.SupStatus); db.AddInParameter(dbcomand, Resources.AddToolOnlineRulesDeleteResources.PARAM_CONSULTOR1, DbType.String, addCorporateDelete.Consultores[0].Consultor); db.AddInParameter(dbcomand, Resources.AddToolOnlineRulesDeleteResources.PARAM_CONAGENT1, DbType.Int32, addCorporateDelete.Consultores[0].Agent); db.AddInParameter(dbcomand, Resources.AddToolOnlineRulesDeleteResources.PARAM_CONPCC1, DbType.String, addCorporateDelete.Consultores[0].PCC); db.AddInParameter(dbcomand, Resources.AddToolOnlineRulesDeleteResources.PARAM_CONSTATUS1, DbType.String, addCorporateDelete.Consultores[0].Status); db.AddInParameter(dbcomand, Resources.AddToolOnlineRulesDeleteResources.PARAM_CONSULTOR2, DbType.String, addCorporateDelete.Consultores[1].Consultor); db.AddInParameter(dbcomand, Resources.AddToolOnlineRulesDeleteResources.PARAM_CONAGENT2, DbType.Int32, addCorporateDelete.Consultores[1].Agent); db.AddInParameter(dbcomand, Resources.AddToolOnlineRulesDeleteResources.PARAM_CONPCC2, DbType.String, addCorporateDelete.Consultores[1].PCC); db.AddInParameter(dbcomand, Resources.AddToolOnlineRulesDeleteResources.PARAM_CONSTATUS2, DbType.String, addCorporateDelete.Consultores[1].Status); db.AddInParameter(dbcomand, Resources.AddToolOnlineRulesDeleteResources.PARAM_CONSULTOR3, DbType.String, addCorporateDelete.Consultores[2].Consultor); db.AddInParameter(dbcomand, Resources.AddToolOnlineRulesDeleteResources.PARAM_CONAGENT3, DbType.Int32, addCorporateDelete.Consultores[2].Agent); db.AddInParameter(dbcomand, Resources.AddToolOnlineRulesDeleteResources.PARAM_CONPCC3, DbType.String, addCorporateDelete.Consultores[2].PCC); db.AddInParameter(dbcomand, Resources.AddToolOnlineRulesDeleteResources.PARAM_CONSTATUS3, DbType.String, addCorporateDelete.Consultores[2].Status); db.AddInParameter(dbcomand, Resources.AddToolOnlineRulesDeleteResources.PARAM_CONSULTOR4, DbType.String, addCorporateDelete.Consultores[3].Consultor); db.AddInParameter(dbcomand, Resources.AddToolOnlineRulesDeleteResources.PARAM_CONAGENT4, DbType.Int32, addCorporateDelete.Consultores[3].Agent); db.AddInParameter(dbcomand, Resources.AddToolOnlineRulesDeleteResources.PARAM_CONPCC4, DbType.String, addCorporateDelete.Consultores[3].PCC); db.AddInParameter(dbcomand, Resources.AddToolOnlineRulesDeleteResources.PARAM_CONSTATUS4, DbType.String, addCorporateDelete.Consultores[3].Status); db.AddInParameter(dbcomand, Resources.AddToolOnlineRulesDeleteResources.PARAM_CONSULTOR5, DbType.String, addCorporateDelete.Consultores[4].Consultor); db.AddInParameter(dbcomand, Resources.AddToolOnlineRulesDeleteResources.PARAM_CONAGENT5, DbType.Int32, addCorporateDelete.Consultores[4].Agent); db.AddInParameter(dbcomand, Resources.AddToolOnlineRulesDeleteResources.PARAM_CONPCC5, DbType.String, addCorporateDelete.Consultores[4].PCC); db.AddInParameter(dbcomand, Resources.AddToolOnlineRulesDeleteResources.PARAM_CONSTATUS5, DbType.String, addCorporateDelete.Consultores[4].Status); db.AddInParameter(dbcomand, Resources.AddToolOnlineRulesDeleteResources.PARAM_FECHAINSERT, DbType.DateTime, addCorporateDelete.FechaInsert); db.AddInParameter(dbcomand, Resources.AddToolOnlineRulesDeleteResources.PARAM_INSERTBY, DbType.Int32, addCorporateDelete.InsertBy); db.AddInParameter(dbcomand, Resources.AddToolOnlineRulesDeleteResources.PARAM_FECHAUPDATE, DbType.DateTime, addCorporateDelete.FechaUpdate); db.AddInParameter(dbcomand, Resources.AddToolOnlineRulesDeleteResources.PARAM_UPDATEBY, DbType.Int32, addCorporateDelete.UpdateBy); db.AddInParameter(dbcomand, Resources.AddToolOnlineRulesDeleteResources.PARAM_FECHADELETE, DbType.DateTime, addCorporateDelete.FechaDelete); db.AddInParameter(dbcomand, Resources.AddToolOnlineRulesDeleteResources.PARAM_DELETEBY, DbType.Int32, addCorporateDelete.DeleteBy); db.ExecuteNonQuery(dbcomand); }
//Realizar cada una de las reglas en especifico private void Commands() { if (optionSelected == Resources.Constants.CORPORATE_CRUD_HIGH) { if (IsValidateExistDK) { MessageBox.Show(Resources.Constants.YA_EXISTE_DK, Resources.Constants.MYCTS, MessageBoxButtons.OK, MessageBoxIcon.Information); txtDKPrincipal.Focus(); } else if (!IsValidateExistDK) { try { AddCorporateCRUD corporateCRUD = FillCorporateCRUD(); AddCorporateCRUDBL.AddCorporateCRUD(corporateCRUD); MessageBox.Show(Resources.Constants.CORPORATIVO_REGISTRADO, Resources.Constants.MYCTS, MessageBoxButtons.OK, MessageBoxIcon.Information); ClearControls(); } catch (Exception ex) { MessageBox.Show(Resources.Constants.HUBO_UN_ERROR_AL_INGRESAR_DATOS, Resources.Constants.MYCTS, MessageBoxButtons.OK, MessageBoxIcon.Information); } } } else if (optionSelected == Resources.Constants.CORPORATE_CRUD_MODIFICATION) { if (rdoBuscar.Checked) { if (IsValidateExistDK) { SeeInformation(); txtDKPrincipal.Focus(); } } else if (rdoModificar.Checked) { if (IsValidateBusinessRules) { try { UpdateCorporateCRUD updateCRUD = FillUpdateCorporate(); UpdateCoporateCRUDBL.UpdateCorporateCRUD(updateCRUD); MessageBox.Show(Resources.Constants.CAMBIOS_SOLICITADOS_SATISFACTORIOS, Resources.Constants.MYCTS, MessageBoxButtons.OK, MessageBoxIcon.Information); ClearControls(); } catch (Exception ex) { MessageBox.Show(Resources.Constants.HA_OCURRIDO_ERROR_MODIFICA, Resources.Constants.MYCTS, MessageBoxButtons.OK, MessageBoxIcon.Information); } } } } else if (optionSelected == Resources.Constants.CORPORAT_CRUD_DROP) { if (rdoBuscar.Checked) { if (IsValidateExistDK) { SeeInformation(); } } else if (rdoModificar.Checked) { DialogResult result = MessageBox.Show(Resources.Constants.MENSAJE_EMILINACION, Resources.Constants.MYCTS, MessageBoxButtons.YesNo, MessageBoxIcon.Exclamation); if (result == DialogResult.Yes) { try { AddToolOnlineRulesDelete deleteRules = FillDeleteCorporate(); AddToolOnlineRulesDeleteBL.AddCorporateDelete(deleteRules); DeleteToolOnlineRulesBL.DeleteToolOnlineRules(attribute1); MessageBox.Show(Resources.Constants.ELIMINACION_SOLICITADA_SATISFACTORIA, Resources.Constants.MYCTS, MessageBoxButtons.OK, MessageBoxIcon.Information); ClearControls(); } catch (Exception ex) { MessageBox.Show(Resources.Constants.HA_CORRUDIO_UN_ERRO_ELIMINAR, Resources.Constants.MYCTS, MessageBoxButtons.OK, MessageBoxIcon.Information); } } } } }