public static List <EventViewModel> GetEventsByUserId(ref DAO.ApplicationContext context, int creatorId)
{
var myEvents = CalendarHelper.GetEvents(ref context)
.Where(x => x.CreatorId == creatorId);
return((List <EventViewModel>)myEvents.ToList());
}
public static List <MessageViewModel> GetMessagesFromUserId(ref DAO.ApplicationContext context, int fromUserId)
{
List <MessageViewModel> msgs = (List <MessageViewModel>)GetMessages(ref context)
.Where(x => x.FromUserId == fromUserId).ToList();
return(msgs);
}
public static IEnumerable <ContactLogViewModel> GetContactLogsByMenteeId(ref DAO.ApplicationContext context, int personId)
{
List <ContactLogViewModel> logs = (List <ContactLogViewModel>)GetContactLogs(ref context)
.Where(x => x.MenteeId == personId).ToList();
return(logs);
}
public static List <UserProfileViewModel> GetUserProfilesByRoleName(ref DAO.ApplicationContext context, string roleName)
{
List <UserProfileViewModel> users = (List <UserProfileViewModel>)GetUserProfiles(ref context)
.Where(x => x.UserRole.Name == roleName).ToList();
return(users);
}
public static List <EventViewModel> GetEventsForMentee(ref DAO.ApplicationContext context, int menteeId)
{
var myEvents = CalendarHelper.GetEvents(ref context)
.Where(x => x.MenteeId == menteeId);
return((List <EventViewModel>)myEvents.ToList());
}
public static List <UserProfileViewModel> GetUserProfilesByRoleId(ref DAO.ApplicationContext context, int roleId)
{
List <UserProfileViewModel> users = (List <UserProfileViewModel>)GetUserProfiles(ref context)
.Where(x => x.UserRole.id == roleId).ToList();
return(users);
}
public static UserProfileViewModel GetUserProfileByUsername(ref DAO.ApplicationContext context, string username)
{
UserProfileViewModel user = (UserProfileViewModel)GetUserProfiles(ref context)
.Where(x => x.UserProfile.Username == username).FirstOrDefault();
return(user);
}
public static UserProfileViewModel GetUserProfileByPersonId(ref DAO.ApplicationContext context, int personId)
{
UserProfileViewModel user = (UserProfileViewModel)GetUserProfiles(ref context)
.Where(x => x.Person.id == personId);
return(user);
}
public static List <MessageViewModel> GetMessagesToUserId(ref DAO.ApplicationContext context, int toUserId)
{
List <MessageViewModel> msgs = (List <MessageViewModel>)GetMessages(ref context)
.Where(x => x.ToUserId == toUserId).OrderByDescending(x => x.Created).ToList();
return(msgs);
}
public static UserProfile GetUsernameByUserId(ref DAO.ApplicationContext context, int id)
{
var data = (from r in context.UserProfiles
where r.id == id
select r).FirstOrDefault();
return(data);
}
public static MentorApplication GetMentorApplicationByPersonId(ref DAO.ApplicationContext context, int id)
{
MentorApplication application = (from r in context.MentorApplications
where r.PersonId == id
select r).FirstOrDefault();
return(application);
}
public static int GetUserIdByUsername(ref DAO.ApplicationContext context, string username)
{
var user = (from r in context.People
join p in context.UserProfiles on r.id equals p.PersonId
where p.Username == username
select r).FirstOrDefault();
return((user != null) ? user.id : 0);
}
public static List <EventViewModel> GetPublicEvents(ref DAO.ApplicationContext context)
{
int eventType = DomainHelper.GetIdByKeyValue(ref context, "EventType", "Public");
var myEvents = CalendarHelper.GetEvents(ref context)
.Where(x => x.EventType == eventType);
return((List <EventViewModel>)myEvents.ToList());
}
public static List <EventViewModel> GetMenteeMeetingRequests(ref DAO.ApplicationContext context, int mentorId)
{
int eventType = DomainHelper.GetIdByKeyValue(ref context, "EventType", "Mentee Meeting Request");
var myEvents = CalendarHelper.GetEvents(ref context)
.Where(x => x.EventType == eventType && x.MentorId == mentorId);
return((List <EventViewModel>)myEvents.ToList());
}
public static string GetUserRoleByUsername(ref DAO.ApplicationContext context, string username)
{
var data = (from r in context.UserProfiles
join p in context.UserRoles on r.RoleId equals p.id
where r.Username == username
select p.Name).FirstOrDefault();
return((string)data);
}
public static IEnumerable <ContactLogViewModel> GetContactLogsByMinistryId(ref DAO.ApplicationContext context, int ministryId)
{
var contactLogs = context.ContactLogs.ToList();
var logs = (from r in GetContactLogs(ref context)
join c in context.Ministries on r.MinistryId equals c.id
where c.id == ministryId
select r).ToList();
return((List <ContactLogViewModel>)logs);
}
public MessageViewModel(ref DAO.ApplicationContext context, Message msg)
{
this.MessageId = msg.id;
this.ToUserId = msg.ToUserId;
this.ToUser = Helpers.AccountHelper.GetUsernameByUserId(ref context, msg.ToUserId).Username;
this.FromUserId = msg.FromUserId;
this.FromUser = Helpers.AccountHelper.GetUsernameByUserId(ref context, msg.FromUserId).Username;
this.Created = msg.Created;
this.Subject = msg.Subject;
this.Body = msg.Body;
}
public static List <UserProfileViewModel> GetUserProfiles(ref DAO.ApplicationContext context)
{
var users = (from r in context.UserProfiles
join p in context.UserRoles on r.RoleId equals p.id
join c in context.People.DefaultIfEmpty() on r.PersonId equals c.id
select new UserProfileViewModel
{
UserProfile = r,
UserRole = p,
Person = c
}).ToList();
return((List <UserProfileViewModel>)users);
}
public static MentorViewModel GetMentorById(ref DAO.ApplicationContext context, int personId)
{
MentorViewModel mentor = new MentorViewModel();
mentor.Person = (from r in context.People
where r.id == personId
select r).First();
mentor.HomeAddress = AddressHelper.GetAddressByPersonAndType(ref context, personId, "Home");
mentor.WorkAddress = AddressHelper.GetAddressByPersonAndType(ref context, personId, "Work");
mentor.MinistryId = MinistryHelper.GetMinistryByPersonId(ref context, personId);
return(mentor);
}
public static List <MenteeViewModel> GetMentees(ref DAO.ApplicationContext context)
{
int menteeType = DomainHelper.GetValueByKeyValue(ref context, "PersonType", "Mentee").id;
var data = (from r in context.People
where r.PersonTypeId == menteeType
select r).AsEnumerable()
.Select(x => new MenteeViewModel
{
Mentee = x,
});
return((List <MenteeViewModel>)data.ToList());
}
public static IEnumerable <SelectListItem> GetValidEventsDropdown(ref DAO.ApplicationContext context)
{
var events = (from r in context.Events
where r.EventBegins >= DateTime.Today
where r.EventEnds <= DateTime.Today
select r).AsEnumerable()
.Select(x => new SelectListItem
{
Value = x.id.ToString(),
Text = x.EventName
}).ToList();
events.Insert(0, new SelectListItem {
Value = "0", Text = "Please select ..."
});
return(events);
}
public static IEnumerable <SelectListItem> GetMenteesDropdownList(ref DAO.ApplicationContext context)
{
int menteeType = DomainHelper.GetValueByKeyValue(ref context, "PersonType", "Mentee").id;
var data = (from r in context.People
where r.PersonTypeId == menteeType
select r).AsEnumerable()
.Select(x => new SelectListItem
{
Text = x.LastName + ", " + x.FirstName,
Value = x.id.ToString()
}).ToList();
data.Insert(0, new SelectListItem {
Value = "0", Text = "Please select ..."
});
return(data);
}
public static IEnumerable <ContactLogViewModel> GetContactLogs(ref DAO.ApplicationContext context)
{
var contactLogs = context.ContactLogs.ToList();
var logs = (from r in contactLogs
join c in context.People on r.MentorId equals c.id
join d in context.People on r.MenteeId equals d.id
orderby r.ContactDate descending
select new ContactLogViewModel
{
ContactLogId = r.id,
ContactDate = r.ContactDate.ToString("s"),
MenteeName = c.LastName + ", " + c.FirstName,
MentorName = c.LastName + ", " + c.LastName,
ActivityTypeId = r.ActivityTypeId,
ContactTypeId = r.ContactTypeId
}).AsEnumerable();
return(logs);
}
public static IEnumerable <EventViewModel> GetEvents(ref DAO.ApplicationContext context)
{
var evts = (from r in context.Events
orderby r.EventBegins
select new EventViewModel
{
id = r.id,
CreatorId = r.CreatorId,
EventName = r.EventName,
EventDetails = r.EventDetails,
EventUrl = r.EventUrl,
EventBegins = r.EventBegins,
EventEnds = r.EventEnds,
AllDayEvent = r.AllDayEvent,
EventType = r.EventType,
MentorId = r.MentorId,
MenteeId = r.MenteeId,
SignupId = r.SignupId
}).AsEnumerable();
return(evts);
}
public static List <MessageViewModel> GetMessages(ref DAO.ApplicationContext context)
{
// Get messages for this mentor
var messages = context.Messages.ToList();
var msgs = (from r in messages
join c in context.UserProfiles on r.ToUserId equals c.id
join p in context.UserProfiles on r.FromUserId equals p.id
orderby r.Created ascending
select new MessageViewModel
{
MessageId = r.id,
FromUserId = r.FromUserId,
FromUser = p.Username,
ToUserId = r.ToUserId,
ToUser = WebMatrix.WebData.WebSecurity.CurrentUserName,
Created = r.Created,
IsFlashTraffic = r.IsFlashTraffic,
Subject = r.Subject,
Body = r.Body
}).ToList();
return((List <MessageViewModel>)msgs);
}
public static RegistrationViewModel FindRegistration(ref DAO.ApplicationContext context, string username)
{
int personId = AccountHelper.GetUserIdByUsername(ref context, username);
if (personId > 0)
{
RegistrationViewModel viewModel = new RegistrationViewModel();
int homeAddrType = DomainHelper.GetIdByKeyValue(ref context, "AddressType", "Home");
int workAddrType = DomainHelper.GetIdByKeyValue(ref context, "AddressType", "Work");
MentorApplication data = (MentorApplication)(from r in context.MentorApplications
where r.PersonId == personId
select r).FirstOrDefault();
UserProfile profile = (UserProfile)(from r in context.UserProfiles
where r.PersonId == personId
select r).FirstOrDefault();
Person mentor = (Person)(from r in context.People
where r.id == personId
select r).FirstOrDefault();
Address homeAddr = (Address)(from r in context.Addresses
join c in context.PersonToAddress on r.id equals c.AddressId
where c.PersonId == personId && c.AddressType == homeAddrType
select r).FirstOrDefault();
Address workAddr = (Address)(from r in context.Addresses
join c in context.PersonToAddress on r.id equals c.AddressId
where c.PersonId == personId && c.AddressType == workAddrType
select r).FirstOrDefault();
viewModel.AgreeToTerms = data.AgreeToTerms;
viewModel.Availability = data.Availability;
viewModel.DateOfBirth = mentor.DOB;
viewModel.FelonyArrested = mentor.FelonyArrested;
viewModel.FelonyConvicted = mentor.FelonyConvicted;
viewModel.FelonyDescription = mentor.FelonyDescription;
viewModel.FirstName = mentor.FirstName;
viewModel.GenderId = mentor.GenderId;
viewModel.HasRelationIncarcerated = data.HasRelationIncarcerated;
viewModel.HomeAddress = homeAddr;
viewModel.LastName = mentor.LastName;
viewModel.LeadershipSkills = data.LeadershipSkills;
viewModel.MaidenName = mentor.MaidenName;
viewModel.MiddleInitial = mentor.MiddleInitial;
viewModel.MinistryExperience = data.MinistryExperience;
viewModel.MinistryId = data.MinistryId;
viewModel.MisdemeanorArrested = mentor.MisdemeanorArrested;
viewModel.MisdemeanorConvicted = mentor.MisdemeanorConvicted;
viewModel.MisdemeanorDescription = mentor.MisdemeanorDescription;
viewModel.PersonId = mentor.id;
viewModel.PrefixId = mentor.PrefixId;
viewModel.RaceId = mentor.RaceId;
viewModel.RelationIncarceratedName = data.RelationIncarceratedName;
viewModel.RelationIncarceratedNumber = data.RelationIncarceratedNumber;
viewModel.RelationIncarceratedType = data.RelationIncarceratedType;
viewModel.RelativesWorkingForDoC = data.RelativesWorkingForDoC;
viewModel.RelativeWorkingForDoCName = data.RelativeWorkingForDoCName;
viewModel.RelativeWorkingForDoCRelationType = data.RelativeWorkingForDoCRelationType;
viewModel.RelativeWorkingForDoCWorkLocation = data.RelativeWorkingForDoCWorkLocation;
viewModel.SocialSecurityNumber = mentor.SSN;
viewModel.SpecialHobbies = data.SpecialHobbies;
viewModel.SpecialRequests = data.SpecialRequests;
viewModel.StateDl = mentor.StateDl;
viewModel.StateWhereDlIssued = mentor.StateWhereDlWasIssued;
viewModel.SuffixId = mentor.SuffixId;
if (data.WhenWorkedEnded != null)
{
viewModel.WhenWorkedEnded = data.WhenWorkedEnded.Value;
}
if (data.WhenWorkedStarted != null)
{
viewModel.WhenWorkedStarted = data.WhenWorkedStarted.Value;
}
viewModel.WhereDidYouWork = data.WhereDidYouWork;
viewModel.WorkAddress = workAddr;
viewModel.WorkedForDoC = data.WorkedForDoC;
viewModel.Username = profile.Username;
return(viewModel);
}
else
{
return(null);
}
}
