private void RemoveRecibo(Recibo R)
{
//used to add a new recibo to the database
if (!verifyBDConnection())
{
return;
}
SqlCommand cmd = new SqlCommand("removeRecibo", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@rID", SqlDbType.Int).Value = R.reciboID;
try
{
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
throw new Exception("Failed to update recibo in database. \n ERROR MESSAGE: \n" + ex.Message);
}
finally
{
listBoxProdutosRecibo.Items.Clear();
cn.Close();
}
}
private void reciboSearch()
{
if (!verifyBDConnection())
{
return;
}
using (SqlCommand cmd = new SqlCommand("searchRecibo", cn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@reciboID", reciboSearchID);
SqlDataReader reader = cmd.ExecuteReader();
listBoxRecibos.Items.Clear();
while (reader.Read())
{
Recibo R = new Recibo();
R.reciboID = int.Parse(reader["reciboID"].ToString());
R.ClienteNIF = int.Parse(reader["ClienteNIF"].ToString());
R.EmpNIF = int.Parse(reader["EmpNIF"].ToString());
R.data_recibo = DateTime.Parse(reader["data_recibo"].ToString());
R.valor = float.Parse(reader["valor"].ToString());
listBoxRecibos.Items.Add(R);
}
reader.Close();
}
}
private void SubmitRecibo(Recibo R)
{
//used to add a new recibo to the database
if (!verifyBDConnection())
{
return;
}
SqlCommand cmd = new SqlCommand("insertRecibo", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@valor", SqlDbType.Float).Value = R.valor;
cmd.Parameters.Add("@ClienteNIF", SqlDbType.Int).Value = R.ClienteNIF;
cmd.Parameters.Add("@EmpNIF", SqlDbType.Int).Value = R.EmpNIF;
cmd.Parameters.Add("@data_recibo", SqlDbType.Date).Value = R.data_recibo;
try
{
cmd.ExecuteNonQuery();
cmd = new SqlCommand("getLastReciboID", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@lastID", System.Data.SqlDbType.Int).Direction = System.Data.ParameterDirection.ReturnValue;
cmd.ExecuteNonQuery();
R.reciboID = (int)cmd.Parameters["@lastID"].Value;
cmd = new SqlCommand("insertCompra", cn);
cmd.CommandType = CommandType.StoredProcedure;
foreach (Produto prod in reciboProds)
{
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@reciboID", R.reciboID);
cmd.Parameters.AddWithValue("@produtoID", prod.ID);
cmd.ExecuteNonQuery();
}
foreach (Produto prod in reciboProds)
{
cmd = new SqlCommand("getProdutoQ", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Produto_ID", prod.ID);
cmd.Parameters.AddWithValue("@recibo_ID", R.reciboID);
cmd.Parameters.Add("@prodQ", System.Data.SqlDbType.Int).Direction = System.Data.ParameterDirection.ReturnValue;
cmd.ExecuteNonQuery();
prod.quantidade = (int)cmd.Parameters["@prodQ"].Value;
}
reciboProds.Clear();
}
catch (Exception ex)
{
throw new Exception("Failed to update recibo in database. \n ERROR MESSAGE: \n" + ex.Message);
}
finally
{
cn.Close();
}
}
public void ShowProdsInRecibo()
{
if (!verifyBDConnection())
{
return;
}
Recibo recibo = new Recibo();
recibo = (Recibo)listBoxRecibos.Items[currentRecibo];
using (SqlCommand cmd = new SqlCommand("getProdutosInRecibo", cn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@reciboID", recibo.reciboID);
SqlDataReader reader = cmd.ExecuteReader();
listBoxProdutosRecibo.Items.Clear();
while (reader.Read())
{
Produto P = new Produto();
P.ID = int.Parse(reader["ID_P"].ToString());
P.preco = float.Parse(reader["precoP"].ToString());
P.tipo = int.Parse(reader["tipoP"].ToString());
P.nome = reader["nomeP"].ToString();
P.quantidade = int.Parse(reader["quantidade"].ToString());
listBoxProdutosRecibo.Items.Add(P);
}
reader.Close();
}
}
public void ShowRecibo()
{ //shows information of Recibo
if (listBoxRecibos.Items.Count == 0 | currentRecibo < 0)
{
return;
}
Recibo recibo = new Recibo();
recibo = (Recibo)listBoxRecibos.Items[currentRecibo];
textBoxClienteNIF.Text = recibo.ClienteNIF.ToString();
textBoxEmpNIF.Text = recibo.EmpNIF.ToString();
textBoxValor.Text = recibo.valor.ToString();
dateTimePicker1.Value = recibo.data_recibo;
//used to show the information of the Recibo in the corresponding boxes
}
private bool SaveRecibo()
{
Recibo R = new Recibo();
if (adding)
{
try
{
R.ClienteNIF = int.Parse(textBoxClienteNIF.Text);
R.EmpNIF = int.Parse(textBoxEmpNIF.Text);
R.data_recibo = dateTimePicker1.Value.Date;
R.valor = float.Parse(textBoxValor.Text);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return(false);
}
SubmitRecibo(R);
listBoxRecibos.Items.Add(R);
adding = false;
}
if (removing)
{
try
{
R = (Recibo)listBoxRecibos.Items[currentRecibo];
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return(false);
}
RemoveRecibo(R);
listBoxRecibos.Items.Remove(R);
removing = false;
}
return(true);
}
private void loadRecibos()
{ //loads all Recibos from the DB
if (!verifyBDConnection())
{
return;
}
using (SqlCommand cmd = new SqlCommand("SELECT * FROM Cafes.Recibo", cn)){;
SqlDataReader reader = cmd.ExecuteReader();
listBoxRecibos.Items.Clear();
while (reader.Read())
{
Recibo R = new Recibo();
R.reciboID = int.Parse(reader["reciboID"].ToString());
R.ClienteNIF = int.Parse(reader["ClienteNIF"].ToString());
R.EmpNIF = int.Parse(reader["EmpNIF"].ToString());
R.data_recibo = DateTime.Parse(reader["data_recibo"].ToString());
R.valor = float.Parse(reader["valor"].ToString());
listBoxRecibos.Items.Add(R);
}
reader.Close(); }
cn.Close();
currentRecibo = 0;
}
