public static IEnumerable<MarketPost> getAllMarketPosts(bool isBuyPost)
{
List<MarketPost> allMarketPosts = new List<MarketPost>();
try
{
DataAccessLayer DAL = new DataAccessLayer();
DataTable dt = DAL.select(String.Format("IsBuy = '{0}'", isBuyPost), "Posts");
foreach (DataRow row in dt.Rows)
{
int textBookID = Convert.ToInt32(row["TextBookID"]);
int profileID = Convert.ToInt32(row["ProfileID"]);
int price = Convert.ToInt32(row["Price"]);
int postID = Convert.ToInt32(row["PostID"]);
bool viaEmail = Convert.ToBoolean(row["viaEmail"]);
bool isNegotiable = Convert.ToBoolean(row["IsNegotiable"]);
bool isBuy = Convert.ToBoolean(row["IsBuy"]);
string condition = Convert.ToString(row["BookCondition"]);
DateTime datePosted = Convert.ToDateTime(row["CreatedDate"]);
UserProfile UserProfile = AccountHandler.getUserProfile(profileID);
string postedBy = UserProfile.Name;
string email = UserProfile.Email;
Textbook textbook = TextbookHandler.getTextbook(textBookID);
string title = textbook.Title;
string course = textbook.CourseName;
string isbn = textbook.ISBN;
string author = textbook.Author;
string bookImageURL = textbook.BookImageURL;
List<Bid> bids = BidHandler.getBids(postID);
MarketPost marketPost = new MarketPost(
title, isBuy, course,
condition, postedBy, datePosted,
isbn, author, bookImageURL,
price, bids, isNegotiable, email,
viaEmail, profileID, postID);
allMarketPosts.Add(marketPost);
}
}
catch (Exception ex)
{
Console.Write("ERROR: An error occured in retrieving all market posts --- " + ex.Message);
}
return allMarketPosts;
}
public static MarketPost getMarketPost(int postID)
{
MarketPost marketPost = null;
try
{
DataAccessLayer DAL = new DataAccessLayer();
DataTable dt = DAL.select(String.Format("PostID = '{0}'", postID), "Posts");
if (dt != null && dt.Rows.Count > 0)
{
DataRow row = dt.Rows[0];
int profileID = Convert.ToInt32(row["ProfileID"]);
UserProfile UserProfile = AccountHandler.getUserProfile(profileID);
string postedBy = UserProfile.Name;
string email = UserProfile.Email;
int textbookID = Convert.ToInt32(row["TextBookID"]);
Textbook textbook = TextbookHandler.getTextbook(textbookID);
string isbn = textbook.ISBN;
string title = textbook.Title;
string author = textbook.Author;
string course = textbook.CourseName;
string bookImageURL = textbook.BookImageURL;
bool isBuy = Convert.ToBoolean(row["IsBuy"]);
bool isNegotiable = Convert.ToBoolean(row["IsNegotiable"]);
string condition = Convert.ToString(row["BookCondition"]);
int price = Convert.ToInt32(row["Price"]);
DateTime datePosted = Convert.ToDateTime(row["CreatedDate"]);
List<Bid> bids = BidHandler.getBids(postID);
bool viaEmail = Convert.ToBoolean(row["viaEmail"]);
marketPost = new MarketPost(
title, isBuy, course,
condition, postedBy, datePosted,
isbn, author, bookImageURL,
price, bids, isNegotiable, email,
viaEmail, profileID, postID);
}
}
catch (Exception ex)
{
Console.Write("ERROR: An error occured in retrieving the market post --- " + ex.Message);
}
return marketPost;
}