private void button1_Click_1(object sender, EventArgs e)
{
string connectionString = ConfigurationManager.ConnectionStrings["AMD"].ConnectionString;
SqlConnection con = new SqlConnection(connectionString);
string id = textBox1.Text;
string password = textBox2.Text;
SqlCommand cmd = new SqlCommand("Select * from Users where Id=@Id and Password=@Password", con);
cmd.Parameters.AddWithValue("@Id", textBox1.Text);
cmd.Parameters.AddWithValue("@Password", textBox2.Text);
con.Open();
SqlDataAdapter adapt = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
adapt.Fill(ds);
con.Close();
int count = ds.Tables[0].Rows.Count;
//If count is equal to 1, then show Menu
if (count == 1)
{
// update na BD dos logins
SqlCommand com = new SqlCommand("INSERT INTO Logins (\"User\", DataLogin) VALUES (@User, @DataLogin)", con);
com.CommandType = CommandType.Text;
DateTime myDateTime = DateTime.Now;
string sqlFormattedDate = myDateTime.ToString("u");
com.Parameters.AddWithValue("@User", textBox1.Text);
com.Parameters.AddWithValue("@DataLogin", sqlFormattedDate);
con.Open();
int i = com.ExecuteNonQuery();
con.Close();
MessageBox.Show("Bem vindo!");
MainFormView.ShowForm(new Menu());
}
else
{
MessageBox.Show("Por favor verifique o seu Username e Password!");
}
}
private void BD_Click(object sender, EventArgs e)
{
MainFormView.ShowForm(new BDpage());
string connectionString = ConfigurationManager.ConnectionStrings["AMD"].ConnectionString;
SqlConnection con = new SqlConnection(connectionString);
SqlCommand com2 = new SqlCommand("DELETE FROM EncomendasFritas", con);
//SqlCommand com3 = new SqlCommand("DELETE FROM PlanoSemanal", con);
com2.CommandType = CommandType.Text;
//com3.CommandType = CommandType.Text;
con.Open();
int i = com2.ExecuteNonQuery();
//int j = com3.ExecuteNonQuery();
con.Close();
}
private void button1_Click(object sender, EventArgs e)
{
MainFormView.ShowForm(new GerirVeiculos());
}
private void tabelaPrecos_Click(object sender, EventArgs e)
{
MainFormView.ShowForm(new GestorDePrecos());
}
private void AddTrans_Click(object sender, EventArgs e)
{
MainFormView.ShowForm(new AddTransp());
}
private void CriarEncomenda_Click(object sender, EventArgs e)
{
MainFormView.ShowForm(new Form1());
}
private void button6_Click(object sender, EventArgs e)
{
MainFormView.ShowForm(new GerirEncomendas());
}
private void button4_Click(object sender, EventArgs e)
{
MainFormView.ShowForm(new GerirUtilizadores());
}
private void button2_Click(object sender, EventArgs e)
{
MainFormView.ShowForm(new GerirTransportadoras());
}
private void button7_Click(object sender, EventArgs e)
{
MainFormView.ShowForm(new GerirArmazens());
}
private void button1_Click_1(object sender, EventArgs e)
{
MainFormView.ShowForm(new AddRemovePaletes());
}
private void prevCarga_Click(object sender, EventArgs e)
{
MainFormView.ShowForm(new PrevisaoCargaSemanal());
}
private void PlanoSemana_Click(object sender, EventArgs e)
{
MainFormView.ShowForm(new PlanoSemanal());
}
private void Arquivo_Click(object sender, EventArgs e)
{
MainFormView.ShowForm(new Arquivo());
}
private void GerirZonas_Click(object sender, EventArgs e)
{
MainFormView.ShowForm(new GerirZonas());
}
private void button1_Click_1(object sender, EventArgs e)
{
MainFormView.ShowForm(new GerirClientes());
}
private void button8_Click(object sender, EventArgs e)
{
MainFormView.ShowForm(new GerirPaletes());
}
private void button3_Click(object sender, EventArgs e)
{
MainFormView.ShowForm(new GerirComerciais());
}
private void AddCliente_Click(object sender, EventArgs e)
{
MainFormView.ShowForm(new AddCliente());
}
private void button5_Click(object sender, EventArgs e)
{
MainFormView.ShowForm(new GerirPlanoSemanal());
}
private void AddComer_Click(object sender, EventArgs e)
{
MainFormView.ShowForm(new AddComercial());
}
private void button1_Click(object sender, EventArgs e)
{
MainFormView.ShowForm(new BDpage());
}
private void AddVeiculo_Click(object sender, EventArgs e)
{
MainFormView.ShowForm(new AddVeiculo());
}