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