public async Task <IActionResult> OnGetAsync(int?id) { if (id == null) { return(NotFound()); } maestro = await _context.maestro.FirstOrDefaultAsync(m => m.ID == id); if (maestro == null) { return(NotFound()); } return(Page()); }
public async Task <IActionResult> OnPostAsync(int?id) { if (id == null) { return(NotFound()); } maestro = await _context.maestro.FindAsync(id); if (maestro != null) { _context.maestro.Remove(maestro); await _context.SaveChangesAsync(); } return(RedirectToPage("./Index")); }
private void rellenar(Dictionary <string, object> diccinario) { if (this.InvokeRequired) { metodoEnviar delegado = new metodoEnviar(rellenar); this.Invoke(delegado, new Object[] { diccinario }); } else { dbaseORM orm = new dbaseORM(); maestro = orm.getObject <maestro>(diccinario); txtNumerobuscar.Text = $"{maestro.jpp}{maestro.num}"; this.jpp = maestro.jpp; this.num = Convert.ToString(maestro.num); txtNum.Text = Convert.ToString(maestro.num); txtRfc.Text = maestro.rfc; txtNombre.Text = maestro.nombre; txtDireccion.Text = maestro.domicilio; txtCat.Text = maestro.categ; txtTel.Text = maestro.telefono; txtSexo.Text = maestro.sexo; txtEle.Text = maestro.nomelec; txtProyecto.Text = maestro.proyecto; txtFin.Text = globales.parseDateTime(maestro.fching); txtLeyenda.Text = maestro.leyen; txtNCuenta.Text = maestro.cuentabanc; txtBanco.Text = maestro.banco; txtImss.Text = maestro.imss; txtCurp.Text = maestro.curp; txtFirma.Text = maestro.superviven; txtFecha.Text = globales.parseDateTime(maestro.fsupervive); jpp = maestro.jpp; string queryhuella = $"select huella from nominas_catalogos.maestro where jpp = '{maestro.jpp}' AND num = {maestro.num} "; List <Dictionary <string, object> > result = globales.consulta(queryhuella); string huella = Convert.ToString(result[0]["huella"]); this.huella_xml = huella; if (!string.IsNullOrWhiteSpace(huella)) { label25.Visible = true; } else { label25.Visible = false; } string query = $"select * from nominas_catalogos.supervive where jpp = '{maestro.jpp}' AND numjpp = {maestro.num} ORDER BY ANIO "; List <supervive> listasupervive = orm.queryForList <supervive>(query); dtggrid.Rows.Clear(); listasupervive.ForEach(datos => { string periodo = string.Empty; switch (datos.periodo) { case 1: periodo = "01 AL 21 DE ENERO"; break; case 2: periodo = "01 AL 21 DE MAYO"; break; case 3: periodo = "01 AL 21 DE SEPTIEMBRE"; break; default: break; } dtggrid.Rows.Add(datos.anio, periodo, globales.parseDateTime(datos.fecha)); }); query = $"select * from nominas_catalogos.supervive where jpp = '{maestro.jpp}' AND numjpp = {maestro.num} AND ANIO = {DateTime.Now.Year} AND PERIODO = {txtsupervive_periodo.SelectedIndex + 1}"; List <Dictionary <string, object> > total = globales.consulta(query); if (total.Count != 0) { exito.Visible = true; no.Visible = false; } else { exito.Visible = false; no.Visible = true; } if (huellita) { btnP_hipote_Click(null, null); huellita = false; } if (!noimprimir) { // button6_Click(null, null); } noimprimir = false; } }
private void rellenar(Dictionary <string, object> diccinario) { supervive.Visible = true; dbaseORM orm = new dbaseORM(); maestro = orm.getObject <maestro>(diccinario); txtNumerobuscar.Text = $"{maestro.jpp}{maestro.num}"; this.jpp = maestro.jpp; this.num = Convert.ToString(maestro.num); txtNum.Text = Convert.ToString(maestro.num); txtRfc.Text = maestro.rfc; txtNombre.Text = maestro.nombre; txtDireccion.Text = maestro.domicilio; txtCat.Text = maestro.categ; txtTel.Text = maestro.telefono; txtSexo.Text = maestro.sexo; txtEle.Text = maestro.nomelec; txtProyecto.Text = maestro.proyecto; txtFin.Text = globales.parseDateTime(maestro.fching); txtLeyenda.Text = maestro.leyen; txtNCuenta.Text = maestro.cuentabanc; txtBanco.Text = maestro.banco; txtImss.Text = maestro.imss; txtCurp.Text = maestro.curp; txtFirma.Text = maestro.superviven; txtFecha.Text = globales.parseDateTime(maestro.fsupervive); preview.Visible = true; int periodo = 0; if (DateTime.Now.Month >= 1 && DateTime.Now.Month < 5) { periodo = 1; label27.Text = $"PERIODO 01 A 21 MAYO DEL {DateTime.Now.Year}"; label27.BackColor = Color.LightBlue; label29.Text = $"PERIODO 01 A 21 SEPTIEMBRE DEL {DateTime.Now.Year}"; label29.BackColor = Color.LightBlue; label26.Text = "PROXIMOS"; label26.BackColor = Color.LightBlue; label28.Text = "PROXIMOS"; label28.BackColor = Color.LightBlue; string query = $"select * from nominas_catalogos.supervive where jpp = '{maestro.jpp}' AND numjpp = {maestro.num} and anio = {DateTime.Now.Year} and periodo = 1 ORDER BY periodo "; List <supervive> listasupervive = orm.queryForList <supervive>(query); bool encontrado = listasupervive.Any(o => o.periodo == 1); if (encontrado) { label25.Text = $"PERIODO 01 A 21 ENERO DEL {DateTime.Now.Year}"; label25.BackColor = Color.LightGreen; label24.Text = "FIRMADO"; label24.BackColor = Color.LightGreen; pictureBox5.Visible = true; pictureBox6.Visible = false; } else { label25.Text = $"PERIODO 01 A 21 ENERO DEL {DateTime.Now.Year}"; label25.BackColor = Color.Pink; label24.Text = "NO FIRMADO"; label24.BackColor = Color.Pink; pictureBox5.Visible = false; pictureBox6.Visible = true; } } else if (DateTime.Now.Month >= 5 && DateTime.Now.Month < 9) { periodo = 2; label29.Text = $"PERIODO 01 A 21 SEPTIEMBRE DEL {DateTime.Now.Year}"; label29.BackColor = Color.LightBlue; label28.Text = "PROXIMOS"; label28.BackColor = Color.LightBlue; string query = $"select * from nominas_catalogos.supervive where jpp = '{maestro.jpp}' AND numjpp = {maestro.num} and anio = {DateTime.Now.Year} and periodo in (1,2) ORDER BY periodo "; List <supervive> listasupervive = orm.queryForList <supervive>(query); bool encontrado = listasupervive.Any(o => o.periodo == 1); if (encontrado) { label25.Text = $"PERIODO 01 A 21 ENERO DEL {DateTime.Now.Year}"; label25.BackColor = Color.LightGreen; label24.Text = "FIRMADO"; label24.BackColor = Color.LightGreen; pictureBox5.Visible = true; pictureBox6.Visible = false; } else { label25.Text = $"PERIODO 01 A 21 ENERO DEL {DateTime.Now.Year}"; label25.BackColor = Color.Pink; label24.Text = "NO FIRMADO"; label24.BackColor = Color.Pink; pictureBox5.Visible = false; pictureBox6.Visible = true; } encontrado = listasupervive.Any(o => o.periodo == 2); if (encontrado) { label27.Text = $"PERIODO 01 A 21 MAYO DEL {DateTime.Now.Year}"; label27.BackColor = Color.LightGreen; label26.Text = "FIRMADO"; label26.BackColor = Color.LightGreen; pictureBox7.Visible = true; pictureBox8.Visible = false; } else { label27.Text = $"PERIODO 01 A 21 MAYO DEL {DateTime.Now.Year}"; label27.BackColor = Color.Pink; label26.Text = "NO FIRMADO"; label26.BackColor = Color.Pink; pictureBox7.Visible = false; pictureBox8.Visible = true; } } else { periodo = 3; string query = $"select * from nominas_catalogos.supervive where jpp = '{maestro.jpp}' AND numjpp = {maestro.num} and anio = {DateTime.Now.Year} and periodo in (1,2,3) ORDER BY periodo "; List <supervive> listasupervive = orm.queryForList <supervive>(query); bool encontrado = listasupervive.Any(o => o.periodo == 1); if (encontrado) { label25.Text = $"PERIODO 01 A 21 ENERO DEL {DateTime.Now.Year}"; label25.BackColor = Color.LightGreen; label24.Text = "FIRMADO"; label24.BackColor = Color.LightGreen; pictureBox5.Visible = true; pictureBox6.Visible = false; } else { label25.Text = $"PERIODO 01 A 21 ENERO DEL {DateTime.Now.Year}"; label25.BackColor = Color.Pink; label24.Text = "NO FIRMADO"; label24.BackColor = Color.Pink; pictureBox5.Visible = false; pictureBox6.Visible = true; } encontrado = listasupervive.Any(o => o.periodo == 2); if (encontrado) { label27.Text = $"PERIODO 01 A 21 MAYO DEL {DateTime.Now.Year}"; label27.BackColor = Color.LightGreen; label26.Text = "FIRMADO"; label26.BackColor = Color.LightGreen; pictureBox7.Visible = true; pictureBox8.Visible = false; } else { label27.Text = $"PERIODO 01 A 21 MAYO DEL {DateTime.Now.Year}"; label27.BackColor = Color.Pink; label26.Text = "NO FIRMADO"; label26.BackColor = Color.Pink; pictureBox7.Visible = false; pictureBox8.Visible = true; } encontrado = listasupervive.Any(o => o.periodo == 3); if (encontrado) { label29.Text = $"PERIODO 01 A 21 MAYO DEL {DateTime.Now.Year}"; label29.BackColor = Color.LightGreen; label28.Text = "FIRMADO"; label28.BackColor = Color.LightGreen; pictureBox9.Visible = true; pictureBox10.Visible = false; } else { label29.Text = $"PERIODO 01 A 21 MAYO DEL {DateTime.Now.Year}"; label29.BackColor = Color.Pink; label28.Text = "NO FIRMADO"; label28.BackColor = Color.Pink; pictureBox9.Visible = false; pictureBox10.Visible = true; } } sacarPanelAnterior(DateTime.Now.Year - 1); }