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); } // }