private static string GetMatchidname(mailTypeEnum mailType)
{
switch (mailType)
{
case mailTypeEnum.indsamlingskoordinator:
return("new_indsamler2016");
case mailTypeEnum.bykoordinator:
return("new_bykoordinatorid");
default:
break;
}
throw new Exception($"unknown mailtype {mailType}");
}
private string GetTablerow(mailTypeEnum mailType)
{
switch (mailType)
{
case mailTypeEnum.indsamlingskoordinator:
return("<tr><td>{!createdon;}</td><td>{!firstname;}</td><td>{!lastname;}</td><td>{!emailaddress1;}</td><td>{!mobilephone;}</td></tr>");
case mailTypeEnum.bykoordinator:
return("<tr><td>{!createdon;}</td><td>{!address1_line1_;}</td><td>{!firstname;}</td><td>{!lastname;}</td><td>{!emailaddress1;}</td><td>{!mobilephone;}</td></tr>");
default:
break;
}
throw new Exception($"unknown mailtype: {mailType}");
}
private DatabaseSendTableFromMailrelay CreateDatabaseSendTableFromMailrelay(mailTypeEnum mailType = mailTypeEnum.indsamlingskoordinator)
{
DatabaseSendTableFromMailrelay databaseSendTableFromMailrelay = new DatabaseSendTableFromMailrelay()
{
Name = "test",
matchidname = GetMatchidname(mailType),
subject = "subject",
tablerow = GetTablerow(mailType),
urlLoginName = "test",
Schedule = CreateScheduleAlwaysOnDoOnce(),
packageid = 1,
mailboxfromid = 2,
mailboxreplyid = 3,
mailboxreportid = 4,
orderbyDescending = "createdon",
headerDateFormat = "dd.MMMM",
tableDateFormat = "dd/MM/yyyy",
requireDataOnDaysFromToday = new List <int>()
{
-1
},
sleepTimeOnFailiure = TimeSpan.FromSeconds(1),
port = 465,
sendType = DatabaseSendTableFromMailrelay.SendTypeEnum.Api,
};
switch (mailType)
{
case mailTypeEnum.indsamlingskoordinator:
databaseSendTableFromMailrelay.queryCreateTable = GetQueryCreateTable();
databaseSendTableFromMailrelay.queryFindContacts = GetQueryFindContacts();
databaseSendTableFromMailrelay.html = GetHtml();
break;
case mailTypeEnum.bykoordinator:
databaseSendTableFromMailrelay.queryCreateTable = GetQueryCreateTableBykoordinator();
databaseSendTableFromMailrelay.queryFindContacts = GetQueryFindContactsBykoordinator();
databaseSendTableFromMailrelay.html = GetHtmlBykoordinator();
break;
default:
break;
}
return(databaseSendTableFromMailrelay);
}
