public void Delete(int idConvenio)
{
using (cooperativaEntities bd = new cooperativaEntities())
{
DataTable dtFacturas = new DataTable();
FacturasImplement oFacturasImplement = new FacturasImplement();
var listar = (from f in bd.facturas
where f.id_convenio == idConvenio
select f).ToList();
Commons oCommons = new Commons();
dtFacturas=oCommons.convertToTable(listar);
foreach(DataRow dr in dtFacturas.Rows)
{
int idFactura = int.Parse(dr["id_factura"].ToString());
facturas oFacturas = new facturas();
oFacturas = oFacturasImplement.Get(idFactura);
oFacturas.id_convenio = 0;
oFacturasImplement.Update(oFacturas);
}
var regis = (from p in bd.convenios
where p.id_convenio == idConvenio
select p).Single();
bd.DeleteObject(regis);
bd.SaveChanges();
}
}
public void Delete(int idBarrio)
{
using (cooperativaEntities bd = new cooperativaEntities())
{
var regis = (from p in bd.cod_barrios
where p.id_barrio == idBarrio
select p).Single();
bd.DeleteObject(regis);
bd.SaveChanges();
}
}
public void Delete(int idTarifa)
{
using (cooperativaEntities bd = new cooperativaEntities())
{
var regis = (from p in bd.tarifas
where p.id_tarifa == idTarifa
select p).Single();
bd.DeleteObject(regis);
bd.SaveChanges();
}
}
public void Delete(int idAccion)
{
using (cooperativaEntities bd = new cooperativaEntities())
{
var regis = (from p in bd.acciones
where p.id_accion == idAccion
select p).Single();
bd.DeleteObject(regis);
bd.SaveChanges();
}
}
