private void preencher_terminais() { ListViewItem item; //DBApp db = new DBApp(); //SqlCommand comm = db.Conn.CreateCommand(); //comm.CommandText = "SELECT TRM_DESCRICAO, TRM_IP, TRM_PORTA, TRM_IND FROM Terminais ORDER BY TRM_DESCRICAO"; //SqlDataReader reader = comm.ExecuteReader(); DBApp db = new DBApp(); SqlDataReader reader = db.getReader("SELECT TRM_DESCRICAO, TRM_IP, TRM_PORTA, TRM_IND FROM Terminais ORDER BY TRM_DESCRICAO"); listRelogios.Items.Clear(); while (reader.Read()) { item = new ListViewItem(); item.Text = reader["TRM_DESCRICAO"].ToString().Trim(); item.SubItems.Add(reader["TRM_IP"].ToString().Trim()); item.SubItems.Add(reader["TRM_PORTA"].ToString().Trim()); item.SubItems.Add(reader["TRM_IND"].ToString()); item.ImageIndex = 0; listRelogios.Items.Add(item); } reader.Close(); db.closeConnection(); }
public static bool EnviarFuncionariosSelecao(int Terminal, Principal form, ListView listFuncionarios, TextBox edLog) { if (listFuncionarios.SelectedIndices.Count == 0) { return(false); } bool Ok = false; Types.Terminal TerminalDados; DBApp db = new DBApp(); db.getDadosTerminal(Terminal, out TerminalDados); Rede rede = new Rede(TerminalDados.IP, edLog); if (!rede.Gertec_Conectar()) { return(Ok); } if (listFuncionarios.SelectedIndices.Count > 1) { rede.log.AddLog(String.Format(Consts.FUNCIONARIOS_ENVIANDO, listFuncionarios.SelectedIndices.Count)); } form.CANCELAR = false; for (int i = 0; i <= listFuncionarios.SelectedIndices.Count - 1; i++) { int index = listFuncionarios.SelectedIndices[i]; string EnviadoEm = listFuncionarios.Items[index].SubItems[Consts.FUNC_SUBITEM_ENVIADOEM].Text; if (EnviadoEm != String.Empty) { rede.log.AddLog(String.Format(Consts.PIS_JA_EXISTE, listFuncionarios.Items[index].SubItems[Consts.FUNC_SUBITEM_PIS].Text)); } else { int Funcionario = Convert.ToInt32(listFuncionarios.Items[index].SubItems[Consts.FUNC_SUBITEM_IND].Text); if (EnviarFuncionario(db, rede, Terminal, Funcionario)) { Ok = true; } } Application.DoEvents(); if (form.CANCELAR) { rede.log.AddLog(Consts.CANCELADO); break; } } rede.Gertec_Desconectar(); return(true); }
//private void processar_marcacoes(int Terminal, string Arquivo) //{ // Marcacoes marcacoes = new Marcacoes(Arquivo); // DBApp db = new DBApp(); // Log log = new Log(edLog); // db.ProcessarMarcacoes(Grupo, marcacoes.listMarcacoes, log); //} private void ExcluirTerminal(int Terminal) { DBApp db = new DBApp(); db.executeCommand(String.Format("DELETE FROM Terminais WHERE TRM_IND = {0}", Terminal)); preencher_terminais(); }
private void RepEdicao_Load(object sender, EventArgs e) { if (Terminal > 0) { db = new DBApp(); //SqlCommand Comm = db.Conn.CreateCommand(); //Comm.CommandText = "SELECT TRM_DESCRICAO, TRM_IP, TRM_PORTA, TRM_RAZAOSOCIAL, TRM_CNPJ, TRM_CPF, " + // "TRM_ENDERECO, TRM_NUMERO, TRM_SERIAL FROM Terminais WHERE TRM_IND = " + Terminal.ToString() + " " + // "ORDER BY TRM_DESCRICAO"; //SqlDataReader reader = Comm.ExecuteReader(); SqlDataReader reader = db.getReader("SELECT TRM_DESCRICAO, TRM_IP, TRM_PORTA, TRM_RAZAOSOCIAL, TRM_CNPJ, TRM_CPF, " + "TRM_ENDERECO, TRM_NUMERO, TRM_SERIAL FROM Terminais WHERE TRM_IND = " + Terminal.ToString() + " " + "ORDER BY TRM_DESCRICAO"); reader.Read(); edDescricao.Text = reader["TRM_DESCRICAO"].ToString().Trim(); edIp.Text = reader["TRM_IP"].ToString().Trim(); edPorta.Text = reader["TRM_PORTA"].ToString().Trim(); edRazaoSocial.Text = reader["TRM_RAZAOSOCIAL"].ToString().Trim(); edCnpj.Text = reader["TRM_CNPJ"].ToString().Trim(); edCpf.Text = reader["TRM_CPF"].ToString().Trim(); edEndereco.Text = reader["TRM_ENDERECO"].ToString().Trim(); edNumero.Text = reader["TRM_NUMERO"].ToString().Trim(); edSerial.Text = reader["TRM_SERIAL"].ToString().Trim(); reader.Close(); db.closeConnection(); } else { edPorta.Text = Consts.PORTAPADRAO.ToString(); } }
private void LoadData() { Globals.ChronoLoadData.Start(); try { DBApp.Open(); LettersBindingSource.DataSource = DBApp.LettersAsBindingList; if (Globals.IsDebugExecutable) // TODO remove when ready { DBHebrew.TakeLettriqs(); TermsBindingSource.DataSource = DBHebrew.TermsHebrewAsBindingList; LettriqsBindingSource.DataSource = DBHebrew.TermLettriqsAsBindingList; } } catch (Exception ex) { DisplayManager.ShowError(SysTranslations.ApplicationMustExit.GetLang() + Globals.NL2 + SysTranslations.ContactSupport.GetLang()); ex.Manage(); Environment.Exit(-1); } finally { Globals.ChronoLoadData.Stop(); Settings.BenchmarkLoadData = Globals.ChronoLoadData.ElapsedMilliseconds; } }
public override bool sendFuncionario(Types.Funcionario Funcionario) { base.sendFuncionario(Funcionario); RepProtocol.Empregado empregado = new RepProtocol.Empregado(); empregado.CNTLS = String.IsNullOrEmpty(Funcionario.Proximidade) ? "0" : Convert.ToInt64(Funcionario.Proximidade).ToString("X"); empregado.ID = Funcionario.Crachas[0].ToString(); empregado.KBD = Funcionario.Crachas[0].ToString(); empregado.Nome = Funcionario.Nome; empregado.PIS = Funcionario.Pis; AssepontoRep.DBApp bd = new DBApp(); string msg = ""; if (bd.FuncionarioEstaNoTerminal(TerminalDados.Indice, Funcionario.Ind)) { repProtocol.EditEmployee(empregado, out msg); } else { repProtocol.SetEmployee(empregado, out msg); } LogMensagem(msg); return(msg == MSGOK); }
public ActionResult AddColumn(string appName, string tableName, DBColumn column) { DBApp app = new DBApp() { Name = appName, ConnectionString = (new Entities()).Database.Connection.ConnectionString }; DBTable table = app.GetTable(tableName); if (table.Select().ToList().Count != 0 && column.canBeNull == false)//condition for not null column, which can be created only in empty table { TempData["message-error"] = "Table " + tableName + " must be empty if you want to add NOT NULL column."; return RedirectToAction("Details", new { @appName = appName, @tableName = tableName }); } else if (table.columns.SingleOrDefault(x => x.Name == column.Name) != null)//condition for column name, column name can not be equal with other names in table { TempData["message-error"] = "Table " + tableName + " has already column with name " + column.Name + "."; return RedirectToAction("Details", new { @appName = appName, @tableName = tableName }); } table.columns.AddToDB(column); app.SaveChanges(); TempData["message-success"] = "Column " + column.Name + " was successfully added."; return RedirectToAction("Details", new { @appName = appName, @tableName = tableName }); }
public static void EnviaInfoEmpresa(int Terminal, TextBox edLog) { Types.Terminal TerminalDados; Types.Empregador EmpregadorDados; DBApp db = new DBApp(); db.getDadosTerminal(Terminal, out TerminalDados); db.LerEmpresa(Terminal, out EmpregadorDados); Rede rede = new Rede(TerminalDados.IP, TerminalDados.Porta, edLog); if (TerminalDados.SupervisorPis == "" || TerminalDados.SupervisorCodigo == 0 || TerminalDados.SupervisorSenha == 0) { rede.log.AddLog(AssepontoRep.Consts.DADOS_SUPERVISOR_NAO_DEFINIDOS); } else { if (rede.Dimep_EnviaEmpresa(EmpregadorDados.PessoaTipo, EmpregadorDados.Pessoa, EmpregadorDados.Nome, EmpregadorDados.Cei, EmpregadorDados.Endereco)) { rede.Dimep_InsereFuncionarioMasterListaEnvio(TerminalDados.SupervisorPis, TerminalDados.SupervisorCodigo.ToString(), TerminalDados.SupervisorSenha.ToString()); rede.Dimep_EnviaFuncionariosMasterListaEnvio(); } } }
public override bool LerMarcacoes(Marcacoes marcacoes, TipoImportacaoMarcacoes tipoimportacao) { base.LerMarcacoes(marcacoes, tipoimportacao); bool Result = false; DBApp db = new DBApp(); int ProximoNsr = db.getLastNsr(TerminalDados.Indice); int NRegistrosLidos = 0; short porta = (short)TerminalDados.Porta; if (Connect(0)) { //string Ponteir = starRep.VerificarNSRPonteiro(TerminalDados.IP, porta, numeroTentativas, tempoEsperaMilissegundos); //int ultimoNSR = Convert.ToInt32(starRep.VerificarUltimoNSR(TerminalDados.IP, porta, numeroTentativas, tempoEsperaMilissegundos)); try { string resposta = starRep.ColetarMarcacoes(TerminalDados.IP, porta, numeroTentativas, tempoEsperaMilissegundos, ProximoNsr + 1, "|"); while (!string.IsNullOrEmpty(resposta) && !resposta.ToLower().Equals("erro")) { string[] respostas = resposta.Split('|'); NRegistrosLidos = Convert.ToInt32(respostas[0]); for (int i = 1; i < NRegistrosLidos + 1; i++) { string b = respostas[i].Substring(0, 9); string c = b + 3 + respostas[i].Substring(9); AssepontoRep.Marcacoes.Marcacao mrc = new AssepontoRep.Marcacoes.Marcacao(); if (marcacoes.InterpretarRegistroAfd(c, out mrc)) { if (mrc.Tipo == Marcacoes.TiposRegistroAfd.Marcacao) { marcacoes.Add(mrc); } } } resposta = string.Empty; } if (marcacoes.Count == 0) { log.AddLog(Consts.MARCACOES_NAO_HA_NOVAS); } Result = true; } catch (Exception ex) { log.AddLog(ex.Message); } finally { starRep.Fecha_Comunicacao(); } } return(Result); }
public override bool LerMarcacoes(Marcacoes marcacoes, TipoImportacaoMarcacoes tipoimportacao) { base.LerMarcacoes(marcacoes, tipoimportacao); bool Result = false; DBApp db = new DBApp(); int ProximoNsr = db.getLastNsr(TerminalDados.Indice) + 1; int Contador = 0; MRPRecord[] registrosMRP; if (Dimep_Conectar()) { try { _watchComm.RepositioningMRPRecordsPointer(ProximoNsr.ToString()); registrosMRP = this._watchComm.InquiryMRPRecords(false, false, true, false); while (registrosMRP != null) { foreach (MRPRecord registroMRP in registrosMRP) { if (registroMRP is MRPRecord_RegistrationMarkingPoint) { string Pis = ((MRPRecord_RegistrationMarkingPoint)registroMRP).Pis; DateTime DataHora = ((MRPRecord_RegistrationMarkingPoint)registroMRP).DateTimeMarkingPoint; int Nsr = Convert.ToInt32(((MRPRecord_RegistrationMarkingPoint)registroMRP).NSR); marcacoes.Add(Pis, DataHora, Nsr); Contador++; if (Nsr > ProximoNsr) { ProximoNsr = Nsr; } } } registrosMRP = _watchComm.ConfirmationReceiptMRPRecords(); } base.FinalizarImportacaoMarcacoes(marcacoes, ProcessarMarcacoesAoImportar.ProcessarSim); } catch (Exception ex) { log.AddLog(ex.Message); } finally { Dimep_Desconectar(); } } return(Result); }
public static void EnviaConfiguracao(int Terminal, TextBox edLog) { Types.Terminal TerminalDados; DBApp db = new DBApp(); db.getDadosTerminal(Terminal, out TerminalDados); Rede rede = new Rede(TerminalDados.IP, TerminalDados.Porta, edLog); rede.Dimep_EnviaConfiguracao(); }
public static void EnviaDataHora(int Terminal, TextBox edLog) { Types.Terminal TerminalDados; DBApp db = new DBApp(); db.getDadosTerminal(Terminal, out TerminalDados); Rede rede = new Rede(TerminalDados.IP, edLog); rede.Gertec_AtualizaDataHora(); }
public ActionResult Create(DBApp model) { if (string.IsNullOrWhiteSpace(model.Name)) return View(model); DBApp.connectionString = (new Entities()).Database.Connection.ConnectionString; if (string.IsNullOrWhiteSpace(model.DisplayName)) model.DisplayName = model.Name; model.Create(); return RedirectToAction("Index"); }
public static void EnviaInfoEmpresa(int Terminal, TextBox edLog) { Types.Terminal TerminalDados; Types.Empregador EmpregadorDados; DBApp db = new DBApp(); db.getDadosTerminal(Terminal, out TerminalDados); db.LerEmpresa(Terminal, out EmpregadorDados); Rede rede = new Rede(TerminalDados.IP, edLog); rede.Gertec_EnviaEmpresa(EmpregadorDados.PessoaTipo, EmpregadorDados.Pessoa, EmpregadorDados.Nome, EmpregadorDados.Cei, EmpregadorDados.Endereco); }
public override bool LerMarcacoes(Marcacoes marcacoes, TipoImportacaoMarcacoes tipoimportacao) { bool Result = false; base.LerMarcacoes(marcacoes, tipoimportacao); string nsr = ""; string pis = ""; int year = 0; int month = 0; int day = 0; int hour = 0; int min = 0; int sec = 0; int iIndex = 0; int idwErrorCode = -9; DBApp db = new DBApp(); int ProximoNsr = db.getLastNsr(TerminalDados.Indice) + 1; bool connect = Connect(TerminalDados.Indice); //bioRep.SetSeekPosition(TerminalDados.Indice, ProximoNsr); if (connect) { log.AddLog("PROCESSANDO MARCAÇÕES...", true); bioRep.EnableDevice(TerminalDados.Indice, false); while (bioRep.GetAttLogs_BZ900(TerminalDados.Indice, out nsr, out pis, out year, out month, out day, out hour, out min, out sec)) { DateTime DataHora = new DateTime(year, month, day, hour, min, sec); marcacoes.Add(pis, DataHora, Convert.ToInt32(nsr)); if (iIndex % 50 == 0) { System.Threading.Thread.Sleep(200); } iIndex++; Result = true; } bioRep.GetLastError(ref idwErrorCode); } if (iIndex == 0) { Result = false; } bioRep.EnableDevice(TerminalDados.Indice, true); return(Result); }
private void definirPróximoNSRToolStripMenuItem_Click(object sender, EventArgs e) { DBApp db = new DBApp(); int Terminal = Convert.ToInt32(listRelogios.Items[listRelogios.SelectedIndices[0]].SubItems[Consts.TRM_SUBITEM_IND].Text); int uNsr = db.getLastNsr(Terminal); string sNsr = uNsr.ToString(); if (InputBox.Show("Informe o Último Nsr", "NSR", ref sNsr) == DialogResult.OK) { db.setLastNsr(Terminal, Convert.ToInt32(sNsr)); } }
public static void EnviarFuncionariosTerminal(int Terminal, Principal form, TextBox edLog) { Types.Terminal TerminalDados; DBApp db = new DBApp(); SqlCommand comm = db.Conn.CreateCommand(); db.getDadosTerminal(Terminal, out TerminalDados); Rede rede = new Rede(TerminalDados.IP, edLog); if (rede.Gertec_Conectar()) { form.CANCELAR = false; SqlDataAdapter da = new SqlDataAdapter("SELECT FUNC_IND, FUNC_PIS, TRMF_ARMAZENADO_NO_TERMINAL " + "FROM Funcionarios " + "INNER JOIN TerminaisFuncionarios ON TRMF_FUNC = FUNC_IND " + "WHERE TRMF_TERMINAL = " + Terminal + " AND FUNC_PIS IS NOT NULL " + "ORDER BY FUNC_NOME", db.Conn); DataSet ds = new DataSet(); da.Fill(ds); rede.log.AddLog(String.Format(Consts.FUNCIONARIOS_ENVIANDO, ds.Tables[0].Rows.Count)); foreach (DataRow dr in ds.Tables[0].Rows) { if (Convert.ToInt32(dr["TRMF_ARMAZENADO_NO_TERMINAL"]) == 1) { rede.log.AddLog(String.Format(Consts.PIS_JA_EXISTE, dr["FUNC_PIS"].ToString())); } else { EnviarFuncionario(db, rede, Terminal, Convert.ToInt32(dr["FUNC_IND"].ToString())); } Application.DoEvents(); if (form.CANCELAR) { rede.log.AddLog(Consts.CANCELADO); break; } } } rede.Gertec_Desconectar(); }
static bool EnviarFuncionario(DBApp db, Rede rede, int Terminal, int Funcionario) { bool Result = false; //string TecladoPassword = ""; string Cracha = ""; string Pis = ""; SqlDataAdapter da = new SqlDataAdapter("SELECT FUNC_NOME, FUNC_PIS, CRA_NUMERO, TRMF_TECLADO, " + "TRMF_TECLADO_PASSWORD, TRMF_PROXIMIDADE, TRMF_CODIGOBARRAS " + "FROM Funcionarios " + "LEFT JOIN Crachas ON CRA_FUNC = FUNC_IND " + "LEFT JOIN TerminaisFuncionarios ON TRMF_FUNC = FUNC_IND " + "WHERE FUNC_IND = " + Funcionario + " AND TRMF_TERMINAL = " + Terminal + " " + "ORDER BY FUNC_NOME", db.Conn); DataSet ds = new DataSet(); da.Fill(ds); foreach (DataRow dr in ds.Tables[0].Rows) { if (dr["CRA_NUMERO"] != DBNull.Value) { Cracha = dr["CRA_NUMERO"].ToString().Trim(); } else { Cracha = ""; } Pis = dr["FUNC_PIS"].ToString().Trim(); if (Pis[0] == Convert.ToChar("0")) { Pis = Pis.Substring(1); } if (Pis != string.Empty) { rede.Dimep_InsereFuncionarioListaEnvio(dr["FUNC_NOME"].ToString().Trim(), Pis, Cracha); FuncionariosAtualizados.Add(Funcionario); Result = true; } } return(Result); }
private void btOk_Click(object sender, EventArgs e) { //SqlConnection Conn = DB.Connection(); //SqlCommand Comm = Conn.CreateCommand(); DBApp db = new DBApp(); db.openConnection(); SqlCommand Comm = db.Conn.CreateCommand(); if (Terminal > 0) { Comm.CommandText = "UPDATE Terminais SET TRM_DESCRICAO = @DESCRICAO, TRM_IP = @IP, " + "TRM_PORTA = @PORTA, TRM_GRUPO = @GRUPO, TRM_FABRICANTE = @FABRICANTE, " + "TRM_RAZAOSOCIAL = @RAZAOSOCIAL, TRM_CNPJ = @CNPJ, TRM_CPF = @CPF, TRM_ENDERECO = @ENDERECO, TRM_NUMERO = @NUMERO, TRM_SERIAL = @SERIAL " + "WHERE TRM_IND = " + Terminal.ToString(); } else { Comm.CommandText = "INSERT INTO Terminais (TRM_DESCRICAO, TRM_IP, TRM_PORTA, TRM_GRUPO, " + "TRM_FABRICANTE, TRM_RAZAOSOCIAL, TRM_CNPJ, TRM_CPF, TRM_ENDERECO, TRM_NUMERO, TRM_SERIAL) VALUES (@DESCRICAO, " + "@IP, @PORTA, @GRUPO, @FABRICANTE, @RAZAOSOCIAL, @CNPJ, @CPF, @ENDERECO, @NUMERO, @SERIAL)"; } Comm.Parameters.Add(new SqlParameter("@DESCRICAO", edDescricao.Text)); Comm.Parameters.Add(new SqlParameter("@IP", edIp.Text)); Comm.Parameters.Add(new SqlParameter("@PORTA", edPorta.Text)); Comm.Parameters.Add(new SqlParameter("@GRUPO", Grupo)); Comm.Parameters.Add(new SqlParameter("@FABRICANTE", "TRIX")); Comm.Parameters.Add(new SqlParameter("@RAZAOSOCIAL", edRazaoSocial.Text)); Comm.Parameters.Add(new SqlParameter("@CNPJ", edCnpj.Text)); Comm.Parameters.Add(new SqlParameter("@CPF", edCpf.Text)); Comm.Parameters.Add(new SqlParameter("@ENDERECO", edEndereco.Text)); Comm.Parameters.Add(new SqlParameter("@NUMERO", edNumero.Text)); Comm.Parameters.Add(new SqlParameter("@SERIAL", edSerial.Text)); Comm.ExecuteNonQuery(); db.closeConnection(); //Conn.Close(); this.Close(); }
public override bool LerMarcacoes(Marcacoes marcacoes, AssepontoRep.Bridge.TipoImportacaoMarcacoes tipoimportacao) { DBApp db = new DBApp(); Connect(TerminalDados.Indice); string from = ""; string to = ""; RepProtocol.FiltroRegistro f; if (tipoimportacao == TipoImportacaoMarcacoes.OnlyNew) { f = RepProtocol.FiltroRegistro.NsrRange; RepProtocol.MrpStatus st = repProtocol.GetMrpStatus(); int ProximoNsr = db.getLastNsr(TerminalDados.Indice) + 1; from = ProximoNsr.ToString().PadLeft(9, '0'); to = st.LastNSR.ToString(); } else { f = RepProtocol.FiltroRegistro.All; } List <string> r = repProtocol.GetRegs(f, from, to, null); foreach (string linha in r) { Marcacoes.Marcacao marcacao = new Marcacoes.Marcacao(); marcacoes.InterpretarRegistroAfd(linha, out marcacao); if (marcacao.Tipo == Marcacoes.TiposRegistroAfd.Marcacao) { marcacoes.Add(marcacao); } } //Wr.Classes.Files.WriteFile(@"c:\arquivo.txt", r); return(marcacoes.Count > 0); }
private void preencher_funcionarios(int Terminal) { ListViewItem item; DBApp db = new DBApp(); //SqlCommand comm = db.Conn.CreateCommand(); //comm.CommandText = "SELECT FUNC_NOME, CAR_DESCRICAO, CRA_NUMERO, FUNC_PIS, FUNC_IND, " + // "dbo.fn_getdatetime(TRMF_ARMAZENADO_EM) AS TRMF_ARMAZENADO_EM " + // "FROM Funcionarios " + // "LEFT JOIN Cargos ON CAR_IND = FUNC_CARGO " + // "LEFT JOIN Crachas ON CRA_FUNC = FUNC_IND " + // "INNER JOIN TerminaisFuncionarios ON TRMF_FUNC = FUNC_IND " + // "WHERE TRMF_TERMINAL = " + Terminal + " AND FUNC_DT_DEM IS NULL AND FUNC_MARCADO_EXCLUSAO = 0 " + // "ORDER BY FUNC_NOME"; //SqlDataReader reader = comm.ExecuteReader(); SqlDataReader reader = db.getReader("SELECT FUNC_NOME, CAR_DESCRICAO, CRA_NUMERO, FUNC_PIS, FUNC_IND, " + "dbo.fn_getdatetime(TRMF_ARMAZENADO_EM) AS TRMF_ARMAZENADO_EM " + "FROM Funcionarios " + "LEFT JOIN Cargos ON CAR_IND = FUNC_CARGO " + "LEFT JOIN Crachas ON CRA_FUNC = FUNC_IND " + "INNER JOIN TerminaisFuncionarios ON TRMF_FUNC = FUNC_IND " + "WHERE TRMF_TERMINAL = " + Terminal + " AND FUNC_DT_DEM IS NULL AND FUNC_MARCADO_EXCLUSAO = 0 " + "ORDER BY FUNC_NOME"); listFuncionarios.Items.Clear(); while (reader.Read()) { item = new ListViewItem(); item.Text = reader["FUNC_NOME"].ToString().Trim(); item.SubItems.Add(reader["CAR_DESCRICAO"].ToString().Trim()); item.SubItems.Add(reader["CRA_NUMERO"].ToString()); item.SubItems.Add(reader["FUNC_PIS"].ToString().Trim()); item.SubItems.Add(reader["FUNC_IND"].ToString()); item.SubItems.Add(reader["TRMF_ARMAZENADO_EM"].ToString()); listFuncionarios.Items.Add(item); } reader.Close(); db.closeConnection(); }
public static void ImportarMarcacoesTerminal(int Terminal, TextBox edLog) { Types.Terminal TerminalDados; DBApp db = new DBApp(); WinRegistry Registro = new WinRegistry("Assecont", "Asseponto4"); db.getDadosTerminal(Terminal, out TerminalDados); Rede rede = new Rede(TerminalDados.IP, edLog); string Arquivo = Folders.folderMarcacoes(TerminalDados.Descricao) + String.Format("{0:yyyy MM dd hhmm}", DateTime.Now) + ".txt"; Marcacoes marcacoes = new Marcacoes(Arquivo); if (rede.Gertec_ImportarMarcacoes(Terminal, TerminalDados.Descricao, marcacoes)) { Utilitarios.setArquivoImportacao(Registro, Arquivo); db.ProcessarMarcacoes(TerminalDados.Grupo, marcacoes, rede.log); } }
public override bool LerMarcacoes(Marcacoes marcacoes, TipoImportacaoMarcacoes tipoimportacao) { bool Result = base.LerMarcacoes(marcacoes, tipoimportacao); string nsr = "200"; string pis; int ano; int mes; int dia; int hora; int min; int sec; DBApp db = new DBApp(); int ProximoNsr = db.getLastNsr(TerminalDados.Indice) + 1; string ArquivoTemp = Path.GetTempFileName(); int Contador = 0; bioRep.SetSeekPosition(numeroRep, ProximoNsr); bool connect = Connect(TerminalDados.Indice); if (connect) { log.AddLog("PROCESSANDO MARCAÇÕES...", true); List <string> arquivo = new List <string>(); Wr.Classes.Files.ReadFile(ArquivoTemp, arquivo); while (bioRep.GetAttLogs(numeroRep, out nsr, out pis, out ano, out mes, out dia, out hora, out min, out sec)) { DateTime DataHora = new DateTime(ano, mes, dia, hora, min, sec); marcacoes.Add(pis, DataHora, Convert.ToInt32(nsr)); Contador++; Result = true; } } return(Result); }
public override bool LerMarcacoes(Marcacoes marcacoes, AssepontoRep.Bridge.TipoImportacaoMarcacoes tipoimportacao) { base.LerMarcacoes(marcacoes, tipoimportacao); Connect(TerminalDados.Indice); //log.AddLog("INICIANDO IMPORTAÇÂO DE MARCAÇÔES"); DBApp bd = new DBApp(); int ultimonsr = bd.getLastNsr(TerminalDados.Indice); DateTime inicial = Convert.ToDateTime("01/01/2010"); DateTime final = DateTime.Now; DataTable table = new DataTable(); string lista = ""; if (Rep.LerAFD_ViaLista(TerminalDados.IP, TerminalDados.Porta, Convert.ToInt32(TerminalDados.SupervisorSenha), inicial.ToString("yyyyMMdd"), final.ToString("yyyyMMdd"), ref lista, ultimonsr, "|", ";")) { string[] registros = lista.Split(new string[] { ";" }, StringSplitOptions.None); string[] campos; foreach (string registro in registros) { campos = registro.Split(new string[] { "|" }, StringSplitOptions.None); string nsr = campos[0]; string tipo = campos[1]; if (tipo.Trim() == "3") { string data = campos[2]; string hora = campos[3]; string pis = campos[4]; DateTime datetime = Convert.ToDateTime(data.Substring(0, 2) + "/" + data.Substring(2, 2) + "/" + data.Substring(4, 4) + " " + hora.Substring(0, 2) + ":" + hora.Substring(2, 2)); marcacoes.Add(pis, datetime, Convert.ToInt32(nsr)); } } return(true); } else { LogErro(); return(false); } }
public static bool ExcluirFuncionariosSelecao(int Terminal, ListView listFuncionarios, TextBox edLog) { bool Result = false; Types.Terminal TerminalDados; DBApp db = new DBApp(); db.getDadosTerminal(Terminal, out TerminalDados); Rede rede = new Rede(TerminalDados.IP, edLog); if (!rede.Gertec_Conectar()) { return(Result); } if (listFuncionarios.SelectedIndices.Count > 1) { rede.log.AddLog(String.Format(Consts.FUNCIONARIOS_EXCLUINDO, listFuncionarios.SelectedIndices.Count)); } for (int i = 0; i <= listFuncionarios.SelectedIndices.Count - 1; i++) { int index = listFuncionarios.SelectedIndices[i]; string Nome = listFuncionarios.Items[index].SubItems[Consts.FUNC_SUBITEM_NOME].Text; string Pis = listFuncionarios.Items[index].SubItems[Consts.FUNC_SUBITEM_PIS].Text; int Funcionario = Convert.ToInt32(listFuncionarios.Items[index].SubItems[Consts.FUNC_SUBITEM_IND].Text); if (rede.Gertec_ExcluirFuncionario(Nome, Pis)) { db.MarcarFuncionarioComoNaoEnviado(Terminal, Funcionario); Result = true; } } rede.Gertec_Desconectar(); return(Result); }
private void MarcarSelecionadosComoNaoEnviados() { List <int> FuncionariosSelecionados = new List <int>(); if (listFuncionarios.SelectedIndices.Count == 0) { return; } for (int i = 0; i <= listFuncionarios.SelectedIndices.Count - 1; i++) { int index = listFuncionarios.SelectedIndices[i]; int Funcionario = Convert.ToInt32(listFuncionarios.Items[index].SubItems[Consts.FUNC_SUBITEM_IND].Text); FuncionariosSelecionados.Add(Funcionario); } DBApp db = new DBApp(); int Terminal = Convert.ToInt32(listRelogios.Items[listRelogios.SelectedIndices[0]].SubItems[Consts.TRM_SUBITEM_IND].Text); db.MarcarFuncionariosComoEnviados(Terminal, FuncionariosSelecionados); atualizar_funcionarios_teminal(); }
public ActionResult AddCheck(string appName, string tableName, FormCollection fc) { DBApp app = new DBApp() { Name = appName, ConnectionString = (new Entities()).Database.Connection.ConnectionString }; DBTable table = app.GetTable(tableName); foreach (string checkConstraint in table.GetCheckConstraints()) //constraint name control in table { if (checkConstraint == "CHK_" + appName + "_" + tableName + "_" + fc["checkName"]) { TempData["message-error"] = "Check constraint with name " + checkConstraint + " is already exist."; return RedirectToAction("Index", new { @appName = appName }); } } int i = 0; Conditions con = new Conditions(new SqlQuery()); Condition_Operators ope = new Condition_Operators(con); Condition_concat concat = new Condition_concat(con); while (fc["column[" + i + "]"] != null) { DBColumn col = table.columns.SingleOrDefault(x => x.Name == fc["column[" + i + "]"]); object val = table.ConvertValue(col, fc["value[" + i + "]"]); con.column(col.Name); con.isCheck = true; if (i != 0) concat.and(); ope = table.GetConditionOperators(con, fc["conOperator[" + i + "]"], val); i++; } table.AddCheck(fc["checkName"], con); app.SaveChanges(); TempData["message-success"] = "Check constraint " + fc["checkName"] + " was successfully added into table " + tableName + "."; return RedirectToAction("Index", new { @appName = appName }); }
public ActionResult Create(string appName, DBTable model) { if (!string.IsNullOrWhiteSpace(model.tableName)) { DBApp app = new DBApp() { Name = appName, ConnectionString = (new Entities()).Database.Connection.ConnectionString }; model.Application = app; foreach (DBTable t in app.GetTables())//can not create table with name, which is already exist { if (t.tableName == model.tableName) { TempData["message-error"] = "Table " + model.tableName + " can not be created. Table name " + model.tableName + " is already exist."; return RedirectToAction("Index", new { @appName = appName }); } } foreach (DBColumn c in model.columns)//column name must be unique in table, int p is for situation, when column is compared with itself { int p = 0; foreach (DBColumn d in model.columns) { if (c.Name == d.Name) { p = p + 1; if (p > 1) { TempData["message-error"] = "Table " + model.tableName + " can not be created. Column name " + c.Name + " is in table more then once."; return RedirectToAction("Index", new { @appName = appName }); } } } } model.Create(); foreach (DBColumn c in model.columns)//every colum with isUnique=true add query for AddUniqueValue into queries { List<string> unique = new List<string>(); if (c.isUnique) { unique.Add(c.Name); model.columns.AddUniqueValue(c.Name, unique); } } app.SaveChanges(); TempData["message-success"] = "Table " + model.tableName + " was successfully created."; return RedirectToAction("Index", new { @appName = appName }); } return View(model); }
public ActionResult DropColumn(string appName, string tableName, string columnName) { DBApp app = new DBApp() { Name = appName, ConnectionString = (new Entities()).Database.Connection.ConnectionString }; app.GetTable(tableName) .columns.DropFromDB(columnName); app.SaveChanges(); TempData["message-success"] = "Column " + columnName + " was successfully dropped."; return RedirectToAction("Details", new { @appName = appName, @tableName = tableName }); }
public ActionResult DropDefault(string tableName, string appName) { DBApp app = new DBApp() { Name = appName, ConnectionString = (new Entities()).Database.Connection.ConnectionString }; DBTable table = app.GetTable(tableName); if (table.columns.GetDefaults().Count == 0) //is there some default value to drop? { TempData["message-error"] = "Table has no default value to drop."; return RedirectToAction("Index", new { @appName = appName }); } ViewBag.Defaults = table.columns.GetDefaults(); return View(table); }
public ActionResult CreateCheck(string appName, string tableName) { DBApp app = new DBApp() { Name = appName, ConnectionString = (new Entities()).Database.Connection.ConnectionString }; DBTable table = app.GetTable(tableName); ViewBag.Column = table.columns.Select(x => x.Name); ViewBag.Operators = table.GetOperators(); return View("AddCheck", table); }
public ActionResult DropIndex(string appName, string tableName) { DBApp app = new DBApp() { Name = appName, ConnectionString = (new Entities()).Database.Connection.ConnectionString }; DBTable table = app.GetTable(tableName); List<string> indexNames = new List<string>(); foreach (DBIndex index in table.indices) //user can not drop cluster index, this foreach add every indexName into the list except cluster index´s name { if (index.indexName != "index_" + appName + tableName) { indexNames.Add(index.indexName); } } if (indexNames.Count != 0) { ViewBag.indeces = indexNames; return View(table); } TempData["message-error"] = "Table has no index to drop."; return RedirectToAction("Index", new { @appName = appName }); }
public ActionResult CreateForeignKey(string appName, string tableName) { DBApp app = new DBApp() { Name = appName, ConnectionString = (new Entities()).Database.Connection.ConnectionString }; DBTable table = app.GetTable(tableName); ViewBag.tables = app.GetTables().Select(t => t.tableName); ViewBag.Columns = table.columns.Select(x => x.Name); return View(new DBForeignKey() { sourceTable = table }); }
public override bool LerMarcacoes(Marcacoes marcacoes, AssepontoRep.Bridge.TipoImportacaoMarcacoes tipoimportacao) { bool Result = base.LerMarcacoes(marcacoes, tipoimportacao); DBApp db = new DBApp(); int ProximoNsr = db.getLastNsr(TerminalDados.Indice) + 1; string ArquivoTemp = Path.GetTempFileName(); int Contador = 0; if (Connect(TerminalDados.Indice)) { int resultado = envioDll.LeCadastro(TerminalDados.IP, 5, ProximoNsr.ToString(), ArquivoTemp); if (resultado == 0) { List <string> arquivo = new List <string>(); Wr.Classes.Files.ReadFile(ArquivoTemp, arquivo); foreach (string S in arquivo) { string[] linhaReg = S.Split(';'); if (linhaReg[1] == Convert.ToInt32(Marcacoes.TiposRegistroAfd.Marcacao).ToString()) { string Pis = linhaReg[4]; try { DateTime DataHora = new DateTime( Convert.ToInt32(linhaReg[2].Substring(4, 4)), Convert.ToInt32(linhaReg[2].Substring(2, 2)), Convert.ToInt32(linhaReg[2].Substring(0, 2)), Convert.ToInt32(linhaReg[3].Substring(0, 2)), Convert.ToInt32(linhaReg[3].Substring(2, 2)), 0 ); int Nsr = Convert.ToInt32(linhaReg[0]); marcacoes.Add(Pis, DataHora, Nsr); Contador++; Result = true; } catch { log.AddLog(S); Result = false; } } } File.Delete(ArquivoTemp); Disconnect(TerminalDados.Indice); } else { Disconnect(TerminalDados.Indice); LogMensagem(resultado); } } return(Result); }
public ActionResult DropTable(string appName, string tableName) { DBApp app = new DBApp() { Name = appName, ConnectionString = (new Entities()).Database.Connection.ConnectionString }; app.GetTable(tableName).Drop(); app.SaveChanges(); TempData["message-success"] = "Table " + tableName + " was successfully dropped."; return RedirectToAction("Index", new { @appName = appName }); }
public ActionResult RenameTable(string appName, DBTable model) { string tableName = TempData["oldTableName"].ToString(); if (!string.IsNullOrWhiteSpace(tableName)) { DBApp app = new DBApp() { Name = appName, ConnectionString = (new Entities()).Database.Connection.ConnectionString }; DBTable table = app.GetTable(tableName); table.Rename(model.tableName); app.SaveChanges(); TempData["message-success"] = "Table " + tableName + " was successfully renamed to " + model.tableName + "."; return RedirectToAction("Index", new { @appName = appName }); } return View(); }
public override bool LerMarcacoes(Marcacoes marcacoes, AssepontoRep.Bridge.TipoImportacaoMarcacoes tipoimportacao) { Disconnect(TerminalDados.Indice); Connect(TerminalDados.Indice); List <string> lstrEventData; string[] split; DBApp bd = new DBApp(); int last = bd.getLastNsr(TerminalDados.Indice); uint uiNSR = Convert.ToUInt32(last == 0 ? 1 : last); try { this._objController.RequestTotalNSR(); System.Threading.Thread.Sleep(100); lstrEventData = this._objController.GetEventData(); split = lstrEventData[6].Split(new string[] { " : " }, StringSplitOptions.None); uint uiMaxNSR = Convert.ToUInt32(split[1]); log.AddLog(":: ATENÇÃO :: A IMPORTAÇÃO DESSE RELÓGIO PODE DEMORAR, NÃO FINALIZE"); log.AddLog(" ATÉ QUE TENHA TERMINADO ..."); log.AddLog("AGUARDE..."); System.Threading.Thread.Sleep(100); for (uint i = uiNSR; i <= uiMaxNSR; i++) { this._objController.RequestEventByNSR(i); int seg = 0; System.Threading.Thread.Sleep(100); EConnectionState state = EConnectionState.SendingData; while (state == EConnectionState.SendingData) { state = this._objController.GetConnectionState(); //System.Threading.Thread.Sleep(100); seg++; } if (state == EConnectionState.DataReceived) { this._objController.SetConnectionState(EConnectionState.Connected); System.Threading.Thread.Sleep(100); lstrEventData = this._objController.GetEventData(); if (lstrEventData == null) { throw new Exception("Evento não encontrado."); } int tipo = -1; for (int c = 0; c < lstrEventData.Count; c++) { if (lstrEventData[c].Contains("Tipo do Registro")) { split = lstrEventData[c].Split(new string[] { " : " }, StringSplitOptions.None); tipo = Convert.ToInt32(split[1]); break; } } Marcacoes.Marcacao marc; if (tipo == 3) { marc = new Marcacoes.Marcacao(); marc.Tipo = Marcacoes.TiposRegistroAfd.Marcacao; split = lstrEventData[7].Split(new string[] { " : " }, StringSplitOptions.None); string nsr = split[1]; marc.NSR = Convert.ToInt32(nsr); split = lstrEventData[9].Split(new string[] { " : " }, StringSplitOptions.None); string datetime = split[1].Trim(); split = lstrEventData[10].Split(new string[] { " : " }, StringSplitOptions.None); datetime = datetime + " " + split[1].Trim(); marc.DataHora = Convert.ToDateTime(datetime); split = lstrEventData[11].Split(new string[] { " : " }, StringSplitOptions.None); string pis = split[1].Replace(".", "").Replace("-", "").Trim(); marc.Pis = pis; marcacoes.Add(marc); } } } bd.setLastNsr(TerminalDados.Indice, (int)uiMaxNSR); bool retorno = (marcacoes.Count > 0); Disconnect(TerminalDados.Indice); return(retorno); } catch (Exception exError) { log.AddLog(Consts.ERRO_ENVIO_COMANDO); log.AddLog("Descrição ", true); log.AddLog(exError.Message); Disconnect(TerminalDados.Indice); return(false); } }
public ActionResult TruncateTable(string appName, string tableName) { DBApp app = new DBApp() { Name = appName, ConnectionString = (new Entities()).Database.Connection.ConnectionString }; DBTable table = app.GetTable(tableName); table.Truncate(); app.SaveChanges(); return RedirectToAction("Data", new { @appName = appName, @tableName = tableName }); }
public ActionResult Constraint(string appName, string tableName, bool isDisable) { DBApp app = new DBApp() { Name = appName, ConnectionString = (new Entities()).Database.Connection.ConnectionString }; DBTable table = app.GetTable(tableName); ViewBag.Constraints = table.getConstraints(isDisable); if (isDisable) { if (table.getConstraints(isDisable).Count != 0) { return View("DisableConstraint", table); } TempData["message-error"] = "Table has no constraint to disable."; return RedirectToAction("Index", new { @appName = appName }); } else { if (table.getConstraints(isDisable).Count != 0) { return View("EnableConstraint", table); } TempData["message-error"] = "Table has no constraint to enable."; return RedirectToAction("Index", new { @appName = appName }); } }
public ActionResult DeleteOrUpdate(string appName, string tableName, FormCollection fc) { DBApp app = new DBApp() { Name = appName, ConnectionString = (new Entities()).Database.Connection.ConnectionString }; DBTable table = app.GetTable(tableName); DBItem row = new DBItem(); foreach (DBColumn c in table.columns)//converting to right data type { row.createProperty(c.ColumnId, c.Name, table.ConvertValue(c, fc.Get("col" + c.Name))); TempData.Remove(c.Name); TempData.Add(c.Name, row[c.Name]); } if (fc.Get("Update") != null) { ViewBag.Row = row.getAllProperties(); return View("UpdateView", table); } else { table.Remove(row); app.SaveChanges(); TempData["message-success"] = "Row was successfully deleted."; return RedirectToAction("Data", new { @appName = appName, @tableName = tableName }); } }
public ActionResult AddDefault(string appName, string tableName, string value, string defaultColumn) { DBApp app = new DBApp() { Name = appName, ConnectionString = (new Entities()).Database.Connection.ConnectionString }; DBTable table = app.GetTable(tableName); DBColumn c = table.columns.SingleOrDefault(s => s.Name == defaultColumn); object val = table.ConvertValue(c, value); table.columns.AddDefaultValue(defaultColumn, val); app.SaveChanges(); return RedirectToAction("Index", new { @appName = appName }); }
public ActionResult DropCheck(string tableName, string appName) { DBApp app = new DBApp() { Name = appName, ConnectionString = (new Entities()).Database.Connection.ConnectionString }; DBTable table = app.GetTable(tableName); if (table.GetCheckConstraints().Count == 0)//is there some check constraint to drop? { TempData["message-error"] = "Table has no check constraint to drop."; return RedirectToAction("Index", new { @appName = appName }); } ViewBag.Check = table.GetCheckConstraints(); return View(table); }
public ActionResult DropUnique(string appName, string tableName) { DBApp app = new DBApp() { Name = appName, ConnectionString = (new Entities()).Database.Connection.ConnectionString }; DBTable table = app.GetTable(tableName); if (table.columns.GetUniqueConstrainst().Count == 0) //if there are not unique constraints, is no need to continue into the view for drop { TempData["message-error"] = "Table has no unique constraint."; return RedirectToAction("Index", new { @appName = appName }); } ViewBag.Unique = table.columns.GetUniqueConstrainst(); return View(table); }
public ActionResult InsertSelect(string appName, string tableName, List<string> columnsA, List<string> columnsB, string tableB, FormCollection fc) { DBApp app = new DBApp() { Name = appName, ConnectionString = (new Entities()).Database.Connection.ConnectionString }; DBTable table = app.GetTable(tableName); Conditions con = new Conditions(new SqlQuery()); if (fc["conOperator[0]"] != "") { Condition_Operators ope = new Condition_Operators(con); Condition_concat concat = new Condition_concat(con); int i = 0; while (fc["column[" + i + "]"] != null) { DBColumn col = table.columns.SingleOrDefault(x => x.Name == fc["column[" + i + "]"]); object val = table.ConvertValue(col, fc["value[" + i + "]"]); con.column(col.Name); if (i != 0) concat.and(); ope = table.GetConditionOperators(con, fc["conOperator[" + i + "]"], val); i++; } } table.InsertSelect(columnsA, tableB, columnsB, con.ToString()); app.SaveChanges(); TempData["message-success"] = "Row(s) was successfully inserted."; return RedirectToAction("Data", new { @appName = appName, @tableName = tableName }); }
public ActionResult Details(string appName, string tableName) { DBApp app = new DBApp() { Name = appName, ConnectionString = (new Entities()).Database.Connection.ConnectionString }; TempData.Remove("oldTableName"); TempData.Add("oldTableName", tableName); return View(app.GetTable(tableName)); }
public ActionResult InsertSelect(string appName, string tableName) { DBApp app = new DBApp() { Name = appName, ConnectionString = (new Entities()).Database.Connection.ConnectionString }; DBTable table = app.GetTable(tableName); ViewBag.Operators = table.GetOperators(); return View(table); }
public ActionResult CreatePrimaryKey(string appName, string tableName) { DBApp app = new DBApp() { Name = appName, ConnectionString = (new Entities()).Database.Connection.ConnectionString }; DBTable table = app.GetTable(tableName); ViewBag.Columns = table.columns.Select(x => x.Name); return View(table); }
private void ler_grupo() { DBApp db = new DBApp(); Grupo = Convert.ToInt32(db.getFieldValueInteger("SELECT TOP 1 GRU_IND FROM Grupos")); }
public ActionResult DropForeignKey(string appName, string tableName) { DBApp app = new DBApp() { Name = appName, ConnectionString = (new Entities()).Database.Connection.ConnectionString }; DBTable table = app.GetTable(tableName); if (table.foreignKeys.GetForeignKeyForDrop().Count != 0) //if there are not foreign keys, is no need to continue into the view for drop { ViewBag.foreignKeys = table.foreignKeys.GetForeignKeyForDrop(); return View(table); } TempData["message-error"] = "Table has no foreign key to drop."; return RedirectToAction("Index", new { @appName = appName }); }
public ActionResult CreateUnique(string appName, string tableName) { DBApp app = new DBApp() { Name = appName, ConnectionString = (new Entities()).Database.Connection.ConnectionString }; DBTable table = app.GetTable(tableName); return View(table); }
public override bool LerMarcacoes(Marcacoes marcacoes, TipoImportacaoMarcacoes tipoimportacao) { base.LerMarcacoes(marcacoes, tipoimportacao); bool Result = false; DBApp db = new DBApp(); int ProximoNsr = db.getLastNsr(TerminalDados.Indice); int NRegistrosLidos = 0, statusColeta = 0, nsr = 0, ret = 0, tentativas = 0; bool recebeuUltimoBilhete = false; string dadosRegistro = string.Empty; if (Connect(0)) { try { nsr = ProximoNsr; while (!recebeuUltimoBilhete) { nsr++; ret = innerRep.SolicitarRegistroNsr(nsr); //string UltimoRegistro = innerRep.LerNumUltimoNsr(); if (ret == 0) { statusColeta = innerRep.LerStatusColeta(); tentativas = 0; while (statusColeta < 2 && tentativas < 1000) { Thread.Sleep(10); Application.DoEvents(); Thread.Sleep(10); statusColeta = innerRep.LerStatusColeta(); tentativas++; } if ((statusColeta == (int)Sdk_Inner_Rep.InnerRepPlusSDK.StatusLeitura.FINALIZADA_COM_ULTIMO_REGISTRO) || (statusColeta == (int)Sdk_Inner_Rep.InnerRepPlusSDK.StatusLeitura.FINALIZADA_COM_REGISTRO)) { string numSerie = innerRep.LerNumSerieRep(); statusColeta = innerRep.LerResultadoColeta(); dadosRegistro = innerRep.LerRegistroLinha(); if (dadosRegistro != "" && dadosRegistro != null) { AssepontoRep.Marcacoes.Marcacao mrc = new AssepontoRep.Marcacoes.Marcacao(); if (marcacoes.InterpretarRegistroAfd(dadosRegistro, out mrc)) { if (mrc.Tipo == Marcacoes.TiposRegistroAfd.Marcacao) { marcacoes.Add(mrc); } } } NRegistrosLidos++; } if ((statusColeta == (int)Sdk_Inner_Rep.InnerRepPlusSDK.StatusLeitura.FINALIZADA_SEM_REGISTRO) || (statusColeta == (int)Sdk_Inner_Rep.InnerRepPlusSDK.StatusLeitura.FINALIZADA_COM_ULTIMO_REGISTRO)) { recebeuUltimoBilhete = true; } } } if (marcacoes.Count == 0) { log.AddLog(Consts.MARCACOES_NAO_HA_NOVAS); } innerRep.FinalizarLeitura(); Result = true; } catch (Exception ex) { log.AddLog(ex.Message); } } return(Result); }
public ActionResult InsertRow(string appName, string tableName, FormCollection fc) { DBApp app = new DBApp() { Name = appName, ConnectionString = (new Entities()).Database.Connection.ConnectionString }; DBTable table = app.GetTable(tableName); bool isClusterIndex = false; foreach (DBIndex index in table.indices) //looking for cluster index between all indeces { if (index.indexName == "index_" + appName + tableName) { isClusterIndex = true; break; } } if (!isClusterIndex)//condition for cluster, you can not insert/update/delete without cluster in Azure { TempData["message-error"] = "Row can not be inserted, because table does not have a cluster index. The cluster index is created when you first create a primary key."; return RedirectToAction("Data", new { @appName = appName, @tableName = tableName }); } DBItem row = new DBItem(); foreach (DBColumn c in table.columns) //converting to right data type { if (fc.Get("col" + c.Name) == "") { row.createProperty(c.ColumnId, c.Name, null); } else { row.createProperty(c.ColumnId, c.Name, table.ConvertValue(c, fc.Get("col" + c.Name))); } } table.Add(row); app.SaveChanges(); TempData["message-success"] = "Row was successfully inserted."; return RedirectToAction("Data", new { @appName = appName, @tableName = tableName }); }
public override bool LerMarcacoes(Marcacoes marcacoes, AssepontoRep.Bridge.TipoImportacaoMarcacoes tipoimportacao) { bool Result = false; int NRegistrosLidos = 0; Connect(); try { DBApp db = new DBApp(); int ProximoNsr = db.getLastNsr(TerminalDados.Indice) + 1; if (!_rep.BuscarAFD(ProximoNsr)) { log.AddLog(Consts.MARCACOES_NAO_HA_NOVAS); } else { string cLinha; while (_rep.LerAFD(out cLinha)) { AssepontoRep.Marcacoes.Marcacao mrc = new AssepontoRep.Marcacoes.Marcacao(); if (marcacoes.InterpretarRegistroAfd(cLinha, out mrc)) { if (mrc.Tipo == Marcacoes.TiposRegistroAfd.Marcacao) { marcacoes.Add(mrc); } } //if (Convert.ToInt32(cLinha.Substring(9, 1)) == (int)(Marcacoes.TiposRegistroAfd.Marcacao)) //{ // string PIS = cLinha.Substring(22, 12).Replace("\n", "").Replace("\t", "").Replace("\r", ""); // string DataHora = cLinha.Substring(10, 12); // string NSR = cLinha.Substring(0, 9); // marcacoes.Add(PIS, extrairDateTime(DataHora), Convert.ToInt32(NSR)); //} NRegistrosLidos++; } if (NRegistrosLidos == 0) { log.AddLog(Consts.ERRO_ENVIO_COMANDO); } if (marcacoes.Count == 0) { log.AddLog(Consts.MARCACOES_NAO_HA_NOVAS); } Result = true; } } catch (Exception ex) { log.AddLog(ex.Message); Result = false; } finally { _rep.Desconectar(); } return(Result); }
public ActionResult Index(string appName) { DBApp app = new DBApp() { Name = appName, ConnectionString = (new Entities()).Database.Connection.ConnectionString }; return View(app.GetTables()); }
public ActionResult DropConstraint(string tableName, string appName, string constraintName, bool? isPrimaryKey) { DBApp app = new DBApp() { Name = appName, ConnectionString = (new Entities()).Database.Connection.ConnectionString }; DBTable table = app.GetTable(tableName); if (isPrimaryKey == true) { if (table.primaryKeys.Count == 0) //is there some primary key to drop? { TempData["message-error"] = "Table has no primary key to drop."; return RedirectToAction("Index", new { @appName = appName }); } } table.DropConstraint(constraintName, isPrimaryKey); app.SaveChanges(); TempData["message-success"] = "Constraint was successfully dropped."; return RedirectToAction("Index", new { @appName = appName }); }
public JsonResult getTableColumns(string tableName, string appName) { DBApp app = new DBApp() { Name = appName, ConnectionString = (new Entities()).Database.Connection.ConnectionString }; DBTable table = app.GetTable(tableName); List<string> tableColumns = table.columns.Select(x => x.Name).ToList(); return Json(tableColumns, JsonRequestBehavior.AllowGet); }
public bool Gertec_ImportarMarcacoes(int Terminal, string TerminalNome, Marcacoes marcacoes) { bool Result = false; DBApp db = new DBApp(); int ProximoNsr = db.getLastNsr(Terminal) + 1; string diretoriomarcacoes = Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments) + "\\Asseponto\\Marcacoes\\" + TerminalNome; Wr.Classes.Files.ForceDirectories(diretoriomarcacoes); string ArquivoTemp = Path.GetTempFileName(); System.Text.Encoding iso_8859_1 = System.Text.Encoding.GetEncoding("iso-8859-1"); int Contador = 0; if (Gertec_Conectar()) { int resultado = envioDll.LeCadastro(IP, 5, ProximoNsr.ToString(), ArquivoTemp); if (resultado == 0) { FileStream abreArquivoTxt = new FileStream(ArquivoTemp, FileMode.Open, FileAccess.Read); StreamReader sr = new StreamReader(abreArquivoTxt, iso_8859_1); string line = ""; while ((line = sr.ReadLine()) != null) { string[] linhaReg = line.Split(';'); if (linhaReg[1] == "3") { string Pis = linhaReg[4]; bool Erro = false; DateTime DataHora; try { DataHora = new DateTime( Convert.ToInt32(linhaReg[2].Substring(4, 4)), Convert.ToInt32(linhaReg[2].Substring(2, 2)), Convert.ToInt32(linhaReg[2].Substring(0, 2)), Convert.ToInt32(linhaReg[3].Substring(0, 2)), Convert.ToInt32(linhaReg[3].Substring(2, 2)), 0 ); int Nsr = Convert.ToInt32(linhaReg[0]); if (Nsr > ProximoNsr) { ProximoNsr = Nsr; } marcacoes.Add(Pis, DataHora, Nsr); Contador++; } catch { log.AddLog(line); Erro = true; } } } sr.Close(); File.Delete(ArquivoTemp); Gertec_Desconectar(); if (Contador > 0) { string Arquivo = marcacoes.SaveToFile(); log.AddLog(String.Format(Consts.ARQUIVO_GERADO, Arquivo)); Result = true; } else { log.AddLog(Consts.SEM_MARCACOES); } if (ProximoNsr > 0) { db.setLastNsr(Terminal, ProximoNsr); } } else { Gertec_Desconectar(); LogMensagem(resultado); } } return(Result); }
public ActionResult UpdateRow(string appName, string tableName, FormCollection fc) { DBApp app = new DBApp() { Name = appName, ConnectionString = (new Entities()).Database.Connection.ConnectionString }; DBTable table = app.GetTable(tableName); DBItem changes = new DBItem(); DBItem oldVal = new DBItem(); foreach (DBColumn c in table.columns)//converting to right data type { changes.createProperty(c.ColumnId, c.Name, table.ConvertValue(c, fc.Get("col" + c.Name))); oldVal.createProperty(c.ColumnId, c.Name, TempData[c.Name]); } table.Update(changes, oldVal); app.SaveChanges(); TempData["message-success"] = "Row was successfully updated."; return RedirectToAction("Data", new { @appName = appName, @tableName = tableName }); }
public ActionResult DeleteIndex(string appName, string tableName, string indexName) { DBApp app = new DBApp() { Name = appName, ConnectionString = (new Entities()).Database.Connection.ConnectionString }; DBTable table = app.GetTable(tableName); table.indices.DropFromDB(indexName); app.SaveChanges(); TempData["message-success"] = "Index " + indexName + " of table " + tableName + " was successfully dropped."; return RedirectToAction("Index", new { @appName = appName }); }
public ActionResult DisableOrEnableConstraint(string appName, string tableName, FormCollection fc, bool isDisable) { DBApp app = new DBApp() { Name = appName, ConnectionString = (new Entities()).Database.Connection.ConnectionString }; DBTable table = app.GetTable(tableName); string constraintName = (fc["all"] != null) ? "ALL" : fc["constraintName"]; if (isDisable) { table.DisableConstraint(constraintName); TempData["message-success"] = "Constraint of table " + tableName + " was successfully disabled."; } else { table.EnableConstraint(constraintName); TempData["message-success"] = "Constraint of table " + tableName + " was successfully enabled."; } app.SaveChanges(); return RedirectToAction("Index", new { @appName = appName }); }