public override string[] GetAllRoles()
{
using (iMAST_dbEntities db = new iMAST_dbEntities())
{
return db.iMentorRoles.Select(x => x.RoleName).ToArray();
}
}
public string RemoveUserAssignments(iMentorUserInfo user)
{
if (user != null)
{
using (iMAST_dbEntities db = new iMAST_dbEntities())
{
var assignments = db.AssignedListings.Where(x => x.UserId == user.Id).ToList();
if (assignments != null || assignments.Count == 0)
{
foreach (AssignedListing assignment in assignments)
{
db.AssignedListings.Remove(assignment);
db.SaveChanges();
}
return("Assignment Removed");
}
else
{
return("No assignment found");
}
}
}
else
{
return("Invalid Assignment");
}
}
public List <iMentorRole> GetRoles()
{
using (iMAST_dbEntities db = new iMAST_dbEntities())
{
return(db.iMentorRoles.ToList());
}
}
public string RemoveUserRole(iMentorUserInfo user)
{
if (user != null)
{
using (iMAST_dbEntities db = new iMAST_dbEntities())
{
var u = db.iMentorUserRoles.Where(x => x.UserId == user.Id).FirstOrDefault();
if (u != null)
{
db.iMentorUserRoles.Remove(u);
db.SaveChanges();
return("User Role Removed");
}
else
{
return("No user role found");
}
}
}
else
{
return("Invalid User Role");
}
}
public ListingModel AddListing(ListingModel listing)
{
if (listing != null)
{
using (iMAST_dbEntities db = new iMAST_dbEntities())
{
try
{
db.ListingModels.Add(listing);
db.SaveChanges();
//Return the listing because it now has its new Id
return(listing);
}
catch (Exception err)
{
return(null);
}
}
}
else
{
return(null);
}
}
public override string[] GetAllRoles()
{
using (iMAST_dbEntities db = new iMAST_dbEntities())
{
return(db.iMentorRoles.Select(x => x.RoleName).ToArray());
}
}
public List <iMentorUserInfo> GetAllUsers()
{
using (iMAST_dbEntities db = new iMAST_dbEntities())
{
var iMentorUsers = db.iMentorUsers.ToList();
List <iMentorUserInfo> users = new List <iMentorUserInfo>();
foreach (iMentorUser user in iMentorUsers)
{
var u = new iMentorUserInfo();
u.Id = user.Id;
u.UrlId = user.UrlId;
u.UserName = user.UserName;
u.FirstName = user.FirstName;
u.LastName = user.LastName;
u.Email = user.Email;
u.RoleId = u.GetRoleIdByUser(user);
u.Role = u.GetRoleName(user);
u.ShowOnlyAssignedListings = user.ShowOnlyAssignedListings;
u.IconIndex = user.IconIndex;
users.Add(u);
}
return(users);
}
}
public iMentorUserInfo GetCurrentUser(string userName)
{
var currentUserName = userName;
var user = new iMentorUserInfo();
if (!currentUserName.Equals(""))
{
using (iMAST_dbEntities db = new iMAST_dbEntities())
{
var iMentorUser = db.iMentorUsers.Where(x => x.UserName.Equals(currentUserName)).FirstOrDefault();
if (iMentorUser != null)
{
user.Id = iMentorUser.Id;
user.UrlId = iMentorUser.UrlId;
user.UserName = iMentorUser.UserName;
user.FirstName = iMentorUser.FirstName;
user.LastName = iMentorUser.LastName;
user.Email = iMentorUser.Email;
user.RoleId = user.GetRoleIdByUser(iMentorUser);
user.Role = user.GetRoleName(iMentorUser);
user.ShowOnlyAssignedListings = iMentorUser.ShowOnlyAssignedListings;
user.IconIndex = iMentorUser.IconIndex;
}
}
}
return(user);
}
public string RemoveParticipant(AssignedListing assignment)
{
if (assignment != null)
{
using (iMAST_dbEntities db = new iMAST_dbEntities())
{
var a = db.AssignedListings.Where(x => x.Id == assignment.Id).FirstOrDefault();
if (a != null)
{
db.AssignedListings.Remove(a);
db.SaveChanges();
return("Assignment Removed");
}
else
{
return("Invalid Assignment");
}
}
}
else
{
return("Invalid Assignment");
}
}
public List <AssignedListing> GetAssignments()
{
using (iMAST_dbEntities db = new iMAST_dbEntities())
{
return(db.AssignedListings.ToList());
}
}
public string RemoveUserApplications(iMentorUserInfo user)
{
if (user != null)
{
using (iMAST_dbEntities db = new iMAST_dbEntities())
{
var applications = db.Applicants.Where(x => x.UserId == user.Id).ToList();
if (applications != null || applications.Count == 0)
{
foreach (Applicant applicant in applications)
{
db.Applicants.Remove(applicant);
db.SaveChanges();
}
return("Applicant Removed");
}
else
{
return("No application found");
}
}
}
else
{
return("Invalid Applicant");
}
}
public string DeleteAspUser(iMentorUserInfo user)
{
if (user != null)
{
using (iMAST_dbEntities db = new iMAST_dbEntities())
{
var aspUser = db.AspNetUsers.Where(x => x.Email.Equals(user.Email)).FirstOrDefault();
if (aspUser != null)
{
db.AspNetUsers.Remove(aspUser);
db.SaveChanges();
return("Asp User Deleted");
}
else
{
return("Invalid Asp User");
}
}
}
else
{
return("Invalid Asp User");
}
}
public string RemoveApplicant(Applicant applicant)
{
if (applicant != null)
{
using (iMAST_dbEntities db = new iMAST_dbEntities())
{
var a = db.Applicants.Where(x => x.UserId == applicant.UserId && x.ListingId == applicant.ListingId).FirstOrDefault();
if (a != null)
{
db.Applicants.Remove(a);
db.SaveChanges();
return("Applicant Removed");
}
else
{
return("Invalid Applicant");
}
}
}
else
{
return("Invalid Applicant");
}
}
public List <Applicant> GetApplicants()
{
using (iMAST_dbEntities db = new iMAST_dbEntities())
{
return(db.Applicants.ToList());
}
}
public string DeleteListing(ListingModel listing)
{
if (listing != null)
{
using (iMAST_dbEntities db = new iMAST_dbEntities())
{
var l = db.ListingModels.Where(x => x.Id == listing.Id).FirstOrDefault();
if (l != null)
{
DeleteAssociatedAssignments(l);
DeleteAssociatedApplications(l);
db.ListingModels.Remove(l);
db.SaveChanges();
return("Listing Deleted");
}
else
{
return("Invalid Listing");
}
}
}
else
{
return("Invalid Listing");
}
}
public List <ListingInfo> GetListings()
{
using (iMAST_dbEntities db = new iMAST_dbEntities())
{
var listingModels = db.ListingModels.ToList();
List <ListingInfo> listings = new List <ListingInfo>();
foreach (ListingModel listing in listingModels)
{
var l = new ListingInfo();
l.Id = listing.Id;
l.UrlId = listing.UrlId;
l.Title = listing.Title;
l.StartDate = listing.StartDate;
l.EndDate = listing.EndDate;
l.Area = listing.Area;
l.AgeGroup = listing.AgeGroup;
l.Frequency = listing.Frequency;
l.Description = listing.Description;
l.HangoutUrl = listing.HangoutUrl;
l.HangoutStart = listing.HangoutStart;
l.TeacherId = listing.TeacherId;
l.Open = listing.Open;
l.Teacher = l.GetTeacherUserName(listing);
listings.Add(l);
}
CheckForExpiredListings(listings);
CheckForExpiredHangouts(listings);
return(listings);
}
}
public AspNetUser ReturnAspUser(string email)
{
using (iMAST_dbEntities db = new iMAST_dbEntities())
{
var user = db.AspNetUsers.Where(x => x.Email == email).FirstOrDefault();
return(user);
}
}
public iMentorUser GetUserById(string userId)
{
using (iMAST_dbEntities db = new iMAST_dbEntities())
{
var id = Convert.ToInt32(userId);
return(db.iMentorUsers.Where(x => x.Id == id).FirstOrDefault());
}
}
public List <ListingInfo> GetListingsByCurrentUser(string userName)
{
var currentUserName = userName;
List <ListingInfo> listings = new List <ListingInfo>();
var userInDatabase = false;
//Check if the current user is in the database
using (iMAST_dbEntities db = new iMAST_dbEntities())
{
userInDatabase = db.iMentorUsers.Where(x => x.UserName.Equals(currentUserName)).FirstOrDefault() != null;
}
if (userInDatabase)
{
using (iMAST_dbEntities db = new iMAST_dbEntities())
{
//Get the current user from the database
var iMentorUser = db.iMentorUsers.Where(x => x.UserName.Equals(currentUserName)).FirstOrDefault();
//Get current users assigned listings
var assignments = db.AssignedListings.Where(x => x.UserId == iMentorUser.Id);
//Get listings base on the assignments
var assidnedListings = new List <ListingModel>();
foreach (AssignedListing assignment in assignments)
{
assidnedListings.Add(db.ListingModels.Where(x => x.Id == assignment.ListingId).FirstOrDefault());
}
foreach (ListingModel listing in assidnedListings)
{
var l = new ListingInfo();
l.Id = listing.Id;
l.UrlId = listing.UrlId;
l.Title = listing.Title;
l.StartDate = listing.StartDate;
l.EndDate = listing.EndDate;
l.Area = listing.Area;
l.AgeGroup = listing.AgeGroup;
l.Frequency = listing.Frequency;
l.Description = listing.Description;
l.HangoutUrl = listing.HangoutUrl;
l.HangoutStart = listing.HangoutStart;
l.TeacherId = listing.TeacherId;
l.Open = listing.Open;
l.Teacher = l.GetTeacherUserName(listing);
listings.Add(l);
}
CheckForExpiredListings(listings);
}
}
return(listings);
}
public iMentorUser ReturnLastAddedUser()
{
using (iMAST_dbEntities db = new iMAST_dbEntities())
{
var lastAdded = (from n in db.iMentorUsers
orderby n.Id descending
select n).FirstOrDefault();
return(lastAdded);
}
}
public string GetTeacherName(ListingModel listing)
{
using (iMAST_dbEntities db = new iMAST_dbEntities())
{
var teacher = db.iMentorUsers.Where(x => x.Id == listing.TeacherId).FirstOrDefault();
var result = teacher.UserName;
return(result);
}
}
public ListingModel ReturnLastAddedListing()
{
using (iMAST_dbEntities db = new iMAST_dbEntities())
{
var lastAdded = (from n in db.ListingModels
orderby n.Id descending
select n).FirstOrDefault();
return(lastAdded);
}
}
public int GetTeacherIdByName(string teacherName)
{
using (iMAST_dbEntities db = new iMAST_dbEntities())
{
var role = db.iMentorUsers.Where(x => x.UserName.Equals(teacherName)).FirstOrDefault();
var result = role.Id;
return(result);
}
}
public AssignedListing ReturnLastAddedAssignment()
{
using (iMAST_dbEntities db = new iMAST_dbEntities())
{
var lastAdded = (from n in db.AssignedListings
orderby n.Id descending
select n).FirstOrDefault();
return(lastAdded);
}
}
public int GetRoleIdByUser(iMentorUser user)
{
using (iMAST_dbEntities db = new iMAST_dbEntities())
{
var userRole = db.iMentorUserRoles.Where(x => x.UserId == user.Id).FirstOrDefault();
var result = userRole.RoleId;
return(result);
}
}
public string GetRoleName(iMentorUser user)
{
using (iMAST_dbEntities db = new iMAST_dbEntities())
{
var userRole = db.iMentorUserRoles.Where(x => x.UserId == user.Id).FirstOrDefault();
var role = db.iMentorRoles.Where(x => x.Id == userRole.RoleId).FirstOrDefault();
var result = role.RoleName;
return(result);
}
}
private void DeleteAssociatedApplications(ListingModel listing)
{
using (iMAST_dbEntities db = new iMAST_dbEntities())
{
var applicants = db.Applicants.Where(x => x.ListingId == listing.Id).ToList();
foreach (Applicant applicant in applicants)
{
db.Applicants.Remove(applicant);
db.SaveChanges();
}
}
}
private void DeleteAssociatedAssignments(ListingModel listing)
{
using (iMAST_dbEntities db = new iMAST_dbEntities())
{
var assignments = db.AssignedListings.Where(x => x.ListingId == listing.Id).ToList();
foreach (AssignedListing assignment in assignments)
{
db.AssignedListings.Remove(assignment);
db.SaveChanges();
}
}
}
public override bool IsUserInRole(string username, string roleName)
{
using (iMAST_dbEntities db = new iMAST_dbEntities())
{
iMentorUser user = db.iMentorUsers.FirstOrDefault(u => u.UserName.Equals(username, StringComparison.CurrentCultureIgnoreCase) || u.Email.Equals(username, StringComparison.CurrentCultureIgnoreCase));
iMentorUserRole userRole = db.iMentorUserRoles.FirstOrDefault(x => x.UserId == user.Id);
iMentorRole role = db.iMentorRoles.FirstOrDefault(x => x.Id == userRole.RoleId);
var roles = new string[] { role.RoleName };
if (user != null)
return roles.Any(r => r.Equals(roleName, StringComparison.CurrentCultureIgnoreCase));
else
return false;
}
}
public string AddApplicant(Applicant applicant)
{
if (applicant != null)
{
using (iMAST_dbEntities db = new iMAST_dbEntities())
{
db.Applicants.Add(applicant);
db.SaveChanges();
return("Assignment Added");
}
}
else
{
return("Invalid Assignment");
}
}
public override bool IsUserInRole(string username, string roleName)
{
using (iMAST_dbEntities db = new iMAST_dbEntities())
{
iMentorUser user = db.iMentorUsers.FirstOrDefault(u => u.UserName.Equals(username, StringComparison.CurrentCultureIgnoreCase) || u.Email.Equals(username, StringComparison.CurrentCultureIgnoreCase));
iMentorUserRole userRole = db.iMentorUserRoles.FirstOrDefault(x => x.UserId == user.Id);
iMentorRole role = db.iMentorRoles.FirstOrDefault(x => x.Id == userRole.RoleId);
var roles = new string[] { role.RoleName };
if (user != null)
{
return(roles.Any(r => r.Equals(roleName, StringComparison.CurrentCultureIgnoreCase)));
}
else
{
return(false);
}
}
}
public List <iMentorUserInfo> GetUsersByListing(string data)
{
using (iMAST_dbEntities db = new iMAST_dbEntities())
{
var users = new List <iMentorUserInfo>();
if (data != null)
{
var userIds = new List <int>();
int id = Convert.ToInt32(data);
if (id > 0)
{
var listing = db.ListingModels.Where(x => x.Id == id).FirstOrDefault();
var assignments = db.AssignedListings.Where(x => x.ListingId == listing.Id).ToList();
foreach (AssignedListing assignment in assignments)
{
var user = db.iMentorUsers.Where(x => x.Id == assignment.UserId).FirstOrDefault();
var u = new iMentorUserInfo();
u.Id = user.Id;
u.UrlId = user.UrlId;
u.UserName = user.UserName;
u.FirstName = user.FirstName;
u.LastName = user.LastName;
u.Email = user.Email;
u.RoleId = u.GetRoleIdByUser(user);
u.Role = u.GetRoleName(user);
u.ShowOnlyAssignedListings = user.ShowOnlyAssignedListings;
u.IconIndex = user.IconIndex;
users.Add(u);
}
}
}
return(users);
}
}
