private void UpdateDataGridView()
{
try
{
listaEncomendas.Clear();
conn.Open();
com.Connection = conn;
SqlCommand cmd = new SqlCommand("select enc.IdEncomenda, enc.Nfatura, fornecedor.nome, enc.dataRegistoEncomenda, enc.dataEntregaPrevista, enc.dataEntregaReal from Fornecedor fornecedor JOIN Encomenda enc ON fornecedor.IdFornecedor = enc.idFornecedor WHERE enc.dataEntregaReal IS NULL ORDER BY enc.IdEncomenda", conn);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
string dataRegistoEnc = DateTime.ParseExact(reader["dataRegistoEncomenda"].ToString(), "dd/MM/yyyy HH:mm:ss", null).ToString("dd/MM/yyyy");
string dataEntregaPrev = DateTime.ParseExact(reader["dataEntregaPrevista"].ToString(), "dd/MM/yyyy HH:mm:ss", null).ToString("dd/MM/yyyy");
string dataEntregaR = "";
if (reader["dataEntregaReal"].ToString() != "")
{
dataEntregaR = DateTime.ParseExact(reader["dataEntregaReal"].ToString(), "dd/MM/yyyy HH:mm:ss", null).ToString("dd/MM/yyyy");
}
Encomendas encomendas = new Encomendas
{
IdEncomenda = (int)reader["IdEncomenda"],
NFatura = (string)reader["Nfatura"],
nome = (string)reader["nome"],
dataRegisto = dataRegistoEnc,
dataEntregaPrevista = dataEntregaPrev,
dataEntregaReal = dataEntregaR,
};
listaEncomendas.Add(encomendas);
}
var bindingSource1 = new System.Windows.Forms.BindingSource {
DataSource = listaEncomendas
};
dataGridViewEncomendas.DataSource = bindingSource1;
dataGridViewEncomendas.Columns[0].HeaderText = "Número da Encomenda";
dataGridViewEncomendas.Columns[1].HeaderText = "Nome Fornecedor";
dataGridViewEncomendas.Columns[2].HeaderText = "Data de Registo da Encomanda";
dataGridViewEncomendas.Columns[3].HeaderText = "Data de Entrega Prevista";
dataGridViewEncomendas.Columns[4].HeaderText = "Data de Entrega Real";
dataGridViewEncomendas.Columns[5].Visible = false;
conn.Close();
auxiliar = listaEncomendas;
dataGridViewEncomendas.Update();
dataGridViewEncomendas.Refresh();
}
catch (Exception)
{
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
MessageBox.Show("Por erro interno é impossível selecionar os dados!", "Atenção!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public LinhaEncomenda(ClassFornecedor forn, Encomendas enc, RegistarEncomendas registarEncomendas)
{
InitializeComponent();
encomendas = enc;
registar = registarEncomendas;
fornecedor = forn;
label11.Text = "Fornecedor: " + fornecedor.nome;
conn.ConnectionString = @"Data Source=(localdb)\MSSQLLocalDB;Initial Catalog=SiltesSaude;Integrated Security=True;Connect Timeout=30;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False";
//var bindingSource2 = new System.Windows.Forms.BindingSource { DataSource = encomendas };
//dataGridViewEncomenda.DataSource = bindingSource2;
}
public void reiniciar()
{
try
{
listaEnc.Clear();
cbEncomendas.Items.Clear();
auxiliar.Clear();
conn.Open();
com.Connection = conn;
SqlCommand cmd = new SqlCommand("select * from Encomenda WHERE dataEntregaReal IS NULL order by Nfatura asc", conn);
// cmd.Parameters.AddWithValue("@Null", DBNull.Value);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
string data = DateTime.ParseExact(reader["dataRegistoEncomenda"].ToString(), "dd/MM/yyyy HH:mm:ss", null).ToString("dd/MM/yyyy");
string dataPrevista = DateTime.ParseExact(reader["dataEntregaPrevista"].ToString(), "dd/MM/yyyy HH:mm:ss", null).ToString("dd/MM/yyyy");
ComboBoxItem item = new ComboBoxItem();
item.Text = (string)reader["Nfatura"];
item.Value = (int)reader["IdEncomenda"];
cbEncomendas.Items.Add(item);
Encomendas enc = new Encomendas
{
NFatura = (string)reader["Nfatura"],
//nome = (string)reader["idFornecedor"],
dataRegisto = data,
dataEntregaPrevista = dataPrevista,
IdEncomenda = (int)reader["IdEncomenda"],
};
listaEnc.Add(enc);
}
conn.Close();
}
catch (Exception)
{
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
MessageBox.Show("Por erro interno é impossível visualizar os dados!", "Atenção!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void dataGridViewEncomendas_MouseDoubleClick(object sender, MouseEventArgs e)
{
int i = dataGridViewEncomendas.CurrentCell.RowIndex;
foreach (var enc in auxiliar)
{
if (enc.NFatura == (Convert.ToString(dataGridViewEncomendas.Rows[i].Cells[0].Value)))
{
encomendas = enc;
}
}
if (encomendas != null)
{
txtNumeroEncomenda.Text = (encomendas.NFatura).ToString();
//txtNumeroEncomenda.Text = Convert.ToString(encomendas.IdEncomenda);
txtFornecedor.Text = encomendas.nome;
labelData.Text = encomendas.dataRegisto;
txtDataEntregaPrevista.Text = encomendas.dataEntregaPrevista;
// dataVEntregaReal.Value = DateTime.ParseExact(encomendas.dataEntregaReal, "dd/MM/yyyy", null) ;
}
}
private void btnGuardar_Click(object sender, EventArgs e)
{
try
{
if (VerificarDadosInseridos())
{
int fornecedor = (comboBoxFornecedor.SelectedItem as ComboBoxItem).Value;
DateTime data = dataEntregaPrevista.Value;
// string observacoes = txtObservacoes.Text;
string encomenda = txtNumeroEncomenda.Text;
conn.Open();
string queryInsertData = "INSERT INTO Encomenda(Nfatura,idFornecedor,dataRegistoEncomenda,dataEntregaPrevista) VALUES(@Nfatura,@IdFornecedor,@DataRegistoEncomenda,@DataEntregaPrevista);";
SqlCommand sqlCommand = new SqlCommand(queryInsertData, conn);
sqlCommand.Parameters.AddWithValue("@DataEntregaPrevista", data.ToString("MM/dd/yyyy"));
sqlCommand.Parameters.AddWithValue("@DataRegistoEncomenda", inicio.ToString("MM/dd/yyyy"));
sqlCommand.Parameters.AddWithValue("@IdFornecedor", fornecedor);
sqlCommand.Parameters.AddWithValue("@Nfatura", encomenda);
sqlCommand.ExecuteNonQuery();
MessageBox.Show("Encomenda registada com Sucesso!", "Sucesso!", MessageBoxButtons.OK, MessageBoxIcon.Information);
conn.Close();
UpdateDataGridView();
conn.Open();
Encomendas enc = null;
string nurEncomenda = txtNumeroEncomenda.Text;
string queryInsertData1 = "SELECT * from Encomenda WHERE Nfatura = @Numfatura";
SqlCommand sqlCommand1 = new SqlCommand(queryInsertData1, conn);
sqlCommand1.Parameters.AddWithValue("@Numfatura", nurEncomenda);
SqlDataReader reader = sqlCommand1.ExecuteReader();
while (reader.Read())
{
enc = new Encomendas
{
IdEncomenda = (int)reader["IdEncomenda"],
NFatura = (string)reader["Nfatura"],
};
}
conn.Close();
LinhaEncomenda linha = new LinhaEncomenda(getFornecedor(fornecedor), enc, this);
linha.Show();
limparCampos();
}
}
catch (SqlException)
{
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
MessageBox.Show("Por erro interno é impossível registar a encomenda!", "Atenção!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public void UpdateDataGridView()
{
listaEncomendas.Clear();
conn.Open();
com.Connection = conn;
SqlCommand cmd = new SqlCommand("select enc.NFatura, fornecedor.nome, enc.dataRegistoEncomenda, enc.dataEntregaPrevista from Fornecedor fornecedor JOIN Encomenda enc ON fornecedor.IdFornecedor = enc.idFornecedor WHERE enc.dataEntregaReal IS NULL ORDER BY dataRegistoEncomenda", conn);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
string dataRegistoEnc = DateTime.ParseExact(reader["dataRegistoEncomenda"].ToString(), "dd/MM/yyyy HH:mm:ss", null).ToString("dd/MM/yyyy");
string dataEntregaPrev = DateTime.ParseExact(reader["dataEntregaPrevista"].ToString(), "dd/MM/yyyy HH:mm:ss", null).ToString("dd/MM/yyyy");
Encomendas encomendas = new Encomendas
{
NFatura = (string)reader["NFatura"],
nome = (string)reader["nome"],
dataRegisto = dataRegistoEnc,
dataEntregaPrevista = dataEntregaPrev,
};
listaEncomendas.Add(encomendas);
}
var bindingSource1 = new System.Windows.Forms.BindingSource {
DataSource = listaEncomendas
};
dataGridViewEncomendas.DataSource = bindingSource1;
dataGridViewEncomendas.Columns[0].HeaderText = "Número da Fatura";
dataGridViewEncomendas.Columns[1].HeaderText = "Nome Fornecedor";
dataGridViewEncomendas.Columns[2].HeaderText = "Data de Registo da Encomenda";
dataGridViewEncomendas.Columns[3].HeaderText = "Data de Entrega Prevista";
dataGridViewEncomendas.Columns[4].Visible = false;
dataGridViewEncomendas.Columns[5].Visible = false;
conn.Close();
dataGridViewEncomendas.Update();
dataGridViewEncomendas.Refresh();
conn.Open();
com.Connection = conn;
SqlCommand cmd1 = new SqlCommand("select enc.NFatura, fornecedor.nome, enc.dataRegistoEncomenda, enc.dataEntregaPrevista from Fornecedor fornecedor JOIN Encomenda enc ON fornecedor.IdFornecedor = enc.idFornecedor ORDER BY dataRegistoEncomenda", conn);
SqlDataReader reader1 = cmd1.ExecuteReader();
while (reader1.Read())
{
string dataRegistoEnc = DateTime.ParseExact(reader1["dataRegistoEncomenda"].ToString(), "dd/MM/yyyy HH:mm:ss", null).ToString("dd/MM/yyyy");
string dataEntregaPrev = DateTime.ParseExact(reader1["dataEntregaPrevista"].ToString(), "dd/MM/yyyy HH:mm:ss", null).ToString("dd/MM/yyyy");
Encomendas encomendas = new Encomendas
{
NFatura = (string)reader1["NFatura"],
nome = (string)reader1["nome"],
dataRegisto = dataRegistoEnc,
dataEntregaPrevista = dataEntregaPrev,
};
todasEncomendas.Add(encomendas);
}
conn.Close();
}
