public static void Startup()
{
// Start MessageSystem
string hubUrl = ConfigurationManager.AppSettings.GetValues("MessageHubAddress").FirstOrDefault();
HubServer.Instance.Start(hubUrl);
HubClient.Instance.Start(hubUrl);
// Load Roles and Permissions
AppVars.rolesAndPermissions = AppLib.LoadAllRolesAndPermissions();
// Init Accounting Interface
using (HostDAO dao = new HostDAO())
{
Accounting.Init.Startup(dao.GetAccountingSettings());
}
// Add System Jobs to Schedule
JobExpireTokens.AddToSchedule();
JobExpireLocks.AddToSchedule();
JobReportNotifications.AddToSchedule();
// Accounting Interface
//Invoice invoice = new Invoice();
//invoice = new InvoiceInterface().InvoiceAdd(invoice);
}
public static bool CheckDatabase()
{
using (HostDAO dao = new HostDAO()) {
dao.CreateTables();
return dao.VerifySetup();
}
}
public static void GetSettings()
{
AppVars.SmtpServerUseSSL = Convert.ToBoolean(ConfigurationManager.AppSettings["SMTP_UseSSL"]);
AppVars.SmtpServer = ConfigurationManager.AppSettings["SMTP_Server"];
AppVars.SmtpAccount = ConfigurationManager.AppSettings["SMTP_Account"];
AppVars.SmtpPassword = ConfigurationManager.AppSettings["SMTP_Password"];
AppVars.SmtpPort = Convert.ToInt32(ConfigurationManager.AppSettings["SMTP_Port"]);
AppVars.ReportNotificationsEnabled = Convert.ToBoolean(ConfigurationManager.AppSettings["Report_Notifications_Enabled"]);
AppVars.FaxUserName = ConfigurationManager.AppSettings["Fax_UserName"];
AppVars.FaxPassword = ConfigurationManager.AppSettings["Fax_Password"];
AppVars.ReportEmailAddress = ConfigurationManager.AppSettings["Report_From_EmailAddress"];
AppVars.ReportTemplateHtml = ConfigurationManager.AppSettings["Report_Template_Html"];
AppVars.ReportTemplateText = ConfigurationManager.AppSettings["Report_Template_Text"];
using (HostDAO dao = new HostDAO())
{
AppVars.dbSettings = (HostSettings)dao.GetHostSettings();
AppVars.baseKey = AppVars.dbSettings.BaseKey;
AppVars.hostOptions = dao.GetHostOptions();
}
}
public void ShowAdmins()
{
if (DbCurrenVersion == 0)
{
if (this.hostSettings != null)
{
if (hostSettings.ValidateModel())
{
using (HostDAO dao = new HostDAO())
{
dao.SaveHostSettings(this.hostSettings);
}
}
}
ServiceHost.Implementation.Init.GetSettings();
using (DataBaseDao dao = new DataBaseDao())
{
this.DbCurrenVersion = dao.GetDatabaseVersion();
}
}
if (ServiceHost.Update.Init.Update(DbCurrenVersion))
CurrentView = ManagerViews.Admins;
}
public void SaveAdministrators(SmartCollection<User> admins)
{
if (admins == null) return;
if (this.hostSettings != null) {
if (hostSettings.ValidateModel()) {
using (HostDAO dao = new HostDAO()) {
dao.SaveHostSettings(this.hostSettings);
AppVars.dbSettings = hostSettings;
}
}
}
try {
int result = -1;
string sql;
using (HostDAO dao = new HostDAO()) {
this.HostSettings = new SMHostSettings(dao.GetHostSettings());
AppVars.dbSettings = hostSettings;
}
using (SystemDAO systemDao = new SystemDAO()) {
using (systemDao.DbConnection = new MsSqlPersistence(systemDao.DbConnectionSettings)) {
if (systemDao.DbConnection.IsConnected()) {
using (systemDao.DbCommand) {
foreach (User user in admins) {
systemDao.DbCommand.CommandType = System.Data.CommandType.StoredProcedure;
systemDao.DbCommand.Parameters.Clear();
if (user.UserId <= 0 || user.UserId == null) {
systemDao.DbCommand.CommandText = "uspInsertAdministrator";
string hashedPassword = Security.GetSha2Hash(user.Password.Trim(), user.Username.Trim());
systemDao.DbCommand.Parameters.AddWithValue("@Password", hashedPassword);
}else {
systemDao.DbCommand.CommandText = "uspUpdateAdministrator";
systemDao.DbCommand.Parameters.AddWithValue("@UserId", user.UserId);
}
systemDao.DbCommand.Parameters.AddWithValue("@Username", user.Username);
systemDao.DbCommand.Parameters.AddWithValue("@FirstName", user.FirstName);
systemDao.DbCommand.Parameters.AddWithValue("@LastName", user.LastName);
systemDao.DbCommand.Parameters.AddWithValue("@AdministratorYN", true);
string administratorKey = Security.GetSha2Hash(user.Username, hostSettings.BaseKey);
systemDao.DbCommand.Parameters.AddWithValue("@AdministratorKey", administratorKey);
if (user.UserId <= 0 || user.UserId == null) {
result = (int)systemDao.DbConnection.ExecuteCommand(systemDao.DbCommand);
}else result = systemDao.DbConnection.ExecuteCommand(systemDao.DbCommand);
}
}
}else {
throw new Exception("Unable to Connect");
}
}
}
}catch {
throw ;
}
}
public void Save()
{
if (this.hostSettings != null) {
if (hostSettings.ValidateModel()) {
using (HostDAO dao = new HostDAO()) {
dao.SaveHostSettings(this.hostSettings);
AppVars.dbSettings = hostSettings;
}
}
}
if (this.hostOptions != null) {
if (HostOptions.Validate(hostOptions)) {
using (HostDAO dao = new HostDAO()) {
dao.SaveHostOptions(this.hostOptions);
}
}
}
if (this.accountingSettings != null)
{
using (HostDAO dao = new HostDAO())
{
dao.SaveAccountingSettings(this.AccountingSettings);
}
}
SaveAdministrators(adminList);
if (DbCurrenVersion == 0)
{
ServiceHost.Implementation.Init.GetSettings();
using (DataBaseDao dao = new DataBaseDao())
{
this.DbCurrenVersion = dao.GetDatabaseVersion();
}
ServiceHost.Update.Init.Update(DbCurrenVersion);
}
Environment.Exit(1);
}
public void LoadViewOptions()
{
if (this.IsLoadedOptions) return;
using (HostDAO dao = new HostDAO()) {
this.HostOptions = dao.GetHostOptions();
}
this.IsLoadedOptions = true;
}
public void LoadViewDatabase()
{
if (this.IsLoadedDatabase) return;
using (HostDAO dao = new HostDAO()) {
this.HostSettings = new SMHostSettings(dao.GetHostSettings());
}
this.IsLoadedDatabase = true;
}
public void LoadViewAccounting()
{
if (this.IsLoadedAccounting) return;
using (HostDAO dao = new HostDAO())
{
this.AccountingSettings = dao.GetAccountingSettings();
}
this.IsLoadedAccounting = true;
}