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