public static void Incluir(SiPA.Compra compra)
{
BancoDataContext dc = new BancoDataContext();
dc.Compras.InsertOnSubmit(compra);
dc.SubmitChanges();
}
public static void Excluir(int id)
{
BancoDataContext dc = new BancoDataContext();
SiPA.Compra compra = (from c in dc.Compras where c.id == id select c).Single();
Modelo.ItemCompra.Excluir(id);
dc.Compras.DeleteOnSubmit(compra);
dc.SubmitChanges();
}
protected void ButtonGravar_Click(object sender, EventArgs e)
{
SiPA.Compra compra = Modelo.Compra.RetornarUltima();
compra.valorTotal = Modelo.Compra.valorTotalCompra;
Modelo.Compra.Alterar(compra);
Session["com-id"] = null;
Modelo.Compra.valorTotalCompra = 0;
Response.Redirect("~/CompraPA/Listar.aspx");
}
public static void Alterar(SiPA.Compra compra)
{
BancoDataContext dc = new BancoDataContext();
SiPA.Compra r = (from c in dc.Compras
where c.id == compra.id
select c).Single();
r.fornecedor_id = compra.fornecedor_id;
r.dataCompra = compra.dataCompra;
r.desconto = compra.desconto;
r.valorTotal = compra.valorTotal;
dc.SubmitChanges();
}
