//Llenado de lista de Actulizacion de CorporateCRUD
private UpdateCorporateCRUD FillUpdateCorporate()
{
UpdateCorporateCRUD updateCorporate = new UpdateCorporateCRUD
{
Corporative = txtCorporate.Text,
ToolOnline = cmbTools.Text,
Attribute1 = attribute1,
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 = list[0].FechaInsert,
InsertBy = list[0].InsertBy,
FechaUpdate = DateTime.Now,
UpdateBy = Convert.ToInt32(ConfigurationManager.AppSettings["DatosContacto"].Split('|')[1])
};
return(updateCorporate);
}
//Realiza la validacion y guarda cambios
private void btnAplicarCambios_Click(object sender, EventArgs e)
{
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);
}
}
}
public static void UpdateCorporateCRUD(UpdateCorporateCRUD updateCorporateCRUD)
{
UpdateCorporateCRUDDAL objUpdateCorporateCRUD = new UpdateCorporateCRUDDAL();
try
{
try
{
objUpdateCorporateCRUD.UpdateCorporateCRUD(updateCorporateCRUD, CommonENT.MYCTSDB_CONNECTION);
}
catch (Exception ex)
{
new EventsManager.EventsManager(ex, EventsManager.EventsManager.OrigenError.BaseDeDatos);
objUpdateCorporateCRUD.UpdateCorporateCRUD(updateCorporateCRUD, CommonENT.MYCTSDBBACKUP_CONNECTION);
}
}
catch { }
}
public void UpdateCorporateCRUD(UpdateCorporateCRUD updateCorporateCRUD, string connectionName)
{
Database db = DatabaseFactory.CreateDatabase(connectionName);
DbCommand dbcomand = db.GetStoredProcCommand(Resources.UpdateCorporateCRUDResources.SP_UPDATETOOLONLINERULES);
db.AddInParameter(dbcomand, Resources.UpdateCorporateCRUDResources.PARAM_CORPORATIVE, DbType.String, updateCorporateCRUD.Corporative);
db.AddInParameter(dbcomand, Resources.UpdateCorporateCRUDResources.PARAM_TOOLONLINE, DbType.String, updateCorporateCRUD.ToolOnline);
db.AddInParameter(dbcomand, Resources.UpdateCorporateCRUDResources.PARAM_ATTRIBUTE1, DbType.String, updateCorporateCRUD.Attribute1);
db.AddInParameter(dbcomand, Resources.UpdateCorporateCRUDResources.PARAM_SUPERVISOR, DbType.String, updateCorporateCRUD.Supervisor);
db.AddInParameter(dbcomand, Resources.UpdateCorporateCRUDResources.PARAM_SUPAGENT, DbType.Int32, updateCorporateCRUD.SupAgente);
db.AddInParameter(dbcomand, Resources.UpdateCorporateCRUDResources.PARAM_PCC, DbType.String, updateCorporateCRUD.PCC);
db.AddInParameter(dbcomand, Resources.UpdateCorporateCRUDResources.PARAM_SUPSTATUS, DbType.String, updateCorporateCRUD.SupStatus);
db.AddInParameter(dbcomand, Resources.UpdateCorporateCRUDResources.PARAM_CONSULTOR1, DbType.String, updateCorporateCRUD.Consultores[0].Consultor);
db.AddInParameter(dbcomand, Resources.UpdateCorporateCRUDResources.PARAM_CONAGENT1, DbType.Int32, updateCorporateCRUD.Consultores[0].Agent);
db.AddInParameter(dbcomand, Resources.UpdateCorporateCRUDResources.PARAM_CONPCC1, DbType.String, updateCorporateCRUD.Consultores[0].PCC);
db.AddInParameter(dbcomand, Resources.UpdateCorporateCRUDResources.PARAM_CONSTATUS1, DbType.String, updateCorporateCRUD.Consultores[0].Status);
db.AddInParameter(dbcomand, Resources.UpdateCorporateCRUDResources.PARAM_CONSULTOR2, DbType.String, updateCorporateCRUD.Consultores[1].Consultor);
db.AddInParameter(dbcomand, Resources.UpdateCorporateCRUDResources.PARAM_CONAGENT2, DbType.Int32, updateCorporateCRUD.Consultores[1].Agent);
db.AddInParameter(dbcomand, Resources.UpdateCorporateCRUDResources.PARAM_CONPCC2, DbType.String, updateCorporateCRUD.Consultores[1].PCC);
db.AddInParameter(dbcomand, Resources.UpdateCorporateCRUDResources.PARAM_CONSTATUS2, DbType.String, updateCorporateCRUD.Consultores[1].Status);
db.AddInParameter(dbcomand, Resources.UpdateCorporateCRUDResources.PARAM_CONSULTOR3, DbType.String, updateCorporateCRUD.Consultores[2].Consultor);
db.AddInParameter(dbcomand, Resources.UpdateCorporateCRUDResources.PARAM_CONAGENT3, DbType.Int32, updateCorporateCRUD.Consultores[2].Agent);
db.AddInParameter(dbcomand, Resources.UpdateCorporateCRUDResources.PARAM_CONPCC3, DbType.String, updateCorporateCRUD.Consultores[2].PCC);
db.AddInParameter(dbcomand, Resources.UpdateCorporateCRUDResources.PARAM_CONSTATUS3, DbType.String, updateCorporateCRUD.Consultores[2].Status);
db.AddInParameter(dbcomand, Resources.UpdateCorporateCRUDResources.PARAM_CONSULTOR4, DbType.String, updateCorporateCRUD.Consultores[3].Consultor);
db.AddInParameter(dbcomand, Resources.UpdateCorporateCRUDResources.PARAM_CONAGENT4, DbType.Int32, updateCorporateCRUD.Consultores[3].Agent);
db.AddInParameter(dbcomand, Resources.UpdateCorporateCRUDResources.PARAM_CONPCC4, DbType.String, updateCorporateCRUD.Consultores[3].PCC);
db.AddInParameter(dbcomand, Resources.UpdateCorporateCRUDResources.PARAM_CONSTATUS4, DbType.String, updateCorporateCRUD.Consultores[3].Status);
db.AddInParameter(dbcomand, Resources.UpdateCorporateCRUDResources.PARAM_CONSULTOR5, DbType.String, updateCorporateCRUD.Consultores[4].Consultor);
db.AddInParameter(dbcomand, Resources.UpdateCorporateCRUDResources.PARAM_CONAGENT5, DbType.Int32, updateCorporateCRUD.Consultores[4].Agent);
db.AddInParameter(dbcomand, Resources.UpdateCorporateCRUDResources.PARAM_CONPCC5, DbType.String, updateCorporateCRUD.Consultores[4].PCC);
db.AddInParameter(dbcomand, Resources.UpdateCorporateCRUDResources.PARAM_CONSTATUS5, DbType.String, updateCorporateCRUD.Consultores[4].Status);
db.AddInParameter(dbcomand, Resources.UpdateCorporateCRUDResources.PARAM_FECHAINSERT, DbType.DateTime, updateCorporateCRUD.FechaInsert);
db.AddInParameter(dbcomand, Resources.UpdateCorporateCRUDResources.PARAM_INSERTBY, DbType.Int32, updateCorporateCRUD.InsertBy);
db.AddInParameter(dbcomand, Resources.UpdateCorporateCRUDResources.PARAM_FECHAUPDATE, DbType.DateTime, updateCorporateCRUD.FechaUpdate);
db.AddInParameter(dbcomand, Resources.UpdateCorporateCRUDResources.PARAM_UPDATEBY, DbType.Int32, updateCorporateCRUD.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);
}
}
}
}
}
