/// <summary> /// Returns a new SourcingLinkDetails instance filled with the DataReader's current record data /// </summary> protected virtual SourcingLinkDetails GetSourcingLinkFromReader(DbDataReader reader) { SourcingLinkDetails sourcingLink = new SourcingLinkDetails(); if (reader.HasRows) { sourcingLink.SourcingLinkId = GetReaderValue_Int32(reader, "SourcingLinkId", 0); //From: [Table] sourcingLink.SourcingLinkName = GetReaderValue_String(reader, "SourcingLinkName", ""); //From: [Table] sourcingLink.URL = GetReaderValue_String(reader, "URL", ""); //From: [Table] sourcingLink.ClientNo = GetReaderValue_Int32(reader, "ClientNo", 0); //From: [Table] sourcingLink.UpdatedBy = GetReaderValue_NullableInt32(reader, "UpdatedBy", null); //From: [Table] sourcingLink.DLUP = GetReaderValue_DateTime(reader, "DLUP", DateTime.MinValue); //From: [Table] } return(sourcingLink); }
/// <summary> /// Get /// Calls [usp_select_SourcingLink] /// </summary> public static SourcingLink Get(System.Int32?sourcingLinkId) { Rebound.GlobalTrader.DAL.SourcingLinkDetails objDetails = Rebound.GlobalTrader.DAL.SiteProvider.SourcingLink.Get(sourcingLinkId); if (objDetails == null) { return(null); } else { SourcingLink obj = new SourcingLink(); obj.SourcingLinkId = objDetails.SourcingLinkId; obj.SourcingLinkName = objDetails.SourcingLinkName; obj.URL = objDetails.URL; obj.ClientNo = objDetails.ClientNo; obj.UpdatedBy = objDetails.UpdatedBy; obj.DLUP = objDetails.DLUP; objDetails = null; return(obj); } }