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::nsPuls3060v2.Properties.Resources.Message_info); //iconSet
}
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 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);
}
}
//*************************************************************************************************************
//*************************************************************************************************************
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));
}
}