private NomineeDirectors FetchNomineeDirectors(NomineeDirectors NomineeDirector, SafeDataReader dr) { NomineeDirector.PersonID = dr.GetInt32("PersonID"); NomineeDirector.PersonSource = dr.GetString("PersonSource"); NomineeDirector.Name = dr.GetString("Name"); return NomineeDirector; }
/// <summary> /// Description : Get Auditors Details from database. /// Created By : Pavan /// Created Date : 23 August 2014 /// Modified By : /// Modified Date: /// </summary> /// <returns></returns> public static List<NomineeDirectors> GetNomineeDirectorsDetails(int WOID, string InfoCode) { var data = new List<NomineeDirectors>(); System.Diagnostics.StackFrame stackFrame = new System.Diagnostics.StackFrame(); System.Reflection.MethodBase methodBase = stackFrame.GetMethod(); log.Debug("Start: " + methodBase.Name); try { SqlParameter[] sqlParams = new SqlParameter[2]; sqlParams[0] = new SqlParameter("@WOID", WOID); sqlParams[1] = new SqlParameter("@InfoCode", InfoCode); var reader = SqlHelper.ExecuteReader(ConnectionUtility.GetConnectionString(), CommandType.StoredProcedure, "[SpGetNomineeDirectorsByWOIDAndInfoCode]", sqlParams); var safe = new SafeDataReader(reader); while (reader.Read()) { var NomineeDirectors = new NomineeDirectors(); NomineeDirectors.FetchNomineeDirectors(NomineeDirectors, safe); data.Add(NomineeDirectors); } } catch (Exception ex) { log.Error("Error: " + ex); return data; } finally { log.Debug("End: " + methodBase.Name); } return data; }