public AltaUsuario(dbmanager db, decimal usrId) { InitializeComponent(); this.db = db; comboTipoUsuario(1); this.usrId = usrId; // busar el usuario a modificar Boolean existeR = this.db.Consultar("select u.Id,u.Username,u.Password,u.Estado,u.Tipos_usuario_Id from CAMPUS_ANALYTICA.Usuario u where u.Id = " + usrId); if (existeR) { this.db.Leer(); tbUsername.Text = this.db.ObtenerValor("Username"); tbPassword.Text = "********"; cbTipoCliente.SelectedValue = Int16.Parse(this.db.ObtenerValor("Tipos_usuario_Id")); Habilitado = Char.Parse(this.db.ObtenerValor("Estado").ToString()); } //tbUsername.Enabled = false; aceptar.Text = "Editar"; if (Habilitado == 'A') { cbhabilitado.Checked = true; } else { cbhabilitado.Checked = false; } }
public generarFactura(dbmanager db, string username, int empId) { InitializeComponent(); this.db = db; this.username = username; this.empId = empId; }
public AltaUsuario(dbmanager db) { InitializeComponent(); this.db = db; comboTipoUsuario(0); tbPassword.Text = pass; }
public Form1(dbmanager dbMng) { this.db = dbMng; InitializeComponent(); CargaCombo(); this.tbComisionGradoPublicacion.Text = CargarComision(Decimal.Parse(this.cbGradoPublicaccion.SelectedValue.ToString())); }
public ListaRol(dbmanager db, String username) { InitializeComponent(); this.db = db; this.username = username; this.cargaGrilla(); }
public Publicaciones(dbmanager dbMng, String usr) { InitializeComponent(); this.db = dbMng; this.usr = usr; cargarGrilla(); }
public lista(dbmanager db) { this.db = db; InitializeComponent(); this.CargaCombos(); }
public event delegar pasarRol; // Se define el evento que va a pasar valor al form llamador. public SelRol(dbmanager db, String username) { InitializeComponent(); this.db = db; this.username = username; this.CargaRoles(); }
public HistrorialCliente(dbmanager dbMng, string cliente) { InitializeComponent(); this.db = dbMng; this.nombreUsuario = cliente; cargaGrilla(); }
public AltaEmpresa(dbmanager db, Decimal emp_id) { InitializeComponent(); this.db = db; this.Empresa_Id = emp_id; Boolean existeR; //buscar la empresa a modificar existeR = this.db.Consultar("SELECT e.[Id],[Razon_social],[Mail], isnull([Telefono], 0) as telefono,[CUIT],[Estado], e.[Fecha_alta],d.Calle,d.Codigo_postal,d.Piso,d.Depoto,d.Localidad FROM[GD2C2018].[CAMPUS_ANALYTICA].[Empresa] e join CAMPUS_ANALYTICA.EmpresaDireccion" + " on Empresa_id = e.Id join CAMPUS_ANALYTICA.Direccion d on Direccion_id = d.Id where e.Id =" + emp_id); if (existeR) { this.db.Leer(); tbRazonSocial.Text = this.db.ObtenerValor("Razon_social"); tbMail.Text = this.db.ObtenerValor("Mail"); tbTelefono.Text = this.db.ObtenerValor("telefono"); tbCuit.Text = this.db.ObtenerValor("CUIT"); tbCalle.Text = this.db.ObtenerValor("Calle"); tbnroPiso.Text = this.db.ObtenerValor("Piso"); tbLocalidad.Text = this.db.ObtenerValor("Localidad"); tbcodPostal.Text = this.db.ObtenerValor("Codigo_postal"); char cliHabilitado = Char.Parse(this.db.ObtenerValor("Estado")); if (cliHabilitado == 'A') { cbHabilitado.Checked = true; } else { cbHabilitado.Checked = false; } } aceptar.Text = "Editar"; }
public DataTable loadData(string createQuery, string execQuery, string server, string name) { dbmanager manager = new dbmanager(); manager.create(createQuery, server, name); return(manager.execQuery(execQuery)); }
public ListadoCliente(dbmanager db) { InitializeComponent(); this.db = db; cargaGrilla(); CargaCombo(); }
public Ubicaciones(dbmanager dbMng, Decimal idPublicacion) { InitializeComponent(); this.db = dbMng; this.publicacionId = idPublicacion; cargarComboTipoUbicacacion(); cargarGrilla(); }
public pagarCompra(dbmanager db, string username, int ubiId, generarCompra generarCompra) { InitializeComponent(); this.db = db; this.username = username; this.ubiId = ubiId; this.generarCompra = generarCompra; }
void populate() { dbmanager manager = new dbmanager(); manager.create(Lcreate, "supportfiles.db3", "location"); DataTable Dt = manager.execQuery("SELECT * FROM location "); listBox1.DisplayMember = "Location"; listBox1.DataSource = Dt; }
private void Button2_Click(object sender, EventArgs e) { String value = listBox1.GetItemText(listBox1.SelectedItem); dbmanager manager = new dbmanager(); manager.create(Lcreate, "supportfiles.db3", "location"); DataTable Dt = manager.execQuery("Delete From location Where Location like '%" + value + "%'"); populate(); }
public Add() { InitializeComponent(); dbmanager manager = new dbmanager(); manager.create(Lcreate, "supportfiles.db3", "location"); DataTable Dt = manager.execQuery("SELECT * FROM location "); location.DisplayMember = "Location"; location.DataSource = Dt; }
public AltaPublicacion(dbmanager dbmanager, String usr) { InitializeComponent(); this.db = dbmanager; this.tbLocalidades.Text = "0"; this.Usr = usr; cargarCombos(); this.mbEspectaculo.MaxSelectionCount = 1; this.mbEspectaculo.SelectionStart = todayDateTime; this.pickerHora.CustomFormat = "hh:mm"; this.pickerHora.Format = System.Windows.Forms.DateTimePickerFormat.Time; this.pickerHora.ShowUpDown = true; this.mcPublicacion.MaxSelectionCount = 1; }
//para alta desde modulo cliente o empresa public AltaUsuario(dbmanager db, int tipoCliente, decimal id) { InitializeComponent(); this.db = db; comboTipoUsuario(tipoCliente - 1); if (tipoCliente == 3) { this.cliId = id; } else { this.empId = id; } tbPassword.Text = pass; }
private void Button1_Click(object sender, EventArgs e) { dbmanager manager = new dbmanager(); manager.create(Lcreate, "supportfiles.db3", "location"); String input = Interaction.InputBox("Enter Location", "", "", -1, -1); if (input != "") { DataTable Dt = manager.execQuery("Insert Into location(Location) Values('" + input + "')"); populate(); } else { } }
public AltaPublicacion(dbmanager dbmanager, decimal id, String usr) { InitializeComponent(); this.idPublicacion = id; this.db = dbmanager; this.Usr = usr; cargarCombos(); inicializar(); this.mbEspectaculo.MaxSelectionCount = 1; this.mcPublicacion.MaxSelectionCount = 1; habilitarControlesLocalidades(); cargarGrilla(); cargarComboTipoUbicacacion(); cargarCantLocalidades(); this.pickerHora.CustomFormat = "hh:mm"; this.pickerHora.Format = System.Windows.Forms.DateTimePickerFormat.Time; this.pickerHora.ShowUpDown = true; }
public DarDeAltaRol(dbmanager db, Decimal rol_id, Char rolHabilitado)//modificación { InitializeComponent(); this.db = db; this.cargaGrillaFuncionalidades(); //para mostrar que funcionalidades tiene actualmente , se busca y se marca for (int j = 0; j < this.funcionalidades.Items.Count; j++) { Boolean existe = false; String funcionalidadNombre = this.funcionalidades.Items[j].ToString(); existe = this.db.Consultar("SELECT f.Id FROM CAMPUS_ANALYTICA.ROL_FUNCIONALIDAD rf JOIN CAMPUS_ANALYTICA.FUNCIONALIDAD f ON rf.Funcionalidad_Id = f.Id WHERE rf.Rol_Id = " + rol_id + " AND f.Nombre = '" + funcionalidadNombre.Trim() + "'"); if (existe) { this.funcionalidades.SetItemChecked(j, true); } else { this.funcionalidades.SetItemChecked(j, false); } } // TILDA LAS FUNCIONALIDADES QUE TIENE EL ROL ACTUALMENTE Boolean existeR = this.db.Consultar("SELECT Nombre FROM CAMPUS_ANALYTICA.ROL WHERE Id = " + rol_id); if (existeR) { this.db.Leer(); nombre.Text = this.db.ObtenerValor("Nombre"); } nombre.Enabled = false; aceptar.Text = "Editar"; if (rolHabilitado == 'A') { active.Checked = true; } else { active.Checked = false; } }
public Login(dbmanager db) { this.db = db; InitializeComponent(); }
public PanelPuntaje(dbmanager db, String username) { this.db = db; this.username = username; InitializeComponent(); }
public facturarEmpresa(dbmanager db, String username) { InitializeComponent(); this.db = db; this.username = username; }
public DarDeAltaRol(dbmanager db) { InitializeComponent(); this.db = db; this.cargaGrillaFuncionalidades(); }
public listaEmpresa(dbmanager db) { InitializeComponent(); this.db = db; cargaGrilla(); }
public AltaEmpresa(dbmanager db) { InitializeComponent(); this.db = db; }
public bajaCliente(dbmanager db, Decimal id) { InitializeComponent(); this.db = db; this.cliId = id; }
public BajaUsuario(dbmanager db, Decimal userID) { InitializeComponent(); this.db = db; this.usuarioId = userID; }