public List <PurchaseDetails> RetrievePurchaseDetailsByUser(int id)
{
var purchaseList = new List <PurchaseDetails>();
try
{
var purchases = MarketEntryAccessor.RetrievePurchasesByUser(id);
foreach (Purchase e in purchases)
{
var marketEntry = MarketEntryAccessor.RetrieveMarketEntryById(e.MarketEntryID);
var marketEntryDetail = new MarketEntryDetails()
{
MarketEntry = marketEntry,
User = UserAccessor.RetrieveUserByMarketEntryID(marketEntry.MarketEntryID),
CollectionEntry = CollectionAccessor.RetrieveCollectionEntryByID(marketEntry.CollectionEntryID)
};
var purhcase = new PurchaseDetails()
{
MarketEntryDetails = marketEntryDetail,
User = UserAccessor.RetrieveUserById(e.UserID)
};
purchaseList.Add(purhcase);
}
}
catch (Exception)
{
throw;
}
return(purchaseList);
}
public frmPurchase(User user, MarketEntryDetails marketEntryDetails)
{
_user = user;
_marketEntryDetails = marketEntryDetails;
InitializeComponent();
setControls();
}
public List <MarketEntryDetails> RetrieveMarketEntryDetailsByUser(int id)
{
var detailList = new List <MarketEntryDetails>();
try
{
var entries = MarketEntryAccessor.RetrieveMarketEntriesByUser(id);
foreach (MarketEntry e in entries)
{
var detail = new MarketEntryDetails()
{
MarketEntry = e,
User = UserAccessor.RetrieveUserByMarketEntryID(e.MarketEntryID),
CollectionEntry = CollectionAccessor.RetrieveCollectionEntryByID(e.CollectionEntryID)
};
detailList.Add(detail);
}
}
catch (Exception)
{
throw;
}
return(detailList);
}
public frmAddEditMarketEntry(ResourceManager resMgr, MarketEntryManager mEMgr, MarketEntryDetails mEDets, MarketEntryForm type)
{
this._resourceManager = resMgr;
this._marketEntryManager = mEMgr;
this._marketEntryDetail = mEDets;
this._type = type;
InitializeComponent();
}
public frmMessaging(MarketEntryDetails details, User user, User purchaser)
{
_marketEntryDetails = details;
_user = user;
_purchaser = purchaser;
InitializeComponent();
populateControls();
}
public MarketEntryDetails RetreiveMarketEntryDetailByID(int id)
{
MarketEntryDetails details = null;
try
{
details = MarketEntryAccessor.RetreiveMarketEntryDetailByID(id);
}
catch (Exception)
{
throw;
}
return(details);
}
public static List <MarketEntryDetails> RetreiveMarketEntryDetailsByAvailable()
{ //sp_select_market_entry_details_by_available
List <MarketEntryDetails> details = new List <MarketEntryDetails>();
//connect
var conn = DBConnection.GetDBConnection();
// command text
var cmdText = @"sp_select_market_entry_details_by_available";
//command
var cmd = new SqlCommand(cmdText, conn);
cmd.CommandType = CommandType.StoredProcedure;
try
{
//open the connection
conn.Open();
//execute the command
var reader = cmd.ExecuteReader();
// check for return rows
if (reader.HasRows)
{
while (reader.Read())
{
var detail = new MarketEntryDetails()
{
MarketEntry = new MarketEntry
{
MarketEntryID = reader.GetInt32(0),
CollectionEntryID = reader.GetInt32(1),
ResourceID = reader.GetString(15),
ResourceAmount = reader.GetInt32(16),
MarketEntryStatusID = reader.GetString(17)
},
CollectionEntry = new CollectionEntry
{
CreatureID = reader.GetString(2),
Name = reader.GetString(3),
Level = reader.GetInt32(4),
Health = reader.GetInt32(5),
Stamina = reader.GetInt32(6),
Oxygen = reader.GetInt32(7),
Food = reader.GetInt32(8),
Weight = reader.GetInt32(9),
BaseDamage = reader.GetInt32(10),
MovementSpeed = reader.GetInt32(11),
Torpor = reader.GetInt32(12),
Imprint = reader.GetInt32(13),
Active = reader.GetBoolean(14)
},
User = new User
{
Gamertag = reader.GetString(18),
UserID = reader.GetInt32(19)
}
};
details.Add(detail);
}
}
}
catch (Exception)
{
throw;
}
finally
{
conn.Close();
}
return(details);
}
public static MarketEntryDetails RetreiveMarketEntryDetailByID(int id)
{
MarketEntryDetails detail = null;
//connect
var conn = DBConnection.GetDBConnection();
// command text
var cmdText = @"sp_select_market_entry_details_by_id";
//command
var cmd = new SqlCommand(cmdText, conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@MarketEntryID", id);
try
{
//open the connection
conn.Open();
//execute the command
var reader = cmd.ExecuteReader();
reader.Read();
detail = new MarketEntryDetails()
{
MarketEntry = new MarketEntry
{
MarketEntryID = reader.GetInt32(0),
CollectionEntryID = reader.GetInt32(1),
ResourceID = reader.GetString(15),
ResourceAmount = reader.GetInt32(16),
MarketEntryStatusID = reader.GetString(17)
},
CollectionEntry = new CollectionEntry
{
CreatureID = reader.GetString(2),
Name = reader.GetString(3),
Level = reader.GetInt32(4),
Health = reader.GetInt32(5),
Stamina = reader.GetInt32(6),
Oxygen = reader.GetInt32(7),
Food = reader.GetInt32(8),
Weight = reader.GetInt32(9),
BaseDamage = reader.GetInt32(10),
MovementSpeed = reader.GetInt32(11),
Torpor = reader.GetInt32(12),
Imprint = reader.GetInt32(13),
Active = reader.GetBoolean(14)
}
}; //[MarketEntry].[MarketEntryID], [MarketEntry].[CollectionEntryID], [CollectonEntry].[CreatureID],
//[CollectonEntry].[Name], [CollectonEntry].[Level], [CollectonEntry].[Health], [CollectonEntry].[Stamina],
//[CollectonEntry].[Oxygen], [CollectonEntry].[Food], [CollectonEntry].[Weight], [CollectonEntry].[BaseDamage],
//[CollectonEntry].[MovementSpeed], [CollectonEntry].[Torpor], [CollectonEntry].[Imprint], [CollectonEntry].[Active]
}
catch (Exception)
{
throw;
}
finally
{
conn.Close();
}
return(detail);
}
public static List <MarketEntryDetails> RetreiveMarketEntryPurchaseDetailsByUserID(int id)
{
List <MarketEntryDetails> details = new List <MarketEntryDetails>();
//connect
var conn = DBConnection.GetDBConnection();
// command text
var cmdText = @"sp_select_market_entry_purchases_by_user_2";
//command
var cmd = new SqlCommand(cmdText, conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@UserID", id);
try
{
//open the connection
conn.Open();
//execute the command
var reader = cmd.ExecuteReader();
// check for return rows
if (reader.HasRows)
{
while (reader.Read())
{
var detail = new MarketEntryDetails()
{
CollectionEntry = new CollectionEntry
{
CreatureID = reader.GetString(0),
Level = reader.GetInt32(1),
Name = reader.GetString(2)
},
User = new User
{
Gamertag = reader.GetString(3)
},
MarketEntry = new MarketEntry
{
MarketEntryID = reader.GetInt32(4),
ResourceID = reader.GetString(5),
ResourceAmount = reader.GetInt32(6)
}
};
details.Add(detail);
}
}
}
catch (Exception)
{
throw;
}
finally
{
conn.Close();
}
return(details);
}
