private void get_cbo_modulo()
{
var BL = new sys_dominioBL();
try
{
cbomodulo.DataSource = BL.GetAllDominioModuloPorUsuario(EmpresaID, VariablesPublicas.Usuar, dominio).Tables[0];
cbomodulo.ValueMember = "moduloid";
cbomodulo.DisplayMember = "moduloname";
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void ValidaDominio()
{
if (dominioid.Text.Trim().Length > 0)
{
sys_dominioBL BL = new sys_dominioBL();
tb_sys_dominio BE = new tb_sys_dominio();
DataTable dt = new DataTable();
BE.dominioid = dominioid.Text.Trim().PadLeft(2, '0');
dt = BL.GetAll(EmpresaID, BE).Tables[0];
if (dt.Rows.Count > 0)
{
dominioid.Text = dt.Rows[0]["dominioid"].ToString().Trim();
dominioname.Text = dt.Rows[0]["dominioname"].ToString().Trim();
}
else
{
dominioid.Text = "";
dominioname.Text = "";
}
}
else
{
dominioid.Text = "";
dominioname.Text = "";
}
}
private void fill_cboModuloid()
{
var BL = new sys_dominioBL();
try
{
cboModuloid.DataSource = BL.GetAllDominioModuloPorUsuario(VariablesPublicas.EmpresaID, VariablesPublicas.Usuar, "60").Tables[0];
cboModuloid.ValueMember = "moduloid";
cboModuloid.DisplayMember = "moduloname";
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
cboModuloid.SelectedValue = modulo;
if (cboModuloid.Items.Count > 0)
{
fill_cbolocal(dominio, cboModuloid.SelectedValue.ToString());
}
}
private void get_cbo_modulo2()
{
var BL = new sys_dominioBL();
var dt = new DataTable();
try
{
dt = BL.GetAllDominioModuloPorUsuario(VariablesPublicas.EmpresaID, VariablesPublicas.Usuar, "60").Tables[0];
if (dt.Rows.Count > 0)
{
cboModuloID2.DataSource = dt;
cboModuloID2.ValueMember = "moduloid";
cboModuloID2.DisplayMember = "moduloname";
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void get_cargarComboDominio()
{
sys_dominioBL BL = new sys_dominioBL();
tb_sys_dominio BE = new tb_sys_dominio();
DataTable dt = new DataTable();
Tdominio = BL.GetAllDominioPorUsuario(VariablesPublicas.EmpresaID, VariablesPublicas.Usuar).Tables[0];
if (Tdominio.Rows.Count > 0)
{
try
{
dt = BL.GetAllDominioPorUsuario(VariablesPublicas.EmpresaID, VariablesPublicas.Usuar).Tables[0];
cboDominioID.DataSource = dt;
cboDominioID.ValueMember = "dominioid";
cboDominioID.DisplayMember = "dominioname";
}
catch (Exception ex)
{
MessageBoxEx.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
get_cbo_modulo();
}
else
{
MessageBoxEx.Show("Usuario no tiene definido Dominio y Módulo... " + "\r" + "Consulte con Sistemas !!!", "Mensaje del Sistema", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
}
private void get_cbo_modulo()
{
sys_dominioBL BL = new sys_dominioBL();
tb_sys_dominio BE = new tb_sys_dominio();
DataTable dt = new DataTable();
try
{
dt = BL.GetAllDominioModuloPorUsuario(VariablesPublicas.EmpresaID, VariablesPublicas.Usuar, cboDominioID.SelectedValue.ToString()).Tables[0];
cboModuloID.DataSource = dt;
cboModuloID.ValueMember = "moduloid";
cboModuloID.DisplayMember = "moduloname";
}
catch (Exception ex)
{
MessageBoxEx.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
if (cboModuloID.Items.Count > 0)
{
get_dominio_modulo_local(cboDominioID.SelectedValue.ToString(), cboModuloID.SelectedValue.ToString());
}
}
private void get_cargarComboDominio()
{
var BL = new sys_dominioBL();
try
{
cboDominioID.DataSource = BL.GetAllDominioPorUsuario(VariablesPublicas.EmpresaID, VariablesPublicas.Usuar).Tables[0];
cboDominioID.ValueMember = "dominioid";
cboDominioID.DisplayMember = "dominioname";
if (_dominioid != null)
{
cboDominioID.SelectedValue = _dominioid;
get_cbo_modulo();
}
else
{
get_cbo_modulo();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void get_cbo_modulo()
{
var BL = new sys_dominioBL();
try
{
cboModuloID.DataSource = BL.GetAllDominioModuloPorUsuario(VariablesPublicas.EmpresaID, VariablesPublicas.Usuar, cboDominioID.SelectedValue.ToString()).Tables[0];
cboModuloID.ValueMember = "moduloid";
cboModuloID.DisplayMember = "moduloname";
if (_moduloid != null)
{
cboModuloID.SelectedValue = _moduloid;
if (cboModuloID.Items.Count > 0)
{
get_dominio_modulo_local(cboDominioID.SelectedValue.ToString(), cboModuloID.SelectedValue.ToString());
}
}
else
{
if (cboModuloID.Items.Count > 0)
{
get_dominio_modulo_local(cboDominioID.SelectedValue.ToString(), cboModuloID.SelectedValue.ToString());
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void ValidaDominio_nuevo()
{
var BL = new sys_dominioBL();
var BE = new tb_sys_dominio();
var dt = new DataTable();
BE.dominioid = dominioid.Text.Trim();
dt = BL.GetAll(EmpresaID, BE).Tables[0];
if (dt.Rows.Count == 0)
{
mensaje.Text = "VALIDO";
mensaje.ForeColor = Color.Green;
form_bloqueado(true);
dominioname.Focus();
btn_cancelar.Enabled = true;
btn_grabar.Enabled = true;
}
else
{
mensaje.Text = "YA EXISTE";
mensaje.ForeColor = Color.Red;
dominioid.Focus();
}
}
private void ValidaDominio()
{
if (dominioid.Text.Trim().Length > 0)
{
var BL = new sys_dominioBL();
var BE = new tb_sys_dominio();
var dt = new DataTable();
BE.dominioid = dominioid.Text.Trim().PadLeft(2, '0');
dt = BL.GetAll(EmpresaID, BE).Tables[0];
if (dt.Rows.Count > 0)
{
dominioid.Text = dt.Rows[0]["dominioid"].ToString().Trim();
dominioname.Text = dt.Rows[0]["dominioname"].ToString().Trim();
}
else
{
dominioid.Text = string.Empty;
dominioname.Text = string.Empty;
moduloid.Text = string.Empty;
moduloname.Text = string.Empty;
xlocal.Text = string.Empty;
localname.Text = string.Empty;
moduloid.Enabled = false;
xlocal.Enabled = false;
}
}
else
{
dominioid.Text = string.Empty;
dominioname.Text = string.Empty;
moduloid.Text = string.Empty;
moduloname.Text = string.Empty;
xlocal.Text = string.Empty;
localname.Text = string.Empty;
moduloid.Enabled = false;
xlocal.Enabled = false;
}
}
private void Update()
{
try
{
if (dominioid.Text.Trim().Length != 2)
{
MessageBox.Show("Ingrese Código de dominio", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
else
{
if (dominioname.Text.Trim().Length == 0)
{
MessageBox.Show("Ingrese nombre de Dominio", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
else
{
var BL = new sys_dominioBL();
var BE = new tb_sys_dominio();
BE.dominioid = dominioid.Text.Trim();
BE.dominioname = dominioname.Text.Trim().ToUpper();
if (BL.Update(EmpresaID, BE))
{
SEGURIDAD_LOG("M");
MessageBox.Show("Datos modificado correctamente !!!", "Confirmación", MessageBoxButtons.OK, MessageBoxIcon.Information);
procesado = true;
}
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void form_cargar_datos(String posicion)
{
try
{
var BL = new sys_dominioBL();
var BE = new tb_sys_dominio();
var dt = new DataTable();
BE.dominioid = dominioid.Text.Trim();
BE.posicion = posicion.Trim();
dt = BL.GetAll_paginacion(EmpresaID, BE).Tables[0];
if (dt.Rows.Count > 0)
{
ssModo = "EDIT";
limpiar_documento();
dominioid.Text = dt.Rows[0]["dominioid"].ToString().Trim();
dominioname.Text = dt.Rows[0]["dominioname"].ToString().Trim();
btn_editar.Enabled = true;
btn_eliminar.Enabled = true;
btn_imprimir.Enabled = true;
btn_primero.Enabled = true;
btn_anterior.Enabled = true;
btn_siguiente.Enabled = true;
btn_ultimo.Enabled = true;
btn_buscar.Enabled = true;
btn_log.Enabled = true;
btn_salir.Enabled = true;
}
else
{
limpiar_documento();
btn_editar.Enabled = false;
btn_eliminar.Enabled = false;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void Delete()
{
try
{
if (dominioid.Text.Trim().Length != 2)
{
MessageBox.Show("Ingrese Código de dominio", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
else
{
var BL = new sys_dominioBL();
var BE = new tb_sys_dominio();
BE.dominioid = dominioid.Text.Trim();
if (BL.Delete(EmpresaID, BE))
{
SEGURIDAD_LOG("E");
MessageBox.Show("Datos Eliminado correctamente !!!", "Confirmación", MessageBoxButtons.OK, MessageBoxIcon.Information);
NIVEL_FORMS();
limpiar_documento();
form_bloqueado(false);
data_Tabladominio();
btn_nuevo.Enabled = true;
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void data_Tabladominio()
{
try
{
if (Tabladominio != null)
{
Tabladominio.Rows.Clear();
}
var BL = new sys_dominioBL();
var BE = new tb_sys_dominio();
Tabladominio = BL.GetAll(EmpresaID, BE).Tables[0];
if (Tabladominio.Rows.Count > 0)
{
btn_imprimir.Enabled = true;
griddominio.DataSource = Tabladominio;
griddominio.Rows[0].Selected = false;
griddominio.Focus();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void data_cbo_dominio()
{
try
{
var BL = new sys_dominioBL();
var BE = new tb_sys_dominio();
dominioid.DataSource = BL.GetAll(EmpresaID, BE).Tables[0];
dominioid.ValueMember = "dominioid";
dominioid.DisplayMember = "dominioname";
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
