public List <Schedule> getSchedule(sortPaging sortPage)
{
List <Schedule> iplSchedule = new List <Schedule>();
using (SqlConnection connection = new SqlConnection(connectionString))
{
SqlDataReader reader;
try
{
connection.Open();
SqlCommand command = new SqlCommand("USP_GetSchedule", connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add(new SqlParameter("@PageNo", sortPage.pageNumber));
command.Parameters.Add(new SqlParameter("@PageSize", sortPage.pageSize));
reader = command.ExecuteReader();
while (reader.Read())
{
Schedule schedule = new Schedule();
schedule.TeamA = reader["teamAname"].ToString();
schedule.TeamB = reader["teamBname"].ToString();
schedule.matchDate = reader["matchDate"].ToString();
schedule.Id = Convert.ToInt32(reader["Id"]);
iplSchedule.Add(schedule);
}
}
catch (Exception ex)
{
}
return(iplSchedule);
}
}
public static void getSchedule()
{
IPLSchedule user = new IPLSchedule();
sortPaging sr = new sortPaging();
sr.pageNumber = 1;
sr.pageSize = 100;
user.getSchedule(sr);
user.getBidQuestion(1);
}
public static void getUser()
{
DBUser user = new DBUser();
sortPaging sr = new sortPaging();
sr.pageNumber = 1;
sr.pageSize = 10;
sr.sortColumn = "Firstname";
sr.sortDirection = "asc";
user.getUser(sr);
}
public List <IPLBidder> getUser(sortPaging sortPage)
{
List <IPLBidder> users = new List <IPLBidder>();
using (SqlConnection connection = new SqlConnection(connectionString))
{
SqlDataReader reader;
try
{
connection.Open();
SqlCommand command = new SqlCommand("USP_GetUser", connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add(new SqlParameter("@PageNo", sortPage.pageNumber));
command.Parameters.Add(new SqlParameter("@PageSize", sortPage.pageSize));
command.Parameters.Add(new SqlParameter("@SortColumn", sortPage.sortColumn));
command.Parameters.Add(new SqlParameter("@SortOrder", sortPage.sortDirection));
reader = command.ExecuteReader();
while (reader.Read())
{
IPLBidder bidder = new IPLBidder();
bidder.firstName = reader["firstName"].ToString();
bidder.lastName = reader["lastName"].ToString();
bidder.userName = reader["userName"].ToString();
bidder.mobileNumber = reader["MobileNumber"].ToString();
bidder.email = reader["EmailId"].ToString();
bidder.points = Convert.ToDecimal(reader["Point"].ToString());
bidder.userId = Convert.ToInt32(reader["Id"]);
users.Add(bidder);
}
}
catch (Exception ex)
{
}
return(users);
}
}
