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(); }