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 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 IHttpActionResult PutListingModel(int id, ListingModel listingModel) { if (!ModelState.IsValid) { return BadRequest(ModelState); } if (id != listingModel.Id) { return BadRequest(); } db.Entry(listingModel).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!ListingModelExists(id)) { return NotFound(); } else { throw; } } return StatusCode(HttpStatusCode.NoContent); }
public void AddListingTest() { ManageController controller = new ManageController(); ListingModel listing = new ListingModel(); listing.Title = "Unit Test"; listing.StartDate = new DateTime(2016, 3, 20, 12, 00, 00); listing.EndDate = new DateTime(2016, 3, 21, 12, 00, 00); listing.Area = "History"; listing.Frequency = "Always"; listing.Description = "Unit testing!"; listing.HangoutUrl = "what.com"; listing.TeacherId = 5; listing.Open = false; //Testing the AddListing function controller.AddListing(listing); //Check that the listing was actually added to 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 IHttpActionResult PostListingModel(ListingModel listingModel) { if (!ModelState.IsValid) { return BadRequest(ModelState); } db.ListingModels.Add(listingModel); db.SaveChanges(); return CreatedAtRoute("DefaultApi", new { id = listingModel.Id }, listingModel); }
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(); } } }
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(); } } }
public void GetListingsTest() { ManageController controller = new ManageController(); var JSONListings = controller.GetListings(); string stringListings = JsonConvert.SerializeObject(JSONListings.Data); List<ListingInfo> ListListings = JsonConvert.DeserializeObject<List<ListingInfo>>(stringListings); ListingInfo test = ListListings.Last(); ListingModel listing = new ListingModel(); listing.Title = "Unit Test (Updated)"; listing.StartDate = new DateTime(2016, 3, 20, 12, 00, 00); listing.EndDate = new DateTime(2016, 3, 21, 12, 00, 00); listing.Area = "History"; listing.Frequency = "Always"; listing.Description = "Unit testing... again!"; listing.HangoutUrl = "what.com"; listing.TeacherId = 5; listing.Open = false; //Check that all listings were returned by checking for a specific listing Assert.IsTrue( listing.Title == test.Title && listing.StartDate == test.StartDate && listing.EndDate == test.EndDate && listing.Area == test.Area && listing.Frequency == test.Frequency && listing.Description == test.Description && listing.HangoutUrl == test.HangoutUrl && listing.TeacherId == test.TeacherId && listing.Open == test.Open); }
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 string DeleteListing(ListingModel listing) { return listingService.DeleteListing(listing); }
public JsonResult AddListing(ListingModel listing) { var toReturn = listingService.AddListing(listing); return Json(toReturn, JsonRequestBehavior.AllowGet); }