private void btnSalvar_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(tbxDescricao.Text))
{
MessageBox.Show("Não é possivel incluir um Kit Sabor sem sua descrição!");
tbxDescricao.Focus();
return;
}
KitSabor kitSabor = new KitSabor();
kitSabor.Descricao = tbxDescricao.Text;
string result = kitSabor.InserirKitSabor(kitSabor);
if (result != "ok")
{
MessageBox.Show(result);
}
else
{
MessageBox.Show("Capsula Cadastrada com sucesso!");
LimparTextBoxes();
IncluirPesquisarMostraBotoes();
DesabilitarCampos();
};
}
public string InserirKitSabor(KitSabor kitSabor)
{
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.\"KitSabor\" values(@Descricao)";
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add(new NpgsqlParameter("@Descricao", kitSabor.Descricao));
cmd.ExecuteNonQuery();
cmd.Dispose();
conn.Close();
}
}
catch (Exception ex)
{
return("ERROR : " + ex.ToString());
}
return(result);
}
private void PreencheCbxKitSabor()
{
KitSabor kitSabor = new KitSabor();
DataTable dtKitSabor = kitSabor.ListarKitSabor();
cbxKitSabor.DataSource = dtKitSabor;
cbxKitSabor.DisplayMember = "Descricao";
cbxKitSabor.ValueMember = "KitSaborID";
}
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;
}