/// <summary> /// Get /// Calls [usp_select_Country] /// </summary> public static Country Get(System.Int32?countryId) { Rebound.GlobalTrader.DAL.CountryDetails objDetails = Rebound.GlobalTrader.DAL.SiteProvider.Country.Get(countryId); if (objDetails == null) { return(null); } else { Country obj = new Country(); obj.CountryId = objDetails.CountryId; obj.CountryName = objDetails.CountryName; obj.Notes = objDetails.Notes; obj.TelephonePrefix = objDetails.TelephonePrefix; obj.Duty = objDetails.Duty; obj.TaxNo = objDetails.TaxNo; obj.ShippingCost = objDetails.ShippingCost; obj.ClientNo = objDetails.ClientNo; obj.GlobalCountryNo = objDetails.GlobalCountryNo; obj.DeliveryLeadTimeAir = objDetails.DeliveryLeadTimeAir; obj.DeliveryLeadTimeSurface = objDetails.DeliveryLeadTimeSurface; obj.IsPriorityForLists = objDetails.IsPriorityForLists; obj.Inactive = objDetails.Inactive; obj.UpdatedBy = objDetails.UpdatedBy; obj.DLUP = objDetails.DLUP; obj.TaxName = objDetails.TaxName; obj.ShipSurchargePer = objDetails.ShipSurchargePer; objDetails = null; return(obj); } }
/// <summary> /// Returns a new CountryDetails instance filled with the DataReader's current record data /// </summary> protected virtual CountryDetails GetCountryFromReader(DbDataReader reader) { CountryDetails country = new CountryDetails(); if (reader.HasRows) { country.CountryId = GetReaderValue_Int32(reader, "CountryId", 0); //From: [Table] country.CountryName = GetReaderValue_String(reader, "CountryName", ""); //From: [usp_dropdown_Address_for_Company] country.Notes = GetReaderValue_String(reader, "Notes", ""); //From: [usp_select_Address_DefaultBilling_for_Company] country.TelephonePrefix = GetReaderValue_String(reader, "TelephonePrefix", ""); //From: [Table] country.Duty = GetReaderValue_Boolean(reader, "Duty", false); //From: [Table] country.TaxNo = GetReaderValue_NullableInt32(reader, "TaxNo", null); //From: [Table] country.ShippingCost = GetReaderValue_NullableDouble(reader, "ShippingCost", null); //From: [Table] country.ClientNo = GetReaderValue_Int32(reader, "ClientNo", 0); //From: [Table] country.GlobalCountryNo = GetReaderValue_NullableInt32(reader, "GlobalCountryNo", null); //From: [Table] country.DeliveryLeadTimeAir = GetReaderValue_NullableInt32(reader, "DeliveryLeadTimeAir", null); //From: [Table] country.DeliveryLeadTimeSurface = GetReaderValue_NullableInt32(reader, "DeliveryLeadTimeSurface", null); //From: [Table] country.IsPriorityForLists = GetReaderValue_Boolean(reader, "IsPriorityForLists", false); //From: [Table] country.Inactive = GetReaderValue_Boolean(reader, "Inactive", false); //From: [Table] country.UpdatedBy = GetReaderValue_NullableInt32(reader, "UpdatedBy", null); //From: [Table] country.DLUP = GetReaderValue_DateTime(reader, "DLUP", DateTime.MinValue); //From: [Table] country.TaxName = GetReaderValue_String(reader, "TaxName", ""); //From: [usp_select_Country] } return(country); }
/// <summary> /// GetShippingCost /// Calls [usp_select_Country_ShippingCost] /// </summary> public static Country GetShippingCost(System.Int32?countryId) { Rebound.GlobalTrader.DAL.CountryDetails objDetails = Rebound.GlobalTrader.DAL.SiteProvider.Country.GetShippingCost(countryId); if (objDetails == null) { return(null); } else { Country obj = new Country(); obj.ShippingCost = objDetails.ShippingCost; objDetails = null; return(obj); } }