public void updateBadgeTransaction(int Id, string receiver, string badge, string comment)
{
using (var conn = new SqlConnection(connectionString))
{
var badgeReceiver = new UserDAO()[receiver].User_Id;
var sentbadge = new BadgeDAO()[badge].Badge_Id;
string sql = @"update BadgeTransaction set Reciever = @badgeReceiver, Badge_Id = @sentbadge, Badge_Comment = @comment where bt_id = @Id";
conn.Query(sql, new { badgeReceiver = badgeReceiver, sentbadge = sentbadge, comment = comment, Id = Id });
}
}
// this funciton gets an badge transaciton when given an id
public BadgeTransaction getBTGivenId(int Id)
{
using (var conn = new SqlConnection(connectionString))
{
string sql = @"select * from BadgeTransaction where bt_id = @BT_Id";
var bt = conn.Query <BadgeTransaction>(sql, new { BT_Id = Id }).FirstOrDefault();
var sender = new UserDAO().findPersonGivenId(bt.Sender);
var receiver = new UserDAO().findPersonGivenId(bt.Reciever);
var badge = new BadgeDAO().findBadgeGivenId(bt.Badge_Id);
bt.Sender_Object = sender;
bt.Receiver_Object = receiver;
bt.Badge = badge;
return(bt);
}
}
public List <BadgeTransaction> getAllBadgeTransactions()
{
using (var conn = new SqlConnection(connectionString))
{
string sql = @"select * from BadgeTransaction";
var result = conn.Query <BadgeTransaction>(sql).AsList();
foreach (var bt in result)
{
UserDAO userdao = new UserDAO();
BadgeDAO badgedao = new BadgeDAO();
bt.Sender_Object = userdao.findPersonGivenId(bt.Sender);
bt.Receiver_Object = userdao.findPersonGivenId(bt.Reciever);
bt.Badge = badgedao.findBadgeGivenId(bt.Badge_Id);
}
return(result);
}
}