public Object GetPerson(int id) { Person p = new Person(); p.Id = id; PersonDb logDb = new PersonDb(); return logDb.GetPerson(p); }
public Person Login(string UserName, string Password) { Person p = new Person(); p.UserName = UserName; p.Password = Password; PersonDb logDb = new PersonDb(); return logDb.Login(p); }
public Person Login(string user, string password) { Person pers = new Person(); pers.User = user; pers.Password = password; persDb = new PersonDb(); return persDb.Login(pers); }
private List<TutoringTime> MiscWhere(string where, Boolean retrieveAssociation) { List<TutoringTime> tts = new List<TutoringTime>(); try { cmd = new SqlCommand(); cmd.CommandText = BuildQuery(where); dbCon = new DbConnection(); cmd.Connection = dbCon.GetConnection(); cmd.Connection.Open(); cmd.CommandType = CommandType.Text; SqlDataReader dr = cmd.ExecuteReader(); TutoringTime tt = null; while (dr.Read()) { tt = BuildTutoringTime(dr); if (retrieveAssociation) { PersonDb persDb = new PersonDb(); int pid = tt.Teacher.Id; Person teacher = persDb.SingleWhere("pid = '" + pid + "'", false); tt.Teacher = teacher; } tts.Add(tt); } dr.Close(); } catch { throw; } return tts; }
private List<Assignment> MiscWhere(string where, Boolean retrieveAssociation) { List<Assignment> asgs = new List<Assignment>(); try { cmd = new SqlCommand(); cmd.CommandText = BuildQuery(where); dbCon = new DbConnection(); cmd.Connection = dbCon.GetConnection(); cmd.Connection.Open(); cmd.CommandType = CommandType.Text; SqlDataReader dr = cmd.ExecuteReader(); Assignment asg = null; while (dr.Read()) { asg = BuildAssignment(dr); if (retrieveAssociation) { PersonDb persDb = new PersonDb(); int pid = asg.Teacher.Id; Person teacher = persDb.SingleWhere("pid = '" + pid + "'", false); asg.Teacher = teacher; } asgs.Add(asg); } dr.Close(); } catch { throw; } return asgs; }
public List<Person> GetAllTeachersBySubject(string subject) { persDb = new PersonDb(); return persDb.GetAllTeachersBySubject(subject); }
public List<Person> GetAllTeachers() { persDb = new PersonDb(); return persDb.GetAllTeachers(); }
public List<Teacher> GetAllTeachers() { PersonDb pDb = new PersonDb(); return pDb.GetAllTeachers(); }
private List<Homework> MiscWhere(string where, Boolean retrieveAssociation) { List<Homework> hws = new List<Homework>(); try { cmd = new SqlCommand(); cmd.CommandText = BuildQuery(where); dbCon = new DbConnection(); cmd.Connection = dbCon.GetConnection(); cmd.Connection.Open(); cmd.CommandType = CommandType.Text; SqlDataReader dr = cmd.ExecuteReader(); Homework hw = null; while (dr.Read()) { hw = BuildHomework(dr); if (retrieveAssociation) { PersonDb persDb = new PersonDb(); int childId = hw.Child.Id; Person child = persDb.SingleWhere("pid = '" + childId + "'", false); hw.Child = child; AssignmentDb asgDb = new AssignmentDb(); int assignmentId = hw.Assignment.Id; Assignment asg = asgDb.SingleWhere("aid = '" + assignmentId + "'", false); hw.Assignment = asg; } hws.Add(hw); } dr.Close(); } catch { throw; } return hws; }