/// <summary>
/// Get Cart Product
/// links:
/// docLink: http://sql2x.org/documentationLink/06760f02-f3ec-45ad-bbfe-db43d7a0378f
/// </summary>
/// <template>DotNetFrameworkByServiceTableCrud</template>
/// <cardinality>Many</cardinality>
public List <GetCartProductWithFilterData> GetCartProductWithFilter()
{
var ret = new List <GetCartProductWithFilterData>();
string sql = @"
select
[c].first_name
,[c].middle_name
,[c].last_name
,[p].product_name
,[fc].financial_currency_type_name
,[du].default_user_name
,[c].image_blob_filename
,[cp].client_id
,[p].state_rcd as product_state_rcd
,[cp].product_id
,[fc].financial_currency_type_rcd
,[fc].financial_currency_against_financial_currency_type_rcd
,[fc].financial_currency_type_code
,[cp].financial_currency_id
,[cp].amount
,[cp].session_identificator
,[cp].state_rcd as cart_product_state_rcd
,[cp].user_id
,[cp].date_time
,[cp].cart_product_id
,[cp].session_id
,[cp].asp_id
from cart_product as [cp]
left join client as [c] on [c].client_id = [cp].client_id
inner join product as [p] on [p].product_id = [cp].product_id
inner join financial_currency as [fc] on [fc].financial_currency_id = [cp].financial_currency_id
inner join default_user as [du] on [du].default_user_id = [cp].user_id
where 1 = 1
";
using (var conn = new SqlConnection(ConfigurationManager.AppSettings["Conn"])) {
conn.Open();
using (var command = new SqlCommand(sql, conn)) {
command.CommandText = sql;
// Logging log = Logging.PerformanceTimeStart("GetCartProductWithFilter");
IDataReader reader = command.ExecuteReader(CommandBehavior.SingleResult);
// log.PerformanceTimeStop(sql, command);
var ordinals = new GetCartProductWithFilterDataOrdinals(reader);
while (reader.Read())
{
var data = new GetCartProductWithFilterData();
data.Populate(reader, ordinals);
ret.Add(data);
}
reader.Close();
}
return(ret);
}
}
// use ordinals to speed up access to DataReader
// links:
// docLink: http://sql2x.org/documentationLink/327451c3-64a8-4de8-b359-76742d634497
// parameters:
// reader: IDataReader from SQLClient
public void Populate(IDataReader reader, GetCartProductWithFilterDataOrdinals ordinals)
{
if (!reader.IsDBNull(ordinals.FirstName))
{
FirstName = reader.GetString(ordinals.FirstName);
}
if (!reader.IsDBNull(ordinals.MiddleName))
{
MiddleName = reader.GetString(ordinals.MiddleName);
}
if (!reader.IsDBNull(ordinals.LastName))
{
LastName = reader.GetString(ordinals.LastName);
}
if (!reader.IsDBNull(ordinals.ProductName))
{
ProductName = reader.GetString(ordinals.ProductName);
}
if (!reader.IsDBNull(ordinals.FinancialCurrencyTypeName))
{
FinancialCurrencyTypeName = reader.GetString(ordinals.FinancialCurrencyTypeName);
}
if (!reader.IsDBNull(ordinals.DefaultUserName))
{
DefaultUserName = reader.GetString(ordinals.DefaultUserName);
}
if (!reader.IsDBNull(ordinals.ImageBlobFilename))
{
ImageBlobFilename = reader.GetString(ordinals.ImageBlobFilename);
}
if (!reader.IsDBNull(ordinals.ClientId))
{
ClientId = reader.GetGuid(ordinals.ClientId);
}
if (!reader.IsDBNull(ordinals.ProductStateRcd))
{
ProductStateRcd = reader.GetString(ordinals.ProductStateRcd);
}
if (!reader.IsDBNull(ordinals.ProductId))
{
ProductId = reader.GetGuid(ordinals.ProductId);
}
if (!reader.IsDBNull(ordinals.FinancialCurrencyTypeRcd))
{
FinancialCurrencyTypeRcd = reader.GetString(ordinals.FinancialCurrencyTypeRcd);
}
if (!reader.IsDBNull(ordinals.FinancialCurrencyAgainstFinancialCurrencyTypeRcd))
{
FinancialCurrencyAgainstFinancialCurrencyTypeRcd = reader.GetString(ordinals.FinancialCurrencyAgainstFinancialCurrencyTypeRcd);
}
if (!reader.IsDBNull(ordinals.FinancialCurrencyTypeCode))
{
FinancialCurrencyTypeCode = reader.GetString(ordinals.FinancialCurrencyTypeCode);
}
if (!reader.IsDBNull(ordinals.FinancialCurrencyId))
{
FinancialCurrencyId = reader.GetGuid(ordinals.FinancialCurrencyId);
}
if (!reader.IsDBNull(ordinals.Amount))
{
Amount = reader.GetDecimal(ordinals.Amount);
}
if (!reader.IsDBNull(ordinals.SessionIdentificator))
{
SessionIdentificator = reader.GetString(ordinals.SessionIdentificator);
}
if (!reader.IsDBNull(ordinals.CartProductStateRcd))
{
CartProductStateRcd = reader.GetString(ordinals.CartProductStateRcd);
}
if (!reader.IsDBNull(ordinals.UserId))
{
UserId = reader.GetGuid(ordinals.UserId);
}
if (!reader.IsDBNull(ordinals.DateTime))
{
DateTime = reader.GetDateTime(ordinals.DateTime);
}
if (!reader.IsDBNull(ordinals.CartProductId))
{
CartProductId = reader.GetGuid(ordinals.CartProductId);
}
if (!reader.IsDBNull(ordinals.SessionId))
{
SessionId = reader.GetGuid(ordinals.SessionId);
}
if (!reader.IsDBNull(ordinals.AspId))
{
AspId = reader.GetGuid(ordinals.AspId);
}
}
