/// <summary> /// GetCurrentForProduct /// Calls [usp_select_DutyRate_Current_for_Product] /// </summary> public static DutyRate GetCurrentForProduct(System.Int32?productNo, System.DateTime?datePoint) { Rebound.GlobalTrader.DAL.DutyRateDetails objDetails = Rebound.GlobalTrader.DAL.SiteProvider.DutyRate.GetCurrentForProduct(productNo, datePoint); if (objDetails == null) { return(null); } else { DutyRate obj = new DutyRate(); obj.DutyRateValue = objDetails.DutyRateValue; objDetails = null; return(obj); } }
/// <summary> /// Returns a new DutyRateDetails instance filled with the DataReader's current record data /// </summary> protected virtual DutyRateDetails GetDutyRateFromReader(DbDataReader reader) { DutyRateDetails dutyRate = new DutyRateDetails(); if (reader.HasRows) { dutyRate.DutyRateId = GetReaderValue_Int32(reader, "DutyRateId", 0); //From: [Table] dutyRate.DutyDate = GetReaderValue_NullableDateTime(reader, "DutyDate", null); //From: [Table] dutyRate.DutyRateValue = GetReaderValue_NullableDouble(reader, "DutyRateValue", null); //From: [Table] dutyRate.ProductNo = GetReaderValue_Int32(reader, "ProductNo", 0); //From: [usp_selectAll_Allocation] dutyRate.UpdatedBy = GetReaderValue_NullableInt32(reader, "UpdatedBy", null); //From: [Table] dutyRate.DLUP = GetReaderValue_DateTime(reader, "DLUP", DateTime.MinValue); //From: [Table] } return(dutyRate); }
/// <summary> /// Get /// Calls [usp_select_DutyRate] /// </summary> public static DutyRate Get(System.Int32?dutyRateId) { Rebound.GlobalTrader.DAL.DutyRateDetails objDetails = Rebound.GlobalTrader.DAL.SiteProvider.DutyRate.Get(dutyRateId); if (objDetails == null) { return(null); } else { DutyRate obj = new DutyRate(); obj.DutyRateId = objDetails.DutyRateId; obj.DutyDate = objDetails.DutyDate; obj.DutyRateValue = objDetails.DutyRateValue; obj.ProductNo = objDetails.ProductNo; obj.UpdatedBy = objDetails.UpdatedBy; obj.DLUP = objDetails.DLUP; objDetails = null; return(obj); } }