public Schools FindByPKID(int id)
{
using (var context = new ContextStarTED())
{
return(context.School.Find(id));
}
}
public List <Schools> List()
{
using (var context = new ContextStarTED())
{
return(context.School.ToList());
}
}
public List <Program> List()
{
using (var context = new ContextStarTED())
{
return(context.Programs.ToList());
}
}
public Program FindByPGID(int id)
{
using (var context = new ContextStarTED())
{
return(context.Programs.Find(id));
}
}
public int Update(Program item)
{
using (var context = new ContextStarTED())
{
context.Entry(item).State = System.Data.Entity.EntityState.Modified;
return(context.SaveChanges());
}
}
public int Add(Program item)
{
using (var context = new ContextStarTED())
{
context.Programs.Add(item);
context.SaveChanges();
return(item.ProgramID);
}
}
public string Add(School item)
{
using (var context = new ContextStarTED())
{
context.Schools.Add(item);
context.SaveChanges();
return(item.SchoolCode);
}
}
public List <Program> FindBySchoolCode(string partialcode)
{
using (var context = new ContextStarTED())
{
IEnumerable <Program> results =
context.Database.SqlQuery <Program>("Programs_FindBySchool @schoolcode"
, new SqlParameter("schoolcode", partialcode));
return(results.ToList());
}
}
public List <Programs> FindByID(string id)
{
using (var context = new ContextStarTED())
{
IEnumerable <Programs> results =
context.Database.SqlQuery <Programs>("Programs_FindBySchool @Schoolcode"
, new SqlParameter("Schoolcode", id));
return(results.ToList());
}
}
public int Delete(int programid)
{
using (var context = new ContextStarTED())
{
var existing = context.Programs.Find(programid);
if (existing == null)
{
throw new Exception("Record has been removed from database");
}
context.Programs.Remove(existing);
return(context.SaveChanges());
}
}
public int Delete(string schoolCode)
{
using (var context = new ContextStarTED())
{
var existing = context.Schools.Find(schoolCode);
if (existing == null)
{
throw new Exception("Record has been removed from database");
}
context.Schools.Remove(existing);
return(context.SaveChanges());
}
}
