public List <itineraryDetails> getTravelDetails(string Id)
{
List <itineraryDetails> tdList = new List <itineraryDetails>();
SqlDataAdapter da;
DataSet ds = new DataSet();
//Create Adapter
//WRITE SQL Statement to retrieve all columns from Customer by customer Id using query parameter
StringBuilder sqlCommand = new StringBuilder();
sqlCommand.AppendLine("Select * from travelDetails where");
sqlCommand.AppendLine("userId = @paraUserId");
SqlConnection myConn = new SqlConnection(DBConnect);
da = new SqlDataAdapter(sqlCommand.ToString(), myConn);
da.SelectCommand.Parameters.AddWithValue("paraUserId", Id);
// fill dataset
da.Fill(ds, "travelDetailsTable");
int rec_cnt = ds.Tables["travelDetailsTable"].Rows.Count;
if (rec_cnt > 0)
{
foreach (DataRow row in ds.Tables["travelDetailsTable"].Rows)
{
itineraryDetails myTD = new itineraryDetails();
myTD.travelDetailsId = row["Id"].ToString();
myTD.tripNameClass = row["tripName"].ToString();
myTD.startDateClass = DateTime.Parse(row["startDate"].ToString());
myTD.endDateClass = DateTime.Parse(row["endDate"].ToString());
myTD.expectedExpensesClass = double.Parse(row["expectedExpense"].ToString());
myTD.countryClass = row["country"].ToString();
myTD.stateClass = row["state"].ToString();
myTD.userIdClass = row["userId"].ToString();
myTD.currentTimeClass = row["dateEntered"].ToString();
tdList.Add(myTD);
}
}
else
{
tdList = null;
}
return(tdList);
}
protected void Page_Load(object sender, EventArgs e)
{
int travelDetailsId = int.Parse(Session["travelDetailsId"].ToString());
itineraryDetailsDAO itineraryDetailsDao = new itineraryDetailsDAO();
itineraryDetails itiObj = new itineraryDetails();
itiObj = itineraryDetailsDao.getItineraryDetailsData(travelDetailsId);
travellID.Value = travelDetailsId.ToString();
travelId.Value = (itiObj.itineraryHtmlClass).ToString();
if (itiObj != null)
{
System.Diagnostics.Debug.WriteLine("html is = " + itiObj.itineraryHtmlClass + " and travelid is = " + travelDetailsId);
}
else
{
System.Diagnostics.Debug.WriteLine("nth is shown");
}
}
public itineraryDetails getItineraryDetailsData(int travelDetailsId)
{
//Get data to see which user is is
SqlDataAdapter da;
DataSet ds = new DataSet();
//Create Adapter
//WRITE SQL Statement to retrieve all columns from Customer by customer Id using query parameter
StringBuilder sqlCommand = new StringBuilder();
sqlCommand.AppendLine("Select itineraryHtml from itineraryDetails where");
sqlCommand.AppendLine("travelDetailsId = @paraItineraryDetailsId");
itineraryDetails obj = new itineraryDetails();
SqlConnection myConn = new SqlConnection(DBConnect);
da = new SqlDataAdapter(sqlCommand.ToString(), myConn);
da.SelectCommand.Parameters.AddWithValue("paraItineraryDetailsId", travelDetailsId);
da.Fill(ds, "itineraryDetails");
int rec_cnt = ds.Tables["itineraryDetails"].Rows.Count;
if (rec_cnt > 0)
{
DataRow row = ds.Tables["itineraryDetails"].Rows[0];
obj.itineraryHtmlClass = row["itineraryHtml"].ToString();
}
else
{
obj = null;
}
return(obj);
}
