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