public DataSet GetAll(string empresaid, tb_sys_dominio BE) { using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid))) { using (SqlCommand cmd = new SqlCommand("gspTbSysDominio_SEARCH", cnx)) { DataSet ds = new DataSet(); { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@dominioid", SqlDbType.Char, 2).Value = BE.dominioid; cmd.Parameters.Add("@dominioname", SqlDbType.VarChar, 50).Value = BE.dominioname; } try { cnx.Open(); using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { da.Fill(ds); } return ds; } catch (Exception ex) { throw new Exception(ex.Message); } } } }
public bool Delete(string empresaid, tb_sys_dominio BE) { using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid))) { using (SqlCommand cmd = new SqlCommand("gspTbSysDominio_DELETE", cnx)) { { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@dominioid", SqlDbType.Char, 2).Value = BE.dominioid; } try { cnx.Open(); if (cmd.ExecuteNonQuery() > 0) { return true; } else { return false; } } catch (Exception ex) { throw new Exception(ex.Message); } } } }
public DataSet GetAll_paginacion(string empresaid, tb_sys_dominio BE) { return tablaDA.GetAll_paginacion(empresaid, BE); }
public bool Delete(string empresaid, tb_sys_dominio BE) { return tablaDA.Delete(empresaid, BE); }
private void get_cbo_modulo() { sys_dominioBL BL = new sys_dominioBL(); tb_sys_dominio BE = new tb_sys_dominio(); 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); } }
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() { 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 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); } }
public bool Update(string empresaid, tb_sys_dominio BE) { return tablaDA.Update(empresaid, BE); }
public DataSet GetAll_tienda(string empresaid, tb_sys_dominio BE) { using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid))) { using (SqlCommand cmd = new SqlCommand("gspTbSysDominio_SEARCH_tienda", cnx)) { DataSet ds = new DataSet(); { cmd.CommandType = CommandType.StoredProcedure; } try { cnx.Open(); using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { da.Fill(ds); } return ds; } catch (Exception ex) { throw new Exception(ex.Message); } } } }
private void get_cbo_modulo() { sys_dominioWebBL BL = new sys_dominioWebBL(); tb_sys_dominio BE = new tb_sys_dominio(); DataTable dt = new DataTable(); try { dt = BL.GetAllDominioModuloPorUsuario(Session["ssEmpresaID"].ToString(), Session["ssUsuar"].ToString().Trim(), cbo_dominio.SelectedValue).Tables[0]; cbo_modulo.DataSource = dt; cbo_modulo.DataValueField = "moduloid"; cbo_modulo.DataTextField = "moduloname"; cbo_modulo.DataBind(); } catch (Exception ex) { ClientMessage(ex.Message); } get_dominio_modulo_local(cbo_dominio.SelectedValue, cbo_modulo.SelectedValue); }
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 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); } }
public DataSet GetAll_tienda(string empresaid, tb_sys_dominio BE) { return tablaDA.GetAll_tienda(empresaid, BE); }
public bool Insert(string empresaid, tb_sys_dominio BE) { return tablaDA.Insert(empresaid, BE); }
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 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 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); } }