public static int CreateCourse(string courseName)
{
int id = -1;
try
{
DataAccess DAL = new DataAccess();
DataTable dt = DAL.select(String.Format("CourseName = '{0}'", courseName), "CourseInfo", NumRows : 1);
if (dt == null || dt.Rows.Count == 0)
{
Dictionary<string, object> courseInfo = new Dictionary<string, object>();
courseInfo.Add("CourseName", courseName);
courseInfo.Add("Description", courseName);
courseInfo.Add("IsActive", 1);
courseInfo.Add("IsDeleted", 0);
courseInfo.Add("CreatedDate", DateTime.Now);
courseInfo.Add("ModifiedDate", DateTime.Now);
id = DAL.insert(courseInfo, "CourseInfo");
}
}
catch (Exception ex)
{
Console.Write("ERROR: An error occured in adding a new course --- " + ex.Message);
}
return id;
}
public static int createComment(Comment comment)
{
int id = -1;
try
{
DataAccess da = new DataAccess();
Dictionary<string, object> TransactionComment = new Dictionary<string, object>();
TransactionComment.Add("UserId", comment.UserId);
TransactionComment.Add("ActionBy", (int)comment.ActionBy);
TransactionComment.Add("TransactionId ", comment.TransactionId);
TransactionComment.Add("Comment", comment.comment);
TransactionComment.Add("ReminderSent", 0);
TransactionComment.Add("IsActive", 1);
TransactionComment.Add("IsDeleted", 0);
TransactionComment.Add("CreatedDate", DateTime.Now);
TransactionComment.Add("ModifiedDate", DateTime.Now);
id = da.insert(TransactionComment, "TransactionComments");
}
catch (Exception ex)
{
Console.Write(ex.Message + " " + ex.StackTrace);
}
return id;
}
public static int createTextBook(Textbook book)
{
int BookId = -1;
try
{
DataAccess da = new DataAccess();
DataTable dt = da.select(String.Format("ISBN = '{0}'", book.ISBN), "TextBooks", NumRows : 1);
if (dt == null || dt.Rows.Count == 0)
{
Dictionary<string, object> textbook = new Dictionary<string, object>();
textbook.Add("ISBN", book.ISBN);
textbook.Add("BookTitle", book.BookTitle);
textbook.Add("Author", book.Author);
textbook.Add("CourseId", book.CourseId);
textbook.Add("BookImageURL", book.BookImageUrl);
textbook.Add("StorePrice", book.StorePrice);
textbook.Add("IsActive", 1);
textbook.Add("IsDeleted", 0);
textbook.Add("CreatedDate", DateTime.Now);
textbook.Add("ModifiedDate", DateTime.Now);
BookId = da.insert(textbook, "TextBooks");
}
}
catch (Exception ex) { Console.Write(ex.Message + " " + ex.StackTrace); }
return BookId;
}
public static int CreateProfile(string Name, string Email)
{
int id = -1;
try
{
DataAccess DAL = new DataAccess();
DataTable dt = DAL.select(String.Format("UserName = '******'", Email), "UserProfile", NumRows : 1);
if (dt == null || dt.Rows.Count == 0)
{
Dictionary<string, object> profile = new Dictionary<string, object>();
profile.Add("Name", Name);
profile.Add("Email", Email);
profile.Add("IsActive", 1);
profile.Add("IsDeleted", 0);
profile.Add("CreatedDate", DateTime.Now);
profile.Add("ModifiedDate", DateTime.Now);
id = DAL.insert(profile, "UserProfile");
}
}
catch (Exception ex)
{
Console.Write("ERROR: An error occured in adding a new course --- " + ex.Message);
}
return id;
}
public static int createPost(Post newPost)
{
int id = -1;
try
{
DataAccess da = new DataAccess();
Dictionary<string, object> post = new Dictionary<string, object>();
post.Add("UserId", newPost.UserId);
post.Add("TextBookId", newPost.TextBookId);
post.Add("ActionBy ", (int) newPost.ActionBy); // enum must be casted to int before we can store it in db
post.Add("Price", newPost.Price);
post.Add("BookCondition", (int) newPost.BookCondition); // enum must be casted to int before we can store it in db
post.Add("IsTransacting", newPost.IsTransacting);
post.Add("IsActive", 1);
post.Add("IsDeleted", 0);
post.Add("CreatedDate", DateTime.Now);
post.Add("ModifiedDate", DateTime.Now);
id = da.insert(post, "Posts");
}
catch (Exception ex)
{
Console.Write(ex.Message + " " + ex.StackTrace);
}
return id;
}
private static int CreateForbiddenMatch(int PostId, int MatchedPostId)
{
DataAccess da = new DataAccess();
Dictionary<string, object> CancelledTransaction = new Dictionary<string, object>();
CancelledTransaction.Add("PostId", PostId);
CancelledTransaction.Add("MatchedPostId", MatchedPostId);
return da.insert(CancelledTransaction, "CancelledTransactions");
}
public static int CreateTransactionHistory(int transactionId, int userId)
{
int transactionHistoryId = -1;
try
{
DataAccess da = new DataAccess();
Dictionary<string, object> transactionHistory = new Dictionary<string, object>();
transactionHistory.Add("TransactionId", transactionId);
transactionHistory.Add("UserId", userId);
transactionHistoryId = da.insert(transactionHistory, "TransactionHistory");
}
catch (Exception ex)
{
Console.Write("ERROR: An error occured in adding a new transaction --- " + ex.Message + " " + ex.StackTrace);
}
return transactionHistoryId;
}
public static int CreateTransaction(Transaction transaction)
{
int transactionId = -1;
try
{
DataAccess da = new DataAccess();
Dictionary<string, object> Transaction = new Dictionary<string, object>();
Transaction.Add("TextbookId", transaction.TextbookId);
Transaction.Add("SellerId", transaction.SellerId);
Transaction.Add("BuyerId", transaction.BuyerId);
Transaction.Add("SellerPostId", transaction.SellerPostId);
Transaction.Add("BuyerPostId", transaction.BuyerPostId);
Transaction.Add("FinalPrice", transaction.FinalPrice == null ? (object)DBNull.Value : transaction.FinalPrice);
Transaction.Add("InitialPrice", transaction.InitialPrice);
Transaction.Add("Confirmed", transaction.Confirmed);
Transaction.Add("IsActive", transaction.IsActive);
Transaction.Add("IsDeleted", transaction.IsDeleted);
Transaction.Add("CreatedDate", transaction.CreatedDate);
Transaction.Add("ModifiedDate", transaction.ModifiedDate);
transactionId = da.insert(Transaction, "Transactions");
Dictionary<string, object> TransactionSeller = new Dictionary<string, object>();
TransactionSeller.Add("TransactionId", transactionId);
TransactionSeller.Add("UserId", transaction.SellerId);
Dictionary<string, object> TransactionBuyer = new Dictionary<string, object>();
TransactionBuyer.Add("TransactionId", transactionId);
TransactionBuyer.Add("UserId", transaction.BuyerId);
da.insert(TransactionBuyer, "TransactionHistory");
da.insert(TransactionSeller, "TransactionHistory");
}
catch (Exception ex)
{
Console.Write("ERROR: An error occured in adding a new transaction --- " + ex.Message + " " + ex.StackTrace);
}
return transactionId;
}
