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 string UpdateListing(ListingInfo listing)
{
if (listing != null)
{
using (iMAST_dbEntities db = new iMAST_dbEntities())
{
int no = Convert.ToInt32(listing.Id);
var l = db.ListingModels.Where(x => x.Id == no).FirstOrDefault();
if (l != null)
{
l.Title = listing.Title;
l.UrlId = listing.UrlId;
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;
db.SaveChanges();
return "Listing Updated";
}
else
{
return "Invalid Listing";
}
}
}
else
{
return "Invalid Listing";
}
}
public void UpdateListingTest()
{
ManageController controller = new ManageController();
ListingModel listingModel = controller.ReturnLastAddedListing();
ListingInfo listing = new ListingInfo();
listing.Id = listingModel.Id;
listing.Title = "Unit Test (Updated)";
listing.StartDate = listingModel.StartDate;
listing.EndDate = listingModel.EndDate;
listing.Area = listingModel.Area;
listing.Frequency = listingModel.Frequency;
listing.Description = "Unit testing... again!";
listing.HangoutUrl = listingModel.HangoutUrl;
listing.TeacherId = listingModel.TeacherId;
listing.Open = listingModel.Open;
listing.Teacher = "*****@*****.**";
//Check that the UpdateListing function completed successfully
Assert.AreEqual(controller.UpdateListing(listing), "Listing Updated");
//Check that the listing was actually updated in the database
ListingModel lastAdded = controller.ReturnLastAddedListing();
Assert.IsTrue( listing.Title == lastAdded.Title &&
listing.StartDate == lastAdded.StartDate &&
listing.EndDate == lastAdded.EndDate &&
listing.Area == lastAdded.Area &&
listing.Frequency == lastAdded.Frequency &&
listing.Description == lastAdded.Description &&
listing.HangoutUrl == lastAdded.HangoutUrl &&
listing.TeacherId == lastAdded.TeacherId &&
listing.Open == lastAdded.Open);
}
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 string UpdateListing(ListingInfo listing)
{
return listingService.UpdateListing(listing);
}
