private void listaDesconto()
{
dbPagamentosDataContext db = new dbPagamentosDataContext();
var query = from d in db.DescCartaos select d;
dgvDesc.DataSource = query;
}
public void carrega()
{
dbPagamentosDataContext db = new dbPagamentosDataContext();
var query = from f in db.FormaPagtos
orderby f.Nome
select new { idFormaPagto = f.idFormaPagto, CodPagto = f.CodPagto, Nome = f.Nome };
dgvForma.DataSource = query;
}
private void selecionePaciente(int idCli)
{
dbPagamentosDataContext db = new dbPagamentosDataContext();
var query = (from c in db.CadClientes
where c.idCliente == idCli
select c).Single <CadCliente>();
txtNomePct.Text = Convert.ToString(query.Nome);
}
private void buscaForma()
{
dbPagamentosDataContext db = new dbPagamentosDataContext();
var query = from f in db.FormaPagtos
select new { Cod = f.CodPagto, Nome = f.Nome };
cboFormaPgt.ValueMember = "Cod";
cboFormaPgt.DisplayMember = "Nome";
cboFormaPgt.DataSource = query;
}
private void buscaPaciente()
{
dbPagamentosDataContext db = new dbPagamentosDataContext();
var query = from c in db.CadClientes
select new { idCli = c.idCliente, Cpf = c.Cpf };
cboCpfPct.ValueMember = "idCli";
cboCpfPct.DisplayMember = "Cpf";
cboCpfPct.DataSource = query;
}
private void selecioneTaxa(int idDesc)
{
dbPagamentosDataContext db = new dbPagamentosDataContext();
var query = (from d in db.DescCartaos
where d.idDesc == idDesc
select d).Single <DescCartao>();
txtId.Text = Convert.ToString(query.idDesc);
txtTipo.Text = Convert.ToString(query.Nome);
txtPorc.Text = Convert.ToString(query.Porc);
}
private void btnAtualizar_Click(object sender, EventArgs e)
{
dbPagamentosDataContext db = new dbPagamentosDataContext();
var query = (from d in db.DescCartaos
where d.idDesc == Convert.ToInt32(txtId.Text)
select d).Single <DescCartao>();
query.idDesc = Convert.ToInt32(txtId.Text);
query.Nome = txtTipo.Text;
query.Porc = Convert.ToDecimal(txtPorc.Text);
db.SubmitChanges();
txtId.Text = "";
txtTipo.Text = "";
txtPorc.Text = "";
}