internal static object SaveUsuario(tbUserEmpaque us)
{
try
{
using (var contex = new AuditoriaEntities())
{
var cont = contex.tbUserEmpaque.FirstOrDefault(x => x.nombreUsuario.Equals(us.nombreUsuario));
if (cont == null)
{
contex.tbUserEmpaque.Add(us);
contex.SaveChanges();
return(1);
}
else
{
return(2);
}
}
}
catch (Exception ex)
{
string mess = ex.Message;
return(0);
}
}
private async Task <string> ActualizarEstado(string codigoBarra)
{
try
{
var resp = await Task.Run(() =>
{
using (var contex = new AuditoriaEntities())
{
var obj = contex.tbBultosCodigosBarra.Find(codigoBarra);
obj.estado = "Impreso";
obj.fechaImpreso = contex.ExtraefechaServidor(1).First();
contex.SaveChanges();
return("Exito");
}
});
return(resp);
}
catch (Exception ex)
{
string mes = ex.Message;
return("Error");
}
}
internal static int DelUsuario(tbUserEmpaque us)
{
try
{
using (var contex = new AuditoriaEntities())
{
var obj = contex.tbUserEmpaque.First(x => x.nombreUsuario.Equals(us.nombreUsuario));
contex.tbUserEmpaque.Remove(obj);
contex.SaveChanges();
return(1);
}
}
catch (Exception ex)
{
string ee = ex.Message;
return(0);
}
}
private void txtticket_KeyUp(object sender, KeyEventArgs e)
{
try
{
if (e.Key == Key.Enter)
{
if (txtticket.Text.Trim().Equals("11101"))
{
txtoperario.Clear();
txtticket.Clear();
txtoperario.Focus();
return;
}
if (comboBihorario.SelectedValue.ToString() == "0" || comboLinea.SelectedValue.ToString() == "0" || idemp == 0)
{
lblEstadoTicket.Content = "Debe Seleccionar Linea, Bihorario ó Asignar Operario";
txtticket.Clear();
txtticket.Focus();
return;
}
Limpiar();
var cadena = txtticket.Text.Trim();// txtticket.Text.Substring(txtticket.Text);
var chart = cadena.Substring(0, 1);
var serial = chart == "0" ? cadena.Substring(1, cadena.Length - 1) : cadena;
var sql = " select s.prodno,s.serialno,o.operno,s.bundleno,o.descr,o.ctdescr,linenumber,plant,b.qty" +
" from serial2 s inner join oper o on s.operno = o.operno " +
" inner join prod p on s.prodno = p.prodno" +
" inner join bundle b on b.prodno = p.prodno" +
" where s.serialno = '" + serial + "' and b.bundleno = s.bundleno";
lblTicketLeido.Content = serial;
var lista = new List <Pervasives>();
var dt = Pervasive_PSQL.GetDataTable(sql);
if (dt.Rows.Count == 0)
{
txtticket.Text = string.Empty;
txtticket.Focus();
lblEstadoTicket.Content = "El codigo no existe, Advertencia";
}
else
{
foreach (DataRow item in dt.Rows)
{
var obj = new Pervasives
{
Prodno = item.ItemArray[0].ToString(),
Serialno = item.ItemArray[1].ToString(),
Operno = item.ItemArray[2].ToString(),
Bundleno = Convert.ToInt16(item.ItemArray[3].ToString()),
Descr = item.ItemArray[4].ToString(),
Ctdescr = item.ItemArray[5].ToString(),
BundleUni = Convert.ToInt32(item.ItemArray[8].ToString())
};
lista.Add(obj);
}
if (lista.Count > 0)
{
lblCorte.Content = lista[0].Prodno;
lblBulto.Content = lista[0].Bundleno.ToString();
lblEstilo.Content = lista[0].Serialno;
lbloperacion.Content = lista[0].Descr;
lblUnidades.Content = lista[0].BundleUni;
using (AuditoriaEntities contex = new AuditoriaEntities())
{
var serial2 = dt.Rows[0][1].ToString().TrimEnd();
var band = contex.tbProduccionTickets.Where(x => x.serial.Equals(serial2)).FirstOrDefault();
if (band == null)
{
var newobjS = new tbProduccionTickets()
{
serial = serial2, // dt.Rows[0][1].ToString(),
codigoOperacion = dt.Rows[0][5].ToString(),
descOperacion = dt.Rows[0][4].ToString(),
corte = dt.Rows[0][0].ToString(),
nSeq = Convert.ToInt16(dt.Rows[0][3].ToString()),
linea = dt.Rows[0][6].ToString(),
fechaRegistro = DateTime.Now,
usuario = emp,
operarioId = idemp,
BundleUni = Convert.ToInt32(dt.Rows[0][8].ToString()),
bihorario = Convert.ToInt16(comboBihorario.SelectedValue.ToString()),
lineaConfeccion = Convert.ToInt16(comboLinea.SelectedValue.ToString())
};
contex.tbProduccionTickets.Add(newobjS);
contex.SaveChanges();
txtticket.Text = string.Empty;
txtticket.Focus();
lblEstadoTicket.Content = "Agregado Correctamente";
// MensajeVoz("Lectura Exitosa");
}
else
{
txtticket.Text = string.Empty;
txtticket.Focus();
lblEstadoTicket.Content = "Lectura Duplicada";
// MensajeVoz("Lectura Duplicada");
}
var listadb = contex.spdProduccionOperarioDiario(idemp).ToList();
lbltotal.Content = listadb.Count.ToString();
lbltotalBihorario.Content = comboBihorario.SelectedValue.ToString() == "0"
?
listadb.Where(x => x.bihorario == listadb.Max(z => z.bihorario)).Count().ToString()
:
listadb.Where(x => x.bihorario == Convert.ToInt16(comboBihorario.SelectedValue.ToString())).Count().ToString();
gridCodigos.ItemsSource = listadb;
}
}
else
{
txtticket.Text = string.Empty;
txtticket.Focus();
lblEstadoTicket.Content = "El codigo no existe, Advertencia";
}
}
}
}
catch (Exception ex)
{
lblEstadoTicket.Content = ex.Message;
txtticket.Text = string.Empty;
txtticket.Focus();
// MensajeVoz(ex.Message);
}
}
private void txtoperario_KeyUp(object sender, KeyEventArgs e)
{
try
{
if (e.Key == Key.Enter)
{
limpiarOper();
var operario = txtoperario.Text.Trim().ToLower();
var sql = "select top 1 empno,estatus,module,lastname,firstname,badgeno,loc1,loc2 from employee where badgeno = '" + operario + "'";
var dt = Pervasive_PSQL.GetDataTable(sql);
if (dt.Rows.Count == 0)
{
txtoperario.Text = string.Empty;
txtoperario.Focus();
lblEstadoTicket.Content = "El operario " + operario + " no existe";
//MensajeVoz("El operario no existe!!!");
//MessageBox.Show("El operario no existe", "Advertencia");
}
else
{
var nombre = string.Concat(dt.Rows[0][4], " ", dt.Rows[0][3]).ToUpper().TrimEnd();
lblNombre.Content = nombre;//string.Concat(dt.Rows[0][4], " ", dt.Rows[0][3]);
lblCod.Content = dt.Rows[0][0].ToString();
lblModulo.Content = dt.Rows[0][6].ToString();
lblLinea.Content = dt.Rows[0][7].ToString();
txtoperario.Text = string.Empty;
txtticket.Focus();
lblEstadoTicket.Content = "Lectura Exitosa!!!";
// MensajeVoz("Lectura Exitosa!");
using (AuditoriaEntities contex = new AuditoriaEntities())
{
var codigobarra = dt.Rows[0][5].ToString().TrimEnd();
var obj = contex.Operario.Where(x => x.codigoBarra.ToUpper().Equals(codigobarra)).FirstOrDefault();
if (obj == null)
{
var objnew = new Operario
{
nombre = nombre,
codigo = dt.Rows[0][0].ToString(),
codigoBarra = dt.Rows[0][5].ToString(),
activo = true
};
contex.Operario.Add(objnew);
contex.SaveChanges();
idemp = objnew.id_operario;
}
else
{
obj.codigoBarra = dt.Rows[0][5].ToString();
obj.codigo = dt.Rows[0][0].ToString();
idemp = obj.id_operario;
}
contex.SaveChanges();
var listadb = contex.spdProduccionOperarioDiario(idemp).ToList();
lbltotal.Content = listadb.Count.ToString();
lbltotalBihorario.Content = comboBihorario.SelectedValue.ToString() == "0"
?
listadb.Where(x => x.bihorario == listadb.Max(z => z.bihorario)).Count().ToString()
:
listadb.Where(x => x.bihorario == Convert.ToInt16(comboBihorario.SelectedValue.ToString())).Count().ToString();
gridCodigos.ItemsSource = listadb;
}
}
}
}
catch (Exception ex)
{
lblEstadoTicket.Content = ex.Message;
/// MensajeVoz(ex.Message);
}
}
public async static Task <tbcodigosCajas> crearCaja(string estilo, string porder, string usuario)
{
try
{
var tarea1 = Task.Run(() =>
{
using (var contex1 = new AuditoriaEntities())
{
var resp = contex1.tbCorteSecuenciaCaja.Where(x => x.corte.Equals(porder.Trim())).Count();
return(resp);
}
});
var tarea2 = Task.Run(() =>
{
using (var contex1 = new AuditoriaEntities())
{
var resp = contex1.ExtraefechaServidor(1).ToArray();
return(resp);
}
});
var tarea3 = Task.Run(() =>
{
using (var contex1 = new AuditoriaEntities())
{
var resp = contex1.POrder
.Join(contex1.Bundle, x => x.Id_Order, y => y.Id_Order, (x, y) => new { x.POrderClient, y.Color, x.POrder1 })
.Where(x => x.POrderClient.Equals(porder))
.Select(x => new { x.Color, Porder = x.POrderClient }).Take(1).ToArray();
return(resp[0]);
}
});
await Task.WhenAll(tarea1, tarea2, tarea3);
using (var contex = new AuditoriaEntities())
{
var cont = tarea1.Result;
var sec = cont == 0 ? 1 : cont + 1;
var formato = "0000000000";
var subcadena = formato.Substring(0, 10 - porder.Trim().Length);
var codigo = string.Concat("999", subcadena, porder.Trim(), string.Format("{0:000}", sec));
var obj = new tbCorteSecuenciaCaja
{
codigo = codigo,
idcorte = 0,
sec = sec,
corte = porder.Trim()
};
contex.tbCorteSecuenciaCaja.Add(obj);
contex.SaveChanges();
var fecha = tarea2.Result;
var codigoNew = new tbcodigosCajas
{
codigoBox = codigo,
idCorte = 0,
estilo = estilo.TrimEnd(),
secBoxXCorte = sec,
fechaGenerado = fecha[0],
estado = true,
numeroImpresion = 0,
color = tarea3.Result.Color,
corteCompleto = porder,
usuario = usuario
};
contex.tbcodigosCajas.Add(codigoNew);
contex.SaveChanges();
return(codigoNew);
}
}
catch (Exception ex)
{
var sr = ex.Message;
// await crearCaja(idcorte, estilo,porder, usuario);
// throw;
return(null);
}
}
public static List <object> GuardarCodigos(List <CodigosDat> listaGuardar, string corte)
{
List <object> listObject = new List <object>();
try
{
using (var contex = new AuditoriaEntities())
{
using (var transaction = contex.Database.BeginTransaction())
{
try
{
var listaguardada = new List <CodigosDat>();
var fecha = contex.ExtraefechaServidor(1).ToArray();
var fe = Convert.ToDateTime(fecha[0]);
var registroCodigosBarra = new List <tbBultosCodigosBarra>();
foreach (var item in listaGuardar)
{
var cont = contex.tbBultosCodigosBarra.Where(x => x.corteCompleto.Contains(corte.Trim()) && x.secuenciaUnidades == item.NSeq).Count();
if (cont == 0)
{
contex.tbBultosCodigosBarra.Add(new tbBultosCodigosBarra
{
// idCorte = item.Id_Order,
codigoBarra = item.codigoBarra,
talla = item.Size,
secuenciaUnidades = item.NSeq,
fechaGenerado = fe,
estado = "Generado",
corteCompleto = corte,
Cantidad = item.Cantidad,
Restante = item.Resto
});
//item.POrder = corte;//opcional
listaguardada.Add(item);
}
}
contex.SaveChanges();
transaction.Commit();
listObject.Add(listaguardada);
listObject.Add(200);
return(listObject);
}
catch (Exception ex)
{
string mess = ex.Message;
transaction.Rollback();
listObject.Add(ex.Message);
listObject.Add(500);
return(listObject);
}
}
}
}
catch (Exception ex)
{
listObject.Add(ex.Message);
listObject.Add(500);
return(listObject);
}
}
