//[001] code end /// <summary> /// GetByAddress /// Calls [usp_select_CompanyAddress_by_Address] /// </summary> public static CompanyAddress GetByAddress(System.Int32?addressId) { Rebound.GlobalTrader.DAL.CompanyAddressDetails objDetails = Rebound.GlobalTrader.DAL.SiteProvider.CompanyAddress.GetByAddress(addressId); if (objDetails == null) { return(null); } else { CompanyAddress obj = new CompanyAddress(); obj.CompanyAddressId = objDetails.CompanyAddressId; obj.CompanyNo = objDetails.CompanyNo; obj.AddressNo = objDetails.AddressNo; obj.CeaseDate = objDetails.CeaseDate; obj.ShipViaNo = objDetails.ShipViaNo; obj.ShipViaAccount = objDetails.ShipViaAccount; obj.Notes = objDetails.Notes; //ESMS #14 obj.TaxbyAddress = objDetails.TaxbyAddress; obj.UpdatedBy = objDetails.UpdatedBy; obj.DLUP = objDetails.DLUP; obj.DefaultBilling = objDetails.DefaultBilling; obj.DefaultShipping = objDetails.DefaultShipping; obj.ShippingNotes = objDetails.ShippingNotes; objDetails = null; return(obj); } }
/// <summary> /// Returns a new CompanyAddressDetails instance filled with the DataReader's current record data /// </summary> protected virtual CompanyAddressDetails GetCompanyAddressFromReader(DbDataReader reader) { CompanyAddressDetails companyAddress = new CompanyAddressDetails(); if (reader.HasRows) { companyAddress.CompanyAddressId = GetReaderValue_Int32(reader, "CompanyAddressId", 0); //From: [usp_select_Address_DefaultBilling_for_Company] companyAddress.CompanyNo = GetReaderValue_Int32(reader, "CompanyNo", 0); //From: [usp_list_Activity_by_Client_with_filter] companyAddress.AddressNo = GetReaderValue_Int32(reader, "AddressNo", 0); //From: [Table] companyAddress.CeaseDate = GetReaderValue_NullableDateTime(reader, "CeaseDate", null); //From: [usp_select_Address_DefaultBilling_for_Company] companyAddress.ShipViaNo = GetReaderValue_NullableInt32(reader, "ShipViaNo", null); //From: [usp_select_Address_DefaultBilling_for_Company] companyAddress.ShipViaAccount = GetReaderValue_String(reader, "ShipViaAccount", ""); //From: [usp_select_Address_DefaultBilling_for_Company] companyAddress.Notes = GetReaderValue_String(reader, "Notes", ""); //From: [usp_select_Address_DefaultBilling_for_Company] companyAddress.UpdatedBy = GetReaderValue_NullableInt32(reader, "UpdatedBy", null); //From: [Table] companyAddress.DLUP = GetReaderValue_DateTime(reader, "DLUP", DateTime.MinValue); //From: [Table] companyAddress.DefaultBilling = GetReaderValue_Boolean(reader, "DefaultBilling", false); //From: [usp_select_Address_DefaultBilling_for_Company] companyAddress.DefaultShipping = GetReaderValue_Boolean(reader, "DefaultShipping", false); //From: [usp_select_Address_DefaultBilling_for_Company] companyAddress.ShippingNotes = GetReaderValue_String(reader, "ShippingNotes", ""); //From: [usp_select_Address_DefaultBilling_for_Company] companyAddress.TaxbyAddress = GetReaderValue_NullableInt32(reader, "TaxbyAddress", 0); // From: [usp_select_Address_DefaultBilling_for_Company] } return(companyAddress); }