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);
}
}
}
