//[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);
}
