private void btSalvar_Click(object sender, EventArgs e) { Configuration config = Firebird.ReturnConfiguration(); if (cbMin.Checked) { config.ListMin = 1; } else { config.ListMin = 0; } if (cbMax.Checked) { config.ListMax = 1; } else { config.ListMax = 0; } config.ListMinColor = ColorTranslator.ToHtml(btnMin.BackColor); config.ListMaxColor = ColorTranslator.ToHtml(btnMax.BackColor); Firebird.SaveConfig(config); form2.PaintMinMax(); MessageBox.Show("Configurações alteradas com sucesso!", "Sucesso!", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Close(); }
public void getEventsByIntervalRequestTest() { Firebird firebird = new Firebird(); var AllEvents = firebird.getEventsByIntervalRequest(); //If not Exeption, then Ok!!! //Assert.IsTrue(AllEvents.Count > 0); }
private void btnReset_Click(object sender, EventArgs e) { if (CurrentUser.IsAdmin != 1) { btnReset.Enabled = false; return; } else { btnReset.Enabled = true; if (MessageBox.Show("Tem certeza que deseja Resetar o Banco de Dados?\nAo resetar o banco perderá todos os dados já salvos nele.\nSó clique em 'Sim' se tiver " + "certeza dessa ação!", "Tem Certeza?", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { // Feito 3 funções para não dar erro em nenhuma exclusão Firebird.ResetLote(); Firebird.ResetMaquina(); Firebird.ResetUsuario(); MessageBox.Show("Resetado com sucesso!", "Sucesso", MessageBoxButtons.OK, MessageBoxIcon.Information); //Application.Restart(); } else { return; } } }
private void btDelete_Click(object sender, EventArgs e) { if (listViewLotes.SelectedItems.Count == 0) { MessageBox.Show("Por favor, selecione um lote.", "Aviso", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } if (!Firebird.UserHasPermission(1)) { return; } if (MessageBox.Show("Tem certeza que deseja excluir o lote selecionado?", "Tem Certeza?", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { Lote lote = new Lote(); lote = Firebird.ReturnLote(listViewLotes.SelectedItems[0].SubItems[0].Text, Convert.ToInt32(listViewLotes.SelectedItems[0].SubItems[1].Text), listViewLotes.SelectedItems[0].SubItems[3].Text); Firebird.DeleteAll(lote); for (int i = listaLotes.Count - 1; i >= 0; i--) { if (listaLotes[i].Maquina == lote.Maquina && listaLotes[i].NumLote == lote.NumLote && listaLotes[i].Calendario == lote.Calendario) { listaLotes.RemoveAt(i); } } } else { return; } WriteFilterLotes(listaLotes); }
public void getAnySqlQueryTest() { Firebird firebird = new Firebird(); var AllStaff = firebird.getAnySqlQuery("select * from STAFF"); Assert.IsTrue(AllStaff.Count > 0); }
public void getAllStaffTest() { Firebird firebird = new Firebird(); var AllStaff = firebird.getAllStaff(); Assert.IsTrue(AllStaff.Count > 0); }
private void CheckBoxes() { var config = Firebird.ReturnConfiguration(); cbValores.Checked = config.GraphValues == 1; cbMedio.Checked = config.GraphMedio == 1; cbMin.Checked = config.GraphMin == 1; cbMax.Checked = config.GraphMax == 1; }
public void Loading() { var config = Firebird.ReturnConfiguration(); cbMin.Checked = config.ListMin == 1; cbMax.Checked = config.ListMax == 1; btnMin.BackColor = ColorTranslator.FromHtml(config.ListMinColor); btnMax.BackColor = ColorTranslator.FromHtml(config.ListMaxColor); }
public void SetBeforeDtAndAfterDtTest() { Firebird firebird = new Firebird(); firebird.SetBeforeDtAndAfterDt(TimeSpan.Parse("00:00:17")); TimeSpan diff = firebird.afterDt - firebird.beforeDt; Assert.IsTrue(diff == TimeSpan.Parse("00:00:17")); }
public EljurBaseClass(Message Message, Config Config, Firebird Firebird, AllStaffAdder allStaffAdder, MsDbChecker MsDbChecker, MsDbUpdater MsDbUpdater, MsDbCleaner MsDbCleaner, EventHandlerEljur EventHandlerEljur) { this.message = new Message(); this.config = new Config(); this.firebird = new Firebird(); this.allStaffAdder = new AllStaffAdder(); this.msDbChecker = new MsDbChecker(); this.msDbUpdater = new MsDbUpdater(); this.msDbCleaner = new MsDbCleaner(); this.eventHandlerEljur = new EventHandlerEljur(); }
public Grafico(Lote _lote) { InitializeComponent(); lote = _lote; lista = Firebird.ReturnLeituras(lote); Header(); CreateChart(); CheckBoxes(); CreateToolTip(); }
public void WriteLeituras(Lote lote) { var listaLeituras = Firebird.ReturnLeituras(lote); if (listaLeituras.Count != lote.NumeroLeit) { MessageBox.Show("Ocorreu um erro ao puxar as leituras do lote " + lote.NumLote + "\n" + listaLeituras.Count + "*" + lote.NumeroLeit, "Erro!", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } listaLeituras = listaLeituras.OrderBy(c => c.Lote).ToList(); lbMaquina.Text = lote.Maquina; lbCalendario.Text = lote.Calendario; lbLote.Text = lote.NumLote.ToString(); lbNumero.Text = lote.NumeroLeit.ToString(); lbUser.Text = lote.Usuario; List <ListViewItem> toAdd = new List <ListViewItem>(); foreach (var b in listaLeituras) { ListViewItem item = new ListViewItem("item", 0); item.SubItems.Add((toAdd.Count + 1).ToString()); item.SubItems.Add(b.Calendario); item.SubItems.Add(b.TipoMadeira); item.SubItems.Add(b.Temperatura.ToString()); if (b.Temperatura >= 100) { // item.SubItems[6].Text = "-"; item.SubItems[3].Text = b.Densidade.ToString() + " Kg/m³"; item.SubItems[4].Text = " "; item.SubItems.Add("✔"); item.SubItems.Add("-"); } else { item.SubItems[3].Text = b.TipoMadeira.ToString(); item.SubItems[4].Text = "✔"; item.SubItems.Add(" "); item.SubItems.Add(b.Temperatura.ToString()); } string leitura = b.ValorLeitura.ToString(); leitura = leitura.Insert(leitura.Length - 1, ",").PadLeft(4, '0'); item.SubItems.Add(leitura); toAdd.Add(item); } listView.Items.Clear(); listView.Items.AddRange(toAdd.ToArray()); WriteHeader(lote); PaintMinMax(); }
private void ConnectLastUser() { if (isCreateAdmin) { return; } var LastUser = Firebird.ReturnLastUser(); txtUser.Text = LastUser.UserName; txtPassword.Text = LastUser.Password; btLogin_Click(null, null); }
private void btSalvar_Click(object sender, EventArgs e) { var config = Firebird.ReturnConfiguration(); if (cbValores.Checked) { config.GraphValues = 1; } else { config.GraphValues = 0; } if (cbMedio.Checked) { config.GraphMedio = 1; } else { config.GraphMedio = 0; } if (cbMin.Checked) { config.GraphMin = 1; } else { config.GraphMin = 0; } if (cbMax.Checked) { config.GraphMax = 1; } else { config.GraphMax = 0; } config.GraphValuesColor = ColorTranslator.ToHtml(btnValores.BackColor); config.GraphMedioColor = ColorTranslator.ToHtml(btnMedio.BackColor); config.GraphMinColor = ColorTranslator.ToHtml(btnMin.BackColor); config.GraphMaxColor = ColorTranslator.ToHtml(btnMax.BackColor); config.GraphLeiturasColor = ColorTranslator.ToHtml(btnLeituras.BackColor); if (Firebird.SaveConfig(config)) { MessageBox.Show("Configurações salvas com sucesso!", "Sucesso!", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("Erro ao salvar as configurações!", "Erro!", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public EljurBaseClass(Message Message, Config Config, MsDb MsDb, Firebird Firebird, TimeChecker TimeChecker, EljurApiSender EljurApiSender, MsDbCatcherFirstPass MsDbCatcherFirstPass, MsDbCatcherLastPass MsDbCatcherLastPass, MsDbSetter MsDbSetter) { this.message = Message; this.config = Config; this.msDb = new MsDb("name=StaffContext", config.ConfigsTreeIdResourceOutput1, config.ConfigsTreeIdResourceOutput2, config.ConfigsTreeIdResourceInput1, config.ConfigsTreeIdResourceInput2); this.firebird = Firebird; this.timeChecker = new TimeChecker(config.timeFromDel, config.timeToDel); this.eljurApiSender = EljurApiSender; this.msDbCatcherFirstPass = MsDbCatcherFirstPass; this.msDbCatcherLastPass = MsDbCatcherLastPass; this.msDbSetter = MsDbSetter; }
//zz扔剑刺火鸟和伙伴们惊呼! public void ZZandfriends(ref Firebird firebird, ref Sword sword, ref Wow wow) { if (firebird.HP < 1150) { zzTime += Time.deltaTime; sword.image.rectTransform.position += new Vector3(Time.deltaTime * sword.speed, Time.deltaTime * sword.speed, 0.0f); } if (zzTime > 5.0f) { zzTime += Time.deltaTime; sword.image.color = new Color(1, 1, 1, 0.0f); wow.image.color = new Color(1, 1, 1, 1.0f); Wscreenfade(ref wscreen); } }
private void Header() { lbLabel.Text = string.Format("Máquina {0} Lote Nº {1} com {2} Leituras", lote.Maquina, lote.NumLote, lote.NumeroLeit); lbMin.Text = (lote.Min / 10).ToString(); lbMedio.Text = (lote.Medio / 10).ToString(); lbMax.Text = (lote.Max / 10).ToString(); var config = Firebird.ReturnConfiguration(); btnValores.BackColor = ColorTranslator.FromHtml(config.GraphValuesColor); btnMedio.BackColor = ColorTranslator.FromHtml(config.GraphMedioColor); btnMin.BackColor = ColorTranslator.FromHtml(config.GraphMinColor); btnMax.BackColor = ColorTranslator.FromHtml(config.GraphMaxColor); btnLeituras.BackColor = ColorTranslator.FromHtml(config.GraphLeiturasColor); }
private void fillComboBox() { var lista = Firebird.ReturnListMaquina(); lista.Sort(); for (int i = 0; i < lista.Count; i++) { cbMachine.Items.Add(lista[i]); } if (cbMachine.Items.Count > 0 && cbMachine.SelectedIndex == -1) { cbMachine.SelectedIndex = 0; } cbMachine.Enabled = form2.isMachine; }
public void FillCarList() { Firebird Firebird = new Firebird(Guid.NewGuid(), "Firebird", 12.5); MajoretteTurbo MajoretteTurbo = new MajoretteTurbo(Guid.NewGuid(), "Majorette", 2); FireTurbo Fireturbo = new FireTurbo(Guid.NewGuid(), "Fire_Turbo", true); MercedesBenz MercedesBenz = new MercedesBenz(Guid.NewGuid(), "Mercedes", true, true); Beachcar Beachcar = new Beachcar(Guid.NewGuid(), "Beachcar", true, true); Lowrider Lowrider = new Lowrider(Guid.NewGuid(), "Firebird", 12.5); _Cars.Add(Firebird); _Cars.Add(MajoretteTurbo); _Cars.Add(Fireturbo); _Cars.Add(MercedesBenz); _Cars.Add(Beachcar); _Cars.Add(Lowrider); }
void Start() { orochi = new Orochi() { Attack = 10, HP = 1500, Cridamage = 20 }; firebird = new Firebird() { Attack = 15, HP = 1200, Cridamage = 45 }; poison = new Poison() { image = imgpoison, speed = 100.0f }; fire = new Fire() { image = imgfire, speed = 100.0f }; posionAD = new PosionAD() { image = imgposionAD }; posionCD = new PosionCD() { image = imgpoisonCD }; fireAD = new FireAD() { image = imgfireAD }; fireCD = new FireCD() { image = imgfireCD }; sword = new Sword() { image = imgsword, speed = 60.0f }; wow = new Wow() { image = imgwow }; wscreen = new Wscreen() { image = imgwscreen, speed = 1.0f }; }
private void SalvarConfiguracaoBackup_Click(object sender, EventArgs e) { Backup backup = Firebird.RetornaBackup(); if (backup == null && chkAtivarBackup.Checked) { backup = new Backup(); //backup.Ativo = 1; backup.Periodo = cmbPeriodo.SelectedIndex; backup.CaminhoBackup = CaminhoBackup.Text; bool retorno = Firebird.SaveBackup(backup); if (retorno) { MessageBox.Show("Backup Salvo com Sucesso.", "Sucesso", MessageBoxButtons.OK, MessageBoxIcon.None); } else { MessageBox.Show("Erro ao tentar salvar o backup. Verifique o log de erro para obter mais informações.", "Atenção", MessageBoxButtons.OK, MessageBoxIcon.Information); } } else if (chkAtivarBackup.Checked) { //backup.Ativo = 1; backup.Periodo = cmbPeriodo.SelectedIndex; backup.CaminhoBackup = CaminhoBackup.Text; string data = DateTime.Now.ToString(); backup.DataUltimoBackup = data.Substring(0, 10); bool retorno = Firebird.AlterarDataUltimoBackup(backup.DataUltimoBackup); if (retorno) { MessageBox.Show("Alterado as configurações do Backup", "Sucesso", MessageBoxButtons.OK, MessageBoxIcon.None); } else { MessageBox.Show("Erro ao tentar alterar o backup!", "Erro!", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else if (backup != null && chkAtivarBackup.Checked == false) { if (MessageBox.Show("Você desativou o backup automático.Deseja confirmar?", "Confirmar", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { Firebird.DeletaBackup(); } } }
private void listViewLotes_SelectedIndexChanged(object sender, EventArgs e) { if (listViewLotes.SelectedItems.Count == 0) { return; } Lote lote = new Lote(); lote.Maquina = listViewLotes.SelectedItems[0].SubItems[0].Text; lote.NumLote = Convert.ToInt32(listViewLotes.SelectedItems[0].SubItems[1].Text); lote.Calendario = listViewLotes.SelectedItems[0].SubItems[3].Text; CurrentLote = Firebird.ReturnLote(lote.Maquina, lote.NumLote, lote.Calendario); WriteLeituras(CurrentLote); }
private void btFiltrar_Click(object sender, EventArgs e) { if (listViewMaquinas.SelectedItems.Count == 0) { MessageBox.Show("Selecione uma máquina para acessar os seus lotes", "Aviso", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } string machine = listViewMaquinas.SelectedItems[0].SubItems[0].Text; var Lista = Firebird.ReturnLotesFromMachine(machine); Form2 form = new Form2(Lista, machine); form.Closed += (s, args) => this.Close(); form.Show(); }
private void btSalvar_Click(object sender, EventArgs e) { if (!isUpdate) { form1.CurrentDescription = txtDescricao.Text; Firebird.SaveNewMachine(form1.CurrentMachine, txtDescricao.Text); MachineSaved = true; } else { maquina.Descricao = txtDescricao.Text; Firebird.ChangeDescription(maquina); formLista.FillListView(); } this.Close(); }
public void FiltrarPorData() { var listaOriginal = Firebird.ReturnListLotes(); DateTime dtInicio = new DateTime(); DateTime dtFim = new DateTime(); if (rbMes.Checked) { dtInicio = DateTime.Now.AddMonths(-1); dtFim = DateTime.Now; } if (rbSemana.Checked) { dtInicio = DateTime.Now.AddDays(-7); dtFim = DateTime.Now; } if (rbTodos.Checked) { listaFinal = listaOriginal; form2.WriteFilterLotes(listaFinal); return; } if (rbPersonalizado.Checked) { dtInicio = dateTimePickerInicio.Value; dtFim = dateTimePickerFim.Value; } if (dtInicio > dtFim) { MessageBox.Show("Valores fornecidos para a data não são válidos!", "Erro!", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } foreach (var item in listaOriginal) { DateTime dt = new DateTime(2020, 05, 05, 00, 00, 00); //DateTime.ParseExact(item.Calendario.Substring(0, 10), "dd/MM/yyyy", CultureInfo.InvariantCulture); if (Between(dt, dtInicio, dtFim)) { listaFinal.Add(item); } } }
public void FillListView() { var lista = Firebird.ReturnMaquinas(); lista = lista.OrderByDescending(c => c.Nome).ToList(); List <ListViewItem> toAdd = new List <ListViewItem>(); for (int i = lista.Count - 1; i >= 0; i--) { ListViewItem viewItem = new ListViewItem(lista[i].Nome, 0); viewItem.SubItems.Add(lista[i].Descricao); viewItem.SubItems.Add(lista[i].Quantidade.ToString()); toAdd.Add(viewItem); } listViewMaquinas.Items.Clear(); listViewMaquinas.Items.AddRange(toAdd.ToArray()); }
private void btDeletar_Click(object sender, EventArgs e) { string userDel = dataGridView1.SelectedCells[0].Value.ToString(); if (CurrentUser?.IsAdmin != 1) { MessageBox.Show("Apenas o administrador pode deletar um usuário.", "Aviso!", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } if (userDel == Admin.UserName) { MessageBox.Show("Não é possível deletar a conta do administrador!", "Aviso!", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } if (userDel == "True" || userDel == "False") { MessageBox.Show("Por favor, selecione o nome do usuário a ser deletado.", "Aviso!", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } string s = string.Format("Tem certeza que deseja deletar o usuário '{0}'?", userDel); DialogResult result = MessageBox.Show(s, "Aviso!", MessageBoxButtons.OKCancel, MessageBoxIcon.Question); if (result == DialogResult.Cancel) { return; } Usuario toDelete = new Usuario(); foreach (var item in listUsers) { if (item.UserName == userDel) { toDelete = item; } } Firebird.DeleteUser(toDelete); FillDataGrid(); MessageBox.Show("O usuário foi deletado com sucesso!", "Sucesso!", MessageBoxButtons.OK, MessageBoxIcon.Information); }
private void Command86() { if (Received.Count != 4) { return; } List <string> lista = Firebird.ReturnListMaquina(); List <string> temp = new List <string>(); for (int i = 1; i < 4; i++) { temp.Add(Received[i].ToString().PadLeft(2, '0')); } CurrentMachine = string.Format("{0}{1}-{2}", temp[0], temp[1], temp[2]); CurrentDescription = Firebird.ReturnCurrentDescription(CurrentMachine); lbMaquina.Text = CurrentDescription + $" ({CurrentMachine})"; EndCommand(); bool Exists = false; foreach (var item in lista) { if (item == CurrentMachine) { Exists = true; break; } } if (!Exists) { DialogResult result = MessageBox.Show("Nova máquina conectada, deseja salvá-la?", "Aviso", MessageBoxButtons.YesNo); if (result == DialogResult.Yes) { NovaMaquina form = new NovaMaquina(this); form.ShowDialog(); } } else { CurrentDescription = Firebird.ReturnCurrentDescription(CurrentMachine); } }
private void btSalvar_Click(object sender, EventArgs e) { if (CurrentUser?.IsAdmin != 1) { MessageBox.Show("Apenas o administrador pode fazer alterações nos usuários.", "Aviso!", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } for (int i = 0; i < dataGridView1.Rows.Count; i++) { DataGridViewRow selectedRow = dataGridView1.Rows[i]; if ((bool)selectedRow.Cells[1].Value == true) { listUsers[i].CanAdd = 1; } else { listUsers[i].CanAdd = 0; } if ((bool)selectedRow.Cells[2].Value == true) { listUsers[i].CanDelete = 1; } else { listUsers[i].CanDelete = 0; } if ((bool)selectedRow.Cells[3].Value == true) { listUsers[i].CanAlter = 1; } else { listUsers[i].CanAlter = 0; } Firebird.UpdateUser(listUsers[i], listUsers[i]); } MessageBox.Show("Alterações salvas com sucesso!", "Sucesso!", MessageBoxButtons.OK, MessageBoxIcon.Information); }
public void PaintMinMax() { var config = Firebird.ReturnConfiguration(); string Min = lbMin.Text; string Max = lbMax.Text; for (int i = 0; i < listView.Items.Count; i++) { listView.Items[i].BackColor = Color.White; if (listView.Items[i].SubItems[5].Text == Min && config.ListMin == 1) { listView.Items[i].BackColor = ColorTranslator.FromHtml(config.ListMinColor); } if (listView.Items[i].SubItems[5].Text == Max && config.ListMax == 1) { listView.Items[i].BackColor = ColorTranslator.FromHtml(config.ListMaxColor); } } }