private void btnIncluir_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(tbxQuantidade.Text))
{
MessageBox.Show("Não é possivel incluir KIT sem uma quantidade de Capsulas");
tbxQuantidade.Focus();
return;
}
KitCapsulas kitCapsulas = new KitCapsulas();
kitCapsulas.KitSaborID = Convert.ToInt16(cbxKitSabor.SelectedValue);
kitCapsulas.KitCapsulaID = Convert.ToInt16(cbxTipoDeCapsulas.SelectedValue);
kitCapsulas.Quantidade = Convert.ToInt16(tbxQuantidade.Text);
string result = kitCapsulas.InserirCapuslaDeCafe(kitCapsulas);
if (result != "ok")
{
MessageBox.Show(result);
}
else
{
MessageBox.Show("Capsula Cadastrada com sucesso!");
PreencheDataGrid();
//LimparTextBoxes();
//IncluirPesquisarMostraBotoes();
//DesabilitarCampos();
};
}
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 FormKitCapsulas()
{
InitializeComponent();
KitSabor kitSabor = new KitSabor();
DataTable dtKitSabor = kitSabor.ListarKitSabor();
cbxKitSabor.DataSource = dtKitSabor;
cbxKitSabor.DisplayMember = "Descricao";
cbxKitSabor.ValueMember = "KitSaborID";
CapsulasDeCafe capsulas = new CapsulasDeCafe();
DataTable dtCapsulas = capsulas.ListarCapsulas();
cbxTipoDeCapsulas.DataSource = dtCapsulas;
cbxTipoDeCapsulas.DisplayMember = "Descricao";
cbxTipoDeCapsulas.ValueMember = "capsulasID";
KitCapsulas kitCapsulas = new KitCapsulas();
DataTable dtKitCapsulas = kitCapsulas.ListarKitCapsulas();
dgvKitCapsulas.DataSource = dtKitCapsulas;
}