public string DisplayRecord(VolunteerTracker.ActiveRecord record)
{
string type = record.GetType().Name;
string modifiedDate = record.GetTimeSinceModification();
string createdDate = record.GetTimeSinceCreation();
long userId = VolunteerTracker.Database.GetUserId();
VolunteerTracker.Database.SetUserId(VolunteerTracker.AccessControlList.ROOT_USERID);
string modifiedBy = new VolunteerTracker.User(record.ModifiedBy).Email;
VolunteerTracker.Database.SetUserId(userId);
string linkUrl = "";
string linkText = "";
if (record is VolunteerTracker.Person) {
//linkUrl = QuickPMWebsite.AppCode.Link.LinkTo((VolunteerTracker.Person)record, Page);
return "";
}
if (record is VolunteerTracker.Volunteer)
{
linkUrl = "Volunteer/Volunteer.aspx?Id=" + record.Id;
linkText = ((VolunteerTracker.Volunteer)(record)).FirstName;
}
if (record is VolunteerTracker.Event)
{
linkUrl = "Event/Event.aspx?Id=" + record.Id;
linkText = ((VolunteerTracker.Event)(record)).Name;
}
string link = "<a href=\"" + linkUrl + "\">" + linkText + "</a>";
return "<td>" + type + "</td><td>" + link + "</td><td style=\"background-color:#D8D8D8 \">" + modifiedDate +
"</td><td style=\"background-color:#D8D8D8 \">" + createdDate + "</td>" +
"</td><td style=\"background-color:#D8D8D8 \">" + modifiedBy + "</td>";
}
public static void UpdateDatabaseConnectionString(ProfileBase profile, HttpRequest request)
{
if (request != null)
{
//VolunteerTracker.Document.RootPath = request.PhysicalApplicationPath + "App_Data";
//VolunteerTracker.ExpenseList.RootPath = request.PhysicalApplicationPath + "App_Data";
}
string databaseFileName = ConfigurationManager.AppSettings["DatabaseFileName"];
string databaseName = ConfigurationManager.AppSettings["DatabaseName"];
string databaseUserName = ConfigurationManager.AppSettings["DatabaseUserName"];
string databasePassword = ConfigurationManager.AppSettings["DatabasePassword"];
string databaseConnector = ConfigurationManager.AppSettings["DatabaseConnector"];
if (databaseConnector.ToLower() == "postgresql")
{
VolunteerTracker.DatabaseAccess.SetDatabaseType(new VolunteerTracker.PSQL());
}
if (databaseConnector.ToLower() == "sqlite")
{
VolunteerTracker.DatabaseAccess.SetDatabaseType(new VolunteerTracker.SQLite());
}
VolunteerTracker.Database.SetConnectionString(VolunteerTracker.Database.CreateConnectionString(databaseFileName, databaseName, databaseUserName, databasePassword));
if (profile.IsAnonymous)
{
VolunteerTracker.Database.SetUserId(VolunteerTracker.AccessControlList.ROOT_USERID);
return;
}
MembershipUser mu = Membership.GetUser(profile.UserName);
VolunteerTracker.Database.SetUserId(VolunteerTracker.AccessControlList.ROOT_USERID);
bool userExists = false;
System.Collections.Generic.List<VolunteerTracker.User> users = VolunteerTracker.User.Find<VolunteerTracker.User>();
foreach (VolunteerTracker.User user in users)
{
if(user.Email.Trim().ToLower() == mu.Email.Trim().ToLower())
{
VolunteerTracker.User pmUser = new VolunteerTracker.User(mu.Email);
VolunteerTracker.Database.SetUserId(pmUser.Id);
userExists = true;
break;
}
}
if (!userExists)
{
VolunteerTracker.User user = new VolunteerTracker.User(mu.Email);
user.Save();
VolunteerTracker.Database.SetUserId(user.Id);
}
//
}
