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