public string InserirReceitas(Receitas receita)
{
string result = "ok";
try
{
ConnetionPostgres connectionPostgres = new ConnetionPostgres();
using (NpgsqlConnection conn = new NpgsqlConnection(connectionPostgres.ConnString))
{
conn.Open();
NpgsqlCommand cmd = new NpgsqlCommand();
cmd.Connection = conn;
cmd.CommandText = "Insert into public.\"KitSabor\" values(@Descricao)";
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add(new NpgsqlParameter("@Descricao", receita.Descricao));
cmd.ExecuteNonQuery();
//RETORNA ULTIMO ID
cmd.CommandText = "select \"kitSaborID\" from public.\"KitSabor\" ORDER BY \"kitSaborID\" DESC LIMIT 1";
cmd.CommandType = CommandType.Text;
LastInsertID = Convert.ToInt32(cmd.ExecuteScalar());
cmd.Dispose();
conn.Close();
}
}
catch (Exception ex)
{
return("ERROR : " + ex.ToString());
}
return(result);
}
public string IncluirItensDaReceita(ReceitaItem receitaItem)
{
string result = "ok";
try
{
ConnetionPostgres connectionPostgres = new ConnetionPostgres();
/* Insertion After Validations*/
using (NpgsqlConnection conn = new NpgsqlConnection(connectionPostgres.ConnString))
{
conn.Open();
NpgsqlCommand cmd = new NpgsqlCommand();
cmd.Connection = conn;
cmd.CommandText = "Insert into public.\"ReceitaItem\" values(@ReceitaID,@KitSaborID)";
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add(new NpgsqlParameter("@ReceitaID", receitaItem.ReceitaID));
cmd.Parameters.Add(new NpgsqlParameter("@KitSaborID", receitaItem.KitSaborID));
cmd.ExecuteNonQuery();
cmd.Dispose();
conn.Close();
}
}
catch (Exception ex)
{
return("ERROR : " + ex.ToString());
}
return(result);
}
public string InserirCapuslaDeCafe(CapsulasDeCafe capsula)
{
string result = "ok";
try
{
ConnetionPostgres connectionPostgres = new ConnetionPostgres();
/* Insertion After Validations*/
using (NpgsqlConnection conn = new NpgsqlConnection(connectionPostgres.ConnString))
{
conn.Open();
NpgsqlCommand cmd = new NpgsqlCommand();
cmd.Connection = conn;
cmd.CommandText = "Insert into public.\"Capsulas\" values(@Descricao,@Forca)";
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add(new NpgsqlParameter("@Descricao", capsula.Descricao));
cmd.Parameters.Add(new NpgsqlParameter("@Forca", capsula.Forca));
cmd.ExecuteNonQuery();
cmd.Dispose();
conn.Close();
}
}
catch (Exception ex)
{
return("ERROR : " + ex.ToString());
}
return(result);
}
private void PreencheDataGrid()
{
ConnetionPostgres connectionPostgres = new ConnetionPostgres();
NpgsqlConnection conn = new NpgsqlConnection(connectionPostgres.ConnString);
string sql = "SELECT * FROM public.\"KitCapsulas\"";
NpgsqlCommand cmd;
DataTable dt;
try
{
conn.Open();
cmd = new NpgsqlCommand(sql, conn);
dt = new DataTable();
dt.Load(cmd.ExecuteReader());
dgvKitCapsulas.DataSource = dt;
conn.Close();
}
catch (Exception)
{
MessageBox.Show("Não conseguimos conectar ao servidor, por favor verifique os parametros de configuração!");
FormConnectionConfig form = new FormConnectionConfig();
form.Show();
form.Activate();
}
}
public string InserirCapuslaDeCafe(KitCapsulas kitCapsula)
{
string result = "ok";
try
{
ConnetionPostgres connectionPostgres = new ConnetionPostgres();
/* Insertion After Validations*/
using (NpgsqlConnection conn = new NpgsqlConnection(connectionPostgres.ConnString))
{
conn.Open();
NpgsqlCommand cmd = new NpgsqlCommand();
cmd.Connection = conn;
cmd.CommandText = "Insert into public.\"KitCapsulas\" values(@KitCapulasID,@Quantidade,@KitSaborID)";
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add(new NpgsqlParameter("@KitCapulasID", kitCapsula.KitCapsulaID));
cmd.Parameters.Add(new NpgsqlParameter("@Quantidade", kitCapsula.Quantidade));
cmd.Parameters.Add(new NpgsqlParameter("@KitSaborID", kitCapsula.KitSaborID));
cmd.ExecuteNonQuery();
cmd.Dispose();
conn.Close();
}
}
catch (Exception ex)
{
return("ERROR : " + ex.ToString());
}
return(result);
}
public string IncluirCapsulasNoEstoque(Estoque estoque)
{
string result = "ok";
int quantidade = estoque.Quantidade;
int iterator = 0;
for (iterator = 0; iterator < quantidade; iterator++)
{
try
{
ConnetionPostgres connectionPostgres = new ConnetionPostgres();
/* Insertion After Validations*/
using (NpgsqlConnection conn = new NpgsqlConnection(connectionPostgres.ConnString))
{
conn.Open();
NpgsqlCommand cmd = new NpgsqlCommand();
cmd.Connection = conn;
cmd.CommandText = "Insert into public.\"Estoque\" values(@validade,@dataEntrada,@capsulasID)";
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add(new NpgsqlParameter("@validade", estoque.Validade));
cmd.Parameters.Add(new NpgsqlParameter("@dataEntrada", estoque.DataEntrada));
cmd.Parameters.Add(new NpgsqlParameter("@capsulasID", estoque.CapsulasID));
cmd.ExecuteNonQuery();
cmd.Dispose();
conn.Close();
}
}
catch (Exception ex)
{
return("ERROR : " + ex.ToString());
}
}
return(result);
}
private void FormConnectionConfig_Shown(object sender, EventArgs e)
{
ConnetionPostgres conn = new ConnetionPostgres();
textBox1.Text = conn.ServerName;
textBox2.Text = conn.Port;
textBox3.Text = conn.UserName;
textBox4.Text = conn.Password;
}
public DataTable ListarCapsulas()
{
DataTable dtCapsulas = new DataTable();
ConnetionPostgres connectionPostgres = new ConnetionPostgres();
NpgsqlConnection conn = new NpgsqlConnection(connectionPostgres.ConnString);
string sql = "SELECT * FROM public.\"Capsulas\"";
NpgsqlCommand cmd = new NpgsqlCommand(sql, conn);
conn.Open();
NpgsqlDataReader reader = cmd.ExecuteReader();
dtCapsulas.Load(reader);
conn.Close();
return(dtCapsulas);
}
private void FormPrincipal_Shown(object sender, EventArgs e)
{
try
{
ConnetionPostgres connectionPostgres = new ConnetionPostgres();
NpgsqlConnection conn = new NpgsqlConnection(connectionPostgres.ConnString);
string sql = "SELECT * FROM public.\"Capsulas\"";
NpgsqlCommand cmd;
conn.Open();
cmd = new NpgsqlCommand(sql, conn);
cmd.ExecuteNonQuery();
conn.Close();
}
catch (Exception)
{
MessageBox.Show("Não conseguimos conectar ao servidor, por favor verifique os parametros de configuração!");
FormConnectionConfig form = new FormConnectionConfig();
form.Show();
form.Activate();
}
}
