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