private DBIndividualOrder GetIndividualOrderFromReader(IDataReader dataReader)
{
DBIndividualOrder indivOrder = new DBIndividualOrder();
indivOrder.IndividualOrderID = NopSqlDataHelper.GetInt(dataReader, "IndividualOrderID");
indivOrder.CurrentUserSessionGuid = NopSqlDataHelper.GetGuid(dataReader, "CustomerSessionGUID");
indivOrder.Price = NopSqlDataHelper.GetLong(dataReader, "Price");
indivOrder.SerialNumberInShCart = NopSqlDataHelper.GetInt(dataReader, "SerialNumberInShCart");
indivOrder.OrderText = NopSqlDataHelper.GetString(dataReader, "OrderText");
return(indivOrder);
}
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 DBIndividualOrder InsertIndividualOrder(Guid userGuid,
long Price, String OrderText)
{
DBIndividualOrder indivOrder = null;
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("IndividualOrderInsert");
db.AddOutParameter(dbCommand, "IndividualOrderID", DbType.Int32, 0);
db.AddInParameter(dbCommand, "CustomerSessionGUID", DbType.Guid, userGuid);
db.AddInParameter(dbCommand, "Price", DbType.Int64, Price);
db.AddInParameter(dbCommand, "OrderText", DbType.String, OrderText);
if (db.ExecuteNonQuery(dbCommand) > 0)
{
int indivOrderID = Convert.ToInt32(db.GetParameterValue(dbCommand, "@IndividualOrderID"));
indivOrder = GetIndividualOrderByID(indivOrderID);
}
return(indivOrder);
}
public override DBIndividualOrder GetIndividualOrderByID(int individualOrderID)
{
DBIndividualOrder indivOrder = null;
if (individualOrderID == 0)
{
return(indivOrder);
}
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("IndividualOrderLoadByPrimaryKey");
db.AddInParameter(dbCommand, "IndividualOrderID", DbType.Int32, individualOrderID);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
if (dataReader.Read())
{
indivOrder = GetIndividualOrderFromReader(dataReader);
}
}
return(indivOrder);
}
