/// <summary>
/// Returns a new ClientDetails instance filled with the DataReader's current record data
/// </summary>
protected virtual ClientDetails GetClientFromReader(DbDataReader reader)
{
ClientDetails client = new ClientDetails();
if (reader.HasRows)
{
client.ClientId = GetReaderValue_Int32(reader, "ClientId", 0); //From: [Table]
client.ClientName = GetReaderValue_String(reader, "ClientName", ""); //From: [Table]
client.ParentClientNo = GetReaderValue_NullableInt32(reader, "ParentClientNo", null); //From: [Table]
client.CurrencyNo = GetReaderValue_Int32(reader, "CurrencyNo", 0); //From: [Table]
client.Telephone = GetReaderValue_String(reader, "Telephone", ""); //From: [Table]
client.Fax = GetReaderValue_String(reader, "Fax", ""); //From: [Table]
client.EMail = GetReaderValue_String(reader, "EMail", ""); //From: [Table]
client.URL = GetReaderValue_String(reader, "URL", ""); //From: [Table]
client.ResaleLicense = GetReaderValue_String(reader, "ResaleLicense", ""); //From: [Table]
client.CompanyRegistration = GetReaderValue_String(reader, "CompanyRegistration", ""); //From: [Table]
client.DocumentFontName = GetReaderValue_String(reader, "DocumentFontName", ""); //From: [Table]
client.DocumentFontSize = GetReaderValue_NullableInt32(reader, "DocumentFontSize", null); //From: [Table]
client.Inactive = GetReaderValue_Boolean(reader, "Inactive", false); //From: [Table]
client.UpdatedBy = GetReaderValue_NullableInt32(reader, "UpdatedBy", null); //From: [Table]
client.DLUP = GetReaderValue_DateTime(reader, "DLUP", DateTime.MinValue); //From: [Table]
client.Login = GetReaderValue_String(reader, "Login", ""); //From: [Table]
client.DefaultSiteLanguageNo = GetReaderValue_Int32(reader, "DefaultSiteLanguageNo", 0); //From: [Table]
client.HasDocumentHeaderImage = GetReaderValue_Boolean(reader, "HasDocumentHeaderImage", false); //From: [Table]
client.Header = GetReaderValue_String(reader, "Header", ""); //From: [Table]
client.OwnDataVisibleToOthers = GetReaderValue_NullableBoolean(reader, "OwnDataVisibleToOthers", null); //From: [Table]
client.CurrencyCode = GetReaderValue_String(reader, "CurrencyCode", ""); //From: [usp_select_Client]
client.CurrencyDescription = GetReaderValue_String(reader, "CurrencyDescription", ""); //From: [usp_select_Client]
client.NumberOfUsers = GetReaderValue_NullableInt32(reader, "NumberOfUsers", null); //From: [usp_select_Client]
client.OpenShippingCost = GetReaderValue_Double(reader, "OpenShippingCost", 0); //From: [usp_select_Client_LastMonth_GP]
client.OpenFreightCharge = GetReaderValue_Double(reader, "OpenFreightCharge", 0); //From: [usp_select_Client_LastMonth_GP]
client.OpenLandedCost = GetReaderValue_Double(reader, "OpenLandedCost", 0); //From: [usp_select_Client_LastMonth_GP]
client.OpenSalesValue = GetReaderValue_Double(reader, "OpenSalesValue", 0); //From: [usp_select_Client_LastMonth_GP]
client.ShippedShippingCost = GetReaderValue_Double(reader, "ShippedShippingCost", 0); //From: [usp_select_Client_LastMonth_GP]
client.ShippedFreightCharge = GetReaderValue_Double(reader, "ShippedFreightCharge", 0); //From: [usp_select_Client_LastMonth_GP]
client.ShippedLandedCost = GetReaderValue_Double(reader, "ShippedLandedCost", 0); //From: [usp_select_Client_LastMonth_GP]
client.ShippedSalesValue = GetReaderValue_Double(reader, "ShippedSalesValue", 0); //From: [usp_select_Client_LastMonth_GP]
}
return(client);
}
/// <summary>
/// GetThisYearGP
/// Calls [usp_select_Client_ThisYear_GP]
/// </summary>
public static Client GetThisYearGP(System.Int32?clientId)
{
Rebound.GlobalTrader.DAL.ClientDetails objDetails = Rebound.GlobalTrader.DAL.SiteProvider.Client.GetThisYearGP(clientId);
if (objDetails == null)
{
return(null);
}
else
{
Client obj = new Client();
obj.OpenShippingCost = objDetails.OpenShippingCost;
obj.OpenFreightCharge = objDetails.OpenFreightCharge;
obj.OpenLandedCost = objDetails.OpenLandedCost;
obj.OpenSalesValue = objDetails.OpenSalesValue;
obj.ShippedShippingCost = objDetails.ShippedShippingCost;
obj.ShippedFreightCharge = objDetails.ShippedFreightCharge;
obj.ShippedLandedCost = objDetails.ShippedLandedCost;
obj.ShippedSalesValue = objDetails.ShippedSalesValue;
objDetails = null;
return(obj);
}
}
/// <summary>
/// Get
/// Calls [usp_select_Client]
/// </summary>
public static Client Get(System.Int32?clientId)
{
Rebound.GlobalTrader.DAL.ClientDetails objDetails = Rebound.GlobalTrader.DAL.SiteProvider.Client.Get(clientId);
if (objDetails == null)
{
return(null);
}
else
{
Client obj = new Client();
obj.ClientId = objDetails.ClientId;
obj.ClientName = objDetails.ClientName;
obj.ParentClientNo = objDetails.ParentClientNo;
obj.CurrencyNo = objDetails.CurrencyNo;
obj.Telephone = objDetails.Telephone;
obj.Fax = objDetails.Fax;
obj.EMail = objDetails.EMail;
obj.URL = objDetails.URL;
obj.ResaleLicense = objDetails.ResaleLicense;
obj.CompanyRegistration = objDetails.CompanyRegistration;
obj.DocumentFontName = objDetails.DocumentFontName;
obj.DocumentFontSize = objDetails.DocumentFontSize;
obj.Inactive = objDetails.Inactive;
obj.UpdatedBy = objDetails.UpdatedBy;
obj.DLUP = objDetails.DLUP;
obj.Login = objDetails.Login;
obj.DefaultSiteLanguageNo = objDetails.DefaultSiteLanguageNo;
obj.HasDocumentHeaderImage = objDetails.HasDocumentHeaderImage;
obj.Header = objDetails.Header;
obj.OwnDataVisibleToOthers = objDetails.OwnDataVisibleToOthers;
obj.CurrencyCode = objDetails.CurrencyCode;
obj.CurrencyDescription = objDetails.CurrencyDescription;
obj.NumberOfUsers = objDetails.NumberOfUsers;
objDetails = null;
return(obj);
}
}
