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();
}
}
