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