private void getRSMembership_KontingentForslag() { clsPbs601 objPbs601 = new clsPbs601(); List <string[]> items = objPbs601.RSMembership_KontingentForslag(this.DatoBetaltKontingentTil.Value, Program.dbData3060); int AntalForslag = items.Count(); foreach (var item in items) { ListViewItem it = lvwKontingent.Items.Add(item[0], item[1], 0); it.SubItems.Add(item[0]); it.SubItems.Add(item[2]); it.SubItems.Add(item[3]); it.SubItems.Add(item[4]); it.SubItems.Add(item[5]); it.SubItems.Add(item[6]); it.SubItems.Add(item[7]); it.SubItems.Add(item[8]); } 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; }
private void betalingerFraPBSToolStripMenuItem_Click(object sender, EventArgs e) { string bigString = null; string smallString = null; int AntalImportFiler = 0; clsPbs601 objPbs601 = new clsPbs601(); clsPbs602 objPbs602 = new clsPbs602(); clsPbs603 objPbs603 = new clsPbs603(); clsPbs686 objPbs686 = new clsPbs686(); clsSFTP objSFTP = new clsSFTP(Program.dbData3060); AntalImportFiler = objSFTP.ReadFraSFtp(Program.dbData3060); //Læs direkte SFTP objSFTP.DisconnectSFtp(); objSFTP = null; //AntalImportFiler = objPbs602.ReadFraPbsFile(); //Læs fra Directory FraPBS int Antal602Filer = objPbs602.betalinger_fra_pbs(Program.dbData3060); int Antal603Filer = objPbs603.aftaleoplysninger_fra_pbs(Program.dbData3060); int Antal686Filer = objPbs686.aftaleoplysninger_fra_pbs(Program.dbData3060); Tuple <int, int> tresult = objPbs601.advis_auto(Program.dbData3060); int AntalAdvis = tresult.Item1; int lobnr = tresult.Item2; if ((AntalAdvis > 0)) { objPbs601.advis_email(Program.dbData3060, lobnr); } clsSumma objSumma = new clsSumma(); int AntalBetalinger = objSumma.BogforIndBetalinger(); if (AntalBetalinger > 0) { bigString = String.Format("Der er {0} bogførte betalinger.", AntalBetalinger); } else { bigString = "Der er ingen nye betalinger"; } smallString = String.Format("Antal indlæste filer fra PBS: {0} \nAntal nye 602 filer: {1}\nAntal nye 603 filer: {3}\nAntal nye 686 filer: {4}\nAntal nye betalinger: {2}.", AntalImportFiler, Antal602Filer, AntalBetalinger, Antal603Filer, Antal686Filer); DialogResult result = DotNetPerls.BetterDialog.ShowDialog( "Filer fra PBS", //titleString bigString, //bigString smallString, //smallString null, //leftButton "OK", //rightButton global::nsPuls3060.Properties.Resources.Message_info); //iconSet }
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)) { 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); 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; if (Antal686Filer > 0) { 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.SendFilesToPBS: break; case enumTask.LoadSchedule: LoadSchedule(); break; case enumTask.KontingentNyeMedlemmer: clsPbs601 objPbs601c = new clsPbs601(); Tuple <int, int> tresultc = objPbs601c.kontingent_fakturer_auto(m_dbData3060); int AntalKontingent = tresultc.Item1; int lobnrc = tresultc.Item2; if ((AntalKontingent > 0)) { objPbs601c.faktura_og_rykker_601_action(m_dbData3060, lobnrc, fakType.fdfaktura); clsSFTP objSFTPc = new clsSFTP(m_dbData3060); objSFTPc.WriteTilSFtp(m_dbData3060, lobnrc); objSFTPc.DisconnectSFtp(); objSFTPc = null; } objPbs601c = null; break; case enumTask.SendEmailRykker: clsPbs601 objPbs601b = new clsPbs601(); Tuple <int, int> tresultb = objPbs601b.rykker_auto(m_dbData3060); 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; default: break; } } return(0); } catch (Exception e) { Program.Log(string.Format("Medlem3060Service JobWorker() failed with message: {0}", e.Message)); return(-1); } }
private void cmdFakturer_Click(object sender, EventArgs e) { string TilPBSFilename = "Unknown"; int AntalFakturaer; 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; Program.dbData3060.tempKontforslags.DeleteAllOnSubmit(Program.dbData3060.tempKontforslags); Program.dbData3060.SubmitChanges(); if ((imax == 0)) { this.Label_Fakturatekst.Text = "Der ikke noget at fakturere"; this.Label_Fakturatekst.Visible = true; } else { tempKontforslag rec_tempKontforslag = new tempKontforslag { betalingsdato = clsOverfoersel.bankdageplus(this.DatoKontingentForfald.Value, 0), bsh = this.DelsystemBSH.Checked }; Program.dbData3060.tempKontforslags.InsertOnSubmit(rec_tempKontforslag); 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; tempKontforslaglinie rec_tempKontforslaglinie = new tempKontforslaglinie { Nr = int.Parse(keyval), advisbelob = (decimal)advisbelob, fradato = fradato, tildato = tildato, indmeldelse = indmeldelse, tilmeldtpbs = tilmeldtpbs, }; rec_tempKontforslag.tempKontforslaglinies.Add(rec_tempKontforslaglinie); } Program.dbData3060.SubmitChanges(); clsPbs601 objPbs601 = new clsPbs601(); nsPuls3060.clsPbs601.SetLobnr += new nsPuls3060.clsPbs601.Pbs601DelegateHandler(On_clsPbs601_SetLobnr); AntalFakturaer = objPbs601.kontingent_fakturer_bs1(); this.pgmFaktura.Value = imax * 2; if ((AntalFakturaer > 0)) { objPbs601.faktura_og_rykker_601_action(m_lobnr, fakType.fdfaktura); this.pgmFaktura.Value = (imax * 3); clsSFTP objSFTP = new clsSFTP(); TilPBSFilename = objSFTP.WriteTilSFtp(m_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; } }
public void PbsAutoKontingent(dbData3060DataContext m_dbData3060) { //DateTime Nu = new DateTime(2016, 7, 10); DateTime Nu = DateTime.Now; int Dag = Nu.Day; if (Dag > 12) { return; } DateTime Nu_plus_1 = Nu.AddMonths(1); DateTime p_DatoKontingentForfald = new DateTime(Nu_plus_1.Year, Nu_plus_1.Month, 1); DateTime p_DatoBetaltKontingentTil = Nu.AddMonths(2); puls3060_dkEntities jdbd = new puls3060_dkEntities(); clsPbs601 objPbs601d = new clsPbs601(); List <string[]> items = objPbs601d.RSMembership_KontingentForslag(p_DatoBetaltKontingentTil, m_dbData3060); int AntalForslag = items.Count(); if (AntalForslag > 0) { Program.Log(string.Format("Medlem3060Service {0} begin", "Send Kontingent File til PBS")); Memkontingentforslag memKontingentforslag = new Memkontingentforslag(); foreach (string[] item in items) { string user_id = item[0]; DateTime fradato = DateTime.Parse(item[4]); double advisbelob = double.Parse(item[5]); DateTime tildato = DateTime.Parse(item[6]); bool indmeldelse = (item[7] == "J") ? true : false; bool tilmeldtpbs = (item[8] == "J") ? true : false; recKontingentforslag rec_Kontingentforslag = new recKontingentforslag { betalingsdato = clsOverfoersel.bankdageplus(p_DatoKontingentForfald, 0), bsh = false, user_id = int.Parse(user_id), membership_id = 6, advisbelob = (decimal)advisbelob, fradato = fradato, tildato = tildato, indmeldelse = indmeldelse, tilmeldtpbs = tilmeldtpbs, }; memKontingentforslag.Add(rec_Kontingentforslag); } Tuple <int, int> tresulte = objPbs601d.rsmembeshhip_kontingent_fakturer_bs1(m_dbData3060, jdbd, memKontingentforslag); int AntalFakturaer = tresulte.Item1; int lobnr = tresulte.Item2; if ((AntalFakturaer > 0)) { objPbs601d.faktura_og_rykker_601_action(m_dbData3060, lobnr, fakType.fdrsmembership); clsSFTP objSFTPd = new clsSFTP(m_dbData3060); objSFTPd.WriteTilSFtp(m_dbData3060, lobnr); objSFTPd.DisconnectSFtp(); objSFTPd = null; } Program.Log(string.Format("Medlem3060Service {0} end", "Send Kontingent File til PBS")); } }
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 void PbsAutoKontingent(dbData3060DataContext m_dbData3060, CrudAPI api) { //DateTime Nu = new DateTime(2018, 8, 13); //<-------- DEBUG DateTime Nu = DateTime.Now; int Dag = Nu.Day; if (Dag > 13) { return; } DateTime Nu_plus_1 = Nu.AddMonths(1); DateTime p_DatoKontingentForfald = new DateTime(Nu_plus_1.Year, Nu_plus_1.Month, 1); DateTime Nu_plus_2 = Nu.AddMonths(2); DateTime p_DatoBetaltKontingentTil = new DateTime(Nu_plus_2.Year, Nu_plus_2.Month, 12); clsPbs601 objPbs601d = new clsPbs601(); List <string[]> items = objPbs601d.UniConta_KontingentForslag(p_DatoBetaltKontingentTil, m_dbData3060, api); int AntalForslag = items.Count(); if (AntalForslag > 0) { Console.WriteLine(string.Format("Medlem3060Service {0} begin", "Send Kontingent File til PBS")); Memkontingentforslag memKontingentforslag = new Memkontingentforslag(); foreach (string[] item in items) { string user_id = item[0]; string name = item[1]; DateTime fradato = DateTime.Parse(item[4]); double advisbelob = double.Parse(item[5]); DateTime tildato = DateTime.Parse(item[6]); bool indmeldelse = (item[7] == "J") ? true : false; bool tilmeldtpbs = (item[8] == "J") ? true : false; int memberid = (!string.IsNullOrEmpty(item[10])) ? int.Parse(item[10]) : m_dbData3060.nextval_v2("memberid"); recKontingentforslag rec_Kontingentforslag = new recKontingentforslag { betalingsdato = clsHelper.bankdageplus(p_DatoKontingentForfald, 0), bsh = false, user_id = int.Parse(user_id), membership_id = 6, advisbelob = (decimal)advisbelob, fradato = fradato, tildato = tildato, indmeldelse = indmeldelse, tilmeldtpbs = tilmeldtpbs, memberid = memberid, name = name }; memKontingentforslag.Add(rec_Kontingentforslag); } Tuple <int, int> tresulte = objPbs601d.UniConta_kontingent_fakturer_bs1(m_dbData3060, memKontingentforslag, pbsType.betalingsservice); int AntalFakturaer = tresulte.Item1; int lobnr = tresulte.Item2; if ((AntalFakturaer > 0)) { //pbsType.betalingsservice objPbs601d.faktura_og_rykker_601_action_lobnr(m_dbData3060, lobnr, api); clsSFTP objSFTPd = new clsSFTP(m_dbData3060); objSFTPd.WriteTilSFtp(m_dbData3060, lobnr); objSFTPd.DisconnectSFtp(); objSFTPd = null; } tresulte = objPbs601d.UniConta_kontingent_fakturer_bs1(m_dbData3060, memKontingentforslag, pbsType.indbetalingskort); AntalFakturaer = tresulte.Item1; lobnr = tresulte.Item2; if ((AntalFakturaer > 0)) { //pbsType.indbetalingskort objPbs601d.faktura_og_rykker_601_action_lobnr(m_dbData3060, lobnr, api); clsSFTP objSFTPd = new clsSFTP(m_dbData3060); objSFTPd.WriteTilSFtp(m_dbData3060, lobnr); objSFTPd.DisconnectSFtp(); objSFTPd = null; } Console.WriteLine(string.Format("Medlem3060Service {0} end", "Send Kontingent File til PBS")); } }
//************************************************************************************************************* //************************************************************************************************************* private void JobWorker(string jobname) { try { if (Enum.IsDefined(typeof(enumTask), jobname)) { Console.WriteLine(string.Format("Medlem3060Service {0} begin", jobname)); dbData3060DataContext m_dbData3060 = new dbData3060DataContext(); enumTask job = StringToEnum <enumTask>(jobname); switch (job) { case enumTask.ReceiveFilesFromPBS: CrudAPI api = UCInitializer.GetBaseAPI; 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) // <<---------------------------- { Console.WriteLine(string.Format("Medlem3060Service {0} begin", "Betalinger til RSMembership")); objPbs602.betalinger_opdate_uniconta(m_dbData3060, api); Console.WriteLine(string.Format("Medlem3060Service {0} end", "Betalinger til RSMembership")); clsUniconta objSumma = new clsUniconta(m_dbData3060, api); int AntalBetalinger = objSumma.BogforIndBetalinger(); } 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(); CrudAPI aapi = UCInitializer.GetBaseAPI; Tuple <int, int> tresult = objPbs601a.advis_auto(m_dbData3060); int AntalAdvis = tresult.Item1; int lobnra = tresult.Item2; if ((AntalAdvis > 0)) { objPbs601a.advis_email_lobnr(m_dbData3060, lobnra, aapi); } objPbs601a = null; break; case enumTask.ProcessType602Files: break; case enumTask.ProcessType603Files: break; case enumTask.SendKontingentFileToPBS: CrudAPI dapi = UCInitializer.GetBaseAPI; clsPbsHelper objPbsHelperd = new clsPbsHelper(); objPbsHelperd.PbsAutoKontingent(m_dbData3060, dapi); objPbsHelperd = null; break; case enumTask.LoadSchedule: //Schedule(); break; case enumTask.KontingentNyeMedlemmer: CrudAPI capi = UCInitializer.GetBaseAPI; clsPbs601 objPbs601c = new clsPbs601(); Tuple <int, int> tresultc = objPbs601c.pending_rsform_indmeldelser(m_dbData3060, capi); int AntalKontingent = tresultc.Item1; int lobnrc = tresultc.Item2; if ((AntalKontingent > 0)) { //pbsType.indbetalingskort objPbs601c.faktura_og_rykker_601_action_lobnr(m_dbData3060, lobnrc, capi); clsSFTP objSFTPc = new clsSFTP(m_dbData3060); objSFTPc.WriteTilSFtp(m_dbData3060, lobnrc); objSFTPc.DisconnectSFtp(); objSFTPc = null; Tuple <int, int> tresultd = objPbs601c.advis_auto_lobnr(m_dbData3060, lobnrc); int AntalAdvisd = tresultd.Item1; int lobnrd = tresultd.Item2; if ((AntalAdvisd > 0)) { objPbs601c.advis_email_lobnr(m_dbData3060, lobnrd, capi); } objPbs601c = null; } break; case enumTask.SendEmailRykker: clsPbs601 objPbs601b = new clsPbs601(); CrudAPI bapi = UCInitializer.GetBaseAPI; Tuple <int, int> tresultb = objPbs601b.rykker_auto(m_dbData3060, bapi); int AntalRykker = tresultb.Item1; int lobnrb = tresultb.Item2; if ((AntalRykker > 0)) { objPbs601b.rykker_email_lobnr(m_dbData3060, lobnrb, bapi); } objPbs601b = null; break; case enumTask.UpdateMedlemStatus: break; case enumTask.SendEmailKviteringer: clsPbs601 objPbs601d = new clsPbs601(); CrudAPI apif = UCInitializer.GetBaseAPI; Tuple <int, int> tresultf = objPbs601d.kvitering_auto(m_dbData3060); int AntalKvit = tresultf.Item1; int lobnrf = tresultf.Item2; if ((AntalKvit > 0)) { objPbs601d.kvitering_email_lobnr(m_dbData3060, lobnrf, apif); } objPbs601d = null; break; case enumTask.ImportEmailBilag: CrudAPI apig = UCInitializer.GetBaseAPI; clsUnicontaHelp objUnicontaHelp = new clsUnicontaHelp(apig); objUnicontaHelp.ImportEmailBilag(); objUnicontaHelp = null; break; default: break; } } Console.WriteLine(string.Format("Medlem3060Service {0} end", jobname)); } catch (Exception e) { Console.WriteLine(string.Format("Medlem3060Service JobWorker() for {0} failed with message: {1}", jobname, e.Message)); } }
private void cmdRykkere_Click(object sender, EventArgs e) { string TilPBSFilename; int AntalRykkere; int lobnr; int imax; string keyval; int faknr; double advisbelob; if ((this.cmdRykkere.Text == "Afslut")) { this.Close(); } this.cmdForslag.Visible = false; this.cmdCancel.Visible = false; imax = lvwRykker.Items.Count; this.pgmRykker.Maximum = (imax * 4); this.pgmRykker.Minimum = 0; this.pgmRykker.Value = 0; this.pgmRykker.Visible = true; Program.dbData3060.tempRykkerforslag.RemoveRange(Program.dbData3060.tempRykkerforslag); Program.dbData3060.SaveChanges(); if ((imax == 0)) { this.Label_Rykkertekst.Text = "Der ikke noget at rykkere"; this.Label_Rykkertekst.Visible = true; } else { nsPbs3060v2.tempRykkerforslag rec_tempRykkerforslag = new nsPbs3060v2.tempRykkerforslag { betalingsdato = clsOverfoersel.bankdageplus(DateTime.Today, 5), bsh = this.DelsystemBSH.Checked }; Program.dbData3060.tempRykkerforslag.Add(rec_tempRykkerforslag); var i = 0; foreach (ListViewItem lvi in lvwRykker.Items) { this.pgmRykker.Value = ++i; keyval = lvi.Name; advisbelob = double.Parse(lvi.SubItems[5].Text); faknr = int.Parse(lvi.SubItems[6].Text); nsPbs3060v2.tempRykkerforslaglinie rec_tempRykkerforslaglinie = new nsPbs3060v2.tempRykkerforslaglinie { Nr = int.Parse(keyval), advisbelob = (decimal)advisbelob, faknr = faknr }; rec_tempRykkerforslag.tempRykkerforslaglinie.Add(rec_tempRykkerforslaglinie); } Program.dbData3060.SaveChanges(); clsPbs601 objPbs601 = new clsPbs601(); Tuple <int, int> tresult = objPbs601.rykkere_bsh(Program.dbData3060); AntalRykkere = tresult.Item1; lobnr = tresult.Item2; this.pgmRykker.Value = imax * 2; if ((AntalRykkere > 0)) { if (this.DelsystemBSH.Checked) //RYKKERE med Indbetalingskort { objPbs601.faktura_og_rykker_601_action(Program.dbData3060, lobnr, fakType.fdrykker); this.pgmRykker.Value = (imax * 3); clsSFTP objSFTP = new clsSFTP(Program.dbData3060); objSFTP.WriteTilSFtp(Program.dbData3060, lobnr); objSFTP.DisconnectSFtp(); objSFTP = null; } else //RYKKERE som emails { objPbs601.rykker_email(Program.dbData3060, lobnr); this.pgmRykker.Value = (imax * 3); } } this.pgmRykker.Value = (imax * 4); cmdRykkere.Text = "Afslut"; try { var rec_tilpbs = (from t in Program.dbData3060.tbltilpbs where t.id == lobnr select t).First(); TilPBSFilename = "PBS" + rec_tilpbs.leverancespecifikation + ".lst"; } catch (System.InvalidOperationException) { TilPBSFilename = "PBSNotFound.lst"; } this.Label_Rykkertekst.Text = ("Leverance til PBS er gemt i filen " + TilPBSFilename); this.Label_Rykkertekst.Visible = true; this.pgmRykker.Visible = false; } }
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 testToolStripMenuItem_Click(object sender, EventArgs e) { #if (DEBUG) clsPbs601 objPbs601 = new clsPbs601(); objPbs601.advis_autoxxx(Program.dbData3060, 5046); /* * string card = clsHelper.generateIndbetalerident(Program.dbData3060); * bool test = clsHelper.Mod10Check(card); * * clsPayPal objPayPal = new clsPayPal(); * objPayPal.testPayPal(); * string myHash = clsHelper.GenerateStringHash("Mogens Hafsjold Nørremarken 31 3060 Espergærde"); * puls3060_dkEntities jdb = new puls3060_dkEntities(); * * var qry_rsmembership = from s in jdb.ecpwt_rsmembership_membership_subscribers * where s.membership_id == 6 * 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, * s.user_id, * tl.user_data * }; * * var rsm = qry_rsmembership.ToArray(); * int test = 1; * * puls3060_dkEntities jdb = new puls3060_dkEntities(); * string user_data = (from t in jdb.ecpwt_rsmembership_transactions where t.id == 568 orderby t.id descending select t).First().user_data; * User_data mydata = clsHelper.unpack_UserData(user_data); * string mystring = clsHelper.pack_UserData(mydata); * * int? test = clsHelper.getParam("membership_id=6", "id"); * * 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; * //AntalKontingent = 1; * //lobnrc = 5039; * 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; * } * * WMemRSMembershipTransactions cls = new WMemRSMembershipTransactions(); * * var qryusers = from u in jdb.ecpwt_users * join m in jdb.ecpwt_rsmembership_membership_subscribers on u.id equals m.user_id * where m.membership_id == 6 * join a in jdb.ecpwt_rsmembership_subscribers on u.id equals a.user_id * join t in jdb.ecpwt_rsmembership_transactions on m.last_transaction_id equals t.id * select new { * id = u.id, * name = u.name, * adresse = a.f1, * postnr = a.f4, * Bynavn = a.f2, * Telefon = a.f6, * email = u.email, * Nr = a.f14, * membership_start = m.membership_start, * membership_end = m.membership_end, * user_data = t.user_data * }; * * int antal = qryusers.Count(); * int x = 0; * foreach (var transactions in qryusers) * { * x++; * } */ /* * string TilPBSFile = "Mogens Hafsjold"; * char[] c_TilPBSFile = TilPBSFile.ToCharArray(); * byte[] b_TilPBSFile = System.Text.Encoding.GetEncoding("windows-1252").GetBytes(c_TilPBSFile); * clsAzure objAzure = new clsAzure(); * objAzure.uploadBlob("test_med_metadata2.txt", "Puls3060", b_TilPBSFile); * * * // START TEST TEST TEST TEST TEST TEST * clsBankUdbetalingsUdskrift objBankUdbetalingsUdskrift = new clsBankUdbetalingsUdskrift(); * objBankUdbetalingsUdskrift.BankUdbetalingsUdskrifter(Program.dbData3060, 894); * * * var rstPusteruns = from p in Program.dbData3060.vPusterummets select p; * int count = rstPusteruns.Count(); * if (count > 0) * { * foreach (var rstPusterun in rstPusteruns) * { * int Nr = (int)rstPusterun.Nr; * string Navn = rstPusterun.Navn; * string Adresse = rstPusterun.Adresse; * string Postnr = rstPusterun.Postnr; * } * } */ /* * string bigString = "BIGSTRING"; * string smallString = "smallString smallString smallString smallString smallString smallString smallString smallString smallString smallString smallString smallString smallString smallString smallString smallString smallString smallString smallString smallString smallString smallString smallString smallString"; * DialogResult result = DotNetPerls.BetterDialog.ShowDialog( * "Betalinger fra PBS", //titleString * bigString, //bigString * smallString, //smallString * null, //leftButton * "OK", //rightButton * global::nsPuls3060.Properties.Resources.Message_info); //iconSet */ /* * clsPbs686 objPbs686 = new clsPbs686(); * int Antal686Filer = objPbs686.aftaleoplysninger_fra_pbs(Program.dbData3060); * objPbs686 = null; */ /* * // case enumTask.KontingentNyeMedlemmer: * clsPbs601 objPbs601c = new clsPbs601(); * Tuple<int, int> tresultc = objPbs601c.kontingent_fakturer_auto(Program.dbData3060); * int AntalKontingent = tresultc.Item1; * int lobnrc = tresultc.Item2; * if ((AntalKontingent > 0)) * { * objPbs601c.faktura_og_rykker_601_action(Program.dbData3060, lobnrc, fakType.fdfaktura); * clsSFTP objSFTPc = new clsSFTP(Program.dbData3060); * objSFTPc.WriteTilSFtp(Program.dbData3060, lobnrc); * objSFTPc.DisconnectSFtp(); * objSFTPc = null; * } * objPbs601c = null; */ /* * //case enumTask.SendEmailRykker: * clsPbs601 objPbs601b = new clsPbs601(); * Tuple<int, int> tresultb = objPbs601b.rykker_auto(Program.dbData3060); * int AntalRykker = tresultb.Item1; * int lobnrb = tresultb.Item2; * if ((AntalRykker > 0)) * objPbs601b.rykker_email(Program.dbData3060, lobnrb); * objPbs601b = null; */ // S**T TEST TEST TEST TEST TEST TEST #endif }