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