public RequestHTTP getElement(string query)
{
var diccionario = new Dictionary <string, object>();
string sql = query;
connection = new SqlConnection(connetionString);
var req = new RequestHTTP();
try
{
connection.Open();
command = new SqlCommand(sql, connection);
dataReader = command.ExecuteReader();
while (dataReader.Read())
{
for (int i = 0; i < dataReader.FieldCount; i++)
{
diccionario.Add(dataReader.GetName(i), dataReader.GetValue(i));
}
}
dataReader.Close();
command.Dispose();
connection.Close();
req.objeto = diccionario;
return(req);
}
catch (Exception e)
{
return(req.falla(e));
}
}
internal RequestHTTP getComprasProvee(int empresa, string desde, string hasta, int concepto, bool cotizacion)
{
var req = new RequestHTTP();
try
{
string ccCotiza = "and tipodoc <> 'CT'";
using (GestionEntities bd = new GestionEntities())
{
if (!cotizacion)
{
ccCotiza = "";
}
req.objeto = bd.Database.SqlQuery <comprasProveedores>(
"select max(nropro) nropro, max(razsoc) razsoc, sum(neto + neto1 + exento) total " +
"from ivacom " +
"where fecha >= '" + desde + "' and fecha <= '" + hasta + "' and concepto = " + concepto + " " + ccCotiza + " " +
"group by nropro " +
"order by total desc").ToList();
}
return(req);
}catch (Exception e)
{
return(req.falla(e));
}
}
public RequestHTTP finalizarPedido(JObject jCabYDet)
{
var req = new RequestHTTP();
try
{
var jCabecera = (JObject)jCabYDet["cabecera"];
int punto = (int)jCabecera["punto"],
empresa = (int)jCabecera["empresa"];
decimal bonifcli = (decimal)jCabYDet["bonifcli"];
PedidoCab cabecera = armaCabecera(jCabecera, bonifcli);
List <PedidoDet> detalles = armaDetalle(cabecera, jCabYDet["lista"], bonifcli);
using (GestionEntities bd = new GestionEntities())
{
bd.PedidoCab.Add(cabecera);
foreach (var p in detalles)
{
bd.PedidoDet.Add(p);
}
factura fac = bd.factura.Single(a => a.PUNTO == punto && a.EmpresaId == empresa);
bd.factura.Attach(fac);
fac.PEDIDO++;
bd.SaveChanges();
req.objeto = new compi(cabecera.nroped, cabecera.punto, cabecera.tipodoc, cabecera.letra, cabecera.id);
return(req);
}
}
catch (Exception e)
{
return(req.falla(e));
}
}
//usado mostrar en la cabecera
public RequestHTTP getClientePresupuesto(int nrocli)
{
var req = new RequestHTTP();
try
{
using (GestionEntities bd = new GestionEntities())
req.objeto = bd.Database.SqlQuery <ClientePesupuesto>("SELECT dbo.cliente.nrocli, " +
" dbo.cliente.razsoc, dbo.cliente.direcc, dbo.cliente.locali AS localicod, " +
" dbo.localidades.nombre AS nombreLocali, depto.nombre AS deptoNombre, depto.id," +
" depto.provincia_id, dbo.provincias.nombre AS nombreProv, dbo.pais.pais, " +
" dbo.cliente.cuit, dbo.cliente.respon AS Iva, dbo.iva.descripcion AS descriIva, " +
" dbo.cliente.tipodoc, dbo.cliente.condicion, dbo.cliente.lista, dbo.vende.codven," +
" dbo.vende.nombre AS nombreVende, dbo.cliente.respon, dbo.cliente.telef1, " +
" dbo.cliente.bonif, dbo.cliente.bonif1, dbo.cliente.bonif2, dbo.cliente.bonif3," +
" dbo.cliente.bonif4, dbo.cliente.convenio, dbo.cliente.nopercib, dbo.cliente.expreso," +
" dbo.cliente.cond_vta" +
" FROM dbo.cliente" +
" LEFT OUTER JOIN dbo.localidades ON dbo.localidades.id = dbo.cliente.locali " +
" LEFT OUTER JOIN dbo.departamentos AS depto ON depto.id = dbo.localidades.departamento_id" +
" LEFT OUTER JOIN dbo.provincias ON dbo.provincias.id = depto.provincia_id " +
" LEFT OUTER JOIN dbo.pais ON dbo.provincias.pais_id = dbo.pais.id " +
" LEFT OUTER JOIN dbo.iva ON dbo.iva.id = dbo.cliente.respon " +
" LEFT OUTER JOIN dbo.vende ON dbo.vende.codven = dbo.cliente.codven where nrocli = " + nrocli).Single();
return(req);
}
catch (Exception e)
{
return(req.falla(e));
}
}
internal RequestHTTP getVendedoresFiltro(string param)
{
var req = new RequestHTTP();
try
{
int nrocli;
using (GestionEntities bd = new GestionEntities())
{
if (int.TryParse(param, out nrocli))
{
nrocli = Convert.ToInt32(param);
req.objeto = bd.Database.SqlQuery <vendedor>("select codven, nombre from vende where codven = " + param + " and nombre like '%" + param + "%'").ToList();
}
else
{
req.objeto = bd.Database.SqlQuery <vendedor>("select codven, nombre from vende where nombre like '%" + param + "%'").ToList();
}
return(req);
}
}
catch (Exception e)
{
return(req.falla(e));
}
}
//----------------------------------------------------------CLIENTES
public RequestHTTP getClientes(int codven, bool veTodos, int offset)
{
var req = new RequestHTTP();
try
{
List <ClienteBuscador> clientes;
using (GestionEntities bd = new GestionEntities())
{
if (veTodos)
{
req.objeto = bd.Database.SqlQuery <ClienteBuscador>(
"select nrocli, razsoc, cuit, fantasia, direcc, telef1, telef2, codven " +
"from cliente " +
"order by nrocli " +
"offset " + offset + " " +
"rows fetch next 20 row only").ToList();
}
else
{
req.objeto = bd.Database.SqlQuery <ClienteBuscador>(
"select nrocli, razsoc, cuit, fantasia, direcc, telef1, telef2, codven " +
"from cliente " +
"where codven = " + codven + " " +
"order by nrocli " +
"offset " + offset + " rows fetch next 20 row only").ToList();
}
}
return(req);
}catch (Exception e)
{
return(req.falla(e));
}
}
public RequestHTTP getCliente(int paran)
{
cliente cli;
var req = new RequestHTTP();
try
{
using (GestionEntities bd = new GestionEntities())
{
if (bd.cliente.Where(a => a.nrocli == paran).Count() == 1)
{
cli = bd.cliente.Single(a => a.nrocli == paran);
}
else
{
cli = new cliente();
cli.nrocli = 0;
}
req.objeto = cli;
return(req);
}
}
catch (Exception e)
{
return(req.falla(e));
}
}
public RequestHTTP getComprobantesFacturados(string query, int offset, int codven, bool veTodos)
{
var res = new RequestHTTP();
try
{
using (GestionEntities bd = new GestionEntities())
{
string queryVende = " and codven = " + codven;
if (veTodos)
{
queryVende = "";
}
res.objeto = bd.Database.SqlQuery <ivavenComprobante>(
"select fecha, tipodoc, letra, punto, numero,hasta ,nrocli, razsoc, total, cae, vencecae, numerofe,idpetic,ctacon,ctaconex,empresaid, id, provin, " +
"remito " +
"from ivaven " +
"where 1=1 " + query + " " + queryVende + " order by id desc offset " + offset + " rows fetch next 20 row only"
).ToList();
}
}catch (Exception ex)
{
res = res.falla(ex);
}
return(res);
}
public string Giai_captcha(string key, int timeOut = 60)
{
RequestHTTP request = new RequestHTTP();
string Response = request.Request("GET", "http://2captcha.com/in.php?key=" + key + "&method=userrecaptcha&googlekey=6LeilUMUAAAAAMSYwJVVq4C70mYZSy6NJoMb6q0t&pageurl=https://manager.sunfrogshirts.com/Login.cfm");
Console.WriteLine("Post Captcha: " + Response);
if (Response.Contains("OK"))
{
Response = Response.Split('|')[1];
}
else
{
return("ERROR");
}
for (int i = 0; i < timeOut; i++)
{
string captcha = request.Request("GET", "http://2captcha.com/res.php?key=" + key + "&action=get&id=" + Response);
Console.WriteLine("Captcha: " + captcha);
if (captcha.Contains("OK"))
{
return(captcha.Split('|')[1]);
}
Thread.Sleep(3999);
}
return("ERROR");
}
internal RequestHTTP getCobranzasPorVendedor(int empresa, int codven, bool cotizaciones, string desde, string hasta, int group)
{
var req = new RequestHTTP();
string qCotizaciones = "";
string labelNombre = "";
string groupb = "";
string order = "";
try
{
if (cotizaciones)
{
qCotizaciones = " and clicta.tipdoco <> 'CT'";
}
string consulta = "select sum(netocob) total, " + labelNombre + ", max(vende.codven) codven " +
"from clicta " +
"left join cliente on cliente.nrocli = clicta.nrocli " +
"left join vende on vende.codven = cliente.codven " +
"where empresa = " + empresa + " and fecha >= '" + desde + "' and fecha <= '" + hasta + "' and clicta.tipodoc = 'RC' and anulado = 0 " +
"and vende.codven = " + codven + qCotizaciones +
"group by " + groupb +
"having sum(netocob) <> 0 " +
"order by " + order;
switch (group)
{
case 1: //agrupado por dia
labelNombre = "convert(char(10),fecha,103) label, max(vende.nombre) nombre";
groupb = " fecha ";
order = " fecha ";
break;
case 2: //agrupado por semana
labelNombre = "convert(varchar,DATEPART(wk, fecha))+'/'+convert(varchar,year(fecha)) label, max(vende.nombre) nombre";
groupb = " DATEPART(wk, fecha), year(fecha) ";
order = " year(fecha), DATEPART(wk, fecha) ";
break;
case 3: //agrupado x mes
labelNombre = " convert(varchar,month(fecha))+'/'+ convert(varchar,year(fecha)) label, max(vende.nombre) nombre ";
groupb = " month(fecha), year(fecha) ";
order = " year(fecha), month(fecha) ";
break;
}
using (GestionEntities bd = new GestionEntities())
req.objeto = bd.Database.SqlQuery <ventasVendedor>(consulta).ToList();
return(req);
}
catch (Exception e)
{
return(req.falla(e));
}
}
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));
}
}
void CheckFullSelectedAccount()
{
int live = 0;
string token = "";
lblStatus.Text = "Status: Loading!";
// Check number of selected rows
if (dtgvLoad.SelectedRows.Count != 0)
{
// Login all selected rows
for (int i = dtgvLoad.RowCount - 1; i >= 0; i--)
{
token = dtgvLoad[3, i].Value.ToString();
// Kiểm tra token không rỗng và được chọn
if (dtgvLoad[3, i].Selected && token.Length > 10)
{
RequestHTTP request = new RequestHTTP();
string htmlInfo = request.Request("GET", "https://graph.facebook.com/v2.11/me?fields=id,email,mobile_phone,name,birthday,gender&access_token=" + token);
htmlInfo = htmlInfo.Remove(htmlInfo.IndexOf('}'));
htmlInfo = htmlInfo.Substring(1);
htmlInfo = htmlInfo.Replace('"', ' ');
htmlInfo = htmlInfo.Replace(",", "|");
htmlInfo = htmlInfo.Replace(" ", string.Empty);
string strInfo = htmlInfo.Split('|')[0];
// Khởi tạo từng thông tin
string id = "";
string status = "";
if (strInfo.Split(':')[0] == "id")
{
id = strInfo.Split(':')[1];
}
if (id.Length > 0)
{
status = "live";
live++;
}
else
{
status = "die";
}
dtgvLoad[12, i].Value = status;
}
}
MessageBox.Show(live + " Account live & " + (dtgvLoad.SelectedRows.Count - live) + " Account died!");
}
else
{
MessageBox.Show("Not Selected yet!", "Notification!", MessageBoxButtons.OKCancel, MessageBoxIcon.Information);
}
lblStatus.Text = "Status: Done!";
}
/// <summary>
/// nghịch thôi chứ ko có gì hết á :v
/// </summary>
/// <param name="uid"></param>
/// <param name="Fbdtg"></param>
/// <returns></returns>
public static string FacebookDateCreatedTest(string uid, string Fbdtg)
{
try
{
RequestHTTP request_api = new RequestHTTP();
request_api.SetSSL(System.Net.SecurityProtocolType.Tls12);
request_api.SetKeepAlive(true);
request_api.SetDefaultHeaders(new string[] { "content-type: Text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8", "user-agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.131 Safari/537.36" });
string get_created_time = request_api.Request("POST", "https://www.facebook.com/api/graphql", null, Encoding.UTF8.GetBytes("fb_dtsg=" + Fbdtg + "&q=node(" + uid + ")hometown{name}{friends{count},subscribers{count},groups{count},created_time,timeline_feed_units.first(500){page_info,edges{node{url,feedback{reactors{count},comments{count}}}}}}}"));
return(Regex.Match(get_created_time, "created_time.*?(\\d+)").Groups[1].Value);
}
catch { return("error"); }
}
/// <summary>
/// get the date created of facebook by UID
/// </summary>
/// <param name="uid"></param>
/// <param name="Fbdtg"></param>
/// <returns></returns>
public string FacebookDateCreated(string uid, string Fbdtg)
{
try
{
RequestHTTP request_api = new RequestHTTP();
request_api.SetSSL(System.Net.SecurityProtocolType.Tls12);
request_api.SetKeepAlive(true);
request_api.SetDefaultHeaders(new string[] { "content-type: Text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8", "user-agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.131 Safari/537.36" });
string get_created_time = request_api.Request("POST", "https://www.facebook.com/api/graphql", null, Encoding.UTF8.GetBytes("fb_dtsg=" + Fbdtg + "&q=node(" + uid + "){created_time}"));
return(Regex.Match(get_created_time, "created_time.*?(\\d+)").Groups[1].Value);
}
catch { return("error"); }
}
public RequestHTTP finalizarPresupuesto(JObject cabydet)
{
var req = new RequestHTTP();
try
{
var jCabecera = (JObject)cabydet["cabecera"];
int punto = (int)jCabecera["punto"], empresaid = (int)jCabecera["empresa"];
var jDetalle = cabydet["lista"];
decimal bonifcli = (decimal)cabydet["bonifcli"];
presupc cabecera = armarCabecera(jCabecera, bonifcli);
List <presupd> detalle = armarDetalle(jDetalle, cabecera, bonifcli);
using (GestionEntities bd = new GestionEntities())
{
bd.presupc.Add(cabecera);
foreach (presupd p in detalle)
{
bd.presupd.Add(p);
}
var factu = bd.factura.Single(a => a.PUNTO == punto && a.EmpresaId == empresaid);
bd.factura.Attach(factu);
factu.PRESUP++;
if (!Convert.ToBoolean(bd.SaveChanges()))
{
throw new Exception();
}
req.objeto = new compi(cabecera.numero, cabecera.punto, cabecera.tipodoc, cabecera.letra, cabecera.id);
return(req);
}
}
catch (DbEntityValidationException dbEx)
{
StreamWriter sw = new StreamWriter("C:/Users/usuario/Desktop/error.txt");
//Close the file
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
sw.WriteLine("Property:" + validationError.PropertyName + " Error:" + validationError.ErrorMessage);
}
}
sw.Close();
return(req.falla(new Exception()));
}
}
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 RequestHTTP getCliente(int nrocli)
{
try
{
using (GestionEntities bd = new GestionEntities())
{
var req = new RequestHTTP();
req.objeto = bd.cliente.Single(cliente => cliente.nrocli == nrocli);
return(req);
}
}catch (Exception e)
{
return(new RequestHTTP().falla(e));
}
}
public RequestHTTP getPresup(string filtro, int offset)
{
var req = new RequestHTTP();
try
{
using (GestionEntities bd = new GestionEntities())
{
req.objeto = bd.Database.SqlQuery <presupc>("select * from presupc where " + filtro + "order by fecha desc offset " + offset + " rows fetch next 20 row only").ToList();
return(req);
}
}
catch (Exception e)
{
return(req.falla(e));
}
}
//----------------------------------------------------------SUBRUBROS
internal RequestHTTP getSubRubros()
{
var req = new RequestHTTP();
try
{
using (GestionEntities bd = new GestionEntities())
{
req.objeto = bd.Database.SqlQuery <MiSubrub>("select codigo, descri from subrub").ToList();
}
return(req);
}
catch (Exception e)
{
return(req.falla(e));
}
}
internal RequestHTTP getProveedor(int param)
{
var req = new RequestHTTP();
try
{
using (GestionEntities bd = new GestionEntities())
{
req.objeto = bd.Database.SqlQuery <MiProvee>("select nropro, razsoc from provee where nropro = " + param).ToList();
}
return(req);
}
catch (Exception e)
{
return(req.falla(e));
}
}
internal RequestHTTP getActividad(int param)
{
var req = new RequestHTTP();
try
{
using (GestionEntities bd = new GestionEntities())
{
req.objeto = bd.Database.SqlQuery <activida>("select * from activida where codigo =" + param).ToList();
}
return(req);
}
catch (Exception e)
{
return(req.falla(e));
}
}
internal RequestHTTP getActividadesFiltro(string param)
{
var req = new RequestHTTP();
try
{
using (GestionEntities bd = new GestionEntities())
{
req.objeto = bd.Database.SqlQuery <activida>("select * from activida where descri like '%" + param + "%' or codigo like '" + param + "'").ToList();
}
return(req);
}
catch (Exception e)
{
return(req.falla(e));
}
}
internal RequestHTTP getTransportes()
{
var req = new RequestHTTP();
try
{
using (GestionEntities bd = new GestionEntities())
{
req.objeto = bd.Database.SqlQuery <MiTranspo>("select codigo, razsoc from transpo").ToList();
}
return(req);
}
catch (Exception e)
{
return(req.falla(e));
}
}
internal RequestHTTP getTransportesFiltro(string param)
{
var req = new RequestHTTP();
try
{
using (GestionEntities bd = new GestionEntities())
{
req.objeto = bd.Database.SqlQuery <MiTranspo>("select codigo, razsoc from transpo where razsoc like '%" + param + "%' or codigo like '" + param + "'").ToList();
}
return(req);
}
catch (Exception e)
{
return(req.falla(e));
}
}
internal RequestHTTP getmarcasFiltro(string param)
{
var req = new RequestHTTP();
try
{
using (GestionEntities bd = new GestionEntities())
{
req.objeto = bd.Database.SqlQuery <MiMarca>("select codigo, descripcion from marcas where codigo like '" + param + "' or descripcion like '%" + param + "%'").ToList();
}
return(req);
}
catch (Exception e)
{
return(req.falla(e));
}
}
internal RequestHTTP getConcepto(int param)
{
var req = new RequestHTTP();
try
{
using (GestionEntities bd = new GestionEntities())
{
req.objeto = bd.Database.SqlQuery <MiConcepto>("select codigo, descri from concepto where codigo = " + param).ToList();
}
return(req);
}
catch (Exception e)
{
return(req.falla(e));
}
}
internal RequestHTTP getProveedoresFiltro(string param)
{
var req = new RequestHTTP();
try
{
using (GestionEntities bd = new GestionEntities())
{
req.objeto = bd.Database.SqlQuery <concepto>("select nropro, razsoc from provee where nropro like '" + param + "' or razsoc like '%" + param + "%'").ToList();
}
return(req);
}
catch (Exception e)
{
return(req.falla(e));
}
}
//----------------------------------------------------------PROVINCIAS
public RequestHTTP getPrvincias()
{
var req = new RequestHTTP();
try
{
List <provincias> provincias;
using (GestionEntities bd = new GestionEntities())
{
req.objeto = bd.Database.SqlQuery <MiProvincia>("select nombre, id from provincias").ToList();
}
return(req);
}catch (Exception e)
{
return(req.falla(e));
}
}
//----------------------------------------------------------MARCAS
internal RequestHTTP getmarcas()
{
var req = new RequestHTTP();
try
{
using (GestionEntities bd = new GestionEntities())
{
req.objeto = bd.Database.SqlQuery <MiMarca>("select codigo, descripcion from marcas").ToList();
}
return(req);
}
catch (Exception e)
{
return(req.falla(e));
}
}
internal RequestHTTP getPuntos(int empresa)
{
var req = new RequestHTTP();
try
{
using (GestionEntities bd = new GestionEntities())
{
req.objeto = bd.factura.Where(a => a.EmpresaId == empresa).ToList();
}
return(req);
}
catch (Exception e)
{
return(req.falla(e));
}
}
