//Llenado de la lista de CorporateCRUD private AddCorporateCRUD FillCorporateCRUD() { AddCorporateCRUD corporateCRUD = new AddCorporateCRUD { Corporative = txtCorporate.Text, ToolOnline = cmbTools.Text, Attribute1 = txtDKPrincipal.Text, PCC = txtPCC.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 = DateTime.Now, InsertBy = Convert.ToInt32(ConfigurationManager.AppSettings["DatosContacto"].Split('|')[1]), FechaUpdate = CadenaODateTime(null), UpdateBy = Convert.ToInt32(null) }; return(corporateCRUD); }
public static void AddCorporateCRUD(AddCorporateCRUD addCorporateCRUD) { AddCorporateCRUDDAL objAddCorporateCRUD = new AddCorporateCRUDDAL(); try { try { objAddCorporateCRUD.AddCorporateCRUD(addCorporateCRUD, CommonENT.MYCTSDB_CONNECTION); } catch (Exception ex) { new EventsManager.EventsManager(ex, EventsManager.EventsManager.OrigenError.BaseDeDatos); objAddCorporateCRUD.AddCorporateCRUD(addCorporateCRUD, CommonENT.MYCTSDBBACKUP_CONNECTION); } } catch { } }
public void AddCorporateCRUD(AddCorporateCRUD addCorporateCRUD, string connectionName) { Database db = DatabaseFactory.CreateDatabase(connectionName); DbCommand dbcomand = db.GetStoredProcCommand(Resources.AddCorporateCRUDResources.SP_ADDTOOLONLINERULES); db.AddInParameter(dbcomand, Resources.AddCorporateCRUDResources.PARAM_CORPORATIVE, DbType.String, addCorporateCRUD.Corporative); db.AddInParameter(dbcomand, Resources.AddCorporateCRUDResources.PARAM_TOOLONLINE, DbType.String, addCorporateCRUD.ToolOnline); db.AddInParameter(dbcomand, Resources.AddCorporateCRUDResources.PARAM_ATTRIBUTE1, DbType.String, addCorporateCRUD.Attribute1); db.AddInParameter(dbcomand, Resources.AddCorporateCRUDResources.PARAM_SUPERVISOR, DbType.String, addCorporateCRUD.Supervisor); db.AddInParameter(dbcomand, Resources.AddCorporateCRUDResources.PARAM_SUPAGENT, DbType.Int32, addCorporateCRUD.SupAgente); db.AddInParameter(dbcomand, Resources.AddCorporateCRUDResources.PARAM_PCC, DbType.String, addCorporateCRUD.PCC); db.AddInParameter(dbcomand, Resources.AddCorporateCRUDResources.PARAM_SUPSTATUS, DbType.String, addCorporateCRUD.SupStatus); db.AddInParameter(dbcomand, Resources.AddCorporateCRUDResources.PARAM_CONSULTOR1, DbType.String, addCorporateCRUD.Consultores[0].Consultor); db.AddInParameter(dbcomand, Resources.AddCorporateCRUDResources.PARAM_CONAGENT1, DbType.Int32, addCorporateCRUD.Consultores[0].Agent); db.AddInParameter(dbcomand, Resources.AddCorporateCRUDResources.PARAM_CONPCC1, DbType.String, addCorporateCRUD.Consultores[0].PCC); db.AddInParameter(dbcomand, Resources.AddCorporateCRUDResources.PARAM_CONSTATUS1, DbType.String, addCorporateCRUD.Consultores[0].Status); db.AddInParameter(dbcomand, Resources.AddCorporateCRUDResources.PARAM_CONSULTOR2, DbType.String, addCorporateCRUD.Consultores[1].Consultor); db.AddInParameter(dbcomand, Resources.AddCorporateCRUDResources.PARAM_CONAGENT2, DbType.Int32, addCorporateCRUD.Consultores[1].Agent); db.AddInParameter(dbcomand, Resources.AddCorporateCRUDResources.PARAM_CONPCC2, DbType.String, addCorporateCRUD.Consultores[1].PCC); db.AddInParameter(dbcomand, Resources.AddCorporateCRUDResources.PARAM_CONSTATUS2, DbType.String, addCorporateCRUD.Consultores[1].Status); db.AddInParameter(dbcomand, Resources.AddCorporateCRUDResources.PARAM_CONSULTOR3, DbType.String, addCorporateCRUD.Consultores[2].Consultor); db.AddInParameter(dbcomand, Resources.AddCorporateCRUDResources.PARAM_CONAGENT3, DbType.Int32, addCorporateCRUD.Consultores[2].Agent); db.AddInParameter(dbcomand, Resources.AddCorporateCRUDResources.PARAM_CONPCC3, DbType.String, addCorporateCRUD.Consultores[2].PCC); db.AddInParameter(dbcomand, Resources.AddCorporateCRUDResources.PARAM_CONSTATUS3, DbType.String, addCorporateCRUD.Consultores[2].Status); db.AddInParameter(dbcomand, Resources.AddCorporateCRUDResources.PARAM_CONSULTOR4, DbType.String, addCorporateCRUD.Consultores[3].Consultor); db.AddInParameter(dbcomand, Resources.AddCorporateCRUDResources.PARAM_CONAGENT4, DbType.Int32, addCorporateCRUD.Consultores[3].Agent); db.AddInParameter(dbcomand, Resources.AddCorporateCRUDResources.PARAM_CONPCC4, DbType.String, addCorporateCRUD.Consultores[3].PCC); db.AddInParameter(dbcomand, Resources.AddCorporateCRUDResources.PARAM_CONSTATUS4, DbType.String, addCorporateCRUD.Consultores[3].Status); db.AddInParameter(dbcomand, Resources.AddCorporateCRUDResources.PARAM_CONSULTOR5, DbType.String, addCorporateCRUD.Consultores[4].Consultor); db.AddInParameter(dbcomand, Resources.AddCorporateCRUDResources.PARAM_CONAGENT5, DbType.Int32, addCorporateCRUD.Consultores[4].Agent); db.AddInParameter(dbcomand, Resources.AddCorporateCRUDResources.PARAM_CONPCC5, DbType.String, addCorporateCRUD.Consultores[4].PCC); db.AddInParameter(dbcomand, Resources.AddCorporateCRUDResources.PARAM_CONSTATUS5, DbType.String, addCorporateCRUD.Consultores[4].Status); db.AddInParameter(dbcomand, Resources.AddCorporateCRUDResources.PARAM_FECHAINSERT, DbType.DateTime, addCorporateCRUD.FechaInsert); db.AddInParameter(dbcomand, Resources.AddCorporateCRUDResources.PARAM_INSERTBY, DbType.Int32, addCorporateCRUD.InsertBy); db.AddInParameter(dbcomand, Resources.AddCorporateCRUDResources.PARAM_FECHAUPDATE, DbType.DateTime, addCorporateCRUD.FechaUpdate); db.AddInParameter(dbcomand, Resources.AddCorporateCRUDResources.PARAM_UPDATEBY, DbType.Int32, addCorporateCRUD.UpdateBy); 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); } } } } }