/// <summary>
/// GetForWarehouse
/// Calls [usp_select_Address_for_Warehouse]
/// </summary>
public static Address GetForWarehouse(System.Int32?warehouseId)
{
Rebound.GlobalTrader.DAL.AddressDetails objDetails = Rebound.GlobalTrader.DAL.SiteProvider.Address.GetForWarehouse(warehouseId);
if (objDetails == null)
{
return(null);
}
else
{
Address obj = new Address();
obj.AddressId = objDetails.AddressId;
obj.AddressName = objDetails.AddressName;
obj.Line1 = objDetails.Line1;
obj.Line2 = objDetails.Line2;
obj.Line3 = objDetails.Line3;
obj.County = objDetails.County;
obj.City = objDetails.City;
obj.State = objDetails.State;
obj.CountryNo = objDetails.CountryNo;
obj.ZIP = objDetails.ZIP;
obj.Inactive = objDetails.Inactive;
obj.UpdatedBy = objDetails.UpdatedBy;
obj.DLUP = objDetails.DLUP;
obj.CountryName = objDetails.CountryName;
objDetails = null;
return(obj);
}
}
/// <summary>
/// GetForCompany
/// Calls [usp_select_Address_for_Company]
/// </summary>
public static Address GetForCompany(System.Int32?companyAddressId)
{
Rebound.GlobalTrader.DAL.AddressDetails objDetails = Rebound.GlobalTrader.DAL.SiteProvider.Address.GetForCompany(companyAddressId);
if (objDetails == null)
{
return(null);
}
else
{
Address obj = new Address();
obj.AddressId = objDetails.AddressId;
obj.AddressName = objDetails.AddressName;
obj.Line1 = objDetails.Line1;
obj.Line2 = objDetails.Line2;
obj.Line3 = objDetails.Line3;
obj.County = objDetails.County;
obj.City = objDetails.City;
obj.State = objDetails.State;
obj.ZIP = objDetails.ZIP;
obj.Inactive = objDetails.Inactive;
obj.DLUP = objDetails.DLUP;
obj.UpdatedBy = objDetails.UpdatedBy;
obj.CompanyAddressId = objDetails.CompanyAddressId;
obj.DefaultBilling = objDetails.DefaultBilling;
obj.DefaultShipping = objDetails.DefaultShipping;
obj.CeaseDate = objDetails.CeaseDate;
obj.ShipViaNo = objDetails.ShipViaNo;
obj.ShipViaAccount = objDetails.ShipViaAccount;
obj.Notes = objDetails.Notes;
obj.ShippingNotes = objDetails.ShippingNotes;
obj.CompanyNo = objDetails.CompanyNo;
obj.CountryNo = objDetails.CountryNo;
obj.CountryName = objDetails.CountryName;
obj.ShipViaName = objDetails.ShipViaName;
// [001] code start
obj.TaxbyAddress = objDetails.TaxbyAddress;
obj.TaxValue = objDetails.TaxValue;
// End
//[002] code start
obj.IncotermNo = objDetails.IncotermNo;
obj.IncotermName = objDetails.IncotermName;
//[002] code end
obj.VatNo = objDetails.VatNo;
obj.RecievingNotes = objDetails.RecievingNotes;
objDetails = null;
return(obj);
}
}
/// <summary>
/// Returns a new AddressDetails instance filled with the DataReader's current record data
/// </summary>
protected virtual AddressDetails GetAddressFromReader(DbDataReader reader)
{
AddressDetails address = new AddressDetails();
if (reader.HasRows)
{
address.AddressId = GetReaderValue_Int32(reader, "AddressId", 0); //From: [Table]
address.AddressName = GetReaderValue_String(reader, "AddressName", ""); //From: [Table]
address.Line1 = GetReaderValue_String(reader, "Line1", ""); //From: [Table]
address.Line2 = GetReaderValue_String(reader, "Line2", ""); //From: [Table]
address.Line3 = GetReaderValue_String(reader, "Line3", ""); //From: [Table]
address.County = GetReaderValue_String(reader, "County", ""); //From: [Table]
address.City = GetReaderValue_String(reader, "City", ""); //From: [Table]
address.State = GetReaderValue_String(reader, "State", ""); //From: [Table]
address.CountryNo = GetReaderValue_NullableInt32(reader, "CountryNo", null); //From: [Table]
address.ZIP = GetReaderValue_String(reader, "ZIP", ""); //From: [Table]
address.Inactive = GetReaderValue_Boolean(reader, "Inactive", false); //From: [Table]
address.UpdatedBy = GetReaderValue_NullableInt32(reader, "UpdatedBy", null); //From: [Table]
address.DLUP = GetReaderValue_DateTime(reader, "DLUP", DateTime.MinValue); //From: [Table]
address.CountryName = GetReaderValue_String(reader, "CountryName", ""); //From: [usp_dropdown_Address_for_Company]
address.CompanyAddressId = GetReaderValue_Int32(reader, "CompanyAddressId", 0); //From: [usp_select_Address_DefaultBilling_for_Company]
address.DefaultBilling = GetReaderValue_Boolean(reader, "DefaultBilling", false); //From: [usp_select_Address_DefaultBilling_for_Company]
address.DefaultShipping = GetReaderValue_Boolean(reader, "DefaultShipping", false); //From: [usp_select_Address_DefaultBilling_for_Company]
address.CeaseDate = GetReaderValue_NullableDateTime(reader, "CeaseDate", null); //From: [usp_select_Address_DefaultBilling_for_Company]
address.ShipViaNo = GetReaderValue_NullableInt32(reader, "ShipViaNo", null); //From: [usp_select_Address_DefaultBilling_for_Company]
address.ShipViaAccount = GetReaderValue_String(reader, "ShipViaAccount", ""); //From: [usp_select_Address_DefaultBilling_for_Company]
address.Notes = GetReaderValue_String(reader, "Notes", ""); //From: [usp_select_Address_DefaultBilling_for_Company]
address.ShippingNotes = GetReaderValue_String(reader, "ShippingNotes", ""); //From: [usp_select_Address_DefaultBilling_for_Company]
address.CompanyNo = GetReaderValue_Int32(reader, "CompanyNo", 0); //From: [usp_list_Activity_by_Client_with_filter]
address.ShipViaName = GetReaderValue_String(reader, "ShipViaName", ""); //From: [usp_select_Address_DefaultBilling_for_Company]
/// /// ESMS #14
address.TaxbyAddress = GetReaderValue_NullableInt32(reader, "TaxbyAddress", null); //From: [usp_select_Address_DefaultBilling_for_Company]
address.TaxValue = GetReaderValue_String(reader, "TaxValue", "");
// End
}
return(address);
}
/// <summary>
/// Get
/// Calls [usp_select_Address]
/// </summary>
public static Address Get(System.Int32?addressId)
{
Rebound.GlobalTrader.DAL.AddressDetails objDetails = Rebound.GlobalTrader.DAL.SiteProvider.Address.Get(addressId);
if (objDetails == null)
{
return(null);
}
else
{
Address obj = new Address();
obj.AddressId = objDetails.AddressId;
obj.AddressName = objDetails.AddressName;
obj.Line1 = objDetails.Line1;
obj.Line2 = objDetails.Line2;
obj.Line3 = objDetails.Line3;
obj.County = objDetails.County;
obj.City = objDetails.City;
obj.State = objDetails.State;
obj.CountryNo = objDetails.CountryNo;
obj.ZIP = objDetails.ZIP;
obj.Inactive = objDetails.Inactive;
obj.UpdatedBy = objDetails.UpdatedBy;
obj.DLUP = objDetails.DLUP;
obj.CountryName = objDetails.CountryName;
// [001] code start
obj.TaxbyAddress = objDetails.TaxbyAddress;
obj.TaxValue = objDetails.TaxValue;
// End
//[002] code start
obj.IncotermNo = objDetails.IncotermNo;
obj.IncotermName = objDetails.IncotermName;
//[002] code end
objDetails = null;
return(obj);
}
}