public Boolean Facturar(Historicos Historicos, String Numero, Char Clase, DateTime Fecha)
{
Facturas F = new Facturas();
try
{
String Mes = Getmes(Fecha);
F.concepto = " Comsion Mes " + Mes.ToString();
F.contrato_id = Historicos.contrato_id;
F.fecha = DateTime.Now;
F.importe = Historicos.importe;
F.iva = Historicos.iva;
F.neto = Historicos.neto;
F.nro_factura = int.Parse(Numero);
F.puntoventa_id = 9;
F.tipo_factura = Clase;
db.Facturas.InsertOnSubmit(F);
db.SubmitChanges();
int id = F.factura_id;
Historicos UpdateHistorico = (from com in db.GetTable<Historicos>()
join o in db.GetTable<Contratos>()
on com.contrato_id equals o.contrato_id
join Iva in db.GetTable<Codigos_Iva>() on o.codigoiva_id equals Iva.codigoiva_id
where ((com.historico_id == Historicos.historico_id))
select com).SingleOrDefault<Historicos>();
UpdateHistorico.factura_id = id;
db.SubmitChanges();
transactionScope.Complete();
transactionScope.Dispose();
transactionScope = null;
}
catch (TransactionAbortedException ex)
{
transactionScope.Dispose();
transactionScope = null;
return false;
}
catch (SystemException ex)
{
transactionScope.Dispose();
transactionScope = null;
return false;
}
return true;
}
partial void DeleteFacturas(Facturas instance);
partial void UpdateFacturas(Facturas instance);
partial void InsertFacturas(Facturas instance);
