protected void filter_ServerClick(object sender, EventArgs e)
{
DateTime startdate = Convert.ToDateTime(TextBox1.Text);
DateTime enddate = Convert.ToDateTime(TextBox2.Text);
Jobhistory dates = new Jobhistory();
dates = dates.selectbydate(startdate, enddate);
string names = dates.TOURNAME;
}
public Jobhistory RetrieveBookingdetailsbyDate(DateTime startdate, DateTime enddate)
{
string DBConnect = ConfigurationManager.ConnectionStrings["ConnStr"].ConnectionString;
SqlConnection myConn = new SqlConnection(DBConnect);
//Step 2 - Create a DataAdapter to retrieve data from the database table
string sqlStmt = "Select * from BookingHistory where TourDate BETWEEN @parastart AND @paraend";
SqlDataAdapter da = new SqlDataAdapter(sqlStmt, myConn);
da.SelectCommand.Parameters.AddWithValue("@parastart", startdate);
da.SelectCommand.Parameters.AddWithValue("@paraend", enddate);
//Step 3 - Create a DataSet to store the data to be retrieved
DataSet ds = new DataSet();
//Step 4 - Use the DataAdapter to fill the DataSet with data retrieved
da.Fill(ds);
//Step 5 - Read data from DataSet to List
Jobhistory T = null;
int rec_cnt = ds.Tables[0].Rows.Count;
if (rec_cnt == 1)
{
DataRow row = ds.Tables[0].Rows[0];
string Tourname = row["TourName"].ToString();
DateTime Tourdate = Convert.ToDateTime(row["TourDate"]);
DateTime Starttime = Convert.ToDateTime(row["StartTime"]);
DateTime Endtime = Convert.ToDateTime(row["EndTime"]);
string Custname = row["CustName"].ToString();
T = new Jobhistory(Tourname, Tourdate, Starttime, Endtime, Custname);
}
else
{
T = null;
}
return(T);
}
