public void SaveResourceLink()
{
if (Id == 0)
{
SqlHelpers.Insert(SqlStatements.SQL_CREATE_RESOURCE_LINK.FormatWith(
Title.FixSqlString(), URL.FixSqlString(), (Active) ? "1" : "0", ThumbNail.FixSqlNull(), Description.FixSqlString()));
}
else
{
SqlHelpers.Update(SqlStatements.SQL_UPDATE_RESOURCE_LINK_BY_ID.FormatWith(
Title.FixSqlString(), URL.FixSqlString(), (Active) ? "1" : "0", ThumbNail.FixSqlNull(), Description.FixSqlString(), Id));
}
}
private static SystemSettings LoadSystemSettings()
{
try {
var dataRow = SqlHelpers.Select(SqlStatements.SQL_GET_MAIL_SETTINGS).Rows[0];
return(new SystemSettings()
{
Id = dataRow["Id"].ToString(),
MailServer = dataRow["MailServer"].ToString(),
ServerPort = dataRow["ServerPort"].ToString().GetInt32(),
SmtpUser = dataRow["SmtpUser"].ToString(),
SmtpPassword = dataRow["SmtpPassword"].ToString().DecryptString(),
FromEmail = dataRow["FromEmail"].ToString(),
FromUsername = dataRow["FromUsername"].ToString(),
RequireAuth = dataRow["RequireAuth"].ToString().GetAsBool(),
RequireSsl = dataRow["RequireSsl"].ToString().GetAsBool()
});
} catch (Exception ex) {
SqlHelpers.Insert(SqlStatements.SQL_LOG_EXCEPTION.FormatWith(DateTime.Now.ConvertSqlDateTime(), "SystemSettings", ex.Message.FixSqlString(), ex.StackTrace.FixSqlString()));
throw new ApplicationException("Sql Server Not accessible");
}
}
//public void AuthenticateUser(string userName, string password) {
// try {
// var dataRow = SqlHelpers.Select(SqlStatements.SQL_AUTHENTICATE_USER.FormatWith(userName, password)).Rows[0];
// if(dataRow.IsNullOrEmpty()) return;
// Id = dataRow["Id"].ToString();
// RoleId = dataRow["RoleId"].ToString();
// DisplayName = dataRow["DisplayName"].ToString();
// UserName = dataRow["UserName"].ToString();
// IsSuperAdmin = dataRow["SuperAdmin"].ToString().GetAsBool();
// UserPassReset = dataRow["PasswordReset"].ToString().GetAsBool();
// Notes = dataRow["Notes"].ToString();
// Role = SqlHelpers.SelectScalar(SqlStatements.SQL_GET_USER_ROLE.FormatWith(RoleId)).ToString();
// IsAuthenticated = true;
// IsAdmin = Role == "System User";
// } catch(Exception ex) {
// LogError("SystemUser: Authenticate User method", ex);
// throw new ApplicationException("Record not found");
// }
//}
private void LogError(string module, Exception error)
{
SqlHelpers.Insert(SqlStatements.SQL_LOG_EXCEPTION.FormatWith(DateTime.Now.ConvertSqlDateTime(), module.FixSqlString(), error.Message.FixSqlString(), error.StackTrace.FixSqlString()));
}
public void LogError(string module, string error)
{
SqlHelpers.Insert(SqlStatements.SQL_LOG_EXCEPTION.FormatWith(DateTime.Now.ConvertSqlDateTime(), module.FixSqlString(), error.FixSqlString(), string.Empty));
}
