public static IndividualOrderCollection GetIndividualOrderByCurrentUserSessionGuid(Guid userGuid)
{
DBIndividualOrderCollection dbCollection = DBProviderManager <DBIndividualOrderProvider> .Provider.IndividualOrderGetByCustomerSessionGUID(userGuid);
IndividualOrderCollection indivCollection = DBMapping(dbCollection);
return(indivCollection);
}
private static IndividualOrderCollection DBMapping(DBIndividualOrderCollection dbCollection)
{
if (dbCollection == null)
{
return(null);
}
IndividualOrderCollection collection = new IndividualOrderCollection();
foreach (DBIndividualOrder dbItem in dbCollection)
{
IndividualOrder item = DBMapping(dbItem);
collection.Add(item);
}
return(collection);
}
public override DBIndividualOrderCollection IndividualOrderGetByCustomerSessionGUID(Guid userGuid)
{
DBIndividualOrderCollection indivOrders = new DBIndividualOrderCollection();
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("IndividualOrderGetByCustomerSessionGUID");
db.AddInParameter(dbCommand, "CustomerSessionGUID", DbType.Guid, userGuid);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
while (dataReader.Read())
{
DBIndividualOrder indivOrder = GetIndividualOrderFromReader(dataReader);
indivOrders.Add(indivOrder);
}
}
return indivOrders;
}
public override DBIndividualOrderCollection IndividualOrderGetByCustomerSessionGUID(Guid userGuid)
{
DBIndividualOrderCollection indivOrders = new DBIndividualOrderCollection();
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("IndividualOrderGetByCustomerSessionGUID");
db.AddInParameter(dbCommand, "CustomerSessionGUID", DbType.Guid, userGuid);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
while (dataReader.Read())
{
DBIndividualOrder indivOrder = GetIndividualOrderFromReader(dataReader);
indivOrders.Add(indivOrder);
}
}
return(indivOrders);
}
