public static OutputInvoiceList GetFacturasPendientes() { DateTime f_fin = DateTime.Today.AddDays((double)Library.Invoice.ModulePrincipal.GetNotifyPlazoFacturasEmitidas()); OutputInvoiceList list = OutputInvoiceList.GetNoCobradasList(DateTime.MinValue, f_fin, false); return(list); }
public static BalanceInfo Get() { BalanceInfo obj = new BalanceInfo(); obj._pendientes_pago = PaymentSummaryList.SortList(PaymentSummaryList.GetPendientesList(), "Nombre", ListSortDirection.Ascending); Library.Store.QueryConditions conditions = new Library.Store.QueryConditions { TipoExpediente = ETipoExpediente.Todos, Estado = EEstado.Pendiente }; ExpedienteREAList expedientes = ExpedienteREAList.GetListByREA(conditions, false); foreach (ExpedienteREAInfo item in expedientes) { obj._pendiente_rea += item.AyudaPendiente; } OutputInvoiceList facturas = OutputInvoiceList.GetNoCobradasList(false); obj._pendiente_clientes = facturas.TotalPendiente(); obj._efectos_pte_vto_clientes = facturas.TotalPendienteVencimiento(); obj._efectos_negociados_clientes = facturas.TotalNegociado(); obj._efectos_devueltos_clientes = facturas.TotalDevuelto(); InventarioValoradoList inventario = InventarioValoradoList.GetListStock(ETipoExpediente.Todos, null, DateTime.Today); foreach (InventarioValoradoInfo item in inventario) { switch (item.TipoExpediente) { case (long)(ETipoExpediente.Alimentacion): obj._stock_alimentacion_valorado += item.PVP; break; case (long)(ETipoExpediente.Ganado): obj._stock_ganado_valorado += item.PVP; break; case (long)(ETipoExpediente.Maquinaria): obj._stock_maquinaria_valorado += item.PVP; break; } } obj._saldo_caja = CashInfo.Get(1, true).SaldoTotal; return(obj); }
public static void SendMailsFacturasPendientes() { try { OutputInvoiceList facturas = OutputInvoiceList.GetNoCobradasList(true); ClienteList clientes = ClienteList.GetList(false); SerieList series = SerieList.GetList(false); CompanyInfo empresa = CompanyInfo.Get(AppContext.ActiveSchema.Oid); SerieInfo serie; ClienteInfo cliente; Registro registro = Registro.New(ETipoRegistro.Email); registro.Nombre = "Envio automático de Facturas"; registro.Observaciones = "Envio automático de Facturas pendientes de pago"; foreach (OutputInvoiceInfo item in facturas) { if (item.Prevision.AddDays(ModulePrincipal.GetPeriodicidadEnvioFacturasPendientes()) > DateTime.Today) { continue; } cliente = clientes.GetItem(item.OidCliente); if (!cliente.EnviarFacturaPendiente) { continue; } serie = series.GetItem(item.OidSerie); FormatConfFacturaAlbaranReport conf = new FormatConfFacturaAlbaranReport(); conf.nota = (cliente.OidImpuesto == 1) ? Resources.Messages.NOTA_EXENTO_IGIC : string.Empty; conf.nota += Environment.NewLine + (item.Nota ? serie.Cabecera : ""); OutputInvoiceReportMng reportMng = new OutputInvoiceReportMng(AppContext.ActiveSchema, string.Empty, string.Empty); ReportClass report = reportMng.GetDetailReport(item, serie, cliente, null, conf); if (report != null) { LineaRegistro linea = registro.LineaRegistros.NewItem(registro, cliente); ExportOptions options = new ExportOptions(); DiskFileDestinationOptions diskFileDestinationOptions = new DiskFileDestinationOptions(); string fileName = Environment.GetFolderPath(Environment.SpecialFolder.Desktop); fileName += "\\" + item.FileName; diskFileDestinationOptions.DiskFileName = fileName; options.ExportFormatType = CrystalDecisions.Shared.ExportFormatType.PortableDocFormat; options.ExportDestinationType = CrystalDecisions.Shared.ExportDestinationType.DiskFile; options.ExportDestinationOptions = diskFileDestinationOptions; report.Export(options); System.Net.Mail.MailMessage mail = new System.Net.Mail.MailMessage(); mail.To.Add(new MailAddress(cliente.Email, cliente.Nombre)); mail.From = new MailAddress(SettingsMng.Instance.GetSMTPMail(), empresa.Name); mail.Body = String.Format(Resources.Messages.FACTURA_EMAIL_ATTACHMENT_BODY, empresa.Name); mail.Subject = Resources.Messages.FACTURA_EMAIL_SUBJECT; mail.Attachments.Add(new Attachment(fileName)); try { Thread mailThread = new Thread(SendMailDelegate); mailThread.Start(mail); while (mailThread.IsAlive) { ; } linea.Observaciones = linea.Descripcion; linea.Descripcion = String.Format(Resources.Messages.FACTURA_EMAIL_OK, item.NFactura); } catch (Exception ex) { linea.Observaciones = linea.Descripcion; linea.Descripcion = String.Format(Resources.Messages.FACTURA_EMAIL_ERROR, item.NFactura); registro.Save(); throw new iQException(ex.Message + Environment.NewLine + Environment.NewLine + moleQule.Library.Resources.Errors.SMTP_SETTINGS); } finally { mail.Dispose(); try { File.Delete(fileName); } catch (Exception ex) { string a = ex.Message; } } } } registro.Save(); ModulePrincipal.SetFechaUltimoEnvioFacturasPendientes(DateTime.Now); AppContext.Principal.SaveSettings(); } catch { } }
private void GetFacturas(ClienteInfo cliente, QueryConditions conditions, FormatConfCarteraClientesReport conf, List <CarteraClientesPrint> pList, List <CobroFacturaPrint> pCobroList) { OutputInvoiceList facturas; conditions.Cliente = cliente; switch (conf.tipo) { case ETipoFacturas.Cobradas: { facturas = OutputInvoiceList.GetCobradasList(conditions, false); if (facturas.Count > 0) { foreach (OutputInvoiceInfo f in facturas) { f.LoadChilds(typeof(CobroFacturaInfo), false); pList.Add(cliente.GetCarteraPrintObject(f)); foreach (CobroFacturaInfo cobro in f.CobroFacturas) { pCobroList.Add(CobroFacturaPrint.New(cobro)); } } } } break; case ETipoFacturas.Pendientes: { facturas = OutputInvoiceList.GetNoCobradasList(conditions, false); if (facturas.Count > 0) { foreach (OutputInvoiceInfo f in facturas) { f.LoadChilds(typeof(CobroFacturaInfo), false); pList.Add(cliente.GetCarteraPrintObject(f)); foreach (CobroFacturaInfo cobro in f.CobroFacturas) { pCobroList.Add(CobroFacturaPrint.New(cobro)); } } } } break; case ETipoFacturas.Todas: { facturas = OutputInvoiceList.GetList(conditions, false); if (facturas.Count == 0) { pList.Add(cliente.GetCarteraPrintObject(null)); } else { foreach (OutputInvoiceInfo f in facturas) { f.LoadChilds(typeof(CobroFacturaInfo), false); if (f.CobroFacturas.Count > 0) { pList.Add(cliente.GetCarteraPrintObject(f)); foreach (CobroFacturaInfo cobro in f.CobroFacturas) { pCobroList.Add(CobroFacturaPrint.New(cobro)); } } else { pList.Add(cliente.GetCarteraPrintObject(f)); } } } } break; } }