public StudentPhoneList GetByStudentId(Guid studentId) { _list.Clear(); Database db = new Database("Student"); db.Command.CommandType = CommandType.StoredProcedure; db.Command.CommandText = "tblStudentPhoneGetByStudentID"; db.Command.Parameters.Add("@StudentId", SqlDbType.UniqueIdentifier).Value = studentId; DataTable dt = db.ExecuteQuery(); foreach (DataRow dr in dt.Rows) { StudentPhone s = new StudentPhone(); s.Initialize(dr); s.InitializeBusiniessData(dr); s.IsDirty = false; s.IsNew = false; s.evtIsSavable += new IsSavableHandler(s_evtIsSavable); _list.Add(s); } return this; }
public StudentPhoneList GetByStudentId(Guid studentId) { _list.Clear(); Database db = new Database("Student"); db.Command.CommandType = CommandType.StoredProcedure; db.Command.CommandText = "tblStudentPhoneGetByStudentID"; db.Command.Parameters.Add("@StudentId", SqlDbType.UniqueIdentifier).Value = studentId; DataTable dt = db.ExecuteQuery(); foreach (DataRow dr in dt.Rows) { StudentPhone s = new StudentPhone(); s.Initialize(dr); s.InitializeBusiniessData(dr); s.IsDirty = false; s.IsNew = false; s.evtIsSavable += new IsSavableHandler(s_evtIsSavable); _list.Add(s); } return(this); }