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