public List <Club> Club_List() { using (var context = new StarTEDContext()) { return(context.Clubs.ToList()); } }
public ProgramCourses ProgramCourse_Find(int programcourseid) { using (var context = new StarTEDContext()) { return(context.ProgramCourses.Find(programcourseid)); } }
public Addresses Addresses_FindByID(int addressid) { using (var context = new StarTEDContext()) { return(context.Addresses.Find(addressid)); } }
public List <Addresses> Address_List() { using (var context = new StarTEDContext()) { return(context.Addresses.ToList()); } }
public Rentals Rentals_FindByID(int rentalid) { using (var context = new StarTEDContext()) { return(context.Rentals.Find(rentalid)); } }
public Club Club_Find(int clubid) { using (var context = new StarTEDContext()) { return(context.Clubs.Find(clubid)); } }
public List <RentalTypes> RentalType_List() { using (var context = new StarTEDContext()) { return(context.RentalTypes.ToList()); } }
public List <Programs> Programs_List() { using (var context = new StarTEDContext()) { return(context.Programs.ToList()); } }
public Programs Programs_FindByProgramID(int programid) { using (var context = new StarTEDContext()) { return(context.Programs.Find(programid)); } }
public List <ClubActivity> List_ClubActivity() { using (var context = new StarTEDContext()) { return(context.ClubActivities.ToList()); } }
public Courses Courses_GetCourse(string CourseID) { using (var context = new StarTEDContext()) { return(context.Courses.Find(CourseID)); } }
public ClubActivity GetClubActivity(int id) { using (var context = new StarTEDContext()) { return(context.ClubActivities.Find(id)); } }
public List <Courses> Courses_List() { using (var context = new StarTEDContext()) { return(context.Courses.ToList()); } }
public List <PropertyOwners> LandLords_List() { using (var context = new StarTEDContext()) { return(context.PropertyOwners.ToList()); } }
public void AddProgramCourse(ProgramCourses programCourses) { using (var context = new StarTEDContext()) { context.ProgramCourses.Add(programCourses); context.SaveChanges(); } }
public void AddCourse(Courses course) { using (var context = new StarTEDContext()) { context.Courses.Add(course); context.SaveChanges(); } }
public List <ClubActivity> Find_ClubActivityClubDate(string clubid, DateTime startdate) { using (var context = new StarTEDContext()) { string sql = "EXEC ClubActivities_FindByClubAndDate @p0, @p1"; var result = context.Database.SqlQuery <ClubActivity>(sql, clubid, startdate); return(result.ToList()); } }
public void DeleteClubActivity(int id) { using (var context = new StarTEDContext()) { var exisiting = context.ClubActivities.Find(id); context.ClubActivities.Remove(exisiting); context.SaveChanges(); } }
public void UpdateClubActivity(ClubActivity item) { using (var context = new StarTEDContext()) { var exisiting = context.Entry(item); exisiting.State = System.Data.Entity.EntityState.Modified; context.SaveChanges(); } }
public int AddClubActivity(ClubActivity item) { using (var context = new StarTEDContext()) { ClubActivity addeditem = context.ClubActivities.Add(item); context.SaveChanges(); return(addeditem.ActivityID); } }
public int Rentals_Add(Rentals item) { using (var context = new StarTEDContext()) { context.Rentals.Add(item); context.SaveChanges(); return(item.RentalID); } }
public List <Courses> Courses_FindByProgram(int programid) { using (var context = new StarTEDContext()) { IEnumerable <Courses> results = context.Database.SqlQuery <Courses>("Courses_FindByProgram @programid", new SqlParameter("programid", programid)); return(results.ToList()); } }
public List <Rentals> Rentals_GetByMonthlyRange(double min, double max) { using (var context = new StarTEDContext()) { IEnumerable <Rentals> results = context.Database.SqlQuery <Rentals>("Rentals_FindByMonthlyRateRange @minrange, @maxrange", new SqlParameter("minrange", min), new SqlParameter("maxrange", max)); return(results.ToList()); } }
public List <ClubActivity> Find_ClubActivityClub(string clubid) { using (var context = new StarTEDContext()) { string sql = "EXEC ClubActivities_FindByClub @p0"; var result = context.Database.SqlQuery <ClubActivity>(sql, clubid); var finalresult = result.ToList(); return(finalresult); } }
public List <Addresses> Addresses_FindByPartialStreetAddress(string number, string street) { using (var context = new StarTEDContext()) { IEnumerable <Addresses> results = context.Database.SqlQuery <Addresses>("Addresses_FindByPartialStreetAddress @number,@street", new SqlParameter("number", number), new SqlParameter("street", street)); return(results.ToList()); } }
public int Rentals_Update(Rentals item) { using (var context = new StarTEDContext()) { //Staging context.Entry(item).State = System.Data.Entity.EntityState.Modified; //Commit and Feedback (rows affected) return(context.SaveChanges()); } }
public List <Rentals> Rentals_FindByLandlord(int landlordid) { using (var context = new StarTEDContext()) { IEnumerable <Rentals> results = context.Database.SqlQuery <Rentals>("Rentals_FindByLandlord @landlordid", new SqlParameter("landlordid", landlordid)); return(results.ToList()); } }
public List <ProgramCourses> ProgramCourses_FindByCourseID(string courseID) { using (var context = new StarTEDContext()) { if (courseID == null || courseID == "") { return(context.ProgramCourses.ToList()); } return(context.ProgramCourses.Where(t => t.CourseID == courseID).ToList()); } }
public List <ProgramCourses> ProgramCourses_FindByProgramAndCourse(int programid, string courseid) { using (var context = new StarTEDContext()) { IEnumerable <ProgramCourses> results = context.Database.SqlQuery <ProgramCourses>("ProgramCourses_FindByProgramAndCourse @programid, @courseid", new SqlParameter("programid", programid), new SqlParameter("courseid", courseid)); return(results.ToList()); } }
public void RemoveCourse(Courses course) { using (var context = new StarTEDContext()) { var entity = context.Courses.Where(t => t.CourseID == course.CourseID).FirstOrDefault(); if (entity == null) { return; } context.Courses.Remove(entity); context.SaveChanges(); } }