public string cambiarCodigo(JObject codigos) { string viejoCodigo = codigos["codigo"].ToString();; string nuevoCodigo = codigos["nuevoCodigo"].ToString(); if (!existeProducto(nuevoCodigo)) { try { using (GestionEntities bd = new GestionEntities()) { bd.Database.ExecuteSqlCommand("exec CambioCodStk '" + viejoCodigo + "','" + nuevoCodigo + "'"); } return("true"); } catch (Exception e) { return("error"); } } else { return("Existe"); } }
internal stock getProductoCod(string codpro) { using (GestionEntities bd = new GestionEntities()) { return(bd.Database.SqlQuery <stock>("select * from stock where codpro like '" + codpro + "'").Single()); } }
public List <ComprobanteAdeudado> getComprobantesAdeudados(int nrocli, int empresa) { using (GestionEntities bd = new GestionEntities()) { return(bd.Database.SqlQuery <ComprobanteAdeudado>( "select fecha, tipodoc, letra, punto, numero,simdoc mon,importe1 importe, importe2 adeudado, vence, simbolo, cotizacion " + " from clictad " + "where empresa = " + empresa + " and nrocli = " + nrocli).ToList()); } }
public RequestHTTP getProductos(string value, int empid, int offset) { var req = new RequestHTTP(); try { List <Producto> lista; using (GestionEntities bd = new GestionEntities()) { bd.Database.CommandTimeout = 30; if (value == "0") { lista = bd.Database.SqlQuery <Producto>( "select pathfoto, stock.codpro, stock.descri, oferta, boniprod, incluido, ivaart.porcen1, envases.descri AS descriEnvase," + " envases.codigo AS codEnvase, envases.simbolo AS simboloEnvase, isnull(stk.saldo,0) saldo " + "FROM stock " + "LEFT OUTER JOIN ivaart ON ivaart.codigo = stock.ivagrupo " + "LEFT OUTER JOIN envases ON envases.id = stock.envase " + "LEFT OUTER JOIN SaldoSTKALL(" + empid + ") AS stk ON stk.codpro = stock.codpro" ).ToList(); } else { lista = bd.Database.SqlQuery <Producto>( "select pathfoto, stock.id, stock.codpro, stock.descri, oferta, boniprod, incluido, ivaart.porcen1, envases.descri AS descriEnvase," + " envases.codigo AS codEnvase, envases.simbolo AS simboloEnvase, isnull(stk.saldo,0) saldo " + "FROM stock " + "LEFT OUTER JOIN ivaart ON ivaart.codigo = stock.ivagrupo " + "LEFT OUTER JOIN envases ON envases.id = stock.envase " + "LEFT OUTER JOIN SaldoSTKALL(" + empid + ") AS stk ON stk.codpro = stock.codpro " + "where stock.codpro like '%" + value + "%' or stock.descri like '%" + value + "%' " + "order by descri " + "offset " + offset + " rows fetch next 20 row only" ).ToList(); } } foreach (var prod in lista) { if (prod.pathfoto != "") { prod.pathfoto = acortarPath(prod.pathfoto); } if (prod.pathfoto == "") { prod.pathfoto = "empty"; } } req.objeto = lista; return(req); } catch (Exception e) { return(req.falla(e)); } }
public itemProducto(decimal cant, string descri, decimal precioVenta, decimal total, decimal bonif, decimal bonif1, decimal impint, string codpro, string[] artasoc) { this.cant = cant; this.descri = descri; this.precioVenta = precioVenta; this.total = total; this.bonif = bonif; this.bonif1 = bonif1; this.impint = impint; this.codpro = codpro; this.asociado = artasoc; using (GestionEntities bd = new GestionEntities()) this.codigo = bd.Database.SqlQuery <string>("select moneda from stock where codpro like '" + this.codpro + "'").First(); }
public bool existeProducto(string codigo) { using (GestionEntities bd = new GestionEntities()) { if (bd.stock.Where(a => a.codpro == codigo).Count() >= 1) { return(true); } else { return(false); } } }
internal bool verificarComprobante(int idClicta, string usuario) { try { using (GestionEntities bd = new GestionEntities()) { bd.Database.ExecuteSqlCommand("update clicta set verifi = 1, verifico = '" + usuario + "' where id = " + idClicta); return(true); } } catch (Exception e) { return(false); } }
public static bool comprobarToken(string miToken) { using (GestionEntities bd = new GestionEntities()) { string token = bd.token.Single().token1; if (miToken == token) { return(true); } else { return(false); } } }
internal RequestHTTP getDisponibles(string codpro, int empresa) { try { var req = new RequestHTTP(); using (GestionEntities bd = new GestionEntities()) { req.objeto = bd.Database.SqlQuery <ComprometidoProducto>("select * from ComprometidoporProducto(" + empresa + ") where Producto like '" + codpro + "'").Single(); return(req); } }catch (Exception e) { return(new RequestHTTP().falla(e)); } }
public bool productoUnico(string value, int empid) { try { using (GestionEntities bd = new GestionEntities()) { if (bd.stocksF(empid).Where(a => a.codpro.Contains(value) || a.descri.Contains(value)).Count() == 1) { return(true); } else { return(false); } } }catch (Exception e) { return(false); } }
internal List <PedidoDet> getPresupDLikePedido(int idPresup) { presupc cabPresup; //cabecera presup List <presupd> dPresup; //detalle de presup List <PedidoDet> dPed = new List <PedidoDet>(); // detalle de pedidod cliente clien; decimal bonifcliTotal = 0; using (GestionEntities bd = new GestionEntities()) { cabPresup = bd.presupc.Single(cab => cab.id == idPresup); //busca la presupC para la moenda de factura dPresup = bd.presupd.Where(det => det.cabeceraid == idPresup).ToList(); // busca la presupd clien = bd.cliente.Single(cliente => cliente.nrocli == cabPresup.nrocli); } int i = 0; bonifcliTotal = 100 - ((clien.bonif * 100) / 100); bonifcliTotal = bonifcliTotal - ((clien.bonif1 * bonifcliTotal) / 100); bonifcliTotal = bonifcliTotal - ((clien.bonif2 * bonifcliTotal) / 100); bonifcliTotal = bonifcliTotal - ((clien.bonif3 * bonifcliTotal) / 100); bonifcliTotal = bonifcliTotal - ((clien.bonif4 * bonifcliTotal) / 100); bonifcliTotal = 100 - bonifcliTotal; stocks stock; var pCab = new PedidoCab(); pCab.monfac = cabPresup.monfac; pCab.id = 1111111111; foreach (var pre in dPresup)// por cada articulo de presup agrega uno al pedido { i++; stock = new stocks(pre.cant, pre.precio, pre.bonif, pre.bonif1, pre.impint, pre.codpro, pre.asociado, bonifcliTotal, pre.fecha, pre.deta, cabPresup.empresa); dPed.Add(new PedidoDet(stock, pCab, i)); } return(dPed); }
//usado en items pedidos public itemProducto getProducto(int idprod, int lista, int empid) { // try // { decimal precioLista; List <artasoc> artaso; List <string> arta = new List <string>(); var prod = inicializarProductos(empid); Dictionary <string, object> p = productos.FirstOrDefault(dic => Convert.ToInt32(dic.Single(elem => elem.Key == "id").Value) == idprod); string codpro = p.Single(a => a.Key == "codpro").Value.ToString(); using (GestionEntities bd = new GestionEntities()) artaso = bd.artasoc.Where(a => a.codpro == codpro).ToList(); foreach (artasoc q in artaso) { arta.Add(q.componen); } switch (lista) { case 1: precioLista = (decimal)p.Single(a => a.Key == "precio1").Value; break; case 2: precioLista = (decimal)p.Single(a => a.Key == "precio2").Value;; break; case 3: precioLista = (decimal)p.Single(a => a.Key == "precio3").Value;; break; case 4: precioLista = (decimal)p.Single(a => a.Key == "precio4").Value;; break; case 5: precioLista = (decimal)p.Single(a => a.Key == "precio5").Value;; break; case 6: precioLista = (decimal)p.Single(a => a.Key == "precio6").Value; break; default: precioLista = (decimal)p.Single(a => a.Key == "costo").Value; break; } string descri = p.Single(a => a.Key == "descri").Value.ToString(); decimal impint = (decimal)p.Single(a => a.Key == "impint").Value; itemProducto ip = new itemProducto(1, descri, precioLista, 0, 0, 0, impint, codpro, arta.ToArray()); return(ip); /* } * catch (Exception) * { * var p = new itemProducto(); * p.codpro = "no existe"; * return p; * }*/ }