public List <BidQuestion> getBidQuestionForBidder(int userId)
{
List <BidQuestion> bidQuestions = new List <BidQuestion>();
int questionCount = 0;
using (SqlConnection connection = new SqlConnection(connectionString))
{
SqlDataReader reader;
try
{
connection.Open();
SqlCommand command = new SqlCommand("USP_GetBidQuestionsForBidder", connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add(new SqlParameter("@UserId", userId));
// command.Parameters.Add(new SqlParameter("@matchID", matchID));
reader = command.ExecuteReader();
while (reader.Read())
{
questionCount++;
BidQuestion schedule = new BidQuestion();
schedule.bidId = Convert.ToInt32(reader["bidId"]);
schedule.Team = reader["Team"].ToString();
schedule.TeamA = reader["TeamA"].ToString();
schedule.TeamB = reader["TeamB"].ToString();
schedule.InFavour = reader["InFavour"].ToString();
schedule.Against = reader["Against"].ToString();
schedule.bidPoints = reader["bidPoints"].ToString();
if (schedule.Team == "A")
{
schedule.bidQuestion = "Q" + questionCount + ". " + schedule.TeamA + " : " + reader["Question"].ToString() + "?";
}
if (schedule.Team == "B")
{
schedule.bidQuestion = "Q" + questionCount + ". " + schedule.TeamB + " : " + reader["Question"].ToString() + "?";
}
schedule.MasterId = Convert.ToInt32(reader["Id"]);
schedule.AlreadySubmitted = Convert.ToBoolean(reader["AlreadySubmitted"]);
schedule.IsBidActive = Convert.ToBoolean(reader["IsBidActive"]);
bidQuestions.Add(schedule);
}
}
catch (Exception ex)
{
}
return(bidQuestions);
}
}
public List <BidQuestion> getActiveBidQuestion(int matchId)
{
List <BidQuestion> bidQuestions = new List <BidQuestion>();
using (SqlConnection connection = new SqlConnection(connectionString))
{
SqlDataReader reader;
try
{
connection.Open();
SqlCommand command = new SqlCommand("USP_GetActiveBidQuestionsByMatch", connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add(new SqlParameter("@MatchId", matchId));
reader = command.ExecuteReader();
while (reader.Read())
{
BidQuestion schedule = new BidQuestion();
schedule.bidQuestion = reader["Question"].ToString();
schedule.bidId = Convert.ToInt32(reader["bidId"]);
schedule.Team = reader["Team"].ToString();
if (reader["IsBidActive"] == DBNull.Value)
{
schedule.IsBidActive = null;
}
else
{
schedule.IsBidActive = Convert.ToBoolean(reader["IsBidActive"]);
}
if (reader["BidResult"] == DBNull.Value)
{
schedule.IsBidResult = null;
}
else
{
schedule.IsBidResult = Convert.ToBoolean(reader["BidResult"]);
}
bidQuestions.Add(schedule);
}
}
catch (Exception ex)
{
}
return(bidQuestions);
}
}
