public ModificarAsignatura(int id)
{
InitializeComponent();
co = new ConnectOracle();
this.idA = id;
asig = co.buscarAsignatura(idA);
cbDescripcion.Text = asig.DESCRIPCION;
cbPrecio.Text = asig.PRECIO.ToString().Replace(",", ".");
}
public ModificarAlumno(int idA)
{
InitializeComponent();
this.id = idA;
co = new ConnectOracle();
al = co.buscarAlumno(id);
cbDNI.Text = al.DNI;
cbNom.Text = al.NOMBRE;
cbAp.Text = al.APELLIDO;
}
public AgregarGrupo()
{
InitializeComponent();
co = new ConnectOracle();
co.getAsignaturas();
ConnectOracle.AsigList.ForEach(x => this.cbAsig.Items.Add(x.DESCRIPCION));
co.getProfesores();
ConnectOracle.ProfeList.ForEach(x => this.cbProf.Items.Add(x.NOMBRE));
}
public CrearFactura(int idUs)
{
InitializeComponent();
this.idU = idUs;
co = new ConnectOracle();
cbAlum.Items.Clear();
co.getAlumnos();
ConnectOracle.AlumList.ForEach(x => this.cbAlum.Items.Add(x.DNI));
cbAlum.SelectedIndex = 0;
}
public VentanaTest()
{
InitializeComponent();
co = new ConnectOracle();
co.getAsignaturas();
this.cbAsig.Items.Add("Todos");
ConnectOracle.AsigList.ForEach(x => this.cbAsig.Items.Add(x.DESCRIPCION));
this.cbAsig.SelectedIndex = 0;
RefrescarTabla(cbAsig.SelectedIndex);
}
public static bool existsUser(String user)
{
ConnectOracle search = new ConnectOracle();
int resp = Convert.ToInt16(search.DLookUp("count(*)", "usuario", "UPPER(NAME)= '" + user.ToUpper() + "' AND DELETED=0"));
if (resp > 0)
{
return(true);
}
return(false);
}
public ModificarFactura(int idF)
{
InitializeComponent();
co = new ConnectOracle();
f = co.buscarFactura(idF);
tbCant.Text = f.cantidadSinImpuesto.ToString();
cbAlum.Items.Clear();
co.getAlumnos();
ConnectOracle.AlumList.ForEach(x => this.cbAlum.Items.Add(x.DNI));
cbAlum.SelectedIndex = f.idAlumno - 1;
}
public bool existsUser(String dni)
{
ConnectOracle search = new ConnectOracle();
int resp = Convert.ToInt16(search.DLookUp("count(*)", "empleados", "UPPER(dni)= '" + dni.ToUpper() + "' AND borrado=0"));
if (resp > 0)
{
return(true);
}
return(false);
}
public ModificarProfesor(int idA)
{
InitializeComponent();
this.id = idA;
co = new ConnectOracle();
pr = co.buscarProfesor(id);
cbDNI.Text = pr.DNI;
cbNom.Text = pr.NOMBRE;
cbAp.Text = pr.APELLIDO;
cbTitu.Text = pr.TITULACION;
}
private void getZipcodesCities()
{
String tables = " zipcodescities z inner join zipcodes zip on refzipcode=idzipcode " +
" inner join cities c on refcity=idcity " +
" inner join states s on refstate=idstate ";
String cond = " zipcode='" + cmbZIP.SelectedItem.ToString() + "' And city='" + cmbCity.SelectedItem.ToString() + "' And State= '" + cmbProv.SelectedItem.ToString() + "'";
ConnectOracle search = new ConnectOracle();
int resp = Convert.ToInt16(search.DLookUp("IDZIPCODESCITIES", tables, cond));
this.refzipcodescities = resp;
}
public static bool existProductOrders(String id)
{
bool exist = false;
ConnectOracle search = new ConnectOracle();
int resp = Convert.ToInt16(search.DLookUp("count(*)", "orders", "IDORDER= (Select REFORDER from ordersproducts Where REFPRODUCT ='" + id + "')"));
if (resp > 0)
{
exist = true;
}
return(exist);
}
public static bool existProduct(String name)
{
bool exist = false;
ConnectOracle search = new ConnectOracle();
int resp = Convert.ToInt16(search.DLookUp("count(*)", "products", "UPPER(NAME)= '" + name.ToUpper() + "' AND DELETED=0"));
if (resp > 0)
{
exist = true;
}
return(exist);
}
public static bool existCustomer(String id)
{
bool exist = false;
ConnectOracle search = new ConnectOracle();
int resp = Convert.ToInt16(search.DLookUp("count(*)", "orders", "REFCUSTOMER= '" + id + "' AND DELETED=0"));
if (resp > 0)
{
exist = true;
}
return(exist);
}
public static bool existDNI(String DNI)
{
bool exist = false;
ConnectOracle search = new ConnectOracle();
int resp = Convert.ToInt16(search.DLookUp("count(*)", "customers", "UPPER(DNI)= '" + DNI.ToUpper() + "' AND DELETED=0"));
if (resp > 0)
{
exist = true;
}
return(exist);
}
public CrearMatricula()
{
InitializeComponent();
co = new ConnectOracle();
co.getAlumnos();
ConnectOracle.AlumList.ForEach(x => this.cbAlum.Items.Add(x.DNI));
cbAlum.SelectedIndex = 0;
al = co.buscarAlumno(cbAlum.SelectedItem.ToString());
co.getGrupos(al.Id);
cbGrup.Items.Clear();
ConnectOracle.GrupList.ForEach(x => this.cbGrup.Items.Add(x.nombre));
}
public List <string> getCompositions()
{
List <string> values = new List <string>();
String sql = "SELECT DISTINCT COMPOSITION FROM COMPOSITIONS";
ConnectOracle con = new ConnectOracle();
DataSet ds = con.getData(sql, "COMPOSITIONS");
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
values.Add(ds.Tables[0].Rows[i]["COMPOSITION"].ToString());
}
return(values);
}
public List <string> getMeasures(string composition)
{
List <string> values = new List <string>();
String sql = "SELECT DISTINCT M.MEASURE FROM MEASURES M, PRODUCTS P, COMPOSITIONS C WHERE M.IDMEASURE = P.REFMEASURE AND P.REFCOMPOSITION = C.IDCOMPOSITION AND C.COMPOSITION='" + composition + "'";
ConnectOracle con = new ConnectOracle();
DataSet ds = con.getData(sql, "MEASURES");
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
values.Add(ds.Tables[0].Rows[i]["MEASURE"].ToString());
}
return(values);
}
public ModificarPregunta(int id)
{
InitializeComponent();
this.idP = id;
co = new ConnectOracle();
co.getAsignaturas();
ConnectOracle.AsigList.ForEach(x => this.cbAsig.Items.Add(x.DESCRIPCION));
pr = co.buscarPregunta(idP);
cbAsig.SelectedIndex = pr.idAsignatura - 1;
cbResC.SelectedIndex = pr.resCorrecta - 1;
tbPreg.Text = pr.pregunta;
tbRes1.Text = pr.respuesta1;
tbRes2.Text = pr.respuesta2;
tbRes3.Text = pr.respuesta3;
}
public ModificarMatricula(int idM)
{
InitializeComponent();
co = new ConnectOracle();
m = co.BuscarMatricula(idM);
a = co.buscarAlumno(m.idAlumno);
co.getAlumnos();
ConnectOracle.AlumList.ForEach(x => this.cbAlum.Items.Add(x.DNI));
cbAlum.SelectedItem = a.DNI;
al = co.buscarAlumno(cbAlum.SelectedItem.ToString());
co.getGrupos(al.Id);
cbGrup.Items.Clear();
ConnectOracle.GrupList.ForEach(x => this.cbGrup.Items.Add(x.nombre));
}
public VentanaHacerTest(int idT, int idA)
{
InitializeComponent();
lbContestada.Visible = false;
this.idTest = idT;
this.idAlum = idA;
co = new ConnectOracle();
listaP = co.getPreguntas(idTest);
p = listaP.ElementAt(pos);
respuestas = new List <int>();
for (int i = 0; i < listaP.Count; i++)
{
respuestas.Add(0);
}
ActualizarDatos(p);
}
public ModificarGrupo(int idG)
{
InitializeComponent();
co = new ConnectOracle();
Grupo gr = co.buscarGrupo(idG);
co.getAsignaturas();
ConnectOracle.AsigList.ForEach(x => this.cbAsig.Items.Add(x.DESCRIPCION));
cbAsig.SelectedIndex = gr.idAsig - 1;
co.getProfesores();
ConnectOracle.ProfeList.ForEach(x => this.cbProf.Items.Add(x.NOMBRE));
cbProf.SelectedIndex = gr.idProf - 1;
this.nombre = gr.nombre;
tbNom.Text = nombre;
numCap.Value = gr.capacidad;
this.idG = gr.id;
}
private DataTable llenaEmple()
{
DataSet data = new DataSet();
ConnectOracle search = new ConnectOracle();
DataTable tcustomers = new DataTable();
tcustomers.Columns.Add("dni", Type.GetType("System.String"));
tcustomers.Columns.Add("nombre", Type.GetType("System.String"));
tcustomers.Columns.Add("apellido", Type.GetType("System.String"));
data = search.getData("select dni, nombre, apellidos apellido from empleados where ID_EMPLE = " + idEmple, "exam");
DataTable tmp = data.Tables["exam"];
foreach (DataRow row in tmp.Rows)
{
tcustomers.Rows.Add(new Object[] { row["dni"], row["nombre"], row["apellido"] });
}
return(tcustomers);
}
public GestionarHorario()
{
InitializeComponent();
co = new ConnectOracle();
cbDia.SelectedIndex = 0;
co.getAulas();
ConnectOracle.AulasList.ForEach(x => this.cbAula.Items.Add(x.NOMBRE));
if (cbAula.Items.Count > 0)
{
cbAula.SelectedIndex = 0;
}
co.getGrupos();
ConnectOracle.GrupList.ForEach(x => this.cbGrupo.Items.Add(x.nombre));
if (cbGrupo.Items.Count > 0)
{
cbGrupo.SelectedIndex = 0;
}
RefrescarTabla();
}
private DataTable llenaPro()
{
DataSet data = new DataSet();
ConnectOracle search = new ConnectOracle();
DataTable tcustomers = new DataTable();
tcustomers.Columns.Add("cantidad", Type.GetType("System.String"));
tcustomers.Columns.Add("nombre", Type.GetType("System.String"));
tcustomers.Columns.Add("precio", Type.GetType("System.String"));
tcustomers.Columns.Add("total", Type.GetType("System.String"));
String sql1 = "select o.cantidad, p.nombre_producto nombre, o.precio, (o.cantidad * p.precio) total from pedidos_productos o inner join productos p on p.ID_PRODUCTO = o.ref_producto where o.ref_pedido = " + idPedido;
data = search.getData(sql1, "exam");
DataTable tmp = data.Tables["exam"];
foreach (DataRow row in tmp.Rows)
{
tcustomers.Rows.Add(new Object[] { row["cantidad"], row["nombre"], row["precio"], row["total"] });
}
return(tcustomers);
}
public static void insertCustomer(String sentencia)
{
ConnectOracle insert = new ConnectOracle();
insert.setData(sentencia);
}
public static void setData(String sentencia)
{
ConnectOracle update = new ConnectOracle();
update.setData(sentencia);
}
public static String getData(String column, String table, String cond)
{
ConnectOracle select = new ConnectOracle();
return(select.DLookUp(column, table, cond).ToString());
}
public VentanaAbonos()
{
InitializeComponent();
co = new ConnectOracle();
RefrescarTabla();
}
public InicioSesion()
{
InitializeComponent();
co = new ConnectOracle();
}
public VentanaProfesor()
{
InitializeComponent();
co = new ConnectOracle();
RefrescarTabla();
}
