public List <SlayerTask> GetAllSlayerTasks()
{
List <SlayerTask> slayerTasks = new List <SlayerTask>();
SqlDataReader reader = null;
using (SqlConnection _conn = new SqlConnection(connectionString))
{
_conn.Open();
SqlCommand cmd = new SqlCommand("GetAllSlayerTasks", _conn);
cmd.CommandType = CommandType.StoredProcedure;
reader = cmd.ExecuteReader();
while (reader.Read())
{
int id = Convert.ToInt32(reader["SlayerTaskID"]);
int characterID = Convert.ToInt32(reader["CharacterID"]);
int monsterID = Convert.ToInt32(reader["MonsterID"]);
int amount = Convert.ToInt32(reader["Amount"]);
SlayerTask slayerTask = new SlayerTask(id, characterID, monsterID, amount);
slayerTasks.Add(slayerTask);
}
}
return(slayerTasks);
}
public void setSlayerTask(SlayerTask task)
{
this.slayerTask = task;
}
