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