private void opdaterRSMembershipToolStripMenuItem_Click(object sender, EventArgs e) { puls3060_dkEntities jdb = new puls3060_dkEntities(); clsPbs602 objPbs602 = new clsPbs602(); objPbs602.betalinger_til_rsmembership(Program.dbData3060, jdb); }
private void testEmailRykkerToolStripMenuItem_Click(object sender, EventArgs e) { puls3060_dkEntities jdb = new puls3060_dkEntities(); clsPbs601 objPbs601 = new clsPbs601(); Tuple <int, int> tresult = objPbs601.rykker_auto(Program.dbData3060, jdb); int AntalRykker = tresult.Item1; int lobnr = tresult.Item2; if ((AntalRykker > 0)) { objPbs601.rykker_email(Program.dbData3060, lobnr); } objPbs601 = null; }
private void payPalTilPBSNyeMedlemmerToolStripMenuItem_Click(object sender, EventArgs e) { puls3060_dkEntities jdb = new puls3060_dkEntities(); clsPbs601 objPbs601 = new clsPbs601(); Tuple <int, int> tresultc = objPbs601.rsmembeshhip_fakturer_auto(Program.dbData3060, jdb); int AntalKontingent = tresultc.Item1; int lobnrc = tresultc.Item2; if ((AntalKontingent > 0)) { objPbs601.faktura_og_rykker_601_action(Program.dbData3060, lobnrc, fakType.fdrsmembership); clsSFTP objSFTPc = new clsSFTP(Program.dbData3060); objSFTPc.WriteTilSFtp(Program.dbData3060, lobnrc); objSFTPc.DisconnectSFtp(); objSFTPc = null; } }
private int JobWorker(string jobname) { try { if (Enum.IsDefined(typeof(enumTask), jobname)) { Program.Log(string.Format("Medlem3060Service {0} begin", jobname)); dbData3060DataContext m_dbData3060 = new dbData3060DataContext(Program.dbConnectionString()); enumTask job = StringToEnum <enumTask>(jobname); switch (job) { case enumTask.ReceiveFilesFromPBS: clsSFTP objSFTP = new clsSFTP(m_dbData3060); int AntalImportFiler = objSFTP.ReadFraSFtp(m_dbData3060); //Læs direkte SFTP objSFTP.DisconnectSFtp(); objSFTP = null; clsPbs602 objPbs602 = new clsPbs602(); int Antal602Filer = objPbs602.betalinger_fra_pbs(m_dbData3060); if (Antal602Filer > 0) { Program.Log(string.Format("Medlem3060Service {0} begin", "Betalinger til RSMembership")); puls3060_dkEntities jdb = new puls3060_dkEntities(); objPbs602.betalinger_til_rsmembership(m_dbData3060, jdb); Program.Log(string.Format("Medlem3060Service {0} end", "Betalinger til RSMembership")); } objPbs602 = null; clsPbs603 objPbs603 = new clsPbs603(); int Antal603Filer = objPbs603.aftaleoplysninger_fra_pbs(m_dbData3060); objPbs603 = null; clsPbs686 objPbs686 = new clsPbs686(); int Antal686Filer = objPbs686.aftaleoplysninger_fra_pbs(m_dbData3060); objPbs686 = null; break; case enumTask.SendEmailAdvis: clsPbs601 objPbs601a = new clsPbs601(); Tuple <int, int> tresult = objPbs601a.advis_auto(m_dbData3060); int AntalAdvis = tresult.Item1; int lobnra = tresult.Item2; if ((AntalAdvis > 0)) { objPbs601a.advis_email(m_dbData3060, lobnra); } objPbs601a = null; break; case enumTask.ProcessType602Files: break; case enumTask.ProcessType603Files: break; case enumTask.SendKontingentFileToPBS: clsPbsHelper objPbsHelperd = new clsPbsHelper(); objPbsHelperd.PbsAutoKontingent(m_dbData3060); objPbsHelperd = null; break; case enumTask.LoadSchedule: LoadSchedule(); break; case enumTask.KontingentNyeMedlemmer: puls3060_dkEntities cjdb = new puls3060_dkEntities(); clsPbs601 objPbs601c = new clsPbs601(); Tuple <int, int> tresultc = objPbs601c.rsmembeshhip_fakturer_auto(m_dbData3060, cjdb); int AntalKontingent = tresultc.Item1; int lobnrc = tresultc.Item2; if ((AntalKontingent > 0)) { objPbs601c.faktura_og_rykker_601_action(m_dbData3060, lobnrc, fakType.fdrsmembership); clsSFTP objSFTPc = new clsSFTP(m_dbData3060); objSFTPc.WriteTilSFtp(m_dbData3060, lobnrc); objSFTPc.DisconnectSFtp(); objSFTPc = null; Tuple <int, int> tresultd = objPbs601c.advis_autoxxx(m_dbData3060, lobnrc); int AntalAdvisd = tresultd.Item1; int lobnrd = tresultd.Item2; if ((AntalAdvisd > 0)) { objPbs601c.advis_email(m_dbData3060, lobnrd); } objPbs601c = null; } break; case enumTask.SendEmailRykker: puls3060_dkEntities bjdb = new puls3060_dkEntities(); clsPbs601 objPbs601b = new clsPbs601(); Tuple <int, int> tresultb = objPbs601b.rykker_auto(m_dbData3060, bjdb); int AntalRykker = tresultb.Item1; int lobnrb = tresultb.Item2; if ((AntalRykker > 0)) { objPbs601b.rykker_email(m_dbData3060, lobnrb); } objPbs601b = null; break; case enumTask.UpdateMedlemStatus: m_dbData3060.UpdateMedlemStatus(); break; case enumTask.UpdateKanSlettes: clsPbsHelper objPbsHelpera = new clsPbsHelper(); objPbsHelpera.opdaterKanSlettes(); break; case enumTask.JobQMaintenance: clsPbsHelper objPbsHelperb = new clsPbsHelper(); objPbsHelperb.JobQMaintenance(m_dbData3060); break; case enumTask.SendEmailKviteringer: puls3060_dkEntities djdb = new puls3060_dkEntities(); clsPbs601 objPbs601d = new clsPbs601(); objPbs601d.rsmembeshhip_betalinger_auto(m_dbData3060, djdb); break; default: break; } } Program.Log(string.Format("Medlem3060Service {0} end", jobname)); return(0); } catch (Exception e) { Program.Log(string.Format("Medlem3060Service JobWorker() for {0} failed with message: {1}", jobname, e.Message)); return(-1); } }
public int BogforPaypalBetalinger() { var rec_regnskab = Program.qryAktivRegnskab(); if (rec_regnskab.Afsluttet == true) { return(0); } DateTime?Startdato = rec_regnskab.Start; DateTime?Slutdato = rec_regnskab.S**t; if (rec_regnskab.DatoLaas != null) { if (rec_regnskab.DatoLaas > Startdato) { Startdato = rec_regnskab.DatoLaas; } } puls3060_dkEntities jdb = new puls3060_dkEntities(); clsPbs602 objPbs602 = new clsPbs602(); MemBogfoeringsKlader bogf = objPbs602.konter_paypal_betalinger_fra_rsmembership(jdb, (DateTime)Startdato, (DateTime)Slutdato); int AntalBetalinger = 0; if (bogf.Count() > 0) { DateTime nu = DateTime.Now; DateTime ToDay = new DateTime(nu.Year, nu.Month, nu.Day);; int BS1_SidsteNr = 0; try { recStatus rec_Status = (from s in Program.karStatus where s.key == "BS1_SidsteNr" select s).First(); BS1_SidsteNr = int.Parse(rec_Status.value); } catch (System.InvalidOperationException) { } Program.karKladde = null; foreach (var b in bogf) { recKladde kl = new recKladde { Dato = b.Dato, Bilag = b.Bilag + BS1_SidsteNr, Tekst = b.Tekst, Afstemningskonto = b.Afstemningskonto, Belob = b.Belob, Kontonr = b.Kontonr, Faknr = b.Faknr, Sagnr = b.Sagnr }; Program.karKladde.Add(kl); AntalBetalinger = (int)b.Bilag; } Program.karStatus.save(); Program.karKladde.save(); Program.dbData3060.SubmitChanges(); } return(AntalBetalinger); }
private void cmdRSMembership_Fakturer_Click(object sender, EventArgs e) { string TilPBSFilename = "Unknown"; int AntalFakturaer; int lobnr; int imax; string keyval; DateTime fradato; DateTime tildato; bool tilmeldtpbs; bool indmeldelse; double advisbelob; if ((this.cmdFakturer.Text == "Afslut")) { this.Close(); } this.cmdForslag.Visible = false; this.cmdCancel.Visible = false; imax = lvwKontingent.Items.Count; this.pgmFaktura.Maximum = (imax * 4); this.pgmFaktura.Minimum = 0; this.pgmFaktura.Value = 0; this.pgmFaktura.Visible = true; if ((imax == 0)) { this.Label_Fakturatekst.Text = "Der ikke noget at fakturere"; this.Label_Fakturatekst.Visible = true; } else { puls3060_dkEntities jdb = new puls3060_dkEntities(); Memkontingentforslag memKontingentforslag = new Memkontingentforslag(); var i = 0; foreach (ListViewItem lvi in lvwKontingent.Items) { this.pgmFaktura.Value = ++i; keyval = lvi.Name; fradato = DateTime.Parse(lvi.SubItems[4].Text); advisbelob = double.Parse(lvi.SubItems[5].Text); tildato = DateTime.Parse(lvi.SubItems[6].Text); indmeldelse = (lvi.SubItems[7].Text == "J") ? true : false; tilmeldtpbs = (lvi.SubItems[8].Text == "J") ? true : false; recKontingentforslag rec_Kontingentforslag = new recKontingentforslag { betalingsdato = clsOverfoersel.bankdageplus(this.DatoKontingentForfald.Value, 0), bsh = this.DelsystemBSH.Checked, user_id = int.Parse(keyval), membership_id = 6, advisbelob = (decimal)advisbelob, fradato = fradato, tildato = tildato, indmeldelse = indmeldelse, tilmeldtpbs = tilmeldtpbs, }; memKontingentforslag.Add(rec_Kontingentforslag); } clsPbs601 objPbs601 = new clsPbs601(); Tuple <int, int> tresult = objPbs601.rsmembeshhip_kontingent_fakturer_bs1(Program.dbData3060, jdb, memKontingentforslag); AntalFakturaer = tresult.Item1; lobnr = tresult.Item2; this.pgmFaktura.Value = imax * 2; if ((AntalFakturaer > 0)) { objPbs601.faktura_og_rykker_601_action(Program.dbData3060, lobnr, fakType.fdrsmembership); this.pgmFaktura.Value = (imax * 3); clsSFTP objSFTP = new clsSFTP(Program.dbData3060); TilPBSFilename = objSFTP.WriteTilSFtp(Program.dbData3060, lobnr); objSFTP.DisconnectSFtp(); objSFTP = null; } this.pgmFaktura.Value = (imax * 4); cmdFakturer.Text = "Afslut"; this.DelsystemBSH.Visible = false; this.Label_Fakturatekst.Text = ("Leverance til PBS i filen " + TilPBSFilename); this.Label_Fakturatekst.Visible = true; this.pgmFaktura.Visible = false; } }
private void getRSMembership_KontingentForslag_old() { puls3060_dkEntities jdb = new puls3060_dkEntities(); DateTime KontingentFradato = DateTime.MinValue; DateTime KontingentTildato = DateTime.MinValue; bool tilmeldtpbs = false; bool indmeldelse = false; int AntalMedlemmer = 0; int AntalForslag = 0; int ikontingent; int iNr = 0; var qry_rsmembership = from s in jdb.ecpwt_rsmembership_membership_subscribers where s.membership_id == 6 && s.status != 3 join tf in jdb.ecpwt_rsmembership_transactions on s.from_transaction_id equals tf.id join tl in jdb.ecpwt_rsmembership_transactions on s.last_transaction_id equals tl.id join m in jdb.ecpwt_rsmembership_subscribers on s.user_id equals m.user_id join u in jdb.ecpwt_users on s.user_id equals u.id select new { Nr = m.f14, Navn = u.name, Adresse = m.f1, Postnr = m.f4, indmeldelsesDato = tf.date, kontingentBetaltTilDato = s.membership_end, Kontingent = tl.price, s.user_id, tl.user_data }; this.lvwMedlem.Items.Clear(); this.lvwKontingent.Items.Clear(); var antal = qry_rsmembership.Count(); this.pgmForslag.Show(); this.pgmForslag.Maximum = antal; this.pgmForslag.Minimum = 0; this.pgmForslag.Value = 0; this.pgmForslag.Step = 1; this.pgmForslag.Visible = true; this.Label_Forslagstekst.Visible = false; this.cmdFakturer.Visible = false; this.DelsystemBSH.Visible = false; pgmForslag.PerformStep(); var rsm = qry_rsmembership.ToArray(); foreach (var m in rsm) { bool bSelected = true; AntalMedlemmer++; tilmeldtpbs = false; indmeldelse = false; if (m.Nr == "") { iNr = 10000 + m.user_id; } else { iNr = int.Parse(m.Nr); } bool erMedlemPusterummet = ((from um in jdb.ecpwt_user_usergroup_map join g in jdb.ecpwt_usergroups on um.group_id equals g.id where g.title == "Pusterummet" && um.user_id == m.user_id select um.user_id).Count() > 0); if (erMedlemPusterummet) { bSelected = false; } else //Er medlem { if ((m.kontingentBetaltTilDato != null) && (m.kontingentBetaltTilDato > m.indmeldelsesDato)) //'Der findes en kontingent-betaling { if (m.kontingentBetaltTilDato > this.DatoBetaltKontingentTil.Value) //der er betalt kontingent efter DatoBetaltKontingentTil { bSelected = false; } else { if (m.kontingentBetaltTilDato >= m.indmeldelsesDato) { KontingentFradato = ((DateTime)m.kontingentBetaltTilDato); } } } else //Der findes ingen kontingent-betaling { KontingentFradato = (DateTime)m.indmeldelsesDato; indmeldelse = true; } } if (bSelected) { DateTime TodayMinus90 = DateTime.Now.AddDays(-90); var qry_fak = from f in Program.dbData3060.tblfaks where f.Nr == iNr && f.betalingsdato > TodayMinus90 join t in Program.dbData3060.tblrsmembership_transactions on f.id equals t.id select f; if (qry_fak.Count() > 0) //Der findes en opkrævning { bSelected = false; } } if (bSelected) { AntalForslag++; tilmeldtpbs = (bool)Program.dbData3060.erPBS(iNr); KontingentTildato = KontingentFradato.AddMonths(12); ikontingent = (int)m.Kontingent; ListViewItem it = lvwKontingent.Items.Add(m.user_id.ToString(), m.Navn, 0); //it.Tag = m; it.SubItems.Add(m.user_id.ToString()); it.SubItems.Add(m.Adresse); it.SubItems.Add(m.Postnr); it.SubItems.Add(string.Format("{0:dd-MM-yyy}", KontingentFradato)); it.SubItems.Add(ikontingent.ToString()); it.SubItems.Add(string.Format("{0:dd-MM-yyy}", KontingentTildato)); it.SubItems.Add((indmeldelse) ? "J" : "N"); it.SubItems.Add((tilmeldtpbs) ? "J" : "N"); } pgmForslag.PerformStep(); } this.lvwKontingent.AutoResizeColumns(ColumnHeaderAutoResizeStyle.ColumnContent); if (AntalForslag == 0) { this.Label_Forslagstekst.Text = "Der er ingen forslag"; this.Label_Forslagstekst.Visible = true; this.cmdFakturer.Visible = false; this.DelsystemBSH.Visible = false; } else { this.Label_Forslagstekst.Visible = false; this.cmdFakturer.Visible = true; this.DelsystemBSH.Visible = true; } this.pgmForslag.Visible = false; }